#DateForumTypeThreadPost
2328 May 2008 @ 04:28 PDTDatabaseReplyCreating Stored Procedures in BatchHello,If you are using BTEQ script for batch, you can use ".COMPILE FILE sp1.sql" to compile the SP.Regards,Adeel
2226 May 2008 @ 07:12 PDTDatabaseReplyForeign KeyHello,If you have select rights on DBC, please have a look at all views starting with "RI_".Regards,Adeel
2125 May 2008 @ 06:51 PDTToolsReplyERROR ~ [Teradata DBMS] : Response limit exceeded.Try by lowering the loop, e.g. 100 => 10 if it works fine, then you are hitting a limit somehow, and also try by putting the commit part in the loop and then slowly increasing the loop till 100 ...
2023 May 2008 @ 06:43 PDTDatabaseReplyOptimize a query containing UNIONLittle change:select a.Reg_no, b.subjectfrom table1 a cross join vtTable1 bwhere a.subject1 is not nullAND a.subject2 is not nullAND a.subject3 is not nullAND a.subject4 is not nullAND a.subject5 i...
1923 May 2008 @ 06:37 PDTDatabaseReplyOptimize a query containing UNIONHello,Create a VT table (suppose vtTable1) with 1 column and insert all the subject names in it, e.g.:Then use it in cross-join with the select statement as:select a.Reg_no, b.subjectfrom table1 a ...
1823 May 2008 @ 05:30 PDTToolsReplyERROR ~ [Teradata DBMS] : Response limit exceeded.After trying Wale's solution if the problem persists, do try by closing all the requests as soon as possible before sending new requests.Regards,Adeel
1723 May 2008 @ 05:19 PDTToolsReplyERROR ~ [Teradata DBMS] : Response limit exceeded.Hello,What sort of query you execute when this error is generated?Regards,Adeel
1623 May 2008 @ 02:17 PDTDatabaseReplymulti partititon optionHello,Can you please provide some more details...like multi-partition of?Are you talking about PPI?Regards,Adeel
1523 May 2008 @ 12:41 PDTDatabaseReplyCursors in teradataHello,You need to have a loop to do this, following is the example:DECLARE Var_EmployeeID INTEGER;DECLARE VarCount INTEGER;DECLARE Cur1 CURSOR FORSELECT Employee_ID FROM Table1 FOR READ ONLY;SELECT...
1422 May 2008 @ 12:06 PDTDatabaseReplyDifference between a TDPID and a USERIDHello,Usually it is the IP of the server machine e.g:Suppose your Teradata server is at 1.1.1.1 then you will use ".LOGON 1.1.1.1/username, password".But if you are on the Teradata server machine, ...
1322 May 2008 @ 07:52 PDTDatabaseReplyTransient JournalAs in first reply, whenever you issue INSERT command on any table, after its completion i.e. after inserting the new row in the table, Teradata automatically stores its ROW-ID in transient journal,...
1222 May 2008 @ 07:33 PDTDatabaseReplyTransient JournalNo, TJ does store information about all INSERTs, UPDATEs and DELETEs regardless of the form of these statements. But for Fastload/MultiLoad.Fastload/Multiload uses seperate mechanism, they dont us...
1122 May 2008 @ 07:18 PDTDatabaseReplyTransient JournalAdditionally, just for info, TRANSIENT JOURNAL has nothing to do with Fastload/Multiload.Regards,Adeel
1022 May 2008 @ 07:15 PDTDatabaseReplyTransient JournalHello,Yes it does, regard-less of the table being empty or not, after each update it stores ROW-ID of that inserted row, if the transaction fails it deletes the inserted row.Regards,Adeel
922 May 2008 @ 06:33 PDTDatabaseReplyDoes teradata support LeftB functionHello,For that i guess your best option will be to write a UDF for this functionality.Regards,Adeel
822 May 2008 @ 02:54 PDTDatabaseReplyTeradata QueryHello,For that perhaps you can use "COALESCE(enter_gate, enter_sequence)".HTH!Regards,Adeel
721 May 2008 @ 08:24 PDTDatabaseReplyStored procedure in teradataTeradata SPs and UDFs require C/C++ compiler to compile. It will best work with Visual C ++ 6.Regards,Adeel
621 May 2008 @ 08:20 PDTUDAReplyCOUNT and GROUP BY Stmt when SELECT returns zero.SQLCODE as 1 is the indicator for a "warning but successful termination"...HTH!Regards,Adeel
521 May 2008 @ 08:06 PDTDatabaseReplyHow to Pass Database Name & Table Name as Input Parameter to Stored ProcedureYou can use dynamic sql to do this and dump the output variable in some VT table, and after executing dynamic sql, you can get the return value from that table and return it.Regards,Adeel
421 May 2008 @ 08:04 PDTDatabaseReplyTotalCpuTime and response timeNo, because the task/query may require 0.001 micro seconds of a CPU time but may have to wait for 1 second before getting that CPU time, there surely is a difference between the two!Regards,Adeel
321 May 2008 @ 08:01 PDTDatabaseReplyHow to read log file.Hello,Was query logging enabled when this happened?Regards,Adeel
221 May 2008 @ 07:23 PDTConnectivityReplyCreate UDFHello,Following is the sample UDF code file, save it as "udfvarchartest.c":#define SQL_TEXT Latin_Text#include "sqltypes_td.h"void udfvarchartest( VARCHAR_LATIN *var_in_varchar1, VARCHAR_LATIN *var...
121 May 2008 @ 06:11 PDTConnectivityReplyCalling BTEQ script from a .NET ApplicationHello,Have a look at "System.Diagnostics.Process" class in .NET. Using that you can run BTEQ and pass arguments to it, or you can directly run "BTEQ < scriptname.btq".Regards,Adeel

Pages