• Using a .csv to create an ODBC connection.

    I am using an ODBC drive to read a .cvs.dsn file and establish to folders where other .csv files are located and converted into .phb file. The software is WFHC Halifax version 1.2. . CSV file.  [ODBC]DRIVER=Microsoft Text Driver (*.txt; *.csv)UID=admin...

    Jefallon5 pointsBadges:
  • sending e-mail attachememt from mianframe – CSV format

    Hi, Can you plesae let me know hos to do a semicolon seperator while doing this?

    Uddaraju195 pointsBadges:
  • How To create an CSV file in Mainframe (from Object star database)?

    I have to create some extract from Object star tables, in CSV format.Please let me know if any utility or programe can be used.

    Ari200940 pointsBadges:
  • HOW TO READ A CSV FILE IN OBJECT STAR (O*)

    I have to requirements, 1) I need to extract data present in column A from a O* table, which is of of two columns 'A' and 'B'. The field value can be between 14 to 19 in length and numeric and the file should have a comma at the end of each record  ( e.g - the file extract should look like...

    Ari200940 pointsBadges:
  • 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

    Mimi1111115 pointsBadges:
  • Pipe Delimited CSV File

    I have the following Pipe Delimited data in a physical file: Dealer Name¦Deal Number¦Buy/Sell¦ Joseph Camm¦80740¦S¦IG¦5000000.00¦ After issueing a CPYTOPCD command, I end up with: Dealer NameÝDeal NumberÝBuy/SellÝIG1ÝAMOUNT_amountÝ David CammÝ80740ÝSÝIGÝ5000000.00Ý How do I get...

    Ricca100 pointsBadges:
  • Create .csv file on IFS folder in AS/400

    Please help to create .csv file in as/400 (V4R3). Please provide me the steps to create .csv file on IFS path on AS/400.(V4R3).

    Samule400160 pointsBadges:
  • 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.

    JoanIk5 pointsBadges:
  • 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

    ITKE346,360 pointsBadges:
  • 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 anyone...

    VGP300 pointsBadges:
  • 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?

    Vvaidya5 pointsBadges:
  • 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". The...

    Aiko2720 pointsBadges:
  • 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.

    Kapiltiwari350 pointsBadges:
  • 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...

    filuphaze475 pointsBadges:
  • 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 BULK...

    GIG240 pointsBadges:
  • Need a 3rd party AS/400 utility for converting to .CSV files

    Hello there, I’m hoping somebody can point me in the right direction. I need a 3rd party software which will be able to integrate with the AS400 to download 4 files & then convert them into .CSV files. This software will then need to save the exported data files to a server on our network. The...

    Smeakin5 pointsBadges:
  • Auto download a .CSV file from network drive

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

    UARTJ105 pointsBadges:
  • 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?

    Superiorsys15 pointsBadges:
  • 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.

    Jazzcafe5 pointsBadges:
  • 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 names...

    Saylorjr5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following