Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 06 Jan 2006 @ 15:38:14 GMT


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


Subj:   Re: Different Explain plan for different users - SAME SQL
 
From:   Geoffrey Rommel

  run by the same production user, but executed by DataStage, using an API stage  


On my system, the API (or TeradataPX) stage uses ANSI transaction mode. There doesn't seem to be a way to override this in the stage itself, although there might be via an environment variable or installation option. Otherwise, I don't see anything unusual about the API; it's running ordinary DBC/SQL.



     
  <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: 23 Jun 2019