EXECSQL

Summary


Execsql is used to launch a SQL request that does not require a return of information. 

Syntax

   Execsql From type_base Sql sql_exp

 

Parameters

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

Examples

# 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)

 

Description and comments

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.

Associated errors

Error

Description

 

 

Associated keywords

Anasql - For...From...sql


SUMMARY


Copyright © Sage 1999 - 2007