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
 
SQL Assist Error

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

New User


Joined: 05 Nov 2009
Posts: 3
Location: INDIA

PostPosted: Thu Apr 08, 2010 3:55 pm    Post subject: SQL Assist Error
Reply with quote

Hi Folks,

Iam trying to use the SQL assist.

OS: Z/OS 1.10
DB: DB2 OS390 V 9.1
DB2 Client:
C:\myfold\db\db2udb95\BIN>db2level
DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL09051" with
level identifier "03020107".
Informational tokens are "DB2 v9.5.100.3130", "special_20479", "WR21402_20479",
and Fix Pack "1".
Product is installed at "C:\myfold\db\db2udb95" with DB2 Copy Name "DB2COPY1".

I get the error message when i click on "SQL" assist icon in the command editor from the client.
"No authorized routine named "SYSIBM.SQLTABLES" of type "" having compatible arguments was found

I checked this
OS: Z/OS 1.10
DB: DB2 OS390 V 8.1.5
DB2 Client: Same as above

When i click on SQL Assist icon in command editor, it works fine.
Iam able to query sysibm.systables.
What is the difference in v8.1.5 and 9.1 that SQL assist is not working?

Can anyone let me know what's been missed in settings for DB2 OS390 V 9.1?

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

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Apr 08, 2010 4:04 pm    Post subject:
Reply with quote

GopiMB,

Quote:
"No authorized routine named "SYSIBM.SQLTABLES" of type "

DB2 doesn't have a table named "SQLTABLES".

Sushanth
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Thu Apr 08, 2010 4:10 pm    Post subject:
Reply with quote

sushanth bobby wrote:
GopiMB,

Quote:
"No authorized routine named "SYSIBM.SQLTABLES" of type "

DB2 doesn't have a table named "SQLTABLES".

of course not, it's a stored procedure.
Back to top
View user's profile Send private message
GopiMB

New User


Joined: 05 Nov 2009
Posts: 3
Location: INDIA

PostPosted: Thu Apr 08, 2010 4:23 pm    Post subject: Reply to: SQL Assist Error
Reply with quote

Thanks GuyC, sushanth bobby.
But how do i get rid of this message/error? Any settings, updation required in db2cli.ini file or similar?
Why this occurs only in V9.1 and not in V8.1.5 which i tested and mentioned in the earlier message.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Apr 08, 2010 4:48 pm    Post subject:
Reply with quote

"Routine".... ahh, i missed that.

GopiMB, Check in DB2 V9, if the routine exists.



Sushanth
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Thu Apr 08, 2010 6:52 pm    Post subject:
Reply with quote

SYSIBM.SQLTABLES is a stored procedure needed for ODBC/JDBC.

Usually setting up software to be able to access DB2 z/OS includes
creating and/or binding some stored procedures/packages in DB2 z/OS.

Sometimes it is Windows/unix setup that takes care of it,
Sometimes it is stated as a preriquisite
Sometimes it is some JCL you have to execute on the mainframe.

Possibly V9 uses another stored proc/version than V8.1.5
Back to top
View user's profile Send private message
GopiMB

New User


Joined: 05 Nov 2009
Posts: 3
Location: INDIA

PostPosted: Tue Apr 20, 2010 4:01 pm    Post subject:
Reply with quote

thanks GuyC and Sushanth.
The mainframe admin had missed building some procedures.
After this error, he had rebuilt and its working fine now.
Thanks folks.
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