Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SQLCODE -950 in PREPARE statement mystery

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

Active User


Joined: 26 Nov 2005
Posts: 458
Location: Belgium

PostPosted: Sat Apr 20, 2019 7:00 pm    Post subject: SQLCODE -950 in PREPARE statement mystery
Reply with quote

Hello,

Running a PL/I program PGM314 which uses dynamic SQL to select DB2 tables. ( DB2 V8 )

Now, I face a sqlcode -950 in the prepare statement. I know where to find explanation, but regarding the error messages, everything seems to be OK.

I spent 3 days on that.... making new program expunged from unnecessary code and keeping the core of the problem. A new program PGMZZZ works... I did a lot of new tests. PGM314 failed as similar programs worked
So I check the code of my program PGM314 , line by line, with the code of the PGMZZZ. Quite exactly the same. Rerun and failed again !!! gggrrhhhh.

My last action was successful but not explained.

I keep the whole code of my program PGM314, I only changed the name to PGM414, I recompiled and bingo it is working !!!!

Can someone explain this Easter mystery icon_rolleyes.gif

Thanks

Happy Easter to everyone Cheers

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

don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 689
Location: Whitby, ON, Canada

PostPosted: Mon Apr 22, 2019 11:34 pm    Post subject:
Reply with quote

Wild guess: any chance that garbage characters are winding up in the LOCATION portion of a three part table name? The book says that LOCATION must contain spaces or a valid location name.
Back to top
View user's profile Send private message
PeD

Active User


Joined: 26 Nov 2005
Posts: 458
Location: Belgium

PostPosted: Tue Apr 23, 2019 2:31 am    Post subject:
Reply with quote

Tanks Don for the interest and suggestion,

but I closely check the content and no garbage characters. No LOCATION involved here.
And I repeat : I just did a change like this : create a new member in PDS, copy the whole program PGM314 then Command : "C PGM314 PGM414 ALL"
That's all. Then recompile, bind and execute successfully ! icon_rolleyes.gif

Regards

Pierre
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 SQLCODE=-204 SQLSTATE=42704 mughais27 DB2 4 Fri Feb 14, 2020 5:04 pm
No new posts Getting sqlcode 805 while executing R... abdulrafi DB2 10 Thu Dec 26, 2019 11:46 am
No new posts Usage of pre-processor statement in p... Sakthidevi PL/I & Assembler 1 Thu Nov 28, 2019 4:08 pm
No new posts Usage of Like statement in PL/I Sakthidevi PL/I & Assembler 3 Fri Nov 15, 2019 11:22 pm
No new posts COBOL -DB2 SQL code to have GROUP BY ... vinu78 DB2 21 Wed Oct 23, 2019 7:00 pm

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