My Oracle Support Banner

Sample script to spool a Batch Data Load file that will populate the new TMS Enterable Parent Question. (Doc ID 2607190.1)

Last updated on OCTOBER 18, 2022

Applies to:

Oracle Clinical - Version 5.2.0 and later
Oracle Clinical Remote Data Capture Option - Version 5.2.0 and later
Oracle Thesaurus Management System - Version 5.2.0 and later
Information in this document applies to any platform.


The purpose of this script (createBDLFile.sql) is to spool a Batch Data Load file that populates the NEW TMS Parent question with the same data that was entered for the OLD TMS Parent. A standard PIPE (|) delimited load file will be spooled to 'c:\temp\bdl.txt' which can then be batch loaded via the Oracle Clinical 'Out Of Study' Batch Data Load menu options.

FYI: This note number is referenced in the TMS Users Guide => 'Using a New Version of a Dictionary for an Ongoing Study' => 'Upgrading to a New Dictionary Version with a New Structure' sub-section.

Note: Ensure the correct values are specified in the 'SPECIFY VALUES' section of the script before running it where:

vStudyName                 = Study name
nOldTMSParentDcmQuestionID = OLD TMS Parent DCM_QUESTION_ID
vDCM_QG_Name               = Question Group name (contains both the OLD (uncollected) and NEW TMS Enterable question)
vNewTMSParent_QName        = New TMS Parent Question Name
nDcm_ques_occurren_sn      = Question Occurence SN .. this is usually zero


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.