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

Function to returns the first nonzero argument

Status
Not open for further replies.
Lesio

Lesio

MIS
Jan 7, 2003
48
US
Is there a function in DB2 to returns the first nonzero argument ?

Column1 = 0
Column2 = 1.5

Function (column1, column2) = 1.5
 
Sort by date Sort by votes
select (case when c1=0 then c2 else c1 end) from table
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question
STRDBG not bringing up options to set breakpoints
Replies
10
Views
282
chuckw0325
C
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
305
tekpr00
tekpr00
usr1234
  • Locked
  • Question
does the setting PARALLEL_DEGREE=*OPTIMIZE helps the execution of an ALTER TABLE ?
Replies
0
Views
120
usr1234
usr1234
Kuldeepg
  • Locked
  • Question
Timestamp_format is not libl function
Replies
1
Views
204
mikrom
mikrom
AMRICE
  • Locked
  • Question
AS400 CPYTOIMPF forces me to enter the latest Job Number
Replies
0
Views
115
AMRICE
AMRICE

Part and Inventory Search

Sponsor

Back
Top