The Star in NonStop Tandem Training & Professional Services since 1986
Polaris Learning Solutions Home PagePolaris Learning Solutions Home PageOn-Site CoursesOnline ClassesProfessional ServicesPricing and Payment TermsContact UsAbout UsOur Clients
PLMX206 - NonStop SQL/MX Programming
This course is based on SQL/MX release 2.0 (G06.23) and addresses both SQL/MP tables and SQL/MX tables. It describes the facilities available in OSS, in Guardian, and on a client PC to produce SQL/MX programs. The course includes sections on data mining and publish-subscribe. It deals with the various interfaces between Java and SQL/MX, including JDBC Type 2 and Type 4 drivers.

This course also addresses the performance aspects of SQL/MX programming.

This two-day course includes 25 scripts. These are run from the OSS (UNIX-like) environment, where SQL/MX is based. The scripts permit the user to display object names, object versions, and security settings without writing metadata queries.

Extensive hands-on labs will anchor the student's classroom learning.

Course Duration: 2 days (on-site only)

NonStop SQL programmers who are new to SQL/MX, as well as programmers in other SQL environments who are new to NonStop systems and any others who need a solid overview of SQL/MX programming topics.


  • SQL/MX Programming Environment
  • SQL/MX and SQL/MP DML Comparison
  • SQL/MX ANSI Compliance
  • SQL/MX Language Elements
  • DML Statements
  • Data Mining
  • Data Mining and comparison to OLAP
  • Transpose, Sample, Sequence functions
  • Publish/Subscribe concepts and triggers
  • Program Development
  • OSH and Windows-based preprocessors
  • Embedding SQL/MX in Java
  • SQL/MX Limits
  • JDBC/MX and Type 4 JDBC Driver
  • Performance factors and CONTROL statements
  • MDAM Performance advantages

The audience should have completed NonStop Features and Fundamentals (PLI210) or be familiar with the Tandem NonStop environment, including the use of editors and general utilities. The student should have a programming background and be familiar with SQL syntax and relational database concepts. No knowledge of ANSI standards, SQL/MP, OSS, or UNIX is presumed

Web site:



+1 972-898-3206
+1 972-898-3206
+1 972-898-3206

1892 FM 2481
Bluff Dale, TX  76433

  • Module 1 - NonStop SQL/MX Programming Environment
    • DML comparison between SQL/MX and SQL/MP
    • Using SQL/MP tables in SQL/MX
    • SQL/MX compliance with ANSI standards
    • OSS-, Guardian-, and PC-based tools
    • Loading external data
    • The SQL/MX compiler and how to influence it
    • Multi-dimensional access method (MDAM)
    • Data access options
  • Module 2 - Language Elements
    • Character sets
    • Collations
    • Data types
    • Expressions
    • Functions
    • Literals
    • Predicates
  • Module 3 - DML Statements
    • SELECT statement - MXCI and embedded
    • INSERT statement - MXCI and embedded
    • UPDATE statement - MXCI and embedded
    • DELETE statement - MXCI and embedded
    • Access and exclusion modes; locking
    • Cursors vs. rowsets
  • Module 4 - Data Mining
    • Data mining vs OLAP
    • SQL/MX support for data mining
    • SELECT options: Transpose, Sample, Sequence By
    • Sequence functions
    • Lab 1: Data mining features
  • Module 5 - Publish/Subscribe
    • Enscribe queue files
    • Publish-subscribe concepts
    • Publish-subscribe vs. triggers
    • Basic stream access
    • Stream timeout
    • Embedded update/delete
    • After Last Row access
    • Lab 2: Publish-subscribe features
  • Module 6 - Program Development
    • Compiling an SQL/MX program
    • Module placement and naming
    • Autorecompilation settings
    • OSH- and Windows-based preprocessors
    • Running the SQL/MX compiler (mxcmp)
    • DISPLAY USE OF command
    • Building Guardian-based programs
    • Embedded SQL/MX statements in Java (SQLJ)
    • Stored Procedures in Java (SPJ)
    • SQL/MX limits
    • Enterprise Tool Kit (ETK)
    • Lab 3: Program development
  • Module 7 - JDBC/MX anf the JDBC Type-4 Driver
    • ODBC and JDBC access to SQL data on NonStop
    • Java on Nonstop
    • JDBC/MX (Type 2 Driver) - architecture and features
    • Type 4 JDBC Driver - architecture and features
  • Module 8 - Performance
    • Compile-time factors
    • MDAM performance advantages
    • Displaying query statistics and execution plans
    • Query plan caching
    • Java application profiling (hprof utility)
    • System default settings
    • Modifying the system defaults table
    • CONTROL statements
    • UPDATE STATISTICS statement
    • Lab 4: Performance
For Web site issues, contact Webmaster .   Copyright 2003-2009 Polaris Learning Solutions   All rights reserved.