59216 | 17 Aug 2016 @ 01:26 PDT | prateek.bansal07 | Tools | Topic | Getting export results in same date format as in Teradata table using BTEQ | I am fairly new to Teradata. I have been struggling to get exact format for all the dates in my select query when doing an export using BTEQ.
Here is my script :
/opt/teradata/cl... |
59215 | 17 Aug 2016 @ 07:38 PDT | dnoeth | Database | Reply | terdata query. | @GTeradata:
You probably run an older version of Teradate where you need to add the column list like WITH cte (col1,col2,.., rn, pairs) AS
@Kuldeepg92:
There's no way to avoid p... |
59214 | 17 Aug 2016 @ 05:52 PDT | dnoeth | Teradata Studio | Reply | How to solve the error "Creating connections to local Teradata Database has encountered a problem" ? | There's a link on the download site "how to install and configure Teradata Express for VMware." :-)
http://downloads.teradata.com/node/415
|
59213 | 17 Aug 2016 @ 05:11 PDT | khawar.ameer | Database | Topic | Results differ between query applied on single and query applied on whole branch accounts | Dear All,
Please refer this
ACCOUNT_NUM = 680213
BRANCH_PARTY_ID = 12311
Both ACCOUNT_NUM and BRANCH_PARTY_ID are part of EVENT table.
Account No 680213 is part of branch 12311
I run followin... |
59212 | 17 Aug 2016 @ 04:27 PDT | GTeradata | Database | Reply | terdata query. |
Hi dnoeth/Kuldeep,
I have tried with below query its giving me error as below.
Syntax error: expected something between the word 'cte' and the 'AS' keyword.
... |
59211 | 17 Aug 2016 @ 03:59 PDT | tanmayku | Teradata Studio | Reply | How to solve the error "Creating connections to local Teradata Database has encountered a problem" ? | Hey Mr. Vink,
Thanks a lot, I didn't know that, but it worked. :)
I thought that the database credentials must be same as the OS login creds like in Windows.
|
59210 | 17 Aug 2016 @ 03:54 PDT | Johannes Vink | Teradata Studio | Reply | How to solve the error "Creating connections to local Teradata Database has encountered a problem" ? | The first user on the database is dbc/dbc. Is that what you are looking for?
|
59209 | 17 Aug 2016 @ 03:47 PDT | tanmayku | Teradata Studio | Reply | How to solve the error "Creating connections to local Teradata Database has encountered a problem" ? | Hello dnoeth,
Isn't the default userId and password "root" and "root"?
I entered the same. Or do I first need to create a database on localhost, using the create D... |
59208 | 17 Aug 2016 @ 03:33 PDT | manaswi_patil | Database | Reply | Substitute for "LIKE" in teradata | Hi Dieter,
The condition given by you using REGEXP_SIMILAR worked for me. I was missing out the '.*' part.
i had tried below query which worked for me:
select
cas... |
59207 | 17 Aug 2016 @ 03:12 PDT | dnoeth | Teradata Database on VMWare | Reply | How to change i.p of a TD VM Image | You do the standard (Suse) Linux way:
Computer -> Control Center -> Network Settings -> Edit
|
59206 | 17 Aug 2016 @ 03:09 PDT | dnoeth | Database | Reply | Substitute for "LIKE" in teradata | Standard SQL LIKE only supports _ & %, using ranges is characters is an extension (e.g. SQL Server).
What did you try?
There's no regexp_like in Teradata, but regexp_similar works... |
59205 | 17 Aug 2016 @ 03:04 PDT | dnoeth | Teradata Studio | Reply | How to solve the error "Creating connections to local Teradata Database has encountered a problem" ? | Well, the error message is self-explaining:
The UserId, Password or Account is invalid.
You used a wrong username or password.
|
59204 | 17 Aug 2016 @ 02:20 PDT | punitgupta87 | Connectivity | Topic | Connecting to Oracle | Teradata ODBC Driver is giving an error while I am trying to access tables afer connecting to oracle database from Teradata SQLAssistant.
Error is as :
-------------------------------------... |
59203 | 17 Aug 2016 @ 02:00 PDT | tanmayku | Teradata Studio | Topic | How to solve the error "Creating connections to local Teradata Database has encountered a problem" ? | I'm a new Teradata user. I just installed Teradata Express VM edtion. When I open Teradata Express Studio, I get the error mentioned above in the title.
Further I get following details r... |
59202 | 17 Aug 2016 @ 01:43 PDT | Strickers | Database | Reply | Console user/db | Hi Heps,
What ever happened to this?
Wreyyyyyyy
|
59201 | 17 Aug 2016 @ 12:31 PDT | loveysaxena | Teradata Database on VMWare | Topic | How to change i.p of a TD VM Image | Hi All,
I have a TD VM image of version 15 and i have made a copy of this image i.e. if the original image name is x i have made a copy of it as x_copy.
I have installed VM Workstation an... |
59200 | 17 Aug 2016 @ 12:02 PDT | Kuldeepg92 | Database | Reply | terdata query. | show table RX_WK.INSTRUCTOR_COURSE
INSTRUCTOR_ID INTEGER,
COURSE_ID INTEGER
show table RX_WK.STUDENT_COURSE
STUD_ID INTEGER,
COURSE_ID INTEGE... |
59199 | 16 Aug 2016 @ 11:28 PDT | Kuldeepg92 | Database | Reply | terdata query. | Thank you very much Dieter it is working fine.
Complexity increses within the question .
1. Group shouldn’t be of two people having the s... |
59198 | 16 Aug 2016 @ 10:54 PDT | Johannes Vink | Database | Reply | Creating a snapshot from Type 2 behaviour | I remember that the INTERVAL function could be usefull. This prevents a product join to your calendar dimension. We ended up with making the tables physical for maximum performance and to make it e... |
59197 | 16 Aug 2016 @ 09:26 PDT | Fred | Database | Reply | Spool space error 2646 collecting statistics | The obvious answer is raise the spool space limit, or possibly to use sampled statistics. But another thing to check is whether EDW_CHECKSUM1 is a VARCHAR/VARBYTE field that has been defi... |
59196 | 16 Aug 2016 @ 09:21 PDT | Fred | Database | Reply | Copying Macro one DB Server to another DB with changed Internal Tables wrt to the new DB instance | Macros reference database objects by fully-qualified names, not by internal IDs.
|
59195 | 16 Aug 2016 @ 09:14 PDT | Fred | Tools | Reply | Casting Date in Bteq utilities | Not sure I understand your question at this point. Are you saying that you loaded to a staging table as character, and now you want a SQL expression that will CAST the character string to a Timesta... |
59194 | 16 Aug 2016 @ 09:01 PDT | Fred | Tools | Reply | Fatal Error with TD TPT API | On current releases of TD the number of sessions is limited via TASM/TIWM settings. You can't have more instances than sessions, and you can't have more sessions than workload man... |
59193 | 16 Aug 2016 @ 07:30 PDT | ssavoye | Tools | Reply | TPT - Instances Vs Sessions | Thanks Steve!
It looks like FileReaderMultipleReaders = 'Yes' works.
|
59192 | 16 Aug 2016 @ 07:16 PDT | manaswi_patil | Database | Topic | Substitute for "LIKE" in teradata | Hi All,
Could anyone please help me and suggest a function/ expression/ operator in Teradata to write a query that would return a set of rows which include any single character between 'A-P... |