EZSQL003 SQL error code 00000

Products

• PanAudit Plus
• Easytrieve Report Generator
• PAN/SQL

Issue/Introduction

EZSQL002 SQL program dqspsxs ended with return code 0016.

EZSQL003 SQL error code 00000,

SQLAllocStmt error, SQLCODE = 0, SQLSTATE = 00000

 

...

Environment

Release: EDBMSU00200-11.5-Easytrieve-Report Generator-Option for DB2-MSU
Component:

Cause

No SQL CONNECT - because when using CURSOR with an ODBC driver, SQL CONNECT is required.

Resolution

CONNECT to the data base as shown in the sample. Click this link please: CA Easytrieve SQL CONNECT on Windows example.mht

It contains a CA Easytrieve source example how to use SQL CONNECT with Microsoft SQL Server on Windows 7 with all the data base and ODBC Driver details.