Interactive SQL Help

The Interactive SQL capability in the IDE currently supports SELECT statements with a extended syntax for richly formatted results.


Interactive SQL Extended Syntax

<Select_Statement // Statement_Qualifiers>

STATEMENT qualifiers

Statement qualifiers follow a double slash '//' comment and are individually seperated by a single slash.

  • BREAK - Set Row break options for table
  • {NO}CACHE - Enable or disable SQL cache
  • CAPTION - Define a table caption
  • {NO}CODE - Display executable M code that implements SQL
  • COLS - Set global and class attributes for column qualifiers
  • {NO}DQMODE - Enable Data-Qwik natural join and Null value translation logic
  • {NO}DEBUG - Analyze or Debug a SELECT statement
  • MARKUP - Set the markup language to either HTML or TEXT (Default = HTML)
  • OUTPUT - Set output device to print results set
  • PAGE - Set number of lines per page before issuing form feed and heading reprints
  • {NO}PLAN - Display IO access plan score
  • ROWS - Set maximum number of rows to output (default = 1,000)
  • STYLE - Set table HTML styles (e.g., background-color:#FCFDFE) HTML mode only
  • TEMPLATE - Set format and style properties according to a pre-defined template (e.g., REPORT)
  • TITLE - Set heading title on top of column headings and enable standard heading format

COLUMN qualifiers ( SQLcolumnExpression {Column_Qualifiers} )

Column qualifiers are enclosed in brackets '{}' adter the column expression. Individual column qualifiers are seperated by commas.

  • ALIGN - Set alignment of value in cell to Left, Center, or Right
  • {NO}BREAK - Insert line breaks or page break if a column value changes from the last row
  • {NO}LENGTH - Set column field length for wrap option or suppress column if '0'
  • {NO}FORMAT - Set column format or mask (e.g., decimal-size:2;group-separator:',')
  • HEADING - Set column Heading
  • MERGE - Merge column with prior column(s)
  • NULL - Replace Null value with supplied value
  • {NO}REPEAT - Suppress column if value is the same as previous row
  • {NO}SPACE - Set whitespace before next column (Text mode only)
  • {NO}STYLE - Set HTML style for column (e.g., color:red)
  • TITLE - Set column title for hover help (HTML mode only)
  • TYPE - Set column data type (TUFN$L)
  • {NO}WRAP - Set column overflow wrap option to {NO}WRAP (text mode only) or TRUNCATE

The values of the column qualifiers: ALIGN, FORMAT, LENGTH, HEADING, TITLE and TYPE default from the data dictionary (i.e., Data-Qwik).

Data formats default to masks associated with a column's initial data type (e.g., 'D' = MM/DD/YEAR). The mask is initialized to the runtime variables %MSKE, %MSKD, etc. These can be overridden at either the table level or the individual column level by changing the format property. Formatting can also be defeated completely (Raw data) at the table, class and individual column level.

SQL Syntax Extension

 SELECT ColumnList FROM tableList WHERE whereExpression // StatementQualifiers
    ColumnList :== SQLColumnExpression {ColumnQualifier{,...}} {,...}

               ColumnQualifier :== QualifierName=Properties{;...}

                                QualifierName :==  String format, String style, Number length, String wrap, 
                                                   String merge, String align, String heading, String math, String type,
                                                   Number space, Boolean repeat, String null, Boolean break

                                Properties :== PropertyName:Value

                                            PropertyName :== String PropertyName
                                            Value :== Primitive Value

Optional column qualifiers are imbedded directly within SQL SELECT statements. They are declared by enclosing column qualifier expressions in brackets ({}) between SQL column expressions. Qualifier expressions are parsed out of the SQL expression before the SQL expression is processed by the SQL engine or SQL API (e.g., JDBC).

The qualifiers BREAK, FORMAT, LENGTH, REPEAT, SPACE, STYLE, and WRAP can either be prefixed by the string 'no' or assigned a value of 'none'; which will disable the qualifier. (e.g., NOFORMAT and FORMAT = 'none' will disable all formatting for a column and display the raw value from within the results row.)


select class, method, parameters{heading=Format Parameters, style=color:red},des from objectmet 

Would override the dictionary default column heading for the column 'parameters' and display the text in Red.

Implementation notes

Default values for STATEMENT expression qualifiers ( preceded by // after SELECT expression)

  • BREAK = no
  • CACHE = yes (Note: CACHE = no if PLAN = yes)
  • CAPTION = Null
  • CODE = no
  • COLS = no
  • DEBUG = no
  • OUTPUT = Current browser window
  • PAGE = no
  • PLAN = no
  • ROWS = 1000 (Can be extended but may fail if output exceeds 1MB)
  • TEMPLATE = Null
  • TITLE = Null
  • STYLE = Table style properties default to the following values

Default values for COLUMN qualifiers ( enclosed in brackets {} after a column expression )

  • LENGTH = Dictionary default for column
  • WRAP = yes (Text mode only, ignored for HTML mode unless 'truncate')
  • FORMAT = Table and class FORMAT defaults (includes display masks and decimal size)
  • ALIGN = Right if column is Currency or Number, Center if Boolean, otherwise Left
  • HEADING = Dictionary default from DBTBL1D.RHD
  • MATH = Null
  • MERGE = No
  • TITLE = Dictionary default (composite: DBTBL1D.DI _ DBTBL1D.TYP _ DBTBL1D.DES _ DBTBL1D.TBL)
  • TYPE = Dictionary default (List: '$,B,C,D,F,L,M,T,U')
  • SPACE = 2 (Text mode only)
  • STYLE = Table defaults
  • REPEAT = Yes
  • NULL = Null
  • BREAK = No

Column qualifier detail

  • BREAK - Break can be set to an integer between 0 and 10 or the literal 'page'. If multiple columns are set to BREAK, will insert the number of line feeds indicated by the highest column value. Setting the value to 'page' will generate a page feed (form feed, title and heading) when the column value changes. Generally, columns that include the BREAK qualifier should be placed at the beginning of the column list. This qualifier is typically used for key column breaks, or when column values are placed into the page titles.
  • FORMAT - This qualifier describes the output mask or formatting rules that are applied to the underlying raw data. For Currency, Date, Number, Logical and Time column classes, the format will default to configuration parameters. Formats can be set for an entire class with the /COLS table qualifier ( e.g., /Currency.format=decimal-size:2 ) or within an individual column ( e.g., DEP.TLD{format="year/mm/dd"} ).

The Number and Currency classes include the following format options:

decimal-size: <default to schema>
decimal-seperator: <default to configuration or ".")
group-size: <default to 3>
group-seperator: <default to configuration or ",")

