SQL adaptation guide For IBM DB2 UDB 8.x, 9x / Connecting to DB2 OS/400 |
A collection or library in DB2® for OS/400® is equivalent to a schema in DB2 for UNIX™.
STRSQL COMMIT(*NONE)
CREATE COLLECTION
Press F4
Enter field values:
LIBRARY: name of the collection (Schema)
ASP: 1
WITH DATA DICTIONARY: Y
Press ENTER
Press F3 to quit ( choose Option 1 (save and exit) ).
This procedure creates: