Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 18 Sep 2002 @ 07:21:30 GMT

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

Subj:   Re: An SQL PrettyPrinter???
From:   Dieter Nöth

Frank C. Martinez IV wrote:

  You can do multi-statement requests from THIS TYPE OF TOOL (see, I'm not talking about a particular product) (oh yeah, try that in Queryman).  

Press F9? But Queryman's syntax highlighting/formatting is terrible...

[snipped nice macro]

  Oh yeah, as you can see, I'm having some trouble with this little macro, getting SQL to let me use the Title column in DBC.Columns. Seems it conflicts with the reserved word. Anybody figured a way around that?  

  The errormessage is
3810: Column/Parameter 'T1.Title' does not exist.

Hmmm, i've never seen that before ;-)

So let's see, what's in the Messages manual about that error:

"Explanation: The column/parameter %VSTR could not be found in any of tables or views referenced in this statement.

Remedy: Check the spelling of the column or parameter name, or see if the table or procedure in which the column exists is correctly referenced."

Hint: the column is named ColumnTitle ;-)


  <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: 28 Jun 2020