#DateForumTypeThreadPost
16205 Dec 2012 @ 10:19 PSTDatabaseReplycorresponding teradata query for a oracle queryTells the ColumnLength...
16102 Dec 2012 @ 12:36 PSTToolsReplyHow to set a defalult width for all of my bteq reports?Kool... Never used this option before... that adds to my knowledge as well. Thanks Dnoeth :)
16002 Dec 2012 @ 12:04 PSTDatabaseReplyHow to find the records having NULL valuesIn my point of view I think thats the only way of finding the records with null value in any of the column i.e. ignoring the columns with not null constraint and checking for the NULL values in the...
15929 Nov 2012 @ 08:21 PSTDatabaseReplySQL ErrorNormally you get this type of error when you are casting a column into non-compatible data types e.g. casting char data into integer or something like that. But without looking at the query it get...
15828 Nov 2012 @ 12:34 PSTDatabaseReplyStored PRocedure to Load Date DimIN_START_DATE is your IN parameter and you are attempting to modify the IN parameter by SET In_Start_Date = cast(current_date as date format 'YYYY-MM-DD') + 1; You can't update the in...
15728 Nov 2012 @ 12:26 PSTDatabaseReplyDetermine which database is up and running or active? If I understand your question correctly then as far as the Teradata nodes are up and running all the databases will be active and up and runnings and users can access the database objects as long a...
15628 Nov 2012 @ 12:20 PSTToolsReplyHow to set a defalult width for all of my bteq reports?I don't think you can set it as a general parameter for BTEQ utility. Just an alternative way would be to write a shell script that should add this line to all the bteq scripts before executin...
15522 Nov 2012 @ 12:48 PSTDatabaseReplySpool ReleaseThe capacity planning section should get you started... www.teradataforum.com/teradata_pdf/b035-1093-061a.pdf
15422 Nov 2012 @ 12:25 PSTDatabaseReplySpool ReleaseYes, I think that should give you a fair idea of how much spool the query will require.
15321 Nov 2012 @ 10:36 PSTDatabaseReplySpool ReleaseSpool falls into three categories: VOLATILE SPOOL - content is retained until * Transaction completes (unless the table was created with  ON COMMIT PRESERVE ROW) * Table is dropped manual...
15221 Nov 2012 @ 10:21 PSTDatabaseReplyprimary index hash value SELECT HASHROW(<<COLUMNLIST>>), COUNT(*) FROM <<TABLENAME>>
15121 Nov 2012 @ 10:10 PSTDatabaseReplyNeed help to avoid spool space errorExplain plan of the query and DDL / Indexes of the table referenced will help in understanding what could be going wrong...
15021 Nov 2012 @ 10:04 PSTAnalyticsReplySQL works fine in Teradata SQL assistant getting error when trying to execute in Tableau custom SQL connectionTry assigning alias names to the first column in your SELECT statement... SEL EXTRACT(MONTH FROM b.date_application_received) || '_' || EXTRACT(YEAR FROM b.date_application_received)...
14921 Nov 2012 @ 02:40 PSTAnalyticsReplyAMPCHECKStraight from the manual... The MultiLoad response to a down AMP condition: . AMPCHECK NONE allows the MultiLoad job to start, restart or continue as long as no more than one AMP is down ...
14820 Nov 2012 @ 07:04 PSTDatabaseReplyCan not use volatile table inside the cursorThis document should help you... http://www.teradataforum.com/teradata_pdf/b035-1148-115a.pdf
14720 Nov 2012 @ 04:57 PSTDatabaseReplyhow to logon to bteqTry sqla on the run window. The SQL Assistant will open if its installed.
14620 Nov 2012 @ 04:09 PSTDatabaseReplyhow to logon to bteqDo you have the Teradata node entries / IP address in your host file?
14520 Nov 2012 @ 04:07 PSTDatabaseReplyhow to logon to bteqNo there is no default user/password in Teradata. You need to get one from your DBA There are two ways to logon; 1. Interactive mode where you can login using command prompt using .LOGON tdpid/us...
14419 Nov 2012 @ 11:12 PSTDatabaseReplyHandling the EMPTY/NULL value in the select queryRead your post couple of time but couldn't understand what exactly you are looking for. I think you need to explain your query with bit more clarity!  
14319 Nov 2012 @ 11:09 PSTDatabaseReplySpool space and Temp space allocationsCan't disagree with Dieter :)
14218 Nov 2012 @ 10:59 PSTDatabaseReplySpool space and Temp space allocationsSpool space is taken from the disk cylinders that are not being used for permanent or temporary data... However the query spooling out needs to be revisited. Explain plan could probably help you o...
14117 Nov 2012 @ 05:43 PSTToolsReplyBTEQ examplesYou can get details on these commands from Teradata BTEQ Reference manual, but in brief these commands can be used for; QUIET - This basically limits BTEQ output (to errors and request processing ...
14017 Nov 2012 @ 02:35 PSTDatabaseReplyOptimal Date selectionThe most reliable way would be to check the EXPLAIN plan of both the queries. But I have seen instances where the joining tables SQL run more efficiently than the subqueries.
13906 Nov 2012 @ 11:45 PSTDatabaseReplyshow view does not show databasename in viewnameTry SHOW SEL * FROM DBC.COLUMNS
13830 Oct 2012 @ 10:02 PDTToolsReplyQueue tabel in Terra Data Queue tables just like the name depicts are used to serialize the custom process using the db capabilities. One process inserts a record signaling the process has been completed and the other proce...

Pages