Page 1 of 1

IGYPS2120-S Error

PostPosted: Wed Dec 02, 2009 1:40 am
by tlnata1
Hello. I received an error. IGYPS2120-S Expected a reference-modification specification but found")". The "MOVE" statement was discarded.
here is the line# that it is referencing.

SELECT ADDR_ID_NO,                         
       PNSLRR_EFF_DT,                     
       PNSLRR_EXPRTN_DT,                   
       PPO_FE_SCH_MDFR_CD,                 
       RMBRCP_TAXID_NO,                   
       RMBRCP_TXIDFRMT_CD,                 
       ADDRD_STRASTSH_ABR,                 
       PNSLRR_PCMCPC_CNT                   
FROM  PNSLRR A, ADDRD B                   
WHERE PRVDR_ID_NO      = :WS10-PRVDR-ID-NO
  AND NTWK_ID_NO       = :WS10-NETID       
  AND PNSLRR_EFF_DT   <= :WS20-SAVE-CURR-DT
  AND PNSLRR_EXPRTN_DT > :WS20-SAVE-CURR-DT
  AND SUPERCEDE_DATE   = '0001-01-01'     
  AND ADDRD_EFF_DT    <= :WS20-SAVE-CURR-DT
  AND ADDRD_EXPRTN_DT  > :WS20-SAVE-CURR-DT
  AND ADDRD_SPSD_DT    = '0001-01-01'     
  AND ADDR_ID_NO       = ADDR_NO           
WITH UR 

This is existing code...added PNSLRR_PCMCPC_CNT field.

Please advice. Once this is resolved, I can begin to test.

thanks.

Re: IGYPS2120-S Error

PostPosted: Wed Dec 02, 2009 7:41 am
by dick scherrer
Hello and welcome to the forum,

The error posted does not go with the code posted - unless i am missing something. . . There is no "move" and there is no ")" posted.

How did you determine this code goes with the error message?

Suggest you post the complete error message (including the problem statement number) and the output from the compiler that shows the same statement number.