Archives of the TeradataForum

Message Posted: Mon, 20 Apr 2009 @ 13:46:52 GMT

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

Either you are looking for this :

     sel infokey as "'Mykey'" from dbcinfo;
      *** Query completed. 3 rows found. One column returned.
      *** Total elapsed time was 1 second.
     'Mykey'
     ------------------------------
     LANGUAGE SUPPORT MODE
     RELEASE
     VERSION

or this:

     sel '''' || infokey || '''' from dbcinfo;
      *** Query completed. 3 rows found. One column returned.
      *** Total elapsed time was 1 second.
     ((''''||InfoKey)||'''')
     --------------------------------
     'LANGUAGE SUPPORT MODE'
     'RELEASE'
     'VERSION'

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