Search found 6 matches

by luckyrl
Fri Jun 01, 2007 5:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: passing a parameter
Replies: 11
Views: 4133

Ok, Got it running , thing was that the " jept on appearing , even with the workarounds from JoshGeorge , so it had to be something else, first i tried to write/read it straight from a file , same problem ... than finally , the light went on while browsing trough all the options and settings of...
by luckyrl
Fri Jun 01, 2007 12:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: passing a parameter
Replies: 11
Views: 4133

Hmzz... i got a bit further now, the JOBDATE is actually passed (added some logging in the subsequent job) Call DSLogInfo("Processing YNKxx_NP_to_FLATFILE":JOBDATE ,"Job Controller") Current job parameters:(for YNKxx_NP_to_FLATFILE) LIB=DSFIND JOBDATE="2006-01-01" LOG s...
by luckyrl
Fri Jun 01, 2007 12:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: passing a parameter
Replies: 11
Views: 4133

Hello, both jobs have the LIB (string , no default) and JOBDATE (sting,no default) as parameter in the parameter tab. I tried the option to use 'convert(..) , then ran the JOBCONTROL (wich than calls the YNKxx_NP_to_FLATFILE) the JOBCONTROL control program says in the logs : Current job parameters: ...
by luckyrl
Thu May 31, 2007 8:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: passing a parameter
Replies: 11
Views: 4133

in addtition ,after adding this line Call DSLogInfo("ERROR ":ErrCode ,"Job Controller") the info from the log YNKxx_to_FLAT_CONTROL..JobControl (Job Controller): ERROR -4 according to the manual 0 = ok -1 = badhandle -2 = badstate -3= badparam -4 = badvalue so I narrowed down the...
by luckyrl
Thu May 31, 2007 8:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: passing a parameter
Replies: 11
Views: 4133

Hello , first of all thnx to all for the fast reply's. I do indeed work with a job control , having cloned jobs put in a loop since I have to do year processing later on . the jobcontrol does not have a parameter JOBDATE (tried to add it , same result (YNKxx_NP_to_FLATFILE: Missing Parameters JOBDAT...
by luckyrl
Thu May 31, 2007 2:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: passing a parameter
Replies: 11
Views: 4133

passing a parameter

Hello , I'm trying to do the following through a job control : *read date from seq. file OpenSeq 'E:\Ascential\DataStage\Projects\DSFIND\PILOT\YNKxx_JOBDATE.txt' To jobdatefile Else Call DSLogWarn("Cannot open ":jobdatefile) ReadSeq YSATCdate From jobdatefile Else Goto jobdatefilerror jobd...