List of Examples

• 3-1 Creating a SQL Translation Interface Package and a Translation Profile
• 3-2 Sample configuration file, drdaas.ora
• 3-3 Granting the DRDAAS_ADMIN_ROLE
• 3-4 Adding DRDAAS_ADMIN_ROLE to Default Values
• 3-5 Dropping package ORACLE.MYPACKAGE, as Administrator
• 3-6 Dropping package ORACLE.MYPACKAGE, as User
• 3-7 Granting and Revoking a User's Package Privileges
• 3-8 Setting and Deleting Translation Profile Name for a DRDA Package
• 3-9 Granting the DRDAAS_USER_ROLE
• 3-10 Adding DRDAAS_USER_ROLE to Default Values
• 4-1 Creating a SQL Translator Interface Package
• 4-2 Granting EXECUTE access to SQL Translator Interface Package
• 4-3 Granting Required Authority to Users with DRDAAS_TRANS_ADMIN Role
• 4-4 Granting Translation Authority to Users with DRDAAS_USER_ROLE
• 4-5 Creating and Managing the SQL Translation Profile
• 4-6 Loading a Third-Party SQL Translator; Single Object
• 4-7 Loading a Third-Party SQL Translator; Multiple Objects
• 5-1 Registering a SQL Substitution Statement
• 5-2 Registering an On-demand Datatype Conversion
• 7-1 Constraining Oracle NUMBER to Exactly Match DRDA SMALLINT
• 7-2 Using TYPEMAP in Queries that Use the Column Directly
• 7-3 Using TYPEMAP in a Function
• 14-1 Removing Clauses from SQL Statements
• 14-2 Retrieving values from special registers
• 14-3 Setting special registers