Vaule in select Sql query

Vijay Gowda · New User Joined: 02 Jun 2006 Posts: 7

Daer sir,

I got requirement

Select e.envir_nm
,e.status
,e.version
,e.ent_id
,value(e2.envir_nm,??)
,value(e2.status,??)
,value(e2.version,??)
,value(e2.ent_id,0)
,value(e2.envir_ds,??)
From dbxrel30.amx_sys_envir e
Dbxrel30.amx_sys_envir e2

what does value mean in select statement and what it will retrive

Please let me know whether it is correct or not

Thanks in advance

regards,
Vijay

Prasanthhere · Active User Joined: 03 Aug 2005 Posts: 306

Value is similar to COALESCE which is used in a Sql query .Value returns the first aurgument which is not null

U can get more information in the following link

publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2.doc.sqlref/bjnrmstr316.htm

Thanks

guptae · Posted: Thu Sep 07, 2006 3:42 pm

Hi Vijay,

It is corect the verb value replace null value with specified values
I.g

Null value in coloumn envir_nmwill replaced by space &
Null value in e2.ent_id replaced by 0

[/img]

Vijay Gowda · New User Joined: 02 Jun 2006 Posts: 7

thanks for your reply

thanks
vijay