Search found 199 matches

by jreddy
Wed Feb 04, 2004 3:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job parameters in Execute Command of job sequence
Replies: 12
Views: 4138

:o Oh really.. i didnt notice that.

Thanks anyways, i have already spent enough time trying to figure out why it wasnt passing parameter values correctly.

Then what would an alternative be, if i have to call a shell script before certain job runs in the sequencer?

Thanks
by jreddy
Wed Feb 04, 2004 3:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job parameters in Execute Command of job sequence
Replies: 12
Views: 4138

job parameters in Execute Command of job sequence

Guys, Has anyone experimented using Job parameters as input parameters to a shell script that is called using the EXECUTE COMMAND in a job sequencer? If i put hard coded values in the parameters box, the shell script is executed fine. But when i use job parameters (defined in the sequencer as well),...
by jreddy
Wed Feb 04, 2004 1:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date conversion
Replies: 7
Views: 3741

Hi, I guess this is pretty long piece of derivation, but it gets the job done.. Oconv(Iconv(field(<linkname.columnname>, " ", 1, 1), "D-YMD[4,2,2]"), "D/DMY[2,2,4]"):" ":field(<linkname.columnname>, " ", 2, 3) if you need to get it written into oracl...
by jreddy
Wed Feb 04, 2004 8:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: multiple inputs to transformer stage?
Replies: 1
Views: 1316

multiple inputs to transformer stage?

Guys, I have a situation where i am using an Oracle Enterprise stage with a user defined SELECT query which will read selected input values and pass them on to a transformer stage. In this SELECT query, i have a subquery which will return a standard value for each job run, and since i have combined ...