Search found 69 matches

by kamesh
Mon Dec 13, 2004 11:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: regd:nodes
Replies: 1
Views: 1240

regd:nodes

Hi,
can any one tell me how may nodes can create for dataset creation in Parallel extender?

Thanks
kamesh
by kamesh
Wed Sep 22, 2004 3:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: migration6.02 to 7.0 issue
Replies: 2
Views: 1520

migration6.02 to 7.0 issue

I have a migrated a job from 6.02 to 7.0 version.But i have foud while running the job all null values in the source dataset in that job are transfered to empty values in the target dataset.This jobs contains source dataset,lookup stage and target dataset.This was working fine in 6.02 version. let m...
by kamesh
Thu Aug 05, 2004 11:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to get dataset column value in before stage
Replies: 6
Views: 3149

Thanks

Can you tell me how to pass column value to sql query in before stage?
by kamesh
Thu Aug 05, 2004 10:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to get dataset column value in before stage
Replies: 6
Views: 3149

yeah i am using db2 out put stage.. I have dataset having 10 columns and i am inserting records in to target table and also same time based on one of columns in the dataset value in before stage i am deleting records in other table. i dont want delete row wise..
by kamesh
Thu Aug 05, 2004 8:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to get dataset column value in before stage
Replies: 6
Views: 3149

how to get dataset column value in before stage

I want to delete records in the db2 stage in before stage based on the dataset column in the where condition, can you pls any one tell me what is the syntax for this

Quary like in before stage

delete from table_name where column_name=dataset_column_value

Thanks
poduri
by kamesh
Wed May 05, 2004 4:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sum of column in Aggregator stage
Replies: 4
Views: 3385

sum of column in Aggregator stage

I have 72k records with decimal 23,3 values in db2 table. I am getting 'A' value when i sum the column using sql query. but when i try to sum the same column field (decimal 23,3) using aggregator i am not able to get the same result.
Can anyone help me out on this issue
Thanks
kamesh
by kamesh
Wed Apr 28, 2004 6:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to open IPC file
Replies: 0
Views: 1608

Unable to open IPC file

I am getting Unable to open IPC file error in my parallel job while run the job. But this job is successfully completed before..
can any one help me out on this problem
Thanks
kamesh
by kamesh
Fri Mar 05, 2004 5:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: cannot open file rt_log835 error in px
Replies: 1
Views: 556

cannot open file rt_log835 error in px

Hi, i ran one job today but it gave lot of warnings.. After that i got a error message and i stopped the job. But now i cant able to open the job or compile the job or even not allowing me to rename the job. when i try to open the job i got this message "cannot open file rt_log835" can any...
by kamesh
Thu Feb 19, 2004 6:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: row count in dataset
Replies: 3
Views: 2769

row count in dataset

Hi
Pls can any one help me how to find the row count in data set.if need to use transformer or any other stage is also ok with me
Thanks
kamesh