I've created a routine to import data saved in a text file where each row in the file is a record to be saved in an OI hash file. The goal is to create and save the OI files into the D:\RevSoft\OInsight10\M2K_DATAVOL folder.

the following local subroutine is used to create the OI file and dictionary.

tableName = 'ARH'

Database = 'M2K'

create_OI_File:

 m2kPath = 'M2K_DATAVOL' ; * this is a folder in d:\RevSoft\OInsight10

 Call Get_Status(0)

 attribs = '1000,500,5,2048,80'

 Call Create_table(m2kpath, tableName, 1, Database, '', 0) ; * create dictionary

 If Get_Status(err) Then

    errMsg<1,-1> = err

    errMsg<1,-1> = 'unable to create dict ':tablename

 End Else

    Call Create_table(m2kpath, tableName, 0, Database, attribs, 0) ; * create file

    If Get_Status(err) Then

       errMsg<1,-1> = err

       errMsg<1,-1> = 'Unable to create ':tableName

    End

 End

 If errMsg = '' then

    call attach_table(m2kpath,tableName,Database)

    If Get_Status(err) Then

       errMsg<1,-1> = err

       errMsg<1,-1> = 'Unable to attach to table ':tableName:' in ':m2kPath

    End

 End

Return

The import routine successfully added 261,775 rows to the OI10 ARH file. This was determined with a COUNT ARH.

Per the Database Utility in the left pane with the Toolbox, the M2K_DATAVOL folder exists as well as the table ARH. That tables file name is REV57030 and the Dictionary name is REV57029.

Choosing the Add Tables option and entering D:\REVSOFT\OINSIGHT10\M2K_DATAVOL in the "Specify the Volume containing the tables you want to attach:" prompt, it includes "ARH*M2K" in the Available Tables column

Using Windows Explorer:

The D:\RevSoft\OInsight10\M2K_DATAVOL folder is empty.

The REV57030 files do not exist in D:\RevSoft\OInsight10 or its sub-folders.

The REV57030 file does not exist anywhere on the D-drive.,

Where might I find these files.

Mike Daniel

480-699-0212

Off hand this looks like Windows Folder Redirection, but your OI path doesn't seem like it would be a part of redirection.

Is your UD configured for redirection? What does the REVPARAM file look like?

Don Bakke

SRP Computer Solutions, Inc.

OMG - wow… yes indeed. The system I'm running this is nhcdev yet line two in revparam is referencing a different system name - t430. And sure enough, it is there where the files reside.

Thank you!

Mike Daniel

480-699-0212

View this thread on the Works forum...