ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

CPYTOIMPF leaving out records

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • CPYTOIMPF leaving out records

    I'm trying to use CPYTOIMPF to extract the data in my table to a tab delimited text file. It seems to work okay, except that it keeps leaving out the last 2-3 records. Any ideas on why this might be happening? The command and parameters I'm using are below.

    Code:
    CPYTOIMPF  FROMFILE(QTEMP/CUSTSEGH) TOSTMF(&STREAM) +  
                 MBROPT(*REPLACE) STMFCCSID(*PCASCII) +    
                 RCDDLM(*CRLF) STRDLM(*NONE) FLDDLM(*TAB) +
                 ADDCOLNAM(*SQL)

  • #2
    Re: CPYTOIMPF leaving out records

    I noticed that your using the ADDCOLNAM keyword so you must be running at V6R1 or greater. Are you current on PTF's?

    Comment


    • #3
      Re: CPYTOIMPF leaving out records

      What is the job environment? Commitment control? Since the FROMFILE() is in QTEMP, it was populated in the same job. How was it populated?

      Tom
      Tom

      There are only two hard things in Computer Science: cache invalidation, naming things and off-by-one errors.

      Why is it that all of the instruments seeking intelligent life in the universe are pointed away from Earth?

      Comment

      Working...
      X