Problem with AS/400 data transfer to Excel
I have been downloading AS400 query files to Excel spreadsheets for many years using the Data Transfer utility in Client Access. There has never been any problem. Now suddenly all of the output data has started transferring to Excel as long hexadecimal strings and is unusable. I asked the IT folks if anything had changed [...]

Answer Question   |  September 13, 2011  11:22 PM
AS/400 Data File, AS/400 data transfer, AS400 Hex Invalid data, Client Access, excel, Exporting AS/400 to Excel

Character or line length when printing AS/400 spool file
I wish to create a spool file on and AS400 Iseries and send that file to a pdf printer without it compressing the print to force the original 132 character line to fit on an 80 column paper. The report has overprinting and is only 80 characters per line.

Answer Question   |  November 4, 2010  4:27 PM
AS/400 PDF, AS/400 printing, AS/400 Spool Files, AS400 Hex Invalid data, iSeries printing, Spool files

CL Parameter Problem
Hello All, I have a Net.Data macro that calls a CL program to do some processing. We have two iSeries: Dev and Prod Using the same code on Dev as is on Prod, the production CL program is getting the parameter values a different way. When you put the programs into debug, Here’s what one [...]

Answer Question   |  July 15, 2010  3:54 PM
AS/400, AS400 Hex Invalid data, CL Parameters, iSeries, net.data

Users inputting invalid data
Our users are inputting invalid characters to a narratve field. When the supervisors go to approve what they input they canno as they get a message saying the field has non-displayable chars. How can we stop this?

Answer Question   |  February 5, 2008  8:39 PM
AS/400, AS400 Hex Invalid data