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
 

 

DB2 SQL Error Code -104 & State 42601

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

New User


Joined: 29 Aug 2005
Posts: 10
Location: Hyderabad, India

PostPosted: Fri Sep 24, 2010 12:31 pm    Post subject: DB2 SQL Error Code -104 & State 42601
Reply with quote

Hi,

I am Executing a SQL statement in SPUFI and it ran fine in one environment (Suppose Dev) when I moved the same to another environment (Suppose UAT) using Endevor, and Ran the same it is throwing an error DB2 SQL Error Code -104 & State 42601,

Can anybody please check the same and let me know Why this Happens and is there any Solution for the same,
As there is no change to the SQL Statement as well.

I need the response ASAP.

Thanks in Advance.

Desireddy
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Fri Sep 24, 2010 12:46 pm    Post subject: Reply to: DB2 SQL Error Code -104 & State 42601
Reply with quote

sorry but we do not do ASAP

the fastest response would obtained by looking at the manuals Yourself

remember... replying is
on voluntary basis
responders time
responders equipment

edited after checking the ts profile
occupation ==> Project Lead in a Reputed MNC icon_eek.gif
a project leader in a reputed MNC should know better icon_evil.gif

a forum search SQL 104 42601 returned quite a few hits and suggestions
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Fri Sep 24, 2010 1:01 pm    Post subject:
Reply with quote

It's a bit hard to check "a sql statement".
maybe undefined column ?
anyway I would check the definitions of the tables in the two environments.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Fri Sep 24, 2010 1:03 pm    Post subject: Reply to: DB2 SQL Error Code -104 & State 42601
Reply with quote

Quote:
It's a bit hard to check "a sql statement".

I guess the TS wanted a bit of manual reading and searching done on his behalf!

after all a project lead is not supposed to do the dirty work, just plan other people work icon_biggrin.gif icon_biggrin.gif
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Sep 24, 2010 1:17 pm    Post subject:
Reply with quote

Psychic day test - maybe the DB2 subsystem name changes with the environment
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 How to Capture the Max return code of... anilkumar922 All Other Mainframe Topics 0 Thu Jan 12, 2017 12:02 pm
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
This topic is locked: you cannot edit posts or make replies. Calling REXX code from ISPF panel sanchita dey TSO/ISPF 4 Mon Jan 02, 2017 5:13 pm
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm


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