Venus (Universal Database Access) can run scripts

Posted in 2005

http://vmdd.tech.mylinuxisp.com/buddhism/links.html — Wed, 30 Mar 2005 23:01:00 -0600 — source: Usenet: comp.databases.informix

Below is an example of a real script I had used at work. This script is dynamic Java. Binh http://vmdd.tech.mylinuxisp.com/catalog/ =============================== void upd (sales, arm, amt) { sql1 = "update tbl_sales set threshold = threshold - " + amt + " where sales_id = " + sales; sql2 = "update tbl_sales set threshold = threshold - " + amt + " where sales_id = " + arm; parentarea_i.append (sql1); parentarea_i.append ("\\n"); cnt = stmt_i.executeUpdate (sql1); parentarea_i.append (cnt + "\\n"); parentarea_i.append (sql2); parentarea_i.append ("\\n"); cnt = stmt_i.executeUpdate (sql2); parentarea_i.append (cnt + "\\n"); } upd (850,51,1225.80); upd (322,61,914.26); upd (188,61,625.28); upd (854,61,13.92); upd (167,701,1335.60); upd (643,701,24.96); upd (150,995,2.88); upd (676,701,34.56); upd (648,61,6.72); upd (695,696,7.68); upd (645,696,3.84); upd (35,713,2.40); upd (732,713,290.74); upd (771,696,87.88); upd (321,51,35.52); upd (1,701,399.44); upd (810,51,506.44); upd (995,713,3.84); upd (222,713,3.36); upd (167,50,2.88); upd (693,74,1904.46); upd (738,51,816.24); upd (317,713,2495.38); upd (760,51,7.68); upd (740,995,4.80); upd (738,995,16.80); upd (35,995,20.64); upd (327,29,37.62); upd (713,713,254.80); upd (728,74,960.02); upd (676,51,5.28); upd (391,61,796.84); upd (850,995,103.68); upd (1,61,4.80); upd (663,245,7.68); upd (150,29,2.40); upd (719,696,1365.60); upd (693,696,3503.36); upd (294,701,351.08); upd (645,61,928.97); upd (728,995,3.84); upd (458,51,4.80); upd (581,50,2.88); upd (1,696,297.68); upd (723,51,10.56); upd (1,51,132.04); upd (338,995,3.84); upd (645,74,835.54); upd (982,50,836.12); upd (391,74,101.76); upd (458,696,149.86); upd (188,74,453.80); upd (318,51,746.00); upd (728,61,735.12); upd (16,50,617.88); upd (648,696,4.32); upd (304,50,1053.48); upd (188,995,8.16); upd (581,29,5.76); upd (728,696,3.84); upd (819,713,253.84); upd (868,61,1235.48); upd (609,51,2024.51); upd (321,50,3133.32); upd (558,51,2117.82); upd (837,245,763.62); upd (738,713,15.84); upd (322,74,27.84); upd (294,995,10.08); upd (327,827,4401.60); upd (1,245,275.96); upd (162,29,481.88); upd (854,713,482.16); upd (1,74,1.44); upd (558,50,7.20); upd (35,50,260.80); upd (693,61,1370.82); upd (911,696,1924.66); upd (532,701,5298.52); upd (638,701,1011.64); upd (676,713,1550.72); upd (581,713,1190.96); upd (609,995,10.08); upd (678,696,354.60); upd (868,995,406.72); upd (837,995,32.16); upd (756,50,1179.46); upd (868,74,361.40); upd (338,696,13.92); upd (558,713,23.52); upd (332,29,2252.74); upd (771,995,2.88); upd (558,74,17.76); upd (188,713,25.48); upd (35,51,2199.88); upd (722,713,553.52); upd (329,245,2018.10); upd (760,713,3780.76); upd (695,61,138.68); upd (645,995,81.64); upd (347,29,394.16); upd (695,74,45.60); upd (850,713,15.36); upd (1,713,3.36); upd (16,713,3.84); upd (581,51,11.52); upd (987,74,2.88); upd (770,696,0.48); upd (854,696,1807.08); upd (338,74,112.80); upd (338,61,2221.44); upd (344,50,256.40); upd (557,29,3245.78); upd (35,245,14.88); upd (851,29,287.48); upd (162,995,3.36); upd (760,696,8.16); upd (810,50,10.08); upd (676,50,8.64); upd (188,827,5.28);

↪ replying to http://vmdd.tech.mylinuxisp.com/buddhism/links.html

Philip Salgannik — Thu, 31 Mar 2005 00:30:28 -0500 — source: Usenet: comp.databases.informix

