guides:programming:programmers_reference_manual:copy_os_to_row

Copy_OS_To_Row routine

Copies one or more operating system files to a native table.

Copy_OS_To_Row(srcfilelist, desttablename, destkeylist, overwriteflag, convertflag, lockflag)

The Copy_OS_To_Row routine has the following parameters.

ParameterDescription
srcfilelistSpecifies an operating system file or list of files. The file name includes the operating system drive and path.
desttablenameSpecifies the name of the destination table.
destkeylistSpecifies a list of destination keys. If destkeylist is null, srcfilelist is used. A one to one correspondence must exist between srcfilelist and destkeylist.
overwriteflagDetermines whether or not to overwrite existing rows in desttablename.

Value Description
0 - Do not overwrite (default).
1 - Only replace an existing row. If the destination row does not exist, then skip it.
2 - Over-write rows, unconditionally.
convertflagDetermines whether or not to convert carriage return/linefeed characters to field marks. If null, the default is to perform the conversion (0). ctrl+z is converted to null. When copying compiled scripts or other binary data, always suppress the conversion by setting the convertflag.

Value Description
0 - Perform conversion (default).
1 - Do not perform conversion.
lockflagDetermines whether or not to lock the DOS source files and destination rows during the copy operation.

Value Description
0 - No locking (default).
1 - Lock.
The following example illustrates how to copy operating system files to OpenInsight tables from the command line:

run Copy_OS_To_Row "C:\AUTOEXEC.BAT", "SYSPROCS", "AUTOEXEC", 2
  • guides/programming/programmers_reference_manual/copy_os_to_row.txt
  • Last modified: 2024/06/19 20:20
  • by 127.0.0.1