(warning)  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:


ORACLE: for TIS from 6.6
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;
ORACLE: for TIS from 6.1 to 6.5
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;
ORACLE: for TIS up to 6.0
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 CULTUREINFO. 1=en-GB, 2=de-DE

2
CLIENTLOGO_IN

must be <NULL>

null
CLIENTFLAGS_IN

must be 0

  • 0 = XIMES
  • 2 = Qmetrix (warning) 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

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

PGSQL
-- 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.