Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

Teradata tables might not be listed in the SAS Explorer library even after a libref is successfully assigned. This problem can be resolved by adding the SCHEMA= option in the LIBNAME statement, as shown in the following example:

libname tera teradata user=teradata-username 
                      password=teradata-password 
                      schema=teradata-schema; 

The schema is another name for the owner. If you are not sure what to use for schema, you can find the schema name by submitting the following SQL procedure. In this code, DBC is the name of the database.

proc sql; 
   connect to Teradata(user=teradata_username password=teradata_password);
   create table list_tab as 
          select * from connection to Teradata(select Creatorname, 
                                               tablename from dbc.tablesx); 
quit; 

The SAS data set LIST_TAB then lists the Teradata tables with their associated schema names.

Operating System and Release Information

proc sql;
Connect to Teradata(user=tera_user password=tera_pass);
Create table list_tab as
Select * from connection to Teradata(select Creatorname, tablename from dbc.tablesx);
quit;