|
From: John T. <Joh...@na...> - 2019-02-13 17:54:08
|
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... 816.713.8716 |
