accessing information about next record

I_Server_Whale · Post by **I_Server_Whale** » Tue Aug 02, 2005 2:36 pm

Hi Gurus,

In my job, I need to access, the next record while the current record is being processed. How do I do that ? Any ideas?

Thanks!
Naveen.

I_Server_Whale · Post by **I_Server_Whale** » Tue Aug 02, 2005 2:39 pm

Hi again,

I have a sequential file source, for which I need to access the second record while the first is being processed. I hope I framed the question correctly.

Thanks again,
Naveen.

pnchowdary · Post by **pnchowdary** » Tue Aug 02, 2005 2:53 pm

Hi NaveenD,

I don't think there is any direct way to do that, as Datastage processes only one row at a time.

ray.wurlod · Post by **ray.wurlod** » Tue Aug 02, 2005 6:45 pm

There is no lookahead capability. You can use stage variables to compare current row to previous row, but never to next row.

The only possiblility is to create your own stage type if you want a lookahead capacity.

I_Server_Whale · Post by **I_Server_Whale** » Tue Aug 02, 2005 6:49 pm

Hello Ray,

How do Igo about creating my own stage type? Please do let me know. Thanks much,

Naveen.

ray.wurlod · Post by **ray.wurlod** » Tue Aug 02, 2005 6:53 pm

Get the Plug-In Writer's Guide from Ascential. Become a very good C and C++ programmer.