CSV Format

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.

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

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 the .CSV...

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.

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 csv format. now my problem...

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.

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?

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...

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