I connect to an AS400 database using DBeaver and ODBC, it lets me run CRUD operations better than the 5250 Emulator. Is there a way to run from DBeaver command lines like WRKUSRPRF or CHGUSRPRF?
Asked
Active
Viewed 226 times
-1
-
1Don't know AS400, but for LUW you have to run utilities outside of sql (load, reorg etc) as `CALL SYSPROC.ADMIN_CMD('...')`. Perhaps there is something similar for AS400? – Lennart - Slava Ukraini Feb 22 '23 at 09:22
-
You are using dBeaver and ODBC to connect to DB2 for i? I would expect JDBC instead. – jmarkmurphy Feb 22 '23 at 14:46
1 Answers
2
You can't use commands that start with WRK without a 5250 session, some will run and produce a list of elements as a spooled file but many will just refuse to run.
You can run a command in any SQL client using QSYS2.QCMDEXC stored procedure or function
IBM i Services provide views, procedures and functions you can use to retrieve information about the system and make some changes (see CHANGE_USER_PROFILE)
If you use IBM i Access - Client Solutions maybe the "run SQL scripts" option is installed. It provides a cl:<command> syntax and can prompt statement
If what you want is more "modern" interface then you can use IBM Navigator for i depending on version and PTF installed on your server. Check http://<your server>:2001
nfgl
- 2,812
- 6
- 16