Search found 284 matches
- Fri Jun 11, 2021 7:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Looping through fields in a job while using RTP
- Replies: 1
- Views: 13437
Re: Looping through fields in a job while using RTP
You can read the entire record in a single field as varchar-assign some large field length, then use column import stage and define the schema file and in target sequential stage use '|' delimiter. You must enable RCP at job level. You must have subsequent jobs that reads the above output files, in ...
- Fri Jun 04, 2021 12:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Runtime column propagation
- Replies: 0
- Views: 13037
Runtime column propagation
Hi All, Want to confirm one scenario that I am facing. Currently in DEV environment, RCP is enabled in project level(the check box is ticked in administrator). In QA and Prod environment, the RCP check box is not enabled but the the option extend link propagation(just underneath RCP checkbox is chec...
- Fri Jun 04, 2021 12:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using sql file to insert data in the table.
- Replies: 2
- Views: 14951
Re: Using sql file to insert data in the table.
Hi All,
This issue is resolved. Thanks.
This issue is resolved. Thanks.
- Thu Jun 03, 2021 4:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using sql file to insert data in the table.
- Replies: 2
- Views: 14951
Using sql file to insert data in the table.
Hi All, Have a requirement to load around 10 source data(from sybase) to oracle staging layer as a direct dump. Want to create one single generic job to load the data and use multiinstance to invoke them in sequence level. Enabled RCP at job level. Job Design: ODBC stage--------Transformer stage----...
- Tue Jan 22, 2019 8:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date conversion
- Replies: 6
- Views: 5182
- Tue Jan 22, 2019 8:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date conversion
- Replies: 6
- Views: 5182
- Tue Jan 22, 2019 7:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date conversion
- Replies: 6
- Views: 5182
- Mon Jan 21, 2019 11:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date conversion
- Replies: 6
- Views: 5182
Date conversion
Hi All, I have a requirement to convert input string to date fomat yyyymmdd. Input string is coming as 'yymmdd' format. Ie if input data is 190110, output should be 20190110. I used the following conversion: DateToString( StringToDate(Lnk_TDCO.TRAIL_DATE,"%yy%mm%dd"),"%yyyy%mm%dd"...
- Wed Dec 19, 2018 8:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to access a table from SAS library
- Replies: 0
- Views: 2543
How to access a table from SAS library
Hi All, I have a following requirement. I need to access a Table which is in a SAS SPDS library. Can you kindly guide me how do I connect to the SAS library from datastage to get the data out of that table? Can I use SAS stage to read the table from library? To access SAS library, do I need to have ...
- Tue Dec 18, 2018 8:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Read Binary file from AS400
- Replies: 9
- Views: 7726
- Tue Dec 18, 2018 8:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Junk character in sequential file viewer stage
- Replies: 4
- Views: 9408
- Mon Dec 17, 2018 6:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Junk character in sequential file viewer stage
- Replies: 4
- Views: 9408
Hi Ray, The NLS map is set to Project default(UTF-8). I used following derivation in the transformer and those characters were not seen. Trim(Trim(DSLink3.RDT_ADDL_SEG_KEY_PROD,char(24)),char(26)) I used 24 as Dec representation for hex 18 and 26 is Dec representation for hex 1A. Is that approach ok?
- Fri Dec 14, 2018 8:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Junk character in sequential file viewer stage
- Replies: 4
- Views: 9408
Junk character in sequential file viewer stage
Hi All, I am reading a cobol EBCDIC file using CFF stage and loading it into Sequential file stage. There are 2 fields defined in CFF as PICX(2) and PIC X(1) which is in Record Layout shown as CHARCTER 2 and CHARACTER 1 respectively. I directly mapped those 2 fields to sequential file stage using da...
- Thu Dec 13, 2018 1:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Read Binary file from AS400
- Replies: 9
- Views: 7726
Thanks Frank.. I think this approach will not work for my case as the the binary file is variable length file and if I output as one continuous record then I cant read it...This approach would have worked in case of true Fixed width file. Currently I am reading the file (test file pushed to datastag...
- Thu Dec 13, 2018 11:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Decimal to string conversion
- Replies: 0
- Views: 2475
Decimal to string conversion
Hi All, I am reading binary file(EBCDIC format) through CFF stage and writing to a sequential file in "^" delimited which will be consumed by downstream application. The down stream application will read the file and load as is into a Hive table in HDFS and all the fields type are string. ...