New look for object (table)

angoca / db2tools

Set of routines that can ease your daily work.

GNU General Public License v2.0

1 stars 0 forks source link

New look for object (table) #11

Open angoca opened 10 years ago

angoca commented 10 years ago

SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=2, TABLEID=12, COLNO=1" is not allowed. SQLSTATE=23502

Something better to solve this.

angoca commented 10 years ago

db2 "select varchar(trim(c.tabschema) || '.' || trim(c.tabname) || '.' || trim(colname), 128) as \"ts.table.col\" from syscat.tables t join syscat.columns c on (c.tabschema = t.tabschema and c.tabname = t.tabname) where t.tbspaceid = 3 and t.tableid = 531 and c.colno = 2"