At a glance
View schedule & enroll Sorted by: location or date
Course number U4182S
Length 4 days
Delivery method Virtual Instructor-Led Training (VILT)
Instructor-led training (ILT)
Onsite dedicated training (OST)
Price USD $3,200
CAD $3,520
*Courses are supported in the delivery formats above, but are not necessarily scheduled in every delivery format listed. Please click the schedule links at the top of the page to see which delivery formats are currently scheduled.

Course overview

In this 4-day class you will acquire the skills you need to design, implement, and build embedded HP NonStop SQL/MP programs using the host programming language, C, and COBOL85. Classroom discussions and valuable hands-on lab exercises enable you to apply these programming techniques for your programming tasks. You will also become familiar with the available tools and functions in the HP NonStop SQL/MP product and the operating system, which affect the program's execution and run-time environment.


  • HP NonStop SQL/MP essentials U4181S
  • COBOL85 or C programming experience


Software developers who are responsible for programming or supporting embedded SQL database applications

Ways to save

Benefits to you

  • HP NonStop SQL/MP statements and directives relevant to programming in C or COBOL85 host language
  • Basic formats for an embedded SQL program and the use of host variables
  • SQL cursor concepts and related DML operations
  • The program compilation process-the tools and utilities for compiling, executing, and debugging an embedded SQL program in the HP NonStop Kernel operating system environment
  • Design considerations such as maintaining database integrity, controlling concurrency with locks, and the effects of data buffering on program performance
  • The concepts and effects of run-time program recompilation and the trade-offs between program availability and performance
  • Programming techniques including the use of the date-time and interval data types, patter matching, handling long-running transactions, and programming for SQL servers
  • The HP NonStop SQL/MP mechanisms available for controlling query execution plans and the EXPLAIN utility

Course outline

  • HP NonStop SQL/MP program development
    • Format and structural differences between a traditional and an embedded HP NonStop SQL/MP application program
    • Compilation steps for an embedded HP NonStop SQL/MP program
    • Run-time HP NonStop SQL/MP components and their functions
    • Compiling and generating an executable object file and executing the program in the HP NonStop SQL/MP environment when given a sample embedded HP NonStop SQL/MP program
    • Lab exercises (1 hour)
    • Gain practice working with embedded HP NonStop SQL/MP program structures, compile an embedded HP NonStop SQL/MP program, and validate the program
  • HP NonStop SQL/MP program structure
    • Different HP NonStop SQL/MP data types and mapping the HP NonStop SQL/MP data types to the host-language data types
    • Performing the following when given a COBOL85 or C program, a database schema, a list of HP NonStop SQL/MP objects, and database access specifications:
    • Embedding host variables, HP NonStop SQL/MP statements and directives, and other programming constructs into the host program to satisfy the given database access specifications
    • Building executable program files
    • Validating program compliance with the given database access specification
    • Lab exercises (3 hours)
    • Write, compile, and execute embedded SQL programs incorporating various data types, host variables, SELECT statements, cursors, and appropriate error handling
  • Design considerations
    • Concepts of database integrity for HP NonStop SQL/MP
    • Strategies and programming techniques for maintaining database integrity
    • Attributes and functions of locks, and strategies for handling deadlocks
    • Impact of using different data buffering methods on program performance
    • Selecting the appropriate buffering and locking strategies that maximize concurrency and maintain database integrity
    • Lab exercise (1 hour)
    • Reinforce the concepts of row locking and gain experience in the use of FUP LISTLOCKS
  • Run-time environment
    • Causes and effects of program invalidation
    • Rules for similarity checks and how this feature can be used to avoid automatic program recompilation at runtime
    • Identifying the SQLCOMP options that can be used to control automatic recompilation
    • Impact and trade-off of automatic recompilation on program execution given different scenarios
    • Lab exercise (1 hour)
    • Explain the impact of program automatic recompilation on program execution and describe the mechanism to avoid program automatic recompilation at run-time
  • HP NonStop SQL/MP programming techniques
    • Programming techniques to handle NULL columns, detect data existence, check for referential integrity, and use pattern matching and row positioning with alphanumeric key values
    • Specific programming techniques for Transaction Services/MP (TS/MP) (Pathway) servers and long-running transactions in offline (large batch) applications
    • Lab exercise (2 hours)
    • Design and implement programs to handle NULL columns, referential integrity, and pattern matching using the LIKE predicate
  • Program query performance
    • Performance impact of the different CONTROL directives
    • Relevant performance information from the output of an EXPLAIN plan report
    • Different mechanisms to monitor and measure query performance