Remotely assisted instructional learning (RAIL)
Instructor-led training (ILT)
Onsite dedicated training (OST)
Price
USD $2,800
CAD $3,640
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 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
Next Steps
HP NonStop SQL/MX database for SQL/MP users U4185S
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
Printable version
