Nucleus Query Language
adds a subset of SQL commands to TCL.

NuQL extends the multi-dimensional model to allow Nucleus rule-based data extraction and insertion according to SQL-like statements. NuQL enhances system security according to user and/or group profiles, while providing a transaction layer that enforces referential integrity during the insertion and deletion of records from the database.

Adding / Insertion:

NUQL ADD SCR.ICUST SET FIRSTNAME="WOODY", LASTNAME="WOODPECKER", PHONE="7145551212", CREDIT.LIMIT="0"

This will add a new item to the SCR.ICUST transaction set. ADD and INSERT are synonyms.

Update - record selection by firstname:

NUQL UPDATE SCR.ICUST SET PHONE="4945556666", CREDIT.LIMIT = "1500", BIRTHDAY = "01/01/1938" WHERE FIRSTNAME = "WOODY"

This will update the elements of the data items where the firstname is "WOODY".

Update - record selection by ID ::

NUQL UPDATE SCR.ICUST SET PHONE="4945556666", CREDIT.LIMIT = "", BIRTHDAY = "01/01/1939" WHERE ID = "00105"

Deletion - record selection:

NUQL NUQL DELETE FROM SCR.ICUST WHERE CUSTID = "00105"

or

NUQL DELETE FROM SCR.ICUST WHERE ACTIVE LIKE "N%"

Building a sequential flat table:
A simple statement can build a sequential flat table based on the results of the query:
NUQL SELECT FIRSTNAME,LASTNAME,CREDIT.LIMIT,PHONE FROM SCR.ICUST WHERE CREDIT.LIMIT = "1500" GROUP-BY AREA.CODE GROUP-BY LASTNAME (Q

Validation:
A statement will validate against defined rules. Values can be changed using the SET clause :

NUQL UPDATE SCR.ICUST SET PHONE = "494-255-6666", CREDIT.LIMIT = "", BIRTHDAY = "xx01/01/1940" WHERE CUSTID = "00105"
[40000] NuQL Update Failed 'Not a valid date format'

Importing XML data into Multi-dimensional files ::
NuQL includes utilities to easily import XML formatted data into a Multi-dimensional environment. If the specified file does not exist, Nucleus will create the file, automatically build the dictionary definitions and convert the XML data into standard multi-dimensional file structures.

More options and examples
Numerous options and modifiers are available for use by developers using NuQl.

Additional information
For extensive details and additional information about the NuQL client-server interface , please visit the links on the right, to our hyper-linked documentation site, http://www.nuwiki.com:

To learn how your organization can benefit from Nucleus Technology, integration of NuQl query language or Nucleus class objects:

Call toll-free (866) 882-1888 or +1 (954) 791-8575 for more information
Email: info@binarystar.com, or fill out our contact form.

Nucleus technology – Accelerate the pace of deployment