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.
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)