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... |
59191 | 16 Aug 2016 @ 05:28 PDT | krishna1985 | Database | Reply | SQL query needed---Urgent | Thanks all :) I wil try both codes...Nice to have SQL gurus....:) world lack them
|
59190 | 16 Aug 2016 @ 04:28 PDT | franceszhu | Database | Topic | Caught an error when update GRAPHIC column | I tried to update a GRAPHIC column with suggested GRAPHIC string literal format, but caught errors.
First, I tried the format G'<xxx>' in the value, for example:
upd... |
59189 | 16 Aug 2016 @ 02:04 PDT | feinholz | Tools | Reply | TPT - Instances Vs Sessions | Since you are using templates, you will need to use the template job variable name.
It could be FileReaderMultipleInstances.
To be sure, take a look at the $FILE_READER.txt template file.
|
59188 | 16 Aug 2016 @ 01:21 PDT | alokku55 | Database | Topic | Substitue for Bulk Collect in Teradata | Hi Everyone,
I am currently working in a project where i need to move all database objects from Oracle to Teradata.
In this project, I need to convert all PL/SQL to Teradata compatible co... |
59187 | 16 Aug 2016 @ 01:00 PDT | ssavoye | Tools | Reply | TPT - Instances Vs Sessions | Thanks for responding Steve. I set the jobvars file as such. Am I setting it in the wrong place?
,MultipleReaders = 'yes'
,LoadInstances = 3
,...
,ReaderInstan... |
59186 | 16 Aug 2016 @ 10:24 PDT | tduqu | Tools | Topic | Teradata 14.10 History Window Gone | My history window no longer appears at login and I can't select Show History from view window, the Show History text is greyed out. I can still access SQL history in a database but it is m... |
59185 | 16 Aug 2016 @ 10:02 PDT | dnoeth | Database | Reply | Datatype of a Column of a View | All literals default to Unicode character set, thus the CASE results in a Unicode string.
dbc.ColumnsV returns the ColumnLength as physical size in bytes, for Unicode (CharType=2) you must di... |
59184 | 16 Aug 2016 @ 09:38 PDT | dnoeth | Connectivity | Reply | CLI CONNECTION USING HOSTS NAME INSTEAD OF IP ADDR. - EXTENDED TIME FOR LOGON | You simply add a new line SET TERACLI=1 to the batch file before calling BTEQ.
To modify environment variables on a user/system level, see
http://superuser.com/questions/949560/how-d... |
59183 | 16 Aug 2016 @ 09:27 PDT | tbenard | Teradata Studio | Topic | Parameterized Queries result in error (1095 - cannot call a method on closed connection) | Hello, I am using TDS 15.00.00.201407291521. I have tried both unnamed parameters "?" and named parameters "?\MyParm" however I get the error shown in the subject of this ... |
59182 | 16 Aug 2016 @ 09:13 PDT | dnoeth | Database | Reply | terdata query. | You can assign a row_number sorted by gender and split in two groups.
Assuming you want to pair randomly:
WITH cte AS
(
SELECT
dt.*,
ROW_NUMBER() OVER (ORDER BY gender, id)... |
59181 | 16 Aug 2016 @ 08:57 PDT | sbloomer | Database | Topic | Creating a snapshot from Type 2 behaviour | Hi all
We have a situation where we need to create (in a view) a snapshot from Type 2 dimension behaviour
Lets say we have a record that has is effective from 2016-05-01 to 2016-05-31. I ne... |
59180 | 16 Aug 2016 @ 08:52 PDT | lgscheurich | Database | Topic | Spool space error 2646 collecting statistics | This is a new one for me. When I run the command below, I get a spool error. The table has about 620 million rows in it. Can someone please suggest what I need to do in order to r... |
59179 | 16 Aug 2016 @ 08:41 PDT | feinholz | Tools | Reply | TPT - Instances Vs Sessions | In order to use multiple instances to read from a single file, you must set the MultipleReaders attribute to 'yes'.
|
59178 | 16 Aug 2016 @ 08:22 PDT | Sandy143 | General | Reply | TPT Update operator | Hi Feinholz,
Hope you are doing great. I have tried loading the tables using the tpt tbuild utility to load the data from one machine to another . However while loading i'm using the update op... |
59177 | 16 Aug 2016 @ 08:17 PDT | BRIANH | Connectivity | Reply | CLI CONNECTION USING HOSTS NAME INSTEAD OF IP ADDR. - EXTENDED TIME FOR LOGON | Hi Dieter.... thanks for your response... I'm not familiar with setting an environment variable. Since I'm running BTEQ in Windows 10 in a .BAT file do I send this to BTEQ like 'S... |
59176 | 16 Aug 2016 @ 07:03 PDT | ssavoye | Tools | Reply | TPT - Instances Vs Sessions | Hello,
I have seen a few posts that indicate multiple instances can be used to read from a SINGLE file. I have some rather large files, but the log (below) shows the 2nd and 3rd instances ar... |
59175 | 16 Aug 2016 @ 06:01 PDT | sk8s3i | Database | Reply | SQL query needed---Urgent | Hi Hope this helps.
create table comparedata (
mnth date format 'mmmyy',
x DECIMAL(18,2),
y DECIMAL(18,2)
) primary index (mnth);
INSERT INTO comparedata values ('A... |
59174 | 16 Aug 2016 @ 04:44 PDT | larry_white | Tools | Reply | SSIS Error: The Teradata TPT registry key cannot be opened. | I am having the same issue with SQL 2016. Has there been a resolution?
|
59173 | 16 Aug 2016 @ 02:56 PDT | Irka | Connectivity | Topic | Connection to Presto with Teradata ODBC from Tableau stopped working |
I'm using Tableau 9.3 on a windows server.
I also have Presto for querying over Hive.
Using the Teradata ODBC connector to connect to Presto.
Presto release: 0.147
Hive versi... |
59172 | 16 Aug 2016 @ 02:06 PDT | Kuldeepg92 | Database | Topic | terdata query. | The gender with the minimum number of students should only pair with opposite gender. The remaining students of the opposite gender can pair among themselves.
1. &nb... |
59171 | 16 Aug 2016 @ 01:36 PDT | Karrajan | Database | Topic | Copying Macro one DB Server to another DB with changed Internal Tables wrt to the new DB instance | Hi All,
I need to copy a macro from old DB instance to new DB instance but the objects inside the macro will remain the same as the old DB name but i need to the objects inside the macro t... |
59170 | 16 Aug 2016 @ 12:51 PDT | seven11 | Tools | Reply | ARCMAIN | Note: the CHECKPOINT parameter is a depricated feature and now only really applicable for mainframe based arcmain
|
59169 | 16 Aug 2016 @ 12:41 PDT | michael.hoppi | Database | Reply | SQL query needed---Urgent | Hi, there are many ways to get yout answer.
There is one:
/*given:
MONTH x  ... |
59168 | 16 Aug 2016 @ 12:03 PDT | sharonn | Teradata Studio | Reply | Why is the first dynamic result set in a procedure is empty? | Thank you
|