Search found 816 matches

by us1aslam1us
Thu Aug 02, 2007 1:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: lookup on null field giving warning
Replies: 1
Views: 1636

It is giving error because you are sending the column with out handling its null values.Either use IsNull() or NulltoEmpty() in the transformer stage or handle_null() in the modify stage for that particular field before doing lookup.
by us1aslam1us
Thu Aug 02, 2007 12:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oracle OCI Stage Performance
Replies: 6
Views: 2143

Oracle OCI Stage Performance

Hi all, In one of my job i am using Oracle OCI stage to pull data from the source system. I am doing a simple left outer join based on date constraints. When i am executing this SQL from TOAD it is taking 15 minutes to complete but In DataStage it is taking almost 1 hour 10 minutes. My job design is...
by us1aslam1us
Thu Jul 26, 2007 12:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DateTimestamp
Replies: 20
Views: 6656

Criag is right about it. Here is the how you can tweak this. Just remember what format you need at the output. OConv(IConv(Col1, "DYMD[4,2,2]"), "D/MDY[2,2,4]") : " " : OConv("Col2[1,2]:":":Col2[3,2]:":":Col2[5,2]", "MTS") With th...
by us1aslam1us
Wed Jul 25, 2007 2:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null handling for dates/timestamps in MOdify Stage
Replies: 13
Views: 12219

Your syntax seems to be correct. What is your source and target datatypes and formats for this field?
by us1aslam1us
Wed Jul 25, 2007 10:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem viewing the data
Replies: 14
Views: 5405

Your answer lies here:
I generated the text file in windows and trasferred it to the unix server .
[/code]
by us1aslam1us
Wed Jul 25, 2007 9:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DateTimestamp
Replies: 20
Views: 6656

Sorry its my bad. You can substring the time part and concatenate it.
by us1aslam1us
Tue Jul 24, 2007 4:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DateTimestamp
Replies: 20
Views: 6656

Just try this piece: Oconv(Iconv(InDWWORK.DW_ADJ_DATE,"DYMD[4,2,2]"),"D/MDY[2,2,4]"):" ":InDWWORK.DW_ADJ_TIME Check for the timestamp format at the output, if needed append the milliseconds. Two other things which need to be considered is Null- Handling and Input date f...
by us1aslam1us
Tue Jul 24, 2007 3:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem viewing the data
Replies: 14
Views: 5405

You need to define the record delimiter property. Check what process is generating the input file and are you able to view the file properly outside datastage.
by us1aslam1us
Tue Jul 24, 2007 3:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem viewing the data
Replies: 14
Views: 5405

What format properties are you using?
by us1aslam1us
Tue Jul 24, 2007 3:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DateTimestamp
Replies: 20
Views: 6656

Just do some tweaking with the code:

Code: Select all

Fmt(Oconv(Iconv(InDWWORK.DW_ADJ_DATE,"DYMD[4,2,2]"),"DMDY[2,2,4]"): InDWWORK.DW_ADJ_TIME,"##/##/#### ##:##:##") 
by us1aslam1us
Tue Jul 24, 2007 11:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to convert 20070625 to Date Format(mm/dd/yyyy) in PX
Replies: 6
Views: 2296

You can try stringtodate() in transformer stage or date_from_string() in the modify stage.
by us1aslam1us
Tue Jul 24, 2007 10:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: julian date
Replies: 4
Views: 2294

Just remove / from the code and it will work.

Code: Select all

Oconv(Iconv(Right(InLink.TheString,7), "D4JY"), "DDMY[2,2,4]")
by us1aslam1us
Tue Jul 24, 2007 10:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion error
Replies: 11
Views: 5229

How are you handling the null values?
by us1aslam1us
Tue Jul 24, 2007 9:48 am
Forum: Site/Forum
Topic: DSguru2B crossed 6K.
Replies: 4
Views: 3909

Great job. Keep it going.....
by us1aslam1us
Mon Jul 23, 2007 3:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null handling for dates/timestamps in MOdify Stage
Replies: 13
Views: 12219

Yes, you can. Isn't Last time Ray posted you the syntax for that.