DSXchange

Thank you.

Thank you for the info.

Thank you for the reply, I did not mention it in my post but I did assign the parameter with the values as you mentioned, but still the problem seems to persist. Are there any other things that could have stopped the shell script? Parameters are fed as: -param JOBPARAMETERNAME=value You aren't speci...

Hi I am working with running datastage job using the shell script on sun system. Eventhough I pass all the required parameters, datastage gives the following error mesaage. Can someone decipher this and inform me. Thanks Bob Invalid arguments: dsjob -run [-mode <NORMAL | RESET | VALIDATE>] [-param <...

HI
How would you concatenate flat files in datastage.

Hi I am trying to capture the rejects of all of my jobs into a flat file.I overwrite the existing file in the first job feeding my flat file and thereafter append records to the flat file from all the other jobs in the sequence. I would like to know whether this aproach would work. If not what other...

Thank you, I will look into it.

Hi
Thank you for the reply for my post. I have tried to figure out the connection string problem but could not troubleshoot it.

View data works fine with all other tables except for 2. Do you have any suggestions to correct the problem.

Please inform.

Thank You for the reply. How do I change the connect string of datastage so that it can pick the data as toad does. Views/tables, doesn't make a difference. If the same query in Toad returns data, you need to verify the connection string. Make sure you're hitting the right instance, because your Toa...

I have noticed that the AR_MEMO_LINES_VL is a view and not a table. Cant we obtain data from views. Hi I have a simple problem. I am trying to load memo_line_id from a oracle table into a hash file. The following is the user defined sql in oracle stage. SELECT Attribute1, MEMO_LINE_ID FROM Apps.AR_M...

Hi I have a simple problem. I am trying to load memo_line_id from a oracle table into a hash file. The following is the user defined sql in oracle stage. SELECT Attribute1, MEMO_LINE_ID FROM Apps.AR_MEMO_LINES_VL Attribute1 is the key in hash file. The view data on the stage gives data source is emp...

Thank you for the promt reply.Can you eloborate the statement "The metadata used to write a hash file has to be the metadata used to reference the hash". Do the datatypes have to exactly the same including the lengths. In my case the datatype to create hash file is a char for the 3 cols an...

Hi I am retrieving 3 columns into a hash file and would like to do a equijoin with 3 columns coming from a flat file in the transformer stage. 1.I would like to know what happens if I define all three columns as keys in the hash file. How is this interpreted by Datastage. Is it that each column is p...

Thank you for the information

Hi I have 2 questions for everyone. 1. I am trying to do a join on data coming from a oracle table with another oracle table using the hash file and transformer stages. The key column in hash file, is it like the primary key in database or is it used just to do a join with other columns from a diffe...