Execute SQL statements in the IBM i

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: