Hi,
I am unable to access sysibm.systables, SYSIBM.* anything. May i know, whether it is authorization issues or some other problem
Moderators: sysprog, prino, sfan, steve-myers, Tim001
---------+---------+---------+---------+---------+---------+--
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
Return to Dezhi systems: Mainframe
Users browsing this forum: No registered users and 0 guests