Using the AS Keyword

[tman24m]

Anyone know how to use the AS keyword with the IBMDA400 driver?

Trying to do something similar to SQL, i.e. SELECT Name as [First Name] from Names

 

[gregsimpson]

tman24m,

I don't know about your sepcific driver but the usual syntax is

SELECT Name as FirstName from Names

Cheers
Greg

 

[tman24m]

Thanks for the reply. However that doesn't do what I was looking for. I want to display it with the space between First and Name. With SQL you can do that using the [] around the alias. I can't figure out how to do it through IBM SQL.

 

[PruSQLer]

Select name as "first name"
From names

 

[tman24m]

Thanks, that's what I was looking for. Sometimes the simplest answers are hard to come by.