Re: SQL0666 on VB application doing SQL on AS400 file

I have found that since the SQL errors issued by VB or VBA (or any ODBC connection) are vague and mostly useless.

What I do is to run the SQL statement using VB or the ACS Run SQL Scripts on my laptop and simultaneously use WORKOBJLCK on my user profile on the system and review the messages found in the job log of the QZDASONIT or QRWTSRVR jobs that are running behind the scenes to implement the SQL calls. If it is still active you can use CHGJOB and change the logging level of those jobs and run the SQL again to get more detailed information.

Regards,
Steve Landess
(512) 289-0387

________________________________
Charles wrote:
The error my VB applications is getting is SQL0666.

The error my VB applications is getting is SQL0666.

In my research I found this link, https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.itjungle.com%2F2005%2F07%2F13%2Ffhg071305-story03%2F&data=05%7C02%7C%7Cfa160264d3e14b1e463708de5ac7b008%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C639048010869713077%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=81ISkbYFVCdYXwmRYCuRsu%2B13Pn4ZSCmXfJguzWVi3M%3D&reserved=0<https://www.itjungle.com/2005/07/13/fhg071305-story03/>
System value QQRYTIMLMT is *NOMAX. Following the instructions in the itjungle link, I went to ODBC Data Source Configuration.
I checked every Data Source, there were four, only one allowed "Configure," the others it was greyed out.
That one, I saw and unclicked "Enable Query Timeout" and clicked ok.
I'm still getting the error. I'm not sure how to fix this time out issue.

Thanks,
Charles Versfelt
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=05%7C02%7C%7Cfa160264d3e14b1e463708de5ac7b008%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C639048010869776953%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=ZOwSlydbBwNwq2XdRAc0%2F15E6IrKVCfa5AtBuVuiAvg%3D&reserved=0<https://lists.midrange.com/mailman/listinfo/midrange-l>
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&data=05%7C02%7C%7Cfa160264d3e14b1e463708de5ac7b008%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C639048010869832486%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=E5syZbSZmUR1k%2FPZobZSlLFTvjVTprN%2BS26uw4hk4FM%3D&reserved=0<https://archive.midrange.com/midrange-l>.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.