DataRdbmsStatement()

Previous Next

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.