www.krengeltech.com

DB2WSE Full Request Format

From Wiki

User Guide

Key to Syntax Diagrams

  • {required-string} A required string (may be a single value or multiple options)
  • [optional-string] An optional string (may be a single value or multiple options)
  • option-1|option-2 Separate options are separated by a vertical bar (|)
  • repeated-string... Repeated strings are suffixed with an ellipsis (...)

The general format of a DB2WSE request (full format) is as follows: 

<DB2WSEREQ>
  <STATEMENT [attributes]>
    {sql-statement}
  </STATEMENT>
  <USER>{username}</USER>
  <PASSWORD>{password}</PASSWORD>
</DB2WSEREQ>

which would be sent in an HTML document form using the HTTP or HTTPS protocol as follows: 

http[s]://{server-address}[:{port}]/db2wse/

Examples of valid SQL statements are as follows: 

SELECT * FROM PETSTORE/ITEM
 
SELECT * FROM petstore/item WHERE itemid = 'EST-1'
 
SELECT productid, name FROM PetStore/Product WHERE category LIKE '%IS%'
 
INSERT INTO petstore/product VALUES('RP-LI-03', 'REPTILES', 'Gecko', '<image src="../images/lizard3.gif">Cool green lizard')
 
UPDATE petstore/item SET attr2 = 'INVALID' WHERE attr2 IS NULL
 
DELETE FROM petstore/product WHERE category = 'REPTILE'

DB2WSE request elements, attributes and attribute values are case-independent. SQL statements are case-independent, except for quoted strings.

Retrieved from "http://iwiki.krengeltech.com/wiki/DB2WSE_Full_Request_Format"