Subject: Some questions about MaxDB 2007-07-25 - By Bi, Xuan
Back
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
|
|