- The Date class defaults to configuration or "MM/DD/YEAR"

- The Time class defaults to configuration or "12:60 AM"

- The Logical Class dafaults to configuration or "NY"

- The String, Upper and Memo class supports format masks that implement HTML elements. the "URL" mask output the column value as a hyperlink (value=URL), the "IMAGE" mask outputs an image (value=URL) and "HTML " outputs raw HTML (value=HTML markup).

Formatting can be disabled by setting the format qualifier to either noformat or format = none


a. When entering formats for the Number and Currency class, the syntax must follow the format=property:value; pattern. When entering masks for the other classes, the correct syntax is: format=mask.

b. To disable formatting for the entire table, enter /COLS=.noformat in the table qualifiers. To disable formatting for a specific class enter /COLS=className.noformat in the table qualifiers.

  • HEADING - The column heading can be entered in plain text (default) or in HTML markup. To specify HTML, the heading qualifier must be followed by a space and the text html (i.e., {heading html=<img src=http_Reference>}). If the heading is enterd as html markup, all html characters must be propery 'escaped' (e.g., < = &lt;) or the browser may not render the heading correctly.

Individual column headings can be disabled by setting the heading qualifier to noheading or heading = 'none'

  • LENGTH - NOLENGTH or LENGTH='0' can be specified to suppress the output of the column. This option can be used in combination with table titles and column breaks to display key columns in headings.
  • NULL - Replaced a Null value for the column with a specified value. Since the replacement occurs prior to the execution of the MATH functions, the replacement value will be included in the results.
  • MATH - Ignores all null values within all functions (unless changed with NULL qualifier). However, math functions will include values for rows that have output suppressed by the REPEAT qualifier.
  • REPEAT - To avoid ambiguity between Null values that result from the REPEAT qualifir and underlying actual Null values, set the Null qualifier if database may contain actual Null values for the column
  • STYLE - HTML mode only, can contain any valid HTML Style property
  • WRAP - Text mode only. If WRAP is enabled a single character overflow will intrude one character into the space between columns if necessary to avoid a single character overflow. If a SELECT statement contains a column that typically overflows the default display length (e.g., OBJECTMET.PROPERTIES) it may make sense to place that column last in the select expression and set the qualifier to NOWRAP.

