MQSeries.net :: View topic - How to create a file using File Output Nodes

Phanikumar · Posted: Tue Oct 16, 2018 4:21 am Post subject:

Hi All,

I have a requirement of write some data to a file by querying data from database.

I have tried below code but Outputroot coming as null

SET cSqlQuery = 'SELECT WORDING, PRODUCT_TYPE FROM XXXX WHERE PRODUCT_CODE = ?';
SET rEnv.Variables.rResultSet.CrdAut = PASSTHRU(cSqlQuery,cCardNo);

SET OutputRoot.BLOB.BLOB = CAST(rEnv.Variables.rResultSet.CrdAut AS BLOB CCSID 1208);

SET OutputLocalEnvironment.Destination.File.Name = cCurrDate || '.SIF';

Please let me know where i did a mistake.

Regards,
Phanikumar.
_________________
Saying what you feel. It's not being rude, it's called being real.