[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Converting AS400 file with packed Decimal fields to ASCII

Posted on 2004-09-26
7
Medium Priority
?
1,212 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

As much as Microsoft wants to kill off PST file support, just as they tried to do with public folders, there are still times when it is useful or downright necessary to export Exchange mailboxes to PST files. Thankfully, it is still possible to e…
Tech spooks aren't just for those who are tech savvy, it also happens to those of us running a business. Check out the top tech spooks for business owners.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

656 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