DSXchange

But he isn't seeing "00A", he's seeing "{00". The leading hex value C1 which represents "this digit is zero, but the whole number is positive", and is also an "{" character in EBCDIC, has been converted to an ASCII "{" character, so there's a hex va...

They're part of the Packed classification of the Decimal data type, which includes zoned and overpunch and which allows you to specify whether the 'sign' is leading or trailing. I am now able to see the output using below option character set =ASCII Data format=Text record delimeter = \n byte order...

Yes, you should be able to use the CFF for this, provided you know the data types. Did you try ASCII yet, do things look better when you do? if we use a CFF stage, then how to specify the decimal properties which phil suggested, no overpunch and leading .I dont see such options in a cff stage.Moreo...

PhilHibbs wrote:Looks like Decimal values, with a Signed property of "No (overpunch), leading"

Phil

Can we use a cff stage for this or use a sequential file instead

Chulet

Would you please throw some light what kind of data is this ?

If it's sent in ASCII format, why are you defining it as EBCDIC? There are many columns with values like "{0000000{00{00{00{00{00{00{00{00{00{00{0000000000000000{0000000000000000{0000000000000000{0000000000000000{0000000000000000{0000000000000000" Aren't these EBCDIC values.So we have def...

If it's sent in ASCII format, why are you defining it as EBCDIC? There are many columns with values like "{0000000{00{00{00{00{00{00{00{00{00{00{0000000000000000{0000000000000000{0000000000000000{0000000000000000{0000000000000000{0000000000000000" Aren't these EBCDIC values.So we have def...

Hi we are using a cff stage for reading a mainframe file which is sent in ASCII format. We are using the below properties in CFF stage byte order:native endian character set=EBCDIC data format=text record delimiter=\n While viewing or writing the output to a file, we see only junk characters like ??...

Hi While reading a mainframe file i am getting below error >##E TOIX 000227 09:10:51(002) <cffRequest,0> Trouble importing field "FILLER_3"; data: {0 { 0 0 { 0 0 { 0 0 { 0 0 { The filler_3 is defined as 07 FILLER PIC S9(09) COMP VALUE 6380. record options are data format = text character s...

We are going against Attunity database. Attunity is a change capture tool.

we have recently applied the below patch on datastage parallel edition 7.5 patch_118136 - PROBLEM REPORTED "DB2 operators do not support parallel execution against range partitioned tables" After applying the patch we are getting the below errors 1. db2CUST_IP_INTERFACE_HEWsel,0: Fatal Err...

We are facing a problem in our Production on daily basis. There are few jobs which are failing on day to day basis because of error, main_program: [DataDirect][ODBC lib] Function sequence error. And these jobs are getting over successfully after re run. The jobs are scheduled in control M. It is obs...

Hi, we have a scenario where in many datastage jobs in production run quite slow as compared to other days. Some jobs also fail only on Tuesday with the error below ============================================= main_program: APT_PMsyncWithSectionLeaders: non-zero status 1 from APT_PMpollUntilZero. =...

Hi I am extarcting data from a table in oracle. One of the column is having a datatype as TIMESTAMP(6) WITH LOCAL TIME ZONE. When i query the oracle at sqlplus promt i get the column value as select Open_date from open_tckt where ref_num = 'IN26' 2 / OPEN_DATE ---------------------------------------...

I saw it in couple of posts on dsexchange but could not find in parallel..one more thing is there is only one column so we cannot set the contains terminator property for this as we need some record delimeter column