WARNING: DO NOT CHANGE CLIENT CULTUREINFO WHEN TISERVICE HAD ALREADY BEEN CONNECTED TO THE TISDB !
Use stored procedure xisp_saveclient and restart TIService afterwards.
Oracle
A new tenant (Client) can be created by a stored procedure XIMES_DAL.XISP_SAVECLIENT
:
Execute in SQL developer:
var clientId varchar2(50)
var clientCompany varchar2(50)
var clientStreet varchar2(50)
var clientPostalCode varchar2(15)
var clientCity varchar2(50)
var clientCountry varchar2(50)
var clientDescription varchar2(200)
var cultureInfoName varchar2(20)
var clientLogo varchar2(255)
var clientFlags number
var userid varchar2(50)
var insertFlag number
var updatemask number
var retval number
exec
:clientId :=
'01'
exec
:clientCompany :=
'XIMES'
exec
:clientStreet :=
'Hollandstrasse 12/12'
exec
:clientPostalCode :=
'1020'
exec
:clientCity :=
'Wien'
exec
:clientCountry :=
'Austria'
exec
:clientDescription :=
'XIMES01'
exec
:cultureInfoName :=
'de-DE'
exec
:clientLogo :=
null
exec
:clientFlags := 0
exec
:userid :=
'TISAdmin'
exec
:insertFlag := 1
exec
:updatemask := 0
exec
ximes_dal.xiSp_SaveClient(ClientId_in => :clientId, -
ClientCompany_in => :clientCompany, -
ClientStreet_in => :clientStreet, -
ClientPostalCode_in => :clientPostalCode, -
ClientCity_in => :clientCity, -
ClientCountry_in => :clientCountry, -
ClientDescription_in => :clientDescription, -
CultureInfoName_in => :cultureInfoName, -
ClientLogo_in => :clientLogo, -
ClientFlags_in => :clientFlags, -
UserId_in => :userId, -
insertflag => :insertFlag, -
updatemask => :updatemask, -
retval_out => :retval);
commit
;
-- for deleting a client
exec
ximes_dal.xiSp_DeleteClient(key_in => :clientId, -
retval_out => :retval);
commit
;
var clientId varchar2(50)
var clientCompany varchar2(50)
var clientStreet varchar2(50)
var clientPostalCode varchar2(15)
var clientCity varchar2(50)
var clientCountry varchar2(50)
var clientDescription varchar2(200)
var cultureInfoId number
var clientLogo varchar2(255)
var clientFlags number
var userid varchar2(50)
var insertFlag number
var updatemask number
var retval number
exec
:clientId :=
'01'
exec
:clientCompany :=
'XIMES'
exec
:clientStreet :=
'Hollandstrasse 12/12'
exec
:clientPostalCode :=
'1020'
exec
:clientCity :=
'Wien'
exec
:clientCountry :=
'Austria'
exec
:clientDescription :=
'XIMES01'
exec
:cultureInfoId := 1
exec
:clientLogo :=
null
exec
:clientFlags := 0
exec
:userid :=
'TISAdmin'
exec
:insertFlag := 1
exec
:updatemask := 0
exec
ximes_dal.xiSp_SaveClient(ClientId_in => :clientId, -
ClientCompany_in => :clientCompany, -
ClientStreet_in => :clientStreet, -
ClientPostalCode_in => :clientPostalCode, -
ClientCity_in => :clientCity, -
ClientCountry_in => :clientCountry, -
ClientDescription_in => :clientDescription, -
CultureInfoId_in => :cultureInfoId, -
ClientLogo_in => :clientLogo, -
ClientFlags_in => :clientFlags, -
UserId_in => :userId, -
insertflag => :insertFlag, -
updatemask => :updatemask, -
retval_out => :retval);
commit
;
-- for deleting a client
exec
ximes_dal.xiSp_DeleteClient(key_in => :clientId, -
retval_out => :retval);
commit
;
var clientId varchar2(50)
var clientCompany varchar2(50)
var clientStreet varchar2(50)
var clientPostalCode varchar2(15)
var clientCity varchar2(50)
var clientCountry varchar2(50)
var clientDescription varchar2(200)
var cultureInfoId number
var clientLogo varchar2(255)
var clientFlags number
var userid varchar2(50)
var insertFlag number
var updatemask number
var retval number
exec
:clientId :=
'01'
exec
:clientCompany :=
'XIMES'
exec
:clientStreet :=
'Hollandstrasse 12/12'
exec
:clientPostalCode :=
'1020'
exec
:clientCity :=
'Wien'
exec
:clientCountry :=
'Austria'
exec
:clientDescription :=
'XIMES01'
exec
:cultureInfoId := 1
exec
:clientLogo :=
null
exec
:clientFlags := 0
exec
:insertFlag := 1
exec
:updatemask := 0
exec
ximes_dal.xiSp_SaveClient(ClientId_in => :clientId, -
ClientCompany_in => :clientCompany, -
ClientStreet_in => :clientStreet, -
ClientPostalCode_in => :clientPostalCode, -
ClientCity_in => :clientCity, -
ClientCountry_in => :clientCountry, -
ClientDescription_in => :clientDescription, -
CultureInfoId_in => :cultureInfoId, -
ClientLogo_in => :clientLogo, -
ClientFlags_in => :clientFlags, -
insertflag => :insertFlag, -
updatemask => :updatemask, -
retval_out => :retval);
commit
;
-- for deleting a client
exec
ximes_dal.xiSp_DeleteClient(key_in => :clientId, -
retval_out => :retval);
commit
;
Parameter | Description | Postgres Sample |
---|---|---|
CLIENTID_IN | Unique alphanumeric identifier for the tenant (Client). Default is 01. | '01' |
CLIENTCOMPANY_IN | Name of the tenant. | 'XIMES' |
CLIENTSTREET_IN | Address | 'Hollandstrasse 12/12' |
CLIENTPOSTALCODE_IN | Address | '1020' |
CLIENTCITY_IN | Address | 'Wien' |
CLIENTCOUNTRY_IN | Address | 'Austria' |
CLIENTDESCRIPTION_IN | Description of the tenant. | 'XIMES01' |
CULTUREINFOID_IN | Language identifier referes to table | 2 |
CLIENTLOGO_IN | must be <NULL> | null |
CLIENTFLAGS_IN | must be 0
| 0 |
USERID_IN | must be <NULL> | null |
INSERTFLAG | must be 1 | true |
UPDATEMASK | must be <DEFAULT> | 0 |
Identifier for Cultureinfo:
MSSQL
-- for TIS from 6.6
DECLARE
@RC
int
DECLARE
@retval_out
int
EXECUTE
@RC = [dbo].[xiSp_SaveClient]
'01'
,
'XIMES'
,
'Hollandstrasse 12/12'
,
'1020'
,
'Wien'
,
'Austria'
,
'XIMES01'
,
'de-DE'
,
null
,0,
'TISAdmin'
,
true
,0,@retval_out
OUTPUT
GO
-- for TIS from 6.1 to 6.5
DECLARE
@RC
int
DECLARE
@retval_out
int
EXECUTE
@RC = [dbo].[xiSp_SaveClient]
'01'
,
'XIMES'
,
'Hollandstrasse 12/12'
,
'1020'
,
'Wien'
,
'Austria'
,
'XIMES01'
,1,
null
,0,
'TISAdmin'
,
true
,0,@retval_out
OUTPUT
GO
-- for TIS up to 6.0
DECLARE
@RC
int
DECLARE
@retval_out
int
EXECUTE
@RC = [dbo].[xiSp_SaveClient]
'01'
,
'XIMES'
,
'Hollandstrasse 12/12'
,
'1020'
,
'Wien'
,
'Austria'
,
'XIMES01'
,1,
null
,0,
true
,0,@retval_out
OUTPUT
GO
Postgres
-- for TIS from 6.6
select
*
from
xisp_saveclient(
'01'
,
'XIMES'
,
'Hollandstrasse 12/12'
,
'1020'
,
'Wien'
,
'Austria'
,
'XIMES01'
,
'de-DE'
,
null
,0,
'TISAdmin'
,
true
,0);
-- for TIS from 6.1 to 6.5
select
*
from
xisp_saveclient(
'01'
,
'XIMES'
,
'Hollandstrasse 12/12'
,
'1020'
,
'Wien'
,
'Austria'
,
'XIMES01'
,1,
null
,0,
'TISAdmin'
,
true
,0);
-- for TIS up to 6.0
select
*
from
xisp_saveclient(
'01'
,
'XIMES'
,
'Hollandstrasse 12/12'
,
'1020'
,
'Wien'
,
'Austria'
,
'XIMES01'
,1,
null
,0,
true
,0);
Afterwards
After successfully updated the table CLIENT
the Windows Service TIService
must be manually restarted.
A user TISAdmin
is created by default.