List:MaxDB« Previous MessageNext Message »
From:Xuan Bi Date:July 25 2007 8:46am
Subject:Some questions about MaxDB
View as plain text  
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

	

Thread
Some questions about MaxDBXuan Bi25 Jul