According to CLI manual (v8.1)
SQLRETURN SQLBindFileToParam (
SQLHSTMT StatementHandle, /* hstmt */
SQLUSMALLINT TargetType, /* ipar */
SQLSMALLINT DataType, /* fSqlType */
SQLCHAR *FileName,
SQLSMALLINT *FileNameLength,
SQLUINTEGER *FileOptions,
SQLSMALLINT MaxFileNameLength,
SQLINTEGER *IndicatorValue);
FileNameLength
Pointer to the location that will contain the
length of the file name (or an array of lengths)
at the time of the next SQLExecute() or
SQLExecDirect() using the StatementHandle.
If this pointer is NULL, then the FileName will
be considered a null-terminated string, similar
to passing a length of SQL_NTS.
The maximum value of the file name length is
255.
I am experimenting to set FileNameLength pointer to NULL or pass
SQL_NTS but they do not work. The error code is
[IBM][CLI Driver][DB2/SUN] SQL0452N Unable to access the file
referenced by host variable "2". Reason code: "1". SQLSTATE=428A1
Just wondering if anyone has the same problem. Thanks. Shane