#DateForumTypeThreadPost
4103 Oct 2014 @ 12:30 PDTDatabaseReplyVariables In Custom SQL BlockYes please post the the table definition or more importantly the partioning definition. Did you try creating a volatile table with the values and then joining to it? Also you should be able to retr...
4003 Oct 2014 @ 10:12 PDTGeneralReplyAPPENDING A DYNAMIC VALUE ON A TABLE IN INSERT STATEMENT IN STORED PROCEDUREYes it is a limitation. You can't do that with an inline sql statement. There are some different ways to handle dynamic sql. Do you have the stored procedures and embedded SQL manual? You can...
3903 Oct 2014 @ 09:30 PDTGeneralReplyQuestion Regarding Stored ProcedureHere is a revison that would improve it a bit and maintain your first parm: REPLACE PROCEDURE BLI_CheckForUserTable (IN d_name VARCHAR(64), IN t_name VARCHAR(64), IN vt_name VAR...
3803 Oct 2014 @ 08:49 PDTDatabaseReplyVariables In Custom SQL BlockSorry you did point that out you were using pearl. What version of Teradata are you using? I tested a similiar construct on teradata 14.0 and it DID use partition elimination. Please post your tabl...
3702 Oct 2014 @ 03:49 PDTDatabaseReplyVariables In Custom SQL Block  This may be a little clearer. WITH min_val(val_dt) AS (SELECT CAST(val_dt AS DATE FORMAT 'MM/DD/YYYY') FROM custom_vars WHERE name = 'v_min_p_val' ), max_val(val_dt)...
3602 Oct 2014 @ 03:44 PDTDatabaseReplyVariables In Custom SQL BlockThis should work. Put your parms in a derived table.  INSERT xyz SELECT DISTINCT p_val FROM abc c, def b, (SELECT * (SELECT CAST(val_dt AS DATE FORMAT 'MM/DD/YYYY') AS val...
3502 Oct 2014 @ 02:54 PDTDatabaseReplyIDLE sessions IMPACTHere is your answer. Subj: Re: An Idle question From: Walter, Todd A There is no resource impact on Teradata if the sessions are truly idle. No tasks are held. Minimal memory is used ...
3402 Oct 2014 @ 02:45 PDTDatabaseReplyCreating Header,Detail and Trailer records from one SQL statement If you really wanted to use a union all you could. You would just have to convert everything to a long varchar concatenating things together. You could also just run three different processes expo...
3302 Oct 2014 @ 02:35 PDTDatabaseReplyExtracting month from date as 'MMM'This is also available.  SELECT TO_CHAR(CURRENT_DATE, 'Mon');
3202 Oct 2014 @ 10:18 PDTDatabaseReplyHow to concatenate a date in three different columns?I'll 2nd that. Dieter is the best. :-) 
3102 Oct 2014 @ 10:11 PDTDatabaseReplySend mail from a stored procedureHere is the user guide: http://www.info.teradata.com/edownload.cfm?itemid=122790011 Check the section "About Alerts in Teradata Database" for more interesting and useful examples.
3002 Oct 2014 @ 10:02 PDTDatabaseReplySend mail from a stored procedureYou have another option provided you have a viewpoint server available and have configured it correctly to send mail which I would assume you do.   INSERT dbcmngr.alertrequest VALUES (...
2902 Oct 2014 @ 09:11 PDTDatabaseReplyPartitioning by a character columnBe careful using hashbucket in partitioning. It can cause issues when upgrading due to different hashmaps. 
2802 Oct 2014 @ 09:03 PDTDatabaseReplyusing COPY from TD13 archiveThis should help. You need the arcmain utility not a copy utility. It is a part of the TTU. http://www.info.teradata.com/edownload.cfm?itemid=082310009
2702 Oct 2014 @ 08:33 PDTDatabaseReplyHow exactly do I fix an error related to 'untranslatable character'This should fix this issue. TRANSLATE( ColumnName USING LATIN_TO_UNICODE WITH ERROR);
2602 Oct 2014 @ 08:15 PDTDatabaseReplyDroping a Global Temporary Table 5337   Drop Table is not allowed due to materialized temporary tables. Explanation: Drop table is only allowed when the target table is not materialized in any other sessions u...
2502 Oct 2014 @ 08:14 PDTDatabaseReplyAborting a Stored ProcedureIt should be. Just check view point or check to see if the session is still active using a query like below.   SELECT * FROM TABLE (MonitorSession(-1,'*',0)) AS t2
2402 Oct 2014 @ 08:10 PDTDatabaseReplyHow to concatenate a date in three different columns? Here is one way of doing it:   SELECT (Yr (FORMAT '9(4)') (CHAR(4)))||'-'|| (Mth (FORMAT '9(2)') (CHAR(2)))||'-'|| (Dy (FORMAT '9(2)') (CHAR(...
2301 Oct 2014 @ 03:27 PDTConnectivityReplyExcel VBA alternative to Fastload / batch insertIf I had to absolutely do this in excel I'd script it to write the file in a delimited format and then launch tpt to load it.  -Fred
2201 Oct 2014 @ 02:43 PDTTeradata ApplicationsReplyFastLoad process hang with concurrent sessions Thats good info. Concurrency of 5 is fairly low. If you aren't having the problem on another machine then I think we can be fairly certain its localized to your "Windows 2012 R2". The...
2101 Oct 2014 @ 10:36 PDTToolsReplyTSETHave you looked at the user guide?   http://www.info.teradata.com/edownload.cfm?itemid=110590031
2030 Sep 2014 @ 02:47 PDTToolsReplySeeking Advice On Low Latency (Near Real Time) Loads using TPT and CDCThen you should be good then. You could possibly improve performance through elimination of the landing of the data. Below is a link you can look at which shows a TPT only example. I personally pre...
1930 Sep 2014 @ 01:57 PDTToolsReplySeeking Advice On Low Latency (Near Real Time) Loads using TPT and CDCSome questions: How long has the existing CDC process been in place? Is it home grown? Was Teradata engaged to tune or architect it? The reason I'm asking is I know of a client that uses a sim...
1830 Sep 2014 @ 01:26 PDTDatabaseReplyDynamic value for SAMPLE RANDOMIZED ALLOCATIONYou should look at this -> http://forums.teradata.com/forum/database/getting-a-dynamic-sample
1730 Sep 2014 @ 01:23 PDTDatabaseReplyDynamic value for SAMPLE RANDOMIZED ALLOCATIONI don't believe that is possible. I tried several options but no dice.

Pages