Page tree
Skip to end of metadata
Go to start of metadata

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

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 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;


ParameterDescriptionPostgres 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
INSERTFLAG
must be 1
true
UPDATEMASK
must be <DEFAULT>
0

Identifier for Cultureinfo:

MSSQL

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,true,0,'TISAdmin',@retval_out OUTPUT
GO


Postgres

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.

  • No labels