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 derfloh 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
Joined
Nov 7, 2002
Messages
9
Location
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 Question
Conditionally have a subfile display record blink
Replies
5
Views
1K
mikrom
mikrom
C
  • Locked
  • Question Question
STRDBG not bringing up options to set breakpoints
Replies
10
Views
1K
chuckw0325
C
tekpr00
  • Locked
  • Question Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
754
tekpr00
tekpr00
C
  • Locked
  • Question Question
AS400 Compile Error
Replies
8
Views
1K
chuckw0325
C
SE2097
  • Locked
  • Question Question
IBM DB2 On Cloud - How is table column name formatted?
Replies
0
Views
319
SE2097
SE2097

Part and Inventory Search

Sponsor

Back
Top