Superx++ and Databases

Purpose Superx++ implements statements that access data from relational databases as well as update them. Superx++ also implements statements that obtain data from relational databases and places that data in new or existing XML nodes.

The Database Statements
<dbconnect> creates a connection to a database
<dbremove> removes/deletes a connection to a database or a persisted recordset
<dberr> returns errors from the DBMS associated with a database connection
<dbopen> opens a connection to a database
<dbclose> closes a connection to a database
<dbselect> performs a SQL SELECT statement on a database, generates a persistent recordset and creates an XML tree from the relational data
<dbinsert> performs a SQL INSERT statement on a database based on XML nodes that have been traversed
<dbupdate> performs a SQL UPDATE statement on a database based on XML nodes that have been traversed
<dbdelete> performs a SQL DELETE statement on a database based on XML nodes that have been traversed
<dbproc> performs a stored procedure call on a database based on XML nodes that have been traversed
<dbstatement> performs a SQL statement on a database
Use of the <parm> clause the <parm> clause is used in the database statements above to parameterize the creation of the SQL statements and to provide the parameters for stored procedure calls. For details click on the links above for each statement.
Use of the <sql> clause the <sql> clause is used in the database statements above to contain the SQL statements to be executed against the database. For details click on the links above for each statement.

Concepts
Relational to Object Data Conversion Because Superx++ is based on XML and you can use the <dbselect> statement to generate XML nodes, it is quite possible to create Superx++ objects from the <dbselect> statement.
Relational to XML Data Conversion Use the <dbselect> statement to generate XML nodes. This is a practical means of converting data from relational format to hierarchical (XML) format. This process is called node growth because the nodes in the XML tree are grown from the relational data.
XML to Relational Data Conversion Use the <dbinsert>, <dbupdate>, <dbdelete> or <dbproc> statements to create or modify data in a relational database based on XML data in XML trees. This is a practical means of converting data from hierarchical (XML) format to relatinal format. This process is called traversal dumping because you traverse through the XML nodes and perform the database statements at specific nodes in the traversal.