SQL error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
fred
Participant
Posts: 3
Joined: Tue Aug 12, 2003 11:19 am

SQL error

Post by fred »

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
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

Fred

You probably did user defined SQL and you have more or less columns defined in your metadata.

Kim.
Mamu Kim
Post Reply