Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 27 Sep 2011 @ 20:07:00 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: Can not change default database
 
From:   barb.green

Too right Martin!

Cant remember what the hierarchy is, default database can be set at user, profile, dsn connection, or command line. I forget the exact order in which they are evaluated someone smarter than I can tell you. You must check at each of these levels to confirm that one setting is not superseding another.

You are able to set the default database for the session, that is working as planned. Suspect you validate settings at DSN or profile.

As a DBA I prefer to control default database and spool and other settings a profile level and not have DSN send extra database xxx; commands - if you have access to it check to see what DBQL is logging for your user credentials.


Good Luck

'barb



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023