|
The Application Developer provides
application development services related to design, implementation, debugging,
profiling and deployment of U2 software applications. Developers are expected
to apply sound programming techniques and solutions common to both UniData and
UniVerse database programming languages utilizing applicable API's available to
produce robust applications. The applications may include SQL connectivity
commands and techniques suitable for external use of U2 database
data.
Certification can be achieved if you have
experience with designing an application for the UniData and/or UniVerse
database and programming experience in either UniData UniBasic or UniVerse
UVBasic programming language running up to UniData Release 5.2 and UniVerse
Release 9.6. Section 1 - Application Design (13%) - Create
hashed files
- Define file dictionaries
- Define file indices
- Integrate application tools (PROCS/Paragraphs, UniQuery/Retrieve, SQL)
- Define API
- Use external subroutines
Section 2 - Logic Constructs (15%) - Control
program flow
- Control file access
- Employ logical operators
- Employ arithmetic operators
- Use internal subroutines and
user-defined functions
Section 3 - User Interface (10%) - Define
character based screen layout
- Accept and format user input
- Validate user input
- Output reports
Section 4 - File Handling (18%) - Open, close,
clear, delete files
- Select data from files
- Read data from
files
- Write data to files
- Use locking techniques
- Use
SQL triggers
Section 5 - Data Formatting and Manipulation (19%) - Format numeric data
- Format date/time data
- Format text
data
- Format string/substring data
- Format output data
- Search strings/substrings
- Manipulate strings/substrings
Section 6 - Array, Variable, and Statement Label Handling
(11%) - Define and manipulate dimensioned arrays
- Define and manipulate dynamic arrays
- Define statement labels
- Define variable names
- Use EQUATE, COMMON and
INCLUDE
Section 7 - System Variables and Functions (10%) - Use COUNT and DCOUNT
- Get and use information from FILEINFO
- Use PERFORM and EXECUTE
- Get and use information from SYSTEM
- Use system DATE and TIME
Section 8 - Debugging Application Programs (4%) - Understand basic debugger capabilities
- Invoke program debugger
- Compile programs for debugging
| 
