SQL Statement Generation

Virtual Machine

Trail: PROIV Documentation > Administration > Environment Guide > SQL Statement Generation

The following statement formats are generated by PROIV for MySQL within Transparency mode.

Read File - Single Row

SELECT key-col-name-1, key-col-name-2, ..., col-name-1,col-name-2 ...{ ,ROWID}
FROM table-name
WHERE key-column-name-1 = :key-column-name-1 AND key-column-name-2 = :key-column-name-2 ...
{FOR UPDATE OF column-name-1, column-name-2, ... }

The optional parameters (shown in brackets) are included in change and update modes only.

Read File - Multiple Rows

SELECT key-col-name-1, key-col-name-2 ...col-name-1, col-name-2 ...
FROM table-name
WHERE key-col-name-1 BETWEEN: key-col-name-1-hi
AND :key-col-name-1-lo,
AND key-col-name-2 BETWEEN :key-col-name-2-hi
AND :key-col-name-2-lo,
AND ...
ORDER BY key-col-name-1, key-col-name-2 ...

Update File

UPDATE table-name
WHERE ROWID = :ROWIDVAR
SET(col-name-1 = :col-name-1, col-name-2 = :col-name-2, ...)

or

DELETE FROM table-name
WHERE ROWID = :ROWIDVAR

or

INSERT INTO table-name
SET (key-col-name-1, key-col-name-2, ... col-name-1, col-name-2 ...)
VALUES (:key-col-name-1, :key-col-name-2, ... :col-name-1, :col-name-2, ...)  

 

 

Comment on this topic

Topic ID: 720299