Re: Server Studio
I was going to recommend purchasing it from www.serverstudio.com/ but the site is not available. I am also unable to connect to their server for product updates. Anyone know what happened??? I sure hope they didn't go belly-up, I like the product. --Ben ----- Original Message ----- From: "LUQUE Valdivia Omar" <luque001@marina.mil.pe> To: <informix-list@iiug.org> Sent: Wednesday, January 26, 2005 12:38 PM Subject: Server Studio > Buen dia a todos, > > Somebody knows that company in Peru sells the Server Studio? > I need buy that tool. > > Alguien sabe que empresa en el Peru vende el Server Studio ??? > Necesito adquirir esta herramienta. > > Thanks > Gracias > > Omar. > > > > > -----Mensaje original----- > De: Dave Griffen [mailto:dgriffen@nospam.finishline.com] > Enviado el: Mi'rcoles, 26 de Enero de 2005 09:04 a.m. > Para: informix-list@iiug.org > Asunto: Re: Equivelant for lpad in Informix ? IDS7.31 > > > Lpad works fine on my 7.31 system and I even found lpad in a 7.31 SQL Syntax > book from Feb 1998. > > Rtrim is a bit different though try this... > trim(trailing from cl_m_no)||lpad(cl_d_no,2,'0') cl_m_d_no > > You may want to have another look at your manuals as well. > > "Doug Lawry" <lawry@nildram.co.uk> wrote in message > news:ct5oo8$oin$1@nntp0.reith.bbc.co.uk... > > Try not to post MIME, Dirk :-) A cleaned up version follows. > > Looks like you need to upgrade: LPAD is there in version 9. > > -- > > Regards, > > Doug Lawry > > www.douglawry.webhop.org > > > > > > "Dirk Moolman" <DirkM@mxgroup.co.za> wrote in message > > news:1106662226.b5a997af030137130b3480a9499796a4@teranews... > > > > > > Oracle has an "lpad" function, to add characters to the left of a string > > > - what is the equivelant of this function in Informix ? Cannot find > > > lpad function in the SQL manuals ... > > > > > > The problem is, I don't want to concatenate, ||, the result must always > > > be to characters long. > > > > > > If cl_m_d_no is 0, I want 00 > > > If cl_m_d_no is 9, I want 09 > > > If cl_m_d_no is 11, it stays 11 > > > > > > Oracle select below: > > > > > > SELECT "cl_bt_no" > > > ,"cl_no" > > > ,"cl_item_no" > > > ,"cl_operator_code" > > > ,substr("cl_scheme",3) cl_scheme > > > ,"cl_dr_no" > > > ,"cl_m_no" > > > ,"cl_d_no" > > > ,rtrim("cl_m_no")||lpad("cl_d_no",2,'0') cl_m_d_no > > > ,"cl_rams_no" > > > ,"cl_dt_service_in" > > > ,"cl_dt_service_out" > > > ,"cl_dt_payment" > > > ,"cl_dt_claim_rcvd" > > > ,"cl_dt_processed" > > > ,"cl_ta_code" > > > ,"cl_units" > > > ,"cl_m_plan" > > > ,"cl_dr_plan" > > > ,"cl_ta_rule" > > > ,"cl_run_no" > > > ,"cl_sequence" > > > ,"cl_tooth_no" > > > ,"dr_name" > > > ,"cl_pay_ind" > > > ,"cl_supp_ref_no" > > > ,"cl_reject_code" > > > ,"cl_remark_code" > > > ,"cl_booking_no" > > > ,"cl_claim_amount" > > > ,"cl_tariff_amount" > > > ,"cl_benefit_amount" > > > ,"cl_members_amount" > > > ,"cl_discount_amount" > > > ,"cl_status" > > > ,"cl_diag_code" > > > ,"cl_levy_amount" > > > ,"cl_iteration" > > > ,"cl_auth_no" > > > ,"cl_scheme_amount" > > > FROM "claim"@medclear > > > , "doctor"@medclear > > > WHERE "cl_dr_no" = "dr_no" > > > > > > > > > sending to informix-list sending to informix-list
Ben, AGS is most certainly did not belly-up. There is a major technical issue at ISP that hosts serverstudio.com site that involved cable breakage during construction works in NYC. We are currently working with the ISP and hope that this issue will be fixed shortly. Meanwhile you can use mirror site www.agsltd.com for the product information. Updates can be downloaded from www.agsltd.com/downloads We sincerely apologize for the inconvenience. Regarding the original question about purchasing Server Studio JE product in Peru: please contact AGS Sales Department at sales@agsltd.com for the contact information of our reseller in Peru. Thank you, Gary Okopnik Technical Support AGS Ltd.