DAC : Database Specific Text Type Parameter

Procedure to define a parameter using the DB Specific Text data type. This procedure applies to parameters defined at both the source system and task levels.
To define a database specific text type parameter:

1. Do one of the following:
   
   • To define a source system parameter, from the Views menu, select Design, and then select Source System Parameters.
     
   • To define a task level parameter, from the Views menu, select Design, then select Tasks, and then click the Parameters subtab.
     
2. Click New.
   
3. Enter a parameter name.
   
4. Select the DB Specific Text data type.
   
5. Click in the Value field to open the Enter Parameter Value dialog.
   
6. Select one of the following Connection Type options:
   
   • @DAC_SOURCE_DBTYPE. This option specifies a source database connection.
     
   • @DAC_TARGET_DBTYPE. This option specifies a target database connection.
     
7. To define a parameter specific to all database types:
   
   1. Click in the Default field to open the Default text box.
      
   2. Enter the parameter definition, and click OK.
      
8. To define a parameter specific to a particular database type:
   
   1. Click in the appropriate database type field to open the text box.
      
   2. Enter the parameter definition, and click OK.
      
9. Click OK to close the Enter Parameter Value dialog.
   
10. (Optional) To inactivate the parameter, select Inactive.
    
11. Click Save.