Re: Accounting/Payroll uses for Informix??
In article <2ms2co$qv4@msuinfo.cl.msu.edu>, decello@discovery.uucp (Joseph P DeCello III) writes:
|>
|> I'm going to attempt to setup an Informix database to do our payroll
|> and accounting for us (well just help track the data, and do reports).
|>
|> Has anyone used Informix for this type of purpose? We looked at a few
|> commercial packages, but none were flexible enough to suit our needs.
|>
|> We need to be able to track time/materials/etc for projects, each with
|> a unique number. Some projects may be charged to serveral accounts.
|>
|> I'm sure that with enough time, this can be done, and I plan to use 4GL
|> and/or viewpoint for the user interfaces.
|>
|> My views may change as I become more aware of Infomix and it's client
|> applications.
|>
|> Has anyone applied Informix in this manner? We may even be interested
|> in having a consultant with a proven track record in this type of development
|> come in and set it up.
|>
|> Any comments appreciated!
|>
|>
|> --
|> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
|> Joseph P. DeCello III **Computer Asst.** Email: decello@cad.msu.edu
|> Michigan State University CPP Phone: (517) 355-9582
|> Dept. of Campus Park and Planning hours: MWF 8-11,2-4 EDT
Yes I have had experience in the past working for a software house writing accounts packages, payroll etc.
I have found Informix 4gl to be excellent for this type of work. One important concept that i4gl has is Transaction Processing.
However I had to write a number rouding function because this was missing from the informix functions.
You can use the SERIAL field in informix to generate a unique number upon inserting a record into a table. You can then find out the number just generated
and then use this as to join any other tables of information to your project.
See example code below:
DEFINE p_proj_no INTEGER # Must be an INTEGER to hold a SERIAL value.
CREATE TABLE project
( proj_no SERIAL,
proj_desc CHAR(30),
etc..
);
## Note inserting a zero causes the next number to be used.
INSERT INTO project VALUES (0, "The project name", etc..);
## Pickup the last serial generated in the last INSERT.
LET p_proj_no = SQLCA.SQLERRD[2]
--
Mark J. Twomey, |
Motorola B.V. | m___
Swords, | @=" )~~ Pig Out !
County Dublin, | W W
Ireland, |
Europe. email at mjt@email.mot.com +----------------------------------