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/MP programming

» 

Education & Training
US & Canada

» Contact Us
» Register for a class
» Education Centers
» VILT/HP RAIL
» Onsite & Dedicated Training
» What's new
» Find a course
» Big Data
» Business Analysis & Project Management
» Cloud
» Data Center
» HP ExpertOne Partner
» HP Integrity
» Graphic Solutions
» ITSM / ITIL
» Linux
» Microsoft
» HP Networking
» HP NonStop
» HP OpenVMS
» HP Project Odyssey
» HP ProLiant
HP BladeSystem
» Security
» HP Storage
» HP Tru64
» HP-UX
» 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 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

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.


Prerequisites

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

Audience

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


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