473,324 Members | 2,370 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

SQLBindFileToParam and SQLBindFileToCol

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
Nov 12 '05 #1
0 1109

This thread has been closed and replies have been disabled. Please start a new discussion.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.