DSXchange

Hi, Iam facing a problem when iam updating a record with a current time stamp in a columm. Iam getting a waring like this . Iam using DB2 api stage ZWV_FACTOR_RC_UPDATE,1: Warning: FEMS_REQUEST_CHANGE_UPDATE_DELETE.ZWV_FACTOR_RC_UPDATE: [IBM][CLI Driver] CLI0109E String data right truncation. SQLSTA...

Hi,

MY problem was solved .Iam getting this error because my userid and password doenot have perimmision with mq server. I used the userid and password which is having permission and my problem was solved.


Thanks,
Somaraju

Hi Dsguru, I have defined a leftouterjoin and Iam haning Ch,Cu and Date as key columm and I am getting only 14 rows out of 24 date key (it is there in file and table),date1(fromfile it is only in file) ch,cu,date,date1 R,1,2,1 O,1,3,2 R,2,2,1 R,1,3,2 Iam getting only above two only from output and I...

Hi, Iam using a job that is performing a lookup function with db2 stage API. I have a file and there are 24 records and DB2 table has 4 records and when I am performing lookup based on key columms in lookup stage Iam getting all the 24 records but I want only 4 records that is from the table db2. Th...

Hi, Iam using a DB2 API stage and iam updating a record by user defined sql like this UPDATE #tgtschema#.yyyySET SHAD_UPDATE=?,yyyyy=?,uuuu=? WHERE rrrrr=? AND sssss=? ; but Iam getting an fatal error like this main_program: Fatal Error: Destination "APT_TRinput0Rec0.SHAD_UPDATE_TS" is alr...

Hi,


My problem was solved .Iam getting this message there are duplicate messages in mq and when it was parsed through XML it is giving an error.



Thanks
Somaraju

Hi, Iam using an Xml output for parsing the data that is commming from the transformer I am facing a warning saying XML_Output_Error,0: Warning: CopyOfCopyOfFEMS_OIM_GetPutCommitTx.XML_Input: XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 1, column: 1): I...

Hi, Iam using an MQ stage for reading and writting a message . When Iam trying to put a message in MQ after parsing with XML output Iam facing a fatal errror saying WebSphere_MQ_Out,0: Fatal Error: Fatal: Failed to put message on the queue. Reason code 2031. Iam connecting two links to websphere_MQ_...

Hi Roy,

Thanks for your reply. I will try that




Thanks,
Somaraju

Hi, I had a user defined environment variable $RequestLoadEnabled (string) and value ="Y". When Iam using it as a parameter in job and Iam using the job parameter in link constraint $RequestLoadEnable ="Y" and Iam getting an when Iam compiling a job saying ##E TFCP 000012 14:38:2...

Hi, Please help me, I have requirement like this. If unrecoverable DB2 error occurs, backout DB2 changes made to this point, write a record to the application log including the error. How to backout DB2 changes is there any rollback function in DB2 / API stage. And one more doubt I have given transa...

Hi kumar, Nice to see your post. Actually my requirement is if economic devaluation is not compatible with Dec(7,4) I must raise an error. I have a columm with name EC dec(7,4) in db2 . If I am getting from input more than dec(7,4) and when I tried to load to db2 I will get an error in log but I wan...

Hi, I have requirement like this the files thar are not loaded in to a DB2 table. I have to send to reject link. But I know that if there is a constraint in transformer before loading in to DB2 the record that doesnot satisfy will go through reject link. But my requirement is to reject to a output l...

Hi ameyvaidya,

Please can you tell me with an example how you people achieved.





Thanks,
Somaraju

Hi Ray,


Sorry Iam not able to understand. What is this equip a message. Is there any solution for this . please help me.


Thanks
Somaraju