Re: STRSQL missing

DSPSFWRSC
Resource
ID Option Feature Description
5770ST1 *BASE 5050 IBM DB2 Query Manager and SQL Development Kit
for i
5770ST1 *BASE 2924 IBM DB2 Query Manager and SQL Development Kit
for i

WRKOBJ *ALL/STRSQL
Object Type Library Attribute Text
STRSQL *CMD QSQL Start SQL Interactive Sessi
STRSQL *CMD QSYS PRX Start SQL Interactive Sessi
STRSQL *CMD QSYSV5R4M0 START SQL INTERACTIVE SESSI
STRSQL *CMD QSYSV6R1M0 START SQL INTERACTIVE SESSI

If you have 57##ST1 but no strsql I suspect an overzealous security admin.
Sometimes they do renames, sometimes they secure them out.

Try this to see if it's secured.
dspobjd qsql/strsql *cmd
that will give a security message. Do NOT try WRKOBJ. That will simply
not list it.

If you know their renaming pattern, like following it with an x, you can
try
WRKOBJ STRSQL*

Remember, you can always use iNav's Run SQL Scripts if you do not have
STRSQL. Even if you do not have 57##ST1 and even if you do not have the
System i Access for Windows loaded on the platform! Consider it another
5250 tax.

Rob Berendt