Archives of the TeradataForum

Message Posted: Fri, 08 May 2009 @ 21:17:13 GMT

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

Hi Mohan,

Thank you.

'DEV' is not a database. My server name is 'DEV'. I taught of server is unavailable but I am able to connect the server and perform the update transactions. When I use Select in Update I am getting the 3802 error. I tried replicate the scenario in my personal laptop but it did work without any problem. When my DBA run this query in his system through SQL assistant it did work without any problem but when I use the same query to execute through Java it throws the below error. I guess, this some system setting.

I am not well versed on system administration side.

My query:

     UPDATE TDT.TEST_RD
     from
     (
     select    test_id
     from    tdt.test
     where    test_id=451) b
     SET    DELETE_IND = 'D',
            CONTROL_ID = null
     WHERE TDT.TEST_RD.TEST_ID = b.test_id;

     Error: 3802: Database 'DEV' doesn't exist.

Regards,

Kumar.

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