What does this have to do with powerbuilder? -- __ "http://vmdd.tech.mylinuxisp.com/buddhism/links.html"; <binhp@mylinuxisp.com> wrote in message news:114n0kb5hfv370e@corp.supernews.com... > Below is an example of a real script I had used at work. This > script is dynamic Java. > > Binh > http://vmdd.tech.mylinuxisp.com/catalog/ > > =============================== > void upd (sales, arm, amt) { > sql1 = "update tbl_sales set threshold = threshold - " + amt + " where > sales_id = " + sales; > sql2 = "update tbl_sales set threshold = threshold - " + amt + " where > sales_id = " + arm; > parentarea_i.append (sql1); > parentarea_i.append ("\\n"); > cnt = stmt_i.executeUpdate (sql1); > > parentarea_i.append (cnt + "\\n"); > parentarea_i.append (sql2); > parentarea_i.append ("\\n"); > cnt = stmt_i.executeUpdate (sql2); > parentarea_i.append (cnt + "\\n"); > } > > upd (850,51,1225.80); > upd (322,61,914.26); > upd (188,61,625.28); > upd (854,61,13.92); > upd (167,701,1335.60); > upd (643,701,24.96); > upd (150,995,2.88); > upd (676,701,34.56); > upd (648,61,6.72); > upd (695,696,7.68); > upd (645,696,3.84); > upd (35,713,2.40); > upd (732,713,290.74); > upd (771,696,87.88); > upd (321,51,35.52); > upd (1,701,399.44); > upd (810,51,506.44); > upd (995,713,3.84); > upd (222,713,3.36); > upd (167,50,2.88); > upd (693,74,1904.46); > upd (738,51,816.24); > upd (317,713,2495.38); > upd (760,51,7.68); > upd (740,995,4.80); > upd (738,995,16.80); > upd (35,995,20.64); > upd (327,29,37.62); > upd (713,713,254.80); > upd (728,74,960.02); > upd (676,51,5.28); > upd (391,61,796.84); > upd (850,995,103.68); > upd (1,61,4.80); > upd (663,245,7.68); > upd (150,29,2.40); > upd (719,696,1365.60); > upd (693,696,3503.36); > upd (294,701,351.08); > upd (645,61,928.97); > upd (728,995,3.84); > upd (458,51,4.80); > upd (581,50,2.88); > upd (1,696,297.68); > upd (723,51,10.56); > upd (1,51,132.04); > upd (338,995,3.84); > upd (645,74,835.54); > upd (982,50,836.12); > upd (391,74,101.76); > upd (458,696,149.86); > upd (188,74,453.80); > upd (318,51,746.00); > upd (728,61,735.12); > upd (16,50,617.88); > upd (648,696,4.32); > upd (304,50,1053.48); > upd (188,995,8.16); > upd (581,29,5.76); > upd (728,696,3.84); > upd (819,713,253.84); > upd (868,61,1235.48); > upd (609,51,2024.51); > upd (321,50,3133.32); > upd (558,51,2117.82); > upd (837,245,763.62); > upd (738,713,15.84); > upd (322,74,27.84); > upd (294,995,10.08); > upd (327,827,4401.60); > upd (1,245,275.96); > upd (162,29,481.88); > upd (854,713,482.16); > upd (1,74,1.44); > upd (558,50,7.20); > upd (35,50,260.80); > upd (693,61,1370.82); > upd (911,696,1924.66); > upd (532,701,5298.52); > upd (638,701,1011.64); > upd (676,713,1550.72); > upd (581,713,1190.96); > upd (609,995,10.08); > upd (678,696,354.60); > upd (868,995,406.72); > upd (837,995,32.16); > upd (756,50,1179.46); > upd (868,74,361.40); > upd (338,696,13.92); > upd (558,713,23.52); > upd (332,29,2252.74); > upd (771,995,2.88); > upd (558,74,17.76); > upd (188,713,25.48); > upd (35,51,2199.88); > upd (722,713,553.52); > upd (329,245,2018.10); > upd (760,713,3780.76); > upd (695,61,138.68); > upd (645,995,81.64); > upd (347,29,394.16); > upd (695,74,45.60); > upd (850,713,15.36); > upd (1,713,3.36); > upd (16,713,3.84); > upd (581,51,11.52); > upd (987,74,2.88); > upd (770,696,0.48); > upd (854,696,1807.08); > upd (338,74,112.80); > upd (338,61,2221.44); > upd (344,50,256.40); > upd (557,29,3245.78); > upd (35,245,14.88); > upd (851,29,287.48); > upd (162,995,3.36); > upd (760,696,8.16); > upd (810,50,10.08); > upd (676,50,8.64); > upd (188,827,5.28); > >

↪ replying to http://vmdd.tech.mylinuxisp.com/buddhism/links.html

nobody — Fri, 01 Apr 2005 07:44:21 -0600 — source: Usenet: comp.databases.informix

