table definition
Moderators: chulett, rschirm, roy
table definition
i am trying import table definition for cobol file.
i am doing these followng steps, in cff columns tab --load--table defoinitions- import- cobol file definitions--
after that
(Seen from) field has WINDOWSXPPRO
and then i try to insert the path name of cobol file and it cannot find the file residing on the server.
Would appreciate if someone helps me out.
Thanks
i am doing these followng steps, in cff columns tab --load--table defoinitions- import- cobol file definitions--
after that
(Seen from) field has WINDOWSXPPRO
and then i try to insert the path name of cobol file and it cannot find the file residing on the server.
Would appreciate if someone helps me out.
Thanks
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DataStage expects to import from COBOL FD files on the client - the reasoning is that they are most likely to have been emailed to the DataStage developer. So search on the client machine - put them somewhere with a short, easily-remembered pathname, such as C:\COBOL_FD
Tip: When importing from a COBOL FD you must provide the column position of the level 01 item.
Tip: When importing from a COBOL FD you must provide the column position of the level 01 item.
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 need to specify in what column the level 01 item is. Try 8 (a common start column).
However, what you have posted is NOT a COBOL file definition. A CFD is pure text. Does it need to be converted from EBCDIC?
However, what you have posted is NOT a COBOL file definition. A CFD is pure text. Does it need to be converted from EBCDIC?
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.
What you are looking at is data file. Why you need is COBOL Copybook to create metadata and this metadata will be used to read data file using CFF stage. Using CFF stage you can also convert data from BINARY to ASCII.dspxguy wrote:Yes Ebcdic to ASCII
COBOL copybook is a simple text file which you can read using any editor and you need to have this file on your client machine. Data file has to be on the server for DataStage to read it.
Hope it helps..........
Assume everything I say or do is positive