Table Titles

In addition to column headings and table captions, a title can be specified for the a table with the /TITLE='Expression' qualifier. A title is typically used to display a report name, directory name, date and time, other optional runtime or table values, and page numbers. Titles are enclosed within the table headings and are displayed at every page break along with column headings. In contrast, captions which outside of the table boundaries and are displayed once at the beginning of the table.

If specified, a title appears within the table boundaries and is contained within a heading group with the individual column headings. The title spans across all of the columns in the table. The title displays the contents of the /TITLE table qualifier, and the directory {company} name (CUVAR.CONAM) along with the system date (%SystemDate) and Current Date (%CurrentDate) and time Current Time (%CurrentTime). If a page break value is specified (/PAGE= 'NumberLines'), the title will also include the current page number.

Variable Insertion in Titles

Through variable insertion, it is also possible to include and format current row (column) data and other runtime values into the title. Including column data into the title when combined with the column properties /break = page and /nolength provides an elegant presentation option for key columns that change infrequently.

The syntax for inserting a column or runtime variable into a title is to prefix the column name or position or variable name with a colon, and enclose it with the greater than and less than symbol, e.g., <:columnReference|variable>. A column reference can be either the column position (e.g., <:1>) or a table.column reference (e.g.,? <:objectmet.class>)

Variable references can include any PSL variable / keyword from within the following list:

Number %ClientVersionID, String %CompanyName, Date %CurrentDate, Time %CurrentTime, Date %EffectiveDate, 
String %Identifier, Number %ProcessID, String %RoutineName, String %ServerChannelID, String %SessionID, 
String %SystemCurrency, Date %SystemDate, String %UserClass, String %UserID, String %UserName, 
String %UserStation, String %VersionID

Data type declarations, formatting and HTML Styles can also be applied to variables by including the Format and Style properties in the variable expression as follows: <:columnReference|variable {Format=ColumnFormat} {Style=ColumnStyle}> For example, the following expression would display a heading with the values for columns dep.cls and dep.grp imbedded and rendered in a red font.

/heading='Account Listing for Class: <:dep.cls style=color:red> and Group <:dep.grp style=color:red>'

Enhanced Wildcard Selection

SQL provides a wildcard character ('*') that can be used to select all of the columns within a table. This capability has been extended to provide filters on the columns that are selected from a table.

  • LIST - Selects the columns specified in DBTBL1.DFTHDR or the column that is contained in the DESCRIPTION string (e.g., DES, DESC). The Primary keys of the table are also always included in the selection. This wildcard option is useful for simple list of table table rows that contain a description column.
  • "<selectionQuery>" - Selects all the columns specified by the selection query which is applied to the table DBTBL1D. For example: select *"nod in (50,51) and typ = 'D'" from DEP selects all the Date data type columns mapped to nodes 50 and 51 from the DEP table. The selection query is entered in SQL syntax itself, and can include any columns from the DBTBL1D table and any valid SQL where clause syntax.

Sample HTML Results

By default the Interactive SQL interpreter uses HTML to markup the results.

Example #1


select cls{break=page,nolength},
          bal{math=sum;avg, format=decimal-size:2},
          from dep
          order by cls,grp,type,lnm,cid
          // rows=30/template=report
          /title=Account Listing for Class: <:dep.cls style=color:red> and Group <:dep.grp style=color:red>


HTML Formatted Interactive SQL results

Sample Text Results

