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

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 - Can anyone recommend alternatives to Queryman? Please include your experience/thoughts/opinions of these tools. 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. - 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

Hello - Looking for a lean database that is ANSI sql92 compliant to practice ANSI sql. By "lean", I mean "small". Freeware would be great. Also, couldn't find solid answers for the following questions: - What is the latest ANSI standard for SQL? 92? 99? is anyone supporting it? Are there...

Just updated Queryman from v5.1 to v6.0. Trying to get the tabbing in v6 to be like it was in v5.1. In 5.1, if I hit the return/enter key, the cursor advances to the beginning of the next line. Even if I tab 3 times and hit return, the cursor is still at the beginning of the next line...

Hello - The list below is a class room schedule for the morning session of an elemtary school. It lists the start and end times of each period as well as the class room and subject being taught. I'd like to get the data into a grid like that shown below the list. I thought a pivot table would...

Hello - Does the 'sample' keyword generate a random or non-random (i.e. first obs)answer set? Thank you.

Issue: running query in Queryman against a TD table. Results start to come back and stop short of what is expected. Example: run query expecting about 900 records in the answer set. However, results stop at 400, even though my &quot;maximum number of answer rows to display&quot; option is...

Good day all! Has anyone used the &quot;Execute Parallel&quot; function/button in Queryman with Teradata? When can/should it be used and what are the benefits? Thank you.

Hello - Would like to update a teradata table with data found in an oracle table. I have ODBC connections for both Teradata and Oracle. I can also connect to each database, one at a time, via Queryman. Is there a way I can hit both in the same queryman session? Thanks, Brian

Hello - 2 questions please: (1) How do I declare and use a variable? In the code below, I'm looking to declare a variable and use it in a WHERE statement.. DECLARE vsor_id CHAR(7); SET vsor_id = 'V','I'; SELECT count(*) FROM bkj_churn_def WHERE sor_id in (:vsor_id); /* The actual code...