✎ Using DB2 on IBM i (AS/400)

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

~~NOTRANS~~
~~Title: Using DB2 on IBM i (AS/400)~~

We support most operations of DB2 on IBM i series but it depends on your configuration. If you don't use journaling, it's not possible to update/delete records. If you work with journaling it's not possible to drop or alter columns. But this shouldn't be a big deal for developers.

We introduced additional configuration parameters:

  jdbc:as400://pub400.com/SIB2;sqlObjectsOnly=true;currentSchemaOnly=true;
or  
  jdbc:as400://pub400.com/SIB2;sqlObjectsOnly;currentSchemaOnly;
  
Both parameters can impact performance and speed up access.  
  
== sqlObjectsOnly ==

Only tables, views, and aliases created with SQL (types T, V, A) will be displayed. By default, this is set to **false**, meaning that types P = Physical File (PF) and L = Logical File (LF) will also be shown.  

== currentSchemaOnly ==

Only the current schema is visible. By default, this is set to **false**, meaning all objects from all schemas you have access rights to will be displayed.