DSXchange

I have a very similar problem. I am able to insert NULL values to the DB2 Table using @NULL function in server job transformer stage. When i check the table with "select * from table1",i am able to see the "Null" values(in col1). But when i execute the query "select * from t...

I have a very similar problem. I am able to insert NULL values to the DB2 Table using @NULL function in server job transformer stage. When i check the table with "select * from table1",i am able to see the "Null" values(in col1). But when i execute the query "select * from t...

Gurus, I Agree with your answer. But we need to configure it manually. Apart from capturing the record count and reloading the records from the point where it got aborted. Is there any way that Datastage will handle the situation on its own (with out keeping track of the records or by giving the Par...

Gurus, I Agree with your answer. But we need to configure it manually. Apart from capturing the record count and reloading the records from the point where it got aborted. Is there any way that Datastage will handle the situation on its own (with out keeping track of the records or by giving the Par...

Hi All, In our project, we have a requirement to load millions of records from file to Oracle database. Data volume being quite high. We decided to go for Oracle Load option. We are able to load data through this option (oracle Load utility), but we need to capture rejects as per the client requirem...

Hi All, I have designed a Parallel job which loads data into 15 oracle Targets tables and the data had been pulled out using 15 ODBC source stages (Source Main Frame DB)Some basic transformation was done using Transformer stage.Performance wise will there be any impact on the DS server and the resou...

Hi All
Thankyou very. Finally i am able to crack it with your help.

Hi All, How to copy the datastage job names to a file after fetching the information from Datastage Administrator command line. In our project some around 1000 jobs are there, We want all the Jobs names in a file.which will be helpful for our client. We are able to fetch the informtion of the jobs n...

Hi Ray, Thanks for the reply. I have the .dat file(binary data) but i am unable to view the data and its format. client just gave us the template of the data. I tried to view that file using complex flat file stage considering the whole set as single column but i am unble make any progress. can you ...

Hi all,
i want to read a .dat file(binary file) through datastage. Is that possible, if so please let me know the procedure.

Thanks in advance.