#DateForumTypeThreadPost
117807 Dec 2011 @ 01:29 PSTDatabaseReplyGot the error "Multiple 'FORMAT' options" when run the SQL from Teradata Document. Both statements work for me. Which TD release and which client are you using? Dieter
117707 Dec 2011 @ 01:25 PSTDatabaseReplyHow to identify which columns included in which index dbc.indexes in not a view, it's a table. Use dbc.indicesV instead. Dieter
117607 Dec 2011 @ 12:40 PSTDatabaseReplyRunning sum It's hard to follow your explanation, but you need to include a missing month in your result set? Are you on TD13.10? There's the new EXPAND ON clause to accomplish that. Diete...
117507 Dec 2011 @ 12:27 PSTExtensibilityReplyREGEXP_LIKE Those Oracle RegExp functions are announced for TD14, so you have to write your own UDF. Dieter
117407 Dec 2011 @ 12:18 PSTDatabaseReplyAltering SET to MULTISET Short answer: No. But don't ask me why it's not possible. Dieter
117307 Dec 2011 @ 12:10 PSTPrivate Forum
117205 Dec 2011 @ 11:58 PSTPrivate Forum
117105 Dec 2011 @ 07:45 PSTDatabaseReplyHow can I call a stored procedure - which has a returning value - within a trigger? WITH seems not to be supported within SPs, you have to write it the old way using a Derived Table: REPLACE PROCEDURE vmtest.p() BEGIN DECLARE var1 INTEGER; SELECT COUNT(*) INTO...
117005 Dec 2011 @ 04:36 PSTDatabaseReplyHow can I call a stored procedure - which has a returning value - within a trigger? I don't think you can do that. How about moving the conditional logic into stdproc or another SP containing a call stdproc? Dieter
116905 Dec 2011 @ 04:31 PSTPrivate Forum
116805 Dec 2011 @ 04:29 PSTDatabaseReplyEnd Dating Previous Relations or sel ... min(End_Dt) over (partition by empid order by start_dt rows between 1 following and 1 following) - 1 as end_dt from tab Dieter
116701 Dec 2011 @ 04:40 PSTDatabaseReplyQuery to find out the table name and the columns of that table associated with a view CF = CHAR CV = VARCHAR I = INTEGER I2 = SMALLINT D = DECIMAL You'll find all possible values in the manuals: SQL Data Definition Language Detailed Topics: HELP COLUMN...
116601 Dec 2011 @ 02:22 PSTDatabaseReplyQuery to find out the table name and the columns of that table associated with a view Explain a HELP TABLE and you'll see it accessing dbc.tvfields. You used HELP TABLE on a view. When a view is created only the column names are resolved and stored within the system table...
116501 Dec 2011 @ 02:10 PSTDatabaseReplyNeed clarification on Parallel Processing means The row which happens to be processed first within that AMP. Dieter
116430 Nov 2011 @ 12:15 PSTDatabaseReplyTimestamp format on teradata retrieval I assume you try it in SQL Assistant: select current_timestamp (format 'YYYYMMDDHHMISS') (char(16)) Dieter
116330 Nov 2011 @ 08:11 PSTDatabaseReplyNot Exists vs Left Join Look at the explain and you'll see that LEFT JOIN creates the result of the join first and then filters for NULLs while NOT EXISTS filters directly while joining. Dieter
116230 Nov 2011 @ 07:42 PSTDatabaseReplyDescribe table Why do you repost that question? I already answered it http://forums.teradata.com/forum/database/query-to-find-out-the-table-name-and-the-columns-of-that-table-associated-with-a-view#com...
116130 Nov 2011 @ 07:40 PSTGeneralReplyComplex view to table You probably don't need stats for tableB. - how long does it take to create tableB? - is tableA empty? - Did you check QueryLog? How long does the insert step take, is it actuall...
116030 Nov 2011 @ 07:35 PSTToolsReplyFASTLOAD - Vartext Data - Error. I don't know :-) If it's a one time load i would remove the BOM, otherwise you should try to fix the process which created the file. Dieter
115930 Nov 2011 @ 06:48 PSTDatabaseReplyQuery to find out the table name and the columns of that table associated with a view SHOW TABLE x HELP TABLE x HELP COLUMN x.* SELECT * FROM dbc.TablesV WHERE DatabaseName = 'y' AND TableName = 'x' Dieter
115830 Nov 2011 @ 06:21 PSTGeneralReplyComplex view to table Do you mean 1/4 of the runtime for the whole insert/select or 1/4 of the time for the actual merge step? TableB might be a SET table (thus already without duplicate rows) and when using the view...
115730 Nov 2011 @ 05:39 PSTToolsReplyFASTLOAD - Vartext Data - Error. Sorry, i ment everything in your DEFINE must be varchar, you already did that. You could remove the FFFE or create a new file and cut&paste the data you posted. Then retry the load. ...
115630 Nov 2011 @ 04:47 PSTToolsReplyFASTLOAD - Vartext Data - Error. When you look at the data in a hex editor you should easily see if it's Unicode data or not. But i just noticed something else: When you're using VARTEXT as input format you have...
115530 Nov 2011 @ 04:08 PSTUDAReply20 Padded in Data Only you can find out whether it's an issue with source data or your ETL tool or whatever. But i still suggest it's stupid to use trailing 0x0 in a CHAR column. Dieter
115430 Nov 2011 @ 04:02 PSTPrivate Forum

Pages