Re: CX parameter of the connection string

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: CX parameter of the connection string
Дата
Msg-id 3D3D190F.10B25858@tpf.co.jp
обсуждение исходный текст
Список pgsql-odbc
SSY wrote:
>
> Thank you very much, but how this substitution can be realized?
> What order of this options? How can this options be encrypted to the CX
> parameter?

For example, I can see CX=188303a8 in your posting.
The first 2 bytes are contant(18) which represents the
count of effective bits of the subsequent flag.

The bits of the flag represents the following.
<The least siginificant bit>
    LF <-> CR/LF conversion
    Updatable Cursors
    Disallow Premature
    Recognize Unique Index
    PROTOCOL 6.3
    PROTOCOL 7.X,6.4
    Unknown Sizes(Don't know)
    Unknown Sizes(Maximum)
    Disable Generic Optimizer
    KSQO
    CommLog
    MyLog
    Parse Statements
    Cancel as FreeStmt
    Use Declare/Fetch
    Read Only
    Text As LongVarChar
    Unknowns as LongVarChar
    Bools as Char
    Row Versioning
    Show System Tables
    Oid Options(Show Column)
    Oid Options(Fake Index)
    True is -1
<The most siginificant bit>

For example,
  8303a8 : 0001 0101 1100 0000 1100 0001

represents
    UNIQUE_INDEX
    6.4/7.x, Unknowns As Max
    Disable Generic Optiomizer, KSQO
    Text As LongVarChar, Unknown As LongVarChar
    True is -1

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/
>
> > You can substitute the CX parameter for the following options.
> >
> > Disable Genereic Optiomizer
> > CommLog
> > KSQO
> > Parse Statements
> > Recognize Unique Index
> > Cancel As FreeStmt
> > Usen Declare/Fetch
> > MyLog
> > Unknown Sizes
> > Text as LongVarChar
> > Unknowns as LongVarChar
> > Bools as Char
> >
> > Read Only
> > Row Versioning
> > Show System Tables
> > Disallow Premature
> > LF <-> CR/LF conversion
> > True is -1
> > Updatable Cursors
> > Protocol
> > Oid options(Show column, Fake Index)
> >
> > regards,
> > Hiroshi Inoue
> > http://w2422.nsk.ne.jp/~inoue/

В списке pgsql-odbc по дате отправления:

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: Problem updating multiline varchar with VB6 and ODBC
Следующее
От: Laura Castro
Дата:
Сообщение: COPY alternative?