Search results
26 lis 2015 · For Db2 for Linux, Unix and Windows (i.e. Db2 LUW) or for Db2 Warehouse use the SYSCAT.TABLES catalog view. E.g. SELECT TABSCHEMA, TABNAME FROM SYSCAT.TABLES WHERE TABSCHEMA LIKE '%CUR%' AND TYPE = 'T'. Which is a SQL statement that will return all standard tables in all schema that contains the substring CUR.
1 wrz 2011 · For DB2/AS400 users: SELECT TABLE_SCHEMA, TABLE_NAME FROM QSYS2.SYSCOLUMNS WHERE upper(column_name) = upper('[column_name]')
Queries below list tables in a specific schema. Query select tabname as table_name from syscat.tables where tabschema = 'schema_name' -- put schema name here and type = 'T' order by tabname Columns. table_name - name of the table; Rows. One row represents one table; Scope of rows: all tables in the schema; Ordered by table name; Sample results
18 cze 2013 · //select the particular table: syntax: select column_name from table_name where column_name='value'; example: select person_name from person where person_id=1;
The following examples illustrate the select-statement query. Example 1: Select all columns and rows from the EMPLOYEE table. SELECT * FROM EMPLOYEE. Example 2: Select the project name (PROJNAME), start date (PRSTDATE), and end date (PRENDATE) from the PROJECT table.
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.
Retrieving data by using the SELECT statement. 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.
