Archives of the TeradataForum

Message Posted: Tue, 17 Dec 2002 @ 17:50:09 GMT

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

We also had this problem when we recently upgraded to QM 6.01. There is no solution I am afraid, only work arounds. NCR assure us that this will be fixed in the next release with TTU 7.0.

Something else you need to be aware of is that if you cut and paste from Word (and maybe other Office apps) is that you can get different results from previous versions of QM. The paste from Word can convert some characters to end of line characters. We ran an update query similar to below which changed 130K rows in QM5:

UPDATE table
SET col1 = col2 - col3
WHERE category = 'value'
;

QM6 updated only 35K rows because it actually ran:

UPDATE table
SET col1 = col2

This was because the minus was changed to end of line when the query was submitted and QM does not require a semi-colon to terminate the query. There are two ways around this - overtype the minus symbol in QM or if you do not need them, turn off ODBC SQL Extensions in the Tools->Options menu.

Another thing to be wary of is "Smart Quotes". Turn these off in Word under the Tools menu.

Paul Ibberson

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