Search found 60 matches

by G.K.K
Fri Jul 31, 2009 12:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before job-subroutine --> need help
Replies: 40
Views: 12349

Doesn't matter, integer or string it will work. Post the log message where it shows the command being run, it will list the 'Output from command' as well. I'll wager it's not what you think it is. Hi chulett, i am pasting the summary log that was generated by the job sequence, my execute command st...
by G.K.K
Thu Jul 30, 2009 11:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before job-subroutine --> need help
Replies: 40
Views: 12349

Ah good, either way should work but as noted it can depend on your version as "earlier" versions don't support the same variety of expressions that the "later" ones do. Please make sure you mark your post as Resolved using the big button at the top of the screen. Thanks! Hi chul...
by G.K.K
Thu Jul 30, 2009 8:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before job-subroutine --> need help
Replies: 40
Views: 12349

chulett wrote:Nice... double posts 36 minutes apart. Make sure you back up and see what you've missed.
hi chulett,

Thank u very very very much, it is working..

thanks for your support,
kamal.
by G.K.K
Thu Jul 30, 2009 8:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before job-subroutine --> need help
Replies: 40
Views: 12349

Ack... no-one ever mentioned using the concatenation operator and it never occurred to me you'd include the quotes after the full syntax had already been spelled out for you earlier. Oh well. ps. Don't use the quotes that Arnd included, either. :wink: Hi, i tried as Arnd mentioned without quotes an...
by G.K.K
Thu Jul 30, 2009 7:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before job-subroutine --> need help
Replies: 40
Views: 12349

Ack... no-one ever mentioned using the concatenation operator and it never occurred to me you'd include the quotes after the full syntax had already been spelled out for you earlier. Oh well. ps. Don't use the quotes that Arnd included, either. :wink: Hi, i tried as Arnd mentioned without quotes an...
by G.K.K
Thu Jul 30, 2009 6:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before job-subroutine --> need help
Replies: 40
Views: 12349

Sai posted almost exactly the same steps that I did, which I find a little odd as it won't help at all at this point. Kamal - you need to answer Arnd's rather simple question: this "k_ftch" parameter you have in your job, what type is it? String, Pathname, what? And please confirm for me ...
by G.K.K
Thu Jul 30, 2009 4:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before job-subroutine --> need help
Replies: 40
Views: 12349

Kamal, Try the following steps Open the sequencer -> Double click on the job stage to open its properties -> Ensure you are on 'Job' tab -> Click on k_ftch parameter to get your mouse ... hi sainath, Your reply is not fully displayed to me could u please send to me as a private message. sorry for i...
by G.K.K
Thu Jul 30, 2009 4:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before job-subroutine --> need help
Replies: 40
Views: 12349

In your job, you can only declare the type of "k_ftch" as String,Encrypted,Integer,Float,Pathname,List,Date and Time. We are looking for one of these as an answer to the first questions. The second question is what actual value are you passing to "k_ftch". hi, i want to pass the...
by G.K.K
Thu Jul 30, 2009 4:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before job-subroutine --> need help
Replies: 40
Views: 12349

It will be very useful to provide actual names of the parameters than talking relative reference names - x and y. 1.) What is the job name? 2.) What is the parameter in the job called as (not the job sequence) ? 3.) What is the name of the executeCommand stage in your sequence ? If you answer the a...
by G.K.K
Thu Jul 30, 2009 4:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before job-subroutine --> need help
Replies: 40
Views: 12349

It will be very useful to provide actual names of the parameters than talking relative reference names - x and y. 1.) What is the job name? 2.) What is the parameter in the job called as (not the job sequence) ? 3.) What is the name of the executeCommand stage in your sequence ? If you answer the a...
by G.K.K
Thu Jul 30, 2009 3:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before job-subroutine --> need help
Replies: 40
Views: 12349

I'm confused as to how this can be so confusing. :? It's way too late to be worrying about a "data type" as you have (allegedly) already defined the parameter in the job you are running, have you not? And there's no need to define it again in the Sequence job as you are not passing it int...
by G.K.K
Wed Jul 29, 2009 8:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before job-subroutine --> need help
Replies: 40
Views: 12349

In the sequencer -> Open job properties -> go to the parameter (x) -> set the value as the one mentioned ... hi sainath, what is the datatype need to mentioned for the parameter x? thanks kamal Hi, please some one help me in solving this issue.. what is the datatype need to mentioned for the parame...
by G.K.K
Wed Jul 29, 2009 7:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before job-subroutine --> need help
Replies: 40
Views: 12349

Sainath.Srinivasan wrote:In the sequencer
-> Open job properties
-> go to the parameter (x)
-> set the value as the one mentioned ...
hi sainath,

what is the datatype need to mentioned for the parameter x?


thanks
kamal
by G.K.K
Wed Jul 29, 2009 7:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before job-subroutine --> need help
Replies: 40
Views: 12349

Use it in the Job Activity stage as the value passed to the parameter you've defined in the job for this purpose. ... hi chulett, i am confused, see i have executecommand stage in jobsequence and followed to it jobactivity. as shown below executecommand stage ------> jobactivity i defined parameter...
by G.K.K
Wed Jul 29, 2009 6:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before job-subroutine --> need help
Replies: 40
Views: 12349

about parameterset derivation

use <CommandActivityName>.$CommandOutput<1> as a derivation of job parameter. And please don't use SMS style words in your post. hi priyadarshikunal, You mean <CommandActivityName>.$CommandOutput<1> mention this value as a default value in job parameter which i used in the job? if not can you pleas...