NUQL:COMMANDS
path: NUWIKI > CHRISTIAN EYERMAN > CATEGORY:EDUCATION > MODERNIZATION PROFESSIONAL SERVICES > NUQL:COMMANDS
NUQL Query Commands
NUQL commands designate the type of processing to be done by the referenced ruleset.
For example:
The first example is of the SELECT command and the second demonstrates an UPDATE that fails because of the bogus value being set for the BIRTHDAY date.
NUQL SELECT FIRSTNAME,LASTNAME,CREDIT.LIMIT,PHONE FROM SCR.ICUST WHERE CREDIT.LIMIT = "1500" GROUP-BY AREA.CODE GROUP-BY LASTNAME (Q
NUQL UPDATE SCR.ICUST SET PHONE = "494-255-6666", CREDIT.LIMIT = "", BIRTHDAY = "xx01/01/1940" WHERE CUSTID = "00105"
NuQL Update Failed 'Not a valid date format'
Command List
Click on headings for additional details.
INIT
INIT is used to initialize all the NUQL internal data tables based on a specific ruleset. The field definitions are retrieved, and data tables (nuCSDynaSet) initialized.
SESSION
SESSION is used by NUQL client server to assigned a session id to an uninitialized ruleset.
SELECT
Select and build the nuCSDynaSet. No item locks set.
READ
Select and build the nuCSDynaSet. Sets item locks.
BROWSE
Retrieve a browse page from a previous SELECT/READ using the 'B' Browse option.
RELEASE
Release locks based on criteria.
REFORMAT
Writes generated nuCSDynaSet items to an mv file.
UPDATE
UPDATE or ADD items to the specified ruleset based on the specified SET criteria.
ADD
Add a new item is written to the data base or add a new row to an embedded mv table.
INSERT
A new item is written to the data base or insert a new row at the top of and embedded mv table.
POST
POST the contents of the current nuCSDynaSet tables.
DELETE
DELETE an item or set of items based on the id clause or WHERE clause.
VALIDATE
Process the validate trigger for a set of fields. Only effects nuCSErrs and nuCSResp. Does not effect the current data set held in nuCSDynaSet.
CORRELATIVE
Process the correlative trigger for a set of fields. Only effects nuCSErrs and nuCSResp. Does not effect the current data set held in nuCSDynaSet.
CHOOSE
Retrieve a list of possible field values as defined in the CHOICEPARAM property.
SEARCH
Retrieve results of an indexed search as defined in the XREF property.
?? and ?
Show the NUQL environment variable tables.
