Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bkj123

    sql assistant: green italics comments

    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...
  2. bkj123

    Pivot Table Help

    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'...
  3. bkj123

    connecting Teradata and Netezza

    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.
  4. bkj123

    using form inputs with java script

    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...
  5. bkj123

    sql assistant/queryman import error

    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.
  6. bkj123

    Study Partner

    hello. where are you located?
  7. bkj123

    SQL for Parsing a String Delimited with Periods

    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...
  8. bkj123

    Create Object Excel and Queryman

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

    extracting data to .xls or .csv format

    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?
  10. bkj123

    Data Mining??

    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...
  11. bkj123

    Data Mining??

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

    queryman alternatives

    Thank you Dieter. As usual, great info.
  13. bkj123

    queryman alternatives

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

    access SAS from Queryman

    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.
  15. bkj123

    access sas dataset through queryman

    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
  16. bkj123

    access SAS from Queryman

    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
  17. bkj123

    Querying from different databases

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

    Data Mining??

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

    Data Mining - worth the investment?

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

    Data Mining Software tools - Critical Appraisals

    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...

Part and Inventory Search

Back
Top