98 | 31 Jul 2008 @ 11:09 PDT | Database | Reply | convert string to date format | Hello,For character dates, you need to specify the format as well.Examples:SELECT CAST('July 22, 2008' AS DATE FORMAT 'MMMMBDD,BYYYY');SELECT CAST ('January 1992' AS DATE FORMAT 'MMMMBYYYY');Please... |
97 | 31 Jul 2008 @ 10:55 PDT | Database | Reply | Using INETERVAL With CASE Statement | Hello,What error you are getting?Regards,Adeel |
96 | 31 Jul 2008 @ 02:59 PDT | Tools | Reply | Help needed in bteq script to load data into a teradata table from an excel sheet | Hello,Few of the possible options can be as follows:- Save excel file as CSV file- Use that file as source in fastload script and load the dataor- Using string functions in excel, create INSERT sta... |
95 | 30 Jul 2008 @ 03:43 PDT | Database | Reply | Integer Vs Varchar in joins - Performance Impact | Hello,It depends on numerous factors such as data, data volume, indexes defined on both tables and type of join used. And logically speaking yes it will affect the performance. And the worst scenar... |
94 | 28 Jul 2008 @ 11:25 PDT | Database | Reply | Calculating no of months between 2 dates | Hello,You can do that using:SELECT CURRENT_DATE - CAST('2008-06-06' AS DATE) MONTH(4);Regards,Adeel |
93 | 28 Jul 2008 @ 11:19 PDT | Database | Reply | how to clean a user's maxperm | Exactly ... Jim Chapman is right ... my bad!! :( |
92 | 28 Jul 2008 @ 11:19 PDT | UDA | Reply | VARCHAR fields | Hello,I seriously doubt if it is a standard practice, and it can degrade the performance as well! If you know your data, I'll suggest you to use data-types accordingly.Regards,Adeel |
91 | 28 Jul 2008 @ 07:28 PDT | Database | Reply | Teradata sql to give the table names when you have given the column names in a database | You can use it as follows:SELECT * FROM DBC.Columns WHERE ColumnName = 'ACC_NO' AND DatabaseName = 'Account';Regards,Adeel |
90 | 28 Jul 2008 @ 07:20 PDT | Database | Reply | Teradata sql to give the table names when you have given the column names in a database | Can you please define the system tables?And do you know the name of database in which you need to search for the column?Regards,Adeel |
89 | 28 Jul 2008 @ 06:05 PDT | Database | Reply | Teradata sql to give the table names when you have given the column names in a database | Well...for that you can filter using DatabaseName...Regards,Adeel |
88 | 28 Jul 2008 @ 05:03 PDT | Database | Reply | udfSubstringIndex function | Hello,This is not a Teradata's built-in function.Regards,Adeel |
87 | 28 Jul 2008 @ 02:18 PDT | Database | Reply | Teradata sql to give the table names when you have given the column names in a database | Hello,You can use DBC.Columns table for that.Regards,Adeel |
86 | 28 Jul 2008 @ 12:47 PDT | Database | Reply | function to separate values from a column which are dot separated into n number of columns | Hello,If the input column contains delimiter (in your example "."), you can write a UDF which takes 2 inputs i.e. Index and Input string and returns a value on that index.Then you can use it as fol... |
85 | 28 Jul 2008 @ 12:43 PDT | Database | Reply | Identity Column Not Coming in a sequence. Need Suggestion. | Hello,Yes, there is no direct/1-to-1 equivalent in Teradata for Oracle sequencers.What you can do, is to write a simple trigger as follows:Suppose we have table definition as follows:CREATE TABLE T... |
84 | 28 Jul 2008 @ 12:34 PDT | Database | Reply | Exporting - without using the "File->Export Results" function | Hello,The following can be done to achieve this:- You need to know the total number of columns you need to export- You can write a UDF, which (if output file doesnot exists, creates it, or append... |
83 | 28 Jul 2008 @ 12:28 PDT | Database | Reply | The installed Teradata Express Database can't be connected | Hello,Have you checked your HOST file? Is Teradata UP & Running?HTH!Regards,Adeel |
82 | 28 Jul 2008 @ 12:20 PDT | Database | Reply | how to clean a user's maxperm | Hello,What is the CurrentPerm for that user?MaxPerm is the maximum perm-space in bytes, ever occupied. It is not the current perm-space!HTH.Regards,Adeel |
81 | 28 Jul 2008 @ 12:18 PDT | Database | Reply | How to read parameters from a table? | Hello,You can use Dynamic SQL in Stored-Procedure for this purpose. You may dump the results in some temporary tables, within dynamic-sql statement.Regards,Adeel |
80 | 28 Jul 2008 @ 12:15 PDT | Connectivity | Reply | updating teradata through asp.net | For that you can use query as follows:cmd.CommandText = "UPDATE "+ txtTableName +" SET "+ txtColumnName +" = "+ numValue +" WHERE ID = 1;";This can cause SQL injection attacks possible, which you c... |
79 | 25 Jul 2008 @ 12:53 PDT | Connectivity | Reply | updating teradata through asp.net | Hello,All you have to do is to change the command text in following:cmd.CommandText = "select Group_Descrip from ExampleDB.ExampleTable";Example:cmd.CommandText = "UPDATE Table1 SET Col1 = 1 WHERE ... |
78 | 23 Jul 2008 @ 11:12 PDT | Database | Reply | Error-Missing/Invalid SQL statement'E(3706):Syntax error | Hello,The best thing you can have for this is, UDF. Alternatively, you can try with EXTRACT and/or INTERVAL.Regards,Adeel |
77 | 23 Jul 2008 @ 11:09 PDT | Analytics | Reply | if and else condition in bteq | Hello,You need to put a dot "." before IF as follows:.IF ACTIVITYCOUNT = 0 THEN .QUIT 65;HTH.Regards,Adeel |
76 | 23 Jul 2008 @ 04:49 PDT | Database | Reply | Dependencies between the tables. | Hello,If you are looking for Referential Integrity (Foreign Key Constraints) or Table Level Constraints, you can surely find related tables/views in DBC.HTH.Regards,Adeel |
75 | 23 Jul 2008 @ 01:36 PDT | Database | Reply | default users | Hello,Usualy they are DBC, SysAdmin and SystemFe.Regards,Adeel |
74 | 23 Jul 2008 @ 01:33 PDT | Database | Reply | track user | Hello,You can use Database Quert Loggin (DBQL) for this purpose.On how to use it, consult manuals.Regards,Adeel |