Has anybody customised their QueryMan setup? 1

[RogerCruse]

Hi,
I'm looking for ways to improve the general standard of SQL being generated by the business & IT users in my company and one way I've thought of is to customise the "SQL Builder" function within QueryMan.

Has anybody done this?

A little background info.
When you right click on the query panel within QueryMan and select the SQL Builder option (earlier versions called it something else, but it's the same thing). You're presented with a list of SQL commands with an simple example of its syntax of each using tables / views / columns like "employee", "department", "banana" etc.

This isn't a replacement for SQL training or the technical manuals but a simple crib sheet that is only a couple of clicks away.

This information is held in the teradata.syn file somewhere in your NCR folder, and it's easy to customise by adding further information, thus making it more relevant to your company and much more useful to your average user.

Then you have a small matter of distribution and keeping it up to date.

If you have done this, what information, other than described above, have you added, changed or removed?

Also, do you have any other suggestions for providing customsed information to your users?

Roger...

 

[dnoeth]

Instead of the syntax help in QueryMan you could enhance the
Teradata online help:
If you submit a "help 'sql create user'" the help text is retrieved from SysAdmin.HelpSyntax

You can add new entries by inserting into that table and every user can access it, e.g.

INSERT INTO SysAdmin.HelpSyntax('RogerCruise','COMMANDS',1,'foo');
INSERT INTO SysAdmin.HelpSyntax('RogerCruise','COMMANDS',2,'bar');
INSERT INTO SysAdmin.HelpSyntax('RogerCruise','foo',1,'bla bla bla');
INSERT INTO SysAdmin.HelpSyntax('RogerCruise','foo',2,'more bla bla');
INSERT INTO SysAdmin.HelpSyntax('RogerCruise','bar',1,'bla bla bla');
INSERT INTO SysAdmin.HelpSyntax('RogerCruise','bar',1,'more bla bla');

help 'rogercruise';

*** Query completed. 2 rows found. One column returned.
*** Total elapsed time was 1 second.

On-Line Help
---------------------------------------------------------
foo
bar

BTEQ -- Enter your DBC/SQL request or BTEQ command:

help 'rogercruise foo';

*** Query completed. 2 rows found. One column returned.
*** Total elapsed time was 1 second.

On-Line Help
---------------------------------------------------------
bla bla bla
more bla bla


see:
- SQL Reference Data Definition Statements, Ch. 4: HELP (Online Form)

- file dipolh.bteq in TDBMS/[version]/etc/


No nice GUI with click and cut'n'paste, but any tool can access it without further work.

Dieter

 

[RogerCruse]

Hi Dieter,
I did look at this, but liked the look & feel of the right click solution.

Thanks anyway.

Roger...

 

[RogerCruse]

Hi,
Having looked into this (translation, read the manual), it's possible to add a "custom.syn" file!

This appears as a third option on the dropdown list in the SQL Builder option.

I not sure what I'm going to put into this yet, but it does open up all sorts of possibilities!!!.

I could use the custom.syn to hold company specific information like contact details, service availability, anything!

I'm quite pleased I would award myself a "valuable post" if I could

Roger...

 

[dnoeth]

Sometimes it's good to RTFM, i didn't know about that custom file...

"I'm quite pleased I would award myself a "valuable post" if I could"

I'll do it for you ;-)

Dieter