AS/400 CSV Questions

1

How to remove comma for individual fields before inserting into comma seperated csv file in RPGLE
I’m trying to convert flat file to CSV file using RPGLE. As it is a comma separated file for certain fields like description as and when comma is encountered data is written to next column. I need to place each field value in respective columns even if comma is present in a field value. Can [...]

Answer Question   |  February 27, 2012  5:00 AM
AS/400 CSV, RPGLE
asked by:
70 pts.

AS400 Shell command
Hi  Iam using jar command to comprees the csv file to Zip file.in my program.iam submitting the job,usually it oftens fails for few files to zip.it gives me the error like qsh: 001-0012 Error found starting child process. System resources not available to complete request. So how can i solve this issue within in my [...]

Answer Question   |  May 24, 2011  11:54 AM
AS/400 CSV, AS400 - STRQSH, AS400 Shell command, CSV, Shell commands
asked by:
335 pts.

Accessing abc.csv AS/400 files
how to access abc.csv files in as400.i have a abc.csv file,in this file have contain some data but i want to access into my physical file,with out using 3rd party tool.pls give advice

Answer Question   |  April 6, 2011  4:49 PM
AS/400, AS/400 CSV, CSV, CSV file format
asked by:
345 pts.

Zipping CSV to AS/400
Hi I have one doubt in zipping the CSV files… Iam keeping the daily running reports in My IFS called ABC folder. wrklnk ABC.This folder contains 10 csv files with date extension. Now i want to zip all this CSV files and FTP to another system. how to do this in AS400.? please help me [...]

Answer Question   |  January 3, 2011  10:39 AM
AS/400 CSV, AS/400 FTP, CSV, Zip Files
asked by:
335 pts.

How to Import Data from a .CSV or .XLSX file to an AS400 file?
I want to import the data of a .CSV or .XLSX file to a AS400 file. How can I accomplish this? Also, the .CSV/.XLSX file has two columns that I would like to keep in the AS400 File. Any inputs would be really appreciated.

Answer Question   |  May 1, 2010  7:12 PM
AS/400 CSV, as400 data import, as400/DB2, XLSX
asked by:
5 pts.

We are runing V5R1 OS400, how do I write to CSV file
We are trying to write a program that will take the output of a report, & put it on a CSV file. This file will the be sent via email to user(s). Please provide with steps to accomplish this including foldersetup, etc.

Answer Question   |  August 18, 2009  9:47 PM
AS/400 CSV, AS/400 import/export, CSV format, OS/400, V5R1, write csv file AS400
asked by:
5 pts.

1