Search found 3 matches

by catmans1
Wed Nov 08, 2006 4:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Modify Stage - System Date to Timestamp conversion??
Replies: 7
Views: 5576

Ray, That's where I'm confused I guess. Does the Specification parameter in the Modify Stage require a mapping of a Input to a output? I don't have an input date for my output column, I want to load the Current Timestamp to the output column......can this be done in the Modify Stage? A truly EE newb...
by catmans1
Wed Nov 08, 2006 1:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Modify Stage - System Date to Timestamp conversion??
Replies: 7
Views: 5576

Modify Stage - System Date to Timestamp conversion??

Are we able to create a new column in the modify stage without a source from the input side? I'm trying to put a load timestamp into my target table (UDB/DB2) in which I just want the system date and time to be loaded into this new field. I've tried the following Specification = DW_LOAD_TIME = times...
by catmans1
Mon Aug 26, 2002 9:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Forcing a DataStage job to Abort based on a rule
Replies: 2
Views: 2878

Forcing a DataStage job to Abort based on a rule

Does anyone know if there is a way to force a DataStage job to abort when a certain condition doesn't match? I have the need to do balance and controls within DataStage 5.2 on HP-UXIX. I read a file that has the first record containing total count (of all records) and I'm to match it to the count of...