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 SkipVought 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
0
0
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

tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
82
tekpr00
tekpr00
SE2097
  • Locked
  • Question
IBM DB2 On Cloud - How is table column name formatted?
Replies
0
Views
48
SE2097
SE2097
ColeFern
  • Locked
  • Question
SQL1224N A database agent could not be started to service a request, or was terminated as a result
Replies
0
Views
60
ColeFern
ColeFern
gdg1976
  • Locked
  • Question
hi all, input TAB1 COL1
Replies
0
Views
47
gdg1976
gdg1976
evr72
  • Locked
  • Question
Update field from one table with a join table
Replies
1
Views
74
evr72
evr72

Part and Inventory Search

Sponsor

Back
Top