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