Ways to Use the SQL Language

Not all interfaces are documented in the English version of the help.

The SQL language is a basic tool for manipulating data stored in the 602SQL database. A SQL statement may be executed on the server in the following ways:

The statement may be part of a stored procedure or trigger on the server.
The statement may be executed from a program in an external programming language (C/C++ or Pascal/Delphi) using the SQL_execute function.
The statement may be executed using the TSQL602Statement component that exists in the CDK interface for Delphi.
The statement may be executed using the wb_exec and wb_psql_execute statements from the PHP module.
A client connected to the server using ODBC or JDBC can use the API of the appropriate driver.

If you want to execute the same statement repeatedly (e.g. with variable data), the following options are available:

Use a stored procedures with input and output parameters to pass values when the procedure is called.
Separate the SQL statement preparation and execution for statements executed by the client using the SQL_prepare and SQL_exec_prepared functions.
statements may contain references to client variables described in the structure passed to the SQL_host_execute function or if the preparation and execution is separated, the variables are described when calling the SQL_host_prepare function and the statement is executed using the SQL_exec_prepared function.
statements passed through the ODBC interface or from the PHP module may contain dynamic parameters.

You can also use the following methods for entering SQL statements when developing applications:

statements may be executed directly using the SQL Console window in the 602SQL Client. The statement is executed immediately and the result is displayed in the Output window or in a separate window (using a SELECT statement).
Procedures stored on the server may be called directly from the 602SQL Client.
You can also use the text console 602cliXX on Linux to enter statements.

List of topics:

SQL Syntax Description in 602SQL

SQL Language in 602SQL

Lexical Elements of the SQL Language