Jump to content United States-English
HP.com Home Products and Services Support and Drivers Solutions How to Buy
» Contact HP
HP.com home
Education & Training  >  Find a course 

HP NonStop SQL/MX database for SQL/MP users


Education & Training
US & Canada

» Contact Us
» Register for a class
» Education Centers
» Onsite & Dedicated Training
» What's new
» Find a course
» Big Data
» Business Analysis & Project Management
» Cloud
» Data Center
» HP ExpertOne Customer
» HP ExpertOne Partner
» HP Integrity
» Graphic Solutions
» Linux
» Microsoft
» HP Networking
» HP NonStop
» HP OpenVMS
» HP Project Odyssey
» HP ProLiant
HP BladeSystem
» Security
» HP Storage
» HP Tru64
» Virtualization
» HP VISPEL-Video Training
» VMware
» HP Education Consulting
» Certification
» HP Virtual Rooms
» eLearning
» HP Software Education
Content starts here

At a glance

View schedule & enroll Sorted by: location or date
Course number U4185S
Length 5 days
Delivery method Virtual Instructor-Led Training (VILT)
Instructor-led training (ILT)
Onsite dedicated training (OST)
Price USD $3,500
CAD $3,850

Course overview

This 5 day course is to help SQL/MP users transition to SQL/MX. The course describes the HP NonStop SQL/MX Release 2.0 architecture and processes.


  • NonStop SQL/MP experience in a production environment
  • Concepts and facilities for HP NonStop systems course (U4147S)
  • HP NonStop SQL/MP Essentials course (U4181S)


  • Persons with practical experience creating databases, and generating queries using the NonStop SQL/MP product wanting to develop new applications using the ANSI-92 features of the NonStop SQL/MX product

Ways to save

Course objectives

  • Describe how to run an mxci session and basic mxci commands
  • Describe how to start an mxci session, use ANSI names to access SQL/MX objects and Guardian names, SQL/MP aliases, and DEFINEs to access NonStop objects
  • Describe SQL/MX DLM statements, data types, identifiers, functions, and isolation levels
  • Describe how to compile embedded SQL/MX C/C++ and COBOL programs
  • Describe how to use SQL/MX compound statements, Rowsets, and Publish and Subscribe services in embedded SQL/MX programs
  • Describe SQL/MX module management features: targeting, versioning, and grouping
  • Describe and use SQL/MX late name resolution, similarity checking, and auto-recompiling
  • Describe and use SQL/MX data mining functions: transpose, sampling, and sequence functions
  • Describe SQL/MX optimization, operators, plan fragments and use EXPLAIN function and Visual Query Planner to display query plans

Next steps

  • HP NonStop SQL/MX Database Management (U8617S)
  • HP NonStop SQL/MX Query Analysis and Tuning (U8529S)

Benefits to you

  • SQL/MX DML statements and ANSI 92 features
  • Overview of the NonStop SQL/MX Release 2 Architecture
  • SQL/MX compilation of COBOL and C applications
  • SQL/MX Rowsets and Publish and Subscribe extensions

Course outline

Module 1: Overview of NonStop SQL/MX Release 2.0 Architecture

  • SQL/MX Release 2 Architecture – ANSI Catalogs and Schemas
  • Underlying physical files that support the SQL/Mx objects
  • SQL/MX Release 2 objects, processes, and utilities.
  • Lab exercise:
    • Lab 1.1 Overview of SQL/MX Release 2.0 Architecture Using mxci
    • Lab 1.2 Overview of SQL/MX Release 2.0 Architecture Using NSM/web

Module 2: Running an mxci Session

  • Running an mxci session and accessing SQL/MX and SQL/MP objects
  • SQL/MX object naming methods
  • mxci commands
  • Lab exercise: Lab 2 Running an mxci Session

Module 3: SQL/MX DML Statements and Options

  • SQL/MX Data types and functions
  • DML statements and options
  • SQL/MX Join operations
  • SQL/MX access options and isolation levels
  • SQL/MX implicit and explicit transaction management
  • Lab exercise: Lab 3 DML Statements

Module 4: Compiling Embedded SQL/MX Programs in the OSS Environment

  • Module Directive and embedding SQL/MX statements
  • Preprocessing, language compiling and SQL/MX compiling embedded SQL/MX COBOL and C programs
  • Lab exercise:
    • Lab 4.1 Compiling SQL/MX COBOL Programs
    • Lab 4.1 Compiling SQL/MX C Programs

Module 5: Preprocessing SQL/MX Programs on a Windows NT/2000/XP Workstation

  • Preprocessing embedded SQL/MX COBOL and C programs

Module 6: SQL/MX Compound Statements

  • Compound statement
  • Assignment statement
  • IF statement
  • Lab exercise:
    • Lab 6.1 Compound Statements in an SQL/MX COBOL Program
    • Lab 6.2 Compound Statements in an SQL/XM C Program

Module 7: SQL/MX Rowsets

  • Describe and implement rowsets in embedded DML statements in SQL/MX COBOL and C programs
  • Lab exercise:
    • Lab 7.2 Rowsets in an SQL/MX C Program
    • Lab 7.1 Rowsets in an SQL/MX COBOL Program

Module 8: SQL/MX Queuing and Publish and Subscribe Services

  • Describe publish and subscribe services and transactional queuing
  • Create publishing, subscribing, and dequeuing applications
  • Lab exercise:
    • Lab 8.1 SQL/MX Queuing and Publish/Subscribe Services in an SQL/MX COBOL Program
    • Lab 8.2 Dequeuing Services in an SQL/MX COBOL program
    • Lab 8.3 SQL/MX Queuing

Module 9: SQL/MX Module Management

  • Describe module management
  • Use targeting, versioning, and grouping module management options
  • Lab exercise:
    • Lab 9.1 Module Management Using an SQL/MX COBOL Program
    • Lab 9.2 Module Management Using an SQL/MX C Program

Module 10: Managing SQL/MX Applications

  • Compile-time name resolution
  • Late-name resolution
  • Automatic recompilaton
  • Lab exercise:
    • Lab 10.1 Managing Embedded SQL/MX COBOL Applications
    • Lab 10.2 Managing Embedded SQL/MX C Applications

Module 11: SQL/MX Transpose Clause

  • Transpose clause syntax and semantics
  • Lab exercise: Lab 11 SQL/MX Transpose Clause

Module 12: SQL/MX Sample Clause

  • Sample clause and semantics
  • Sampling methods: Random, First, and Periodic
  • Lab exercise: Lab 12 Sample Clause

Module 13: SQL/MX Sequence Functions

  • OFFSET, DIFF, RUNNING and MOVING functions
  • Lab exercise: Lab 13 Sequence Functions

Module 14: NonStop SQL/MX Query Optimization

  • Compilation phases
  • Data flow model
  • Physical operators
  • Type 1 and type 2 joins
  • Query analysis tools
  • Methods for influencing the optimizer
  • Lab exercise: Lab 14 SQL/MX Query Optimization

Onsite-Delivery Equipment Requirements

  • NonStop Server with G06-25 or later operating system installed
  • Instructor PC with:
    • Window 2000 or XP
    • PowerPoint software
    • OutsideView
  • Projection system to display PowerPoint slides from the instructor PC

Privacy statement Using this site means you accept its terms Feedback to Education & Training
© 2014 Hewlett-Packard Development Company, L.P.