| Author |
Message
|
| sandyvedi |
 Posted: Thu Mar 06, 2014 11:52 am Post subject: Not able to set CCSID in esql |
 |
|
Newbie
Joined: 06 Mar 2014
Posts: 3
|
I am trying to set the CCSID in the esql like below.
DECLARE CCSIDTOUSE INTEGER;
SET CCSIDTOUSE = CAST( InputRoot.Properties.CodedCharSetId AS INTEGER);
DECLARE uSTREAM CHAR CAST(InputRoot.DataObject.*[1].IDocStreamData AS CHAR CCSID CCSIDTOUSE);
DECLARE uBLOBSTREAM BLOB CAST(InputRoot.DataObject.*[1].IDocStreamData AS BLOB CCSID CCSIDTOUSE);
But its not working. I am new to broker please dont mind in-case any basic mistakes.I have taken this piece of code from our repository and tried to modify the same.
Please help |
|
| Back to top |
|
 |
| kimbert |
| Posted: Thu Mar 06, 2014 11:53 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5543
Location: Southampton
|
Please define 'not working'. What is actually happening. What have you tried?
Have you looked at recent posts in this forum ( especially ones that talk about IDocStreamData )?
_________________
Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too. |
|
| Back to top |
|
|
| sandyvedi |
| Posted: Fri Mar 07, 2014 2:06 am Post subject: |
|
|
Newbie
Joined: 06 Mar 2014
Posts: 3
|
Aplogies for not providing complete error details :-
Below is the erro what I am getting -
Idoc Number - NULL
( ['MQROOT' : 0x11802e430]
(0x01000000:Name):RecoverableException = (
(0x03000000:NameValue):File = '/build/S700_P/src/DataFlowEngine/ImbComputeNode.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 489 (INTEGER)
(0x03000000:NameValue):Function = 'ImbComputeNode::evaluate' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmComputeNode' (CHARACTER)
(0x03000000:NameValue):Name = 'SAP2MB_IDOC#FCMComposite_1_6' (CHARACTER)
(0x03000000:NameValue):Label = 'SAP2MB_IDOC.CPT.PROCESS.IDOC' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPmsgs' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2230 (INTEGER)
(0x03000000:NameValue):Text = 'Caught exception and rethrowing' (CHARACTER)
(0x01000000:Name ):RecoverableException = (
(0x03000000:NameValue):File = '/build/S700_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 643 (INTEGER)
(0x03000000:NameValue):Function = 'SqlStatementGroup::execute' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmComputeNode' (CHARACTER)
(0x03000000:NameValue):Name = 'SAP2MB_IDOC#FCMComposite_1_6' (CHARACTER)
(0x03000000:NameValue):Label = 'SAP2MB_IDOC.CPT.PROCESS.IDOC' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPmsgs' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2488 (INTEGER)
(0x03000000:NameValue):Text = 'Error detected, rethrowing' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '.SAP2MB_IDOC_Compute_ProcessIDOC.Main' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '15.2' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'DECLARE u1208 CHARACTER CAST(InputRoot.DataObject.*:*[1].IDocStreamData AS CHARACTER CCSID CCSIDTOUSE);' (CHARACTER)
)
(0x01000000:Name ):RecoverableException = (
(0x03000000:NameValue):File = '/build/S700_P/src/DataFlowEngine/ImbRdl/ImbRdlTypeCast.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 176 (INTEGER)
(0x03000000:NameValue):Function = 'SqlTypeCast::evaluate' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmComputeNode' (CHARACTER)
(0x03000000:NameValue):Name = 'SAP2MB_IDOC#FCMComposite_1_6' (CHARACTER)
(0x03000000:NameValue):Label = 'SAP2MB_IDOC.CPT.PROCESS.IDOC' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPmsgs' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2906 (INTEGER)
(0x03000000:NameValue):Text = '' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '.SAP2MB_IDOC_Compute_ProcessIDOC.Main' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '15.21' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'NULL' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'CCSID' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'CAST' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'INTEGER' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'NULL' (CHARACTER)
)
)
)
)
) |
|
| Back to top |
|
|
| kimbert |
| Posted: Fri Mar 07, 2014 2:39 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5543
Location: Southampton
|
|
| Back to top |
|
|
| sandyvedi |
| Posted: Fri Mar 07, 2014 3:35 am Post subject: |
|
|
Newbie
Joined: 06 Mar 2014
Posts: 3
|
Not sure abt sudeepd2005 is, but code looks from repository.
I am asked to retrieve the the CCSID from the idoc .
But this value is populated as null -
InputRoot.Properties.CodedCharSetId
Can you please suggest is there some other way to fetch the CCSID ? |
|
| Back to top |
|
|
| Gralgrathor |
| Posted: Fri Mar 07, 2014 7:25 am Post subject: |
|
|
Master
Joined: 23 Jul 2009
Posts: 297
|
| sandyvedi wrote: |
| Can you please suggest is there some other way to fetch the CCSID ? |
What does a dump of the complete object look like? From a trace node, I mean?
_________________
A measure of wheat for a penny, and three measures of barley for a penny; and see thou hurt not the oil and the wine. |
|
| Back to top |
|
|
|
|
