All forum activity

#DateUserForumTypeThreadPost
4581631 Oct 2014 @ 12:46 PDTMikeDempseyToolsReplySQL Assistant problemStarting with SQL Assistant 15.0 the option "Submit only the selected query text, when highlighted" now applies to Import also.
4581531 Oct 2014 @ 12:44 PDTMikeDempseyToolsReplySQL Assistant v.15.00 Keyboard Shortcut problems - CommentIn 15.0 Ctrl+D is used to remove Bookmarks while Ctrl+/ is used to toggle comments. The latest efix also allows you to use Toggle Comment to comment the current line when no text is selected. (I...
4581431 Oct 2014 @ 12:40 PDTMikeDempseyToolsReplyBug in SQL Assistant 15.00In 15.0 we changed the shortcut for Toggle Comment to be Ctrl+/. This is more consistant with other apps and allows us to use Ctrl+D to remove (Delete) all bookmarks. Although almost anything can...
4581331 Oct 2014 @ 12:28 PDTMikeDempseyToolsReplyIssues in querying Informix Database using Teradata SQL assistant via ODBCThis was first reported a year or so back. When I traced the application I found that the Microsoft .Net Data Provider for ODBC was specifying a length of 2 for the data buffer when retreieving ch...
4581231 Oct 2014 @ 12:03 PDTMikeDempseyToolsReplyError Starting SQL Assistant v14.10.0.4If this still isn't fixed email me at mike.dempsey@Teradata.com. It is actually a problem with your Windows setup rather than with SQL Assistant, but it is simply a matter of updating your reg...
4581131 Oct 2014 @ 11:58 PDTvbdcbTeradata StudioTopicSQL History Result column maximized and now cannot be resizedI double clicked on the right column header separator for the Results column in the Teradata SQL History - SQL Summary group and now it is off the screen and I cannot resize it back down. The main ...
4581031 Oct 2014 @ 11:56 PDTMikeDempseyToolsReplySQL Assistant FavoritesThey are stored in files called *.syn [for the built in lists] and *.qbs [for lists you create] in the directory: <username>\AppData\Roaming\Teradata\SQL Assistant
4580931 Oct 2014 @ 11:52 PDTMikeDempseyToolsReplySQL Assistant key not found errorI vaguely remember fixing this a long time ago but without the detail from SQLError.txt I can't remember which efix it was in.  The latest version should contain the fix however, so downl...
4580831 Oct 2014 @ 10:53 PDTfeinholzToolsReplyTPT load failure - Please suggestYes.
4580731 Oct 2014 @ 10:46 PDTpyiteToolsReplyTPT load failure - Please suggestThanks Steve, really appreciate it. So just to be clear, despite using the MS driver, the issue is fixed in 02?
4580631 Oct 2014 @ 10:44 PDTdlaytenGeneralTopicConverting varchar to timestampAll I have a table that stores the timestamp in this format hhmmss000000 so for example it the field might have 142750261904 this equates to 14:27:50.261904. How can I write a query to convert tha...
4580531 Oct 2014 @ 10:24 PDTfeinholzToolsReplyTPT load failure - Please suggestTalk to your account rep about the download site. This issue is specific to using the Microsoft SQLServer driver. (If you had used the DataDirect driver, you would not have seen this problem.) T...
4580431 Oct 2014 @ 09:14 PDTescuetaTeradata StudioTopicNeed help with Java Version:I installed Teradata Studio and I have Java jre6, jre7 and jre1.8. When I installed it, I changed the java to jre6. When I ran it I get an error, error window pops up:   JAva was started but...
4580331 Oct 2014 @ 08:37 PDTulrichDatabaseReplySize of a data type : check dbc.columns but this holds only the info for data types in use. only other source I am aware of is the documentation...  
4580231 Oct 2014 @ 08:34 PDTChandanDatabaseReplyHow to limit rows to only those where there are duplicates of a specific column?Hi Dieter, There is slight change in requirement. I have below scenario:   ACCT    ID        NUM               CODE &...
4580131 Oct 2014 @ 06:27 PDTToddAWalterDatabaseReplyInvalid TimeTM is your column name. You have to insert into DU, your table name. 
4580031 Oct 2014 @ 06:16 PDTbillcoupeToolsReplySQL Assistant key not found errorHas anyone found a solution to this issue?  I've uninstalled SQL Assistant and reinstalled it to no avail.  I suspect the issue is contained to one of the config files.
4579931 Oct 2014 @ 05:57 PDTvincent91ToolsReplySession and Checkpoint consideration in TTUs and TPThow can I manage the number of sessions used by TPT Streams ?   Unlike TPT Load operator, Stand Alone FastLoad or  Stand Alone MultiLoad, we cannot define a session limit for TPT STREAM...
4579831 Oct 2014 @ 05:55 PDTRaja_KTDatabaseReplyError in Merge Statement Check your PI,PPI cols matching http://www.info.teradata.com/htmlpubs/DB_TTU_13_10/index.html#page/General_Reference/B035_1096_109A/Database.05.1885.html
4579731 Oct 2014 @ 05:35 PDTRohit RanjanToolsReplyBTEQ export CSV issueThanks Dieter. As always you are the life saver:)
4579631 Oct 2014 @ 05:04 PDTpyiteToolsReplyTPT load failure - Please suggestThanks. Is there a download link to 15.00.00.02? I just downloaded TPT the other day, and it was version 00. Currently I am using the MS SQL Server driver (trying to get the datadirect driver) -- ...
4579531 Oct 2014 @ 04:42 PDTRaj83DatabaseTopicError in Merge Statement Hi Everyone,   I have created below merge statement in Teradata, but getting error while trying to execute this script.   MERGE INTO  AGG_PART_SALES_TEST_CUBE AS Target_tbl ...
4579431 Oct 2014 @ 04:26 PDTreddyrajendra2014DatabaseTopicSize of a data type : Hi , Can we get size of a data type from database ? for ex : for integer : 4 Bytes   Can we get this info from any dbc tables or any other way ?....   Thanks, Rajendra Reddy
4579331 Oct 2014 @ 04:04 PDTdnoethToolsReplyBTEQ export CSV issueHi Rohit, you must write the column header with a seperate Select: sel 'eno,ename,dno,sal' (TITLE '');  
4579231 Oct 2014 @ 03:17 PDTMiklosDatabaseTopicUsing periods with left outer joinLet's create two simple tables using the same ID column, some attributes (A_CDC and B_CDC) and a date period. CREATE VOLATILE TABLE TEST_A ( ID INTEGER NOT NULL ,A_CDC INTEGER ...

Pages