All forum activity

#DateUserForumTypeThreadPost
5919116 Aug 2016 @ 05:28 PDTkrishna1985DatabaseReplySQL query needed---UrgentThanks all :) I wil try both codes...Nice to have SQL gurus....:) world lack them
5919016 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...
5918916 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.  
5918816 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...
5918716 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...
5918616 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...
5918516 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...
5918416 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...
5918316 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 ...
5918216 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)...
5918116 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...
5918016 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...
5917916 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'.
5917816 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...
5917716 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...
5917616 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...
5917516 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...
5917416 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?
5917316 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...
5917216 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...
5917116 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...
5917016 Aug 2016 @ 12:51 PDTseven11ToolsReplyARCMAINNote: the CHECKPOINT parameter is a depricated feature and now only really applicable for mainframe based arcmain      
5916916 Aug 2016 @ 12:41 PDTmichael.hoppiDatabaseReplySQL query needed---UrgentHi, there are many ways to get yout answer. There is one: /*given: MONTH         x            ...
5916816 Aug 2016 @ 12:03 PDTsharonnTeradata StudioReplyWhy is the first dynamic result set in a procedure is empty?Thank you 
5916715 Aug 2016 @ 11:47 PDTpinaldbaToolsReplyTPT Wizard 15.10.01.02 64-Bit: error occurred while accessing the logThe error can be avoided by just editing the config file of the tptwizard.properties. It's recomdonned to take the backup of the existing tptwizard.properties file. Edit the path of...

Pages