I am trying to bring down Variable block file from Mainframe to the Datastage.
I've tried whole bunch of settings and may be missing something that I cant figure out. Please share your knowledge with this fellow.
Mainframe File is pipe delimited, has Mainframe LRECL=86, and every record ends with pipe.
Tried settings:
---------------
FTP stage:
Record level>>Record Type=varying
Record level>>Record Type>>Format VB
Field defalults:
Tried both:
Delimiter: none
Delimiter: |
Type defaults
General>> Character set=EBCDIC
General>>Data format=binary
Reading file as a Char and have tried both no Length or with 82 length.
Text File which saves the input has following settnigs:
Writing file as Char and have tried with 82 length and without.
Final Del=end
Rec Del=Unix newline
Char.set ASCII
Data format=text
At most I was able to get all the record in one line i guess because DS could not detect what's the end of the line...
Thank you in advance for your time and sincere efforts.
FTP VB File from Mainframe to Datastage
Moderators: chulett, rschirm, roy
The one setting you don't list is Record level>>Record Type=implicit. I've not tried that with a delimiter, but my read of mainframe data works just fine on any table definition I've used so far so long as it conforms to the LRECL setting. Each row fits nicely into the columns and implied widths they have. The rest of my successful attributes:
Field defaults>>Delimter=none
Type defaults>>General>>Character set=EBCDIC, Data format=binary
Type defaults>>Decimal>>allow all zeroes=yes
My expectation is if you set Delimiter=| with the rest, it should work.
Field defaults>>Delimter=none
Type defaults>>General>>Character set=EBCDIC, Data format=binary
Type defaults>>Decimal>>allow all zeroes=yes
My expectation is if you set Delimiter=| with the rest, it should work.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
My man Franklin, you rock! simply the best! thanks a million for helping me out.
I respect your knowledge. Thanks again....
For those who will find this issue later, here is my settings that worked.
FTP Stage:
------------
Record Level>>Record Type=implicit
Field defaults>>Delimiter =| <pipe>
Type defaults>>General>>Character set=EBCDIC, Data format=binary
Specify all the input fields with length, in my case I had to use SQL Type= Varchar and their length.
![Smile :)](./images/smilies/icon_smile.gif)
![Smile :)](./images/smilies/icon_smile.gif)
For those who will find this issue later, here is my settings that worked.
FTP Stage:
------------
Record Level>>Record Type=implicit
Field defaults>>Delimiter =| <pipe>
Type defaults>>General>>Character set=EBCDIC, Data format=binary
Specify all the input fields with length, in my case I had to use SQL Type= Varchar and their length.