Search results for query: *

Jen123 I find "TERADATA SQL UNLEASH THE POWER" by Larkins and Coffing a useful additon to the NCR manuals Martin

jones1 There is some info on reserved words in the V2R5 documentation (Release Summary manual) but I guess you've already looked here. I tend to find there are always 'surprises' when upgrading which don't appear to be fully documented, or at least not that easy to find. I guess that is...

Can you post the exact error message are you getting? Martin

I really could have misunderstood your problem here but you could try just changing the order of the columns in the select ie: SELECT DISTINCT(PHONE),NAME, BLAH1, BLA2H,TRANSACTION,...... FROM TABLE1 TABLE2 TABLE3 TABLE4 WHERE STATE = 'TX' AND TYPE = 'BUS' AND TRANSACTION =...

Alternatively you could try: SELECT FIRSTNAME, LASTNAME GROUP BY 1,2; Martin

Depending on the size of the table, this may or may not be a solution for you. As well as being more than a little cheesy it could be a bit inefficient on very large tables. But try: SELECT * FROM MYSTUFF.TEKTIP WHERE ACCT_NUM NOT LIKE ALL ('%A%', '%B%', '%C%', '%D%', '%F%', '%H%'); or...

dezarnb I have never used global temporary tables myself. But according to the documentation the characteristics of this type of table include the following: Global temporary tables are private to the session which created them. Their contents cannot be shared by other sessions. Martin

Tony - The data type of column_d is CHAR(1). The missing comma is indeed a typo, but well spotted anyway! The former would appear to be where the problem lies. I hadn't realised the data type applied by the CASE statement would be VARCHAR. I'd assumed it would take the data type of the...

When running an INSERT/SELECT with a number of CASE statements in the SELECT clause an error '6706 Untranslatable Character' occurs. This happens in both Queryman and a Mainframe BTEQ script. All the data being processed is within existing Teradata tables i.e. no load files are being used...

Sambones An excellent suggestion. Can you confirm whether you are solely using the drivers or whether the Oracle Transparent Gateway for Teradata is part of the equation? Thanx Martin

To enhance security when loading to Teradata from an IBM E10K we are considering using the NCR supplied CLIUSRLGNEXT function. I can't find a coded example of this in any of the manuals. Does anyone have an example of how to code/use this function? Thanks Martin

Hi Devendrap You could try quering the following DBC tables to give you most of the info you require. DBC.LOGONOFF and DBC.ACCESSLOG. The latter assumes that you have access logging enabled for the user id you are logging on with TheMartian