QSQSRVR 8.96

[craig_welton]

Hello all,

We are having an issue with robot jobs when using tools release 8.96

RUNUBE is called from a CL and can be followed by RUNSQLSTM to perform a database query. With the tools release, the process is set to SQL Server Mode which causes all SQL statements to be handled by QSQSRVR. The SQL statements used in the RUNSQLSTM command do not qualify the tables with libarary names, instead relying on the library list which is set in the CL. This is now a problem since QSQSRVR does not inherit or know about the lib list of the CL it is servicing.

I understand that the SQL Server mode cannot be turned off once it is enabled for a job. Does anyone know of a way to disable it in JDE or have an idea to work around this?

thanks,
Craig

 

[jean_driscoll]

Have you gone to HelP Systems with this issue? I was told that their product worked with 8.96 and not to worry. We've just bought Robot and are getting ready to implement with 8.96.

If you only have one environment to worry about, the QSQSRVR jobs are defined in QSYSWRK as Prestart job entries which have a job definition attached. that jobd could be updated with a library list. however, not sure how this could work for multiple environments on the same AS/400.

Subsystem description: QSYSWRK Status: ACTIVE

Program . . . . . . . . . . . . . . . . . . . . : QSQSRVR
Library . . . . . . . . . . . . . . . . . . . : QSYS
User profile . . . . . . . . . . . . . . . . . . : QUSER
Job . . . . . . . . . . . . . . . . . . . . . . : QSQSRVR
Job description . . . . . . . . . . . . . . . . : QDFTSVR
Library . . . . . . . . . . . . . . . . . . . : QGPL
Start jobs . . . . . . . . . . . . . . . . . . . : *NO
Initial number of jobs . . . . . . . . . . . . . : 5

 

[craig_welton]

Thanks Jean,

We have multiple environments, but we have found a fix. After several support calls, it turns out the SQL Server Mode can be disabled by a JDE.INI setting.

[DB SYSTEM SETTINGS]
sqlServerMode=0

Craig