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