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>>  

From:   Christian Schiefer


here's the statement from the GSC.

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



# 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
# (and, so .33 wouldn't have it). So
# 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