Search found 35 matches

by dongyingying
Mon Feb 13, 2012 1:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: wrong number of parameters
Replies: 7
Views: 5064

Hi ,dsdevper

Did you get the answer about issue?Today I met one .
by dongyingying
Thu Feb 09, 2012 3:16 am
Forum: General
Topic: How to handle this issue?
Replies: 3
Views: 2933

How to handle this issue?

When I design a sequence to run two jobs,every job's source have two files and the jobs have no links and need to run parallel ,so i need to loops and nest condition and sequencer . so who can tell me how can i do it? thank you .
by dongyingying
Thu Feb 09, 2012 2:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to update a table there is a expression in the sql
Replies: 2
Views: 2413

HendrikB,

yes, u r right ,when i check it ,I found the sql can't be write to Column_a =Column_a*(1+percent), The bracket can not be accept in the sql.
by dongyingying
Wed Feb 08, 2012 3:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to update a table there is a expression in the sql
Replies: 2
Views: 2413

How to update a table there is a expression in the sql

when I want to update a column and set the column_a = column_a * percent in a table in a stage, also in the input link there are two columns and named to key_1 and percent. so the sql i want to write to like : update table_name set column_a = column_a * percent where key_1=? ; but when i run the job...
by dongyingying
Tue Feb 07, 2012 3:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job failed due to connection closed error
Replies: 3
Views: 3687

So Did you resolved the question ,I want to know the result too.