Skip to main content

double primary keys in indexed files

  • June 5, 2024
  • 3 replies
  • 0 views

Hi,

we are currently migrating a big application from BS2000 mainframe to linux using MF Visual COBOL V9.

There are indexed data files that contain 2 identical data sentences (completely identical - indentical primary key aswell) in mainframe. Is there any chance in MF VC to use ISAM files with non unique primary keys?

Thanks in advance!

Paul


#Mainframe
#COBOLMigration
#ISAM
#VisualCOBOL

3 replies

Chris Glazier
Forum|alt.badge.img+2
  • Moderator
  • 3697 replies
  • June 5, 2024

Hi,

we are currently migrating a big application from BS2000 mainframe to linux using MF Visual COBOL V9.

There are indexed data files that contain 2 identical data sentences (completely identical - indentical primary key aswell) in mainframe. Is there any chance in MF VC to use ISAM files with non unique primary keys?

Thanks in advance!

Paul


#Mainframe
#COBOLMigration
#ISAM
#VisualCOBOL

Can you please show me what your SELECT statement looks like?


  • 0 replies
  • June 6, 2024

Can you please show me what your SELECT statement looks like?

Hi Chris,

the SELECT statement looks like this:

SELECT DAT
ASSIGN TO "$DAT"
ORGANIZATION IS INDEXED
RECORD KEY IS SORT-KEY
DUPLICATES.

Writing two identical scentences works in this case but reading is a problem.

Paul


  • 0 replies
  • June 6, 2024

Hi Chris,

the SELECT statement looks like this:

SELECT DAT
ASSIGN TO "$DAT"
ORGANIZATION IS INDEXED
RECORD KEY IS SORT-KEY
DUPLICATES.

Writing two identical scentences works in this case but reading is a problem.

Paul

We solved the problem. It seems to work now. Thank you! Ticket can be closed