|45816||31 Oct 2014 @ 12:46 PDT||MikeDempsey||Tools||Reply||SQL Assistant problem||Starting with SQL Assistant 15.0 the option "Submit only the selected query text, when highlighted" now applies to Import also.
|45815||31 Oct 2014 @ 12:44 PDT||MikeDempsey||Tools||Reply||SQL Assistant v.15.00 Keyboard Shortcut problems - Comment||In 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.
|45814||31 Oct 2014 @ 12:40 PDT||MikeDempsey||Tools||Reply||Bug in SQL Assistant 15.00||In 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... |
|45813||31 Oct 2014 @ 12:28 PDT||MikeDempsey||Tools||Reply||Issues in querying Informix Database using Teradata SQL assistant via ODBC||This 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... |
|45812||31 Oct 2014 @ 12:03 PDT||MikeDempsey||Tools||Reply||Error Starting SQL Assistant v18.104.22.168||If 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... |
|45811||31 Oct 2014 @ 11:58 PDT||vbdcb||Teradata Studio||Topic||SQL History Result column maximized and now cannot be resized||I 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 ... |
|45810||31 Oct 2014 @ 11:56 PDT||MikeDempsey||Tools||Reply||SQL Assistant Favorites||They are stored in files called *.syn [for the built in lists] and *.qbs [for lists you create] in the directory:
|45809||31 Oct 2014 @ 11:52 PDT||MikeDempsey||Tools||Reply||SQL Assistant key not found error||I 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... |
|45808||31 Oct 2014 @ 10:53 PDT||feinholz||Tools||Reply||TPT load failure - Please suggest||Yes.
|45807||31 Oct 2014 @ 10:46 PDT||pyite||Tools||Reply||TPT load failure - Please suggest||Thanks Steve, really appreciate it. So just to be clear, despite using the MS driver, the issue is fixed in 02?
|45806||31 Oct 2014 @ 10:44 PDT||dlayten||General||Topic||Converting varchar to timestamp||All 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... |
|45805||31 Oct 2014 @ 10:24 PDT||feinholz||Tools||Reply||TPT load failure - Please suggest||Talk 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.)
|45804||31 Oct 2014 @ 09:14 PDT||escueta||Teradata Studio||Topic||Need 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... |
|45803||31 Oct 2014 @ 08:37 PDT||ulrich||Database||Reply||Size 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...
|45802||31 Oct 2014 @ 08:34 PDT||Chandan||Database||Reply||How 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 &... |
|45801||31 Oct 2014 @ 06:27 PDT||ToddAWalter||Database||Reply||Invalid Time||TM is your column name. You have to insert into DU, your table name.
|45800||31 Oct 2014 @ 06:16 PDT||billcoupe||Tools||Reply||SQL Assistant key not found error||Has 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.
|45799||31 Oct 2014 @ 05:57 PDT||vincent91||Tools||Reply||Session and Checkpoint consideration in TTUs and TPT||how 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... |
|45798||31 Oct 2014 @ 05:55 PDT||Raja_KT||Database||Reply||Error in Merge Statement ||Check your PI,PPI cols matching
|45797||31 Oct 2014 @ 05:35 PDT||Rohit Ranjan||Tools||Reply||BTEQ export CSV issue||Thanks Dieter. As always you are the life saver:)
|45796||31 Oct 2014 @ 05:04 PDT||pyite||Tools||Reply||TPT load failure - Please suggest||Thanks. 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) -- ... |
|45795||31 Oct 2014 @ 04:42 PDT||Raj83||Database||Topic||Error 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
|45794||31 Oct 2014 @ 04:26 PDT||reddyrajendra2014||Database||Topic||Size 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 ?....
|45793||31 Oct 2014 @ 04:04 PDT||dnoeth||Tools||Reply||BTEQ export CSV issue||Hi Rohit,
you must write the column header with a seperate Select:
sel 'eno,ename,dno,sal' (TITLE '');
|45792||31 Oct 2014 @ 03:17 PDT||Miklos||Database||Topic||Using periods with left outer join||Let'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 ... |