IHSD
.IHS_2023
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
IHS_2023.PR_UPDATE_SURVEYDICTIONARY
Parameters
Name
Type
Mode
Definition
procedure pr_update_SURVEYDICTIONARY -- use AUTHID CURRENT_USER to execute with the privileges and -- schema context of the calling user AUTHID CURRENT_USER AS begin -------------------------------------------------------- -- 0 - Data insertion for Table SURVEYDICTIONARY -------------------------------------------------------- --added for IHS 2023: --fully refreshed! EXECUTE IMMEDIATE 'truncate table SURVEYDICTIONARY'; insert into SURVEYDICTIONARY ( SURVEYNAME ,SURVEYKEY ,SURVEYVERSION ,STEPIDENTIFIER ,RESULTIDENTIFIER ,QUESTIONTEXT ,ANSWERFORMAT ,ANSWERCHOICES ) select SURVEYNAME ,fn_guid_to_raw(SURVEYKEY) as SURVEYKEY ,SURVEYVERSION ,STEPIDENTIFIER ,RESULTIDENTIFIER ,QUESTIONTEXT ,ANSWERFORMAT ,ANSWERCHOICES from stg_SurveyDictionary ; commit; end;