#347 unable to see views when accessing AS/400

2.1final
closed
Rob Manning
Unknown (89)
5
5 days ago
2006-02-22
Anonymous
No

email = ibaker3@csc.com.au

Error: VIEW: java.sql.SQLException: [SQL0901] SQL
system error.

Logged by class
net.sourceforge.squirrel_sql.client.session.mainpanel.
objecttree.ObjectTree at 22/02/06 16:55:

Error: VIEW

DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
registerDriver: driver
[className=com.ibm.as400.access.AS400JDBCDriver,AS/400
Toolbox for Java JDBC Driver]
JdbcOdbcDriver class loaded
registerDriver: driver
[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.
JdbcOdbcDriver@687ea9]
registerDriver: driver
[className=com.ibm.db2.jcc.DB2Driver,com.ibm.db2.jcc.D
B2Driver@e2892b]
as400: Properties (6109888) : access = "all".
as400: Properties (6109888) : block size = "32".
as400: Properties (6109888) : block criteria = "2".
as400: Properties (6109888) : date format = "".
as400: Properties (6109888) : date separator = "".
as400: Properties (6109888) : decimal separator = "".
as400: Properties (6109888) : errors = "basic".
as400: Properties (6109888) : extended dynamic
= "false".
as400: Properties (6109888) : libraries = "".
as400: Properties (6109888) : naming = "sql".
as400: Properties (6109888) : package = "".
as400: Properties (6109888) : package add = "true".
as400: Properties (6109888) : package cache
= "false".
as400: Properties (6109888) : package clear
= "false".
as400: Properties (6109888) : package error
= "warning".
as400: Properties (6109888) : package library = "".
as400: Properties (6109888) : password = "".
as400: Properties (6109888) : prefetch = "true".
as400: Properties (6109888) : prompt = "".
as400: Properties (6109888) : remarks = "system".
as400: Properties (6109888) : sort = "job".
as400: Properties (6109888) : sort language = "ENU".
as400: Properties (6109888) : sort table = "".
as400: Properties (6109888) : sort weight = "shared".
as400: Properties (6109888) : time format = "".
as400: Properties (6109888) : time separator = "".
as400: Properties (6109888) : trace = "false".
as400: Properties (6109888) : transaction isolation
= "read uncommitted".
as400: Properties (6109888) : translate binary
= "false".
as400: Properties (6109888) : user = "ibaker3da".
as400: Properties (6109888) : package criteria
= "default".
as400: Properties (6109888) : lob threshold
= "32768".
as400: Properties (6109888) : secure = "false".
as400: Properties (6109888) : data truncation
= "true".
as400: Properties (6109888) : proxy server = "".
as400: Properties (6109888) : secondary URL = "".
as400: Properties (6109888) : data compression
= "true".
as400: Properties (6109888) : big decimal = "true".
as400: Properties (6109888) : thread used = "true".
as400: Properties (6109888) : cursor hold = "true".
as400: Properties (6109888) : lazy close = "false".
as400: Properties (6109888) : driver = "toolbox".
as400: Properties (6109888) : bidi string type = "".
as400: Properties (6109888) : key ring name = "".
as400: Properties (6109888) : key ring password = "".
as400: Properties (6109888) : full open = "false".
as400: Properties (6109888) : server trace = "0".
as400: Properties (6109888) : database name = "".
as400: Properties (6109888) : extended metadata
= "false".
as400: Properties (6109888) : cursor sensitivity
= "asensitive".
as400: Properties (6109888) : behavior override
= "0".
as400: Properties (6109888) : package ccsid
= "13488".
as400: Properties (6109888) : minimum divide scale
= "0".
as400: Properties (6109888) : maximum precision
= "31".
as400: Properties (6109888) : maximum scale = "31".
as400: Properties (6109888) : translate hex
= "character".
as400: Properties (6109888) : toolbox trace = "".
as400: Properties (6109888) : qaqqinilib = "".
as400: Properties (6109888) : login timeout = "".
as400: Properties (6109888) : true autocommit
= "false".
as400: Properties (6109888) : bidi implicit
reordering = "true".
as400: Properties (6109888) : bidi numeric ordering
= "false".
as400: Properties (6109888) : hold input locators
= "true".
as400: Properties (6109888) : hold statements
= "false".
as400: Properties (6109888) : rollback cursor hold
= "false".
as400: Properties (6109888) : variable field
compression = "true".
as400: Properties (6109888) : query optimize goal
= "0".
as400: Properties (6109888) : keep alive = "".
as400: Properties (6109888) : receive buffer size
= "".
as400: Properties (6109888) : send buffer size = "".
as400: Properties (6109888) : XA loosely coupled
support = "0".
as400: Driver AS/400 Toolbox for Java JDBC Driver
(21046486) : Using IBM Toolbox for Java JDBC driver
implementation.
as400: Toolbox for Java - Open Source Software,
JTOpen 5.0, codebase 5722-JC1 V5R4M0.1
as400: JDBC Level: 30
as400: Connection xxxxxx.xxxx.xxx.xxx(12195679) :
Client CCSID = 13488.
as400: Connection xxxxxx.xxxx.xxx.xxx(12195679) :
Setting server NLV = 2924.
as400: Connection xxxxxx.xxxx.xxx.xxx(12195679) :
Client functional level = V5R3M01 .
as400: Connection xxxxxx.xxxx.xxx.xxx(12195679) :
Data compression = RLE.
as400: Connection xxxxxx.xxxx.xxx.xxx(12195679) :
ROWID supported = true.
as400: Connection xxxxxx.xxxx.xxx.xxx(12195679) :
True auto-commit supported = true.
as400: Connection xxxxxx.xxxx.xxx.xxx(12195679) :
Maximum decimal precision = 31.
as400: Connection xxxxxx.xxxx.xxx.xxx(12195679) :
Maximum decimal scale = 31.
as400: Connection xxxxxx.xxxx.xxx.xxx(12195679) :
Minimum divide scale = 0.
as400: Connection xxxxxx.xxxx.xxx.xxx(12195679) :
Translate hex = character.
as400: Connection xxxxxx.xxxx.xxx.xxx(12195679) :
Using extended datastreams.
as400: Connection xxxxxx.xxxx.xxx.xxx(12195679) :
JDBC driver major version = 7.
as400: Connection xxxxxx.xxxx.xxx.xxx(12195679) :
i5/OS VRM = V5R3M0.
as400: Connection xxxxxx.xxxx.xxx.xxx(12195679) :
Server CCSID = 37.
as400: Connection xxxxxx.xxxx.xxx.xxx(12195679) :
Server functional level = V5R3M00013 (13).
as400: Connection xxxxxx.xxxx.xxx.xxx(12195679) :
Server job identifier = 087191/QUSER/QZDASOINIT.
as400: Properties (6109888) : decimal separator
= ".".
as400: Properties (6109888) : date format = "dmy".
as400: Properties (6109888) : date separator = "/".
as400: Properties (6109888) : time format = "hms".
as400: Properties (6109888) : time separator = ":".
as400: Connection XXXXXX (12195679) open.
as400: Connection XXXXXX (12195679) : Auto commit
= "true".
as400: Connection XXXXXX (12195679) : Read only
= "false".
as400: Connection XXXXXX (12195679) : Transaction
isolation = "1".
as400: ResultSet Type Info (3789605) open.
as400: ResultSet Type Info (3789605) : Conncurrency
= "1007".
as400: ResultSet Type Info (3789605) : Fetch
direction = "1000".
as400: ResultSet Type Info (3789605) : Fetch size
= "0".
as400: ResultSet Type Info (3789605) : Max rows = "0".
as400: ResultSet Type Info (3789605) : Type = "1004".
as400: ResultSet Type Info (3789605) closed.
as400: ResultSet Table Types (15995795) open.
as400: ResultSet Table Types (15995795) :
Conncurrency = "1007".
as400: ResultSet Table Types (15995795) : Fetch
direction = "1000".
as400: ResultSet Table Types (15995795) : Fetch size
= "0".
as400: ResultSet Table Types (15995795) : Max rows
= "0".
as400: ResultSet Table Types (15995795) : Type
= "1004".
as400: ResultSet Table Types (15995795) closed.
as400: Statement STMT0001 (31768270) open. Parent:
Connection XXXXXX (12195679) .
as400: Statement STMT0001 (31768270) : Escape
processing = "true".
as400: Statement STMT0001 (31768270) : Fetch
direction = "1000".
as400: Statement STMT0001 (31768270) : Fetch size
= "0".
as400: Statement STMT0001 (31768270) : Max field size
= "0".
as400: Statement STMT0001 (31768270) : Max rows = "0".
as400: Statement STMT0001 (31768270) : Query timeout
= "0".
as400: Statement STMT0001 (31768270) : Result set
concurrency = "1007".
as400: Statement STMT0001 (31768270) : Result set
holdability = "-9999".
as400: Statement STMT0001 (31768270) : Result set
type = "1003".
as400: Statement STMT0001 (31768270) : Behavior
Override = "0".
as400: Statement STMT0001 (31768270) : Data to
correlate statement with cursor Cursor CRSR0001
(11202659) .
as400: Statement STMT0001 (31768270) : Executing
query, SQL Statement -->[SELECT LOCATION FROM
QSYS2.SYSCATALOGS WHERE RDBTYPE = 'LOCAL' AND
RDBASPSTAT='AVAILABLE'].
as400: Statement STMT0001 (31768270) : Prepared
STMT0001*, SQL Statement -->[SELECT LOCATION FROM
QSYS2.SYSCATALOGS WHERE RDBTYPE = 'LOCAL' AND
RDBASPSTAT='AVAILABLE'].
as400: Cursor CRSR0001 (11202659) open.
as400: ResultSet CRSR0001 (1693320) open. Parent:
Statement STMT0001 (31768270) .
as400: ResultSet CRSR0001 (1693320) : Conncurrency
= "1007".
as400: ResultSet CRSR0001 (1693320) : Fetch direction
= "1000".
as400: ResultSet CRSR0001 (1693320) : Fetch size
= "0".
as400: ResultSet CRSR0001 (1693320) : Max rows = "0".
as400: ResultSet CRSR0001 (1693320) : Type = "1003".
as400: Statement STMT0001 (31768270) : Executed
STMT0001*, SQL Statement --> [SELECT LOCATION FROM
QSYS2.SYSCATALOGS WHERE RDBTYPE = 'LOCAL' AND
RDBASPSTAT='AVAILABLE'].
as400: Statement STMT0001 (31768270) : Update count
= -1.
as400: Statement STMT0001 (31768270) : Result set =
true.
as400: Statement STMT0001 (31768270) : Number of
result sets = 0.
as400: Statement STMT0001 (31768270) : Row count
estimate = 1.
as400: Cursor CRSR0001 (11202659) : Closing with
reuse flag = 241.
as400: Cursor CRSR0001 (11202659) closed.
as400: ResultSet CRSR0001 (1693320) closed.
as400: Statement STMT0001 (31768270) closed.
as400: ResultSet Catalogs (5479058) open.
as400: ResultSet Catalogs (5479058) : Conncurrency
= "1007".
as400: ResultSet Catalogs (5479058) : Fetch direction
= "1000".
as400: ResultSet Catalogs (5479058) : Fetch size
= "0".
as400: ResultSet Catalogs (5479058) : Max rows = "0".
as400: ResultSet Catalogs (5479058) : Type = "1004".
as400: ResultSet Catalogs (5479058) closed.
as400: ResultSet Schemas (28838298) open.
as400: ResultSet Schemas (28838298) : Conncurrency
= "1007".
as400: ResultSet Schemas (28838298) : Fetch direction
= "1000".
as400: ResultSet Schemas (28838298) : Fetch size
= "0".
as400: ResultSet Schemas (28838298) : Max rows = "0".
as400: ResultSet Schemas (28838298) : Type = "1004".
as400: ResultSet Schemas (28838298) closed.
as400: Statement STMT0001 (17722557) open. Parent:
Connection XXXXXX (12195679) .
as400: Statement STMT0001 (17722557) : Escape
processing = "true".
as400: Statement STMT0001 (17722557) : Fetch
direction = "1000".
as400: Statement STMT0001 (17722557) : Fetch size
= "0".
as400: Statement STMT0001 (17722557) : Max field size
= "0".
as400: Statement STMT0001 (17722557) : Max rows = "0".
as400: Statement STMT0001 (17722557) : Query timeout
= "0".
as400: Statement STMT0001 (17722557) : Result set
concurrency = "1007".
as400: Statement STMT0001 (17722557) : Result set
holdability = "-9999".
as400: Statement STMT0001 (17722557) : Result set
type = "1003".
as400: Statement STMT0001 (17722557) : Behavior
Override = "0".
as400: Statement STMT0001 (17722557) : Data to
correlate statement with cursor Cursor CRSR0001
(339055) .
as400: Statement STMT0001 (17722557) : Executing
query, SQL Statement -->[SELECT VARCHAR('1', 128) AS
TYPE_CAT, VARCHAR('2', 128) AS TYPE_SCHEM, VARCHAR
('3', 128) AS TYPE_NAME, VARCHAR('4', 128) AS
SUPERTYPE_NAME FROM QSYS2.SYSTYPES WHERE 1 = 2 FOR
FETCH ONLY].
as400: Statement STMT0001 (17722557) : Prepared
STMT0001*, SQL Statement -->[SELECT VARCHAR('1', 128)
AS TYPE_CAT, VARCHAR('2', 128) AS TYPE_SCHEM, VARCHAR
('3', 128) AS TYPE_NAME, VARCHAR('4', 128) AS
SUPERTYPE_NAME FROM QSYS2.SYSTYPES WHERE 1 = 2 FOR
FETCH ONLY].
as400: Cursor CRSR0001 (339055) open.
as400: ResultSet CRSR0001 (27806520) open. Parent:
Statement STMT0001 (17722557) .
as400: ResultSet CRSR0001 (27806520) : Conncurrency
= "1007".
as400: ResultSet CRSR0001 (27806520) : Fetch
direction = "1000".
as400: ResultSet CRSR0001 (27806520) : Fetch size
= "0".
as400: ResultSet CRSR0001 (27806520) : Max rows = "0".
as400: ResultSet CRSR0001 (27806520) : Type = "1003".
as400: Statement STMT0001 (17722557) : Executed
STMT0001*, SQL Statement --> [SELECT VARCHAR('1',
128) AS TYPE_CAT, VARCHAR('2', 128) AS TYPE_SCHEM,
VARCHAR('3', 128) AS TYPE_NAME, VARCHAR('4', 128) AS
SUPERTYPE_NAME FROM QSYS2.SYSTYPES WHERE 1 = 2 FOR
FETCH ONLY].
as400: Statement STMT0001 (17722557) : Update count
= -1.
as400: Statement STMT0001 (17722557) : Result set =
true.
as400: Statement STMT0001 (17722557) : Number of
result sets = 0.
as400: Statement STMT0001 (17722557) : Row count
estimate = 0.
as400: Connection XXXXXX (12195679) : Fetching a
block of data from the server.
as400: ResultSet Tables (7544464) open.
as400: ResultSet Tables (7544464) : Conncurrency
= "1007".
as400: ResultSet Tables (7544464) : Fetch direction
= "1000".
as400: ResultSet Tables (7544464) : Fetch size = "0".
as400: ResultSet Tables (7544464) : Max rows = "0".
as400: ResultSet Tables (7544464) : Type = "1004".
as400: ResultSet Tables (7544464) closed.
as400: Cursor CRSR0001 (339055) : Closing with reuse
flag = 241.
as400: Cursor CRSR0001 (339055) closed.
as400: ResultSet CRSR0001 (27806520) closed.
as400: Statement STMT0002 (5529961) open. Parent:
Connection XXXXXX (12195679) .
as400: Statement STMT0002 (5529961) : Escape
processing = "true".
as400: Statement STMT0002 (5529961) : Fetch direction
= "1000".
as400: Statement STMT0002 (5529961) : Fetch size
= "0".
as400: Statement STMT0002 (5529961) : Max field size
= "0".
as400: Statement STMT0002 (5529961) : Max rows = "0".
as400: Statement STMT0002 (5529961) : Query timeout
= "0".
as400: Statement STMT0002 (5529961) : Result set
concurrency = "1007".
as400: Statement STMT0002 (5529961) : Result set
holdability = "-9999".
as400: Statement STMT0002 (5529961) : Result set type
= "1003".
as400: Statement STMT0002 (5529961) : Behavior
Override = "0".
as400: Statement STMT0002 (5529961) : Data to
correlate statement with cursor Cursor CRSR0002
(29833150) .
as400: Statement STMT0002 (5529961) : Executing
query, SQL Statement -->[SELECT SPECIFIC_SCHEMA,
SPECIFIC_NAME, REMARKS, RESULTS FROM QSYS2.SYSPROCS
WHERE SPECIFIC_NAME LIKE '%' ORDER BY
SPECIFIC_SCHEMA, SPECIFIC_NAME].
as400: Statement STMT0002 (5529961) : Prepared
STMT0002*, SQL Statement -->[SELECT SPECIFIC_SCHEMA,
SPECIFIC_NAME, REMARKS, RESULTS FROM QSYS2.SYSPROCS
WHERE SPECIFIC_NAME LIKE '%' ORDER BY
SPECIFIC_SCHEMA, SPECIFIC_NAME].
as400: Cursor CRSR0002 (29833150) open.
as400: ResultSet CRSR0002 (30440511) open. Parent:
Statement STMT0002 (5529961) .
as400: ResultSet CRSR0002 (30440511) : Conncurrency
= "1007".
as400: ResultSet CRSR0002 (30440511) : Fetch
direction = "1000".
as400: ResultSet CRSR0002 (30440511) : Fetch size
= "0".
as400: ResultSet CRSR0002 (30440511) : Max rows = "0".
as400: ResultSet CRSR0002 (30440511) : Type = "1003".
as400: Statement STMT0002 (5529961) : Executed
STMT0002*, SQL Statement --> [SELECT SPECIFIC_SCHEMA,
SPECIFIC_NAME, REMARKS, RESULTS FROM QSYS2.SYSPROCS
WHERE SPECIFIC_NAME LIKE '%' ORDER BY
SPECIFIC_SCHEMA, SPECIFIC_NAME].
as400: Statement STMT0002 (5529961) : Update count = -
1.
as400: Statement STMT0002 (5529961) : Result set =
true.
as400: Statement STMT0002 (5529961) : Number of
result sets = 0.
as400: Statement STMT0002 (5529961) : Row count
estimate = 14.
as400: Connection XXXXXX (12195679) : Fetching a
block of data from the server.
as400: Connection XXXXXX (12195679) : Fetching a
block of data from the server.
as400: Connection XXXXXX (12195679) : Fetching a
block of data from the server.
as400: Cursor CRSR0002 (29833150) : Closing with
reuse flag = 241.
as400: Cursor CRSR0002 (29833150) closed.
as400: ResultSet CRSR0002 (30440511) closed.
as400: Statement STMT0002 (5529961) closed.
as400: ResultSet Procedures (15695220) open.
as400: ResultSet Procedures (15695220) : Conncurrency
= "1007".
as400: ResultSet Procedures (15695220) : Fetch
direction = "1000".
as400: ResultSet Procedures (15695220) : Fetch size
= "0".
as400: ResultSet Procedures (15695220) : Max rows
= "0".
as400: ResultSet Procedures (15695220) : Type
= "1004".
as400: ResultSet Procedures (15695220) closed.
as400: Statement STMT0002 (9568605) open. Parent:
Connection XXXXXX (12195679) .
as400: Statement STMT0002 (9568605) : Fetch direction
= "1000".
as400: Statement STMT0002 (9568605) : Fetch size
= "0".
as400: Statement STMT0002 (9568605) : Max field size
= "0".
as400: Statement STMT0002 (9568605) : Max rows = "0".
as400: Statement STMT0002 (9568605) : Query timeout
= "0".
as400: Statement STMT0002 (9568605) : Result set
concurrency = "1007".
as400: Statement STMT0002 (9568605) : Result set
holdability = "-9999".
as400: Statement STMT0002 (9568605) : Result set type
= "1003".
as400: Statement STMT0002 (9568605) : Behavior
Override = "0".
as400: Statement STMT0002 (9568605) : Data to
correlate statement with cursor Cursor CRSR0002
(26707741) .
as400: Statement STMT0002 (9568605) : Executing
query, SQL Statement -->[SELECT VARCHAR('1', 128) AS
TYPE_CAT, VARCHAR('2', 128) AS TYPE_SCHEM, VARCHAR
('3', 128) AS TYPE_NAME, VARCHAR('4', 128) AS
SUPERTYPE_NAME FROM QSYS2.SYSTYPES WHERE 1 = 2 FOR
FETCH ONLY].
as400: Statement STMT0002 (9568605) : Prepared
STMT0002*, SQL Statement -->[SELECT VARCHAR('1', 128)
AS TYPE_CAT, VARCHAR('2', 128) AS TYPE_SCHEM, VARCHAR
('3', 128) AS TYPE_NAME, VARCHAR('4', 128) AS
SUPERTYPE_NAME FROM QSYS2.SYSTYPES WHERE 1 = 2 FOR
FETCH ONLY].
as400: Cursor CRSR0002 (26707741) open.
as400: ResultSet CRSR0002 (19375260) open. Parent:
Statement STMT0002 (9568605) .
as400: ResultSet CRSR0002 (19375260) : Conncurrency
= "1007".
as400: ResultSet CRSR0002 (19375260) : Fetch
direction = "1000".
as400: ResultSet CRSR0002 (19375260) : Fetch size
= "0".
as400: ResultSet CRSR0002 (19375260) : Max rows = "0".
as400: ResultSet CRSR0002 (19375260) : Type = "1003".
as400: Statement STMT0002 (9568605) : Executed
STMT0002*, SQL Statement --> [SELECT VARCHAR('1',
128) AS TYPE_CAT, VARCHAR('2', 128) AS TYPE_SCHEM,
VARCHAR('3', 128) AS TYPE_NAME, VARCHAR('4', 128) AS
SUPERTYPE_NAME FROM QSYS2.SYSTYPES WHERE 1 = 2 FOR
FETCH ONLY].
as400: Statement STMT0002 (9568605) : Update count = -
1.
as400: Statement STMT0002 (9568605) : Result set =
true.
as400: Statement STMT0002 (9568605) : Number of
result sets = 0.
as400: Statement STMT0002 (9568605) : Row count
estimate = 0.
as400: Connection XXXXXX (12195679) : Fetching a
block of data from the server.
SQLException: SQLState(HY001) vendor code(-14)

Discussion

  • Gerd Wagner
    Gerd Wagner
    2006-02-26

    Logged In: YES
    user_id=776065

    None of us has access to DB 400 to reproduce your problem.
    But I would really be interested in it. So here is my
    proposal: If you could give me access to DB 400 via VPN
    1. I would take care of your problem(s)
    2. I would try to write a DB 400 plugin for SQuirreL that
    would allow you to script views and stored procedures from
    within SQuirreL's object tree. I know how to do that on DB2
    for Linux and hope it wouldn't be much harder on DB400.

    Im closing this bug. In case you could give me access to
    DB400 please feel free to reopen it and contact me at
    gerdwagner@users.sourceforge.net

     
  • Gerd Wagner
    Gerd Wagner
    2006-02-26

    • status: open --> closed