Archives of the TeradataForum

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

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

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