when i open the *.dat in text pad i can see the data.
If i try to import the table def by sequential file def.. then it is not showing uo the files.
is there any other way to get the meta data...?
Use sequential file option to import the metadata, later use it in your DB stage. If thats what you are looking for.
Is the sequential file fill with actual data or Metadata?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
koolsun85 wrote:when i open the *.dat in text pad i can see the data.
If i try to import the table def by sequential file def.. then it is not showing uo the files.
is there any other way to get the meta data...?
koolsun85,
If you are able to view the data from Mainframe, then it means that it is in ASCII form. However, it doesn't change the fact that it is a Cobol File and its definition (metadata) is obtained from a CFD (Cobol File Definition). Request one, if you don't have it already. If you have one, try importing it using DataStage, the process for which should be quite straightforward!
Hope this helps...
Vivek Gadwal
Experience is what you get when you didn't get what you wanted