Archives of the TeradataForum

Message Posted: Mon, 13 Feb 2006 @ 18:47:39 GMT

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

Our DDL was created via a program that read from an Oracle Schema.

The problem is that this program put FORMAT on all kinds of stuff.

For instance, DECIMAL (8) has a format of '9(8)'.

Pulling negative numbers from this works fine in SQL Assistant. And it works fine in BTEQ if you add a format clause to your query. (i.e. '- 99999999', I think.) But, the default returned to BTEQ without an overriding format clause with '9(8)' eliminates the sign.

So, -43 in BTEQ looks like 43. (Unless, as I said, you know this is going to happen and override it in your query.)

My goal is just to eliminate all format clauses. This, in turn, will eliminate the problem.

This is a particularly big issue for our testing group, would have to modify all of their SQL to handle this situation across the board.

Thanks.

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