Skip to main content

System Status: 

How to Use the SQL Executer

Use the SQL Executer if you can't obtain the results you want from any of the Link products or from a Standard Query in DataLink.

Note: If you don't know the SQL programming language, you can use QueryLink by clicking the Queries button in FinancialLink, EmployeeLink, Student/ Class Info tools, and DataLink.

For detailed instructions on SQL, enroll in a SQL training class.

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.

  • 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. Choose a subject area.

  • If you are using the SQL Executer tool labeled SQL Executer:
    • Use the Schema drop-down list to choose a subject area within the Data Warehouse production environment.

  • If you are using the SQL Executer tool labeled Advanced SQL Executer
    • Use the database drop down list to choose a specific server within the Data Warehouse environment.
    • In the Schema field, enter the actual schema name such as "pur."

5. Choose the output options you want.

  • Complete these fields to determine how you'll receive the information.
    • Return Row Limit - By default 20 output rows will be returned from a SQL query. Leave this field at 20 until you are satisfied that your query is returning correct results.
    • Send Data To - How your information will be displayed and saved:
      Screen - Returned to the screen
      PC File - Saved as a PC file.
      Mac File - Saved as a Macintosh file
      Unix File - Saved as a Unix file
    • Display Options - What your results will show:
      Show general info with results - General info will be returned along with SQL results.
      Show SQL with results -The SQL code will be displayed along with SQL results.
      Show results in new window -The SQL results will be displayed in a new window (requires JavaScript). 
    • File Options - What you want saved in your files.
            File Type -
      Choose a file type.
            Include column headings -
      Column headings will be saved along with the SQL results.
            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.

For general Data Warehouse related questions or comments, e-mail ITS-DATAWAREHOUSE@ad-ucsd.edu.