DSXchange

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

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...

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...

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...

1. Source is Oracle; Target is DB2
2. loading with minimal transformation
3. update or Insert

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...

Hi, I imported the XSD to the schema library. Then in the XML document I made reference to it as follows: <ROOT xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="TEST.xsd"> <HDR><FIELD1>ABC</FIELD1></HDR> <DTL><FIELD2>123</FIELD2></DTL> </ROOT> ...

Thanks. I'll try that out.

Thanks for your response. Is it sufficient to define the location of the XSD schema in the XML Input Stage and not in the XML document or is it a must that it has to be specified in the XML document ? XSD is defined as follows: <?xml version="1.0" encoding="utf-8"?> <xs:schema xm...

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 ...

It's TIMESTAMP in db2.

The value in the db is 2012-01-15 01:15:14.3

If I don't use the substring function, the format received is as follows:

YYYY-MM-DD HH:MM:SS.ssssss (I need to have a '-' separator between the date and time).

Thanks.

(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

Thanks. We are currently checking with IBM on this issue.

I have checked and the column meta deta is exactly the same. Yes, I am using a custom SQL.