DBSEND

8.0.4, PLBCMP GUI or PLBLinux Only

The DBSEND instruction builds a complete or partial SQL statement that can be sent to the database engine using a DBEXECUTE instruction. The instruction uses the following format:

Where:

label

Optional. A Program Execution Label.

dbfile

Required. A DBFILE or DBSTATEMENT variable defining the database associated with the connection.

list

Required. A comma-delimited set of controls, variables and literals composing the query.

Flags Affected: none

Note the following:

1. The DBSEND instruction builds an SQL statement for execution by the DBEXECUTE instruction. Multiple DBSEND instructions may create the query.

2. The DBSEND does not execute the SQL statement. The DBEXECUTE instruction actually executes the SQL statement.

3. The supported list controls are as follows:

 

Control	Function
*LC	Disable *UC (default)
*LL	Send only the Logical String of any character string variables
*PL	Blank-fill after the Length Pointer through the Physical Length (default)
*SL	Send the contents of any character string variable starting with the first character in the variable through the character pointed to by Length Pointer
*UC	Convert lower case data to upper case in both variables and literals.
*ZF	Zero-fill variables
*ZFON	Zero-fill variables until a *ZFOFF is encountered or the end of the statement.
*ZFOFF	Cancel *ZFON list control before the end of statement.
*ZS	Send the contents of the next variable as blanks when it is a numeric variable with a value of zero.s

4. In Windows, the maximum size of one query string is 1,048,576 characters. If the query list contains more characters than the maximum size of a query string, a D202 error is given.

See Also: Example Code, SQL Instructions