MQSeries.net :: View topic

mayur2378 · Posted: Wed Sep 15, 2004 8:53 am Post subject:

Hey guys,

i am using WBIMB 5.0.3, DB28.1.2, Windows Xp
i have this problem i am struggling with .

My situation is i have to capture an SQL code(Insert) in a variable which is passed to a subflow. Now inside the subflow i am using a compute node to insert the data into a DB2 database.. Let me give u a better picture

Environment.Patterns.DBConnSQL='INSERT INTO bulletin ('||received_dt||','||create_dt||','||uuid||','||tt||'
,'||aa||','||ii||','||cccc||','||yygggg||','||bbb_group||'
,'||awips_id||','||file_name||','||file_path||','||src_seq_num||'
,'||source_id||','||chk_sum||','||datalength||','||bulletin_data||')
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?),'||RcvdDate||','||MyDate||','||uid||','||tt||','||aa||'
,'||ii||','||cc||','||YYGGgg||','||bbb||','||awips||','||FileName||'
,'||FilePath||','||SQN||','||SID||','||checksum||','||bulllength||','||bull||')';

After this , its passed to the SUbflow and the compute node inside the Subflow implements

set Environment.Patterns.DBConnResults[]
=passthru(Environment.Patterns.DBConnSQL);

When i try to deploy these files it gives me an error that correlation name 'recieved_dt' is not vaild..

Have tried various combinations for the insert statement. but no success.Was wondering if somebody out there could guide me to what i am doing wrong..