VTI - HOW????

I have IDS 10.0 and I've read about VTI (Virtual Table Interface). From what I read, I would believe I would have it. But WHERE. In dbaccess I cannot "create access method" which is presumable essential to get it working./ It seems an excellent feature but I can't find anything on WHERE it even resides!.

I am not sure what errors you get when you try and create the VTI but this should get you started. VTI Manual http://publib.boulder.ibm.com/epubs/pdf/25123030.pdf -- Need to create a function for each vti purpose function. create function informix.myvti_open(informix.pointer) returning int with (parallelizable) external name '$USERFUNCDIR/my_vti.udr(ft_open_table)' language C; ---Create the access method create primary access_method informix.hash( am_create=informix.myvti_create, am_open=informix.myvti_open, am_close=informix.myvti_close, am_insert=informix.myvti_insert, am_update=informix.myvti_update, am_delete=informix.myvti_delete, am_scancost=informix.myvti_scancost, am_beginscan=informix.myvti_beginscan, am_rescan=informix.myvti_rescan, am_getnext=informix.myvti_getnext, am_getbyid=informix.myvti_getbyid, am_rowids, am_readwrite, am_sptype='x'); John Miller kjuliff@gmail.com wrote: > I have IDS 10.0 and I've read about VTI (Virtual Table Interface). From > what I read, I would believe I would have it. But WHERE. In dbaccess I > cannot "create access method" which is presumable essential to get it > working./ It seems an excellent feature but I can't find anything on > WHERE it even resides!. >

Thanks John, but I cannot see where the external physical file is mapped here? How does it know WHAT to open? Kate