self evaluation testing

Existing User




If you are a existing user

click here to login



New User




If you are a new user

click here to register



Other Links





            skills development


            references


            feedback

ADABAS/NATURAL courses outline

Introduction

1. Introduction to Natural
2. Object types in NATURAL
3. Structure of a Natural program
4. Naming conventions
5. Format, Length and Type for variables
6. Constants Types – Numeric, Alphanumeric, Date and Time, Hexadecimal, Logical, Floating Point constants

Data types and Data Manipulation

1. Defining data – DEFINE DATA statement, Date formats, Data structures, Qualifying data names, Redefining fields , Level numbers
2. Natural functions- SUBSTRING, MASK, SCAN, BREAK, IS
3. Data transfer statements - MOVE, COMPRESS
4. Arithmetic statements - COMPUTE, ADD, SUBTRACT, DIVIDE, MULTIPLY
5. Truncation ,rounding and floating point numbers. Date arithmetic's and array addition/subtraction. Mathematical functions and Date handling
6. Concept of Data Blocks

Logical Testing

1. Relational expressions, arithmetic expressions in Logical conditions, handles. IF statement. Substring option for comparison
2. Extended relational expression. Logical variables. Logical Expressions and operators AND , NOT and OR
3. Non-database loop processing FOR, CALL LOOP, REPEAT, CALL FILE, READ WORKFILE, SORT, ESCAPE
4. Control Breaks processing – AT BREAK

Arrays and Array handling

1. Declaration , Initialization, array referencing, array resolution, comparison and arithmetic operations
2. Arrays as part of larger data structure

Formatting Output

1. WRITE and DISPLAY statements
2. EDIT MASKS

User Interface

1. Creating and using Maps
2. Attribute control

Pseudo

1. conversational technique and a comparison with other systems like CICS and IMS DC

Introduction to ADABAS

1. Database Access, Data Definition Modules(DDM), Components of a DDM
2. Multiple-value fields, Periodic groups, multiple-value fields within periodic groups, data views database arrays and referencing them
3. Database access statements – READ, FIND, HISTOGRAM
4. Database processing loops and ACCEPT/REJECT statements
5. Database update - STORE, DELETE, GET
6. Transaction processing - backing out and ending a transaction

System variables and Functions

1. AT BREAK, AT END OF DATA, COUNT, MAX, SUM, TOTAL, Mathematical functions,*APPLIC-ID, *APPLIC-NAME, date time variables

Programs, Subprograms and Subroutines

Platform specific information and additional information like Library organization and Overview of editors