DSXchange

1) You don't want to pull the data into ascential's memory: How do you intend to use DataStage when you don't want it to read the data You have got exactly what I intended. I feel performance would be bad if I brought the data from db2 to ascential memory. table1--> ascential --> table2 I want to s...

Hi Folks, I need to move records from temp table to the final table. Can you suggest a good approach so that I can move data from temp table to warehouse and then delete from the temp table. I would prefer not to pull the records into ascential's memory and at the same time would need to keep the in...

Hi All,
I have been going through the old posts on this forum, but not been able to get enough inputs.

Has anyone successfully invoked a udb stored procedure using db2 api stage.

Bigpopa, Any inputs for me... Pointers would be appreciated

Thanks

Hi Ray, Thanks for pointing out that the suggestion in help doc was for server job. Kindly provide me pointers on how to incorporate this on px version 7.0 I would be wanting to do insert / updates and which to capture database related errors like unique constraint violated, not null error etc. I wo...

Hi, I need to incorporate handling of database rejects. DB2 stage doesnot seem to be supporting the creation of reject link. The pdf help docs say that it is possible as given below,but I am not clear where to put the transformer stage. Has anyone successfully tried it before Any help wud be appreci...

The output of a UDB Stage is a date (CREATE_D). I need to use this date to select data from a different database. A possible approach ? : Store the CREATE_D in a sequential file. Write a basic routine to read this value and invoke a job which takes the CREATE_D as a parameter. Select A,B,C from DB2P...

I get the following error message when I do a comparision on two date fields [IBM][CLI Driver] CLI0100E Wrong number of parameters. SQLSTATE=07001 The user defined query in the UDB Stage is: SELECT A,B,C,CREAT_D FROM DB2PROD.ALPHA WHERE CREATE_D > ? ; My job runs if I replace the '>' with '='. It ab...

I need to convert a string into a number. This is needed for performing a mod operation.