|
View previous topic :: View next topic
|
| Author |
Message |
dineshsjce
Currently Banned
New User
Joined: 16 Apr 2007
Posts: 41
Location: Bangalore
|
|
|
|
| I got the error SQLSTATE=42601 when comipling a cics program in unix. What is the cause for that error ? |
|
| Back to top |
|
 |
dineshsjce
Currently Banned
New User
Joined: 16 Apr 2007
Posts: 41
Location: Bangalore
|
|
|
|
| I got the error SQLSTATE=42601 when comipling a cics program in unix. What is the cause for that error ? |
|
| Back to top |
|
|
dineshsjce
Currently Banned
New User
Joined: 16 Apr 2007
Posts: 41
Location: Bangalore
|
|
|
|
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 ?
EXEC SQL
SELECT CNTCT_EFF_DT
, CUST_CNTCT_ID
INTO :WS-EFF-DATE
, :WS-CNTCT-ID
FROM CON01_CUST_CNTCT
WHERE
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 |
|
| Back to top |
|
|
Nimesh.Srivastava
New User
Joined: 30 Nov 2006
Posts: 78
Location: SINGAPORE
|
|
|
|
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.
Thanks
Nimesh |
|
| Back to top |
|
|
|
|
