I executed a cics application in unix. But i got the following error
" An unexpected token "CNTCT_EFF_DT
" was found following "SELECT ". Expected tokens may
include: "<space>". SQLSTATE=42601 "
This is the piece of my program code. Can anyone please help me ?
AID_CD = :WS-AID-CD-ONLY
AND COMP_CD IS NULL
AND PRICGRP_CD IS NULL
AND CUST_NBR IS NULL
AND CNTCT_PURP_CD = :WS-PURPOSE-CD-IDP
AND CNTCT_END_DT > :CON01-CNTCT-EFF-DT
what are trying to do...an compilation or execution / run of the program. It seems the error you have posted to be an compilation error.
Provide some more details and have you included the SQLCA structure in your code.