#DateForumTypeThreadPost
46205 May 2016 @ 12:37 PDTDatabaseReplyEXECUTE PROCEDURE access Hi. The INVOKER rights are rights related to the objects accessed by the Store Procedure code. The EXECUTE PROCEDURE is the right to execute the procedure itself. HTH. Cheers. Carlos.
46115 Apr 2016 @ 02:10 PDTDatabaseReplyconvert MM:SS to total secondsHi. Format MM:SSSS is not a valid format for time, MM:SS either.  It should be 'mi:ss'. Cheers. Carlos.    
46013 Apr 2016 @ 10:57 PDTDatabaseReplyConvert varchar to date data typeHi. You could write a SQL UDF that can parse the varchars into dates/nulls using regexp functions, for example. Cheers. Carlos.
45912 Apr 2016 @ 10:45 PDTDatabaseReplyEphoc to teradata timestampHi. CASE cannot give different types. The result type of every condition must be the same. You may use VARCHAR for the two of them. HTH. Cheers. Carlos.
45812 Apr 2016 @ 03:10 PDTDatabaseReplyConvert varchar to date data typeThree words: LEFT OUTER JOIN (with Calendar table). HTH Cheers. Carlos.
45712 Apr 2016 @ 08:16 PDTDatabaseReplyEphoc to teradata timestampHi. There's something wrong with your data: 1454247163111 seconds are more than 4600 years (not a 'real' epoch as seconds since 1970-01-01 00:00:00). If you have milliseconds, then yo...
45606 Apr 2016 @ 10:23 PDTToolsReplyExecute Oracle's stored procedures from tptHi. >>"Is it possible to launch Oracle's stored procedures from tpt? Or doing updates on Oracle's tables from tpt ?" The short answer: NO. The long answer: YES. You will...
45501 Apr 2016 @ 07:59 PDTDatabaseReplyTPT ODBCHi. If you have the TTUs installed you should have "tdxodbc" which is a small app to test ODBC connections. HTH. Cheers. Carlos.
45401 Apr 2016 @ 12:20 PDTDatabaseReplyTPT ODBCHi. Connecting to Oracle through sqlplus (oracle client) doesn't mean anything. Sqlplus doesn't use ODBC.  It seems your ODBC install is wrong somehow ("Fatal error received fro...
45331 Mar 2016 @ 08:30 PDTDatabaseReplyfastload to NOPI table gives skewHi. >>"But difficult to see why only 38 AMPs are compressed" Temperature-based block-level compression perhaps? Cheers. Carlos.
45228 Mar 2016 @ 04:06 PDTDatabaseReplyPK used as USI and not UPIHi. I can't tell. Ask your designer. But Primary Indexes and Primary Keys are two different things. The data distribution and the access to them may advice to choose a PI which is not the PK. ...
45128 Mar 2016 @ 02:54 PDTDatabaseReplyPK used as USI and not UPIHi. Whenever the PK is not implemented as UPI (as explained above), then it's implemented as USI. Cheers. Carlos.
45028 Mar 2016 @ 02:05 PDTDatabaseReplyPK used as USI and not UPIHi. The PK will be implemented as a UPI if no Primary Index is provided in the table definition. Cheers. Carlos.
44923 Mar 2016 @ 04:37 PDTDatabaseReplyStore Negative decimal value into teradata datatypeHi. Beware of certain behaviour of TO_NUMBER():   BTEQ -- Enter your SQL request or BTEQ command: SELECT TO_NUMBER('1,000,000.00'); *** Query completed. One row found. ...
44823 Mar 2016 @ 02:11 PDTGeneralReplyFill Missing Rows With Data SELECT t.sessionID,        t.TheCol,        agr.TheCols   FROM TheTable t,        ( SELECT sessi...
44723 Mar 2016 @ 01:55 PDTGeneralReplySelect data from char position to the nextHi. Try STRTOK('/a/bbb/cc/aaa/ddd','/',2) HTH. Cheers. Carlos.
44623 Mar 2016 @ 01:41 PDTExtensibilityReplyOracle TruncDate UDF - cannot compile truncdate2Hi A shoot in the dark but... It seems that you upgraded the gcc compiler (with the platform upgrade?). gcc 4 compilers are more strict with some programming rules like the ones that are giv...
44509 Mar 2016 @ 07:11 PSTDatabaseReplyLoading SQL Server TimeStamp Varchar to Teradata Table via TPT SELECT CAST(REGEXP_SUBSTR('2/1/2016 11:54:01 AM -06:00', '(?<= )[0-9]{2}:[0-9]{2}:[0-9]{2} [AP]M [+-][0-9]{2}:[0-9]{2}', 1, 1, 'c') AS TIME(0) WITH TIMEZONE FORMAT '...
44409 Mar 2016 @ 06:44 PSTDatabaseReplyAm I Fastloading?Hi. You can have this kind of information in Dbc.DbqLogtbl (LogonSource, AppID, QueryBand, UtiliyRowCount, QueryText...) HTH. Cheers. Carlos.
44309 Mar 2016 @ 03:48 PSTDatabaseReplyLoading SQL Server TimeStamp Varchar to Teradata Table via TPTHI. Your rant is inappropriate. First of all you should have exported the SQL Datetimes in a normalized mode (see ISO 8601), especially if you were going to import them into another, different sys...
44208 Mar 2016 @ 02:09 PSTGeneralReplyRound function in TeradataHi. Teradata types are different from Oracle types (except NUMBER, which is the same). Your problem is the type, not the function. Take a look at the docs regarding datatypes. You'll get the ...
44108 Mar 2016 @ 12:33 PSTGeneralReplyRound function in TeradataHi. 178.22 is a DECIMAL(5,2). You have truncation if you do 178.22/100=1.78. If you want 'Oracle' ROUND(), you can do a simple CAST: SELECT ROUND(CAST(172.22 AS NUMBER)/100,5); HTH. Ch...
44004 Mar 2016 @ 07:13 PSTDatabaseReplyResUsageSAWT Time IntervalHi. Time is time. It's the moment when the information is logged. The period is typically determined by the information in "Secs", "CentiSecs"... HTH. Cheers. Carlos.
43902 Mar 2016 @ 07:43 PSTDatabaseReplyConverting string to date using REGEXP - Getting error 3798Hi. The capturing group will make the expression fail (at least in TD 14, I haven't got any 15x at hand): REGEXP_REPLACE('1925-3-1','\b([0-9])\b', '0\1', 1, 0, 'c&...
43802 Mar 2016 @ 12:37 PSTToolsReplyTransfering data from one server to anotherHi. We the old people used to use arcmain (1 dump + 1 copy) with named pipes to transfer tables from one system to another. HTH. Cheers. Carlos.

Pages