Search found 57 matches
- Thu Feb 14, 2019 3:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connector - Deadlock issue
- Replies: 9
- Views: 6779
- Fri Jan 11, 2019 9:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with Unstructured data stage
- Replies: 3
- Views: 3221
- Wed Apr 11, 2018 7:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: COBOL File Issues
- Replies: 3
- Views: 2938
COBOL File Issues
I am trying to read a COBOL file, But i am experiencing '{','}' signs in the data. My options are EBCDIC and Binary. But still seeing these values when i am trying to view the data in output tab. I looked at many post here on DSXCHANGE, but i could'nt figure out the exact answer, Appreciate if someo...
- Thu Sep 07, 2017 6:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading and writing data into csv files?
- Replies: 14
- Views: 12769
- Wed Aug 30, 2017 11:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: YTD BASED ON THE MONTH NUMBER
- Replies: 7
- Views: 5680
- Wed Aug 30, 2017 7:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: YTD BASED ON THE MONTH NUMBER
- Replies: 7
- Views: 5680
A Small correction to my Question With this Data there is another additional field in the input i.e source_lin_ID,So the data is like this Src_lin_id,FSCL_YR,MTH_NUM,AMT 1,1997,1,20 1,1997,2,30 . . . 2,1997,1,30 2,1997,2,40 . . . . 3,1997,1,40 3,1997,2,50 . . . . So the key should be for the SRC_Lin...
- Wed Aug 30, 2017 7:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: YTD BASED ON THE MONTH NUMBER
- Replies: 7
- Views: 5680
- Wed Aug 30, 2017 7:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: YTD BASED ON THE MONTH NUMBER
- Replies: 7
- Views: 5680
- Wed Aug 30, 2017 6:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: YTD BASED ON THE MONTH NUMBER
- Replies: 7
- Views: 5680
YTD BASED ON THE MONTH NUMBER
Hello, My source is Oracle, And i have this columns in my source FSCL yr,MTH_NUM,AMT And my requirement is to calculate the YTD based on the month. So for example if i am in the month num 2, then the YTD should be AMT in Month1 +AMT in month2 If i am in Month 3 then the YTD should be AMT in Month1 +...
- Fri Aug 25, 2017 1:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting Month Name from Column Name
- Replies: 4
- Views: 4320
- Thu Aug 24, 2017 8:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting Month Name from Column Name
- Replies: 4
- Views: 4320
Getting Month Name from Column Name
I have a scenario where I have columns Like REV_ACT_JAN ........ REV_ACT_DEC, I am doing a pivot to store all the columns in one field i.e Amount, And also i have another filed MONTH which should be identified from the Column Name(ex:REV_ACT_JAN then the MONTH field should have 01 and so on) Could s...
- Wed Jul 26, 2017 8:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage Timestamp field into Oracle Date field
- Replies: 1
- Views: 2283
Datastage Timestamp field into Oracle Date field
Is there any way to load the Timestamp field from datastage into Oracle Date field.
- Mon Jul 17, 2017 9:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Excel on AIX server
- Replies: 3
- Views: 2984
- Mon Jul 17, 2017 9:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Excel on AIX server
- Replies: 3
- Views: 2984
Reading Excel on AIX server
Hello,
Is there any way that i can view or read Excel file on AIX server using any commands or script. Is it possible?
Thanks
Deep
Is there any way that i can view or read Excel file on AIX server using any commands or script. Is it possible?
Thanks
Deep
- Tue Jul 11, 2017 7:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Writing to Excel Using unstructured Data Stage
- Replies: 5
- Views: 3606