identity columns are not virtual (DB2 Z/OS)

Ralf Wisser · Ralf Wisser · commit 2c55c5813c59 · 2025-05-27T10:33:41.000+02:00
diff --git a/src/main/engine/net/sf/jailer/configuration/jailer.json b/src/main/engine/net/sf/jailer/configuration/jailer.json
@@ -736,7 +736,7 @@
 			"estimatedRowCountQuery": "SELECT TABNAME, CARD FROM SYSSTAT.TABLES WHERE TABSCHEMA = '%s'",
 			"defaultSchemaQuery": null,
 			"viewTextOrDDLQuery": "SELECT TEXT FROM SYSCAT.VIEWS WHERE VIEWSCHEMA = '%1$s' and VIEWNAME = '%2$s'",
-			"virtualColumnsQuery": "SELECT TABNAME, COLNAME from syscat.columns WHERE TABSCHEMA='${SCHEMA}' AND GENERATED='A'",
+			"virtualColumnsQuery": "SELECT TABNAME, COLNAME from syscat.columns WHERE TABSCHEMA='${SCHEMA}' AND GENERATED='A' AND NOT IDENTITY='Y'",
 			"userDefinedColumnsQuery": null,
 			"nullableContraint": null,
 			"identifierQuoteString": "\"",
