#DateForumTypeThreadPost
112804 Nov 2011 @ 05:01 PDTDatabaseReplyIs "eq" a reserved word? There are old keywords which shouldn't be used anymore but still are reserved, e.g. RETRIEVE (instead of SELECT). And there used to be some 2 or 3 character abbreviations like CT (CREATE...
112721 Oct 2011 @ 03:00 PDTGeneralReplyCast as timestamp As there are only a few different combinations, i used to do it with LIKE: CASE WHEN ts LIKE '____ _______ %' THEN SUBSTRING(ts FROM 1 FOR 4) || '0' || SUBSTRING(ts ...
112619 Oct 2011 @ 03:29 PDTDatabaseReplyCollect column statistics for a single partition There's no stats on a single partition. But instead of collecting all stats on that table you might just recollect some. The table is probably partitioned by date, so just collect on...
112518 Oct 2011 @ 01:21 PDTDatabaseReplyQueryband I don't know what you mean. Could you post where you found anything like that in the manuals? Dieter
112418 Oct 2011 @ 01:18 PDTDatabaseReplyHow to store and display a german umlaut? Hi Joe, you probably just have a display problem, what tool are you using? In SQL Assistant you need to set a font which actually includes Unicode characters, e.g. "Lucida Sans Unicode&...
112312 Oct 2011 @ 05:55 PDTDatabaseReplyRandom record selection in the subquery Just do a cross join of derived tables: INSERT INTO TABLE_A select 1, a.col1, b.col1 from (SEL COL1 FROM TABLE_X SAMPLE 1) as a, (SEL COL1 FROM TABLE_Y SAMPLE 1) as b; Dieter
112207 Oct 2011 @ 12:30 PDTDatabaseReplyMultiple selects in macro There's already 13.11: http://developer.teradata.com/tools/articles/what-s-new-in-teradata-sql-assistant-13-11 I just tried it on: - 13.11.00.02: ok - 13.10.00.06: ok for a .NET ...
112106 Oct 2011 @ 11:27 PDTDatabaseReplyExplain Permissions Hi Chuck, you don't want to hear that answer: -- NO -- , at least for the Explain part This would be a really nice feature, i know that problem, too :-( You could create an enh...
112005 Oct 2011 @ 11:05 PDTDatabaseReplyMultiple selects in macro Hi Brian, you run that macro through SQL Assistant? This issue has been fixed, try to install the latest release. Dieter
111905 Oct 2011 @ 12:12 PDTGeneralReplyProblem with Timestamp in SQL assistant Which release of SQLA? ODBC or .NET connection? Dieter
111805 Oct 2011 @ 12:01 PDTDatabaseReplyExecute Multiple Drop Table Statements in single Procedure In which session mode is your transactionn running? If it's ANSI you must COMMIT each DROP, in BT mode you shouldn't do a BT before calling the SP. Maybe just show your current s...
111704 Oct 2011 @ 11:55 PDTToolsReplySQL help - consecutive nights stay query You probably need to a query calculating a flag based on "date_in = date_out of the previous row". This is quite similar: http://forums.teradata.com/forum/database/how-to-find-the-...
111604 Oct 2011 @ 11:41 PDTDatabaseReplyCharacter Partitioning directly on column (no CASE_N or RANGE_N defined) It would be easier when you showed the CREATE you tried :-) I don't think you can do that without RANGE_N (even on 13.10). This comes close, but will only work for any access using &...
111529 Sep 2011 @ 12:52 PDTDatabaseReplyParsing Help Statistics Output Partition stare stored in dbc.indexes with an IndexType of 'D'. My query should return that info, too. You should check if you're using the latest version from the link above. ...
111427 Sep 2011 @ 07:07 PDTDatabaseReplyExtracting Data From volatile table select * from my_volatile_table? Dieter  
111327 Sep 2011 @ 06:39 PDTDatabaseReplyParsing Help Statistics Output Go to http://www.teradataforum.com/attach.htm and download my stats query to extract that info for all existing stats using a single request   :-) Dieter  
111224 Sep 2011 @ 09:51 PDTDatabaseReplyHow to convert CURRENT_TIMESTAMP into UTC timestamp? Is the column defined as TIMESTAMP or TIMESTAMP WITH TIME ZONE? try cast(current_timestamp as timestamp) Dieter  
111123 Sep 2011 @ 09:25 PDTDatabaseReplyLoad flat file in consecutive order to Teradata Oops, sorry. Now i remember, you have to use a single FastLoad session. Dieter
111023 Sep 2011 @ 08:22 PDTDatabaseReplyAny advice to increase efficiency of my query? The Full Outer Join is probably removed by the optimizer and the SUM might be put in a DerivedTable, but without Explain and some info about PI/partitioning it's hard to tell. Dieter
110923 Sep 2011 @ 08:12 PDTGeneralReplyHelp with COLLECT STATS Collect stats on volatile tables have been added in TD13. All details about statistics can be found in the manuals: SQL Request and Transaction Processing Chapter 2: Query Rewrite and ...
110823 Sep 2011 @ 08:04 PDTDatabaseReplyWhere are system reboots tracked? Restart info should be available via the systemfe.allrestarts macro or filtering for the appropriate event_tags in dbc.software_event_logV. Dieter
110723 Sep 2011 @ 07:58 PDTDatabaseReplyLoad flat file in consecutive order to Teradata Add an IDENTITY column to the target table and load it via Fastload/MLoad. When i tested this a few years ago the number was assigned exactly in input file sequence. I don't think this c...
110619 Sep 2011 @ 11:09 PDTDatabaseReplyusing "case when" statement inside stored procedure It's probably due to the LENGTH function which is not valid Teradatan SQL. The ODBC driver will automatically translate it to CHAR_LENGTH, but only within SELECT statements. So just ...
110517 Sep 2011 @ 01:19 PDTDatabaseReplycollect stats between multiple insert/select You already answered your question :-) Stats are important for evaluating all those possible ways to retrieve the answer set for a complex multi-table query. But how many possible ways e...
110414 Sep 2011 @ 11:27 PDTGeneralReplyORACLE TO TERADATA MIGRATIONYou have to apply the cast/format in your select: ,:FIRST_CREATE_DATE (timestamp(0), format 'dd-mm-yyyy:hh:mi:ss') Dieter

Pages