EXECSQL |
Execsql is used to launch a SQL request that does not require a return of information.
Execsql From type_base Sql sql_exp
|
Element |
Description |
Restrictions |
|
type_base |
alphanumeric character describing the database type. |
|
|
sql_exp |
Character string or character string grid containing the SQL request |
225 elements in the grid |
# in the creation and update process for the table structures.
# use of the configuration file
Local Char BASE(1)
Case [F:ADS]TYPDBA
When 1 : BASE = "3"
When 2 : BASE = "5"
When 3 : BASE = "2"
When 4 : BASE = "4"
Endcase
Execsql From BASE Sql REQUETE(1..NBREQ)
Execsql is used to launch a SQL request that does not require the return of information, unlike the instruction For...From...Sql that recovers the columns. This instruction is used, for example, to launch a Sql grant command that is used to accord the rights to a table.
The parameter type_base is used to indicate the database type to be accessed :
- "o","O","3" to describe an Oracle database
- "s","S","5" to describe a SQL 7 database.
The sql_exp parameter is used to indicate the sql request. It is expressed by a character string or else a grid. When using a grid, the request expression is made up of the concatenation of character strings. This grid is limited to 255 elements.
|
Error |
Description |
|
|
|
|
|