EZSQL003 SQL error code 00000

book

Article ID: 5358

calendar_today

Updated On:

Products

CA PanAudit Plus CA Easytrieve Report Generator CA PAN/SQL

Issue/Introduction

EZSQL002 SQL program dqspsxs ended with return code 0016.

EZSQL003 SQL error code 00000,

SQLAllocStmt error, SQLCODE = 0, SQLSTATE = 00000

 

...

Cause

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

Environment

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

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.

Attachments

1558533922079TEC1905866.zip get_app