Case Training courses

...and use triggers Use the supplied WebSphere MQ programs to put and get Messages to Queues Course Details MESSAGING CONCEPTS Islands of Automation Program...

...courses in a 'non-design' capacity. Course Format: Interactive practical sessions make up a large part of the course, allowing delegates to demonstrate...

...Visual Studio IDE. The skills needed to use this software are presented as part of the Course. On completion of this Course the student will be able...

...The ORDER BY Clause Fetch First ''n'' Rows Only Clause Special Registers Current Date Current Time Current Timestamp User Keyword The UPDATE Statement...

...Whilst covering advanced concepts of JavaScript, and how it is used, this Course also aims to give an insight into JavaScript syntax. Associative arrays...

...to support historic "bread and butter" applications, or improve debugging capabilities. Course Format: Practical sessions make up a large part of the course...

...Data between Programs - The COMMAREA The LINK Command The XCTL Command The RETURN Command The START Command The RETRIEVE Command CICS Exec Interface Block (EIB)...

...Fetch First vs Optimize for Handling Nulls Retrieving System Registers Updating in CICS Timestamp Checking PLANS AND PACKAGES Bind Rebind Plans and Packages...

...The aim of this Course is to provide the programmer, unfamiliar with CICS, with the necessary skills required to design, write, code and test both CICS programs and BMS...

...use Indexable and Stage 1 predicates to write efficient SQL statements Course Details PHYSICAL DATABASE PERFORMANCE ISSUES The Structure Of DB2 Objects...

...Page and Row Organisation The Simple Tablespace The Segmented Tablespace The Partitioned Tablespace The Lob Tablespace Create Tablespace Parameters Alter... Learn about: Database Design...

...knowledge of the DB2 development process. It is aimed at programmers who need to code or support DB2 application programs written in COBOL or PL1....

...DEFINITION LANGUAGE The Structure Of DB2 Objects Definition Of DB2 Objects - DDL Database Definition Tablespace / Page Organisation Page Sizes Tablespace...

...MANIPULATION LANGUAGE EFFICIENCY ISSUES Row Placement Rules Select Statements The Where Clause Special Operators Special Operators - Examples Is Not Distinct...

...LOB Handling Check Index Performance Rebuild Index Performance Load Performance Copy Performance Reorg Performance - No Build2 Phase Online Reorg Enhancement...

...The Truncate Table Statement Optimistic Locking Package Stability Column and Index Renaming Course Environment The lectures apply to DB2 running in a z/OS environment...

...Trapping The Number of Elements Non Numeric Subscripts Multi-Dimensional Arrays Re-Initialising Variables - Drop SUBROUTINES Internal Subroutines External...

...development Course Objectives Whilst covering the basics of the different types of beans and how they are used, this Course also aims to give an insight...

...use Program Specification Blocks Understand and use the DL/1 ''CALL'' Statement and its'' parameters Develop programs using the various DL/1 calls available...

...statements and logic into Message Processing Programs. The course provides the COBOL or PL/1 developer with full IMS/DC training. It contains the detail...