RECORDSETS IN TERADATA

[GUMDO]

All,

Is there a way to build and use recordsets in Teradata through stored procedures? I basically have a table with an item and a cost, and need to move some of those items to another table until the sum of the costs hits a max. I also need to move those items ordered by the size of their costs.

If anyone can provide sample code of how to do this, I'd appreciate it.

Thanks,
KG

 

[Sridharan]

KG,

Why don't u try Cursors! I think that will help ur cause.

Regards,

Sridharan

 

[GUMDO]

Thanks, do you have any examples of how to make cursors work? I tried copying the examples in the NCR Teradata documentation and it doesn't seem to work.