AS/400 iSeries FTP

[tomholden]

when i ftp to the iSeries with Core the data always gets into binary or ascii mode. the iseries is an EBCDIC machine. normal FTP via DOS, etc. automatically converts from ascii to ebcdic. I tried using the post login script/cmds to set the session to ebcdic but no luck. is there a way around this? We're on V5R3 of the iSeries OS and running Win XP Pro on the PC. maybe an ebcdic mode transfer should be added??

[tomholden]

i've tried using AS/400 as the server type & auto. neither one performs the translation properly. I'd vote for adding the EBCDIC mode.

[misslexi]

I just upload a file from v5r3 in the default Binary mode and sure enough it landed in EBCDIIC on my PC. Changed transfer mode to ASCII and it uploaded fine. See snippets below. BTW, you probably know that native packed and binary data type will not translate using ftp.

Binary:
±≡Φ≡≡Φ°∙@Φ@≡≡≡≡≡≡≡≡≡╤∙∙∙÷┴┬ΣΓ┼─@╙╔╒┼╒@@@@≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡∙≡≡≡
≡≡≡≡≡≡≡≡≡≡≡≡≡±≡≥≡≡≡≡≡≡Φ≡≡Φ∙∙@Φ@≡≡≡≡≡≡≡≡≡╤∙∙∙≈┘┼╫╙┴├┼╘┼╒π@@@@@≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡
≡≡≡≡≡≡≡≡≡≡≡≡∙≡≡≡≡@@≡≡≡≡≡≡≡≡≡≡≡≡≡≡±≡≥≡≡≡≡≡≡Φ≡≡Φ∙∙@Φ@≡≡≡≡≡≡≡≡≡╤∙∙∙°π┼╘╫╓┘┴┘Φ@┘
╙≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡∙≡≡≡≡@@≡≡≡≡≡≡≡≡≡≡≡≡≡≡±≡≥≡≡≡≡≡≡Φ≡≡Φ∙∙@Φ@≡≡≡≡≡
╤∙∙∙∙πa┘┼╒π@Γ╚╓┘π┴╟┼@≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡∙≡≡≡≡@@≡≡≡≡≡≡±≡≡≡≡≡≡≡±≡≥
±≡Φ≡≡Φ∙∙@Φ@≡≡≡≡≡≡≡≡≡
C:\>

Ascii:
J9997REPLACEMENT 000000000000000000000000000000090000 000000000000001020000
00Y00Y99 Y 000000000
J9998TEMPORARY RENTAL000000000000000000000000000000090000 000000000000001020000
00Y00Y99 Y 000000000
J9999T/RENT SHORTAGE 000000000000000000000000000000090000 000000100000001020000
10Y00Y99 Y 000000000
C:\>

[tomholden]

I just upload a file from v5r3 in the default Binary mode and sure enough it landed in EBCDIIC on my PC. Changed transfer mode to ASCII and it uploaded fine. See snippets below. BTW, you probably know that native packed and binary data type will not translate using ftp.

Binary:
±≡Φ≡≡Φ°∙@Φ@≡≡≡≡≡≡≡≡≡╤∙∙∙÷┴┬ΣΓ┼─@╙╔╒┼╒@@@@≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡∙≡≡≡
≡≡≡≡≡≡≡≡≡≡≡≡≡±≡≥≡≡≡≡≡≡Φ≡≡Φ∙∙@Φ@≡≡≡≡≡≡≡≡≡╤∙∙∙≈┘┼╫╙┴├┼╘┼╒π@@@@@≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡
≡≡≡≡≡≡≡≡≡≡≡≡∙≡≡≡≡@@≡≡≡≡≡≡≡≡≡≡≡≡≡≡±≡≥≡≡≡≡≡≡Φ≡≡Φ∙∙@Φ@≡≡≡≡≡≡≡≡≡╤∙∙∙°π┼╘╫╓┘┴┘Φ@┘
╙≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡∙≡≡≡≡@@≡≡≡≡≡≡≡≡≡≡≡≡≡≡±≡≥≡≡≡≡≡≡Φ≡≡Φ∙∙@Φ@≡≡≡≡≡
╤∙∙∙∙πa┘┼╒π@Γ╚╓┘π┴╟┼@≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡≡∙≡≡≡≡@@≡≡≡≡≡≡±≡≡≡≡≡≡≡±≡≥
±≡Φ≡≡Φ∙∙@Φ@≡≡≡≡≡≡≡≡≡
C:\>

Ascii:
J9997REPLACEMENT 000000000000000000000000000000090000 000000000000001020000
00Y00Y99 Y 000000000
J9998TEMPORARY RENTAL000000000000000000000000000000090000 000000000000001020000
00Y00Y99 Y 000000000
J9999T/RENT SHORTAGE 000000000000000000000000000000090000 000000100000001020000
10Y00Y99 Y 000000000
C:\>

yep i know about packed data
my issues are going from PC to iSeries....

[misslexi]

I used ASCII transfer...

File . . . . . . : ITMTST Library . . . . : QGPL
Member . . . . . : ITMTST Record . . . . . : 860
Control . . . . . B Column . . . . . : 1
Find . . . . . . .
*...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+...
J9920CHARGE,SHARPS 000000000000000000000000000000090000 0000001000000049900
J9985CHARGE SORTING 000000000000000000000000000000090000 0000000000000049900
J9986CHARGE SHIPPING 000000000000000000000000000000090000 0000000000000049900
J9987CHARGE RETD CK 000000000000000000000000000000090000 0000000000000049900
J9988CHARGE LATE/INT 000000000000000000000000000000090000 0000000000000049900
J9989CHARGE INVC REPL000000000000000000000000000000090000 0000000000000049900
J9992SERVICE CHARGE 000000000000000000000000000000090000 0000001000000049900
J9993L/S CHARGE 000000000000000000000000000000090000 0000001000000049900
J9994INV. SHORTAGE 000000000000000000000000000000090000 0000000000000010200
J9995MISC. SALE 000000000000000000000000000000080000 0000001000000010200
J9996ABUSED LINEN 000000000000000000000000000000090000 0000000000000010200
J9997REPLACEMENT 000000000000000000000000000000090000 0000000000000010200
J9998TEMPORARY RENTAL000000000000000000000000000000090000 0000000000000010200
J9999T/RENT SHORTAGE 000000000000000000000000000000090000 0000001000000010200
****** END OF DATA ******
Bottom

[tomholden]

still haven't resolved this...but i haven't had time to look at it. i have been able (at another client site) to transfer files successfully. it could be some little setting somewhere i don't have set correctly. i'll keep playing with it as time permits & will post my findings after i get this going...