Archives of the TeradataForum

Message Posted: Mon, 21 Feb 2005 @ 11:11:20 GMT

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

Have you tried ''Market''?

Basically it stores the select as a string. To check what you will be storing, just construct the select string, then SELECT it in bteq/SQL Assistant to check what you're getting. For example if I wanted WB to run

     Select *
     from tablea
     where columna = 'Egg'

Then I'd make my WB script have

     Selectstmt =
     'Select *
     from tablea
     where columna = ''Egg'';'

And would verify this gives me the statement I want by running the following in SQL Assistant;

     SELECT 'Select *
     from tablea
     where columna = ''Egg'';';

Cheers,

Stuart Herd

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