Avatar of rmhambon
rmhambon asked on

HOw do I open a file exported to a PC from an AS400 iseries using iseries navigator

I have exported a portion of a database using  I series navigator into a comma delimited text file to my PC .When I open it, all I get is a bunch of what look like control characters.
What utility can I use to open this exported on my PC.
Databases

Avatar of undefined
Last Comment
mbroeders

8/22/2022 - Mon
Harry_Truman

We use an application called IBM iSeries Access for Windows.  The new version, System i Access (http://www-03.ibm.com/systems/i/software/access/index.html), requires a key to use.  It's been so long since we setup our 400 that I can't remember whether we purchased this seperately (probably did) or if it was included.
Harry_Truman

I'm an idiot.  Didn't see the part where you clearly stated you already use that.  Sorry.

When you installed it, did you install all the features and plugins?  I've made the mistake of leaving out a few different utilities before and have been left high and dry.
ASKER CERTIFIED SOLUTION
rward

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
mbroeders

When databases are created on our system the CCSID is set to 37 by default.  But, I have found if you are creating the database in a query and you create new character fields in the query, that the field CCSID will become 65535 and will cause the whole file to show garbage when transfered using Data Transfer in iSeries Access.  You can view the field details of the file using DSPFFD where it will show the CCSID of the individual field.
One thing you can do if it is a query problem.  You can create the file first using a file description and fill the field as you are running the query.  This will keep the CCSID the same as when it was created.
Your help has saved me hundreds of hours of internet surfing.
fblack61