HP3000-L Archives

October 2017, Week 1

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
"James B. Byrne" <[log in to unmask]>
Reply To:
Date:
Thu, 5 Oct 2017 14:53:58 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (86 lines)
On Thu, October 5, 2017 14:39, Santucci, Patrick wrote:
> I tend to think Neil Armstrong is on the right track.
>
> IIRC, the default when extracting data with QTP from a KSAM/XL file is
> in key (index) order. That might explain the difference in what you're
> seeing.
>
> What does a LISTFILE,5 or LISTFILE,7 show?
>
>

:listfile acctk02d.data,5
********************
FILE: ACCTK02D.DATA.HARTLYNE

FILE CODE : 0                   FOPTIONS: ASCII,FIXED,NOCCTL,KSAMXL
BLK FACTOR: 4                   CREATOR : **
REC SIZE: 62(BYTES)             LOCKWORD: **
BLK SIZE: 4096(BYTES)           SECURITY--READ    : ANY
EXT SIZE: 0(SECT)                         WRITE   : ANY
NUM REC: 10638                            APPEND  : ANY
NUM SEC: 9216                             LOCK    : ANY
NUM EXT: 2                                EXECUTE : ANY
MAX REC: 11500                          **SECURITY IS ON
                                FLAGS   : 1 ACCESSOR,SHARED,1 R,1 W
NUM LABELS: 0                   CREATED : SUN, MAY  7, 1995,  9:13 PM
MAX LABELS: 0                   MODIFIED: MON, OCT  2, 2017,  2:39 PM
DISC DEV #: 2                   ACCESSED: THU, OCT  5, 2017,  2:41 PM
SEC OFFSET: 0                   LABEL ADDR: **
VOLSET    : HAL_DATA

KEY         KEY TYPE            KEY LOCATION      KEY SIZE   DUP/RDUP
---         --------            ------------      --------   --------
  1         BYTE                           1            30   RDUP
  2         BYTE                          31             8   RDUP
  3         BYTE                          39            20   RDUP

NUM KSAM KEYS: 3                               FIRST KSAM RECORD: 0
LANGUAGE     : NATIVE-3000                     REUSE RECORD     : YES
PRIMARY KEY  : RANDOM                          COMPUTE BLK SIZE : DEFBLK
VERSION      : 2


:listfile acctk02d.data,7
********************
FILE: ACCTK02D.DATA.HARTLYNE


KEY         KEY TYPE            KEY LOCATION      KEY SIZE   DUP/RDUP
---         --------            ------------      --------   --------
  1         BYTE                           1            30   RDUP
  2         BYTE                          31             8   RDUP
  3         BYTE                          39            20   RDUP

NUM KSAM KEYS: 3                               FIRST KSAM RECORD: 0
LANGUAGE     : NATIVE-3000                     REUSE RECORD     : YES
PRIMARY KEY  : RANDOM                          COMPUTE BLK SIZE : DEFBLK
VERSION      : 2                               DATA BLOCK SIZE  : 4096


-- 
***          e-Mail is NOT a SECURE channel          ***
        Do NOT transmit sensitive data via e-Mail
 Do NOT open attachments nor follow links sent by e-Mail

James B. Byrne                mailto:[log in to unmask]
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3


-- 
***          e-Mail is NOT a SECURE channel          ***
        Do NOT transmit sensitive data via e-Mail
 Do NOT open attachments nor follow links sent by e-Mail

James B. Byrne                mailto:[log in to unmask]
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2