Stored Procedure Stage Question
Posted: Fri Mar 06, 2009 2:14 pm
Is it possible to handle differing column layouts returned from a Sybase Stored procedure call? For example say my rowset contains header, detail and trailer records with differing columns.
The simple answer is to modify all the procs to return only detail records and handle the header and trailer in DataStage but this is not an option at the moment.
I'm currently getting the following error:
Stored_Procedure_0,0: Error: ValidateOutputColumns ct_results
The column(s) defined on this link do not match the column result set.
What are mt options here. Thanks in advance guys.
The simple answer is to modify all the procs to return only detail records and handle the header and trailer in DataStage but this is not an option at the moment.
I'm currently getting the following error:
Stored_Procedure_0,0: Error: ValidateOutputColumns ct_results
The column(s) defined on this link do not match the column result set.
What are mt options here. Thanks in advance guys.