Re: getting login name in 4GL
Posted in 1996
Tim if you are trying to get login information for use of Informix 7.x DB, then access the sysmaster DB! IF it is not there you have NO ONLINE or the Informix system has crashed. Of course I beleive this only applies to Informix 6/7 Online (I'm sure of 7 Online). Someone with a 6 Onlne,6SE or 7SE could verify this for you! "SYSMASTER" is the "GOD DB" for 7 Online without it you have no Online! ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR kendric@gwysmtp.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Thu, 9 May 1996, Tim Schaefer wrote: } Perry Dillard wrote: } > } > You don't need to do all that garbage. The following has _always_ } > worked starting with version 1.10.03. } > } > select user from systables where tabid = 1; } > } > -perryd (Guru) } > } > ==================================================================== } > = Perry Dillard - Chief Architect Direct Dial: (206)517-6430 = } > = FourGen Software, Inc. FAX: (206)522-0054 = } > = FourGen Building Tech. Support: (800)444-3398 = } > = 115 NE 100th Street Sales: (800)333-4436 = } > = Seattle, W.A. 98125-8098 = } > = e-mail: perryd@fourgen.com Web Site http://www.fourgen.com = } >==================================================================== } GURU, CHIEF, LORD OF FOURGEN, OH-MOST-HIGH, } } Your solution always works for you. But I would never depend on a } data base to give me system information regarding a login. The way } things are now with system security a gap in real-time information is } all that's needed to hack a system. } } GURU: Good Understanding Relatively Useless. } } By the way, will you folks be coming out with a Java Tool Kit soon? } I hope so, you might be out of work 'fore too long... } } :-) } } } -- } \\\\|// } (6 6) } ==============================---o00--(_)--00o---============================ } Tim Schaefer http://www.shadow.net/~tschaefe } The Computer Business Company, Inc. tschaefe@shadow.net } ============================================================================= } }