maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_insert_default_config_colombia(integer)
Parameters
Name
Type
Mode
in_idclient
integer
IN
Definition
INSERT INTO gnx.gnx_config_customer_specific (idclient,idparameter,value) SELECT in_idclient,29,'192.168.30.19.4.45' FROM client WHERE idbranch = 2 AND in_idclient NOT IN (SELECT DISTINCT idclient FROM gnx.gnx_config_customer_specific WHERE idparameter = 29); INSERT INTO gnx.gnx_config_customer_specific (idclient,idparameter,value) SELECT in_idclient,64,30 FROM client WHERE idbranch = 2 AND in_idclient NOT IN (SELECT DISTINCT idclient FROM gnx.gnx_config_customer_specific WHERE idparameter = 64);