All forum activity

#DateUserForumTypeThreadPost
5919516 Aug 2016 @ 07:16 PDTmanaswi_patilDatabaseTopicSubstitute 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...
5919416 Aug 2016 @ 05:28 PDTkrishna1985DatabaseReplySQL query needed---UrgentThanks all :) I wil try both codes...Nice to have SQL gurus....:) world lack them
5919316 Aug 2016 @ 04:28 PDTfranceszhuDatabaseTopicCaught 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...
5919216 Aug 2016 @ 02:04 PDTfeinholzToolsReplyTPT - Instances Vs SessionsSince 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.  
5919116 Aug 2016 @ 01:21 PDTalokku55DatabaseTopicSubstitue for Bulk Collect in TeradataHi 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...
5919016 Aug 2016 @ 01:00 PDTssavoyeToolsReplyTPT - Instances Vs SessionsThanks for responding Steve.  I set the jobvars file as such.  Am I setting it in the wrong place? ,MultipleReaders = 'yes' ,LoadInstances     = 3 ,... ,ReaderInstan...
5918916 Aug 2016 @ 10:24 PDTtduquToolsTopicTeradata 14.10 History Window GoneMy 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...
5918816 Aug 2016 @ 10:02 PDTdnoethDatabaseReplyDatatype of a Column of a ViewAll 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...
5918716 Aug 2016 @ 09:38 PDTdnoethConnectivityReplyCLI CONNECTION USING HOSTS NAME INSTEAD OF IP ADDR. - EXTENDED TIME FOR LOGONYou 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...
5918616 Aug 2016 @ 09:27 PDTtbenardTeradata StudioTopicParameterized 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 ...
5918516 Aug 2016 @ 09:13 PDTdnoethDatabaseReplyterdata 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)...
5918416 Aug 2016 @ 08:57 PDTsbloomerDatabaseTopicCreating a snapshot from Type 2 behaviourHi 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...
5918316 Aug 2016 @ 08:52 PDTlgscheurichDatabaseTopicSpool space error 2646 collecting statisticsThis 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...
5918216 Aug 2016 @ 08:41 PDTfeinholzToolsReplyTPT - Instances Vs SessionsIn order to use multiple instances to read from a single file, you must set the MultipleReaders attribute to 'yes'.
5918116 Aug 2016 @ 08:22 PDTSandy143GeneralReplyTPT Update operatorHi 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...
5918016 Aug 2016 @ 08:17 PDTBRIANHConnectivityReplyCLI CONNECTION USING HOSTS NAME INSTEAD OF IP ADDR. - EXTENDED TIME FOR LOGONHi 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...
5917916 Aug 2016 @ 07:03 PDTssavoyeToolsReplyTPT - Instances Vs SessionsHello, 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...
5917816 Aug 2016 @ 06:01 PDTsk8s3iDatabaseReplySQL query needed---UrgentHi 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...
5917716 Aug 2016 @ 04:44 PDTlarry_whiteToolsReplySSIS Error: The Teradata TPT registry key cannot be opened.I am having the same issue with SQL 2016.  Has there been a resolution?
5917616 Aug 2016 @ 02:56 PDTIrkaConnectivityTopicConnection 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...
5917516 Aug 2016 @ 02:06 PDTKuldeepg92DatabaseTopicterdata 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...
5917416 Aug 2016 @ 01:36 PDTKarrajanDatabaseTopicCopying Macro one DB Server to another DB with changed Internal Tables wrt to the new DB instanceHi 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...
5917316 Aug 2016 @ 12:51 PDTseven11ToolsReplyARCMAINNote: the CHECKPOINT parameter is a depricated feature and now only really applicable for mainframe based arcmain      
5917216 Aug 2016 @ 12:41 PDTmichael.hoppiDatabaseReplySQL query needed---UrgentHi, there are many ways to get yout answer. There is one: /*given: MONTH         x            ...
5917116 Aug 2016 @ 12:03 PDTsharonnTeradata StudioReplyWhy is the first dynamic result set in a procedure is empty?Thank you 

Pages