Archives of the TeradataForum

Message Posted: Sat, 02 Apr 2005 @ 20:05:40 GMT

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

Prasanna,

There could be many reasons for this. Like

1. user may not have proper access to a any database object.

2. trying to access any database object which doesn't exist.

3. trying to call a stored procedure with inadequate parameters etc..

To find the all possible reasons, refer the Teradata manual vol6, APPENDIX-D where you will find the SQLSTATE TO Teradata error code mapping table.

Then refer the dbc.errormsgs table to get the list of error messages related to this SQLSTATE.

Hope this helps..

Thanks,

Tapas

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