Magic User Group

Magic Wiki-Wakka : PervasiveODBCfileDDF

HomePage :: CATEGORIES | Index :: Changes :: Comments :: Search :: Login/Register

DDF File Import


Create a database with name CTL and import

VRSN=830
APPLICATION=N
ISN=N

FILE={NAME="file.ddf",DESC="file_ddf",ACCKEY="..SC....",DBNAME="CTL",ENCR=N,SIZ=78,RESIDENT=78,HAS_HINT=Y,CURSOR=D,CHECK_EXIST=D,FTYPE=T,POSITION=D,
FLD={DESC="FILE_file id",PIC="4",STRG=5,ATTR=N,SIZ=2,WHLE=4,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="    100000,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
FLD={DESC="FILE_file name",PIC="20",STRG=1,ATTR=A,SIZ=20,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="    100000,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
FLD={DESC="FILE_file loc",PIC="64",STRG=1,ATTR=A,SIZ=64,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="    100000,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
FLD={DESC="FILE_flags",PIC="3",STRG=5,ATTR=N,SIZ=1,WHLE=3,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="    100000,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
FLD={DESC="FILE_filler",PIC="10",STRG=1,ATTR=A,SIZ=10,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="    100000,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
KEY={DESC="key 1(id)",MOD=S,DIR=T,RNG=Q,KEY_TYPE=R,HAS_HINT=Y,CLUSTER=N,DROP_IN_REINDEX=N,
SEG={SIZ=2,FLD=1,DIR=A}},
KEY={DESC="key 2(name)",MOD=S,DIR=T,RNG=Q,KEY_TYPE=R,HAS_HINT=Y,CLUSTER=N,DROP_IN_REINDEX=N,
SEG={SIZ=20,FLD=2,DIR=A}}}
FILE={NAME="field.ddf",DESC="field_ddf",ACCKEY="..SC....",DBNAME="CTL",ENCR=N,SIZ=78,RESIDENT=78,HAS_HINT=Y,CURSOR=D,CHECK_EXIST=D,FTYPE=T,POSITION=D,
FLD={DESC="FIELD_field id",PIC="4",STRG=5,ATTR=N,SIZ=2,WHLE=4,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="    100000,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
FLD={DESC="FIELD_file id",PIC="4",STRG=5,ATTR=N,SIZ=2,WHLE=4,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="    100000,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
FLD={DESC="FIELD_field name",PIC="20",STRG=1,ATTR=A,SIZ=20,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="    100000,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
FLD={DESC="FIELD_bt data type",PIC="3",STRG=5,ATTR=N,SIZ=1,WHLE=3,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="    100000,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
FLD={DESC="FIELD_offset",PIC="5",STRG=5,ATTR=N,SIZ=2,WHLE=5,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="    100000,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
FLD={DESC="FIELD_size",PIC="5",STRG=4,ATTR=N,SIZ=2,WHLE=5,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="    100000,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
FLD={DESC="FIELD_decimals",PIC="3",STRG=5,ATTR=N,SIZ=1,WHLE=3,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="    100000,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
FLD={DESC="FIELD_flags",PIC="3",STRG=4,ATTR=N,SIZ=2,WHLE=3,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="    100000,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
KEY={DESC="key 1(field id)",MOD=S,DIR=T,RNG=Q,KEY_TYPE=R,HAS_HINT=Y,CLUSTER=N,DROP_IN_REINDEX=N,
SEG={SIZ=2,FLD=1,DIR=A}},
KEY={DESC="key 2(file id)",MOD=N,DIR=T,RNG=Q,KEY_TYPE=R,HAS_HINT=Y,CLUSTER=N,DROP_IN_REINDEX=N,
SEG={SIZ=2,FLD=2,DIR=A}},
KEY={DESC="key 3(field name)",MOD=N,DIR=T,RNG=Q,KEY_TYPE=R,HAS_HINT=Y,CLUSTER=N,DROP_IN_REINDEX=N,
SEG={SIZ=20,FLD=3,DIR=A}},
KEY={DESC="key 4(file id+field",MOD=S,DIR=T,RNG=Q,KEY_TYPE=R,HAS_HINT=Y,CLUSTER=N,DROP_IN_REINDEX=N,
SEG={SIZ=2,FLD=2,DIR=A},
SEG={SIZ=20,FLD=3,DIR=A}},
KEY={DESC="key 5(fi+offset+dec)",MOD=N,DIR=T,RNG=Q,KEY_TYPE=R,HAS_HINT=Y,CLUSTER=N,DROP_IN_REINDEX=N,
SEG={SIZ=2,FLD=2,DIR=A},
SEG={SIZ=2,FLD=5,DIR=A},
SEG={SIZ=1,FLD=7,DIR=A}}}
FILE={NAME="index.ddf",DESC="index_ddf",ACCKEY="..SC....",DBNAME="CTL",ENCR=N,SIZ=78,RESIDENT=78,HAS_HINT=Y,CURSOR=D,CHECK_EXIST=D,FTYPE=T,POSITION=D,
FLD={DESC="INDEX_file id",PIC="4",STRG=5,ATTR=N,SIZ=2,WHLE=4,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="    100000,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
FLD={DESC="INDEX_field id",PIC="5",STRG=5,ATTR=N,SIZ=2,WHLE=5,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="    100000,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
FLD={DESC="INDEX_key number",PIC="2",STRG=5,ATTR=N,SIZ=2,WHLE=2,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="    100000,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
FLD={DESC="INDEX_key segment",PIC="2",STRG=5,ATTR=N,SIZ=2,WHLE=2,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="    100000,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
FLD={DESC="INDEX_flags",PIC="5",STRG=5,ATTR=N,SIZ=2,WHLE=5,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="    100000,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
KEY={DESC="key 1(file id)",MOD=N,DIR=T,RNG=Q,KEY_TYPE=R,HAS_HINT=Y,CLUSTER=N,DROP_IN_REINDEX=N,
SEG={SIZ=2,FLD=1,DIR=A}},
KEY={DESC="key 2(field id)",MOD=N,DIR=T,RNG=Q,KEY_TYPE=R,HAS_HINT=Y,CLUSTER=N,DROP_IN_REINDEX=N,
SEG={SIZ=2,FLD=2,DIR=A}},
KEY={DESC="key 3(file+key num+s",MOD=S,DIR=T,RNG=Q,KEY_TYPE=R,HAS_HINT=Y,CLUSTER=N,DROP_IN_REINDEX=N,
SEG={SIZ=2,FLD=1,DIR=A},
SEG={SIZ=2,FLD=3,DIR=A},
SEG={SIZ=2,FLD=4,DIR=A}}}
FILE={NAME="fieldext.ddf",DESC="fieldext_ddf",ACCKEY="..SC....",DBNAME="CTL",ENCR=N,SIZ=78,RESIDENT=78,HAS_HINT=Y,CURSOR=D,CHECK_EXIST=D,FTYPE=T,POSITION=D,
FLD={DESC="EXT_File ID",PIC="4",STRG=5,ATTR=N,SIZ=2,WHLE=4,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="         0,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
FLD={DESC="EXT_Field ID",PIC="4",STRG=5,ATTR=N,SIZ=2,WHLE=4,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="         0,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
FLD={DESC="EXT_Erweiterter Typ",PIC="4",STRG=5,ATTR=N,SIZ=2,WHLE=4,RSRCE={MDFY=Y,TRNS=S,DEF=N,MOD=B,CTRL=E,CTRL_STP="         0,00000",NUL_ALW=N,DEF_NULL=N,STYLE=2,IDX_COLOR=1,IDX_FONT=1}},
KEY={MOD=S,DIR=T,RNG=Q,KEY_TYPE=R,HAS_HINT=Y,CLUSTER=N,DROP_IN_REINDEX=N,
SEG={SIZ=2,FLD=1,DIR=A},
SEG={SIZ=2,FLD=2,DIR=A}}}

There are no comments on this page. [Add comment]

Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by Wikka Wakka Wiki trunk
Page was generated in 0.3145 seconds