Sample results (there are three examples below, each demonstrating different features of the SELECT browser.

Example #1

Demonstrates the use of MATH functions, headings, format and null value replacement.

Note: The different unique count in columns #5 and #6, due to the replacement of Nulls in column #6. Column #4 is a good example of Unique.

Note: The headings in quotes preserved original upper/lower case, while unquoted values were converted to uppercase. Also, the last heading was split into two lines since it contained the '@' character.

Note: The second column (SUM) was formatted with the Data-Qwik E option, inserting commas into the numbers.

Note: DEP.BAL is defined as three decimal precision in this directory.


SELECT CID{math=unique}, LNM{length=10,wrap=2,math=unique}, bal{math=sum,heading=sum}, bal{math=avg,heading=average}, 
bal{math=count,heading=count}, bal{math=unique,null=0,heading='Unique Balances'} from dep //rows=10/template=report


Console> %PSL-Runtime: .005691 Seconds
    Account  Report                                                                  Unique
     Number  Short Name              SUM          AVERAGE            COUNT         Balances
------------  ----------  ---------------  ---------------  ---------------  ---------------
          6  HOERR,BRUC       10,236.990        10236.990        10236.990        10236.990
          7  HOERR,BRUC       17,901.510        17901.510        17901.510        17901.510
          8  HOERR,BRUC          210.000          210.000          210.000          210.000
          9  HOERR,BRUC                                                               0.000
         45  HOERR,BRUC        7,200.000         7200.000         7200.000         7200.000
         55  SRIVASTAVA      100,000.000       100000.000       100000.000       100000.000
         56  SRIVASTAVA        2,574.000         2574.000         2574.000         2574.000
         68  HOERR,BRUC                                                               0.000
         71  SANCHEZ,FR          180.000          180.000          180.000          180.000
         76  SCHWARTZ,C       12,420.000        12420.000        12420.000        12420.000
============  ==========  ===============  ===============  ===============  ===============
         10           4      150,722.500        18840.313                8                9
Complete :> 10 rows processed.

Example #2

Demonstrates the use of the 'break', 'repeat' and /PAGE options.

Note: Even if norepeat is enabled, all columns will print on the first line after a page break.


SELECT class{break},method from objectmet//cache/rows=99/PAGE=10


Console> %PSL-Runtime: .01222 Seconds
 Class         Method
 ------------  --------------
 ByteString   ascii

 Class        Method
 ------------  --------------
 Cache        getRecord
 Class        isAncestor

 Class        Method
 ------------  --------------
 Date         day

 Class        Method
 ------------  --------------
 Date         monthOfYear
 Db           currVal

 Class        Method
 ------------  --------------
 Db           delete

 Class        Method 
 -----------  --------------
 Db           isSchemaColumn

 Class        Method
 ------------  --------------
 Db           update
 DbSet        getRecord
 HTML         addAttrib

 Class         Method
 ------------  --------------
 HTML         addElement
 IO           close

 Class        Method
 ------------  --------------
 IO           open
 List         add

 Class        Method
 ------------  --------------
 List         position
 Number       byte

 Class        Method
 ------------  --------------
 Number       roundDec
 Object       data

 Class        Method
 ------------  --------------
 Object       order
 PSL          actual

 Class        Method
 ------------  --------------
 PSL          error
 Class        Method
 ------------  --------------
 PSL          isRecord

 Complete :> 99 rows processed.

Example #3

Demonstrates the use of the break and wrap options. Also demonstrates the use of the /CODE option to display the M database code.

Note: Column #2 is truncated, while #1 and #3 wrap


SELECT class{break,math=unique}, method,des{length=40,wrap=truncate}, parameters{length=50} from objectmet  //code


Console> %PSL-Runtime: .011288 Seconds

Line  Executable code
----  --------------------------------------------------------------------------
  1   S vsql(1)=""
  2   S vsql(1)=$O(^OBJECT(vsql(1)),1) I vsql(1)="" S vsql=-1
  3   S vsql(2)=""
  4   S vsql(2)=$O(^OBJECT(vsql(1),1,vsql(2)),1) I vsql(2)="" S vsql=1
  5   S vsql(3)=$G(^OBJECT(vsql(1),1,vsql(2)))
  6   S vd=$S(vsql(1)=$C(254):"",1:vsql(1))_$C(9)_$S(vsql(2)=$C(254):"",1:vsql(2))_$C(9)_$P(vsql(3),"|",4)_$C(9)_$P(vsql(3),"|",2)</nowiki>

Data Key    Value
 --------    ---------------------------------
 0           "4"
 1           ""
 2           ""
 3           ""
 A           ""
 D           "T0T0T0T0"
 F           "||MM/DD/YEAR||||"
 I           "OBJECTMET"
 K           "2"
 P           "4"

Class         Method          Description                               Formal Parameters
------------  --------------  ----------------------------------------  --------------------------------------------------
ByteString    ascii           ASCII code of byte at specified pos       lo?al Number position
              extract         Extract a bytestring                      local Number start,local Number end
              find            Find the next position of a bytestring    local ByteString string,local Number start
              justify         Justify a bytestring                      local Number fieldLength
              length          String length                             local ByteString delimiter
              piece           Return bytestring at delimited position   local ByteString delimiter,local Number start,
                                                                        local Number end
              toPSLExpression translate literal value to PSL expressio
              translate       Byte by byte replace                      local ByteString lookFor,local ByteString replaceBy

Cache         getRecord       Get RecordTABLE object from Cache         literal String table,String KeyExpr,literal 
                                                                        Boolean classNew
              isDefined       Check if RecordTABLE row exists using Ca  literal String table,String KeyExpr

Class         isAncestor      Is Name1 an ancestor of Name2             String ancestorName,String descendantName
              isClass         Does className exist in OBJECT table      String className
              isDescendant    Is Name1 a descendant of Name2            String descendantName,String ancestorName
              isValid         Does className exist in OBJECT table      Reference instance
              new             Create a new instance of class            literal String Class,Object initObj

Date          day             2 digit day of month
              dayOfMonth      Numeric day of the month
              dayOfYear       Day of the year
              daysInMonth     Number of days in Month
              daysToEOY       Days to the end of the year
              isBusDate       Date is a business date in calendar       local String Calendar
              isLeapYear      Leap Year
              month           2 digit month of year
              monthOfYear     Numeric month of year
              nextBusDate     Next business date for calendar           local Number numberDays,local String Calendar
              nextFreqDate    Next frequency date                       local String frequency,public Number AF,local 
                                                                        String control
              prevBusDate     Previous business date for calendar       local Number numberDays,local String Calendar
              toString        Convert Date to String                    local String DateMask
              year            Year (4 digit)

Db            currVal         Return highest key value                  literal String table,String KeyExpr
              delete          Delete records (SQL format)               literal String table,local String where,local 
                                                                        String PSQLqualifiers
              fastDelete      Delete multiple records                   literal String table,String KeyExpr
              getOneRow       Select one row of data from a table       String select,String table,String keys,String delim
              getRecord       Retrieve a recordTABLE from the database  literal String table,String KeyExpr,literal 
                                                                        Boolean ClassNew
              getSchemaColumn Return a PSL column descriptor            local String table, local String column
              getSchemaTable  Return a PSL table descriptor             local String table
              insert          Insert a new record (SQL format)          String table,String columns,String values,String 
              isDefined       Returns whether reference is defined      literal String from,literal String where,loca? 
                                                                        Number match
              isSchemaColumn  Is table.column a valid column name?      local String table, local String column
              isSchemaTable   Is table a valid table name?              local String table
              nextKey         Return next key value                     literal String table,String KeyExpr
              nextVal         Return highest key value + 1              literal String table,String KeyExpr
              prevKey         Return previous key value                 literal String table,String KeyExpr
              prevVal         Return prior key value                    literal String table,String KeyExpr
              select          Create a Result set                       local String select,local String from,local 
                                                                        String where,local String orderby,local String 
                                                                        groupby,local String PSQLparams
              selectDbSet     Create a set of Records                   literal String table,local String where,local 
                                                                        String orderby
              update          Update records (SQL format)               String table,String columns,String where,String 

DbSet         getRecord       Return current record                     literal String table
              isEmpty         Return boolean state of results set
              next            Position cursor to the next row

HTML          addAttrib       Add column attributes                     String element,String attributes
              addCol          Add Column form resultset to XML documen  ResultSet rs,String col
              addElement      Add Element line to XML DTD               String element,String attributes
              addList         Add a matching list (columns+values) XML  literal String element,literal String columnlist,
                                                                        String valuelist,String delim
              addProp         Add individual column and value to XML    String column,String value
              addRow          Add results row with tags                 String element,ResultSet rs
              addString       Add string to XML format (clsoe or open)  String string,literal Boolean close
              addTitle        Add XML title to header                   String title

IO            close           Close Device
              open            Open IO
              read            Reads a record from device                public String ErrorType
              write           Write record                              local String Record,local String EOL

List          add             Add a value to a list                     local String expr,local String delimiter,local 
                                                                        Boolean allowDuplicate,local Boolean inOrder
              contains        List contains expression                  String expr,String delimiter,Boolean ignoreCase
              count           Number of elements in list                local String delimiter,local Boolean noDuplicates
              elementAt       Return individual element of List         local Number position,local String delimiter
              position        Ordinal position in the list              local String expr,local String delimiter,local 
                                                                        Boolean ignoreCase
              sort            Sort the elements in a list               local String delimiter,local Boolean allowDuplicate

Number        byte            return single byte represented by number
              char            return character represented by number
              fnumber         Format (and round) a number        ?      local String format,local Number decimals
              random          Return pseudo-random number in {0,val-1}
              roundCur        Round an amount to currency               local String crcd,local String roundOption,local 
                                                                        Number justify
              roundDec        Round an amount to decimal                local Number decimal,local String roundOption,
                                                                        local Number justify
              toString        Format a number                           local Number decimal,local String formatMask
              zero            Zero fill a number                        local Number length,local Number decimal,local 
                                                                        Boolean implied,local Number sign

Object        data            Return object exists / is array
              exists          Return object exists
              getClass        Return object class
              isPrimitive     Class is a primitive class
              order           Next or previous subscript in array       local Number direction
              query           Name of next node in array

PSL           actual          actual() array as 'property'              Number sub
              addSetting      Add or modify a PSL compiler setting      local String section,local String ident,local 
                                                                        Primitive value
              addSubrou       Add a subroutine to the module            local String Name,local List parameters,local 
                                                                        String comment,local Boolean new
              cachePSLColumn  Cache and return a PSL column descriptor  PSLColumn cache(), local String qcn, PSLTable 
              cachePSLTable   Cache and return a PSL table descriptor   PSLTable cache(), local String table, local 
                                                                        Number level
              error           Output a PSL compile-time error           String errorText
              getDbLoad       Return Record map header                  local String subRou,local String var,local Number 
              getLabelRecord  Return a PSL subroutine label record      String subrou
              getPSLColumn    Return a PSL column descriptor            local String table, local String column, 
                                                                        SchemaTable stCache()
              getPSLTable     Return a PSL table descriptor             local String table,local Number level
              getSetting      Return a PSL compiler setting (defaults   local String section,local String ident
              hasSetting      Does PSL compiler setting exist?          local String section,local String ident
              insertLine      Insert a line of code                     local String PSLCode,local Number line,local 
                                                                        Number level
              isRecord        Record class is ancestor of class         local String class
              mExpr           Convert a PSL string to an M string       local String psl
              newVariable     Generate a new variable name
              openBuffer      Open a new PSL buffer                     local List parameters,local String comment
              patch           Replace expression with backpatch token   local String expression
              subrouExists    Subroutine exists in current module       local String name
              warn            Output a PSL compile-time warning         local String warning

PSLBuffer     add             Add a line of PSL code to the buffer      local String code
              insert       ?  insert PSL subroutine into current code   local String name, local String resultClass

PSLColumn     getClass        column's dataType as PSL class
              getCurrentExpr  expression to retrieve(0)/set(1) column   local PSLIdentifier rec,local Boolean bLeft
              getCurrentLvn   local variable containing column's value  local PSLIdentifier rec
              getCurrentNode  Node containing column's value            local Boolean bQuoted
              getOldExpr      expr to retrieve(0)/set(1) column.oldVal  local PSLIdentifier rec,local Boolean bLeft
              getOldLvn       local variable containing column.oldVal   local PSLIdentifier rec
              getOldNode      Node containing column.oldVal             local Boolean bQuoted
              getPurposeNode  purpose Id of node containing the column
              getUpdateCode   code to update column value               local PSLIdentifier rec,local PSLExpression value,
                                                                        local Number mode

PSLExpression fitsLineLength  does expression + extra space fit M line  local Number extra
              isArray         Expression is an array
              isLiteral       Expression is literal
              isVariable      Expression is a variable
              toValue         Reduce expression to constant

PSLIdentifier optimize        Reference object can be post optimized

PSLSubrou     addCode         Add a line of M code the buffer           local String code
              addExe          Add a line of code from exe() the buffer  local String code
              addLvn          Add a vsql() replacement for addExe() to  local Number nr,local String expr
              addTag          Add a tag(number) for addExe() to the su  local Number nr,local String code
              getCode         Get M code at specified line              local Number line
              getLine         Get highest linenumber of the subroutine
              getLvn          Get vsql() replacement value              local Number lvn
              getLvnMax       Get highest vsql() replacement number of
              getTag          Get the tag for a subscript in exe()      local Number tag
              getTagMax       Get highest tag number of the subroutine
              getTagPrefix    Get the tag prefix for addExe()
              insCode         Insert M code at specified line           local Number line,local String Code
              setTagPrefix    Set the tag prefix for addExe()           local String prefix

PSLTable      assertLevel     Assert a PSLTable instance with minimum   local Number level, PSLColumn cache()
              getArchivable   Is table valid to be archived
              getArchiveIncl  Get tables included with this when archi
              getArchiveKey   Get archive key number                    local Boolean forArch
              getArchiveSubs  Get archive sub-tables
              getArchiveTable Get primary archive table
              getFilerLogic   Filer logic that needs to be processed    local String operation,local PSLExpression 
                                                                        qualExp,local Boolean isPslExp
              getLoadCode     M code to load data node                  local PSLIdentifier rec,local String node,local 
                                                                        Number mode,local Boolean exists,public String 
              getNewCode      M code instantiate new Record             local PSLIdentifier rec,local PSLExpression mode
              getQuery        Get table query
              getSaveCode     M code to save data node                  local PSLIdentifier rec,local String node,local 
                                                                        Number mode,local String lvpm(),local PSLColumn 
                                                                  ?     rdbCol()
              getUpdateKey    M code to safe current key for UPDATE     local PSLIdentifier rec,local String lvpm()
              isOneNode       table uses single node in internal stora
              isParent        Table is parent table

Primitive     get             The primitive's value or a default value  Primitive default
              isNull          Expression is NULL                        literal Boolean isIncludeEmptyQuotes

Record        bypassSave      Database save, bypass triggers
              compare         Compare and report differences            local Record object2
              copy            Copy object                               local String colmap
              fromArchive     Check if record loaded from archive
              fromArray       Copy M array into object properties       literal String Array,literal String Keys
              getMode         Return Record Mode
              getTable        Return table represented by this record
              isChanged       Check if the Column has Changed           local String column,local String useagetype
              overlay         New record overlay fields                 String array()
              save            Save a record to the database             local String Filerqualifiers
              setAuditFlag    Set update history flag                   literal Boolean state
              setCreateOnly   Allow create mode only
              setMode         Set Record Mode                           local Number Mode
              setUpdateOnly   Allow update mode only
              toArray         Copy object properties into M array       literal String Array,literal String Keys
              toString        Copy object

RecordACN     renew           Loan/Deposit renewal                      String keys

RecordCIF     default         New Cif account defaults form product     String key

RecordDEP     default         Deposit new account default method        String keys
              renew           Loan/Deposit renewal                      String keys

RecordLN      default         Loan new account product defaults         String keys
              renew           Loan/Deposit renewal                      String keys

Reference     copy            Copy Reference class instance
              equals          Compare two reference objects             Reference cmp
              getPointer      Return pointer to reference object
              getStoredValue  Return a process scope value from object  local String tag
              setStoredValue  Store a process scope value in an object  local String tag,local String value
              toString        Return string representation of object

ResultSet     getCol          Return column value from results row      local Primitive colRef
              getColProt      Return column protection                  local Primitive colRef
              getRow          Return current results row                local String delimiter,local List columnList
              getRowProt      Return row protection
              isEmpty         Return boolean state of results set
              next            Position cursor to the next row

Row           getColumns      Get the properties of a Row object
              getDelimiter    Get the row delimiter
              setColumns      Set the properties of a Row object        local List Properties
              setDelimiter    Set the row delimiter                     local String delimiter
              toRecord        Copy a Row object to a Record object      local Record identifier,local String columnMap
              toString        Convert a Row object to a String          local String colDel,local String quoChar,local 
                                                                        String fmtDate,local String fmtTime,local String 

RowSet        beforeFirst     Position RowSet before first Row
  ?           getRow          Return current row
              isEmpty         Return if RowSet is empty
              loadFromFile    Load RowSet from file                     local String directory,local String filename,
                                                                        local String filetype
              next            Position rowset at the next row

Runtime       charset         Character set
              commit          Commit TP fence
              delErrXBAD      XBAD error                                object,errcode
              delayCommit     Call subroutine with delayed commits      literal String entryref
              rollback        Tp Rollback to the start of a fence       Startptr
              setErrMSG       Message Table Error                       object,msgnum,variable
              setErrSTBLER    Application Error                         object,errcode
              setErrXBAD      XBAD error                                object,errcode,column,curval,altval
              start           Start TP fence                            Tranid,varlist,stat

Schema        createTable     Create temporary table schema             String table,String keyexpr,String columnList,
                                                                        String globalName
              deleteTable     Delete table schema                       String table
              getTableName    Return a table name for a RecordClass     String class
              getTableRecord  Return a Data-Qwik table record           String table

String        addQuotes       Add one layer of quotes                   local String character
              ascii           ASCII code of character at specified pos  local Number position
              beginsWith      Begins with string                        local String string,local Boolean ignoreCase
              blank           Pad a string with blanks                  local Number fieldLength, local Boolean 
              byteLimitSubst  substring of at most maxBytes bytes       local Number start, local Number maxBytes
              complexUnpack   Complex unpack of data string             local Number length,local Boolean signed,local 
                                                                        Boolean leftnib
              contains        Contains a string                         local String string
              endsWith        Ends with string                          local String string,local Boolean ignoreCase
              extract         Extract a string                          local Number start,local Number end
              find            Find the next position of a string        local String string,local Number start,local 
                                                                        Boolean ignoreCase,local String quoteChar
              follows         Follows a string                          local String string
              getSub          Return a sub-delimited or labeled string  local String label,local String delimiter1,local 
                                                                        String delimiter2,local Number position
              insert          Insert a string into a string             local String string,local Number offSet,local 
                                                                        String padCharacter,local Boolean displace
              isInteger       Is an integer
              isLike          Is like (SQL like)                        local String likeExpr,local Boolean ignoreCase
              isLiteral       Is a literal value - quoted or number
              isNumber        Is a number
              justify         Justify and pad a string                  local Number fieldLength,local Number direction,
                                                                        local String padCharacter,local Boolean truncate?
              length          String length                             local String delimiter
              lowerCase       Convert to lower case                     local Boolean capitalizeFirstChar
              piece           Return string at delimited position       local String delimiter,local Number start,local 
                                                                        Number end,local String quoteChar
              putSub          Insert a sub-delimited or tagged string   local String insert,local String label,local 
                                                                        String delimiter1,local String delimiter2,local 
                                                                        Number position
              replace         Replace occurrances of expr1 with expr2   local String expr1,local String expr2,local 
                                                                        Number count,local Boolean ignoreCase,local 
                                                                        String quoteChar
              reverse         Reverse the character order
              stripQuotes     Strip one layer of quotes                 local String quoteCharacter
              toByteString    Convert String to ByteString
              toDate          Convert formatted date to julien date     local String mask
              toNumber        Convert String to Number                  local String mask,local Boolean stripSpace
              toRow           Convert a String type to a Row type       local List elements,local String delimiter
              toTime          Convert formatted to internal time
              translate       Character by character replace            local String lookFor,local String replaceBy
              trim            Trim characters from a String             local Number Option,local String character
              unpack          Unpacks data string                       local Number length
              upperCase       Convert to upper case

Time          toString        Convert Time to String                    local String TimeMask

TranSet       copyTran        Copy transaction to TranSet               local RecordTTX ttx,String colRefs(),local Number 
                                                                        tranSeq,local String secTran
              getTran         Get transaction from TranSet              local Number Sequence
              postTSet        Post TranSet                              PostDate,Branch,PostParam,TranArr

Complete :> 244 rows processed.