DSXchange

Call to the stored procedure can be made in the before/after sql tab.

Cat them together with a delimiter in between say a hypen (-) and return a single string with all the values you need. Read that and manipulate that within datastage using Field() or someother function.

Ok, i want you to build a test job for me with three output columns. Read only the date and provide the following derivations for the output columns Col1 | Iconv(in.col, "D-YMD[4,2,2]") Col2 | Iconv(in.col, "D/MDY[2,2,4]") Col3 | in.Col Col3 will be a straight pul...

Two ways that i can think of at the moment. Job control or via a unix script. Well one more, maybe a server job if you dont mind that. Build a job to dump the table into a file. Read that file in JobControl and Run the jobs you want to depending upon whatever the group value is. Same can be done in ...

Fix the quote character (not the delimiter) for the entire file, you cant do it for a portion of the file.

When you view data, how do you see the date, is it in internal format or in MM/DD/YYYY format?

Craig, even for a before-job activity, doesnt the job start first and then kick off the before job acitivity. It still shows the status as Running even though the before job activity is running.

Hehe....

Do an exact search on 'Unexpected termination by Unix signal 10'.

Did i forget to mention ETLStats.

You can read about their functionality in detail in Designer Guide .

Commands to be run from DataStage administrator are uv commands. Like LIST.READU (to list all current users logged on and a little more info..) There is no list as such, but any uv command, provided its in your VOCabulary, and provided you have the priviliges to run those commands, you can run it fr...

IMHO, you need to develop all the jobs as stages are very different for the two engines.

How can you update based on the surrogate key when your generating those as you insert? You need to update based on the natural key. Also, if the surrogate key is the only key column defined, how are you getting duplicates? How many columns have unique indices on them? I am confused

Go to sequence job properties, under the General tab, check the box that says 'Log Warnings after activities that finish with status other than OK'. This way if any child job finishes with status 2, the parent sequence will also finish with status 2.