Re: Modulus Arithmatic
Posted in 1992
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
> In message <9210051003.aa03784@dmrinc.com> ( Bob Hadden ) wrote: > > > I rarely need to do modulo arithmatic, but I seem to > remember being able to have this capability in Informix. But > I can't seem to find a manual that shows the corect syntax > for this operation in ACE. > This is strictly for SQL, and the SE engine (NO 4GL). > Anyone out there have a simple answer? > > RH. > Failing to find a way to do modulo arithmetic in ACE one can reach the same goal with a C function called by the report program. Write the C function. The functions to be defined in the C program must be declared in the report spec file in the define section. ( Call the function where needed in the report. ) Compile and link using the shell script called cace. A customized version of sacego is created by cace. I have not used this feature but have seen references in the following: 1. INFORMIX-ESQL/C Programmer,s Manual Chapter 6. "C Functions in ACE and Perform". 2. Data Processing in UNIX by R. S. Tare (McGraw-Hill) Chapter 6.2.12 "Interfacing C Functions" -- Art Cooper AT&T Bell Laboratories att!ihlpk!wd9aet 708-979-3049