Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts FTP Skip or ignore error and process ... AJAYREDDY All Other Mainframe Topics 3 Wed Sep 27, 2017 8:12 pm
No new posts Assembler Macro Copybook converted to... Ziquilix PL/I & Assembler 4 Tue Sep 26, 2017 3:07 am
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 1 Mon Sep 18, 2017 4:31 pm
No new posts Reply MQ open error Vignesh Sid COBOL Programming 6 Thu Sep 07, 2017 6:02 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us