Search found 2 matches

by bahut2000
Fri Apr 14, 2006 5:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Custom oracle function to do execute complex sql transformat
Replies: 1
Views: 1017

Custom oracle function to do execute complex sql transformat

Will datastage do the necessary transformation row by row if I use Oracle custom function passing rowid as a parameter to the oracle custom function to excute complex sql query?I am intending to call the function
as a userdefined function from the Oracle Enterprise stage.
by bahut2000
Fri Feb 17, 2006 2:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Column names in the sequential file output with delimiter
Replies: 7
Views: 2424

Hi rgn_g. In the sequential file stage, there is an option named: "First Line is Column Names = False". Change it to True. And in the Format tab of this stage, you can specify which delimiter you want. You can choose "None", "Comma"... or you can even type it is the li...