GET_CLOB_FROM_FILE

The GET_CLOB_FROM_FILE function returns the data from a source stream file or a source physical file.

Read syntax diagramSkip visual syntax diagramGET_CLOB_FROM_FILE(string-expression ,integer )
string-expression
The argument must be a string expression that specifies a path and file name. The file name may be a name of a source stream file or a source physical file. For a source physical file, the string must be in the form 'library/file(member)'.
integer
An integer constant that specifies how to handle trailing whitespace when the specified file is a source physical file. Valid values are:
If this argument is not specified for a source physical file, the default is 0. If it is specified for a source stream file, it is ignored.

The result of the function is a CLOB locator.

The function will read the file specified by the argument, convert the data to the default job CCSID, and return it as a CLOB locator. The function must be run under commitment control. The locator will be freed when a COMMIT or ROLLBACK is performed.

Examples

Assign the data contained in the source file to host variable HV1. The data will be converted to the default job CCSID and trailing blanks from each line of the source file will be removed.

  SET :HV1 = GET_CLOB_FROM_FILE('MYLIB/MYFILE(MYMBR)',1)