DAT file
Moderators: chulett, rschirm, roy
DAT file
Hi,
I am having a requirement where i need to read from DAT file and load into DB. As i never dealt with DAT file , can anyone please guide what is the stage that i need to use to read DAT file as can we use sequential file stage or do we need to use CFF stage only, and if we use Sequential file stage do we need to import the Cobol copy book or is it not necessary
Thanks in advance
I am having a requirement where i need to read from DAT file and load into DB. As i never dealt with DAT file , can anyone please guide what is the stage that i need to use to read DAT file as can we use sequential file stage or do we need to use CFF stage only, and if we use Sequential file stage do we need to import the Cobol copy book or is it not necessary
Thanks in advance
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
'DAT' is just an extension. You can take a text file and replace the '.txt' to '.dat'. It does not matter, a sequential file stage will be able to read it as long as you have the right metadata.
Now what matters is the content, if its not an ascii file or is an ascii file but was generated by mainframe (dataset) then you will need a cff stage to read it properly as the metadata may differ.
Now what matters is the content, if its not an ascii file or is an ascii file but was generated by mainframe (dataset) then you will need a cff stage to read it properly as the metadata may differ.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
You do not absolutely need to use a cff stage whenever a file is created by a mainframe. Handling OCCURS DEPENDING ON clauses is handy with cff, as are a few other items. A typical sequential file with a fixed number of columns can usually be handled with only a Sequential File stage...did it plenty of times in 7x.
Regards,
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
In other words, only you rsunny can determine if you'll be fine processing this particular "dat" file with the sequential file stage. You know what it looks like, how the fields are defined - we don't. If you're not positive you know exactly how each field is defined, get back together with whomever is supplying you this file, work out your doubts.
Once you have that information you can work out how to process the file.
Once you have that information you can work out how to process the file.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers