Archives of the TeradataForum

Message Posted: Thu, 03 Apr 2003 @ 15:25:00 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Yes. As long as you run your macro only through bteq. You will have to maintain close control over where this is run.

CREATE MACRO TWO_STEP
(
.set titledashes off;
.export file = a;
SELECT 'SELCT blah blah FROM ' || TRIM(DATABASENAME) || '.' ||
TRIM(TABLENAME) || ';' (title '')
FROM tablelist
ORDER BY 1;
.export reset
.run file = a;
);

You need to remember the blank title and titledashes to get rid of your titles. Alternatively, you can use .run file = a,skip=2, but the progam will error if no rows are returned.

We built Unix scripts to accomplish this.

Glen

	<Prev	Next>		<<First	<Prev	Next>	Last>>