#DateForumTypeThreadPost
9103 Feb 2012 @ 01:23 PSTDatabaseReplyAccessing Row Hash of a record Will not work this way - why don't you join with the PK columns?
9003 Feb 2012 @ 12:15 PSTDatabaseReplyAdding CR/LF to huge datafiles you might try to use a perl script with write append. Didn't test it but the script would be something like    #!/usr/local/bin/perl  open (MYFILE, '>&g...
8902 Feb 2012 @ 08:31 PSTDatabaseReplyFastest way to update a table joining to a huge table If both tables have the same PI Update 1 should be OK. I don't know your processes or if this a one time task. When you build the table 1 can't you set fruit to defaul_fruit?  I...
8802 Feb 2012 @ 07:56 PSTGeneralReplyWelcome to the Teradata Developer Exchange discussion forums! In the documentation - Section Gerneral -> Messages   2689 Field is null for column defined as NOT NULL. Explanation: This error occurs only when the input parcel con...
8702 Feb 2012 @ 07:27 PSTDatabaseReplyoptimizing the Select Query   DON'T SHOUT AT PEOPLE!    And I don't think this will work for the second maximum without derived tables (if it is not simply max -1). Also thi...
8602 Feb 2012 @ 02:27 PSTConnectivityReplyNeed Sql And if you only want the year CURRENT_DATE / 10000 + 1900 CURRENT_DATE / 10000 + 1900 -1
8501 Feb 2012 @ 11:39 PSTToolsReplySpeed up imports in BTEQ or SQL Assistant What is the data volume you want to process? What is your PI on the table? Is is fairly unique? Can you share the table DDL and BTEQ Script?
8401 Feb 2012 @ 11:57 PSTDatabaseReplyoptimizing the Select Query Did you run the query I suggested? I think it will do what you want.  
8301 Feb 2012 @ 06:43 PSTPrivate Forum
8201 Feb 2012 @ 06:03 PSTDatabaseReplyoptimizing the Select Query   I am not sure if I oversimplyfy but isn't this the same?   SEL PGW_IP_ADDRESS,        PDN_CONNECTION_ID,        C...
8101 Feb 2012 @ 05:21 PSTToolsReplyBTEQ Output: Unicode Column wider as defined in DDL or FORMAT Can't say why it is finally the way as it is - maybe someone from TD add some infos.  Personally bet would be currently that you won't find a solution in BTEQ as long as you hav...
8001 Feb 2012 @ 03:38 PSTDatabaseReplyModify a column defination with NOT NULL of a Table funny - seems to be difficult the get ride of the default value never the less alter table [tablename] add columnname DEFAULT NULL; might solve the issue. As the column is define...
7901 Feb 2012 @ 03:21 PSTToolsReplyBTEQ Output: Unicode Column wider as defined in DDL or FORMAT Not sure that I understand your last question - you can check dbc.columns column length should give you the number of bytes needed. CharType is giving you the char type. TD does internal...
7801 Feb 2012 @ 12:23 PSTToolsReplyBTEQ Output: Unicode Column wider as defined in DDL or FORMAT I check it with some real Unicode values (and used only char(2)) in the table definition. select * from uc_test;      *** Query completed. 4 rows found. 2 columns ...
7731 Jan 2012 @ 11:24 PSTDatabaseReplyBTEQ vs Macros   If you use the SP to control the execution of a sequence of SQL I would not expect any performance overhead.  And should also not depend on the frequency the SP is called. Yo...
7631 Jan 2012 @ 07:33 PSTToolsReplyBTEQ Output: Unicode Column wider as defined in DDL or FORMAT don't mix the number characters with the length in bytes which are needed to store this character in latin the ratio is 1:1 in utf8 it is 1:3 So what is your problem with bteq? ...
7530 Jan 2012 @ 12:29 PSTDatabaseReplyBTEQ vs Macros Would agree if this option exists but SP would also need some solid ground work for proper exception handling and good standards to follow, espacially if you use them for more complex pr...
7430 Jan 2012 @ 11:12 PSTExtensibilityReplyWhat is allowed in an SQL UDF? my understanding is that an SQL UDF can contain everything which can be done with a standard SQL which result in a single value output. Think of SQL UDF simple code wrapper which will be rep...
7330 Jan 2012 @ 11:06 PSTDatabaseReplyBTEQ vs Macros I personally prefer BTEQ usually. Your points are all valid. Some to add: "so that they can be easily modified from SQL Assistant only" is indicating not best souce controll ma...
7230 Jan 2012 @ 08:21 PSTConnectivityReplyBTEQ/Fastload CLI Data Transfer Encryption you might find some more infos in the Security Administration Section Appendix A: TDGSS Configuration Files, Valid Settings, and Editing Guidelines Algorithms It looks like some options ...
7130 Jan 2012 @ 05:45 PSTDatabaseReplyUnable to create a Before Trigger I REALLY don't think you should implement this!!!   CREATE TABLE sample_test ( id INTEGER ,name VARCHAR(200) ) unique primary index (id);   &nbs...
7030 Jan 2012 @ 05:19 PSTDatabaseReplyUnable to create a Before Trigger can't understand this.  espacially if you want a change via a website - which means some kind of OLTP processing - you should not use NO PI here as it means always full table scans....
6930 Jan 2012 @ 04:05 PSTDatabaseReplyUnable to create a Before Trigger Do you considered to use a Unique secondary index on name? I am not sure that Trigger are the best way to enforce RI here... Depending of the workload on the table you will face bad perf...
6829 Jan 2012 @ 11:47 PSTDatabaseReplyUnable to create a Before Trigger You posted a rather incomplete question with incomplete information. I have no clue what you want to achive here.
6729 Jan 2012 @ 11:40 PSTDatabaseReplyredistribution or not Not 100% sure that I understand your question.  But assume you have a query Select * from yourTable where col1 = X and col2 = Y where yourTable has a PI on (col1,col2,co...

Pages