I'm working on a database with numerous small tables containing
codes and code meanings (i.e. key=3, meaning=80386). I was
merrily working along building an sace report (ISQL) when after
I added one more coded table, the report compiled fine, but when I
ran it I got the following error:
Could not open database table (os)
See error number -242
I checked the error in our ISQL ref manual which said, Check the
C-ISAM error for info about the source of the problem. I suspect
I've overstepped the limit on how many files can be open on our Intel
Xenix system simultaneously. Has anyone hit this limitation
before...how to get around it (and still retain my current table
structure - and not have to combine all my little code tables in to
mammoth, more complicated table)??? The offending SQL statement follows:
SELECT
tran_id, sent_status, entry_date, entry_time, poc_uid, poc_ddn_addr,
line_type, poc_phone, hs_type, project_status, computer_type,
cpu_type, os_name, os_version, app_sw,
sw_version_major, sw_version_minor, sw_version_patch,
compiler, c_version, msg_action,
file_type, file_size, file_name, file_description
FROM trans, pstatus, hs, comptype, action, cpu, os
WHERE sent_status = "U" and
trans.h_s = hs_key and
trans.p_status = pstatus_key and
trans.os = os_key and
trans.cpu = cpu_key and
action_type = action_key and
comp_key = platform
END
Thanks in advance for any help you can provide!
--
Greg Sheppard Internet: imop@wa-ngnet.army.mil
(IMO Programmer) UUCP: ...sumax!polari!gcs
Comm: (206) 581-8924 DSN: 355-7924 CIS: 75410,1066
--