maikeru-sama
Active Member
1) For iSeries, I am getting an error when I try to run queries. I am not at work, so I don't know the exact error but it has something to with invalid syntax when I use "Schema/F0411"
For example: "SELECT * FROM Schema/F0411", it says I need to use another authorative syntax instead of SQL Syntax. Now in my ODBC, I go to the proper ODBC Connection and change one of the tab values to go by SQL name and it still gives me the error. This leads me to my second question.
2) We have Development, Test, Prototype and Production data. In iSeries, when I choose to build SQL Statement, how do I know which environment I am querying? All you have to do is choose your AS/400 in the tree and then choose to build SQL statement, but I don't know which environment I am hitting, so I am probably changing the wrong property in ODBC connection I mentioned in Question 1.
3) Does Toad not support AS/400 OS400? I don't think it does, but I wanted to talk to some who are familiar with it first. In the OS dropdown, there is no option for OS400.
Thanks
For example: "SELECT * FROM Schema/F0411", it says I need to use another authorative syntax instead of SQL Syntax. Now in my ODBC, I go to the proper ODBC Connection and change one of the tab values to go by SQL name and it still gives me the error. This leads me to my second question.
2) We have Development, Test, Prototype and Production data. In iSeries, when I choose to build SQL Statement, how do I know which environment I am querying? All you have to do is choose your AS/400 in the tree and then choose to build SQL statement, but I don't know which environment I am hitting, so I am probably changing the wrong property in ODBC connection I mentioned in Question 1.
3) Does Toad not support AS/400 OS400? I don't think it does, but I wanted to talk to some who are familiar with it first. In the OS dropdown, there is no option for OS400.
Thanks