#DateForumTypeThreadPost
708 Jan 2013 @ 02:28 PSTDatabaseReplyTeradata Lock in Insert StatementThanks Fred for correcting me. I have tried this and worked :)
608 Jan 2013 @ 09:09 PSTDatabaseReplyTeradata Lock in Insert StatementA user can lock the table/Row only for access. They cant be locked for DML operations by the user. The system will apply the lock at table/row level based on the DML operations.    
508 Jan 2013 @ 08:46 PSTDatabaseReplyFast Load - Insert Select StatementThank you Qaisar.
403 Jan 2013 @ 06:03 PSTDatabaseReplyFast Load - Insert Select StatementThank you for the input. Trying to load the target table through stage table within the fastload. This might not be possible so using the bteq to do that.   Regards, Suneel
303 Jan 2013 @ 08:13 PSTDatabaseReplyTime Data TypeThank you Tahoon. It worked. I am trying to change to ANSI mode, without trying to modify the ODBC setting. Can it be over written for only specific session. I tried 'SET SESSION DATEFORM=AN...
202 Jan 2013 @ 03:51 PSTDatabaseTopicTime Data Type  Hi  I have created a table with column as TIME(0) data type. When I look at the table DDL, through SHOW TABLE, it shows the column data type as 'Integet Format '99:99:99'...
124 Dec 2012 @ 11:58 PSTDatabaseTopicFast Load - Insert Select Statement  Hi All,   Is is possible to have 'Insert/Select' statement in fast load utility.   Example: fastload << ! <load empty TableB through fi...