Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

A DB2 error SQLSTATE=42601

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
dineshsjce
Currently Banned

New User


Joined: 16 Apr 2007
Posts: 41
Location: Bangalore

PostPosted: Wed May 30, 2007 1:47 pm    Post subject: A DB2 error SQLSTATE=42601
Reply with quote

I got the error SQLSTATE=42601 when comipling a cics program in unix. What is the cause for that error ?
Back to top
View user's profile Send private message

dineshsjce
Currently Banned

New User


Joined: 16 Apr 2007
Posts: 41
Location: Bangalore

PostPosted: Wed May 30, 2007 1:53 pm    Post subject: Needed infornation on SQLSTATE=42601 error .
Reply with quote

I got the error SQLSTATE=42601 when comipling a cics program in unix. What is the cause for that error ?
Back to top
View user's profile Send private message
dineshsjce
Currently Banned

New User


Joined: 16 Apr 2007
Posts: 41
Location: Bangalore

PostPosted: Wed May 30, 2007 2:04 pm    Post subject: A DB2 error
Reply with quote

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
View user's profile Send private message
Nimesh.Srivastava

New User


Joined: 30 Nov 2006
Posts: 78
Location: SINGAPORE

PostPosted: Wed May 30, 2007 2:10 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm
No new posts INVOKE WEBSERVICE error danik56 CICS 11 Thu Mar 09, 2017 11:52 am
No new posts Row not found Sql error GaganGarg DB2 7 Tue Mar 07, 2017 6:29 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us