Hello
> It will be possible to modify the database kernel that he knows the type
> NUMERIC within "CREATE TABLE"-commands. But inside the kernel this type
will
> be mapped to FIXED and this will be the value returned by making selects
to
> the system tables. Will this be a solution?
I think it will be the solution. Up to what I know, to be compliant with
the standard it is not necessary that the driver returns a NUMERIC data type
identification, mainly because the standard does not provide any facility to
get a column data type.
Inside JDBC, the driver can identify the column data_type as "DECIMAL",
"FIXED" or any other implementation equivalent data type, without this
affecting compliance with the standard.
I think it is better to map the data type in the kernel. In this way,
all the interfaces of SAPDB including ISQL will comply with ANSI92 and not
only the JDBC one.
The NUMERIC type can have the same type mappings as the DEC[IMAL] one.
The only difference between NUMERIC and DECIMAL that I can see in the
standard is that NUMERIC has a precision equal to the one selected in the
type declaration and DECIMAL has the same or more precision that the
declared one. I believe that for all the SQL implementations I know the two
types are exactly the same.
The text that defines the two types in the SQL92 standard is:
17)NUMERIC specifies the data type exact numeric, with the decimal precision
and scale specified by the <precision> and <scale>.
18)DECIMAL specifies the data type exact numeric, with the decimal scale
specified by the <scale> and the implementation-defined decimal precision
equal to or greater than the value of the specified <precision>.
Regards
Blas Rodriguez Somoza
----- Original Message -----
From: "Paskamp, Marco" <[EMAIL PROTECTED]>
To: "'Blas Rodriguez Somoza'" <[EMAIL PROTECTED]>
Sent: Monday, February 11, 2002 9:23 AM
Subject: RE: Data types and ANSI SQL92 Entry level
> Hello,
>
> > -----Original Message-----
> > From: Blas Rodriguez Somoza [mailto:[EMAIL PROTECTED]]
> > Sent: Freitag, 8. Februar 2002 20:58
> > To: [EMAIL PROTECTED]
> > Cc: Paskamp, Marco
> > Subject: Data types and ANSI SQL92 Entry level
> >
> >
> > Hello
> >
> > With the data types and mappings that was included in the
> > Reference
> > manual, SAPDB is not ANSI SQL92 Entry level compliant, and
> > because that the
> > JDBC Driver can't be J2EE 1.2 compliant.
> >
> > The data types
> >
> > NUMERIC
> > NUMERIC(p)
> > NUMERIC(p,s)
> >
> > Don't exists and they are required for compliance with SQL92 Entry
> > Level.
>
> Did you mean they are missing in the database kernel or missing in the
> MetaData-methods of the JDBC-driver? In the JDBC-driver mappings are
> possible.
>
> >
> > There exists mappings for other types of the SQL92 standard (DEC,
> > DECIMAL...) but those was apparently forgetted.
> >
> > Is it any easy solution to that?
> > I try looking at the source but I don't find how the mappings are
> > implemented.
>
> It will be possible to modify the database kernel that he knows the type
> NUMERIC within "CREATE TABLE"-commands. But inside the kernel this type
will
> be mapped to FIXED and this will be the value returned by making selects
to
> the system tables. Will this be a solution?
>
> Regards,
> Marco
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
