CSV

can you explain what cluster shared volumes are? Is this a new file system?

Can you explain what cluster shared volumes are?  Is this a new file system? This question is from the 7/30 Microsoft Virtualization Chat on ITKnowledgeExchange.com

cpytoimpf CSV file showing garbage

I have an application that does 3 CSV files to import to Excel. All three use the same cpytoimpf program/command, 1 is working correctly and 2 are not. I debugged and do not see a difference. I can view the data just fine with dsplnk on the iSeries/AS/400 but the Excel is all @@@@@@. Does...

CSV to Access

I have multiple csv files in a folder with many lines of data in them. Every day new csv files get added to this folder. I want to write batchfile to copy certain rows from these files to the access database table everynight automatically. How can I do this?

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

convert csv file to pf file

i have a file on IFS in .csv format.how to copy this file to pf format in another library.

Open XL file from ILE program

We have a process that converts a spooled file into a .CSV file and stores it in a folder on the IFS. The user then opens Excel and locates and opens the file for editing etc. Is there a way to open up the file in Excel for them after its transferred to the IFS? Could you show me code examples...

help on Bulk insert and xp_cmdshell rename

Hi, I have a csv with only one field with multiple rows, when i am using bulk insert to insert into sql server table, all the rows are inserted in to single column instead of multiple rows.I dont have a delimiter. csv file: (First row is blank) apple bat cat doll when i used the below command...

Auto download a .CSV file from network drive

to a AS/400 physical file through a cl program? how can I do this?

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?

Format CSV file column width.

I converted a dataset to a CSV file and found when opening the file, all the column widths are fixed. This causes most of the columns to be truncated. Is there a way (not manually) of making the columns auto-fit. Language: Cobol.

Code to upload CSV file to AS400

I am looking for code to convert .CSV file to AS400 automatically. I need to automate this feature. Thanks in advance.

How do I read in the comma delimited files by SAS

How do I save an Excel File with 2 sheets into two comma delimited (.csv) files, first for the sheet tabbed "sheet 1" and second for the sheet tabbed "sheet 2"? Also, how do I then read in the comma delimited files by SAS? *note: these are excel files that I am trying to read into the SAS program

Importing addresses via .CSV as a new contact group

I am working on sending out a mass email based on a list of names received as a .csv. I have converted this file to a .wk4 and a .wk1 and I am able to import the names, however, when trying to import the names as a group they appear as seperate contacts. Is there anyway to import all of these...

How to create a CSV file in php code?

I need to create a physical CSV file from php code. I have many solutions to get the results to print to a screen, but I need a file... any ideas?

Trying to run remote command to view AS/400 UNC and failing!

I need some ideas here...I'm stuck. I'm running an RPG program that builds some CSV files for our accounting department. Because they love Excel, I had to make it so that the program breaks the data up into separate CSV files so as not to exceed 65,535 rows. Anyway, I am saving the stream files...

Script to extract files information from ftp server

Hi Wonder if you could help me with the following please. I would like to construct a script (in any language whichever it's easiest) which when run, it will: 1. Log on to a ftp server using a generic account and password 2. It then find the files (no downloading) in a specific folder that...

Script to extract files information from ftp server

Hi Wonder if you could help me with the following please. I would like to construct a script (in any language whichever it's easiest) which when run, it will log on to a ftp server using a generic account and password, then list the files in a specific folder that begins with the string "abc"....

create .csv file from table

how to create a .csv file which will contain data in 2 or more tables

export to csv file from java app

In windows our java application calls one .bat file which runs db2 export command to export data to csv file,how can i do the same on iseries...i dont have any knowledge of iseries and we need to deploy our application on iseries ...can anyone tell me how to do the same thing on iseries

Export in db2 iseries

i want to export query output to a csv file on iseries ..can anyone tell me how to do that