Wow! Just goes to show you that people are proud of their poor programing skills. Nothing new here, just a usenet spammer trying to hawk his pathetic wares. http://vmdd.tech.mylinuxisp.com/buddhism/links.html wrote: > Below is an example of a real script I had used at work. This > script is dynamic Java. > > Binh > http://vmdd.tech.mylinuxisp.com/catalog/ > > =============================== > void upd (sales, arm, amt) { > sql1 = "update tbl_sales set threshold = threshold - " + amt + " where > sales_id = " + sales; > sql2 = "update tbl_sales set threshold = threshold - " + amt + " where > sales_id = " + arm; > parentarea_i.append (sql1); > parentarea_i.append ("\\n"); > cnt = stmt_i.executeUpdate (sql1); > > parentarea_i.append (cnt + "\\n"); > parentarea_i.append (sql2); > parentarea_i.append ("\\n"); > cnt = stmt_i.executeUpdate (sql2); > parentarea_i.append (cnt + "\\n"); > } > > upd (850,51,1225.80); > upd (322,61,914.26); > upd (188,61,625.28); > upd (854,61,13.92); > upd (167,701,1335.60); > upd (643,701,24.96); > upd (150,995,2.88); > upd (676,701,34.56); > upd (648,61,6.72); > upd (695,696,7.68); > upd (645,696,3.84); > upd (35,713,2.40); > upd (732,713,290.74); > upd (771,696,87.88); > upd (321,51,35.52); > upd (1,701,399.44); > upd (810,51,506.44); > upd (995,713,3.84); > upd (222,713,3.36); > upd (167,50,2.88); > upd (693,74,1904.46); > upd (738,51,816.24); > upd (317,713,2495.38); > upd (760,51,7.68); > upd (740,995,4.80); > upd (738,995,16.80); > upd (35,995,20.64); > upd (327,29,37.62); > upd (713,713,254.80); > upd (728,74,960.02); > upd (676,51,5.28); > upd (391,61,796.84); > upd (850,995,103.68); > upd (1,61,4.80); > upd (663,245,7.68); > upd (150,29,2.40); > upd (719,696,1365.60); > upd (693,696,3503.36); > upd (294,701,351.08); > upd (645,61,928.97); > upd (728,995,3.84); > upd (458,51,4.80); > upd (581,50,2.88); > upd (1,696,297.68); > upd (723,51,10.56); > upd (1,51,132.04); > upd (338,995,3.84); > upd (645,74,835.54); > upd (982,50,836.12); > upd (391,74,101.76); > upd (458,696,149.86); > upd (188,74,453.80); > upd (318,51,746.00); > upd (728,61,735.12); > upd (16,50,617.88); > upd (648,696,4.32); > upd (304,50,1053.48); > upd (188,995,8.16); > upd (581,29,5.76); > upd (728,696,3.84); > upd (819,713,253.84); > upd (868,61,1235.48); > upd (609,51,2024.51); > upd (321,50,3133.32); > upd (558,51,2117.82); > upd (837,245,763.62); > upd (738,713,15.84); > upd (322,74,27.84); > upd (294,995,10.08); > upd (327,827,4401.60); > upd (1,245,275.96); > upd (162,29,481.88); > upd (854,713,482.16); > upd (1,74,1.44); > upd (558,50,7.20); > upd (35,50,260.80); > upd (693,61,1370.82); > upd (911,696,1924.66); > upd (532,701,5298.52); > upd (638,701,1011.64); > upd (676,713,1550.72); > upd (581,713,1190.96); > upd (609,995,10.08); > upd (678,696,354.60); > upd (868,995,406.72); > upd (837,995,32.16); > upd (756,50,1179.46); > upd (868,74,361.40); > upd (338,696,13.92); > upd (558,713,23.52); > upd (332,29,2252.74); > upd (771,995,2.88); > upd (558,74,17.76); > upd (188,713,25.48); > upd (35,51,2199.88); > upd (722,713,553.52); > upd (329,245,2018.10); > upd (760,713,3780.76); > upd (695,61,138.68); > upd (645,995,81.64); > upd (347,29,394.16); > upd (695,74,45.60); > upd (850,713,15.36); > upd (1,713,3.36); > upd (16,713,3.84); > upd (581,51,11.52); > upd (987,74,2.88); > upd (770,696,0.48); > upd (854,696,1807.08); > upd (338,74,112.80); > upd (338,61,2221.44); > upd (344,50,256.40); > upd (557,29,3245.78); > upd (35,245,14.88); > upd (851,29,287.48); > upd (162,995,3.36); > upd (760,696,8.16); > upd (810,50,10.08); > upd (676,50,8.64); > upd (188,827,5.28); > >