Posted: Thu Mar 04, 2010 7:19 am Post subject: SAP ALE Pass throug : ESQL problem
Centurion
Joined: 18 Nov 2009 Posts: 118
Hello All,
I am currently converting a MQlink to use SAP request node.
I have a compute node which creates the output structure in IDOC format.
Below is the esql code, one line sample for control record and data record.
SET OuputRoot.IDOC.DC.segnam = 'E1XXX';
SET OuputRoot.IDOC.DD[1].sdatag.MRM.<field> = 'XXXXX';
I build the whole IDOC this way and try converting into a BLOB using reset content descriptor. It get converted to BLOB properly and then passing this to SAP request node.
I want to avoid using Reset content descriptor. I tried using the Compute node instead and wrote the below
SET OuputRoot.xxxx.xxx = CAST(InputRoot.IDOC as BLOB);
But I see nothihing is getting populated in OuputRoot ??
Could someone tell me what should the code look like if I want to convert the whole InputRoot to a Blob. ??
Joined: 12 Sep 2006 Posts: 2493 Location: Boston, US
search for CREATE PARSE ESQL statement in this forum,
ASBITSTREAM etc etc. it is been discussed a lot here... more than 100+ i guess _________________ Regards
Gayathri
-----------------------------------------------
Do Something Before you Die
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum