DB_STD_SQL

Syntax

Example

Description/ Remarks

DB_STD_SQL "database_type"

DB_STD_SQL "SPC"

DB_STD_SQL "DMS"

DB_STD_SQL "SPC*"

DB_STD_SQL "DMS*"

See XML and Record Buffer Template Commands for sample templates showing how the XML and Record Buffer commands work together.

Returns a SQL string to be used to insert into the VSTDS or DSTDS table.

Possible database types are "DMS", "DMS*, "SPC,  and "SPC*".

If the "DMS" or "SPC" parameter is used, this command returns a string for use with the SQL INSERT command. If you want to do things such as UPDATE, build your own string with the DB_SET_VALUE and DB_VALUE commands.

If a value has not been set, a default will be returned.

If the "DMS*" or "SPC*" parameter is used, this command will return an entire SQL INSERT command, ready for executing.  This SQL command contains the "INSERT INTO..." section at the beginning of the text.