Search found 3329 matches

by Sainath.Srinivasan
Fri Mar 20, 2009 10:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Combine Data from two different sources using Pivot
Replies: 11
Views: 3168

What do you mean by 'source 2' ?

Can you provide a pseudo-code of your expected logic.
by Sainath.Srinivasan
Fri Mar 20, 2009 8:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Combine Data from two different sources using Pivot
Replies: 11
Views: 3168

Simplest will be an awk statement. Something like

Code: Select all

awk <params> ' 
    {for (i = 3; i <= NF; i++) 
         { printf("%s,%s,%s\n", $1, $2, $i) } 
     }'
as part of the source.
by Sainath.Srinivasan
Fri Mar 20, 2009 7:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parrel job warning and not loading data into seq file
Replies: 3
Views: 1340

Did you search for the error. There are loads of identical posts.
by Sainath.Srinivasan
Fri Mar 20, 2009 4:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to login to Datastage
Replies: 6
Views: 1638

Were you having DS 7.x running with the same configuration?
by Sainath.Srinivasan
Fri Mar 20, 2009 4:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal Termination of Stage
Replies: 8
Views: 10099

I doubt whether it is due to connectivity.

Can you try routing the data traffic through your dev or test database? There could be some special chars or derivation having issues.
by Sainath.Srinivasan
Fri Mar 20, 2009 3:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to login to Datastage
Replies: 6
Views: 1638

Do you ping by name or ipaddress?
by Sainath.Srinivasan
Fri Mar 20, 2009 3:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to login to Datastage
Replies: 6
Views: 1638

Do you ping by name or ipaddress?
by Sainath.Srinivasan
Fri Mar 20, 2009 3:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Compilation Error for Transformer
Replies: 8
Views: 3891

Is this the first job or was DataStage working before in the PC?
by Sainath.Srinivasan
Fri Mar 20, 2009 3:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem using Surrogate Key generator stage
Replies: 3
Views: 912

Can you check the sequence's currval.
by Sainath.Srinivasan
Thu Mar 19, 2009 11:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to connect Oracle 11g through 7.5 PX Jobs
Replies: 10
Views: 3943

You must be able to use old (10) client to access 11.
by Sainath.Srinivasan
Thu Mar 19, 2009 11:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Buildop Stage - details
Replies: 7
Views: 2405

Can you explain the purpose of having a build-op.
by Sainath.Srinivasan
Thu Mar 19, 2009 10:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: StringtoDecimal Issue
Replies: 7
Views: 2068

StringToDecimal with trunc_zero ?