DSXchange

Hi,
Can we create universe tables for staging instead of creating in Oracle which would be a quick approach!


Thanks,

Hi, I am converting ETL work built in SQL to DataStage. I have a statement which uses case statement with the "LIKE" command and I donot have the temp table, so how do I get the functionality of the LIKE command in DS transformer. For example I have the following command SELECT CUSTOMER, P...

Hi, I am able to runt he job but I am getting two warnings, I am not sure what can be done . 1) main_program: No collation sequence found for en_US, using default locale root 2) main_program: Warning: the value of the PWD environment variable (/opt/etl/Ascential/DataStage/DSEngine) does not appear t...

The fields I am mentioning are decimal with length 15, scale 3.

Thanks a bunch Arnd, I have looking the help file and was able to get there. I gave the null values as 0 if the incoming field is null and it gives me the following warning: "null_field" length (8) must match field's fixed width (6) So should each field be filled with 0s as per the length ...

Hi,
Where would I "specify your null handling in the column declarations", my job as of now looks like

ABAP_Extract--->Modify--->FlatFile


So if I take the Modify stage out, as I was using it for the Nulls it will look like:

ABAP_Extract--->Modify--->FlatFile

Thanks,

Hi, I have researched the " NULL Values " in this forum, my question is if I have 35 columns to check for the null handling, can I do it with one command for all columns or I need to add each column Col1=handle_null (Col1, 0), Col2=handle_null(Col2,0) ... in the modify stage. I am extracti...

Hi,
I have a simple job which reads from a DataSet and looksup a Oracle stage, if no records match the job completes fine and now when I have records that match in the source dataset, the job just sits there after a row!

Any help?
Thanks ,

I will check it out, I am now looking into what ArndW has posted.
Thanks for your help.

I have used the SHIFT-JIS map and all others , it is spitting out the records if I am trying to write to a table with the following errors:

"Unmappable characters found mapping text string (?W???w?????? ) with map (ASCII)"

Thanks,

Thanks for your idea , have alreadu started it, wish there wa s a developer who wants to learn DS , they are so monotonus jobs

well I donot know about the money but instead of calling for meetings with DBAs and all team members (which will take more a week) , I thought it would take the same time to just build individual jobs in DS to load Test from Prod!

Hi, Most of the development data is extracted out of production as data quality and quantity is not even close in test and development environments. This makes the real production jobs run slow! If we need to synchronize data in test or development with production every week on the weekend or so, wh...

Hi Dale,
thats exactly what I have settled with !
Thanks

I'm having trouble selecting data from a Sybase view using the Sybase Enterprise stage. I confirmed with our DBA that DataStage is connecting to the database server, but when I "View Data" it comes back with no rows and the following log: ##I TUTL 000031 11:08:56(001) <main_program> The op...