DSXchange

Is there any way converting file layouts in excel to sequential file definitions in datastage

I have like following:

Name CHAR 1
Address CHAR 80
City CHAR 80

What I do so far is just copy column names in another sheet as a single row and export as delimited file then manually select data type and enter lengths

Any help is appreciated,
Thank you.

You could slightly modify your process to produce a schema file.

{
Name:string[1];
Address:string[max=80];
City:string[max=80];
}

Is Name really Char(1) data type?

Thank you for the reply, I have filters used while reading a file. If I use schema file then I am not able to use filter scripts.

You did not state that in your original questions. I can only read minds at short range.

While creating table definitions in the DS_METADATA table is possible, it is not for the faint-hearted. There are 156 columns in this table, but the file dictionary only specifies the first five. The remainder of the record structure is not published.

ray.wurlod wrote:You did not state that in your original questions. I can only read minds at short range.

Always suspected... now confirmed.