Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: How to use a string in TWB script.
From:   Herd, Stuart

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'';';


Stuart Herd

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020