59242 | 18 Aug 2016 @ 05:24 PDT | prateek.bansal07 | Tools | Reply | Getting 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?/... |
59241 | 18 Aug 2016 @ 05:20 PDT | padhia | Teradata Database on VMWare | Reply | How to change i.p of a TD VM Image | It 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... |
59240 | 18 Aug 2016 @ 03:56 PDT | bhushan.koli | Tools | Reply | SQL Assistant v.15.00 Keyboard Shortcut problems - Comment | These 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... |
59239 | 18 Aug 2016 @ 03:56 PDT | CarlosAL | Database | Reply | Teradata Query-URGENT | Hi Dieter.
I'm afraid the mode I fall into is much less polite than yours... ;-)
Cheers.
Carlos.
|
59238 | 18 Aug 2016 @ 03:23 PDT | dnoeth | Database | Reply | Teradata Query-URGENT | Whenever I read URGENT I tend to fall into tranquilo, mañana mode :-)
QUALIFY ROW_NUMBER() OVER (PATTITION whatever ORDER BY whatever) = 1
|
59237 | 18 Aug 2016 @ 03:21 PDT | bhushan.koli | Database | Topic | Use teradata with jmeter | How to use jmeter with teradata to get performance stat?
|
59236 | 18 Aug 2016 @ 03:15 PDT | dnoeth | Database | Reply | SQL Error on 'Create Table' in Terdata SQL Assistant | Simply read the error message:
CREATE TABLE Failed. [3707] Syntax error, expected something like a 'LOG' keyword or a 'QUEUE' keyword between ',' and the 'CHEC... |
59235 | 18 Aug 2016 @ 03:10 PDT | dnoeth | Teradata Debugger | Reply | Fetching 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'... |
59234 | 18 Aug 2016 @ 03:03 PDT | dnoeth | Teradata Database on VMWare | Reply | How to change i.p of a TD VM Image | It'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.
|
59233 | 18 Aug 2016 @ 02:34 PDT | RevathiS | Teradata Debugger | Topic | Fetching 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... |
59232 | 18 Aug 2016 @ 01:17 PDT | Kishor_SN | Aster | Reply | Visualizing an nTree | Is there a possibility to use Sankey or Tree visualization uisng a nTree function?
|
59231 | 18 Aug 2016 @ 01:08 PDT | loveysaxena | Teradata Database on VMWare | Reply | How to change i.p of a TD VM Image | Has 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.
|
59230 | 18 Aug 2016 @ 01:06 PDT | loveysaxena | Teradata Database on VMWare | Reply | How to change i.p of a TD VM Image | Hi 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... |
59229 | 18 Aug 2016 @ 12:22 PDT | Kuldeepg92 | Database | Topic | Teradata Query-URGENT | There 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... |
59228 | 17 Aug 2016 @ 11:59 PDT | jasonmoore2k | Connectivity | Topic | Teradata JDBC Driver returns the wrong schema / column nullability | I'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... |
59227 | 17 Aug 2016 @ 09:35 PDT | au185006 | Teradata Database on AWS | Reply | I 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... |
59226 | 17 Aug 2016 @ 09:27 PDT | NetFx | Connectivity | Reply | Teradata Client 15.0 to 15.11 for c# dot.net builds | Right 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... |
59225 | 17 Aug 2016 @ 08:56 PDT | Fred | Connectivity | Reply | Connecting 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... |
59224 | 17 Aug 2016 @ 08:49 PDT | Fred | Tools | Reply | Getting 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... |
59223 | 17 Aug 2016 @ 08:32 PDT | Fred | Database | Reply | Declaring variables in Terdata SQL Assistant | This is a DB2 question and not Teradata or even SQL Assistant. Is DECLARE VARIABLE even supported via ODBC?
|
59222 | 17 Aug 2016 @ 08:20 PDT | dhg | Teradata Database on AWS | Reply | I 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... |
59221 | 17 Aug 2016 @ 08:18 PDT | fgrimmer | Teradata Studio | Reply | Parameterized 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 ... |
59220 | 17 Aug 2016 @ 04:15 PDT | flash7gordon | Connectivity | Reply | Teradata Client 15.0 to 15.11 for c# dot.net builds | error message also said "Version =15.11.0.0"
|
59219 | 17 Aug 2016 @ 04:13 PDT | flash7gordon | Connectivity | Topic | Teradata Client 15.0 to 15.11 for c# dot.net builds | Hi, 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 ... |
59218 | 17 Aug 2016 @ 02:16 PDT | ap0167 | Database | Topic | SQL 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
... |