Search code examples
ibm-midrange

How to get the STRSQL version in AS400?


it is really hard to find out the version, I tried checking SYSIBM or SYSPROC but I cannot find it. I'm not sure if this will help but if I use VER command in Command Entry it will show this:

SMART Version R20.0 Installed.
Diary Version R20.0 Installed.
MSP Version 3.0 Installed.

I wanted to find out the version so that I can research on specific syntax for that version. It is really hard to just refer to SQL commands since it seems the version AS400 is using is old.


Solution

  • STRSQL doesn't have a version..

    Or rather it's simply an optionally installed piece of the OS. Note that the DB itself is part of the OS also.

    You need to determine the OS version you're running. Instead of running STRSQL at the command line try on of these:

    • DSPDTAARA DTAARA(QSS1MRI)
    • DSPPTF
    • GO LICPGM -> Option '10'

    Also, your VER command entry output is not from IBM i (aka AS/400)