Convert Oracle Dynamic SPL into Informix SPL
Posted in 2005
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