Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 04 Feb 2004 @ 18:41:43 GMT


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


Subj:   Re: UPDATE and OUTER JOIN
 
From:   Christian Schiefer

Hi,

here's the statement from the GSC.

I did a mistake before ist not internal flag 41 but 44.


Sorry,

Christian

# This is highly likely the same problem as described in
# DR 85359.
#
# This describes a similar problem where we get the 3791 error
# when using derived tables with an inner join.

# Also, DR 85359 says that very likely the problem was introduced
# with DR 83246, which has been implemented in 5.00.02.11
# (and 5.00.00.37, so .33 wouldn't have it). So 5.00.02.12
# definitly has the problem described in DR 85359.
#
# Since all of this points towards the same problem as at Nadra,
# I would like you to contact the customer for trying the
# following:
#
# DR 85359 says that two workarounds exist for the problem:
#
# 1) Change the SQL to not use the join syntax (use the where
#    clause instead)
#
# 2) Change SPOOL DERIVED TABLES = TRUE (dbscontrol internal flag 44)
#    -or-
#   diagnostic nodt on for session; (note: submit before submitting
#   the update 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: 27 Dec 2016