DSXchange

TRACKID OFFSET EDIDATA 10 010 010 010 005 AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 10 010 010 004 BBBBBBBBBBBBBBBBBBBBBB 10 010 010 010 010 005 SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS 20 010 010 002 CCCCCCCCCCCCCCCCCCCC 20 010 007 ZZZZZZZZZZZZZZZZZ O/P: For the track id having similar trackid the ...

Hi All, We have two similar groups are split into two xml files.But our datastage job should identify each time whether two xmls of similar group available then only process the records.if only single xml file of that group is available dont process.How to achieve this logic in datastage. For exampl...

What should you be getting, and what format settings are you using? ... Actualy 77° - 9° 10 should come in seperate column and R0403 should come in another column. Am using sequential file format settings for varchar columns using quote as double and delimeter as comma. is there any way to ch...

Hi all, we are getting incorrect allignment for the few rows in csv file when generating using sequential file. Format settings are delimeter as comma, quotes as double. 77° - 9° 10",R0403" 77° - 9° 10",R0403" 77° - 9° 10",R0403" 77° - 9° 10"...

We are generating that files in binary mode and the mainframes is ftp in ascii mode.

Are all of your data columns binary (comp-3, comp, etc.) or do you also have some that are character data? In our layout we are having some columns as comp-3 decimal and some are character.At mainframe end they are FTP using ascii mode.So we are some how unable to see the data in the mainframe. We ...

Hi all, We are generating complex flat file output in which the layout is having the some columns with DECIMAL COMP-3(PIC S9(15) COMP-3.) and Binary COMP(PIC S9(9) COMP.). The output setting used are Characterset as ASCII and Dataformat as Binary. The issues we are facing are 1)In mainframe side whe...

craig

For the integer column having length of four .I queried in the database it has max length of data stored is six.so should i go for the char(6) or any logical conversion is required between integer(4) to determine the character length.

i have in the source Int(4).If i want to convert into char what length should i give.

Yes am using schema file.The problem is with integer and timestamp columns for that how we can use to get fixed width format.

The problem is the integer column data is not all of same length.as am using RCP i cant transform any columns.and for timestamp columns there is no problem if there is null am populating space(26)

yes craig.....

For integers and timsestamp columns what datatype can be used.....

Hi all I need to load the data into flat file as fixed width format,source is a sql server and am using runtime column propagation .But few of the columns in the target are Integer and timestamp.So if i use char data type for integer how much length should i give and for timestamp columns when i use...

Yup its worked...