Dynamic SQL in PRO-C (type 3), problem with NULL
From: Riccardo D.S. <rdistefano_at_aleniasystems.finmeccanica.it>
Date: Fri, 31 Mar 2000 14:25:53 +0200
Message-ID: <38E49951.D6D2CB0A_at_aleniasystems.finmeccanica.it>
I use e dynamic SQL statment (pro c - type 3 ) to estract the value of single column and put it in the host-variable. When the return of query is Null the SQL statment go in error . Is it possible when this occur continue the process? Now use the NVL function to return a particulat string or number when the value is NULL. I prefer ignore the select when tha value is Null and continue to other select.
Date: Fri, 31 Mar 2000 14:25:53 +0200
Message-ID: <38E49951.D6D2CB0A_at_aleniasystems.finmeccanica.it>
I use e dynamic SQL statment (pro c - type 3 ) to estract the value of single column and put it in the host-variable. When the return of query is Null the SQL statment go in error . Is it possible when this occur continue the process? Now use the NVL function to return a particulat string or number when the value is NULL. I prefer ignore the select when tha value is Null and continue to other select.
Thanks,
Sorry for my english...
I'm italian
Dott. Riccardo Di Stefano
Alenia Marconi System s.p.a.
Rome - Italy
Received on Fri Mar 31 2000 - 14:25:53 CEST