Search results
16 kwi 2015 · How to view the table structure in db2 database. Open db2 command window, connect to db2 with following command. > db2 connect to DATABASE_NAME USER USERNAME USING PASSWORD. Once you connected successfully, issue the following command to view the table structure. > db2 "describe select * from SCHEMA_NAME.TABLE_NAME".
30 wrz 2008 · SELECT * FROM SYSIBM.COLUMNS -- Provides all columns, their data types & sizes, default values, etc. SELECT * FROM SYSIBM.SQLPRIMARYKEYS -- Provides a list of primary keys and their order Share
You can use the SYSCAT.TABLES and SYSCAT.COLUMNS catalog views to view table definitions. For SYSCAT.COLUMNS, each row represents a column defined for a table, view, or nickname. To see the data in the columns, use the SELECT statement.
29 maj 2015 · select table_owner, table_name from from qsys2.systables Where TABLE_OWNER is the schema, and TABLE_NAME is the name. You should find various other useful views in the catalog like SYSVIEWS, SYSCOLUMNS, SYSTRIGGERS, etc.
SELECT * FROM SYSTABLES; SYSTABLES is the DB2 standard catalog view. Where you find it depends on which flavor of DB2 server you are using: DB2 for i, LUW, or z/OS. You shouldn't need GO or other such fiddle-faddle. Right click on a statement in the SQL file editor, and you'll see options like alt-S to execute current text.
The simplest way to retrieve data is to use the SQL statement SELECT to specify a result table. You can specify the columns and rows that you want to retrieve.
The select-statement is the form of a query that can be directly specified in a DECLARE CURSOR statement or FOR statement, prepared and then referenced in a DECLARE CURSOR statement, or directly specified in an SQLJ assignment clause.
