The following explains how to validate whether ML Engine and Advanced SQL Engine functions are installed, accessible, and functioning. It is an easy way to get you started using the analytic functions when you first receive your Vantage system or to validate connectivity between Advanced SQL Engine and ML Engine after a maintenance system reboot.
You can run the following commands from any client (such as BTEQ or Teradata Studio).
If you use BTEQ, you can copy and paste SQL statements at the command line as follows:
- To run a single-statement SQL request, press Enter at the end of the line.
- To run a multistatement SQL request, press Enter after the last line. If you do not press Enter, every statement runs automatically except the statement on the last line.
From a client application (such as BTEQ or Teradata Studio), log on to the Vantage system as DBC. For example:
where systemname is the primary database node (the name by which the Vantage system is known to the network, also called the TDPID).
Run the following command:
help foreign schema "public"@coprocessor;In this command, public must be enclosed in quotation marks because it is a reserved word.
The command returns a list of functions that are installed. If an error is reported, the command will not return a complete list of objects in the schema.