We checked with IBM support.
1. The ETL jobs will work ok without any changes in DataStage v11.3
2. DataStage v11.3 supports only up to DB2 database version 10.5
Search found 221 matches
- Thu Jun 01, 2017 2:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Upgrading to 11.3 from 8.7
- Replies: 4
- Views: 17540
- Tue May 30, 2017 8:15 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Upgrading to 11.3 from 8.7
- Replies: 4
- Views: 17540
Upgrading to 11.3 from 8.7
Hi, We are currently planning to upgrade from DataStage v8.7 to v11.3. I would appreciate your advice on the following: 1. Will ETL jobs in v8.7 with DB2 UDB Load stage, work without changes in v11.3? 2. will the DB2 UDB Load stage be able to connect to external DB2 database v11.1 ? If otherwise any...
- Tue Jul 26, 2016 9:58 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Having issues reading XML files with line breaks
- Replies: 5
- Views: 8391
Having issues reading XML files with line breaks
Hi All, I am trying to read the contents of an XML file in to a Text File but encounter error when there is a line break in the XML file. Job Design XML Source File -> XML Input Stage -> Transformer -> Text File The job works fine when there is no line break within the XML fields. However, when ther...
- Fri May 15, 2015 3:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Recommended method to Extract and Load from source DB
- Replies: 8
- Views: 8857
Re: Recommended method to Extract and Load from source DB
Thanks for your inputs. However considering if there is any recovery required in case of a job failure (for e.g. special character in the source record and row is rejected during loading), wouldn't it be more efficient to amend the sequential file rather than the source DB (which may belong to an ex...
- Fri May 15, 2015 3:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Recommended method to Extract and Load from source DB
- Replies: 8
- Views: 8857
Re: Recommended method to Extract and Load from source DB
1. Source is Oracle; Target is DB2
2. loading with minimal transformation
3. update or Insert
2. loading with minimal transformation
3. update or Insert
- Thu May 14, 2015 2:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Recommended method to Extract and Load from source DB
- Replies: 8
- Views: 8857
Recommended method to Extract and Load from source DB
Hi, I would like some advice on which of the following methods is recommended to extract data from source DB and load to target DB with minimal transformation. Option A - Step 1: Extract from Source DB to Text File via Shell Script / SQL Step 2: Load the contents of Text File (from Step 1) to Target...
- Mon Jan 27, 2014 12:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: unable to validate Input XML
- Replies: 11
- Views: 8354
- Thu Jan 23, 2014 8:17 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: unable to validate Input XML
- Replies: 11
- Views: 8354
- Thu Jan 23, 2014 6:59 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: unable to validate Input XML
- Replies: 11
- Views: 8354
- Thu Jan 23, 2014 5:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: unable to validate Input XML
- Replies: 11
- Views: 8354
unable to validate Input XML
Hi All, I am unable to validate the input XML in a job which extracts data from a XML source file and subsequently converts the information to a text file (with Header repeated for Details). Job Design: XML Source File -> XML Input Stage -> Transformer -> Text File In the XML Input Stage the option ...
- Sun Jan 27, 2013 8:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Corvertiion > Timestamp to YYYY-MM-DD-HH:MM:SS.ssssss for
- Replies: 5
- Views: 4721
- Sun Jan 27, 2013 6:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Corvertiion > Timestamp to YYYY-MM-DD-HH:MM:SS.ssssss for
- Replies: 5
- Views: 4721
- Sat Jan 26, 2013 9:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Corvertiion > Timestamp to YYYY-MM-DD-HH:MM:SS.ssssss for
- Replies: 5
- Views: 4721
Corvertiion > Timestamp to YYYY-MM-DD-HH:MM:SS.ssssss for
(a) Source: DB2 UDB Database
(b) Target : Sequential file
(c) Objective: Timestamp value to be represented in YYYY-MM-DD-HH:MM:SS.ssssss format
(b) Target : Sequential file
(c) Objective: Timestamp value to be represented in YYYY-MM-DD-HH:MM:SS.ssssss format
- Wed Jun 08, 2011 5:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup not working as expected
- Replies: 5
- Views: 4106
- Wed Jun 01, 2011 8:13 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup not working as expected
- Replies: 5
- Views: 4106