Executing Remote Commands via ODBC-compliant Application and CONNX
You can use any ODBC-compliant application to execute OS/400 remote commands via CONNX, provided that the application supports the SQLExecDirect or SQLPrepare/SQLExecute API call sequence.
1. Create a library = CNXTEST.
Syntax:
CRTLIB LIB(CNXTEST)
If you use InfoNaut, InfoNaut will display an information dialog box on a successful execution.
2. Copy the file NULLID/TESTNULLS to CNXTEST/TESTNULL.
Syntax:
CPY FROMFILE (NULLID/TESTNULLS) TOFILE (CNXTEST/TESTNULLS)MBROPT(*REPLACE)CRTFILE(*YES)
3. Delete the library CNXTEST.
Syntax:
DLTLIB LIB(CNXTEST)