From: | Mike Ellsworth <nhrcommu(at)rochester(dot)rr(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Subnovice question |
Date: | 2004-09-13 19:42:55 |
Message-ID: | 4145F661.20BA8104@rochester.rr.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Calling myself a novice would be inflating my skills/knowledge.
My situation and following question:
I have a customer (a Human Resources Department) that requires a
web-based system for the purposes of allowing employees to self-enroll
in their employee benefits of choice. This will not be a problem for
us. Where we will soon be stumped are the following additional
requirements:
#1 That after completion of the web-based enrollment, we provide the
customer's IT department with an EBCIDC file (mixed data types) that
must be packed/zoned for certain of the data fields, according to their
specs. An example would be EMPLOYEE_NMBR, packed, field length
9....0(precision), buffer length 5, buffer position 19.., etc. After we
deliver, their IT department will do their thing to update their system
(AS400, DB2). As near as I can understand, the customer's IT group is
either too busy or too cranky to set up this "web-data collection" on
their own. Apparently there is a hornets nest of intra-company
politics (HR vs IT). I'd rather not be the one to kick the hive.
#2 That we should expect 0 help from IT when it comes to this
"packing/zoning" stuff.
#3 That we leave JDBC/ODBC out of it. IT has no interest.
There are about 75 fields spread across 5 files, a few of which are CHAR
and are not packed/zoned.
We have located (but not purchased) commercial, desktop software that
can get the data from ASCII to EBCIDC, but we are clueless on getting it
packed/zoned correctly. I'd rather not use a service if this particular
wheel has already been invented. We do NOT have access to a AS400/DB2
system.
I have a feeling this whole "packing" thing is left over from the old
days and will probably save < 1 meg of space, but we do not have a
choice.
Any help..... clues.... suggestions? Please use small words. I'm the
salesguy :)
Thanks!
Mike
From | Date | Subject | |
---|---|---|---|
Next Message | Aarni Ruuhimäki | 2004-09-13 19:47:16 | Re: nextval() clarification |
Previous Message | Oliver Elphick | 2004-09-13 19:40:21 | Re: nextval() clarification |