Description

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

Syntax

Copy_Row_To_OS (scrtablename, scrkeylist, destfilelist, overwriteflag, convertflag, lockflag)

Parameters

The Copy_Row_To_OS routine has the following parameters.

ParameterDescription
scrtablenameSpecifies the name of the source table.
scrkeylistSpecifies a list of source keys to copy to operating system files. A one-to-one correspondence must exist between destfilelist and scrkeylist.
 Note: If more than one rows are to be copied, separate the keys with field marks.
destfilelistSpecifies a destination operating system file or list of destination files. The file name includes the operating system drive and path. A one-to-one correspondence must exist between destfilelist and scrkeylist.
 If destfilelist is null, scrkeylist is used; the default directory is the OpenInsight directory.
overwriteflag

Determines whether or not to overwrite existing rows.

ValueDescription
0Do not overwrite (default).
1Only replace an existing file. If the destination file does not exist, then skip the row.
2Write this file, unconditionally. If the destination file exists, overwrite it.
convertflag

convertflag determines whether or not to convert field marks to carriage return/linefeed characters. If convertflag is null, the default is to perform the conversion (0). When copying compiled scripts or other binary data, always suppress the conversion by setting the convertflag.

ValueDescription
0Perform conversion (default).
1Do not perform conversion.
lockflag

Determines whether or not to lock the source rows and destination files during the copy operation.

ValueDescription
0No locking (default).
1Lock.

See also

Copy_OS_To_RowCopy_Row

Example (from System Monitor)

The following example illustrates how to copy OpenInsight rows to operating system files from the command line:

run Copy_Row_To_OS "SYSOBJ", "$TEST_PROC", "C:\DAT\PROC1","", 1
  • No labels