Executes stored procedures or data
definition SQL statements (CREATE / ALTER / DROP TABLE). Data
manipulation SQL statements (INSERT / UPDATE / DELETE / SELECT) are
not allowed.
Syntax
DataRdbmsStatement(<statement>)
Parameters
statement
The statement to be executed.
NOTE:
Manipulations triggered by a statement that is executed with
this action (for example a stored procedure) will not be checked
for conceptual violations or for authorization. USoft is not
responsible for any data integrity loss when this action is
used.
Oracle
DataRdbmsStatement('CREATE TABLE
<table_name> (<column_name>
<data type> [,<column_name> <data
type>...])')
SqlScript(action
DataRdbmsStatement('BEGIN
<package_name>.<proc_name>('||:"<embedded
method call>"||'); END;'))
DataRdbmsStatement(<plsql_block>)
Sybase
DataRdbmsStatement(ALTER TABLE
<table_name>
ADD <column_name> <data type>
NULL)
SqlScript(action DataRdbmsStatement('exec
<proc_name> '||:"<embedded method call>"))
It is recommended that you
restrict the use of DataRdbmsStatement() to data
definition and to tables that do not belong to a USoft
application.
|