SQL Practical Guide

Search

SNOMED CT Document Library

    Loading...

Page tree

Versions Compared

Old Version 3

changes.mady.by.user David Markwell

Saved on

compared with

New Version 4

changes.mady.by.user David Markwell

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note

Languages can only be set if the following conditions apply.

  1. The concept identifying the language reference set is available in the database.
  2. The language abbreviation, language name and the identifier of the language reference set are in the config_language table.
  3. The identified language reference set is available in the snap_refset_language reference set table or view.
SQL Call to Procedure

call

setDeltaRange(p_id,p_deltaStartTime,p_deltaEndTime);

ParameterDescriptionData typeValid valuesExample
p_idThe identifier of the configuration table view (also the number of the snapshot or delta view number to which the setting applies).TINYINT

0, 1 or 2

Note

The language setting can be changed for the id=0 row.

1
p_lang_codeThe date after which changes will be included in the delta view.VARCHAR(5)Any value that MySQL recognizes as a date or date-time.'en-GB'
Example of Procedure Call
Code Block
languagesql
themeConfluence
call setLanguage(1,'en-GB');
Result

If p_lang_code does not refer to a language code in the config_language file or if no valid refset or refset members are found the procedure reports an error.

If the procedure succeeds, the language setting is changed but there is no output data. To check the result of the change, call showConfig() after resetConfig.

...

The setDeltaRange procedure sets the snapshotTime for a configuration row specified by its id value.

SQL Call to Procedure

call

setDeltaRange(p_id,p_snapshotTime,p_deltaEndTime);

ParameterDescriptionData typeValid valuesExample
p_idThe identifier of the configuration table view (also the number of the snapshot or delta view number to which the setting applies).TINYINT

1 or 2

(Note: Values less than 1 or greater than 2 will be treated as referring to row 2)

1
p_snapshotTime
The date for which the identified snapshot view will be computed.DATETIMEAny value that MySQL recognizes as a date or date-time.'2017-07-31'
Example of Procedure Call
Code Block
languagesql
themeConfluence
call setSnapshotTime(1,'2017-07-31');
Result

The snapshotTime setting is changed but there is no output data. To check the result of the change, call showConfig() after resetConfig.

...

The setDeltaRange procedure sets the deltaStartTime and deltaEndTime for a configuration row specified by its id value.


of
SQL Call to Procedure

call

setDeltaRange(p_id,p_deltaStartTime,p_deltaEndTime);

ParameterDescriptionData typeValid valuesExample
p_idThe identifier of the configuration table view (also the number of the snapshot or delta view number to which the setting applies).TINYINT

1 or 2

(Note: Values less than 1 or greater than 2 will be treated as referring to row 2)

1
p_deltaStartTimeThe date after which changes will be included in the delta view.DATETIMEAny value that MySQL recognizes as a date or date-time.'2016-07-31'
p_deltaEndTimeThe date on or before which changes with be included in the delta view.DATETIMEAny value that MySQL recognizes as a date or date-time.'2019-01-31'
Example Procedure Call
Code Block
languagesql
themeConfluence
call setDeltaRange(1,'2016-07-31','2017-07-31');
Result

The deltaStartTime and deltaEndTime settings are changed but there is no output data. To check the result of the change, call showConfig() after resetConfig.

...