Convert Oracle Dynamic SPL into Informix SPL
Posted in 2005
Prashant Shirude asked how to convert Oracle dynamic SQL where-clause strings in a procedure to Informix SPL. Jonathan Leffler said to install the Dynamic SQL (EXEC) bladelet, fix assignments with LET, and consider empty strings versus NULL, noting NVL(...) IN (...) works on 9.40. Jean Anderson and Obnoxio The gave locations for the bladelet. Partly answered.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Topics: Stored Procedures & SPL
Hi, Oracle Dynamic SQL: IF ( sl IS NOT NULL ) THEN sl_where_clause := ' AND NVL(service_level, ''ALL'') IN ( ''ALL'',''' || sl || ''' ) '; sl_bd_where_clause := 'and (service_level is null or EXISTS ( SELECT 1 FROM tp_company_service_level sl WHERE sl.carrier_code = RLD.carrier_code AND sl.tc_company_id = RLD.TC_COMPANY_ID and sl.service_level = RLD.service_level))'; ELSE sl_where_clause := NULL; sl_bd_where_clause := NULL; END IF; FOREACH rs_option_cursor FOR SELECT from rg_lane rl, rg_lane_dtl rld, carrier_code cc where (rl.tc_company_id = rld.tc_company_id and rl.lane_id = rld.lane_id ) AND rl.D_SEARCH_LOCATION IN (vDestinationList) sl_where_clause || sl_bd_where_clause || END FOREACH; How to convert above where_clause (sl_where_clause, sl_bd_where_clause) into Informix? This is just part of the oracle procedure, there are so many where clauses. Prashant ------_=_NextPart_001_01C4F736.CE0532AE Content-Type: text/html Content-Transfer-Encoding: quoted-printable <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC-html40"> <head> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)"> <style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline;} p.MsoPlainText, li.MsoPlainText, div.MsoPlainText {margin:0in; margin-bottom:.0001pt; font-size:10.0pt; font-family:"Courier New";} @page Section1 {size:8.5in 11.0in; margin:1.0in 77.95pt 1.0in 77.95pt;} div.Section1 {page:Section1;} --> </style> </head> <body lang=3DEN-US link=3Dblue vlink=3Dpurple> <div class=3DSection1> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'>Hi,<o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'><o:p> </o:p></span></font></p> <p class=3DMsoPlainText><b><font size=3D2 face=3D"Courier New"><span style=3D'font-size:10.0pt;font-weight:bold'>Oracle Dynamic = SQL:<o:p></o:p></span></font></b></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'><o:p> </o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'>IF ( sl IS NOT NULL ) THEN<o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'> sl_where_clause :=3D ' AND = NVL(service_level, ''ALL'') IN ( ''ALL'',''' || <o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'> sl || ''' ) = ';<o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'> sl_bd_where_clause :=3D 'and (service_level = is null or EXISTS ( SELECT 1 <o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'> FROM = tp_company_service_level sl WHERE sl.carrier_code =3D <o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'> &nbs= p; RLD.carrier_code AND = <o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'> sl.tc_company_id =3D RLD.TC_COMPANY_ID and sl.service_level =3D = <o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'> = RLD.service_level)= )';<o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'>ELSE<o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'> sl_where_clause :=3D = NULL;<o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'> sl_bd_where_clause :=3D = NULL;<o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'>END IF;<o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'><o:p> </o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'>FOREACH rs_option_cursor FOR<o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'> SELECT <o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'>from rg_lane rl, rg_lane_dtl rld, carrier_code = cc<o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'>where (rl.tc_company_id =3D rld.tc_company_id and rl.lane_id = =3D rld.lane_id )<o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'>AND rl.D_SEARCH_LOCATION IN = (vDestinationList)<o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'> sl_where_clause || = sl_bd_where_clause ||<o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'><o:p> </o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'>END FOREACH;<o:p></o:p></span></font></p> <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = style=3D'font-size: 10.0pt'><o:p>&
forum.subscriber@iiug.org wrote on 01/10/2005 09:12:51 AM: > Oracle Dynamic SQL: > > IF ( sl IS NOT NULL ) THEN > sl_where_clause := ' AND NVL(service_level, ''ALL'') IN ( ''ALL'',''' || > sl || ''' ) '; > sl_bd_where_clause := 'and (service_level is null or EXISTS ( SELECT 1 > FROM tp_company_service_level sl WHERE sl.carrier_code = > RLD.carrier_code AND > sl.tc_company_id = RLD.TC_COMPANY_ID and sl.service_level = > RLD.service_level))'; > ELSE > sl_where_clause := NULL; > sl_bd_where_clause := NULL; > END IF; > > FOREACH rs_option_cursor FOR > SELECT > from rg_lane rl, rg_lane_dtl rld, carrier_code cc > where (rl.tc_company_id = rld.tc_company_id and rl.lane_id = rld.lane_id ) > AND rl.D_SEARCH_LOCATION IN (vDestinationList) > sl_where_clause || sl_bd_where_clause || > END FOREACH; > > How to convert above where_clause (sl_where_clause, sl_bd_where_clause) into > Informix? > > This is just part of the oracle procedure, there are so many where clauses. > > Prashant You'll need to install the Dynamic SQL bladelet (aka EXEC datablade) -- hunt it down on the IIUG and/or IBM web sites -- and then you'll need to fix up the assignments with LET and '='. You may also find that empty strings (as opposed to NULL strings - they are different according to ISO SQL, contrary to what Oracle thinks) better than nulls. I've verified that the NVL(...) IN (...) syntax works (IDS 9.40) with "SELECT * FROM systables WHERE NVL(tabname, 'ALL') IN ('ALL', 'syscolumns');" and it produced the correct answer (syscolumns). -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Data Management 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!"
I searched for Dynamic SQL bladelet (aka EXEC datablade) on IBM/IIUG web sites but didn't get any result. I can modify the assignment statements but how will I modify the where clause? Prashant _____ From: Jonathan Leffler [mailto:jleffler@us.ibm.com] Sent: Monday, January 10, 2005 2:48 PM To: Prashant Shirude Cc: forum.subscriber@iiug.org; ids@iiug.org Subject: Re: Convert Oracle Dynamic SPL into Informix SPL [3980] forum.subscriber@iiug.org wrote on 01/10/2005 09:12:51 AM: > Oracle Dynamic SQL: > > IF ( sl IS NOT NULL ) THEN > sl_where_clause := ' AND NVL(service_level, ''ALL'') IN ( ''ALL'',''' || > sl || ''' ) '; > sl_bd_where_clause := 'and (service_level is null or EXISTS ( SELECT 1 > FROM tp_company_service_level sl WHERE sl.carrier_code = > RLD.carrier_code AND > sl.tc_company_id = RLD.TC_COMPANY_ID and sl.service_level = > RLD.service_level))'; > ELSE > sl_where_clause := NULL; > sl_bd_where_clause := NULL; > END IF; > > FOREACH rs_option_cursor FOR > SELECT > from rg_lane rl, rg_lane_dtl rld, carrier_code cc > where (rl.tc_company_id = rld.tc_company_id and rl.lane_id = rld.lane_id ) > AND rl.D_SEARCH_LOCATION IN (vDestinationList) > sl_where_clause || sl_bd_where_clause || > END FOREACH; > > How to convert above where_clause (sl_where_clause, sl_bd_where_clause) into > Informix? > > This is just part of the oracle procedure, there are so many where clauses. > > Prashant You'll need to install the Dynamic SQL bladelet (aka EXEC datablade) -- hunt it down on the IIUG and/or IBM web sites -- and then you'll need to fix up the assignments with LET and '='. You may also find that empty strings (as opposed to NULL strings - they are different according to ISO SQL, contrary to what Oracle thinks) better than nulls. I've verified that the NVL(...) IN (...) syntax works (IDS 9.40) with "SELECT * FROM systables WHERE NVL(tabname, 'ALL') IN ('ALL', 'syscolumns');" and it produced the correct answer (syscolumns). -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Data Management 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" ------_=_NextPart_001_01C4F758.8B3C2BC6 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <html xmlns:v=3D"urn:schemas-microsoft-com:vml" = xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" = xmlns=3D"http://www.w3.org/TR/REC-html40"> <head> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)"> <!--[if !mso]> <style> v\\\\:* {behavior:url(#default#VML);} o\\\\:* {behavior:url(#default#VML);} w\\\\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--><o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" = name=3D"PostalCode"/> <o:SmartTagType = namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"State"/> <o:SmartTagType = namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"Street"/> <o:SmartTagType = namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"address"/> <o:SmartTagType = namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"City"/> <o:SmartTagType = namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"PersonName"/> <!--[if !mso]> <style> st1\\\\:*{behavior:url(#default#ieooui) } </style> <![endif]--> <style> <!-- /* Font Definitions */ @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} @font-face {font-family:sans-serif; panose-1:0 0 0 0 0 0 0 0 0 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline;} tt {font-family:"Courier New";} span.EmailStyle18 {mso-style-type:personal-reply; font-family:Arial; color:navy;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in;} div.Section1 {page:Section1;} --> </style> </head> <body lang=3DEN-US link=3Dblue vlink=3Dpurple> <div class=3DSection1> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>I searched for </span></font><font = size=3D2 face=3Dsans-serif><span = style=3D'font-size:10.0pt;font-family:sans-serif'>Dynamic SQL bladelet (aka EXEC datablade) on IBM/IIUG web sites but didn't get any result. <o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3Dsans-serif><span = style=3D'font-size:10.0pt; font-family:sans-serif'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3Dsans-serif><span = style=3D'font-size:10.0pt; font-family:sans-serif'>I can modify the assignment statements but how = will I modify the where clause?</span></font><font size=3D2 color=3Dnavy = face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:navy'><o:p></o:p></spa= n></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>= <div> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>Prashant = </span></font><o:p></o:p></p> </div> <div> <div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font = size=3D3 face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1> </span></font></div> <p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span = style=3D'font-size:10.0pt; font-family:Tahoma;font-weight:bold'>From:</span></font></b><font = size=3D2 face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'> = Jonathan Leffler [mailto:jleffler@us.ibm.com] <br> <b><span style=3D'font-weight:bold'>Sent:</span></b> Monday, January = 10, 2005 2:48 PM<br> <b><span style=3D'font-weight:bold'>To:</span></b> <st1:PersonName = w:st=3D"on">Prashant Shirude</st1:PersonName><br> <b><span style=3D'font-weight:bold'>Cc:</span></b> = forum.subscriber@iiug.org; ids@iiug.org<br> <b><span style=3D'font-weight:bold'>Subject:</span></b> Re: Convert = Oracle Dynamic SPL into Informix SPL [3980]</span></font><
The exec bladelet is also here, though it's possible it isn't as current as what is (somewhere) at the IIUG: http://www.ibm.com/developerworks/db2/zones/informix/library/demo/ids_exec.html -jean Jean T. Anderson Cloudscape Gardener / Community Architect Internet: jander@us.ibm.com "Prashant Sh...." <PShirude@manh.com> Sent by: forum.subscriber@iiug.org 01/10/2005 01:14 PM To ids@iiug.org cc Subject RE: Convert Oracle Dynamic SPL into Informix SPL [3983] I searched for Dynamic SQL bladelet (aka EXEC datablade) on IBM/IIUG web sites but didn't get any result. I can modify the assignment statements but how will I modify the where clause? Prashant _____ From: Jonathan Leffler [mailto:jleffler@us.ibm.com] Sent: Monday, January 10, 2005 2:48 PM To: Prashant Shirude Cc: forum.subscriber@iiug.org; ids@iiug.org Subject: Re: Convert Oracle Dynamic SPL into Informix SPL [3980] forum.subscriber@iiug.org wrote on 01/10/2005 09:12:51 AM: > Oracle Dynamic SQL: > > IF ( sl IS NOT NULL ) THEN > sl_where_clause := ' AND NVL(service_level, ''ALL'') IN ( ''ALL'',''' || > sl || ''' ) '; > sl_bd_where_clause := 'and (service_level is null or EXISTS ( SELECT 1 > FROM tp_company_service_level sl WHERE sl.carrier_code = > RLD.carrier_code AND > sl.tc_company_id = RLD.TC_COMPANY_ID and sl.service_level = > RLD.service_level))'; > ELSE > sl_where_clause := NULL; > sl_bd_where_clause := NULL; > END IF; > > FOREACH rs_option_cursor FOR > SELECT > from rg_lane rl, rg_lane_dtl rld, carrier_code cc > where (rl.tc_company_id = rld.tc_company_id and rl.lane_id = rld.lane_id ) > AND rl.D_SEARCH_LOCATION IN (vDestinationList) > sl_where_clause || sl_bd_where_clause || > END FOREACH; > > How to convert above where_clause (sl_where_clause, sl_bd_where_clause) into > Informix? > > This is just part of the oracle procedure, there are so many where clauses. > > Prashant You'll need to install the Dynamic SQL bladelet (aka EXEC datablade) -- hunt it down on the IIUG and/or IBM web sites -- and then you'll need to fix up the assignments with LET and '='. You may also find that empty strings (as opposed to NULL strings - they are different according to ISO SQL, contrary to what Oracle thinks) better than nulls. I've verified that the NVL(...) IN (...) syntax works (IDS 9.40) with "SELECT * FROM systables WHERE NVL(tabname, 'ALL') IN ('ALL', 'syscolumns');" and it produced the correct answer (syscolumns). -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Data Management 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" ------_=_NextPart_001_01C4F758.8B3C2BC6 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <html xmlns:v=3D"urn:schemas-microsoft-com:vml" = xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" = xmlns=3D"http://www.w3.org/TR/REC-html40"> <head> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)"> <!--[if !mso]> <style> v\\\\:* {behavior:url(#default#VML);} o\\\\:* {behavior:url(#default#VML);} w\\\\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--><o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" = name=3D"PostalCode"/> <o:SmartTagType = namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"State"/> <o:SmartTagType = namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"Street"/> <o:SmartTagType = namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"address"/> <o:SmartTagType = namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"City"/> <o:SmartTagType = namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"PersonName"/> <!--[if !mso]> <style> st1\\\\:*{behavior:url(#default#ieooui) } </style> <![endif]--> <style> <!-- /* Font Definitions */ @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} @font-face {font-family:sans-serif; panose-1:0 0 0 0 0 0 0 0 0 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline;} tt {font-family:"Courier New";} span.EmailStyle18 {mso-style-type:personal-reply; font-family:Arial; color:navy;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in;} div.Section1 {page:Section1;} --> </style> </head> <body lang=3DEN-US link=3Dblue vlink=3Dpurple> <div class=3DSection1> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>I searched for </span></font><font = size=3D2 face=3Dsans-serif><span = style=3D'font-size:10.0pt;font-family:sans-serif'>Dynamic SQL bladelet (aka EXEC datablade) on IBM/IIUG web sites but didn't get any result. <o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3Dsans-serif><span = style=3D'font-size:10.0pt; font-family:sans-serif'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3Dsans-serif><span = style=3D'font-size:10.0pt; font-family:sans-serif'>I can modify the assignment statements but how = will I modify the where clause?</span></font><font size=3D2 color=3Dnavy = face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:navy'><o:p></o:p></spa= n></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>= <div> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>Prashant = </span></font><o:p></o:p></p> </div> <div> <div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font = size=3D3 face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1> </span></font></div> <p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span = style=3D'font-size:10.0pt; font-family:Tahoma;font-weight:bold'>From:</span></font></b><font = size=3D2 face=3DTahoma><span style=3D'font-size:10.0pt
Prashant Sh.... said: > I searched for Dynamic SQL bladelet (aka EXEC datablade) on IBM/IIUG web > sites but didn't get any result. Jesus, you must have really killed yourself searching: ftp://ftp.iiug.org/pub/informix/pub/exec_sql_udr.zip -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco You're so stupid, you think martial arts are paintings by a sheriff... I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed