| What to do |
How to do it |
| 1 |
Go to the SQL Executer. |
- Open DataLink.
- Click the link on the left to open the SQL Executer.
Note: Before you start be sure you:
- Understand SQL commands and the Data Warehouse database environment
- Are familiar with table and column names, and security access
|
| 2 |
Enter the SQL Code.
|
- Type the SQL commands in the free formatted text window.
|
| 3 |
Retrieve and/or save your SQL commands. |
- 1. To use a command from a previous file, Browse to the location and retrieve your SQL from the file. The retrieved SQL commands will appear in the text window.
- If you want to save the command in the text window, press the Save SQL to File button and save it to your local drive as a text file.
|
| 4 |
Login to the database. |
- If you are using the SQL Executer tool labeled SQL Executer:
- Use the Database drop-down list to choose a subject area within the Data Warehouse production environment.
- In the Userid/ Password fields, enter either your DARWIN or SQL-DSE user ID and password.
- If you are using the SQL Executer tool labeled Advanced SQL Executer
- Use the server drop down list to choose a specific server within the Data Warehouse production environment.
- In the Database field, enter the actual database name such as "pur."
- In the Userid/ Password fields, enter either your DARWIN or SQL-DSE user ID and password.
|
| 5 |
Choose the output options you want. |
- Complete these fields to determine how you'll receive the information.
Column Delimiter - If the SQL results are being sent to a file, specify the desired field delimiter.
|
| 6 |
Run the Query. |
- Use the Run Query button.
|
| 7 |
Clear the form. |
- Use the Reset button.
|
