Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 20 Jan 2011 @ 19:00:16 GMT

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

Subj:   Re: Query ends within a string or common block
From:   McLeod, Terry


In the SQL you sent. of the four places where "(title '')" appears, 3 are correct in that they are using two single quotation marks. The third of the four, however, contains a single double quotation mark, which is the cause of the error message you report receiving.

To get two line output, why not use two separate SQL statements? (I am assuming this is in a BTEQ script...)

Again, assuming you are using BTEQ, I think it is possible to format it in such a way to center it. Don't remember the derails offhand, but check the manual.

Hope this information is helpful.

P.S. I changed the double quotation to two single quotation marks and it worked.



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