How to specify OFFSET for each field(Fixed width file)

[venki]

Hi,
I am new to PROFILING,
Now i am preparing QETXT.INI for fixed width file.
My query is how to specify OFFSET for each field.

Eg:- My file structure is
02T20 2034UKLUN02458632


FIELD1=IND,VARCHAR,<Precision>,<Scale>,<Length>,<Offset>

Can any one have idea how to specify offset of a perticular field, please suggegt me.

Thanks in advance.

[venki]

I have solved this problem,

This offset should be the STARTING position of the field name.

For E.g,
02ven1234123456yhhhyyuui

Field1=IND,VARCHAR,2,0,2,0,
FIELD2=NAME,VARCHAR,3,0,3,2,...

[venki]

Hi,

I have another reqirement. Now Source file is XML.
How to read XML metadata into PROFILING.

I have an idea of reading flat files, for this we have created .txt and QETXT.INI files in particular folder.
Like that how to read XML metadta.

Can some one help me....


Thanks in advance.