Imbedded keys with MF 3.25 on Unix. 
Author Message
 Imbedded keys with MF 3.25 on Unix.

Hello,

We are getting some weird lockups during the loading of a flat file
into an indexed file.  The indexed file has keys setup like the
following:

    01 ALT-KEY-3.
        03 FLD-A                                PIC X(10).
        03 FLD-B                                PIC X(10).
        03 ALT-KEY-2.
            05 FLD-C                            PIC X(10).
            05 FLD-D                            PIC X(10).
            05 ALT-KEY-1.
                07 FLD-E                        PIC X(10).
                07 MAIN-KEY                PIC X(10).

The field names and sizes are just examples.

The select statement had the main key of the file as MAIN-KEY.  This
is the unique key.  There are 3 alternate keys without duplicates as
ALT-KEY-1, ALT-KEY-2, and ALT-KEY-3.

What is you opinion of having keys like this? Is it safe?  

I am suspecting that since our file is very large (appx 1,500,000
records), these embedded keys are causing the load to lock up, and
even corrupt the indexes.

Thanks, and feel free to ask questions.

Paul
--------------------------------------
To reply by email, please take out the
words REMOVETHIS from my email address



Sat, 03 Nov 2001 03:00:00 GMT  
 Imbedded keys with MF 3.25 on Unix.
We have files with similar structures without any problems.

What do you mean by locked up?  Do you get a file status?

How big are your records?  You can't have a file larger than 2gb.  If your
MF is defaulting to lock mode 2 then you can't have shared files larger than
1gb.  These are unix limits.  (I'm assuming you're on unix).  If you have
lock_mode=0 then shared files can also be 2gb.

Rick

Quote:

>Hello,

>We are getting some weird lockups during the loading of a flat file
>into an indexed file.  The indexed file has keys setup like the
>following:

>    01 ALT-KEY-3.
>        03 FLD-A                                PIC X(10).
>        03 FLD-B                                PIC X(10).
>        03 ALT-KEY-2.
>            05 FLD-C                            PIC X(10).
>            05 FLD-D                            PIC X(10).
>            05 ALT-KEY-1.
>                07 FLD-E                        PIC X(10).
>                07 MAIN-KEY                PIC X(10).

>The field names and sizes are just examples.

>The select statement had the main key of the file as MAIN-KEY.  This
>is the unique key.  There are 3 alternate keys without duplicates as
>ALT-KEY-1, ALT-KEY-2, and ALT-KEY-3.

>What is you opinion of having keys like this? Is it safe?

>I am suspecting that since our file is very large (appx 1,500,000
>records), these embedded keys are causing the load to lock up, and
>even corrupt the indexes.

>Thanks, and feel free to ask questions.

>Paul
>--------------------------------------
>To reply by email, please take out the
>words REMOVETHIS from my email address



Sun, 04 Nov 2001 03:00:00 GMT  
 Imbedded keys with MF 3.25 on Unix.
Thanks for the reply.

We found the problem was due to some corrupted input records.

Paul

On Wed, 19 May 1999 10:03:38 +0100, "Rick Price"

Quote:

>We have files with similar structures without any problems.

>What do you mean by locked up?  Do you get a file status?

>How big are your records?  You can't have a file larger than 2gb.  If your
>MF is defaulting to lock mode 2 then you can't have shared files larger than
>1gb.  These are unix limits.  (I'm assuming you're on unix).  If you have
>lock_mode=0 then shared files can also be 2gb.

>Rick

--------------------------------------
To reply by email, please take out the
words REMOVETHIS from my email address


Mon, 05 Nov 2001 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. tk4.0b3 failing color test on AIX 3.25

2. mf cobol/animate/alt-f10 key on a hp/unix

3. MF COBOL animator function keys in an XTERM

4. MF WB 4007 security key

5. MF - keys not detected

6. HELP! Function Keys and Mouse in MF COBOL

7. MF Cobol & ibm3151 Delete EOL key

8. MF Cobol/2 V1.3 for SCO UNIX

9. Chicago MF COBOL/Unix Openings

10. MF, Unix, and Memory

11. MF Cobol/Unix/Menus - HELP!

12. Help with MF Cobol/Unix/EOF Condition

 

 
Powered by phpBB® Forum Software