Subnovice question
От | Mike Ellsworth |
---|---|
Тема | Subnovice question |
Дата | |
Msg-id | 4145F661.20BA8104@rochester.rr.com обсуждение исходный текст |
Ответы |
Re: Subnovice question
|
Список | 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 по дате отправления: