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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CHAR function Problems in SELECT

Status
Not open for further replies.
yotela

yotela

Programmer
Apr 5, 2001
1
UY
I'm having problems in a SELECT over a column table wich is numeric, using the cast funcion CHAR.
DB2 is not responding the SQL statment.
Do you know how to solve this problem ?
I'm working in OS390 with DB2 6.

Thanks,

Yotela.-
 
Sort by date Sort by votes
A sample copy of your query will help to solve your problem.
chidi
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

gdg1976
  • Locked
  • Question
extract rows with characters in char field
Replies
6
Views
333
gdg1976
gdg1976
pratimsingha
  • Locked
  • Question
Alternative of Select count(*) from TABLE
Replies
0
Views
179
pratimsingha
pratimsingha
MohanV
  • Locked
  • Question
Using table functions in Query
Replies
5
Views
220
fredericofonseca
fredericofonseca
gdg1976
  • Locked
  • Question
hi all, input TAB1 COL1
Replies
0
Views
168
gdg1976
gdg1976
ANGELDANY
  • Locked
  • Question
WEEK ISO with Dates in string format YYYYMMDD 1
Replies
4
Views
375
ANGELDANY
ANGELDANY

Part and Inventory Search

Sponsor

Back
Top