SetBindOption()


" "

short SetBindOption(BSTR CollectionName, BSTR PackageName, short Option, short Value)

Description

This function sets options for the collection and package prior to calling EndBind().

Parameters

Name Description
CollectionName The collection ID of the package for which you want to set the bind options.
PackageName The name of the package for which you want to set the bind options.
Options:




DDM_PKGRPLOPT
(0x211C)
Flag specifying whether to replace an existing package with the same collection ID and name.
DDM_PKGRPLALW (0x241F)
Yes
DDM_PKGRPLNA (0x2420)
No
DDM_STTDECDEL
(0x2121)
The delimiter used for the decimal point in SQL statements in the package.
DDM_DECDELPRD (0x243C)
Period
DDM_DECDELCMA (0x243D)
Comma
PKGRPLNA (0x2420)
No
DDM_STTSTRDEL
(0x2120)
The delimiter used for string values in SQL statements in the package.
DDM_STRDELAP (0x2426)
Apostrophe
DDM_STRDELDQ (0x2427)
Double Quote
DDM_PKGISOLVL
(0x2124)
The isolation level for the package.
DDM_ISOLVLALL (0x2443)
All
DDM_ISOLVLCHG (0x2441)
Change
DDM_ISOLVLCS (0x2442)
Cursor
Stability
DDM_ISOLVLNC (0x2445)
No Commit
DDM_ISOLVLRR (0x2444)
Repeatable Read
DDM_PKGATHOPT
(0x211E)
Flag specifying whether to keep existing authorizations on the package.
DDM_PKGATHKP (0x2425)
Keep
DDM_PKGATHRVK (0x2424)
Revoke
DDM_QRYBLKCTL
(0x2132)
The method to use when fetching rows of data for queries in the package.
DDM_FIXROWPRC (0x2418)
Row at a time
DDM_LMTBLKPRC (0x2417)
Block at a time
DDM_RDBRLSOPT
(0x2129)

When to release database resources acquired when running the package.
DDM_RDBRLSCMM (0x2438)
Commit
DDM_RDBRLSCNV (0x2439)
Conversation deallocation
DDM_STTDATFMT
(0x2122)

Format for retrieved date values.
DDM_ISODATFMT (0x2429)
ISO
DDM_USADATFMT (0x242A)
US
DDM_EURDATFMT (0x242B)
European
DDM_JISDATFMT(0x242C)
Japanese Industrial Standard
DDM_STTTIMFMT
(0x2123)
Format for retrieved time values.
DDM_ISOTIMFMT (0x242E)
ISO
DDM_USATIMFMT (0x242F)
US
DDM_EURTIMFMT (0x2430) 
European
DDM_JISTIMFMT(0x2431) 
Japanese Industrial Standard

Return Value

Return value will be zero if successful or non-zero if unsucessful. If the return value is non-zero, you can call GetLastErrorString() or GetLastErrorType() to get additional error information.

Related Tasks

EndBind()
SetBindOwner()