[Squirrel-sql-develop] SQuirreL -> Objects -> SEQUENCE

[Domen D. <dom...@zp...>]

Hello,

 

We have problem browsing SEQUENCES in your tool. The problem is because the
information of sequences is stored in other table than that you specify in
the tool. Other browsing (tables, views, .) is working OK.

 

Error: SEQUENCE: com.ibm.db2.jcc.a.nn: DB2 SQL Error: SQLCODE=-204,
SQLSTATE=42704, SQLERRMC=SYSCAT.SEQUENCES, DRIVER=3.52.95

 

The target database is DB2 (version 9.1) which is running on zOS. The table
where information of sequences is stored is located in SYSIBM.SYSSEQUENCES.

 

Is it possible to change these settings somewhere?

 

Best regards Domen Dolar

 

 

----------------------------------------------------------------------------

Msc. Domen Dolar

Head of Application Development

The institute of pension and invalidity insurance of Slovenia

Kolodvorska 15, 1518 Ljubljana, Slovenija

E: Dom...@zp...

Tel: +386 1 474 5105