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.
Sequential File Layout to datastage table def's
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
{
Name:string[1];
Address:string[max=80];
City:string[max=80];
}
Is Name really Char(1) data type?
Last edited by ray.wurlod on Tue Sep 18, 2012 8:38 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.