DSXchange

Hi,

I have the following fixed length input :

Input :

Q0009814 TEST DATA 500000P

I would like to extract 3 columns from the below fixed length record file.

Col1 - Q0009814
Col2 - TEST DATA
Col3 - 500000P

and I want to mention my Record Length = 40 and length of Col1,Col2,Col3 are 18,15,7 respectively.

How do I set that in Sequential file stage.I can find 'Record Length' (will that be 'fixed' or 40), but not 'Field Length'.

Thanks

read the whol record as char (40) and then concatenate into three columns.

How to do that

instead of three, just define one column as char (40).

Define delimiter and quote character as none and read your source file.

After that how to separate them into three fixed width columns

I want to know if we can read a fixed widht file using the schema file ..........my problem is i get data from different locations and the schema for each of them is different.......i want to read data from any source just by changing the schema file ....i could do that for a comma delimited file ........i want to know if we can do that for a fixed width file

How do we handle data from different locations (with different metadata) with schema files.Do we have schema file as parameter or schema file with RCP.

sgubba wrote:I want to know if we can read a fixed widht file using the schema file ..........my problem is i get data from different locations and the schema for each of them is different.......i want to read data from any source just by changing the schema file ....i could do that for a comma delimited file ........i want to know if we can do that for a fixed width file

you will have to read all the files in seperate stages. In case you want to process them in same job, you will have to be more specific. Send us examples of 2-3 files that you will get so that we can explaind the solution to you.

there is no stage that allows that or schema cannot be read from any text file. you will have to logically implement it

Yeah i am able to do it now...Assume In a fixed file lenght format column NAME is at position from 1-10 for one source data file ....and the same column "NAME" is at position 200-210 for another source data file ....i should be able to read any kind of source data file by just changing the schema file.I am using a column import to break a record into differnt columns by using schema file ....i was able to do it by field delimiter ....now i am able to read it for a fixed lenght filed format

mydsworld wrote:Hi,

I have the following fixed length input :

Input :

Q0009814 TEST DATA 500000P

I would like to extract 3 columns from the below fixed length record file.

Col1 - Q0009814
Col2 - TEST DATA
Col3 - 500000P

and I want to mention my Record Length = 40 and length of Col1,Col2,Col3 are 18,15,7 respectively.

How do I set that in Sequential file stage.I can find 'Record Length' (will that be 'fixed' or 40), but not 'Field Length'.

Thanks

As you import the table definition check the "Fixed width" check box on the Format tab, then enter 18,15,7 in the column widths field. Select the Define tab and note that the widths are recorded as "Display width". Make any other required changes, such as addition of data elements and descriptions, and click OK to save the table definition into the Repository.
Use it from there.