Some questions about MaxDB
"Bi, Xuan" <[email protected]> Wed, 25 Jul 2007 16:46:24 +0800
| Newsgroups | gmane.comp.db.maxdb |
|---|---|
| Message-ID | <[email protected]> |
------_=_NextPart_001_01C7CE98.49692A5B
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Dear Madam/Sir,
I'm new to MaxDB. I want to ask some questions for using MaxDB.
1. As we know, in Microsoft SQL Server, it has a type
"uniqueidentifier". With this type data, we can use the function
"newid()" to generate a globe user identifier.So I wanna if MaxDB has
the similar functions? I only found STAMP in MaxDB, Such values are
serial numbers beginning at X'0000000000001' and are assigned in
ascending order. I don't know if it can replace the function of
"uniqueidentifier" in MaxDB
2. When I write this SQL statement:
If exists (select * from A)
insert into A(b,c) values('b','c')
or
if exists table A ...
it always failed.
So I wanna whether this statement is correct or MaxDB does
not support using "if" together with "exists". You know, this is a very
important feature.
=09
3. I created a demoDB, and a DBPROC (named test), all corretly.
I opened a new SQL editor, and just wrote "Call test" , but
it failed with Error Executing 'CALL hotel.test' SAP DBTech JDBC: Call
of execute(String) is not allowed for PreparedStatement.
And I ran the system default DBPROC , it still the same
problem
Thank you very much!
Best Regards,
Jason
=09
------_=_NextPart_001_01C7CE98.49692A5B--