Re: CPYF bug - or working as designed?

[CRPence <CRPbottle@xxxxxxxxx>]

  Working /correctly/ as coded; thus probably a .feeture. ;-)  Whether 
that is working-as-designed is moot, after having always functioned that 
way... since the S/38, I believe.  The value passed on the INCREL 
parameter has an actual or effective length attribute [ELEM TYPE(*X) I 
believe; someone could use their version of a RTVCMDSRC to validate 
that], and the /field/ being compared against the specified /value/ 
elment is compared only up to the length of the literal value that was 
specified.  Thus the comparison is effectively the following predicate 
[as expressed using SQL; e.g. as a predicate in a WHERE clause]:
     left(LMLL, length('BR_T')) = 'BR_T'

  At the command line [i.e. a command string without a CL variable for 
the /value/ element of the Include Relationship], to copy just the one 
row with the value 'BR_T', use the following specification:
     INCREL((*IF LMLL *EQ 'BR_T      '))

  Or similarly, as I had explained here:
http://archive.midrange.com/midrange-l/201107/msg00408.html

Regards, Chuck

On 07 May 2013 15:05, Steve Landess wrote:
> After working on this platform for 30 years, I can't believe that I
> have not previously encountered this issue.
>
> (tested on V5R4 and IBM i 7.1)
>
> In an RUNSQLSTM script, do this:
>
> CREATE TABLE QTEMP/XXXX
> ( LMLL CHAR (10 ) NOT NULL WITH DEFAULT
> , LLNAME CHAR (30 ) NOT NULL WITH DEFAULT
> )
> ;
>
> Insert into qtemp/XXXX Values
>  ('BR_T' ,'Brazil test')
> ,('BR_T1','Brazil test')
> ,('BR_T2','Brazil test')
> ,('BR_T3','Brazil test')
> ,('BR_T4','Brazil test')
> ,('BR_X' ,'Brazil test')
> ;
>
> Now issue the following CPYF command:
>
> CPYF FROMFILE(QTEMP/XXXX) TOFILE(QTEMP/XXXX1) MBROPT(*ADD)
> CRTFILE(*YES) INCREL((*IF LMLL *EQ 'BR_T'))
>
> <<SNIP what describes effect as copying all but the last row>>
>
> So, Is this a feature or a bug?
>
> (tested on V5R4 and IBM i 7.1)