RE: [sqr-users] access to KSAM-file

["Steve Cavill" <steve.cavill@infoclarity.com.au>]

SQR can only read flat files sequentially.

If the file is indexed, then I would check to see if there is a SQL
interface to the file, and use standard SQL Select to access it (with a
where clause).

If there is no SQL interface, check if there is a operating system level
command or write a C program and call that from SQR with CALL SYSTEM USING

Cheers, Steve.

-----Original Message-----
From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
[mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On
Behalf Of Martin, Annerose
Sent: Thursday, 8 April 2004 8:11 PM
To: 'Sqr-Users (E-mail)
Subject: [sqr-users] access to KSAM-file


Hello,

is there any possibility to access a KSAM (key sequenced/index) file, a
very big file on a fast kind of way:
I have to check the validity of an employee-number against a very big
personal-file and it takes very long

many thanks

  Annerose Martin





_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users