#DateForumTypeThreadPost
21224 May 2012 @ 12:59 PDTConnectivityReplyWhy is TeraData JDBC complaining about these parameters? Hi. I'm not an expert in java/JDBC but : The single quotes are considered LITERALS. You need to construct the string with concatenations. Something like String sql = "SE...
21124 May 2012 @ 12:48 PDTDatabaseReplyIssue with DAYOFWEEK in a Teradata Procedure DAYOFWEEK is an ODBC extension (thus works in SQLA), but not a Teradata Function (well... pre 14.0 ;-) ). You can find an example of how calculate the DAY OF WEEK here: http://carlosal.w...
21023 May 2012 @ 12:08 PDTDatabaseReplySAS SQL Create Table & Group by problem when querying a Teradata DB. Hi. The part "AS …WITH (NO) DATA (AND STATISTICS)" is missing in your code. Refer to the docs to look up the correct syntax for CREATE TABLE AS. Cheers. Carlos.
20921 May 2012 @ 04:06 PDTDatabaseReplyCollect stats on column vs on index Hi. There is no difference, but you could use the INDEX clause with your named indexes instead of their columns: COLLECT STATISTICS ON DB1.TBL1 INDEX PMY_idx; COLLECT STATISTICS ON DB1...
20813 May 2012 @ 11:58 PDTDatabaseReply"bteq << !@! > $LOGFILE 2> $LOGFILE" in the shell script Hi. If it's in a shell script then it is a so-called 'here document' (and you should find '!@!' some lines below). HTH. Cheers. Carlos.
20708 May 2012 @ 12:47 PDTToolsReplyWhy is Work Table present in mload and not in fload? Hi. Worktables are used as intermediate storage (Aquisition & Application). In fastload the target tables must be empty -no need for intermediate storage-, whereas multiload loads non-em...
20627 Apr 2012 @ 12:08 PDTAnalyticsReplyQuery with FORMAT'$$$,$$9.99' Not displaying $ as expected. Hi:  BTEQ -- Enter your SQL request or BTEQ command: select 1 (format 'G$$$$9D99');  *** Query completed. One row found. One column returned.  *** Total el...
20526 Apr 2012 @ 11:56 PDTDatabaseReplyChange all periods "." in a column to forward slash "/" >>"thoughts on resolving this?" Yes: Sanitize your data. I tried to give you a hint with the (little) info you provided in the first post, not to solve all your problems....
20426 Apr 2012 @ 08:45 PDTDatabaseReplyChange all periods "." in a column to forward slash "/" Hi: You could substitute the 'PARTS' and 'SEPS' (as I said, it was only for 'academic' purposes) with their expressions. On the other hand, you could always use the q...
20326 Apr 2012 @ 06:26 PDTDatabaseReplyChange all periods "." in a column to forward slash "/" It does not matter what the length is, it will work as long as there are three separators/four parts (I followed the format you provided):   SELECT ACC ORIGINAL,    ...
20226 Apr 2012 @ 01:54 PDTDatabaseReplyChange all periods "." in a column to forward slash "/" Sorry for jumping in. If you cannot use oReplace maybe some approach like this may help you:    BTEQ -- Enter your SQL request or BTEQ command: SELECT ACC ORIGINAL, &nb...
20117 Apr 2012 @ 07:06 PDTDatabaseReplydbtimezone in teradata If you mean 'database' as 'user', you can SELECT TimeZoneHour, TimeZoneMinute FROM DBC.USERS; If you mean 'database' as 'system' you can: dbscontrol -...
20017 Apr 2012 @ 06:46 PDTGeneralReplySpace occupied by NULL values in Varchar columns No, it isn't. Nulls VARCHARs don't take space (presence and offset bytes apart). Cheers. Carlos.
19916 Apr 2012 @ 06:03 PDTDatabaseReplyReference Index -- How It Work It's the system generated error table. It will collect the rows that break the referential integrity. You should take a look at SQL Data Definition Language - Detailed Topics. "ALTE...
19816 Apr 2012 @ 12:02 PDTDatabaseReplyHow to display each row in a table into multiple times Take a look at 'WITH RECURSIVE' in the docco. 'connect by' is a proprietary Oracle syntax. The WITH RECURSIVE is the ANSI syntax, which is used from Oracle 11gR2 onwards, btw...
19712 Apr 2012 @ 08:23 PDTDatabaseReplyFASTLOAD WITH FIXED WIDTH FILES Dieter: +1 (and LOL!)   Adeel: "we have plan to shift our data from oracle to teradata but it seems to be very difficult becoz there is very fewer help on web." ...
19604 Apr 2012 @ 12:08 PDTDatabaseReplycollect stats Yup, Dieter. I just saw it just a minute after I posted the hint! Cheers. Carlos.
19502 Apr 2012 @ 11:43 PDTDatabaseReplycollect stats Hi: Carrie Ballinger explains it much better than I could here:   http://developer.teradata.com/database/articles/statistics-collection-recommendations-for-teradata-12  ...
19428 Mar 2012 @ 01:31 PDTDatabaseReplyError-Illegal usage of identity column on trigger action Try:   REPLACE TRIGGER grm_tmp_db.id_tbl_Ins    AFTER INSERT ON grm_tmp_db.test_trig    REFERENCING NEW AS newrow    FOR EACH ROW    ...
19305 Mar 2012 @ 04:30 PSTTeradata ApplicationsReplyTPT 13.0 is compatible with Windows 7?? Depending on your HW/SW architecture, but I'm pretty sure it's compatible as per excel B0353119110K.xls.   To locate detailed supported-release information: 1 Go t...
19201 Mar 2012 @ 04:12 PSTDatabaseReplyUNION Vs MSR Stalin: >>"In general, inserting into a populated target table will be slower as INSERT SELECT operates on a row-by-row/block-by-block basis." INSERT...SELECT will operat...
19128 Feb 2012 @ 12:30 PSTDatabaseReplydelete xxx rows with teradata Just a few thoughts: Stalin: Not at all. RANK can give you more rows than expected: SELECT * FROM MY_DB.PRUEBA01 ORDER BY 1; *** Query completed. 9 rows found. 2 columns retu...
19022 Feb 2012 @ 11:59 PSTDatabaseReplyBTEQ LOGON timeout Hi: It't the common message for a non reached host: check your connection settings (hosts file) and IP's. Also, check that the DB is up & running (pdestate...) HTH. Cheer...
18910 Feb 2012 @ 12:50 PSTDatabaseReplyUnexpected syntax error 3706 when using CASE IN with timestamp values Greg: Your solution (3) is equivalent to what you're after. Besides that:  BTEQ -- Enter your SQL request or BTEQ command: SELECT CASE WHEN CURRENT_TIMESTAMP(0)  ...
18819 Jan 2012 @ 07:08 PSTGeneralReplyTD Multi language support Karthik: "ALTER TABLE does not support changing the server character set for character data types." (Failure 3558 Cannot alter the specified attribute(s) for) Maybe you...

Pages