;---------------------------------------------------------------------------- ; ; (c) Starware Corporation, 1995 ; StarSQL Configuration Information file ; ; ;---------------------------------------------------------------------------- ; This file contains StarSQL ODBC driver specific entries. ; This should be appended to the Gupta dcc.ini file that ; is created when you install Gupta 5.0.2 or later with ; ODBC support. ; ; The data sources that are supported in this file are: ; SQL/DS 3.4 ; DB2/MVS 2.3 ; DB2/MVS 3.1 ; DB2/400 2.3 ; DB2/400 3.1 ; DB2 Common Server 2.1 (DB2/2 and DB2/6000 and DB2/NT) ;---------------------------------------------------------------------------- ; [DB2 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC32] Quoted Creator=FALSE Outer Join=FALSE Derived In GroupBy=TRUE Label Clause=FALSE Table Rename=FALSE Comments=FALSE Group By=TRUE Alter Add=TRUE Alter Drop=FALSE Alter Modify=FALSE Alter Rename=FALSE Owner For Label=FALSE Owner For Comment=FALSE Qualify Index With Creator=FALSE Only Access Owned Indexes=TRUE Modify Index=FALSE Pad User Names=FALSE Not Null On Alter Table Add=TRUE Mixed Case User Id Password=FALSE Modify View=FALSE With Check On Views=TRUE Asc/Desc For Columns In Indexes=TRUE Alter Authority=FALSE Index Authority=FALSE Not Null As Default=FALSE Qualify Index On Create=FALSE Qualify Index With Table Name=FALSE Parantheses On Alter Table=FALSE Alternate User Name=FALSE Use Ordinals In Group By=TRUE Cache Table=TRUE Cache Column=TRUE Cache Column Auth=FALSE Cache Table Auth=FALSE Qualify Table Name With DBName=FALSE Column Type On Alter Modify=FALSE Null On Alter Modify=FALSE Delete Indexes=FALSE Outer Join In From Clause=FALSE Check Views Editable=TRUE Support ROWID=FALSE Support Row Version=FALSE Support Logical Key=FALSE Multiple Outer Joins=FALSE Compound Outer Joins=FALSE Qualify Indexes=FALSE Qualified Column Names=FALSE Commit After Result=FALSE User Qualified Columns=FALSE Support Create Tables=TRUE Set Quest To Read-Only Mode=FALSE Qualify Table Name With Creator=TRUE Support Views=TRUE Add Primary Keyword For Create Index=FALSE Order By/Group By Column In Select List=TRUE Quoted User Ids=TRUE Quoted Table/Column Names=TRUE Table Name Length=18 Column Name Length=18 User Name Length=10 Parse Flags= Number Of Column Types=13 Table Name Case=3 Number Of Optional Parms= Date Rule Flags= Maximum Row Size=32706 Default Long Binding Type=SQLPLON RowID Type= Column Name Case=3 DateTime Insert String= Date Picture String= Time Picture String= DateTime Picture String= Static Date Picture= Static Time Picture= Static DateTime Picture String= Creator Filter= System SQL Views Prefix= Left Outer Join Format= Right Outer Join Format= Minimum Maximum Backend Version= Server Name= Date Insert String= Time Insert String= Row ID= Row Version= Logical Key= Row Version Left Bind= Row Version Right Bind= Logical Key Left Bind= Logical Key Right Bind= Identifier Quote Character=" [Column Type(0) Info - DB2 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=CHAR Catalog Column Type=CHAR Statement to Create Column= Matching Gupta Column Type=4 Maximum Size/width=254 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(1) Info - DB2 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=VARCHAR Catalog Column Type=VARCHAR Statement to Create Column= Matching Gupta Column Type=5 Maximum Size/width=254 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(2) Info - DB2 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=VARCHAR Catalog Column Type=VARCHAR Statement to Create Column= Matching Gupta Column Type=6 Maximum Size/width=32704 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(3) Info - DB2 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=INTEGER Catalog Column Type=INTEGER Statement to Create Column= Matching Gupta Column Type=1 Maximum Size/width=10 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(4) Info - DB2 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=SMALLINT Catalog Column Type=SMALLINT Statement to Create Column= Matching Gupta Column Type=2 Maximum Size/width=5 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(5) Info - DB2 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=DECIMAL Catalog Column Type=DECIMAL Statement to Create Column= Matching Gupta Column Type=7 Maximum Size/width=31 Precision=Required Maximum Scale=31 Scale Required/Not Reqd/Optional=Opt Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(6) Info - DB2 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=NUMERIC Catalog Column Type=NUMERIC Statement to Create Column= Matching Gupta Column Type=7 Maximum Size/width=31 Precision=Required Maximum Scale=31 Scale Required/Not Reqd/Optional=Opt Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(7) Info - DB2 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=DATE Catalog Column Type=DATE Statement to Create Column= Matching Gupta Column Type=8 Maximum Size/width=10 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(8) Info - DB2 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=TIME Catalog Column Type=TIME Statement to Create Column= Matching Gupta Column Type=9 Maximum Size/width=8 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(9) Info - DB2 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=TIMESTAMP Catalog Column Type=TIMESTAMP Statement to Create Column= Matching Gupta Column Type=10 Maximum Size/width=26 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(10) Info - DB2 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=REAL Catalog Column Type=REAL Statement to Create Column= Matching Gupta Column Type=3 Maximum Size/width=21 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(11) Info - DB2 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=FLOAT Catalog Column Type=FLOAT Statement to Create Column= Matching Gupta Column Type=3 Maximum Size/width=53 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(12) Info - DB2 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=DOUBLE PRECISION Catalog Column Type=DOUBLE PRECISION Statement to Create Column= Matching Gupta Column Type=3 Maximum Size/width=53 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [DB2/400 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Quoted Creator=FALSE Outer Join=FALSE Derived In GroupBy=TRUE Label Clause=FALSE Table Rename=FALSE Comments=FALSE Group By=TRUE Alter Add=FALSE Alter Drop=FALSE Alter Modify=FALSE Alter Rename=FALSE Owner For Label=FALSE Owner For Comment=FALSE Qualify Index With Creator=FALSE Only Access Owned Indexes=TRUE Modify Index=FALSE Pad User Names=FALSE Not Null On Alter Table Add=TRUE Mixed Case User Id Password=FALSE Modify View=FALSE With Check On Views=TRUE Asc/Desc For Columns In Indexes=TRUE Alter Authority=FALSE Index Authority=FALSE Not Null As Default=FALSE Qualify Index On Create=FALSE Qualify Index With Table Name=FALSE Parantheses On Alter Table=FALSE Alternate User Name=FALSE Use Ordinals In Group By=TRUE Cache Table=TRUE Cache Column=TRUE Cache Column Auth=FALSE Cache Table Auth=FALSE Qualify Table Name With DBName=FALSE Column Type On Alter Modify=FALSE Null On Alter Modify=FALSE Delete Indexes=FALSE Outer Join In From Clause=FALSE Check Views Editable=TRUE Support ROWID=FALSE Support Row Version=FALSE Support Logical Key=FALSE Multiple Outer Joins=FALSE Compound Outer Joins=FALSE Qualify Indexes=FALSE Qualified Column Names=TRUE Commit After Result=FALSE User Qualified Columns=TRUE Support Create Tables=TRUE Set Quest To Read-Only Mode=FALSE Qualify Table Name With Creator=TRUE Support Views=TRUE Add Primary Keyword For Create Index=FALSE Order By/Group By Column In Select List=TRUE Quoted User Ids=TRUE Quoted Table/Column Names=TRUE Table Name Length=10 Column Name Length=10 User Name Length=10 Parse Flags= Number Of Column Types=13 Table Name Case=3 Number Of Optional Parms= Date Rule Flags= Maximum Row Size=32766 Default Long Binding Type=SQLPLON RowID Type= Column Name Case=3 DateTime Insert String= Date Picture String= Time Picture String= DateTime Picture String= Static Date Picture= Static Time Picture= Static DateTime Picture String= Creator Filter= System SQL Views Prefix= Left Outer Join Format= Right Outer Join Format= Minimum Maximum Backend Version= Server Name= Date Insert String= Time Insert String= Row ID= Row Version= Logical Key= Row Version Left Bind= Row Version Right Bind= Logical Key Left Bind= Logical Key Right Bind= Identifier Quote Character=" [Column Type(0) Info - DB2/400 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=CHAR Catalog Column Type=CHAR Statement to Create Column= Matching Gupta Column Type=4 Maximum Size/width=254 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(1) Info - DB2/400 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=VARCHAR Catalog Column Type=VARCHAR Statement to Create Column= Matching Gupta Column Type=5 Maximum Size/width=254 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(2) Info - DB2/400 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=VARCHAR Catalog Column Type=VARCHAR Statement to Create Column= Matching Gupta Column Type=6 Maximum Size/width=32740 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(3) Info - DB2/400 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=INTEGER Catalog Column Type=INTEGER Statement to Create Column= Matching Gupta Column Type=1 Maximum Size/width=10 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(4) Info - DB2/400 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=SMALLINT Catalog Column Type=SMALLINT Statement to Create Column= Matching Gupta Column Type=2 Maximum Size/width=5 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(5) Info - DB2/400 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=DECIMAL Catalog Column Type=DECIMAL Statement to Create Column= Matching Gupta Column Type=7 Maximum Size/width=31 Precision=Required Maximum Scale=31 Scale Required/Not Reqd/Optional=Opt Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(6) Info - DB2/400 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=NUMERIC Catalog Column Type=NUMERIC Statement to Create Column= Matching Gupta Column Type=7 Maximum Size/width=31 Precision=Required Maximum Scale=31 Scale Required/Not Reqd/Optional=Opt Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(7) Info - DB2/400 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=DATE Catalog Column Type=DATE Statement to Create Column= Matching Gupta Column Type=8 Maximum Size/width=10 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(8) Info - DB2/400 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=TIME Catalog Column Type=TIME Statement to Create Column= Matching Gupta Column Type=9 Maximum Size/width=8 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(9) Info - DB2/400 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=TIMESTAMP Catalog Column Type=TIMESTAMP Statement to Create Column= Matching Gupta Column Type=10 Maximum Size/width=26 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(10) Info - DB2/400 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=REAL Catalog Column Type=REAL Statement to Create Column= Matching Gupta Column Type=3 Maximum Size/width=21 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(11) Info - DB2/400 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=FLOAT Catalog Column Type=FLOAT Statement to Create Column= Matching Gupta Column Type=3 Maximum Size/width=53 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(12) Info - DB2/400 02.03.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=DOUBLE PRECISION Catalog Column Type=DOUBLE PRECISION Statement to Create Column= Matching Gupta Column Type=3 Maximum Size/width=53 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [DB2/400 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Quoted Creator=FALSE Outer Join=FALSE Derived In GroupBy=TRUE Label Clause=FALSE Table Rename=FALSE Comments=FALSE Group By=TRUE Alter Add=FALSE Alter Drop=FALSE Alter Modify=FALSE Alter Rename=FALSE Owner For Label=FALSE Owner For Comment=FALSE Qualify Index With Creator=FALSE Only Access Owned Indexes=TRUE Modify Index=FALSE Pad User Names=FALSE Not Null On Alter Table Add=TRUE Mixed Case User Id Password=FALSE Modify View=FALSE With Check On Views=TRUE Asc/Desc For Columns In Indexes=TRUE Alter Authority=FALSE Index Authority=FALSE Not Null As Default=FALSE Qualify Index On Create=FALSE Qualify Index With Table Name=FALSE Parantheses On Alter Table=FALSE Alternate User Name=FALSE Use Ordinals In Group By=TRUE Cache Table=TRUE Cache Column=TRUE Cache Column Auth=FALSE Cache Table Auth=FALSE Qualify Table Name With DBName=FALSE Column Type On Alter Modify=FALSE Null On Alter Modify=FALSE Delete Indexes=FALSE Outer Join In From Clause=FALSE Check Views Editable=TRUE Support ROWID=FALSE Support Row Version=FALSE Support Logical Key=FALSE Multiple Outer Joins=FALSE Compound Outer Joins=FALSE Qualify Indexes=FALSE Qualified Column Names=TRUE Commit After Result=FALSE User Qualified Columns=TRUE Support Create Tables=TRUE Set Quest To Read-Only Mode=FALSE Qualify Table Name With Creator=TRUE Support Views=TRUE Add Primary Keyword For Create Index=FALSE Order By/Group By Column In Select List=TRUE Quoted User Ids=TRUE Quoted Table/Column Names=TRUE Table Name Length=128 Column Name Length=30 User Name Length=10 Parse Flags= Number Of Column Types=13 Table Name Case=3 Number Of Optional Parms= Date Rule Flags= Maximum Row Size=32766 Default Long Binding Type=SQLPLON RowID Type= Column Name Case=3 DateTime Insert String= Date Picture String= Time Picture String= DateTime Picture String= Static Date Picture= Static Time Picture= Static DateTime Picture String= Creator Filter= System SQL Views Prefix= Left Outer Join Format= Right Outer Join Format= Minimum Maximum Backend Version= Server Name= Date Insert String= Time Insert String= Row ID= Row Version= Logical Key= Row Version Left Bind= Row Version Right Bind= Logical Key Left Bind= Logical Key Right Bind= Identifier Quote Character=" [Column Type(0) Info - DB2/400 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=CHAR Catalog Column Type=CHAR Statement to Create Column= Matching Gupta Column Type=4 Maximum Size/width=254 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(1) Info - DB2/400 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=VARCHAR Catalog Column Type=VARCHAR Statement to Create Column= Matching Gupta Column Type=5 Maximum Size/width=254 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(2) Info - DB2/400 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=VARCHAR Catalog Column Type=VARCHAR Statement to Create Column= Matching Gupta Column Type=6 Maximum Size/width=32740 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(3) Info - DB2/400 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=INTEGER Catalog Column Type=INTEGER Statement to Create Column= Matching Gupta Column Type=1 Maximum Size/width=10 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(4) Info - DB2/400 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=SMALLINT Catalog Column Type=SMALLINT Statement to Create Column= Matching Gupta Column Type=2 Maximum Size/width=5 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(5) Info - DB2/400 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=DECIMAL Catalog Column Type=DECIMAL Statement to Create Column= Matching Gupta Column Type=7 Maximum Size/width=31 Precision=Required Maximum Scale=31 Scale Required/Not Reqd/Optional=Opt Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(6) Info - DB2/400 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=NUMERIC Catalog Column Type=NUMERIC Statement to Create Column= Matching Gupta Column Type=7 Maximum Size/width=31 Precision=Required Maximum Scale=31 Scale Required/Not Reqd/Optional=Opt Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(7) Info - DB2/400 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=DATE Catalog Column Type=DATE Statement to Create Column= Matching Gupta Column Type=8 Maximum Size/width=10 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(8) Info - DB2/400 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=TIME Catalog Column Type=TIME Statement to Create Column= Matching Gupta Column Type=9 Maximum Size/width=8 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(9) Info - DB2/400 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=TIMESTAMP Catalog Column Type=TIMESTAMP Statement to Create Column= Matching Gupta Column Type=10 Maximum Size/width=26 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(10) Info - DB2/400 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=REAL Catalog Column Type=REAL Statement to Create Column= Matching Gupta Column Type=3 Maximum Size/width=21 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(11) Info - DB2/400 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=FLOAT Catalog Column Type=FLOAT Statement to Create Column= Matching Gupta Column Type=3 Maximum Size/width=53 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(12) Info - DB2/400 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=DOUBLE PRECISION Catalog Column Type=DOUBLE PRECISION Statement to Create Column= Matching Gupta Column Type=3 Maximum Size/width=53 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [DB2 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Quoted Creator=FALSE Outer Join= Derived In GroupBy= Label Clause=FALSE Table Rename=FALSE Comments=FALSE Group By= Alter Add= Alter Drop= Alter Modify=FALSE Alter Rename=FALSE Owner For Label=FALSE Owner For Comment=FALSE Qualify Index With Creator= Only Access Owned Indexes= Modify Index=FALSE Pad User Names=FALSE Not Null On Alter Table Add= Mixed Case User Id Password= Modify View=FALSE With Check On Views= Asc/Desc For Columns In Indexes= Alter Authority=FALSE Index Authority= Not Null As Default=FALSE Qualify Index On Create= Qualify Index With Table Name= Parantheses On Alter Table= Alternate User Name= Use Ordinals In Group By= Cache Table= Cache Column= Cache Column Auth= Cache Table Auth= Qualify Table Name With DBName= Column Type On Alter Modify= Null On Alter Modify= Delete Indexes= Outer Join In From Clause= Check Views Editable= Support ROWID= Support Row Version= Support Logical Key= Multiple Outer Joins= Compound Outer Joins= Qualify Indexes= Qualified Column Names= Commit After Result= User Qualified Columns= Support Create Tables= Set Quest To Read-Only Mode= Qualify Table Name With Creator=TRUE Support Views= Add Primary Keyword For Create Index= Order By/Group By Column In Select List= Quoted User Ids= Quoted Table/Column Names=TRUE Table Name Length=18 Column Name Length= User Name Length= Parse Flags= Number Of Column Types=11 Table Name Case=3 Number Of Optional Parms= Date Rule Flags= Maximum Row Size= Default Long Binding Type= RowID Type= Column Name Case=3 DateTime Insert String= Date Picture String= Time Picture String= DateTime Picture String= Static Date Picture= Static Time Picture= Static DateTime Picture String= Creator Filter= System SQL Views Prefix= Left Outer Join Format= Right Outer Join Format= Minimum Maximum Backend Version= Server Name= Date Insert String= Time Insert String= Row ID= Row Version= Logical Key= Row Version Left Bind= Row Version Right Bind= Logical Key Left Bind= Logical Key Right Bind= Identifier Quote Character= [Column Type(0) Info - DB2 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=CHAR Catalog Column Type=CHAR Statement to Create Column= Matching Gupta Column Type=4 Maximum Size/width=254 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(1) Info - DB2 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=VARCHAR Catalog Column Type=VARCHAR Statement to Create Column= Matching Gupta Column Type=5 Maximum Size/width=254 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(2) Info - DB2 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=VARCHAR Catalog Column Type=VARCHAR Statement to Create Column= Matching Gupta Column Type=6 Maximum Size/width=32704 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(3) Info - DB2 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=INTEGER Catalog Column Type=INTEGER Statement to Create Column= Matching Gupta Column Type=1 Maximum Size/width=10 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(4) Info - DB2 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=SMALLINT Catalog Column Type=SMALLINT Statement to Create Column= Matching Gupta Column Type=2 Maximum Size/width=5 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(5) Info - DB2 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=DECIMAL Catalog Column Type=DECIMAL Statement to Create Column= Matching Gupta Column Type=7 Maximum Size/width=31 Precision=Required Maximum Scale=31 Scale Required/Not Reqd/Optional=Opt Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(6) Info - DB2 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=NUMERIC Catalog Column Type=NUMERIC Statement to Create Column= Matching Gupta Column Type=7 Maximum Size/width=31 Precision=Required Maximum Scale=31 Scale Required/Not Reqd/Optional=Opt Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(7) Info - DB2 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=DATE Catalog Column Type=DATE Statement to Create Column= Matching Gupta Column Type=8 Maximum Size/width=10 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(8) Info - DB2 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=TIME Catalog Column Type=TIME Statement to Create Column= Matching Gupta Column Type=9 Maximum Size/width=8 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(9) Info - DB2 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=TIMESTAMP Catalog Column Type=TIMESTAMP Statement to Create Column= Matching Gupta Column Type=10 Maximum Size/width=26 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(10) Info - DB2 03.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=REAL Catalog Column Type=REAL Statement to Create Column= Matching Gupta Column Type=3 Maximum Size/width=21 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [SQL/DS 03.04.0000 C:\WINDOWS\SYSTEM\SWODBC16] Quoted Creator=FALSE Outer Join=FALSE Derived In GroupBy=TRUE Label Clause=FALSE Table Rename=FALSE Comments=FALSE Group By=TRUE Alter Add=TRUE Alter Drop=FALSE Alter Modify=FALSE Alter Rename=FALSE Owner For Label=FALSE Owner For Comment=FALSE Qualify Index With Creator=FALSE Only Access Owned Indexes=TRUE Modify Index=FALSE Pad User Names=FALSE Not Null On Alter Table Add=TRUE Mixed Case User Id Password=FALSE Modify View=FALSE With Check On Views=TRUE Asc/Desc For Columns In Indexes=TRUE Alter Authority=FALSE Index Authority=FALSE Not Null As Default=FALSE Qualify Index On Create=FALSE Qualify Index With Table Name=FALSE Parantheses On Alter Table=FALSE Alternate User Name=FALSE Use Ordinals In Group By=TRUE Cache Table=TRUE Cache Column=TRUE Cache Column Auth=FALSE Cache Table Auth=FALSE Qualify Table Name With DBName=FALSE Column Type On Alter Modify=FALSE Null On Alter Modify=FALSE Delete Indexes=FALSE Outer Join In From Clause=FALSE Check Views Editable=TRUE Support ROWID=FALSE Support Row Version=FALSE Support Logical Key=FALSE Multiple Outer Joins=FALSE Compound Outer Joins=FALSE Qualify Indexes=FALSE Qualified Column Names=FALSE Commit After Result=FALSE User Qualified Columns=FALSE Support Create Tables=TRUE Set Quest To Read-Only Mode=FALSE Qualify Table Name With Creator=TRUE Support Views=TRUE Add Primary Keyword For Create Index=FALSE Order By/Group By Column In Select List=TRUE Quoted User Ids=TRUE Quoted Table/Column Names=TRUE Table Name Length=18 Column Name Length=18 User Name Length=10 Parse Flags= Number Of Column Types=13 Table Name Case=3 Number Of Optional Parms= Date Rule Flags= Maximum Row Size=32706 Default Long Binding Type=SQLPLON RowID Type= Column Name Case=3 DateTime Insert String= Date Picture String= Time Picture String= DateTime Picture String= Static Date Picture= Static Time Picture= Static DateTime Picture String= Creator Filter= System SQL Views Prefix= Left Outer Join Format= Right Outer Join Format= Minimum Maximum Backend Version= Server Name= Date Insert String= Time Insert String= Row ID= Row Version= Logical Key= Row Version Left Bind= Row Version Right Bind= Logical Key Left Bind= Logical Key Right Bind= Identifier Quote Character=" [Column Type(0) Info - SQL/DS 03.04.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=CHAR Catalog Column Type=CHAR Statement to Create Column= Matching Gupta Column Type=4 Maximum Size/width=254 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(1) Info - SQL/DS 03.04.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=VARCHAR Catalog Column Type=VARCHAR Statement to Create Column= Matching Gupta Column Type=5 Maximum Size/width=254 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(2) Info - SQL/DS 03.04.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=LONG VARCHAR Catalog Column Type=LONG VARCHAR Statement to Create Column= Matching Gupta Column Type=6 Maximum Size/width=32767 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(3) Info - SQL/DS 03.04.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=INTEGER Catalog Column Type=INTEGER Statement to Create Column= Matching Gupta Column Type=1 Maximum Size/width=10 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(4) Info - SQL/DS 03.04.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=SMALLINT Catalog Column Type=SMALLINT Statement to Create Column= Matching Gupta Column Type=2 Maximum Size/width=5 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(5) Info - SQL/DS 03.04.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=DECIMAL Catalog Column Type=DECIMAL Statement to Create Column= Matching Gupta Column Type=7 Maximum Size/width=31 Precision=Required Maximum Scale=31 Scale Required/Not Reqd/Optional=Opt Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(6) Info - SQL/DS 03.04.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=NUMERIC Catalog Column Type=NUMERIC Statement to Create Column= Matching Gupta Column Type=7 Maximum Size/width=31 Precision=Required Maximum Scale=31 Scale Required/Not Reqd/Optional=Opt Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(7) Info - SQL/DS 03.04.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=DATE Catalog Column Type=DATE Statement to Create Column= Matching Gupta Column Type=8 Maximum Size/width=10 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(8) Info - SQL/DS 03.04.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=TIME Catalog Column Type=TIME Statement to Create Column= Matching Gupta Column Type=9 Maximum Size/width=8 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(9) Info - SQL/DS 03.04.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=TIMESTAMP Catalog Column Type=TIMESTAMP Statement to Create Column= Matching Gupta Column Type=10 Maximum Size/width=26 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(10) Info - SQL/DS 03.04.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=REAL Catalog Column Type=REAL Statement to Create Column= Matching Gupta Column Type=3 Maximum Size/width=21 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(11) Info - SQL/DS 03.04.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=FLOAT Catalog Column Type=FLOAT Statement to Create Column= Matching Gupta Column Type=3 Maximum Size/width=53 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(12) Info - SQL/DS 03.04.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=DOUBLE PRECISION Catalog Column Type=DOUBLE PRECISION Statement to Create Column= Matching Gupta Column Type=3 Maximum Size/width=53 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [DB2 Common Server 02.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Quoted Creator=FALSE Outer Join=FALSE Derived In GroupBy=TRUE Label Clause=FALSE Table Rename=FALSE Comments=FALSE Group By=TRUE Alter Add=TRUE Alter Drop=FALSE Alter Modify=FALSE Alter Rename=FALSE Owner For Label=FALSE Owner For Comment=FALSE Qualify Index With Creator=FALSE Only Access Owned Indexes=TRUE Modify Index=FALSE Pad User Names=FALSE Not Null On Alter Table Add=TRUE Mixed Case User Id Password=FALSE Modify View=FALSE With Check On Views=TRUE Asc/Desc For Columns In Indexes=TRUE Alter Authority=FALSE Index Authority=FALSE Not Null As Default=FALSE Qualify Index On Create=FALSE Qualify Index With Table Name=FALSE Parantheses On Alter Table=FALSE Alternate User Name=FALSE Use Ordinals In Group By=TRUE Cache Table=TRUE Cache Column=TRUE Cache Column Auth=FALSE Cache Table Auth=FALSE Qualify Table Name With DBName=FALSE Column Type On Alter Modify=FALSE Null On Alter Modify=FALSE Delete Indexes=FALSE Outer Join In From Clause=FALSE Check Views Editable=TRUE Support ROWID=FALSE Support Row Version=FALSE Support Logical Key=FALSE Multiple Outer Joins=FALSE Compound Outer Joins=FALSE Qualify Indexes=FALSE Qualified Column Names=FALSE Commit After Result=FALSE User Qualified Columns=FALSE Support Create Tables=TRUE Set Quest To Read-Only Mode=FALSE Qualify Table Name With Creator=TRUE Support Views=TRUE Add Primary Keyword For Create Index=FALSE Order By/Group By Column In Select List=TRUE Quoted User Ids=TRUE Quoted Table/Column Names=TRUE Table Name Length=18 Column Name Length=18 User Name Length=10 Parse Flags= Number Of Column Types=12 Table Name Case=3 Number Of Optional Parms= Date Rule Flags= Maximum Row Size=4005 Default Long Binding Type=SQLPLON RowID Type= Column Name Case=3 DateTime Insert String= Date Picture String= Time Picture String= DateTime Picture String= Static Date Picture= Static Time Picture= Static DateTime Picture String= Creator Filter= System SQL Views Prefix= Left Outer Join Format= Right Outer Join Format= Minimum Maximum Backend Version= Server Name= Date Insert String= Time Insert String= Row ID= Row Version= Logical Key= Row Version Left Bind= Row Version Right Bind= Logical Key Left Bind= Logical Key Right Bind= Identifier Quote Character=" [Column Type(0) Info - DB2 Common Server 02.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=CHARACTER Catalog Column Type=CHARACTER Statement to Create Column= Matching Gupta Column Type=4 Maximum Size/width=254 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(1) Info - DB2 Common Server 02.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=VARCHAR Catalog Column Type=VARCHAR Statement to Create Column= Matching Gupta Column Type=5 Maximum Size/width=4000 Precision=Required Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(2) Info - DB2 Common Server 02.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=INTEGER Catalog Column Type=INTEGER Statement to Create Column= Matching Gupta Column Type=1 Maximum Size/width=10 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(3) Info - DB2 Common Server 02.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=SMALLINT Catalog Column Type=SMALLINT Statement to Create Column= Matching Gupta Column Type=2 Maximum Size/width=5 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(4) Info - DB2 Common Server 02.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=DECIMAL Catalog Column Type=DECIMAL Statement to Create Column= Matching Gupta Column Type=7 Maximum Size/width=31 Precision=Required Maximum Scale=31 Scale Required/Not Reqd/Optional=Opt Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(5) Info - DB2 Common Server 02.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=NUMERIC Catalog Column Type=NUMERIC Statement to Create Column= Matching Gupta Column Type=7 Maximum Size/width=31 Precision=Required Maximum Scale=31 Scale Required/Not Reqd/Optional=Opt Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(6) Info - DB2 Common Server 02.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=FLOAT Catalog Column Type=FLOAT Statement to Create Column= Matching Gupta Column Type=3 Maximum Size/width=53 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(7) Info - DB2 Common Server 02.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=DOUBLE Catalog Column Type=DOUBLE Statement to Create Column= Matching Gupta Column Type=3 Maximum Size/width=53 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(8) Info - DB2 Common Server 02.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=DATE Catalog Column Type=DATE Statement to Create Column= Matching Gupta Column Type=8 Maximum Size/width=10 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(9) Info - DB2 Common Server 02.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=TIME Catalog Column Type=TIME Statement to Create Column= Matching Gupta Column Type=9 Maximum Size/width=8 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(10) Info - DB2 Common Server 02.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=TIMESTAMP Catalog Column Type=TIMESTAMP Statement to Create Column= Matching Gupta Column Type=10 Maximum Size/width=26 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=TRUE [Column Type(11) Info - DB2 Common Server 02.01.0000 C:\WINDOWS\SYSTEM\SWODBC16] Column Name=LONG VARCHAR Catalog Column Type=LONG VARCHAR Statement to Create Column= Matching Gupta Column Type= Maximum Size/width=32700 Precision=No Maximum Scale= Scale Required/Not Reqd/Optional=No Alternate Column Type= Can this Column be NULL?=TRUE Alternate Long Column Descriptor= Can NULL be specified in DDL?=FALSE Can unique index be specified=FALSE