Search found 17 matches

Go to advanced search

by vjonnala1516
Mon Feb 09, 2009 5:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Concatenate Two string
Replies: 3
Views: 3055



Hi choose the following function from transformer Date&Time

TimestampFromDateTime(%date%,%time%), where date should be Y-M-D format.
by vjonnala1516
Thu Feb 05, 2009 6:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Concatenate 3 files and generate sequence number
Replies: 14
Views: 8742

Generate new Column (SID- with int Datatype) in Col Gen Stage just before Sequential file stage and in the output-Columns tab for SID use Generator as cycle with initial value as 1 and increment value also 1 and col gen stage should be on sequential mode.

Go to advanced search