DSXchange

Thanks guys for the suggestions. It was helpful.

Can someone please suggest a way to generate unique sequence numbers within Ascential. The purpose is to assign that number to a column in a table each time a new record is created using datastage. Currently I am using Oracle sequences (and having a trigger on insert on the table to populate the col...

This might be a very basic question, I am not very familiar with datastage.

Am getting an error:

DSD.BCIOpenRef call to SQLNumResultCols failed.SQL statement has incorrect number of result columns.

What could be the problem?

Thanks in advance.
Fred