• cl

    DCL &TEXTFILENM *CHAR 40 dcl &curdt *char 6 dcl &curtm *char 6 /* build your CL file name as */ RTVSYSVAL SYSVAL(QDATE) RTNVAR(&CURDT) RTVSYSVAL SYSVAL(QTime) RTNVAR(&CURTM) ChgVar &TextFileNm (QDATE *TCAT QTIME *TCAT ‘.TXT’ CPYTOIMPF … To stream file . . . . . . . . . TOSTMF &TextFileNm Am...

    0 pointsBadges:
  • Error code 10: Function sequence error using CPYTOIMPF on AS/400

    I am using the CPYTOIMPF function on an AS400 to copy from one data base file to another. I want to end up with a .CSV file format. It worked once but now I get the following error: Message Id: SQ999999 Error occurred in SQL Call Level Interface. A procedure call encountered an error. The error...

    AS400 - Ask the Expert485 pointsBadges:
  • 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:
  • 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