Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 20 May 2011 @ 09:19:04 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Use case statement to select the desired table
From:   Benjamin.E.Ford

If you only need to run the code in SQL Assistant then the following will work. You will be prompted for a parameter to replace the text "?hcclSchema" wherever it occurs. I think that this will not work outside of SQL Assistant. In Crystal Reports you would enter your parameter as {?hcclSchema}--adding the braces.

     SELECT *
     FROM ?hcclSchema.PATIENT


Ben Ford

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