Re: Layout Hell.
From: Robert Wagner (robert.deletethis_at_wagner.net)
Date: 07/17/04
- Next message: Richard Steiner: "Re: "Every Shop Has Some Assembler Somewhere" - course update"
- Previous message: Robert Wagner: "Re: In answer to RW - again (was: Sorts (revised)"
- In reply to: Carol: "Re: Layout Hell."
- Next in thread: Carol: "Re: Layout Hell."
- Reply: Carol: "Re: Layout Hell."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Sat, 17 Jul 2004 00:01:49 GMT
"Carol" <kgdg@helkusa.com> wrote:
>I add these up and I get 201.
>
>My block length is 32600 for sure.
>that divides by 200 * 163
>but not 201
>
>what do I do?
Length of the third field is 2, not 4, so the record length is 199. Look at the
data to see how long records are. It should be easy to spot CO-NO, which appears
to be a constant or at least the same for several records.
I used to process 1-10 requests per week for such conversions. I charged a flat
rate of $50 per, with possible discount to $25 if they could supply a copybook.
They almost never could. Instead they sent a text document that management
thought was usable.
>"JerryMouse" <nospam@bisusa.com> wrote in message
>news:FfWdnajyuePaoGrdRVn-hw@giganews.com...
>> Carol wrote:
>> > Hi,
>> > Could I have some help with this layout?
>> > I am new to the layout scene, but if I could see some real examples,
>> > I might get it. Then again, I might club myself with a shovel.
>> > Thank you.
>> > I just need to convert this file to Access or something normal.
>>
>> No you don't. It's already more normal than anything to which you could
>> convert it.
>>
>> > Do you have any thoughts?
>>
>> I have placed the number of bytes each field uses (usually, beware of
>> compiler dependencies) in square brackets. If that's insufficient, come
>back
>> with more specific questions.
>>
>> (P.S., "77" levels are not involved in the record. They may be ignored for
>> this purpose.)
>>
>> > Thanks you.
>> >
>> > 01 WWICTLG.
>> > 10 CTLGOP-CO-NO PIC X(3). [3]
>> > 10 CTLGCONTROL-SET-SEQ-NO PIC S9(9) USAGE COMP. [4]*
>> > 10 CTLGINVOICE-SEQ-NO PIC S9(4) USAGE COMP. [4]*
>> > 10 CTLGAP-CNTRL-ENTITY-CD PIC X(4). [4]
>> > 10 CTLGINVOICE-TYPE-CD PIC X(2). [2]
>> > 10 CTLGLEGACY-VENDOR-NO PIC X(10). [10]
>> > 10 CTLGAP-VENDOR-NO PIC X(30). [30]
>> > 10 CTLGAP-PO-NO PIC X(30). [30]
>> > 10 CTLGAP-INVOICE-NO PIC X(30). [30]
>> > 10 CTLGINVOICE-DT PIC X(10). [10]
>> > 10 CTLGTOTAL-INVOICE-AM PIC S9(11)V9(2) USAGE COMP-3.
>> [7]**
>> > 10 CTLGTOTAL-MERCH-AM PIC S9(11)V9(2) USAGE COMP-3.
>[7]
>> > 10 CTLGTERMS-CD PIC X(2). [2]
>> > 10 CTLGCARRIER-CD PIC X(10). [10]
>> > 10 CTLGCARRIER-PRO-NO PIC X(10). [10]
>> > 10 CTLGSHIP-DT PIC X(10). [10]
>> > 10 CTLGSHIP-VIA-CD PIC X(3). [3]
>> > 10 CTLGSHIP-LOC-NO PIC X(3). [3]
>> > 10 CTLGSHIP-WT PIC X(10). [10]
>> > 10 CTLGSHIP-UNITS-DC PIC X(10). [10]
>> > 10 CTLGSHIP-TY PIC X(2). [2]
>>
>> * = Binary Fullword, 4 bytes because of its size (>4 digits)
>> ** = Packed Decimal (number-of-digits + 1) / 2. No other database system
>> uses Packed Decimal. You have your work cut out to convert to a "normal"
>> number.
>>
>>
>
>
- Next message: Richard Steiner: "Re: "Every Shop Has Some Assembler Somewhere" - course update"
- Previous message: Robert Wagner: "Re: In answer to RW - again (was: Sorts (revised)"
- In reply to: Carol: "Re: Layout Hell."
- Next in thread: Carol: "Re: Layout Hell."
- Reply: Carol: "Re: Layout Hell."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
