Search found 2 matches
- 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...
- 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...