on 08-19-2015 4:41 PM
I am trying to create a stored procedure in Hana Studio. In the stored procedure ,I am trying to give a default value to the input. my code is,
CREATE PROCEDURE defaultSchemaName.procedureName (IN INPUT NVARCHAR(10) DEFAULT 'TEST')
This runs fine when I am trying to create a .hdbprocedure
but fails when I want to create a .procedure
. Is there any way to use a default procedure in Design Time?
From a previous discussion which was carried on almost 2 years ago I understood that this feature would be available in SP06, we are now at SP09 but I still cant see it.
>his runs fine when I am trying to create a .hdbprocedure
but fails when I want to create a .procedure
.
Why would you want to use a .procedure? The .procedure format is obsolete and replaced with .hdbprocedure. You even receive a "Deprecated" message in the Studio when you try to create new .procedures.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>So is there a possibility to achieve this ?
Yes by changing the procedure over to an HDBProcedure. The process isn't really difficult and the runtime object remains the same. Don't expect new features to come to the old .procedure format since its deprecated. If new features are desired, that makes for a fine time to switch over to the new format.
Hi Thomas,
As I was scouring SCN for this issue, I came across this post which states that such a feature is available or rather should be available with Hana SP06.
If it is so, then such a feature should already be available with Hana SP09 on which we are currently.
So we aren't expecting a new feature but rather something that should already be available.
Thanks and regards,
Hitesh Jolly
Is the DEFAULT keyword not supported while creating scalar functions in HANA (.hdbscalarfunction) ?
We are trying to create a function with the default keyword. The function gets activated successfully, but while trying to invoke the function it throws an error :
mismatch input argument count for user defined function
We are receiving the error in Hana Rev 85
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.