Course description: UniData Fundamentals
In this hands-on, introductory course, focus on how to use UniData. Learn both the process and the theory of querying the database and creating specialized reports. Build a database file from scratch, including creating a data dictionary, entering data, and then exchanging data with other database files. Learn the Environment Control Language (ECL) and the Alternative Editor (AE). Explore advanced ECL topics, including running background processes at scheduled times and basic administration commands. Also, learn about Process Control Language.
Skills taught
- Probe a data file using LIST and SORT statements
- Use ECL commands and the AE to build a database file
- Create a data dictionary
- Add virtual attributes to files that perform mathematical calculations and import data from other files
- Use the MERG.LIST command to create select lists and merge two lists together
- Create, build, and maintain alternative key indexes
- Use ECL to run background processes at scheduled times
- Use basic administration commands including COMO and STATUS
- Use Process Control Language to link several statements into one piece of code
- Describe the UniData data model
Course outline
- Introduction to UniData
- Take command!
- LIST statement
- Vocabulary (VOC) file
- Dictionaries (DICT)
- Data models
- Virtual attributes
- UniQuery reporting
- Alternate key indexes
- Select lists
- Advanced ECL
- Process Control Language
- System review