Solved

Converting AS400 file with packed Decimal fields to ASCII

Posted on 2004-09-26
7
1,177 Views
Last Modified: 2008-01-09
Team,

I am in need for a suitable tool which can do the converstion from AS400 EBCDIC to Windows ASCII and vis versa from command prompt. I don't have CA and I can't buy expensive tools.

If there is a way to have a direct socket connection (either through ODBC or JDBC) that will be ok but I need the suitable driver and I don't want to buy Microsoft HIS for example.

Appreciate your quick response.

Thanks in advanced
0
Comment
Question by:Jablif
  • 3
  • 2
7 Comments
 
LVL 6

Expert Comment

by:dedy_djajapermana
ID: 12154747
hi,

use windows FTP that:
1. do remote execute CPTOIMPF; CPYTOIMPF will convert packed decimal to normal decimal. You can test the command first.
2. GET the result of the CPYTOIMPF

Please let me know if you need example.
0
 

Author Comment

by:Jablif
ID: 12157684
Hi Dedy,

Thanks for your reply.

Actually, I appreciate if you give the example so I better execute it.

Thanks again
0
 
LVL 6

Accepted Solution

by:
dedy_djajapermana earned 500 total points
ID: 12157988
hi

supposed you have PFILE in library LIBRARY
first, create a folder to contain the temporary converted file, e.g., CRTFLR FTPTMP

on the PC:
create a text file named FTP.SRC with notepad with content like this:
qsecofr
passwordofQSECOFR
quote rcmd CPYTOIMPF FROMFILE(LIBRARY/PFILE) TOSTMF('/qdls/ftptmp/PFILE.csv') MBROPT(*REPLACE) RCDDLM(*CRLF)
get /qdls/ftptmp/PFILE.csv
quit

----end of FTP.src file

then on the command line (assumed that the fTP.src is in the same directory):
C:>ftp -s:ftp.src xxx.xxx.xxx.xxx
(xxx.xxx.xxx.xxx is your as/400 IP address)
the file is downloaded as PFILE.csv in your directory

0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 6

Expert Comment

by:dedy_djajapermana
ID: 12158280
hi dave,

note that i put cpytoimpf, and ftp the CPYTOIMPF'ed file, not the file with packed field.

dd
0
 

Author Comment

by:Jablif
ID: 12158401
Thanks a lot Dedy I will try that then will let you know the result.

Hi Dave,

I have read the mentioned thread but it was talking about either using CA or MS HIS. I don't have them both.

0
 
LVL 14

Expert Comment

by:daveslater
ID: 12158632
Hi  dedy_djajapermana

sorry, I did not see that bit. It iis best to go with  dedy_djajapermana  solition and ignore my comment as it will over complicate things

dave

0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
as400 calendar 2 169
Read spool files from iseries in C# 4 272
convert constant to free form 1 81
Monitoring IBM System x through PRTG 7 132
The question appears often enough, how do I transfer my data from my old server to the new server while preserving file shares, share permissions, and NTFS permisions.  Here are my tips for handling such a transfer.
This problem is more common than not and I will show you some things to check to solve this problem.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question