Hi
Our Source Sequential files have "pipe" as the field delimiter and "comma" as the record delimiter.
The Source File contains 50+ columns
How do we import the defition using the manager, we wud not want to opt for a manual specification of the field/record delimiter, colulmn length etc
Thnx
Importing Sequential File MetaData Defintion
Moderators: chulett, rschirm, roy
-
Veena K Urs
- Participant
- Posts: 1
- Joined: Wed Dec 21, 2005 7:15 am
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard. :D
Import IS a manual proecss. During import you specify the file's pathname manually, and then its format (in your case the delimiter character, the quote character and whether the first line is column headings). You keep clicking on Preview until the display makes sense, then move on to define the field names, correct DataStage's guesses as to data types, and add data elements (if desired) and descriptions for each column.
Import IS a manual proecss. During import you specify the file's pathname manually, and then its format (in your case the delimiter character, the quote character and whether the first line is column headings). You keep clicking on Preview until the display makes sense, then move on to define the field names, correct DataStage's guesses as to data types, and add data elements (if desired) and descriptions for each column.
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.