DSXchange

major

Hi,

This error is related to Teradata.

BULK load uses worktable to load first before loading to actual table.
So , in your case the actual table must exist in db before job establishes connection to Teradata db for loading.

Thanks
major

major

Hi, xmlns:soapenc="http://xmlsoap.org/soap/encoding" xmlns:wsdl="http://xmlsoap.org/wsdl/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" The above description in your xml is a namespace , which has to be dec...

major

Hi,

Why can't you combine two files and start generating SERIAL after that ?

Thanks
major

major

Before loading the xml into Teradata, try to write into a file and see.

If everything is ok, change the data element in the meta data as 'XML'.

Thanks
major

major

Arnd : The OConv and IConv resulted the same number. But when i extract the equivalent character for the decimal to ASCII.. I can able to extract it. But from Ascii to EBCIDIC could not retrieve the exact character.

major

Thanks Arnd!. When i tried with "ASCII(ICONV("C9","MX"))" I'm getting some garbage values instead of 'I'. I tried with ASCII(Char(ICONV(Arg1,"MX")) -- It returns the value as Ci instead of I. Is there any options to convert this from EBZeeDIC Hex to EBZeeDic C...

major

Thanks Arnd & Craig. I am trying it make simple as per your suggestions. I have used Basic transformer to translate the Hex to equivalent EBCDIC character. Below are the steps : ICONV(VAR, 'MX') -- Returns the Decimal value of the Hex code Char() -- Returns the equivalent Ascii character value A...

major

Thanks Craig for looking into this. Requirement : I have a column from DB2 which has converted from Timestamp to Hexadecimal (16). The column has again suppressed into char( 8 ) for the target database (ADABAS) which has EBCDIC charset. Whenever i perform insert in datastage, this column has resulte...

major

Is there any way to convert EBCDIC hexadecimal Code to EBCDIC related character in Datastage?

For example : C9 ---> I

major

Hi all,

Issue was ETL has 2 physical nodes and the source directory from which the job reads is not mounted on node 2.
Since the files are in node 1 directory and node 2 source directory is not mounted, job was failing because unable to find directory or files on node 2

Thanks
major

major

Hi, I have a job as follows ExternalSource------->XML Stage-------------->Datastage I have parameterized unix source dir and path . Job is working fine in Dev environment . I have moved job to Test environment and placed respective files in source dir with 777 permissions, and I can "see" ...

major

Thanks Ray , thought so.

major

Thanks Eric. Tried with the CFS log for this specific error. It has provided sql error code which was already indicated in the DS log.

'SQLCODE(-817) on line 0 in unknown '

This might be some configuration issue. We are still investigating further.

major

I'm getting the below error when ever i am updating the two different target tables in DTS stage. The Distributed Transaction Stage has detected that the error threshold of 1 has been met. The count of units of work that failed is 1. SQL-Error-Message. -817. An update is prohibited. A two-phase-comm...

major

Hi,

A silly one but is sparse lookup equivalent to Inner join or Left outer join ? I can do a POC and find out but I'm away from PC for couple of days

Thanks
Major

DSXchange

Search found 166 matches

Convert EBCDIC Hexcode to EBCDIC Character

CDIER0410E error in xml stage

2 Phase commit issue in DTS Stage

Sparse lookup is equivalent to which job