Defining an AS-400 Logged Database

There are two ways to define an AS/400 logged database:

1. Create the library where the SQL tables are to be placed using the "CREATE COLLECTION" SQL instruction.
   Then generate the logical entities in "AS/400 SQL" form, which will create the tables using the "CREATE TABLE" SQL instruction.
2. If the library was not created via CREATE COLLECTION, or if your logical entities have been created in "native AS/400" form, create logs using the appropriate IBM commands: CRTJRN, CRTJRNRCV, STRJRNPF.

↑ Top of page