#DateForumTypeThreadPost
257803 Feb 2014 @ 07:42 PSTToolsReplyFast Export ErrorIf you read the error message "Enter your logon or BTEQ command" you will notice that you used BTEQ for running this script :-) Try fexp instead.  
257702 Feb 2014 @ 12:54 PSTDatabaseReplyOptimizing Teradata SQL queryHi Hilal, 525 mio rows can't be stored in 10GB :-) When both tables share the same PI there should be no duplication. I would expect the big table's spool is "built locally" and...
257602 Feb 2014 @ 06:35 PSTDatabaseReplyOptimizing Teradata SQL queryHi Hilal, could you share the query? Might be a bad join condition.  
257502 Feb 2014 @ 06:33 PSTDatabaseReplyQuestion regarding FastloadMost data is created by exporting it from a DBMS or any other source and those exports usually add that final EOL. Regarding delimited output: FastExport is an old legacy tool it will probably not...
257402 Feb 2014 @ 04:12 PSTDatabaseReplySQL Workaround@kelvsdotph: I would go with a PI on (A,B) for all three tables, this will result in the fastest possible local Merge Join. If your actually concerned about skew you can do a  SELECT HASHR...
257302 Feb 2014 @ 03:52 PSTDatabaseReplySpace in the databaseA: wrong, most users will have zero Perm Space, this only restricts the possibility to create objects. B: a profile doesn't specify any access rights, even setting spool to zero will still all...
257231 Jan 2014 @ 09:32 PSTGeneralReplyCreate a macro that chooses from teo different select staments depending on a given parameter.Sounds like you want a Stored Procedure, a Teradata macro can't do that. But as a newbie your DBA will probably not grant you the right to create SPs as you can do too many bad things in a SP....
257131 Jan 2014 @ 08:10 PSTDatabaseReplyGenerating Surrogate Key Using ROWNUMA similar thread statred a few days ago: http://forums.teradata.com/forum/database/generate-surrogatekey-with-a-huge-table     Which part of the process is slow? Checking for the MAX...
257031 Jan 2014 @ 08:07 PSTToolsReplyMVC on BYTEINT column Hi Raj, I don't know about the costing algorithm used by Atana, but it's hardlly worth compressing single byte values. Compressing 8 bits to 1 or 2 does not save a lot of disk space. And ...
256931 Jan 2014 @ 08:00 PSTDatabaseReplySql helpIf it actually omits valid combinations i would consider it a bug. But you probably do something in your query to produce that result. Can you share the SQL?
256831 Jan 2014 @ 06:53 PSTDatabaseReplyAutomation - Cycle through lookup= x is not running until activitycount <> 0, it is repeating the previous request x times. When you know about the number of repetititons you can simply repeat that line of code x times...
256730 Jan 2014 @ 09:41 PSTDatabaseReplyQuery OptimisationSQL is not the best tool to do a shortest-path query :-) If you don't start with specific airports you will create all possible combinations (similar to cross joining). And when you add a 3rd/...
256630 Jan 2014 @ 07:34 PSTDatabaseReplyPlease share any possibility approach with automated process for 2500+ Teradata tables. UrgentThis will be a huge project, hopefully they pay you well. If this is actually urgent you should try to get rid of it, it's way too late to ask right here and right now :-) Good luck.
256530 Jan 2014 @ 06:19 PSTDatabaseReplyAggregated Join Index on 2 systemsDid you compare CPU/IO from DBQL on both systems, did the AJI actually use less/run faster? There's a lot of "no confidence" in both explains, did you check for missing stats using D...
256430 Jan 2014 @ 04:56 PSTDatabaseReplyAggregated Join Index on 2 systemsThe stats are freshly collected, but not the same, e.g. step 2.2 (preparation for the join to AJI):    with low confidence to be 16,836 rows  (AJI not used) vs.   &nbs...
256330 Jan 2014 @ 04:46 PSTDatabaseReplySpool space and Temp space allocationsHi Sri, yep, this is correct.
256230 Jan 2014 @ 03:47 PSTDatabaseReplySpool space and Temp space allocationsOn a User level? SELECT TempSpace FROM dbc.UsersV WHERE UserName = USER; Or on a system level? Temp space is similar to spool space, (almost) all currently not used perm space is avai...
256129 Jan 2014 @ 01:13 PSTDatabaseReplyAutomation - Cycle through lookupHi Sri, you can't repeat until activitycount = 0 (in BTEQ, of course you easily can in a SP). If you know about the maximum number of levels in a BTEQ script you could do the SELECT/DELETE as...
256029 Jan 2014 @ 01:04 PSTDatabaseReplyhelp in Transpose rows to columns@Raja: UNPIVOT transforms columns to rows, unfortunately there's no PIVOT function, yet. @KVB: Check my StatsInfo view, ColumnName returns a comma-delimited list. Btw, in TD14 there's a c...
255929 Jan 2014 @ 12:40 PSTDatabaseReplySQL help"trans_year * 12 + trans_month AS trans_ym" calculates a sequential month number to deal with months across two years like nov/dec/jan. "SUM(SUM(amount))": The outer SUM i...
255827 Jan 2014 @ 02:01 PSTDatabaseReplyAutomation - Cycle through lookupI would suggest you better talk to your DBA to get more spool first.   You can't use GOTO to go back within a script. Do you need to run that in a batch or interactively?   What ...
255727 Jan 2014 @ 11:54 PSTDatabaseReplystring with single quotesYou need to double the single quote for the STARTUP and concat the double quote to Sql_String: 'CREATE USER "' || :IN_USER_ID || '" FROM "BUSINESS" AS PERM = 0 ...
255627 Jan 2014 @ 11:42 PSTDatabaseReplyTrouble with FormatFORMAT is only applied when there's a CAST from/to a string. Only for BTEQ REPORTs it's done automatically, for anything else you need to add a CAST to a [VAR]CHAR, most datatypes also wor...
255527 Jan 2014 @ 10:40 PSTDatabaseReplyRANGE in INTEGER data fieldsWhat's the dataype of ampcputime? If it's a string then this CASE will not returning the answer you expect as every value will not get past the first WHEN thus returning 0. And if it'...
255426 Jan 2014 @ 05:10 PSTGeneralReplyusing a calculation done in the previous row in this row's calculationYou need to cast the year to a date CAST((yr*10000) - 19000000 + 101 AS DATE) use this in the Period and finally EXTRACT the year again: SELECT company, newyr, CASE WHEN yr = newyr THE...

Pages