DSXchange

Hi all, I have a requirement to prepare binary number from the input then convert it into decimal and sent it to database. I m trying to implement this logic in buildop stage. I read that buildop stage supports c++ programming, but here when I am trying to use atoi() function for converting binary n...

Hi, Finally after searching a lot in Basic manual I was able to find workaround for this problem. It can be done with only one after job routine. After job routine will capture the current run log messages and abort the job if it finds SQL code in it. Matchfield and Match are the functions which wil...

Welcome aboard. Do you mean something like "treat warnings as fatal"? I don't think this exists in the DB2 API stage. Is there some reason you're not using the DB2 Enterprise stage? ... Hi Ray, Job has to update table that resides on mainframe host, so we cannot use enterprise stage to co...

Hi all, I am having a problem with DB2 API stage. I searched the forum could not find solution for it. Here is the job. Seq file --> Copy Stage --> DB2 API (update) Job is reading from a flat file and updating the records in DB2 table. Here DB2 errors are getting captured as warnings instead of fata...