Multi row result set in Parallel job

vnspn · Post by **vnspn** » Mon Aug 20, 2007 3:08 pm

Hi,

We are using DataStage version 7.5 on AIX server.

We were making use of the feature Multi row result set (in ODBC and UniVerse stages) in Server jobs. Now we are moving into Parallel jobs, and there is no such similar kind of option in the parallel stages. Could anyone please point us on how could this be done in a parallel jobs.

Also, is it possible to get a Multi row result set when the reference link is from either a Sequential File stage or a Data Set stage.

Thanks.

ArndW · Post by **ArndW** » Mon Aug 20, 2007 3:37 pm

The lookup stage will return multiple rows, and there is an option to limit that to a single row.