ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Execute SQL statements in the IBM i

book

Article ID: 41305

calendar_today

Updated On:

Products

CA Plex

Issue/Introduction

Question:

I execute SQL statements and want to acquire the number of the data, is it possible?

Answer: 

When you want to execute SQL statements for a physical file of DB2/400, there are two possible ways.
1. Integration of the SQL statement using FNC language SQLRPG400 triple and API Call.
2. Use of ODBC driver "Client Access ODBC Driver (32-bit)" or "iSeries Access ODBC Driver" provided by IBM .

* The SQL statement of the user making incorporates it by Exec SQL order of the action diagram.

Environment

Release: ESBPLX99000-7.1-Cool Plex-Extended Support Basic
Component: