DSXchange

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.

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.

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.