Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SELECT from System Table
I have the following problem when selecting from a system table. What is a likely explanation? Permissions? (AS/400 DB2 from PC using IBM AS/400 Client Access). SELECT TABNAME,TYPE,CREATE_TIME FROM SYSCAT.TABLES WHERE DEFINER =USER [SQL0204] TABLES in SYSCAT type *FILE not found. Cause . . . ... -
SQL Server sp_help = what in in DB2?
All, I am new to DB2, and I am using the AS/400 Operationas Navigator which provides a GUI command line interface to issue SQL commands to a DB2 database. To get a text dump to the SQL Server command line screen of the columns and column types and the indexes and other constraints of a table...
