|
From: Roger H. <rh...@hi...> - 2019-02-13 18:22:16
|
Try library.table not library/table. SQL notation not CL. Roger --- *************************** Roger Hill *************************** On 2019-02-13 15:21, John Tremper wrote: > 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 > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
