...

• The original table that is used as the default value in any custom SQL query remains the default table whenever the custom SQL dataset is used.  
  • During job execution on a dataset of parameterized tables, if the parameterized SQL query returns data from a table from the default table,

    D s platform

    expects that the schema of the new table matches the schema of the original default table.
  • If the schemas do not match, schema mismatch errors may be reported.
•   Parameterizing the column project list in the SELECT  portion of a custom SQL statement is not supported.
• Schema refresh of a parameterized dataset using custom SQL is not supported.

...

1. In the

   D s webapp
   type Portal

   , click Library  Library for Data in the left nav bar.
   
2. In the Library for Data page, click Import Data.
3. From the left side of the Import Data page, select the relational connection from which to import.
4. Depending on the type of relational connection, you may need to select the database or schema to browse. 
5. Locate the tables to import. Take note of the table name or names.
6. Click  Create Dataset with SQL. The Create Dataset with SQL window is displayed.

...

• When a job is executed, the currently specified variable value is passed to the running environment. By default, the value that you specify as part of the dataset creation process is provided. 
• You can override this value:
  • You As needed, you can specify an override for a variable parameter through Flow View. 
  • For any specific job run, you can specify an override value through the Run Job page.
• In this manner, you can specify the exact data that you wish to retrieve at the flow- or job-level.

Steps:

1. Create a custom dataset using SQL. For more information, see Create a Custom SQL Dataset above.
2. In the Create Dataset with SQL window, enter a SELECT* statement to retrieve data from the specified table. Click Validate SQL to verify that the query is properly specified. 

3. Now, highlight the part of the query that you wish to parameterize. Click the Variable icon. 
   

   D caption
   Define Variable Parameter

4. In the Variable dialog, enter the following details:
   
   

   Tip
   Tip: Type env. to see the environment parameters that can be applied. These parameters are available for use by each user in the environment.

   1. Name: Enter a display name for the variable.

   2. Default value : Enter a default value for the parameter.

5. Click Save  to save the parameter.

6. To verify that your SQL is still valid, click  Validate SQL .

7. If the SQL is valid, click Create Dataset.

...