DSXchange

I need to get the Stage Start timestamp and End Time stamp as part to log the timings and statuses of the each stage in my job. I am proving in Transformer stage where it write to a Seg log file DSGetStageInfo(DSJ.ME, DSStageName,DSJ.STAGESTARTTIMESTAMP) DSGetStageInfo(DSJ.ME, DSStageName,DSJ.STAGEE...

Thanks Arndw, I following the method of writing different HAsh file and writing to a Seq Output file using Transformer. I have one more question what kind of values does DSStageLastErr and DSLinkLaskErr macros set, I want to capture those to Log file. For example if stage or link completed succesful...

I am using a Seq file, as you said i can't use Seq file, hash file as it is going to be same key. So, how should i get the result what i am expecting.

thanks

Hi,

Is it possible to use same file in 3 stages to write output status.
I am not able to write the first 2 stages status, i think it is overriding the last 2 stages statuses.

Thanks

Hi Ray, May be my question was wrong. my requrement is - I will get a fine with values, i need to read those values and pass as parameters to next job and from that job to next job. I am trying to use JOB control to write a small code to read the seq file and Attach a Job with DSSetparam and call ne...

Thanks Ray!!! I changed it - it is passing the parameters to next job and next job working fine but the main job aborted with following error "Job_Parms..JobControl (fatal error from DSGetJobInfo): Job control fatal error (-1) (DSGetJobInfo) Invalid job handle <Missing or NULL>" ----- I ha...

Hi Sai,
I am kind of confused!!!
i added this code just before DSSetparm

If IsNull(JobHandle) Then
Msg = "job handle is Null:"
End

Guide me pls

Hi Sai,

you mean

JobHandle = IsNull(DSAttachJob(TempJobName, DSJ.ERRFATAL))

Please clarify me!

Thanks

Here is my Code Where A -to- K are values from ParameterFile and I am trying to call another job by passing A -to- K values as paramter. *---------------------------------------------------------------------------- * Get Parameters *-------------------------------------------------------------------...

Hi all, I am trying to run a job from Job Control in Job Parameters. Basically i get a file and i need to read the file to get the values as a parameters and call another job. But while i am running the main Job i am getting following error. "Job_Parms..JobControl (fatal error from DSSetParam):...

Hi All, I have a input file which has CHAR(30) length column and i need to match this column with DB2 table CHAR(30) column to get the data, But the question is from the Input CHAR(30) i need to table only 28 char to match with table char values as the last 2 chars in input file has some value. So I...

where do we run the SQL provided by Kdude, is it in Universe Stage?

Same thing happenning with me also, Source is AS400 - DB2. I used User defined SQL to join 3 tables to get the data, when view the data it is perfectly retrieving the data but when I run the job it is aborting with "[IBM][CLI Driver] CLI0131E Invalid string or buffer length. SQLSTATE=HY090 SQLT...

Hi, How to load a DB2 table with Dummy? I need to clean up the table before inserting new rows. Yes there is an option in DB2 stage " Clean the table, then insert rows" but i need to use "User defined Insert statement" for my requirement. I tried with DELETE statement then INSERT...

I guess i am moving Char value to Numeric value.
But how do we look the Line number it mention in the abort message..