Search results for query: *

Stored Procedure erratic failure with 3604 "Cannot insert a Null value into a NOT NULL field". Below is portion( only the failure step is copied below ) of a stored procedure that fails intermittently on a V2R.04.01.01.12 ( REL 04.01.01.36 ) Machine. The failure occurs with no...

Below is the code sniplet which is throwing an exception at the second line when used with a Type3 Teradata driver to connect to a Teradata database. Tried some other method getCatalogs() and it works fine. DatabaseMetaData dbMetaData = con.getMetaData(); rs = dbMetaData.getPrimaryKeys(null...

Thanks for the reply, I am interested to know whether Teradata has got any mechanism other than CSUM to generate a sequence number like Pseudo tables used in other databases like Oracle having Sequence etc..

Any help regarding the below issue is highly appreciated!!!. Trying to Accomplish is to Load data from RB_TestClone Table to RB_Test table, but should generate a Sequence Number automatically based on the group COL1, COL2. COL1, COL2, COL3 are the columns from TestClone to be loaded to Test...

Hi, Yeah I found later that's the solution is NCR SUPPORT.....I had to DROP and recreate the target tables again to get rid of the error... Thanks for the suggestion. Raj.

Hi dave, Yeah, after dropping the above mentioned tables I issued release MLOAD command too.Actually MLOAD was not active on the target tables.The error number and description is not helping me out to locate where the problem would be. Thanks, Raj.

RDBMS failure, 2554: Inconsistent situation occurs in restart MLoad?? I got the above error while running MLOAD utility. I dropped all the worktables, error tables, application tables and restarted the MLOAD to run Mload as a new process , but its still giving the same. Can anyone give an idea...