Search results for query: *

Hello. I am using Teradata SQL Assistant v12.0. The default formatting for inline comments is green italics. Using tools > options > formatting, I can change the color of the comments but not the italics format. How can I turn off the italics? I swear I had done this in earlier versions...

Hi Scott. Does the code below work or did you want something more automated? select status ,reason ,sum(case when data = '2010-04-13' then 1 else 0 end) as 20100413 ,sum(case when data = '2010-04-14' then 1 else 0 end) as 20100414 ,sum(case when data = '2010-04-15'...

Good morning. Any suggestions of connecting Teradata and Netezza databases? We are currently using SAS to do this and are looking for other options. Thank you.

Hello. I have a web page with a form that asks the user for their name and few other inputs. I'd like to send the inputs to another webpage that creates a letter. A simplified example is a form that asks for the: - user's name (<uname>), - their govenor's name (<gname>) - and a question...

Hello. I'm using SQL Assistant 7.1 (QueryMan) to run a query with parameters using File>Import Data. I am getting an error message saying "Error occurred during ExportResults. Code=54 Bad file mode". Any ideas of how I can resolve? Thank you.

hello. where are you located?

if it were a flat file you could load it as a delimited file. Not sure if you can do this table to table or table to file to table. other than that, you basically need to find the position of the first 3 periods and then you can use a substring funtion to pull out the first 3 values. I'd start...

Sounds like you want to access Teradata from Excel. Why not just use ODBC which is what I believe Queryman uses.

what software are you using for your database? How many tables, columns, and rows do you have? Probably the most important question is why do you want to export the whole database to excel?

hejamana - I have seen many defintions of "data mining" but I do not consider one to be "complex reporting". The first definition listed at google (http://www.google.com/search?hl=en&lr=&oi=defmore&q=define:Data+mining) states: The process of analyzing data to identify patterns or...

pwrpuff - Are you equating data mining with MIS and reporting?

Thank you Dieter. As usual, great info.

Hello - Can anyone recommend alternatives to Queryman? Please include your experience/thoughts/opinions of these tools. Thank you. - Brian

Thanks teralearner - Hear what you are saying. I'm trying to avoid creating a permanent table due to limited available space. That's where hitting the dataset would be helpful.

Hello - I am able to access Teradata through SAS. For example, I can create a SAS dataset by using PROC SQL to hit a Teradata table(s). Is there a way to access a SAS dataset in Queryman? I'm looking to join a SAS dataset on a unix server to a teradata table. Thank you. - Brian

Hello - I am able to access Teradata through SAS. For example, I can create a SAS dataset by using PROC SQL to hit a Teradata table(s). Is there a way to access a SAS dataset in Queryman? I'm looking to join a SAS dataset on a unix server to a teradata table. Thank you. - Brain

I've used MS Access to link to Oracle and Teradata at the same time using ODBC. Warning: Performance was an issue. Thanks.

Anthony - My response to Derrick's post may be helpful... http://www.tek-tips.com/viewthread.cfm?qid=855811 - Brian

Phil - Sounds like a great opportunity to do a Proof of Concept on your own or even better with a vendor. - Brian

I agree with JD. SAS and SPSS/Clementine have good (very good in my opinion) products and even more importantly, since your users are familiar with them and have accepted them, you are setting yourself up for a successful implementation. As far as reviews, JD's mention of DMREVIEW is always...