|
>>Apparently STRSQL is not on the system. > That puts a crimp in things, but not a fatal one. If you have Query/400 you > can use that in place of STRSQL. Or you can use QMQRY. I am pretty sure > the FAQ has an entry on using it. http://faq.midrange.com The point is > that if you run an SQL statement in a job with debug active, the SQL > optimiser puts messages in the job log describing what it considered before > running the statement. You could also use the SQL script option in OpsNav, it has the same capabilities of giving access at the optimizer messages. Bonne réception/Best regards Richard THEIS AS/400 Education, France theis_richard@fr.ibm.com
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.