Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 26 Sep 2011 @ 19:00:20 GMT

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

Subj:   Re: Can not change default database
From:   Dave Wellman


The results that you're seeing is what is expected.

Using the MODIFY USER command changes your user definition. This change does not take effect until the next time you logon.

If you want to change the default database for your current session (which would be reflected when you issue "SELECT DATABASE") you need to use the DATABASE statement.



  <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