Archives of the TeradataForum

Message Posted: Mon, 16 Jan 2006 @ 10:12:52 GMT

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

Hi ,

We are using V2R5.0

There is senario, We have created a table a char, b int fields. when we are giving A=1 (without codes) SQL*assistant is giving error 2621:BAD CHARACTER IN FORMAT OR DATA OF TESTPRE.A

But same query in EXPLAIN is working fine but showing that 'WE WILL DO TRANSALATE'

Does anyone have come accross this kind of situation? As i have noticed this first time that explain is working but select is giving error.

Regards

Rajesh Arora

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