Subnovice question - Mailing list pgsql-novice

From Mike Ellsworth
Subject Subnovice question
Date
Msg-id 4145F661.20BA8104@rochester.rr.com
Whole thread Raw
Responses Re: Subnovice question
List 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


pgsql-novice by date:

Previous
From: Sandip Bhattacharya
Date:
Subject: Re: nextval() clarification
Next
From: Tim Pushor
Date:
Subject: Newbie Questions