|
View previous topic :: View next topic
|
| Author |
Message |
naveen_desireddy
New User
Joined: 29 Aug 2005
Posts: 10
Location: Hyderabad, India
|
|
|
|
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 |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
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 
a project leader in a reputed MNC should know better 
a forum search SQL 104 42601 returned quite a few hits and suggestions |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| 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  |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| Psychic day test - maybe the DB2 subsystem name changes with the environment |
|
| Back to top |
|
|
|
|
