IBM U2 UniVerse Fundamentals

Skill level: Basic

This course provides an introduction to the UniVerse extended relational database environment. Learn about the tools and commands used to input data into storage files, modify data records, and extract the records to produce and print reports. Build a sample database file, including data input through the editor and reporting using the RetrieVe processor. Explore UniVerse commands that perform ad hoc queries, generate and print reports, and create paragraphs to gather or report business information. This course is the classroom delivered version of 3U800 Instructor Led Online course. This course replaces course UV900.

course content details

	LIST statement: Introduction to RETRIEVE

	Determine how many records are in a file
	Practice command statement basics
	Locate and identify field names
	Simplify entering statements using the command stack commands
	Select criteria with which to create a report
	Sort a file by any field you choose
	Display the fields you want to see
	Use the SEARCH and ESEARCH commands to probe for text within a file

	The VOC file

	List the words in VOC
	Explore how words, files, sentences and paragraphs are stored in VOC
	Understand command processing
	Use the Editor to create your own words and sentences in VOC

	DICTionaries

	Display the contents of any DICT file and understand how each field is defined
	Create your own DICTionary and data files
	Define fields by setting their display, format, conversion and association specifications
	Create phrases to use as shortcuts with LIST statements

	I-Descriptors

	Convert a field to all upper case for more accurate searches
	Use the REUSE function to perform a function across a dynamic array
	Access system variables
	Use the OCONV function to convert output formats
	Compare values with IF/THEN/ELSE and process the results accordingly
	Link to information in other files with the TRANS function

	RetrieVe reporting

	Build on your considerable expertise to generate more sophisticated reports
	Select the precise data you want from a file
	Create custom headings and footers
	Reformat a display on the fly
	Make calculations on the fly with TOTAL and AVG (AVERAGE)
	Group data and create subtotals with BREAK keywords

	SELECT lists

	Create select lists and display their results
	SAVE, GET, EDIT and DELETE select lists you create
	Create select list special effects with SAVING and SAVING UNIQUE
	Compare multiple select lists with the LIST.UNION, LIST.INTER, and LIST.DIFF commands

	Miscellaneous commands

	Build and use background processes with PHANTOM and SLEEP
	Determine where you and others are on the system
	Track errors with the COMO command
	Get dangerous with MESSAGE

	Paragraphs

	Create and save a canned report by building a paragraph
	Use IF/THEN and LOOP/REPEAT to control what processes execute
	Build a report that prompts for selection criteria
	Generate a report that checks entered information

	Secondary indexes

	Describe what an alternate index is
	Investigate index status
	Understand how I-Descriptor indexes can speed up searches
	Take advantage of the alternate key index file in LIST statements

	File structure

	Use CREATE.FILE to create the various file structures
	Size the data file appropriately
	Determine the appropriate file type for various uses
	Understand the file structures used by UniVerse
	Recognize performance problems that can relate to the file structures

	UniVerse wrap-up

	Manipulate a record using ReVise
	Understand how Menus are created
	Know what development tools are available to you in the UniVerse environment