two questions

Posted in 1999

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Platform-Specific Issues

=?iso-8859-1?Q?Ant=F3nio_Roque?= — Thu, 7 Oct 1999 12:35:42 +0100 — source: Informix-list mailing list archive (1991-1998)

This is a multi-part message in MIME format. ------=_NextPart_000_0015_01BF10C0.78834FA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi people , I=B4m working with Informix Dynamic Server Version 7.30.FC7 = , for HP-UX=20 1) Is possible , using only 4gl ( no c compiler ) before start a = transaction ( begin work ) to detect if I=B4m already in one = transaction ? 2) sorry to ask this again , also would like to know if , using 4gl only = , if I can retrieve the server=B4s names of all my remote databases one sample : I have 14 remote databases ( stores ) ( all Informix = Dynamic Server Version 7.30.FC7 ) , the database name is all ways the same=20 dbs@server1tcp , dbs@server2tcp , ... and so on , what I would like to = retrieve is the "@server?tcp" name that are availaible from=20 central database=20 This would be very help full to me ,because if my DBA added a new = database server or change the name without telling me=20 , ( all ways does that ...!) , I would=B4nt be need to change code of = the applications. I know this way of working is stupid ,but here I=B4m to small to = change any thing ...... ( each men for then self )=20 ( now I have to change the code of all my programs , no all only = shared functions , but need to re-compile all of then ) =20 Many thanks ------=_NextPart_000_0015_01BF10C0.78834FA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type> <META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT size=3D2>Hi people , I=B4m working with Informix Dynamic = Server Version=20 7.30.FC7 , for HP-UX </FONT></DIV> <DIV> </DIV> <DIV><FONT size=3D2>1) Is possible , using only 4gl ( no c compiler = ) before=20 start a transaction  ( begin work ) to detect if I=B4m already in = one=20 transaction ?</FONT></DIV> <DIV> </DIV> <DIV><FONT size=3D2>2) sorry to ask this again , also would like to = know if ,=20 using 4gl only  , if I can retrieve  the server=B4s names of = all my=20 remote databases</FONT></DIV> <DIV> </DIV> <DIV><FONT size=3D2> one sample : I have 14 remote databases ( = stores ) =20 ( all Informix Dynamic Server Version 7.30.FC7 ) , the database name is = all=20 ways</FONT></DIV> <DIV><FONT size=3D2> the same </FONT></DIV> <DIV> </DIV> <DIV><FONT size=3D2> dbs@server1tcp , dbs@server2tcp , ... and so = on , what I=20 would like to retrieve is the "@server?tcp" name that are = availaible from=20 </FONT></DIV> <DIV><FONT size=3D2> central database </FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2> This would be very help full to me  = ,because if my=20 DBA added a new database  server or change the name without telling = me=20 </FONT></DIV> <DIV><FONT size=3D2> , ( all ways does that ...!) , I = would=B4nt be=20 need to change code of the applications.</FONT></DIV> <DIV> </DIV> <DIV><FONT size=3D2>  I know  this way of working is = stupid ,but=20 here I=B4m to small to change any thing ...... ( each men for then = self )=20 </FONT></DIV> <DIV> </DIV> <DIV><FONT size=3D2>  ( now I have to change </FONT><FONT = size=3D2>the code of all my programs , no all only shared functions , = but need to=20 re-compile </FONT> <FONT size=3D2>all of then )</FONT></DIV> <DIV><FONT size=3D2>  </FONT></DIV> <DIV><FONT size=3D2>  Many thanks</FONT></DIV> <DIV> </DIV></BODY></HTML> ------=_NextPart_000_0015_01BF10C0.78834FA0--

↪ replying to =?iso-8859-1?Q?Ant=F3nio_Roque?=

Christian Brauer — Thu, 07 Oct 1999 17:58:25 +0200 — source: Informix-list mailing list archive (1991-1998)

Hallo Antonio, I sent an answer on how to get the available database servers with 4GL last night to this forum. Have a look at your last question for this in the newsgroup, you will find a solution there... Bye, Chris

↪ replying to =?iso-8859-1?Q?Ant=F3nio_Roque?=

Jonathan Leffler — Thu, 07 Oct 1999 20:57:24 -0700 — source: Informix-list mailing list archive (1991-1998)

António Roque wrote: > I'm working with Informix Dynamic Server Version 7.30.FC7 for HP-UX > > 1) Is possible, using only 4gl (no c compiler) before start a > transaction (begin work) to detect if I'm already in one? With no C compiler, you must be using I4GL-RDS. Which version? Actually, not all that important, but since you quote the DBMS version, it would also seem sensible to quote the version number of the product which your questions reference. You can only detect whether you're in a transaction or not reliably and usefully by executing BEGIN WORK and seeing what, if any, error you get. * No transaction available - you weren't in one and you still aren't. * Already in transaction - you were already in one * OK - you are now in a transaction > 2) [...] also would like to know if, using 4gl only, > if I can retrieve the server's names of all my remote databases Not easily - you'd have to run another program which inserted the information into a table in the database you are using. But then you aren't using just 4GL, so NO. > [...snip...] -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.62 -- see http://www.perl.com/CPAN #include <disclaimer.h>

Related threads

Glossary

4GL (Informix-4GL)