#DateForumTypeThreadPost
43726 Feb 2016 @ 06:05 PSTConnectivityReplyBteq: Running bteq scripts located at local unix machine from remote linux admin boxHi. It seems it can be done through tunneling (ssh -L ...). HTH. Cheers. Carlos.
43622 Feb 2016 @ 07:24 PSTDatabaseReplyTeradata Express 15.10 without Samples Database?Hi. They stopped including samples db's in version 15. You can copy them from version 14.* (or pre 14) backups. HTH. Cheers. Carlos.
43522 Feb 2016 @ 03:01 PSTDatabaseReplyPerformance of corelated subqueryH. Impact CPU is related to skew. Your correlated subqueries are causing several AMPs work more than others. Cheers. Carlos.
43418 Feb 2016 @ 08:59 PSTDatabaseReplyError compare times  BTEQ -- Enter your SQL request or BTEQ command: SELECT CASE  WHEN CAST('20:00:00' AS TIME) < CAST('16:00:00' AS TIME) THEN 1  ELSE 0  END;  *...
43317 Feb 2016 @ 03:48 PSTDatabaseReplyHow to make an anonymous piece of code to execute it once?Hi. 1. There is no PL/SQL anonymous blocks in TD. 2. You can call SPs as Dieter explained. If the param is INOUT you must provide a value, not a name: CALL F_QUITA_REPES(' Hola ', ' ...
43211 Feb 2016 @ 07:21 PSTDatabaseReplyHow to define an array of varchars in Stored Procedure Language?Hi again. Forgot to mention: You can do it with just one instance of the array:   DECLARE MY_ARRAY1 MY_VARARRAY; SET MY_ARRAY1 = MY_ARRAY1.ARRAY_UPDATE(MY_ARRAY1.ARRAY_GET(3)),2); &...
43111 Feb 2016 @ 06:25 PSTDatabaseReplyHow to define an array of varchars in Stored Procedure Language?Hello. Oracle is Oracle. Teradata is Teradata. As Dieter said, maybe you don't even need them. PL/SQL tends to row-at-a-time programming and overprogramming. In Teradata you cannot modify on...
43011 Feb 2016 @ 01:43 PSTDatabaseReplyHow to define an array of varchars in Stored Procedure Language?Hi. You can define VARRAY types a-la-Oracle: CREATE TYPE The_Type AS VARRAY(n) OF type: CREATE TYPE MY_VARRAY AS VARRAY(10) OF CHARACTER(15);   Oracle can create this VARRAYs on the fly (...
42904 Feb 2016 @ 12:18 PSTDatabaseReplycast date between 2 different data typesHi. Check your data for the column jsdate. It seems you may have INTEGERs that don't correspond to licit DATEs. HTH. Cheers. Carlos.
42803 Feb 2016 @ 07:51 PSTGeneralReplyUnicode (German) characters are not getting displayed properly in Teradata SQL Assistant Hi. It seems you've loaded UTF8 chars in a LATIN column. The glibberish symbols correspond to the UTF8 code for your 'ü'. What I guess is happening is that you are using a telnet...
42703 Feb 2016 @ 07:36 PSTDatabaseReplycast date between 2 different data typesHi. You need to cast your INTEGER/DECIMAL data to DATE first:   SELECT CAST(CAST(The_Int_Col AS CHAR(8)) AS DATE FORMAT 'YYYYMMDD') The_Date_Col FROM (SELECT 20160203 The_Int_C...
42603 Feb 2016 @ 04:20 PSTDatabaseReplyLogon credentials in BTEQ script not workingHi. In bteq "interactive mode" you cannot .LOGON with the password appended to the username with a comma. It only works this way in "batch mode". You must provide the DBCop/Us...
42515 Jan 2016 @ 12:16 PSTAnalyticsReplySingle row to multiple rowHi. I think you'd better try with STRTOK_SPLIT_TO_TABLE(). HTH. Cheers. Carlos.
42430 Dec 2015 @ 12:24 PSTDatabaseReplyHow could Cylinder index scan achieve the "select count(*) from table X" ?Hi. The Cylinder Index contains: The Subtable Reference Descriptors (they have the Table ID and the range of Data Block Descriptors). The Data Block Descriptors have the Row count (a data block ...
42314 Dec 2015 @ 12:44 PSTToolsReplyI'm new to BTEQ, trying to execute in batch mode via .bat fileHi. There are 'lower than' ("<") and 'greater than' (">") signs missing in your call to bteq:   bteq < test_it.txt > custlog.log 2>&a...
42211 Dec 2015 @ 08:12 PSTTeradata ApplicationsReplyactivate Nontemporal operations with DBS CONTROL or Teradata AdministratorHi Fabrizio. You can find it for yourself: (better as root): find / -name dbscontrol I find it easier to work with dbscontrol from xdbw, but you can use it from the command line too. The field ...
42104 Dec 2015 @ 03:45 PSTConnectivityReplyConnecting to a VM from a completely separate hostVincent: The port redirection feature for NAT can be used in the Virtual Network Editor. If you are using the VMWare Player (or its new name "Workstation Player") then there is no Virtu...
42001 Dec 2015 @ 08:19 PSTConnectivityReplyConnecting to a VM from a completely separate hostVincent: If your VM was 'bridged' you should have provided an IP address (fixed, no DHCP) in your LAN for it and you should have configured the virtual network card within the VM (IP addre...
41901 Dec 2015 @ 04:25 PSTConnectivityReplyConnecting to a VM from a completely separate hostHi: You have two main options: 1.- Change the VM machine Network Adapter to 'bridged'. This will make the V Machine visible within your network. 2.- Use the port redirection feature of t...
41830 Nov 2015 @ 02:41 PSTDatabaseReplyviews getting created even though underlying select has syntax errorHi. There is not syntax error: you are giving the column 'errortext' the name (title) sessionid. Cheers. Carlos.
41726 Nov 2015 @ 04:15 PSTToolsReplyFast load IssueFred: Yup. Of course you're right. I overlooked the ERRORFILES part. Cheers. Carlos.
41625 Nov 2015 @ 12:36 PSTToolsReplyFast load IssueHi. Commas missing after field definitions in the DEFINE section. HTH Cheers. Carlos.
41523 Nov 2015 @ 06:23 PSTDatabaseReplySQL - DateHi.   SELECT CAST(CAST(MY_COL AS DATE FORMAT 'YYYYMM') AS FORMAT 'YYYY-MM-DD') FDOM, ADD_MONTHS(FDOM, 1 ) - 1 LDOM FROM ( SELECT '201511' MY_COL ) a ...
41410 Nov 2015 @ 01:25 PSTDatabaseReplyIssue with Trigger definitionHi. What is your session mode (ANSI/TD)? Cheers. Carlos.
41310 Nov 2015 @ 01:19 PSTDatabaseReplytimestamp am/pmHi. You cannot use '00' hours with AM/PM times. You must use: SELECT CAST('12'||':'||'45'||' '||'AM' AS TIME(0) FORMAT 'hh:mibT'); HTH. ...

Pages