Differences

This shows you the differences between two versions of the page.

--- jvx:server:db:as400 [2025/06/23 13:35]
admin created
+++ jvx:server:db:as400 [2025/06/23 13:42] (current)
admin
@@ Line 1: / Line 1: @@
-Using DB2 on IBM i (AS/400)
+~~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.