Actocom is registered as a training service company under the number 42 68 01848 68.

Main training domains: Linux and AS400

Training goal

Linux is for a developper and integrator of internet and intranet solutions. This training is made in 7 days. The goal is to give enough elements to be able to continue further. Maximal practice is foreseen.

  • Install a Linux system
  • Use basic commands in console mode
  • Update a system and install new programs on the system
  • Manage users
  • Share ressource disks or printers on a network with SAMBA
  • Install and administrate a FTP server
  • Install, administrate and use a web server apache by creating an intranet site

Training AS400

Introduction

History and fundamental principles

Basic concept

The objects - the libraries - the library list - the menus - the orders - the members

Job managing

Sub system - ( SBS ) - Interactive jobs - Jobs by batches - Job description - Job waiting queue (JOBQ) - Job managing (WRKUSRJOB - WRKACTJOB) - Job planning. -Spoule

Development manager and source editor

Library managing - object managing - member managing - source files - SEU ( STRSEU )

Messages

Message queues - display - send a message - Creation of a message queue - message file

Screen files

Creation of DDS source - control by type of data - control by key words - main key words screen - creation of the object

Control language ( CL )

Limit of CL - structure - variable declaration - file declaration ( FD ) - Other orders - CHGVAR - IF/ELSE - DO/ENDDO - Goto - expressions - call - RTVJOBA - RTVUSRPRF - RTVUSRVAL - CHGJOB - MONMSG - data zones

Data

Codification of physical files - file key words - size key words - zone key words - reference file - creation of a physical file CRTPF - order CPYF - logical files 8.2.4 joined logical files - orders in connection with files - CPYF : order copy

DFU

Choice of program and file name - choice of fields - use

SDA

Conception of a screen picture - conception of a menu

QUERY

STRQRY - selection and sorting out - sum up and split - exit parameters - several files - OPNQRYF

Introduction to RPG

Small history of RPG - specifications - F for files - O for output - I for input - D for declarations - C for processing - some operations - acces to files : reading, writing or updating - partial reading - CHAIN : read only one recording- SETLL READ : positioning and reading the following recording - writing - update

Saving and restoring

 

Securities

Users - Rights on objects - List of authorization

Crossed references

Customer access or iSeries access

Functioning - basic operations - job managing - inventory of PTF - network - network security - point à point - protocols : TCP/IP - servors - servors - Internet - security - list of authorization - strategies - users and groupes - data base - table - view - Journalisation - file system - saving - development

 

DB2/400 or DB2 for iSeries

 

SQL

 

RUNSQLSTM start a source SQL - SQL manager - restraints - entity restraints - referential integrity restraints - control restraints - order for restraints WRKPFCST - using of restraints by SQL

Trigger