RUNSQL pre-V7R1 (CLSQL)

Where allowed to run: All environments (*ALL)
Threadsafe: No
Parameters
Examples
Error messages

Deprecated command. Use the SQL iQuery RUNIQRY command instead.

The RUNSQL (CLSQL) command provides support similar to the IBM i V7R1 RUNSQL command, however CLSQL runs on all ILE versions of OS/400, IBM i5/OS and IBM i. In addition, it can be compiled back to V3R1 if needed. CLSQL was originally named RUNSQL and written and copyrighted by Bob Cozzi back in 1990. It was repackaged as "SQL Lite" during most of the 1990s and withdrawn from market in 2002. Recently IBM included a CL command named "RUNSQL" with an IBM i v7r1 TR (technology refresh) that only works on V7R1 and later. This caused problems for thousands of users who owned SQL Lite and/or wrote their own RUNSQL command. During 2014, Cozzi Productions, Inc. the owner of SQL Lite and author of the original RUNSQL command, introduced a new SQL product named, "SQL iQuery". This product includes the RUNIQRY and RUNIQRYF commands that provide more advanced capbilities than the SQL Lite package and IBM's RUNSQL command. Visit www.cozTools.com/qryFile for details on the SQL Query File package.

Top

Parameters

Keyword Description Choices Notes
SQL SQL Statement to run Character value Required, Positional 1
Top

SQL Statement to run (SQL)

Specifies the SQL statement to run. Any non-SELECT statement is usually supported. For support of the SELECT statement, you need to order Licensed Program 2COZIQ3 from Cozzi Productions, Inc. www.cozTools.com/iQuery

This is a required parameter.

character-value
Specify the SQL statement to be run immediately. The statement is run with COMMIT(*NONE) using NAMING(*SYS).
Top

Examples for CLSQL

Example 1: Simple Command Example

CLSQL  SQL('DELETE FROM CUSTMAST WHERE DLTCODE = ''D''')

This command removes all records from CUSTMAST that have a delete code equal to the letter D.

Top

Error messages

Unknown
Top