SQLOverrideCCSID400()--Override SQL CLI CCSID for IBM PASE for i
Syntax
#include <as400_protos.h> int SQLOverrideCCSID400(int newCCSID);
Default Public Authority: *USE
Library: IBM PASE for i SQL CLI Library (libdb400.a)
Threadsafe: Yes
Note: This function can only be used in an IBM® i PASE program. See the IBM PASE for i topic collection for more information about creating IBM PASE for i programs.
The SQLOverrideCCSID400() function allows an IBM PASE for i program to specify a Coded Character Set Identifier (CCSID) used to convert character data arguments and results on IBM PASE for i SQL Call Level Interface (CLI) functions.
Parameters
- newCCSID
- (Input) Specifies the CCSID used for IBM PASE for i SQL CLI functions.
Authorities
No special authorities required.
Return Value
The function result is zero for success, or -1 for an error that is further qualified by an errno value.
Error Conditions
At least these errno values can be returned:
[EINVAL] | The conversion between newCCSID and the IBM i
job default CCSID is not supported. |
[ENFILE] | A converter could not be opened because the
maximum number of files in the system are already opened. |
[EMFILE] | A converter could not be opened because the maximum number of files are already opened. |
Usage Notes
- The system automatically converts character arguments and results between the CCSID of the job or database field and a CCSID used for IBM PASE for i SQL CLI functions that defaults to the IBM PASE for i CCSID value in effect when the first IBM PASE for i SQL CLI function is called. You must call SQLOverrideCCSID400 before any other IBM PASE for i SQL CLI function, or it will have no effect on CCSID conversions.
API introduced: V4R5