#DateForumTypeThreadPost
200325 Jun 2013 @ 02:33 PDTDatabaseReplyOne or more values to pass in a prompt When you're  on TD14 you might simply use the strtok_split_to_table function: WHERE P_ID IN ( SELECT CAST(token as INT) FROM TABLE (STRTOK_SPLIT_TO_TABLE(1, #sq(prompt('&...
200225 Jun 2013 @ 02:23 PDTDatabaseReplyUpdating a table through viewHi Mahesh, it's the same a SELECTing from this view, the souce code is resolved by the parser and you actually access the base table: When you EXPLAIN the update you'll notice that the ba...
200125 Jun 2013 @ 02:22 PDTDatabaseReplySelecting count(*) from multiple tablesYou need to do the aggregates within Dervied Tables and then Outer join them: SELECT acct.acc_no, acct.sort_code, COALESCE(credit.cnt, 0) AS credit_count, COALESCE(debit.cnt, 0) ...
200023 Jun 2013 @ 03:26 PDTAnalyticsReplySELECT Failed. 3706: Syntax error: expected something between '(' and the 'select' keyword.Hi Vasudeva, are you the DBA? You should read  CHAPTER 12 Recommended Housekeeping Tasks Cleaning Out Frequently Updated Logs before deleting system logs.   Deleting is ...
199923 Jun 2013 @ 03:08 PDTConnectivityReply.NET Data Provider 12.00.01.00Why do you try to get an even older version of a real old version?   Dieter
199823 Jun 2013 @ 03:06 PDTDatabaseReplyOne or more values to pass in a prompt How is the value for #sq(prompt(''))# filled/created? If it's just plugged in the SQL string by the client, the simply use "(5056,1351)" or "(5001)". If ...
199723 Jun 2013 @ 03:01 PDTDatabaseReplyFastload errorYou should post some more details, DEFINE/SET RECORD/BEGIN LOADING and a part of the log.   Dieter
199623 Jun 2013 @ 02:57 PDTAnalyticsReply3706: Syntax error: expected something between ')' and ','. For derivedIs this the actual query? There's no opening parenthesis for ") as A", simply remove it.   Dieter
199523 Jun 2013 @ 02:53 PDTDatabaseReplyDBQL MetricsTotal = sum of all AMPs CPU/IO usage Max = maximum CPU/IO usage across all indicidual AMPs Skew = Comparing Max with Avg usage. On a parallel system the slowest AMP determines the speed, when the...
199423 Jun 2013 @ 02:24 PDTToolsReplyTPT multiple instances using mainframe host (Syntax error).Hi Vijay, TPT 14 DataConnector supports .zip and .gz files directly, but i don't know if it supports MultipleReaders, probably not.   Dieter
199314 Jun 2013 @ 07:43 PDTDatabaseReplyDetermine number working day between two datesHi Vlad, this can be further simplified, you don't the sys_calendar: SELECT start_date, end_date, end_date-start_date+1 AS period_length, period_length - holiday_days AS working...
199214 Jun 2013 @ 06:24 PDTDatabaseReplyImprove performance of like queries.You might try to rewrite this LIKE using POSITION or SUBSTRING, but it will probably not reduce CPU.   Dieter
199114 Jun 2013 @ 06:14 PDTUDAReplyfastload#1: Yes, but you don't create the error tables, this is done automatically by the tool. You just might change their default names.   #2: MLoad: aquisition phase -> ET-table and appli...
199012 Jun 2013 @ 04:35 PDTExtensibilityReplyTable degeneration and amp data arrangementWhat do you mean by "degeneration"? To check for skewed distribution you'll find some queries in the forum, e.g.: http://forums.teradata.com/forum/database/help-for-stats   D...
198912 Jun 2013 @ 04:23 PDTToolsReplyCS Ram, Pakdisk? Paddisk? Packdisk is a command of the Ferret tool, a command line utility to get information about Teradata's file system. It's fully documented in the Utilities and Database Administration manuals....
198812 Jun 2013 @ 04:13 PDTDatabaseReplyOrder of RANK(yy)Yep, of course, that's what i ment when i wrote "don't use it" ;-)   Dieter
198712 Jun 2013 @ 04:11 PDTDatabaseReplyNULLS are treated as high priority when assigned row numbers with in a groupA Derived Table shouldn't change that, when you sort descending NULLs are sorted last. In your example you ordered by DNAME and all rows had NULL in it, maybe you ment DNO.   For changi...
198612 Jun 2013 @ 04:05 PDTDatabaseReplySpool space issueAsk your DBA to get access to that information, it's vital for development.   Dieter
198512 Jun 2013 @ 04:04 PDTDatabaseReplyBehavior of VARCHAR and COMPRESSed columns in SPOOL#1: false in general, but true when used in GROUP BY/ORDER BY/UNION. Plus the maximum size is considered during FastLoad/MLoad resulting in less row per block sent. For me this is always an in...
198412 Jun 2013 @ 04:00 PDTAnalyticsReplySelect Failed 3706: Syntax error: expected something between the word 'sasnref' and the word 'EXCEPTION'Did you work with DB2 before? EXCEPTION JOIN is no Standard SQL (unless it was recently introduced).   When you need data from the 2nd table you can rewrite it using a LEFT JOIN plus a WHER...
198312 Jun 2013 @ 12:29 PDTDatabaseReplyOrder of RANK(yy)Hi Peter, don't use it, this is deprecated syntax. Teradata implemented some OLAP functions like RANK, MAVG, CSUM in V2R3 before they existed in Standard SQL, but added the ANSI versions in V...
198212 Jun 2013 @ 12:23 PDTDatabaseReplySpool space issueYou need to check dbc.QryLogStepsV (if it's enabled) to find which step failed. It will include all steps successfully completed, so the first missing step run out of spool.   There'...
198112 Jun 2013 @ 12:17 PDTGeneralReplyCASE statementHi Cheeli, of course this could be simplified. All BI tools tend to produce overly complex code :-)   Dieter
198011 Jun 2013 @ 10:59 PDTDatabaseReplyTIMESTAMP(6) WITH TIME ZONE, space between seconds and timezone, need to remove itDealing with "timestamp with time zone" is complicated and the rules how it's casted depend on some dbscontrol settings, too :-) Plus there's a known limitation in ODBC, which do...
197911 Jun 2013 @ 08:55 PDTToolsReplyTDLOAD error RDBMS Warning: 6813 Numeric overflow in internal counters. The number of rows returned is actual number of rows returned, modulo 2^32. 5259745852 MOD 2**32 = 964778556 :-)   Regarding the smaller size, e.g. this might be caused by: - cop...

Pages