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:

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 TIS up to 6.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 `CULTUREINFO`. 1=en-GB, 2=de-DE	2
CLIENTLOGO_IN	must be <NULL>	null
CLIENTFLAGS_IN	must be 0 0 = XIMES 2 = Qmetrix APPID must be unique on host for MSMQ usage	0
USERID_IN	must be <NULL>	null
INSERTFLAG	must be 1	true
UPDATEMASK	must be <DEFAULT>	0

Identifier for Cultureinfo:

MSSQL

DECLARE @RC int
DECLARE @retval_out int
 
-- TIS 6.0
EXECUTE @RC = [dbo].[xiSp_SaveClient] '01','XIMES','Hollandstrasse 12/12','1020','Wien','Austria','XIMES01',1,null,0,true,0,@retval_out OUTPUT
GO
 
-- TIS 6.1
EXECUTE @RC = [dbo].[xiSp_SaveClient] '01','XIMES','Hollandstrasse 12/12','1020','Wien','Austria','XIMES01',1,null,0,'TISAdmin',true,0,@retval_out OUTPUT
GO

Postgres

select * from  xisp_saveclient('01','XIMES','Hollandstrasse 12/12','1020','Wien','Austria','XIMES01',1,null,0,'TISAdmin',true,0);

Afterwards

After successfully updated the table CLIENT the Windows Service TIService must be manually restarted.

A user TISAdmin is created by default.