Difference between revisions of "DB2"
(New page: DB2 z/OS Stuff. == BLOBS, CLOBS == So kreiert man die auxiliary Tables automatisch: SET CURRENT SQLID = 'MYSCHEMA'; set current rules='STD'; Create table MYSCHEMA.MYTABLE ( ID ...) |
(→BLOBS, CLOBS) |
||
Line 2: | Line 2: | ||
== BLOBS, CLOBS == | == BLOBS, CLOBS == | ||
− | So kreiert man die auxiliary Tables automatisch | + | So kreiert man die auxiliary Tables automatisch. Das Zauberwort ist STD. |
SET CURRENT SQLID = 'MYSCHEMA'; | SET CURRENT SQLID = 'MYSCHEMA'; | ||
set current rules='STD'; | set current rules='STD'; |
Revision as of 20:52, 7 July 2008
DB2 z/OS Stuff.
BLOBS, CLOBS
So kreiert man die auxiliary Tables automatisch. Das Zauberwort ist STD.
SET CURRENT SQLID = 'MYSCHEMA'; set current rules='STD'; Create table MYSCHEMA.MYTABLE ( ID DECIMAL(10,0) NOT NULL Generated Always as identity (start with 1, increment by 1, cache 20), DATEI BLOB(1048576) With Default ) in MYSCHEMA.MYTABLESPACE ;