Read EBCDIC file layout in Datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 30
- Joined: Tue Sep 08, 2009 4:24 am
Read EBCDIC file layout in Datastage
Hi,
We have received an Layout file of an ebcdic file. We can open the layout file in textpad to view the column and its details.
Can anyone please let me know, how can we import the layout file in Datastage to load the column details of the ebcdic file.
Thnx
Arpana
We have received an Layout file of an ebcdic file. We can open the layout file in textpad to view the column and its details.
Can anyone please let me know, how can we import the layout file in Datastage to load the column details of the ebcdic file.
Thnx
Arpana
-
- Premium Member
- Posts: 36
- Joined: Wed Dec 27, 2006 3:50 am
- Location: Phoenix
-
- Participant
- Posts: 30
- Joined: Tue Sep 08, 2009 4:24 am
-
- Premium Member
- Posts: 36
- Joined: Wed Dec 27, 2006 3:50 am
- Location: Phoenix
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Probably your COBOL FD has the level 01 item (A margin) other than in column #8 (the default). You have to tell the importer in which column the level 01 item appears.
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: 30
- Joined: Tue Sep 08, 2009 4:24 am
Some file portion:
***** ABC TESTING ***** 20/08/10 at 3:43 pm
SY039 F I L E L A Y O U T U T I L I T Y Page.: 1
Library: PLDUSRA File: YELBOK Selection: YELBOK____
*USRLIBL__
Record : RYELBOK Text: YEL Book
Length : 349 Type: Physical file Access path: Keyed FIFO Unique
__Field_text_____________________Key_#__Field_name__Start__End__Typ__Len__Dec_
| | | | | | | | |
| Branch | 01 A | BRK | 1 | 2 | A | 2 | |
| | | | | | | | |
| Product Type | 02 A | TYK | 3 | 5 | A | 3 | |
| | | | | | | | |
| Number | 03 A | NOK | 6 | 12 | S | 7 | 0 |
***** ABC TESTING ***** 20/08/10 at 3:43 pm
SY039 F I L E L A Y O U T U T I L I T Y Page.: 1
Library: PLDUSRA File: YELBOK Selection: YELBOK____
*USRLIBL__
Record : RYELBOK Text: YEL Book
Length : 349 Type: Physical file Access path: Keyed FIFO Unique
__Field_text_____________________Key_#__Field_name__Start__End__Typ__Len__Dec_
| | | | | | | | |
| Branch | 01 A | BRK | 1 | 2 | A | 2 | |
| | | | | | | | |
| Product Type | 02 A | TYK | 3 | 5 | A | 3 | |
| | | | | | | | |
| Number | 03 A | NOK | 6 | 12 | S | 7 | 0 |
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 30
- Joined: Tue Sep 08, 2009 4:24 am
-
- Premium Member
- Posts: 36
- Joined: Wed Dec 27, 2006 3:50 am
- Location: Phoenix
-
- Participant
- Posts: 30
- Joined: Tue Sep 08, 2009 4:24 am
-
- Premium Member
- Posts: 36
- Joined: Wed Dec 27, 2006 3:50 am
- Location: Phoenix
Looks like you have a pipe delimited sequential file. try getting rid of the below portion before reading the entire file.
***** ABC TESTING ***** 20/08/10 at 3:43 pm
SY039 F I L E L A Y O U T U T I L I T Y Page.: 1
Library: PLDUSRA File: YELBOK Selection: YELBOK____
*USRLIBL__
Record : RYELBOK Text: YEL Book
Length : 349 Type: Physical file Access path: Keyed FIFO Unique
__Field_text_____________________Key_#__Field_name__Start__End__Typ__Len__Dec_
-
- Participant
- Posts: 30
- Joined: Tue Sep 08, 2009 4:24 am
Modified the file as below but the same error.
| Branch | 01 A | POLBRK | 1 | 2 | A | 2 | |
| | | | | | | | |
| Product Type | 02 A | POLTYK | 3 | 5 | A | 3 | |
| | | | | | | | |
| Number | 03 A | POLNOK | 6 | 12 | S | 7 | 0 |
Can you please let me know what is the expected format when seen in textpad.
| Branch | 01 A | POLBRK | 1 | 2 | A | 2 | |
| | | | | | | | |
| Product Type | 02 A | POLTYK | 3 | 5 | A | 3 | |
| | | | | | | | |
| Number | 03 A | POLNOK | 6 | 12 | S | 7 | 0 |
Can you please let me know what is the expected format when seen in textpad.
-
- Premium Member
- Posts: 36
- Joined: Wed Dec 27, 2006 3:50 am
- Location: Phoenix
From the designer Use Import>Table Definitions>Sequential File Definitions
Select directory containing your modified file and sucessively the file and then check the format which comes then by default edit the metadata where required and save it. Use sequential file stage then to read the modified file with the metadat saved.
Select directory containing your modified file and sucessively the file and then check the format which comes then by default edit the metadata where required and save it. Use sequential file stage then to read the modified file with the metadat saved.
-
- Participant
- Posts: 30
- Joined: Tue Sep 08, 2009 4:24 am
The modified file is as below:
| Branch | 01 A | POLBRK | 1 | 2 | A | 2 | |
| | | | | | | | |
| Product Type | 02 A | POLTYK | 3 | 5 | A | 3 | |
| | | | | | | | |
| Number | 03 A | POLNOK | 6 | 12 | S | 7 | 0 |
When i try to import the file as sequential file definition, by default in the format tab, all the checkboxes are unchecked ; except delimeter is defaulted to comma.
But when i try to see the metadata in define's tab, i can see only 1 column Field001. But when i try to load he table definition in Complex flat file stage it prompts no rows returned. But the file is of 20000 bytes
When i update teh delimeter to |, i can see 10 fields. But when i try to load he table definition in Complex flat file stage it prompts with below error:
##E IIS-DSEE-TOIX-00179 13:00:52(010) <I90_ADRCLM,0> Import error at record 1.
Thanks
| Branch | 01 A | POLBRK | 1 | 2 | A | 2 | |
| | | | | | | | |
| Product Type | 02 A | POLTYK | 3 | 5 | A | 3 | |
| | | | | | | | |
| Number | 03 A | POLNOK | 6 | 12 | S | 7 | 0 |
When i try to import the file as sequential file definition, by default in the format tab, all the checkboxes are unchecked ; except delimeter is defaulted to comma.
But when i try to see the metadata in define's tab, i can see only 1 column Field001. But when i try to load he table definition in Complex flat file stage it prompts no rows returned. But the file is of 20000 bytes
When i update teh delimeter to |, i can see 10 fields. But when i try to load he table definition in Complex flat file stage it prompts with below error:
##E IIS-DSEE-TOIX-00179 13:00:52(010) <I90_ADRCLM,0> Import error at record 1.
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: