Archives of the TeradataForum
Message Posted: Mon, 21 Feb 2005 @ 11:11:20 GMT
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'';';
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|