topic Re: Views are not accessible using odbc connection in Qlik Replicate

Views are not accessible using odbc connection

suvbin — Fri, 03 Oct 2025 11:33:39 GMT

Hi,

we have a source with ODBC connection to AS400. Connection is working fine but the problem is... unable to see the system catalog views SYSTABLES and SYSCOLUMNS accessible . Could you please advise how we can proceed

Re: Views are not accessible using odbc connection

john_wang — Sat, 04 Oct 2025 01:45:18 GMT

Hello @suvbin ,

As a general rule, the ODBC source endpoint should not be used to access any sources already listed in the Support Matrix. Could you clarify why you’re attempting to use ODBC instead of the dedicated DB2 for i (AS/400) endpoint?

If the AS/400 version is below the supported range for Qlik Replicate, please note that this would require PS (Professional Services) engagement.

Regarding your specific question: can you check whether the views SYSTABLES and SYSCOLUMNS exist by connecting to AS/400 via ODBC 64-bit DSN with the same account that is configured in the endpoint settings? This will help us confirm whether the issue is related to permissions or something else.

Hope this helps.

John.

Re: Views are not accessible using odbc connection

CuriousRaindrop — Sat, 04 Oct 2025 18:39:34 GMT

@suvbin paygonline wrote:

Hi,

we have a source with ODBC connection to AS400. Connection is working fine but the problem is... unable to see the system catalog views SYSTABLES and SYSCOLUMNS accessible . Could you please advise how we can proceed

Hi John,

Thanks for the clarification. I’ll check whether the views SYSTABLES and SYSCOLUMNS exist by connecting via ODBC 64-bit DSN using the same account as in the endpoint settings.

Also, the reason I attempted ODBC was because the AS/400 version might be below the supported range for Qlik Replicate, but I’ll confirm that and reach out to PS if needed.

Appreciate your guidance!

Re: Views are not accessible using odbc connection

john_wang — Sun, 05 Oct 2025 01:54:36 GMT

Thank you @CuriousRaindrop for the update. Feel free to let us know if you need any additional assistance.

Re: Views are not accessible using odbc connection

john_wang — Thu, 23 Oct 2025 14:37:48 GMT

Hello @CuriousRaindrop ,

Since SYSTABLES and SYSCOLUMNS are system views, you can access them through the QSYS2 schema. For example:

Hope this helps.

John.

Re: Views are not accessible using odbc connection

DesmondWOO — Fri, 24 Oct 2025 08:38:36 GMT

Hi @suvbin ,

Please try creating a view for the QSYS2.SYSTABLES, and avoid using names that begin like a system table, such as SYSTAB.

Regards,
Desmond