copy pdf files from an E drive into an AS/400 data file
Is there a way to copy pdf files directly into an AS/400 data file?

Answer Question   |  February 16, 2009  5:05 PM
AS/400 import/export, PDF, PDF to AS/400

Receiving an XML file to RPG
HI, I need to receive xml files ( of fixed format ) to my rpgle progrm ( not free format RPG ) and do some calculations. Can i do this without purchasing any tools ( free tools can be used). Please let me know if anyone has done something similar Regards, Kiron

Answer Question   |  December 8, 2008  7:35 AM
AS/400 development, AS/400 import/export, RPG, RPG/400, RPGLE, XML

Copy data from flat file to a flat file
My requirement is : I need to copy data from 1 big flat file to a flat file,but size of this flat file must not > 3MB, if size increases then new members will be created and remaining data will be copied there ….so on..hence this small files will only contain records with size upto [...]

Answer Question   |  November 3, 2008  6:37 AM
AS/400 import/export, COBOL, COBOL/400, Flat files, PF, Physical File, RPG

RPG/400
Hello ,how can we Migrate fromcurrently running on UNISYS platform to AS/400 platform. Major portion of the source application is in COBOL and uses the DMS-II database. This has been migrated to COBOL and RPG on AS/400 using the DB2/400 database

Answer Question   |  November 3, 2008  2:02 PM
AS/400 database, AS/400 import/export, AS/400 migration, COBOL/400, DB2/400, RPG/400, Unisys DMSII

auto transfer of as400 to pc
Hi There How do I create a CL pgm to automatically transfer physical file to a PC server in csv format. Thanks for the help

Answer Question   |  August 12, 2008  9:29 AM
AS/400 import/export, CL, CSV format

Is it possible to get a PDF from AS400 spool file?
Is this possible? Is it really possible to get a PDF from spool file? Nothing seems to work. I was trying to convert PDF in iSeries Navigator. I put a spool file, right click, convert to pdf, asks me whether I want a new printer, I say yes, starts a printer then a writer but [...]

Answer Question   |  August 14, 2008  5:56 PM
AS/400 import/export, PDF conversion, Spool files

Excel Imported Data
Import data from an AS400 using the query function in XL. Hangs. Connection is ok, finds the tables but when it tries to retrieve records an write to XL work sheet it just hangs. Can anyone help. I believe it is a job on the AS400, but which one?

Answer Question   |  July 30, 2008  2:19 AM
AS/400 import/export, Microsoft Excel

Transferring files from AS/400 to Sharepoint 3
We want to be able to transfer data files (Excel Spreadsheets) from our AS/400 to a Sharepoint site. We’ve been advised that e-mail is a solution, but for security reasons our company won’t allow this. We have a utility that let’s us create the Excel files on the AS/400 but cannot work out what’s needed [...]

Answer Question   |  July 29, 2008  10:20 AM
AS/400 import/export, Microsoft Excel, SharePoint, SharePoint Services 3.0

Data Transfer from AS400 to excel
i need to download data from As400 to Excel using TTO option. How to download the description of the fields instead of field names. I have tried with the COLHDG & TEXT keywords in the DDS of the PF. But, the records are getting downloaded with the filed names only. Please revert to me ASAP [...]

Answer Question   |  April 29, 2010  11:32 AM
AS/400 import/export, Data transfer, Microsoft Excel

Update excel charts auto from as400 data
I have a user request to create charts in excel using data held on the as400. I can do this in seperate steps but the user wants it as automatic as possible. At the moment : I run a query on the as400 to create data file I transfer using client access I open in [...]

Answer Question   |  June 13, 2008  11:43 AM
AS/400, AS/400 import/export, Excel Charts, Microsoft Excel