The STR(CON)SQL Toolkit uses the full functionality of the IBM built in SQL engine in any iSeries (AS/400). It is free and behaves very similar to STRSQL of the charged SQL/400 license program.
Have a look at the new and free STRSQL toolkit:
After you enter your name and mail adress you will receive a user and password for the download. This will work very fast.
You will download the zip compressed SAVF and the english documentation. Just follow the docu and you are fine.
When you start the command STRSQL or STRCONSQL the first time, you have to select your preferred language. You should enter "01" for german or "03" for english and then you have to hit F6 for "Processing" as enter is not sufficient at this point. Later on in the toolkit you can always use enter or F6 for precessing.
Have fun with this nice tool !!!!
The interesting trick here is, that IBM built in the complete SQL engine in any iSeries (AS/400, AS400) and only created special license costs to the STRSQL frontend. If you are able, to code iSeries syntactically correct SQL code, you can use the following idea for running any SQLs on your server. You type them into a source file, compile them and run them on your server. The performance will be the same as with the expensive STRSQL. For sure, this is supported from the free SQLUTIL, which is available via a special PTF, as well. But, STRSQL & SQLUTIL can normally run in dialog only, if you don't want to code an RPG program around (only possible with STRSQL) it. So, you might run into performance problems on a box with limited interactive power. So, you might want to run them in batch anyway.Here you see one example for the creation of an index with OS/400 SQL means:
CRTSRCPF FILE(SAPTEST/QQMQRYSRC) RCDLEN(91)
CREATE INDEX R3DATA/z<table> ON R3<sid>DATA/<table> (<key1>, <key2>, ...)
CRTQMQRY QMQRY(SAPTEST/Z<TABLE>) SRCFILE(SAPTEST/QQMQRYSRC)
SBMJOB CMD(STRQMQRY QMQRY(SAPTEST/Z<TABLE>)) JOB(Z<TABLE>) JOBQ(QS36EVOKE)
( STRCONSQL, STRSQL, SQLUTIL, SQL, batch, AS400, OS400, as400, os400, AS/400, OS/400 )