Function Arguments - FormatDate
Use the Start page to choose the type of SQL statement that you want to create. The types of statements that you can create might be limited, depending on the application that you were using when you started SQL Assist.
Creates a statement that returns rows that are based on criteria that you specify on the SQL Assist notebook pages.
Adds rows, one at a time, to a table.
Changes values in a table.
Removes rows from a table.
Use this page to make a connection to a database.
Specify the connection type, database type, and database name.
Specify the user ID that you want to use to connect to the database.
Specify the password for the user ID.
Specify the type of database to which you are connecting.
Specify the location and name of the JDBC driver that you want to use.
Connects to the server that is specified in the Database URL field.
Disconnects from the server that is specified in the Database URL field.
Use this page to select the tables that you want to include in your SQL statement.
Displays the schemas and tables that are accessible in the database that is identified by the currently selected connection alias.
Displays the tables that will be used in the SQL statement.
Moves the highlighted items from the Available list to the Selected list.
Moves the highlighted items from the Selected list to the Available list.
Moves all items from the Selected list to the Available list.
Opens the Filter Schemas window for selecting schemas.
Opens the Filter Tables window for you to specify filtering characters. These characters limit the display to only the table names that begin with those characters. The filtering characters are case-sensitive. The % character is a wildcard character.
Use this page to select the columns that you want to include in your SQL statement.
Displays the columns in the tables that were selected on the Tables page.
Displays the columns that are included in the result set.
Moves the highlighted items from the Available list to the Selected list.
Moves all items from the Available list to the Selected list.
Moves the highlighted items from the Selected list to the Available list.
Moves all items from the Selected list to the Available list.
Moves the selected item up one position in the list.
Moves the selected item down one position in the list.
Opens the Expression Builder - Columns window.
Opens the Expression Builder - Columns window with the currently selected expression.
Removes the calculated column from the Selected columns list.
Use this page to join tables in an SQL statement. The Joins page displays the columns of each table that is selected in the Tables page. Select columns in each table that you want to join. You can specify multiple joins.
Joins the selected columns. The join is indicated by a red join line.
Scrolls through the joins. The line that represents the current join is highlighted in red.
Scrolls through the joins. The line that represents the current join is highlighted in red.
Removes the selected join.
Opens the Join Type window. Use this window to specify the type of join you want to create: inner join, left outer join, right outer join, or full outer join.
Use this page to specify a search condition for an SQL statement. You can specify multiple search conditions.
Exclude duplicate rows (SELECT DISTINCT)
Indicates that all specified conditions must be met.
Indicates that one of the specified conditions must be met.
Displays the names of the columns in the table or tables specified in the Selected tables field on the Tables page.
Displays the operators that can be used in the condition. The operators can change, depending on the data type of the column that is selected in the Available columns list.
Displays the values that will be used in the condition. You can either type the values into this field, click Find to open the Find window and select the values that you want to use, or click Add Variable to specify a host variable.
Opens the Find window, where you can select values that you want to use in your condition.
Opens the Add Variable window, where you can specify host variables to be used in your condition.
Removes all of the values from the Values list.
Appends the current condition to the Conditions field.
Displays the current conditions.
Opens the Expression Builder - Conditions window.
Eliminates all but one of each set of duplicate rows in the result set. Two rows are duplicates of one another only if each value in the first is equal to the corresponding value of the second. Two null values are considered equal.
Use this page to specify which columns to use to divide the result set into groups.
Specify whether to include grouping in your SQL statement.
Displays all columns in the Selected columns list on the Columns page, if the Include grouping columns checkbox is selected.
Specifies the columns that will be used to divide the data in the result set into groups, based on the values in those columns.
Specifies an expression that is used to eliminate unwanted grouped data by filtering the results that are returned by the grouping columns.
Opens the Expression Builder - Conditions window.
Use this page to specify the order of rows in the result set. You can specify multiple sort columns.
Displays the columns in the tables that were selected on the Tables page.
Specifies one or more columns to be used as sort columns.
Moves the highlighted items from the Available list to the Selected list.
Moves all items from the Available list to the Selected list.
Moves the highlighted items from the Selected list to the Available list.
Moves all items from the Selected list to the Available list.
Indicates whether the values in the column are listed in ascending (up) or descending (down) order.
Moves the selected item up one position in the list.
Moves the selected item down one position in the list.
Displays those columns that are specified in the Selected columns list on the Columns page.
Displays those columns that are listed in the Available columns list on the Columns page, plus any column expressions.
Use this page to remap the data retrieved from a table column to a different SQL data type. This action also maps the data to a different Java class.
Displays the columns that are available for mapping.
Displays the SQL data type for the column.
Specifies the data type to which the data retrieved from the column will be mapped.
Resets the mapping of all columns to their default SQL data types.
Use this page to specify the values that you want to add to the specified table.
Displays the value to be inserted.
Use this page to specify the values that you want to change in the specified table.
Displays the value that will be added to the table.
Use the Review page to display the SQL statement that was generated from selections on the other pages.
Do not include schema names for tables owned by schema name
Displays the tables and columns that you can use in your SQL statement.
Displays the SQL statement that was generated from selections on the other pages.
Removes any unsaved changes that you made in the SQL statement field.
Runs the SQL statement against the database and displays the results in the Results window.
Opens a Save window in which you can specify the location and name of the file in which you want to save your SQL statement. The default file extension is sql.
Specify whether to qualify table names in the SQL statement that are owned by the current user with that user's schema.
Use the Expression Builder window to build a column expression, a row condtion, or a group condition.
Displays columns that you can use in your expression.
Displays operators that you can use in your expression. The operators in this list can change, depending on whether you are building a column expression, a row condition, or a group condition.
Displays case operators that you can use in your expression.
Displays values that you type. The values are added to the expression when you click the checkmark button.
Displays functions that you can use in your expression. Clicking on a function category displays the functions of that category in the list below.
Displays constants that you can use in your expression.
Adds the logical operator AND to the expression at the cursor location.
Adds the logical operator OR to the expression at the cursor location.
Adds the operator = (equals) to the expression at the cursor location.
Adds the operator <> (not equal) to the expression at the cursor location.
Adds the operator ( (left parenthesis) to the expression at the cursor location.
Adds the operator ) (right parenthesis) to the expression at the cursor location.
Displays the expression as you type or build it.
Removes all input from the Expression field.
Removes the last change that you made from the Expression field.
Reverses the last change that you made in the Expression field.
Use the Results window to view the result set of your SQL statement.
Copies the result set to the clipboard.
Saves the result set in a file.
Closes the window.
Use the Function Parameters window to specify parameters for the selected function.
Select the format of the function.
Specify the values for each parameter.
Use the Function Arguments - FormatDate window to change date and time information from one format to another.
Displays the columns that you can use with the FormatDate function.
Displays the name of the column that contains the field for which you want to reformat the date and time. This field is required.
Displays the category of the date/time format that is currently defined to the input column. This field is required.
Displays the date time format that is currently defined for the input column. This field is required.
Displays examples that correspond to the date/time formats that are listed in the Format column.
Displays the format string for the date or time in the input column.
Displays the category of the new date or time format. This field is required.
Displays the new date or time format. This field is required.
Displays examples that correspond to the date/time formats that are listed in the Format column.
Displays the selected format string for the date or time in the Format column.