RE: dbinfo("sqlca.sqlerrd2")

Posted in 2003

Support Informix — Tue, 07 Oct 2003 05:08:07 — source: IIUG Forums & Mailing Lists

Good idea, I can certainly use the nvl function in this way. Somebody suggest me to use "if g_ideodt is null" and this is good I tried unfortunately "if ... = null" ... on a monday morning. The nvl() I can use elsewhere Thanks, Yves -----Original Message----- From: preetinder.dhaliwal@dhl.com [mailto:preetinder.dhaliwal@dhl.com] Sent: maandag 6 oktober 2003 20:56 To: Support Inf.... Cc: ids@iiug.org Subject: Re: dbinfo("sqlca.sqlerrd2") [1992] You can use nvl(min(nvl(colname,defvalue)),defval2) , this way you can put ur defvalue to a value which is never used in ur application and then check for this and can find out from defval2 if it did not have any rows. Rgds Preetinder ------_=_NextPart_001_01C38C90.EFC01CB0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2653.12"> <TITLE>RE: dbinfo("sqlca.sqlerrd2") [1992]</TITLE> </HEAD> <BODY> Good idea, I can certainly use the nvl function in this = way. Somebody suggest me to use "if g_ideodt is = null" and this is good I tried unfortunately "if ... =3D = null"  ...  on a monday morning. The nvl() I can use elsewhere Thanks, Yves -----Original Message----- From: preetinder.dhaliwal@dhl.com [<A = HREF=3D"mailto:preetinder.dhaliwal@dhl.com">mailto:preetinder.dhaliwal@d= hl.com</A>] Sent: maandag 6 oktober 2003 20:56 To: Support Inf.... Cc: ids@iiug.org Subject: Re: dbinfo("sqlca.sqlerrd2") = [1992] You can use nvl(min(nvl(colname,defvalue)),defval2) , = this  way you can put ur defvalue to a value which is never used in ur = application and then check for this and can find out from defval2 if = it did not have any rows. Rgds Preetinder </BODY> </HTML> ------_=_NextPart_001_01C38C90.EFC01CB0--

↪ replying to Support Informix

PATRICK LEY — Thu, 09 Oct 2003 09:47:50 — source: IIUG Forums & Mailing Lists

Good idea, I can certainly use the nvl function in this way. Somebody suggest me to use "if g_ideodt is null" and this is good I tried unfortunately "if ... = null" ... on a monday morning. The nvl() I can use elsewhere Thanks, Yves -- comment The checking of NULL syntax should be IF varable IS NULL THEN ... and not IF varible = NULL THEN ... Cheer . Patrick

RE: dbinfo("sqlca.sqlerrd2")

Related threads

Your privacy choices