Some questions about MaxDB

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.
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          Received on Wed Jul 25 04:48:29 2007