Pathway application programming I (C language)

Prerequisites

• Knowledge of ANSI-standard SQL, if you plan to perform the HP NonStop SQL labs
• C Programming on HP NonStop systems

Audience

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

Ways to save

Benefits to you

• Components of the Pathway environment
• C requester programs with PATHSEND
• Context-free C server programs that access Enscribe and HP NonStop SQL/MP databases
• Using HP NonStop Transaction Monitor/MP (TM/MP) to ensure database consistency and integrity in the Pathway application environment
• Debugging requester and server programs using the Inspect facility
• Pathway system administration including configuration, starting, stopping, and monitoring components

Next Steps

Pathway application programming II U4191S

Course outline

• Pathway introduction
• Online transaction processing (OLTP) in the HP 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
• Establish your individual lab environment
• 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
• Configure Pathway TCP, TERM, PROGRAM, and SERVER objects
• Display Pathway object attributes and information
• Shut down a Pathway application environment
• Lab exercise (1 hour): Managing and Monitoring a Pathway system
• Use a series of commands to manage and monitor a Pathway application environment
• 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 stand-alone 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)
• Gain hands-on experience in coding the Guardian procedure calls to use $RECEIVE properly
• Code a server to respond to incoming requests
• Lab exercise (1 hour): Inspect debugging
• Establish an Inspect session in a Pathway environment
• Use the Inspect debugging tool to examine the message passing that occurs between a requester and a server
• Become familiar with common Inspect tool commands
• Enscribe Database Access (second segment)
• Alternate key access to Enscribe files
• Identifying and addressing simultaneous update issues
• File and record locking procedures
• Modifying Enscribe file characteristics
• HP NonStop SQL database access
• Use of HP 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)
• Code a server to access either an Enscribe or an SQL database to fetch records
• Use Guardian procedures to access an Enscribe database
• Use SQL statements for cursor handling in SQL database access
• Lab exercise (2 hours): New vehicle (Enscribe and SQL)
• Code a server to access either an Enscribe or an SQL database to perform updates
• Use Guardian procedures to perform record positioning and insertion in an Enscribe database
• Use SQL statements to fetch and insert rows in an SQL database
• HP NonStop Transaction Services/MP (TS/MP) programming
• Major components that make up the HP NonStop TS/MP environment
• Pathsend environment and the capabilities of a Pathsend requester
• Coding the Pathsend procedures
• Coding nowait Pathsend operations
• Design considerations in using the Pathsend facility
• HP 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