ms sql has a feature where you can be looking at a lot of sql code, hilite one section of it and hit f5 and it will only run that piece of code. Does the teradata sql assistant r13.x do that in some other way?
a related question. Teradata macros seem to do only one sql action per macro. Like I can't do 10 different selects in one macro. I have tried semicolons at then end of a selects, I have tried putting END in. Is there some way to do multiple sql actions in a macro? bteq seems more flexible this way.
1. There's an option "submit only selected query text when highlighted" in options - query For some historical reason it's unchecked by default.
2. Of course you might have multiple DML statements witin a single macro, you might even exec a macro within a macro. Each statement must be terminated by a semicolon, you already tried that, so there must be some other error.
Dieter, my sql assistant has only little buttons, none of which say "options". Is there some command to get menus for the sql assistant gui?
I did multiple selects in a macro and that worked, thanks. If do something more complex like create volitile table xtempc as ( select .... ) WITH DATA ON COMMIT PRESERVE ROWS ; They don't seem to stack. Like creating 3 or 4 temp tables in one macro. Do I need to use more semicolons?
Dieter, Thanks, alt-t did the trick. The menu came up separate from the sql assistant window. When I dragged the disjoint menu back to the sql assistant window, the menu items stayed in sql assistant even after logon/logoff. With that I was able to get the "execute only hilite" feature working.
I understand about only one ddl per macro. I'll take a look at stored procedures.