1

A

Req

The LANSA File Name

1

10

2

A

Opt

Output File Path/Name

Default Value = ....\X_ppp\source\<File Name>.dat

1

256

3

A

Opt

Y\N Check for OAM

Default = N

1

1

4

A

Opt

Unload BLOB and CLOB fields.
Default = N, meaning BLOB and CLOB are unloaded as their default (*SQLNULL).
If Y, if BLOB or CLOB fields exist on the file and are not Null, they are unloaded to files in the same directory as the output file (Arg 2), with the naming convention FileName_Field_DiskFile.ext (where DiskFile.ext is the disk file name saved in the table for the LOB).

1

1

5

A

Opt

Perform a Commit to release any database locks that the database may leave as part of this operation.

Default = N, for backward compatibility.
Y will release any database table locks.

Sybase leaves a database table locked at the end of this operation. This blocks dropping the table.

Set this value to Y to release the database table lock so that the table can be dropped, for example, by REBUILD_FILE.

1

1

6

A

Opt

CTD Location Level
A= All (Partition + System).
P = Partition Level only.
S=System Level only.

Default is A.

1

1

1

A

Req

Return Code:
OK = File successfully unloaded
ER = File unload failed (possible causes - invalid path, out of space on disk drive).
NT = No table exists
NO = No OAM. File does not exist or is not compiled.

NO only returned when input option 3 is set to Y.

2

2

2

L

Opt

Working list of files created for unloaded BLOB and CLOB files

256

256