DSXchange

Hi Ray, Actaully, I got error message like "Job xxxx is being accessed by another user" Please advise what to do, thanks!! The pid does exist - it's just that you're looking for the wrong thing. Each connected client establishes a dsapi_server as its agent process, and that may fork a dsap...

Dear all, I would like to ask if there is anyway to forcing a job to "log off". Actually, when I was using D.S. job designer today, the application messed up and I use the windows task manager to kill the job designer. And a problem arose: The job that I was modifying wasn't able to be fre...

Dear All, I would like to see if it is possible to create a null column in Modify stage. Also, in the specification box, when I try to enter "USERID = SetNull" the compiler treated "SetNull" as a input dataset field instead of treating as a build-in function. Can anyone provide t...

Hi all, Just a piece of little additonal info. Actually I have already created a job which handles multiple datasets upload to DB2 without predifining a table definition. And the job design is pretty strict forward, i.e. uncheck RCP and make sure the dataset has an identical table definition to that...

Hi all, I would like to see if it would be possible to apply the following logic to a datastage job: 1) Input Dataset (multiple and specified in a job parameter) 2) logic - Specified by a parameter, a dataset(out of many other datasets) is input into a datastage job - The stage job checks the table ...

Hi Ray, Thanks for your advise! Cheers Welcome aboard! :D 1) Is it mandatory to specify table definition in the DB2_UDB_API job in order to retrieve data from a DB2 table? Yes. 2) Is there any workaround to avoid specifying table definition such that a d.s. job can be designed in a generic way to re...

Dear all, Actually I am trying to write a D.S. job to retrieve data from DB2 table by using DB2_UDB_API. And I intend to write this job in a generic way such that this job can be called to handle multiple tables(with different table definitions). However, it seems that this job can not be done in a ...