PURPOSE: OSQL HELP provides assistance to the application designer about the characteristics and syntax of the On-line Structured Query Language (OSQL) facility. A Data Base Library (DBL) must be declared for this command to work.
OSQL {HELP; ?; SYNTAX} [command_name]
|
command_name |
specifies the name of the OSQL command to be described. If no command is specified, HELP will describe itself. |
|
HELP |
supplies a description and syntax for a specified OSQL command. |
|
? |
functions identical to the HELP keyword. |
|
SYNTAX |
lists only the syntax associated with a specified OSQL command. |
*osql help insert
Help for the OSQL INSERT command: This command adds or inserts one or more rows of data into the specified table. If the WITH WINDOW clause is specified, then an DMF window will be displayed on the screen. If the DEFINE PM clause is included, then the process module created to execute the command will be saved in the current DBL under the object name specified.
Syntax for the OSQL INSERT command: For Oracle Data Base Engines:
OSQL INSERT /INTO/ table_name
[(column_list)]
{WITH WINDOW; VALUES (\\constant_expression\\); select_str_exp}
[INCLUDE include_list]
[DEFINE PM pm_name [ONLY]]
For DB-MACH2 and RMS Data Base Engines:
OSQL INSERT /INTO/ table_name WITH WINDOW
[INCLUDE include_list]
[DEFINE PM pm_name [ONLY]]