Database manipulation language SQL statements are used to manipulate data in tables. The following functions are provided in the HiRDB SQL:

Basic data manipulation

• Data retrieval
• Data updating
• Data deletion
• Data insertion
• Search for specific data
• Data operations
• Data processing
• Manipulation of data in a table containing an abstract data type

Reduction in number of steps required for UAP development and reduction of communication and analysis overhead

• Stored procedures
• Stored functions

Improvement in database access performance

• Block transfer facility
• Rapid grouping facility
• FETCH facility using arrays
• Holdable cursor
• SQL optimization option