brainchime.com Latest Questions

Admin
Asked: 2024-10-06T07:46:16+05:30 In:

How can i use SQL if the IBM i does not have STRSQL installed?

How can I run SQL queries if STRSQL is not installed on my IBM i machine? I need to get some information from the tables and I noticed that STRSQL is not installed at all on one of the IBM i systems.

as400db2

Related Questions

Leave an answer

Leave an answer

Browse
Browse

Choose from here the video type.

Put Video ID here: https://www.youtube.com/watch?v=sdUUx5FdySs Ex: "sdUUx5FdySs".

1 Answer

  1. Admin

    In that situation, you can use System i Navigator. You can follow the below steps to  run SQL queries using System i Navigator instead of STRSQL.

    1. Start  System i Navigator and log in with the user ID and password.
    2. Go to My Connections -> Your System->Databases->Schemas.
    3. In the bottom right panel of Databases tasks, you will see the option Run an SQL script.
    4. Click on it. The Untitled -Run SQL scripts- system name window opens and there you can type your SQL queries and run them. Please note that you must use .(dot) instead of /(slash) to qualify the library name with the file.