Course ID 00071759
HP product number U4189S
Course format ILT
Course length 4 days
Skill level Foundational
Delivery languages English
Related certifications
In preparation for these exams
Selected items from this course are included in these exams:
Register for this course.
Find this course in the Training calendar and click the “Register” link in the last column to begin your registration.

Course description

This course covers c language application programming in the Pathway environment through classroom discussion and hands on programming exercises with an HP NonStop™ server. You will have the choice of performing lab exercises using either the Enscribe or the NonStop SQL/MP database.

Who should attend

C language application programmers who will be developing applications using the Pathway product.

Prerequisites

For complete prerequisites and requirements to achieve any of the related certifications or upgrade paths, see the certification description on the HP ExpertOne website.

Topics

  • Pathway introduction
    • Online transaction processing (OLTP) in the NonStop server environment
    • The requester - server approach to online transaction processing
    • Pathway application and its role in online transaction processing
    • Components of a Pathway environment
    • Starting PATHMON and PATHCOM
    • Client/server options available in the Pathway environment
  • Pathway configuration and operation
    • Difference between global and object specific configuration parameters
    • Configuring global and object - specific parameters
    • Cold starting and cool starting a Pathway system
    • Starting the Pathway objects individually
    • Monitoring and maintaining a Pathway system
    • Shutting down a Pathway system
    • Capturing the current Pathway environment
    • Lab Exercise (30 minutes): Starting a Pathway System
      o Establish your individual lab environment
      o Start and stop a Pathway application environment
    • Lab Exercise (1 hour): Configuring a Pathway System - leads you through the series of commands to create, start, and exit from a Pathway application environment
      o Configure Pathway TCP, TERM, PROGRAM, and SERVER objects
      o Display Pathway object attributes and information
      o Shut down a Pathway application environment
    • Lab Exercise (1 hour): Managing and Monitoring a Pathway System
      o Use a series of commands to manage and monitor a Pathway application environment
      o Practice the steps to capture the current configuration
  • Server fundamentals
    • Requester-server model
    • Basic function of a server
    • Function of $RECEIVE in interprocess communication
    • Steps that make up the basic structure of a server program
    • Why servers should be context free
    • Recognizing and addressing the problems with concurrent database access by servers
    • Coding the Guardian procedures for server message processing
    • Differences between application messages and system messages
  • Inspect debugging
    • Basic syntax and use of the more common Inspect commands for debugging C programs
    • Components of the Inspect debugging environment
    • Steps required to debug a standalone process
    • Steps necessary to debug a Pathway server
  • Enscribe database access
    • Enscribe file types
    • Coding the Guardian procedures to create and access Enscribe files
    • Coding the Guardian procedures to perform record positioning for Enscribe files
    • Appropriate error checking
    • Lab Exercise (1.5 hours): Server Fundamentals (Enscribe and SQL)
      o Gain hands on experience in coding the Guardian procedure calls to use $RECEIVE properly
      o Code a server to respond to incoming requests
    • Lab Exercise (1 hour): Inspect Debugging
      o Establish an Inspect session in a Pathway environment
      o Use the Inspect debugging tool to examine the message passing that occurs between a requester and a server
      o Become familiar with common Inspect tool commands
    • Enscribe Database Access (second segment)
      o Alternate key access to Enscribe files
      o Identifying and addressing simultaneous update issues
      o File and record locking procedures
      o Modifying Enscribe file characteristics
  • NonStop SQL database access
    • Use of NonStop SQL statements to insert, update, and delete rows in an SQL database
    • Identifying and defining host variables
    • Operation of a cursor
    • Writing statements to report SQL run time errors
    • Process involved in building a C program with embedded SQL statements
    • Lab Exercise (2 hours): Locate Vehicle (Enscribe and SQL)
      o Code a server to access either an Enscribe or an SQL database to fetch records
      o Use Guardian procedures to access an Enscribe database pathway application programming I (C language) (U4189S)
      o Use SQL statements for cursor handling in SQL database access
    • Lab Exercise (2 hours): New Vehicle (Enscribe and SQL)
      o Code a server to access either an Enscribe or an SQL database to perform updates
      o Use Guardian procedures to perform record positioning and insertion in an Enscribe database
      o Use SQL statements to fetch and insert rows in an SQL database
  • NonStop Transaction Services/MP (TS/MP) programming
    • Major components that make up the NonStop TS/MP environment
    • Pathsend environment and the capabilities of a Pathsend requester
    • Coding the Pathsend procedures
    • Coding no wait Pathsend operations
    • Design considerations in using the Pathsend facility
    • NonStop TS/MP server design considerations
  • Data integrity and application availability threats to data integrity
    • Guardian procedure calls that ensure database integrity through the TM/MP subsystem
    • Writing Guardian procedure calls to invoke services from the TM/MP subsystem
    • Use of the TS/MP subsystem to provide for continuous availability of processes
    • Lab Exercise (1 hour): Pathsend Lab
    • Code the Pathsend procedure to submit a request to a Pathway server class
    • Code the Pathsend procedure to perform error handling

Objectives

After completing this course, you should be able to do the following:
  • Understand how Pathway applications utilize the features of the system architecture and operating system.
  • Apply in C language what you have learned to your own application programs.

How to register

View the HP ExpertOne Global Training Calendar to register for the trainings offering that best meets your needs.

Policies, fees and cancellations

Course fees may vary and are established and collected by the training center delivering the course. Cancellation fees may apply. Contact your HP Authorized Training Partner for their respective policies.