Re: MOD function in Informix

Path: emory!swrinde!cs.utexas.edu!asuvax!anasaz!qip!briand From: briand@anasaz (Brian Douglass) Newsgroups: comp.databases Message-ID: <1991Aug23.202737.8587@anasaz> Date: 23 Aug 91 20:27:37 GMT References: <sabini.682869536@acf9> Organization: Anasazi, Inc. Phoenix, Az In article <sabini.682869536@acf9> sabini@acf9.nyu.edu (John P. Sabini) writes: >Does informix have a MOD function? A reserve word MOD exists (page D-5) >in the INFORMIX 4GL reference manual that leads me to suspect that >it may be a function (possibly aggragate) in 4GL. >I've looked around and tried some simple programs w/o success. Can >anyone help? >Thanks. >P.S. All i need is a page number in the manuals (we have VERS 4.00 on a unix >box ) and ver 2 or 3 on PC's. I looked through the 4GL manuals (1.10) that against our Online system (4.00), and yes MOD is a reserved word, but there is no reference to in the index. However, looking in my Quickstep Manual (V4.00) there is a reference in section 7, page 126 to available math operators, for which MOD is one of the available. Looks like it is a modulus operator under version 4.00 of 4GL (Quickstep generates 4GL code), and just reserved under earlier version for future use. -- Brian Douglass briand%anasaz.UUCP@asuvax.eas.asu.edu 602-870-3330 X657