I am a new user with liquibase and I am using it against DB2 via ant scripts. I can use the “generateChangeLog” task with my local db2 on windows. But when I use it against the remote db2 server on z/os, I got the following error:
liquibase.exception.DatabaseException: Error executing SQL SELECT IDENTITY FROM SYSCAT.COLUMNS WHERE TABSCHEMA = ‘someShema’ AND TABNAME = ‘tableName’ AND COLNAME = ‘colName’ AND HIDDEN != ‘S’
I think it is due to the syscat.columns view is different between windows db2 and z/os db2, is liquibase supports DB2 on z/os? And if it is, where can I specify the database system is on z/os instead of windows? (by using ant, or java api? or other means?)
Thanks a lot for your help!