#DateForumTypeThreadPost
3503 Aug 2010 @ 04:49 PDTDatabaseTopicFailure 2631 Transaction ABORTed due to deadlockalter table mydb.rtl_transactions drop sales_amt;  *** Failure 2631 Transaction ABORTed due to deadlock.                 Statement# 1, Info =0 Getting this error while dropping a col...
3428 Jun 2010 @ 10:43 PDTDatabaseReplyLoad TAB delimited data via Fastloadset record vartext " "; The above syntax is working fine. you have to give a tab between the quotes.
3305 Feb 2010 @ 06:39 PSTDatabaseReplyDBC.DBQLogTbl V12The field TotalCPUTime is also not present in dbc.DBQLogTbl table in TD12.Can anyone suggest, what is the alternative field for this.
3205 Feb 2010 @ 01:30 PSTDatabaseReplyExtracting Object PermissionsTry the below query......SEL TRIM(username) ,TRIM(databasename),TRIM(tablename),'GRANT '|| CASE WHEN AccessRight = 'AF ' THEN 'ALTER FUNCTION' WHEN AccessRight = 'AP ' THEN 'ALTER PROCEDURE' WHEN ...
3128 Jan 2010 @ 04:36 PSTToolsReplyScd type2SCD-Slowly Changing DimensionIt is capturing the slowly changing data which changes very slowly with respect to the time. Example: The address of a custumer may change in rare case. The address of ...
3028 Jan 2010 @ 03:30 PSTDatabaseReplyWhat is method or strategy to calculate the CPU utilized in running a Query?Step-1 Run the query in the database for which you need to calculate the CPU time elapsed, skew factor etc.Step-2 Then run the below query to get the desired statistics.SELECT /**tag 1**/ distinctl...
2928 Jan 2010 @ 03:22 PSTDatabaseReplyError -7423 while selectingYou can enforce row level lock while selecting from a table, instead of table level lock.Use "LOCKING ROW FOR ACCESS select * from table_name ......... ".In Teradata, locking is by default table le...
2827 Jan 2010 @ 08:35 PSTUDAReplyNeed help loading dataMerge all the files of different dates into one file, say all_files.csvThen use this file all_files.csv as the input file.Previous input file:FILE=\\IS02corp\rec\Files\Corp\IS\80720\HUB\HOTELSUMM\L...
2706 Oct 2009 @ 11:52 PDTUDATopicTable alter timestampIs there any metadata table/view where one can find the last modification time of the table. If we alter a table to add a new column, or drop an existing column, or any chnage to table structure, i...
2623 Sep 2009 @ 10:30 PDTUDATopicTpump loader ErrorI got the following Error while executing a Tpump loader script.**** 14:23:05 UTY3401 End of file was reached with an unbalanced number of quotes being found in the text.Please suggest if anyo...
2528 Aug 2009 @ 12:13 PDTUDATopicString manipulation in a MACROREPLACE MACRO mydb.emp_mac_test(in_emp_id varchar(300) )AS(sel * from db.emp where emp_id in (: in_emp_id););The requirement is that the macro will be executed as follows:exec mydb.emp_mac_test('A1...
2428 Jul 2009 @ 10:51 PDTDatabaseTopicLoad TAB delimited data via FastloadI am looking to load TAB delimited data via Fastload. I cannot identify what value to use for TAB.I have tried the following syntax:.set record vartext "tab"set record vartext "tab";.set record var...
2302 Jun 2009 @ 11:41 PDTUDATopicExecuting teradata procedures in unix shell scriptssqlplus -s /nolog @/rsl/app/upendra/login.sql << EOFset serveroutput onset timing onexec CAT_CHCONFIG_APP('M','1');EOFCAT_CHCONFIG_APP is an oracle procedure.Is there any way to run teradata ...
2217 Mar 2008 @ 02:35 PDTUDAReplyLocked tableThanks.I have also sth to share .On Windows, the utilities can be run from Database Window, Teradata MultiTool, and fromthe Teradata Command Prompt.Reference->Utilities,Volume-2, G-S page -87
2114 Mar 2008 @ 05:03 PDTUDATopicLocked tableIs there any mechanism in teradata to know exactly which tables are lockedat a particular instance of time and the types of lock being imposed on the tables
2013 Mar 2008 @ 05:19 PDTDatabaseTopicuser defined exceptionIn oracle there is a way to make user defined exception .It is useful when there is need to catch more business related problems rather than just the traditional exception such as 'not found' or 'd...
1913 Mar 2008 @ 04:59 PDTDatabaseReplyrowid in TeradataBy giving xb sufix ,it works.Thanks for the information.
1813 Mar 2008 @ 03:09 PDTDatabaseTopicrowid in TeradataI want to use rowid to update a table . sel rowid,emp_id,e_name from test;*******************************************************************result set--->**************************************...
1712 Mar 2008 @ 03:45 PDTConnectivityReplyHow to write UDF to handle operating System I/O operationsIt is giving the following error.BTEQ -- Enter your DBC/SQL request or BTEQ command: select appendlog('this is my test string');select appendlog('this is my test string'); *** Failure 7504 in UDF/X...
1612 Mar 2008 @ 03:06 PDTConnectivityReplyHow to write UDF to handle operating System I/O operationsThanks for the information.
1511 Mar 2008 @ 01:19 PDTDatabaseReplyplease help me....Some useful links in the blog.http://upendramishra.blogspot.com
1411 Mar 2008 @ 12:42 PDTConnectivityReplyHow to write UDF to handle operating System I/O operationsThanks for the information.Can you post a sample code which opens a file and writes anything to it.And the create function statement also.
1310 Mar 2008 @ 07:46 PDTDatabaseTopicprint statementIn Teradata print statement isn't giving output to the stdout.Then what is it's usage.Or that requires some other environment settings.
1210 Mar 2008 @ 07:43 PDTDatabaseTopicsynonymsIs there any alternative to Oracle's 'create synonym .......' in Teradata.
1110 Mar 2008 @ 01:37 PDTConnectivityReplyHow to write UDF to handle operating System I/O operationsur right.it doesn't work on 2 node system.The error is like 'it failed to create authorization on the two nodes if i give authorization clause as it is a OS I/o.With out this clause in the create f...

Pages