All forum activity

#DateUserForumTypeThreadPost
5924518 Aug 2016 @ 05:24 PDTprateek.bansal07ToolsReplyGetting export results in same date format as in Teradata table using BTEQ   I tried using SET SESSION DATEFORM=ANSIDATE; to get all date fields in YYYY-mm-dd format but the end result is always yy-MM-dd :(   Is there anything wrong with my shell script?/...
5924418 Aug 2016 @ 05:20 PDTpadhiaTeradata Database on VMWareReplyHow to change i.p of a TD VM ImageIt is strange that you are getting the same IP address assigned to both VM. Teradata VM images use dhcp to obtain IP addresses from VMWare. You may try generating a new MAC address for one of the V...
5924318 Aug 2016 @ 03:56 PDTbhushan.koliToolsReplySQL Assistant v.15.00 Keyboard Shortcut problems - CommentThese are few keyboard shortcuts (Used in only GUI mode On windows/linux)  F2 : It will open QUERY BUILDER, with SYNTAX for all SQL Queries. F5 : Execute SQL Query F6 : Ex...
5924218 Aug 2016 @ 03:56 PDTCarlosALDatabaseReplyTeradata Query-URGENTHi Dieter. I'm afraid the mode I fall into is much less polite than yours... ;-) Cheers. Carlos.
5924118 Aug 2016 @ 03:23 PDTdnoethDatabaseReplyTeradata Query-URGENTWhenever I read URGENT I tend to fall into tranquilo, mañana mode :-)   QUALIFY ROW_NUMBER() OVER (PATTITION whatever ORDER BY whatever) = 1
5924018 Aug 2016 @ 03:21 PDTbhushan.koliDatabaseTopicUse teradata with jmeter How to use jmeter with teradata to get performance stat?
5923918 Aug 2016 @ 03:15 PDTdnoethDatabaseReplySQL Error on 'Create Table' in Terdata SQL AssistantSimply read the error message: CREATE TABLE Failed.  [3707] Syntax error, expected something like a 'LOG' keyword or a 'QUEUE' keyword between ',' and the 'CHEC...
5923818 Aug 2016 @ 03:10 PDTdnoethTeradata DebuggerReplyFetching the last date of the current Quarter !!! Your first calculation doesn't return the current quarter correctly, e.g. in July it will return 2016-04-01 instead of 2016-07-01. -- begin of current quarter trunc(current_date, 'q'...
5923718 Aug 2016 @ 03:03 PDTdnoethTeradata Database on VMWareReplyHow to change i.p of a TD VM ImageIt's Network Settings, not Network Proxy :-) You must modify eth0 (lo = localhost, you can't change that), this is the only entry, listed as Ethernet Network Card.
5923618 Aug 2016 @ 02:34 PDTRevathiSTeradata DebuggerTopicFetching the last date of the current Quarter !!! Fetching the last date of the current Quarter !!!    This query fetches the fist date of the current Quarter-->>select TRUNC(ADD_MONTHS(CURRENT_DATE,-1),'Q'). Need to kno...
5923518 Aug 2016 @ 01:17 PDTKishor_SNAsterReplyVisualizing an nTreeIs there a possibility to use Sankey or Tree visualization uisng a nTree function?
5923418 Aug 2016 @ 01:08 PDTloveysaxenaTeradata Database on VMWareReplyHow to change i.p of a TD VM ImageHas some issues uploading the screen shot of the Manual proxy configuration Writing the fields below HTTP Proxy Secure HHTP Proxy FTP Proxy Socks Host Each one above also asks for Port.
5923318 Aug 2016 @ 01:06 PDTloveysaxenaTeradata Database on VMWareReplyHow to change i.p of a TD VM ImageHi Dieter, Thankyou for your reply. Below is the configuration details of the VM Image whoes i.p which i want to change. When i go the link provided by you i clicked the "Manual proxy confi...
5923218 Aug 2016 @ 12:22 PDTKuldeepg92DatabaseTopicTeradata Query-URGENTThere is table with coulmns: INTL_EMP_ID PRSCT_FILL_ID ACTVTY_TS EMPLYE_NBR EMP_ID   Problem Statement: select INTL_EMP_ID from table for that PRSCT_FILL_ID. order by ACTVTY_TS in asc...
5923117 Aug 2016 @ 11:59 PDTjasonmoore2kConnectivityTopicTeradata JDBC Driver returns the wrong schema / column nullabilityI'm running an Apache Spark application that uses terajdbc4 to fetch data from a Teradata server.  It seems to be returning the wrong value for the nullability for many of the columns in t...
5923017 Aug 2016 @ 09:35 PDTau185006Teradata Database on AWSReplyI cannot logon with bteq or SQL Assistant from my PC to my Teradata Database instance but I can ssh to it, why is that ?  1. You need to change the dbc password by running tdc-start to enable port 1025 which is used by ODBC and CLI connections 2. Also check your inbound ports to make sure you have opene...
5922917 Aug 2016 @ 09:27 PDTNetFxConnectivityReplyTeradata Client 15.0 to 15.11 for c# dot.net buildsRight click on the Reference and select Properties; Is the "Specific Version" set to False?  http://stackoverflow.com/questions/24022134/how-exactly-does-the-specific-version-proper...
5922817 Aug 2016 @ 08:56 PDTFredConnectivityReplyConnecting to Oracle In general, Teradata does not provide drivers to connect to other vendors' databases (such as Oracle). Those drivers must be obtained from the other database vendor or a third party. &nbs...
5922717 Aug 2016 @ 08:49 PDTFredToolsReplyGetting export results in same date format as in Teradata table using BTEQ"Exactly the same format as they are in the Teradata table" would be an internal binary representation; probably not what you really want. BTEQ in FIELDMODE will use the FORMAT asso...
5922617 Aug 2016 @ 08:32 PDTFredDatabaseReplyDeclaring variables in Terdata SQL AssistantThis is a DB2 question and not Teradata or even SQL Assistant. Is DECLARE VARIABLE even supported via ODBC?
5922517 Aug 2016 @ 08:20 PDTdhgTeradata Database on AWSReplyI cannot logon with bteq or SQL Assistant from my PC to my Teradata Database instance but I can ssh to it, why is that ?I'm having the same issue.  I can SSH from my PC.  I can log into the database in the SSH session via bteq.   I also spun up a windows box in my AWS VPC and from there I can...
5922417 Aug 2016 @ 08:18 PDTfgrimmerTeradata StudioReplyParameterized Queries result in error (1095 - cannot call a method on closed connection)Thomas, I am trying to recreate this issue but no luck. Are you running the query on Aster or Teradata Database? Can you try reconnecting the connection profile? Also can you try your query on the ...
5922317 Aug 2016 @ 04:15 PDTflash7gordonConnectivityReplyTeradata Client 15.0 to 15.11 for c# dot.net buildserror message also said "Version =15.11.0.0"
5922217 Aug 2016 @ 04:13 PDTflash7gordonConnectivityTopicTeradata Client 15.0 to 15.11 for c# dot.net buildsHi,   Work for a big company.   Recently we had a forced 15.1 from 15.0 Teradata Client install on our laptops where I do my c# builds.   Everything (builds and runtime) ran fine on ...
5922117 Aug 2016 @ 02:16 PDTap0167DatabaseTopicSQL Error on 'Create Table' in Terdata SQL Assistant why I am getting a syntax error?   create TABLE  ddwp_v.sponsoredm, CHECK = DEFAULT (account VARCHAR(12)  Unique Primary INDEX(account); insert into ddwp_v.sponsoredm ...

Pages