|
From: Alex M. <ale...@bl...> - 2019-02-13 18:34:01
|
I do not recall having any problems with Squirrel when working with iSeries. Should you not fully qualify the tables using a period? I.e. IESPROOF.custmast? Also, it could help if you set the default schema in the Squirrel alias to the library your table belongs to, but I am not 100% sure of this. Thanks Alex From: John Tremper <Joh...@na...> Sent: Wednesday, February 13, 2019 10:22 AM To: squ...@li... Subject: [Squirrel-sql-users] configuration using JT400 driver to AS400 Hello, I have used squirrel in the past and am trying to get it configured correctly at a new job. I am attempting to connect to an AS400(iSeries, series I, etc). I downloaded the JT400 jar and placed it in the same directory squirrel is installed. I created the alias and connected successfully when I hit the test button. On the schemas tab, I have the 'Specify Schema Loading and Caching' radio button selected. I have all schema, tables, views, procedures, and UDTs set to 'Don't Load'. On the 'Driver Properties' tab everything is greyed out (???). When I try to run a simple query like: select * from custmast I get the following error: Error: [SQL0204] CUSTMAST in TREJ type *FILE not found. SQLState: 42704 ErrorCode: -204 TREJ is my user id. If I fully qualify the sql statement: select * from IESPROOF/custmast, I get the following error: Error: [SQL5016] Qualified object name CUSTMAST not valid. SQLState: 42833 ErrorCode: -5016 I am hoping this is just a simple configuration issue. Any help is appreciated. I really like squirrel and would be lost without it. Thanks, John Tremper joh...@na...<mailto:joh...@na...> 816.713.8716 |
