Search found 2 matches

by DBI
Wed Feb 23, 2005 4:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lookup Range
Replies: 12
Views: 5493

Re: Lookup Range

Hi Shiv, if it's possible for you to make these entries in a database, then you could use the ODBC Stage for the reference Link. In the ODBC Stage you are able to define a reference link SQL statement. So you make it in the way " where field FROM >= '' and field TILL <= '' " So you'll get ...
by DBI
Tue Dec 09, 2003 3:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: generating numbers
Replies: 2
Views: 1375

Used the @INROWNUM :idea:
If you generate the numbers from the inrow count, you can reference against the 10 rows you need and at the output your 10 rows have the numbers from the inrow count and not 1 to 10.