• As400 directory space

    Hi Can u please let me know what is the command to check the directory space... for example the directory name is ABC,which contains 100 CSV files. i want to check the space allocated by that directory. Thanks

    iiiiiiiiiiiii335 pointsBadges:
  • Report / File repository for AS/400 V5R4

    Currently we have a home grown web application where we send our reports from the AS400 so our clients can view them. They are converted into a Monarch format. We would like to replace this with something else. We need to be able to put out .csv files, .pbf files and other types in addition to just...

    CharlieBrowne41,430 pointsBadges:
  • How to remove the double quotes in CSV file in iSeries

    Hi The command is to remove the double quotes present in CSV file. I have used one shell command. Strqsh cmd(Sed -e 's/""//g' file name > new file name) I have to write this command in CLLE program. CHGVAR     VAR(&RPLC) VALUE('Sed' *BCAT '-e' *BCAT +                 ...

    iiiiiiiiiiiii335 pointsBadges:
  • Removing zeros from .csv file

    I'm creating a .csv file using CPYTOIMPF Command.. I have a numeric Field in the File. I want to remove the zeros since i am not using it regularly. Pls help me

    Babs30 pointsBadges:
  • Can I use filler to skip a column in a csv file on SQL*LOADER rel 8.0.6.3.0

    We are running Oracle E-business suite 11.5.10.2 on db 9i but when I execute sql*loader it gives me version 8.0.6.3.0. Is the key word FILLER available for me to use to skip unwanted columns in a comma delimited input file? I know FILLER became a key work in 9i - is that the db 9i? Why is my...

    Meb10 pointsBadges:
  • Exporting Active Directory user info to CSV

    Can we export all of our AD data to a CSV file for backup purposes? Can we export the passwords as well? Will they  be encrypted? Where can we find the encryption key so we can make heads or tales of them.

    Karl Gechlik9,860 pointsBadges:
  • Sending an email with a link to a .csv file that’s too large to email

    My program creates a .csv that is copied to the IFS. It is too large to attach to email. I want to send an email with a link to the file. How do I do that?

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

    Koohiisan5,020 pointsBadges:
  • Using IBM System i Access can I replace zeros with blanks in a downloaded CSV file?

    Hi, I have a simple file transfer from my iSeries(AS/400) to a CSV file.  I have a numeric field with 2 decimal places.  The file is sent to an outside agency.  They need zero values to contain blanks.  Is there a way to do this? Thanks for your help.  

    BCF5 pointsBadges:
  • Error using CPYFRMIMPF

    I have a .CSV file that contains a header record and then several detail records (random number as it is the EDI invoices). I use the CPYFRMIMPF to copy the first record to the header file and then I do it again for record 2 to *end. The problem is that it will copy the header fine but then it will...

    Cooking5 pointsBadges:
  • How can I transfer a file from th as/400 to my documents as a csv file using client access?

    How can I transfer a file from th as/400 to my documents as a csv file. When I try to copy now I get a a bit map file with using 40 for blanks. I'm trying to use client access to move the data.

    nitzinger385 pointsBadges:
  • Export to CSV or dump file

    can any body guide how to export from command line in oracle 10g tables or db to CSV or dump file.

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

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