Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Alias to a column

Status
Not open for further replies.
SIDSHU

SIDSHU

Programmer
Nov 7, 2002
9
US

How can give an alias name to a column.

like
select FirstName AS F_Name from table1 in db2 sql query.

I tried select FirstName AS F_Name from table1 , did not work

Thanks.
 
Sort by date Sort by votes
When you say "did not work", exactly what was the result? Did you get an error message or did the alias just not look like you wanted?
 
Upvote 0 Downvote
Is it possible the "_" is a reserved character on your system? If so you may have to enclose the name in qoutes.

VTJ
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question
Conditionally have a subfile display record blink 1
Replies
5
Views
791
mikrom
mikrom
C
  • Locked
  • Question
STRDBG not bringing up options to set breakpoints
Replies
10
Views
600
chuckw0325
C
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
532
tekpr00
tekpr00
C
  • Locked
  • Question
AS400 Compile Error
Replies
8
Views
782
chuckw0325
C
SE2097
  • Locked
  • Question
IBM DB2 On Cloud - How is table column name formatted?
Replies
0
Views
232
SE2097
SE2097

Part and Inventory Search

Sponsor

Back
Top