• CPYTOIMPF – SQL ERROR

    I am using CPYTOIMPF to copy AS400 database file to another AS400 database to get the receiver file in .csv format to download to a pc folder. I get a SQL error " Error occured in SQL Call Level Interface. Function sequence error." Does anyone know what this error means? I know that my receiver...

    Ann45 pointsBadges:
  • CL – Copy To Import File

    I am using the CPYTOIMPF fromfile(PF) to STMF('dir\acp&txtfile') where &txtfile is &curdt *tcat &curtm.(system date and time) The stream file is created as acp&txtfile and what i want is acp120108100150.

    0 pointsBadges:
  • Copying an externally-described file to the IFS

    Hello, I need to copy several externally-described files to the IFS. What is the best way to copy an externally-described file on the iseries to the IFS on the same iseries? I am wanting the file on the IFS to be in either EBCDIC, ASCII, BINARY, or Comma Separated Variable format. I thought about...

    Panthers905 pointsBadges:
  • TXT file naming using CL

    Hi I hve created a txt file from a pf using cpytoimpf.The name of the txt file should have ccyymmddhhmmss in its name.I can retreive the date and time parameters from qdate and qtime.How do i name the txt file using a CL.

    0 pointsBadges:
  • CPYTOIMPF performance problem

    Since moving from V5R4M0 to V6R1M0 our program that copies from a PF to an import file on the IFS using the CPYTOIMPF command has had major performance issues. What used to take 30 minutes to copy now takes as much as 24 hours.

    Jstone5 pointsBadges:
  • CPYTOIMPF – Physical file to IFS, get imbedded blanks

    I have a physical file with the following fields. (field - attribute - sample content) FILL01 - 1A - blank KEY - 8A - AAPCTINV LENGTH - 2S 0 - 60 TEXT - 60 A - 8028038 When looking at the file using DSPPFM, the info = AAPCTINV608028038 Note, it has 1 space at the begining Using the following...

    Klw50 pointsBadges:
  • Where does the time of IFS stored files come from ?

    Since we have shifted to summer time, and adapted the Qtime value of the ISeries (V5R4 Model 525), the files created by ISeries native applications and moved by this applications to IFS automaticaly using CPYTOIMPF present a bad creation/modification time. The time is one hour later. I don't find...

    TSCHMITZ470 pointsBadges:
  • creating a .csv from iseries file

    I've asked this question before and was told to change the parm in CPYTOIMPF to STMFCODPAG(819). The date in the .csv file is garble. CPYTOIMPF FROMFILE(qtemp/&FILE_NAME) + TOSTMF('/ILS/payops/*tcat &file_name *tcat '.csv') (*REPLACE) + STMFCODPAG(819) RCDDLM(*CRLF) + DTAFMT(*DLM) STRDLM(*NONE)...

    Shelties10 pointsBadges:
  • Bad date.

    I'm using the "CPYTOIMPF" to create a .csv file from a iseries database. All fields look good when opening the spreadsheet, except the date. The format of the date is MM/DD/YY 8 position char. field Here's what it looks like.ñññòð÷

    Shelties10 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