Search found 2 matches

by jasonchan
Thu Oct 14, 2004 1:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error Msg in Running a Simple Lookup
Replies: 1
Views: 1084

Error Msg in Running a Simple Lookup

Hi all, I had a job that runs a simple lkup with a lkup stage; input being a dataset, reference being a lkup fileset, and output being another dataset. When I validate the job, I got the following 2 errors in my DS Director: main_program: This step has no datasets. It has 1 operator: op0[1p] {(seque...
by jasonchan
Wed Oct 13, 2004 10:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting Last Generated SK from Surrogate Key Stage
Replies: 1
Views: 1395

Getting Last Generated SK from Surrogate Key Stage

Hi all, I'd like to know what's the best way to get last generated SK for the SK stage. This will be used as the "Start Value" property of the SK stage. I searched through the fourm, and found someone is doing a SQL query over the table, and get the max. value of the S.K. and then get this...