1
  • CPYFRMIMPF in CL vs CPYFRMIMPF in command line

    If i type: CPYFRMIMPF FROMSTMF('/INTRA/STANDARD.CSV') + TOFILE(INTRA400DM/TESTCSVF00) + MBROPT(*REPLACE) RCDDLM(*CRLF) + FLDDLM(';') DECPNT(*COMMA) FROMRCD(2) + RPLNULLVAL(*FLDDFT) IDCOL(*FROMFLD) in command line all works fine. If i try same command in CL, in the TESTCSVF00 file are copied olny...

    paolopanini20 pointsBadges:
  • Create Excel from AS/400 with multiple sheets

    I have a requirement to generate an excel from 2 different PF as 2 sheets in a single Excel file. I have created single sheet excel using CrtCsvDta command. Please help me to figure out to generate multi-sheet Excel from AS400.

    RamvishakRamesh2,505 pointsBadges:
  • How to remove comma for individual fields before inserting into comma seperated csv file in RPGLE

    I'm trying to convert flat file to CSV file using RPGLE. As it is a comma separated file for certain fields like description as and when comma is encountered data is written to next column. I need to place each field value in respective columns even if comma is present in a field value. Can some...

    ganeshpavi70 pointsBadges:
  • AS400 Shell command

    Hi  Iam using jar command to comprees the csv file to Zip file.in my program.iam submitting the job,usually it oftens fails for few files to zip.it gives me the error like qsh: 001-0012 Error found starting child process. System resources not available to complete request. So how can i solve this...

    iiiiiiiiiiiii335 pointsBadges:
  • Accessing abc.csv AS/400 files

    how to access abc.csv files in as400.i have a abc.csv file,in this file have contain some data but i want to access into my physical file,with out using 3rd party tool.pls give advice

    madhuchowdary350 pointsBadges:
  • Zipping CSV to AS/400

    Hi I have one doubt in zipping the CSV files... Iam keeping the daily running reports in My IFS called ABC folder. wrklnk ABC.This folder contains 10 csv files with date extension. Now i want to zip all this CSV files and FTP to another system. how to do this in AS400.? please help me out in...

    iiiiiiiiiiiii335 pointsBadges:
  • How to Import Data from a .CSV or .XLSX file to an AS400 file?

    I want to import the data of a .CSV or .XLSX file to a AS400 file. How can I accomplish this? Also, the .CSV/.XLSX file has two columns that I would like to keep in the AS400 File. Any inputs would be really appreciated.

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

    Proy5 pointsBadges:
1

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