Finding a stream file CSV
i have a stream file in CSV format, we are not sure wheere this file is I have find out where this available in AS/400. I tryed wrklnk command and other options but i am not able to find this file. could you tell me the best way to find out this CSV stream file.   [...]

Answer Question   |  May 2, 2011  12:50 PM
AS/400, CSV, CSV format, Stream files

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

CSV file to database table
Hi Experts, I have a question is the csv file can be converted to a database table with same column and data i hav gone through the CSV format tag,not getting idea about this i just would like to know is there any procedure or sysntax to do this thanks for the hlp

Answer Question   |  June 25, 2009  10:57 AM
CSV format, CSV input file

How to automate getting the .CSV file from IFS folder to local desktop
I am working on tool which extract the data from physical files based on some condition and creates a .CSV file in IFS folder. I want to automate the process to get the CSV file to local Desktop and should save the file in specified location in local system. Is there any way to open [...]

Answer Question   |  April 14, 2009  6:15 AM
AS/400 import/export, CSV format, IFS Folder, RPG/400, RPGLE

SAP – Create CSV from Text format
I tried to convert the text format to CSV format by USing internal table and the FM isSAP_CONVERT_TO_CSV_FORMAT. But wn i download to CSV format the file contains fields serepared by ‘;’.So becuse of this Im unable to Up load this file.

Answer Question   |  July 20, 2010  4:11 AM
CSV format, isSAP_CONVERT_TO_CSV_FORMAT, SAP development, SAP Import/Export

How to match CSV field values in SQL Server 2005
i have an table in sql-server 2005, in which my one field is storing csv values. suppose i have two tables; one is roles and another is users; and multiple role can be assign to one user. so that i have make a fields i.e roles in user table which is keeping the values in [...]

Answer Question   |  March 26, 2009  7:18 AM
CSV, CSV file format, CSV format, SQL Server 2005

AS/400 command to convert a file to .csv
Hi, If I remember correctly thare is an iseries command to convert a file to .csv with the OS environment. Can anyone remember it. Not using Client Access. Thanks.

Answer Question   |  March 12, 2009  4:41 AM
AS/400 import/export, CSV format

Creating a CSV file to FTP
I just loaded Office 2007 and created a csv file which then was FTP’ed to a server. When picked up it had lost its csv extension. I follow this process regularly and this only happened after I upgraded to 2007. Any ideas?

Answer Question   |  February 8, 2009  4:56 AM
Comma Separated Values, CSV, CSV format, Excel 2007, FTP, Microsoft Excel 2007, Microsoft Office 2007

CPYTOIMPF and EXCEL defaults
I have an issue when copying an AS400 file to the IFS. One field that is defined as 15 charachter and contains numeric data does not show up in .csv format correctly without reformatting the column to special. I also tried defining the field as numeric, and had the same result. Example of data displayed: [...]

Answer Question   |  January 20, 2009  8:39 PM
CPYTOIMPF, CSV format, IFS, Microsoft Excel

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