hashed file with multiple keys
Posted: Thu Jul 07, 2005 3:43 am
Previously, i'm using a ORACLE OCI8 to load data
with a query a bind variables:
SELECT * FROM SOMETABLE
WHERE :1 BETWEEN FLD1 AND FLD2
AND :2 BETWEEN FLD3 AND FLD4
these are the key fields:
FLD1, FLD2, FLD3, FLD4
field non-key:
FLD5
i have no problem with this...
now, i want to do the same by using a hashed file,
my question is how will i do that with same definition as
the table...
i will use the hashed file for lookups...
thanks
with a query a bind variables:
SELECT * FROM SOMETABLE
WHERE :1 BETWEEN FLD1 AND FLD2
AND :2 BETWEEN FLD3 AND FLD4
these are the key fields:
FLD1, FLD2, FLD3, FLD4
field non-key:
FLD5
i have no problem with this...
now, i want to do the same by using a hashed file,
my question is how will i do that with same definition as
the table...
i will use the hashed file for lookups...
thanks