23 | 28 May 2008 @ 04:28 PDT | Database | Reply | Creating Stored Procedures in Batch | Hello,If you are using BTEQ script for batch, you can use ".COMPILE FILE sp1.sql" to compile the SP.Regards,Adeel |
22 | 26 May 2008 @ 07:12 PDT | Database | Reply | Foreign Key | Hello,If you have select rights on DBC, please have a look at all views starting with "RI_".Regards,Adeel |
21 | 25 May 2008 @ 06:51 PDT | Tools | Reply | ERROR ~ [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 ... |
20 | 23 May 2008 @ 06:43 PDT | Database | Reply | Optimize a query containing UNION | Little 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... |
19 | 23 May 2008 @ 06:37 PDT | Database | Reply | Optimize a query containing UNION | Hello,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 ... |
18 | 23 May 2008 @ 05:30 PDT | Tools | Reply | ERROR ~ [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 |
17 | 23 May 2008 @ 05:19 PDT | Tools | Reply | ERROR ~ [Teradata DBMS] : Response limit exceeded. | Hello,What sort of query you execute when this error is generated?Regards,Adeel |
16 | 23 May 2008 @ 02:17 PDT | Database | Reply | multi partititon option | Hello,Can you please provide some more details...like multi-partition of?Are you talking about PPI?Regards,Adeel |
15 | 23 May 2008 @ 12:41 PDT | Database | Reply | Cursors in teradata | Hello,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... |
14 | 22 May 2008 @ 12:06 PDT | Database | Reply | Difference between a TDPID and a USERID | Hello,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, ... |
13 | 22 May 2008 @ 07:52 PDT | Database | Reply | Transient Journal | As 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,... |
12 | 22 May 2008 @ 07:33 PDT | Database | Reply | Transient Journal | No, 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... |
11 | 22 May 2008 @ 07:18 PDT | Database | Reply | Transient Journal | Additionally, just for info, TRANSIENT JOURNAL has nothing to do with Fastload/Multiload.Regards,Adeel |
10 | 22 May 2008 @ 07:15 PDT | Database | Reply | Transient Journal | Hello,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 |
9 | 22 May 2008 @ 06:33 PDT | Database | Reply | Does teradata support LeftB function | Hello,For that i guess your best option will be to write a UDF for this functionality.Regards,Adeel |
8 | 22 May 2008 @ 02:54 PDT | Database | Reply | Teradata Query | Hello,For that perhaps you can use "COALESCE(enter_gate, enter_sequence)".HTH!Regards,Adeel |
7 | 21 May 2008 @ 08:24 PDT | Database | Reply | Stored procedure in teradata | Teradata SPs and UDFs require C/C++ compiler to compile. It will best work with Visual C ++ 6.Regards,Adeel |
6 | 21 May 2008 @ 08:20 PDT | UDA | Reply | COUNT and GROUP BY Stmt when SELECT returns zero. | SQLCODE as 1 is the indicator for a "warning but successful termination"...HTH!Regards,Adeel |
5 | 21 May 2008 @ 08:06 PDT | Database | Reply | How to Pass Database Name & Table Name as Input Parameter to Stored Procedure | You 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 |
4 | 21 May 2008 @ 08:04 PDT | Database | Reply | TotalCpuTime and response time | No, 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 |
3 | 21 May 2008 @ 08:01 PDT | Database | Reply | How to read log file. | Hello,Was query logging enabled when this happened?Regards,Adeel |
2 | 21 May 2008 @ 07:23 PDT | Connectivity | Reply | Create UDF | Hello,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... |
1 | 21 May 2008 @ 06:11 PDT | Connectivity | Reply | Calling BTEQ script from a .NET Application | Hello,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 |