SYSIBM.*

This forum provides the support of Dezhi Mainframe systems. Please post your questions about logon, usage of our mainframe environment.

Moderators: sysprog, prino, sfan, steve-myers, Tim001

SYSIBM.*

Postby kevin1 » Mon 01 Mar 2010, 13:19

Hi,

I am unable to access sysibm.systables, SYSIBM.* anything. May i know, whether it is authorization issues or some other problem :)
kevin1
 
Posts: 4
Joined: Wed 20 Jan 2010, 04:56

Re: SYSIBM.*

Postby prino » Mon 01 Mar 2010, 14:31

No problems here:
Code: Select all
---------+---------+---------+---------+---------+---------+--
  select * from sysibm.systables where name = 'TAB';         
---------+---------+---------+---------+---------+---------+--
NAME                                                         
---------+---------+---------+---------+---------+---------+--
TAB                                                           
TAB                                                           
TAB                                                           
TAB                                                           
TAB                                                           
TAB                                                           
TAB                                                           
TAB                                                           
DSNE610I NUMBER OF ROWS DISPLAYED IS 8                       
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100   
---------+---------+---------+---------+---------+---------+--
---------+---------+---------+---------+---------+---------+--
DSNE617I COMMIT PERFORMED, SQLCODE IS 0                       
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0     
---------+---------+---------+---------+---------+---------+--
DSNE601I SQL STATEMENTS ASSUMED TO BE BETWEEN COLUMNS 1 AND 72
DSNE620I NUMBER OF SQL STATEMENTS PROCESSED IS 1             
DSNE621I NUMBER OF INPUT RECORDS READ IS 1                   
DSNE622I NUMBER OF OUTPUT RECORDS WRITTEN IS 24               
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
Some programming here :mrgreen:
prino
 
Posts: 479
Joined: Sat 06 Jun 2009, 21:41
Location: Vilnius, Lithuania


Return to Dezhi systems: Mainframe

Who is online

Users browsing this forum: No registered users and 0 guests