Description
noneProcedure properties
| name | value |
|---|
| name | ml_server.ml_qa_upsert_global_prop
|
| created |
|
| type | SQL stored procedure
|
Parameters
| name | datatype | length | in/out | comment |
|---|
| @client | varchar | 128 | in | |
| @name | varchar | 128 | in | |
| @modifiers | integer | 4 | in | |
| @value | long varchar | 32767 | in | |
Usage
EXEC ml_server.ml_qa_upsert_global_prop
@client = @myvarchar1,
@name = @myvarchar2,
@modifiers = @myinteger3,
@value = @mylong varchar4Code
create procedure ml_server.ml_qa_upsert_global_prop( in @client varchar(128),
in @name varchar(128),
in @modifiers integer,
in @value long varchar )
begin
insert into ml_qa_global_props( client,name,modifiers,value ) on existing update defaults off
values( @client,@name,@modifiers,@value )
end