Hi,
The post had detailed explanation. Thank you.
I was looking for a command where I could export certain set of jobs to one isx file. These jobs could exist in different folders in DataStage project.
Your help is appreciated.
Thank you
Search found 239 matches
- Mon Apr 28, 2014 8:24 am
- Forum: General
- Topic: istool syntax
- Replies: 30
- Views: 60616
- Sat Aug 17, 2013 5:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformer Constraint
- Replies: 1
- Views: 1931
Transformer Constraint
Hi, I have the below conditions inorder to filter records using the transformer stage. This works fine in Development environment of 8.7 but fails in Test 8.7 environment. Stage Variable - svFLAG ---> If NullToEmpty(ERR_IND) = 'Y' then 'ERR' Else 'T' The transformer has 2 links as output - First lin...
- Fri Aug 16, 2013 3:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Empty String handling in 8.7
- Replies: 3
- Views: 2691
- Thu Nov 10, 2011 10:42 am
- Forum: General
- Topic: Unable to attach executables
- Replies: 0
- Views: 1511
Unable to attach executables
Hi All,
I am trying to export a job with its executable. Now when when I try importing it using import selected option I do not see the executable file.
This is a multiple instance sequence which is called in another sequence. Not sure why this happens.
Thanks & Regards,
Devi
I am trying to export a job with its executable. Now when when I try importing it using import selected option I do not see the executable file.
This is a multiple instance sequence which is called in another sequence. Not sure why this happens.
Thanks & Regards,
Devi
- Thu Oct 20, 2011 3:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal Length
- Replies: 3
- Views: 2682
Decimal Length
Hi All,
I had a very simple question..
I have field of datatype Decimal (15,4)
Can I read a number value of 2774389000000 in this field?
I am trying to understand the Varchar length accepted to read the value.
Thanks
I had a very simple question..
I have field of datatype Decimal (15,4)
Can I read a number value of 2774389000000 in this field?
I am trying to understand the Varchar length accepted to read the value.
Thanks
- Fri Jun 17, 2011 4:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job hangs when performing insert/update
- Replies: 4
- Views: 5288
- Thu Jun 16, 2011 9:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job hangs when performing insert/update
- Replies: 4
- Views: 5288
Job hangs when performing insert/update
Hi All, We are currently facing an issue with our datastage jobs. After performing the required transformations we do a self lookup on the table and then filter records as insert and update. The job has an update and insert flow to perform this. The insert flow using upsert method with the update qu...
- Wed Mar 23, 2011 3:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Rows to Columns
- Replies: 6
- Views: 4672
- Wed Mar 23, 2011 2:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Rows to Columns
- Replies: 6
- Views: 4672
- Wed Mar 23, 2011 1:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Rows to Columns
- Replies: 6
- Views: 4672
Rows to Columns
Hi All, I have a scenario to handle. Please suggest approach to design the job. Input: Column1 Column 2 Column3 4321 X1 3 4321 X2 4 4321 X3 6 Output Required: Column1 Column2 Column3 Column4 4321 3 4 6 The source is dynamic where the column2 and column3 can have new values for Column1 indicating the...
- Tue Mar 22, 2011 11:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamic Decimal Point
- Replies: 2
- Views: 2654
- Tue Mar 22, 2011 12:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamic Decimal Point
- Replies: 2
- Views: 2654
Dynamic Decimal Point
Hi All, I have a scenario where I get the number of decimal points dynamically. For example: If the incoming column value for C1 is 2 then C2 must be multipled by C2*0.01 If the incoming column value for C1 is 4 then C2 must be multipled by C2*0.0001 Basically i need to multiple C2 in this way C2 * ...
- Tue Nov 23, 2010 12:44 am
- Forum: General
- Topic: Email Notification Stage Issue
- Replies: 5
- Views: 4896
Well, I used the attachement option: Please see below with the values given. Senders email address: good4@gmail.com Recipient email address: good4@gmail.com Email Suject: Error and Reprocess Records of Schedule #jp_SchdName# for Batch Number: #$UDV_BATCH_NUM# Attachments: #$UDV_INPUT_DIR#/#jp_SchdNa...
- Mon Nov 22, 2010 8:17 am
- Forum: General
- Topic: Email Notification Stage Issue
- Replies: 5
- Views: 4896
- Mon Nov 22, 2010 1:27 am
- Forum: General
- Topic: Email Notification Stage Issue
- Replies: 5
- Views: 4896
Email Notification Stage Issue
Hi All, I have a email notification stage in the sequence thats sending an attachement to the user. The job aborts with the following message. When i re-run the job again it runs to success and sends the attachment. Any issue with the stage due which this happens? Please advice. PRS_STG_S_ERROR_STAT...