haha awesome.
then i can mark it as resolved then :D :D :D
Search found 170 matches
- Fri Feb 09, 2018 12:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: database table deadlock
- Replies: 8
- Views: 5731
- Thu Feb 08, 2018 9:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: database table deadlock
- Replies: 8
- Views: 5731
this is my job, populate type 6 table https://i.imgur.com/5ZJPcZf.png those 2 SE stages update same table, one is type 1 change another is type 2 change. I had a kind of illegitimate work around: set the array size to 1 to avoid the problem. consider the whole table only have couple thousand rows th...
- Thu Feb 08, 2018 7:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: database table deadlock
- Replies: 8
- Views: 5731
database table deadlock
hi all i think this is more like a database question rather than a ds question but someone may can help me on here. i have a job has two sql server stages that update same table and they may update same row, if they do the deadlock will occur. these 2 stages runs very different queries from same sou...
- Wed Dec 27, 2017 8:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: automatically turn off RCP for every stages
- Replies: 5
- Views: 4907
- Thu Dec 21, 2017 12:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: if statement problem
- Replies: 14
- Views: 8382
Hi all: I think I find the problem: i didn't put the full code out. the full code is like: if IsNotNull(LkTfProdDetial.Hospital_ProductTypeID) and IsNotNull(LkTfProdDetial.Ancillary_ProductTypeID) then if (LkTfProdDetial.Hospital_ProductTypeID = 3 and LkTfProdDetial.Ancillary_ProductTypeID = 2) or L...
- Wed Dec 20, 2017 7:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: if statement problem
- Replies: 14
- Views: 8382
- Mon Dec 18, 2017 5:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: if statement problem
- Replies: 14
- Views: 8382
- Mon Dec 18, 2017 5:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: if statement problem
- Replies: 14
- Views: 8382
- Mon Dec 18, 2017 4:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: if statement problem
- Replies: 14
- Views: 8382
- Mon Dec 18, 2017 1:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: if statement problem
- Replies: 14
- Views: 8382
- Mon Dec 18, 2017 12:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: if statement problem
- Replies: 14
- Views: 8382
if statement problem
hi i am having a weird problem in transformer stage: i created a stage variable: svCoverTypeCode the value can be : 'HA', 'H', 'A' and in the output link's derivation, i create the following if statement if (svCoverTypeCode = 'HA' or svCoverTypeCode = 'A') then 'Y' else 'N' however when the value of...
- Wed Dec 13, 2017 7:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: automatically turn off RCP for every stages
- Replies: 5
- Views: 4907
- Wed Dec 13, 2017 5:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: automatically turn off RCP for every stages
- Replies: 5
- Views: 4907
- Tue Dec 12, 2017 5:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: automatically turn off RCP for every stages
- Replies: 5
- Views: 4907
automatically turn off RCP for every stages
Hi
I just turned on RCP on one of our project, current problem is we only want use rcp for some of the stages for our new jobs. but once you turn it on some existing stages from old jobs were automatically turn on.
is there a way to switch it off for all the existing jobs?
thanks
abyss
I just turned on RCP on one of our project, current problem is we only want use rcp for some of the stages for our new jobs. but once you turn it on some existing stages from old jobs were automatically turn on.
is there a way to switch it off for all the existing jobs?
thanks
abyss
- Thu Nov 16, 2017 6:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: tuning a massive checksum job
- Replies: 3
- Views: 3440
tuning a massive checksum job
Hi all this topic may be a little more than only datastage I am trying to tune a job that calculate check sum on one of our table. The table is massive, it has over 120 million rows in it and more than 60 fields. the job call a checksum stage to calculate checksum value for each record. the problem ...