CA Service Management

Dec 01, 2015 08:49 AM

TMACUL

How to load a Survey Answer?

bop_sinfo -dq svy_atpl
Factory svy_atpl < Survey_Answer_Template > Attributes: id INTEGER UNIQUE producer_id LOCAL STRING(20) persistent_id persid STRING(30) text txt STRING(400) sequence INTEGER REQUIRED owning_survey_question <own_srvy_question> SREL -> svy_qtpl.id REQUIRED delete_flag del SREL -> actbool.enum REQUIRED last_mod_dt DATE last_mod_by SREL -> cnt.id TENANCY_UNRESTRICTED tenant SREL -> tenant.id

Factory svy_atpl < Survey_Answer_Template >

Attributes:

id INTEGER UNIQUE

producer_id LOCAL STRING(20)

persistent_id persid STRING(30)

text txt STRING(400)

sequence INTEGER REQUIRED

owning_survey_question <own_srvy_question> SREL -> svy_qtpl.id REQUIRED

delete_flag del SREL -> actbool.enum REQUIRED

last_mod_dt DATE

last_mod_by SREL -> cnt.id TENANCY_UNRESTRICTED

tenant SREL -> tenant.id

pdm_extract Survey_Answer_Template
TABLE Survey_Answer_Template del id last_mod_by last_mod_dt owning_survey_question persid sequence tenant txt

TABLE Survey_Answer_Template

del id last_mod_by last_mod_dt owning_survey_question persid sequence tenant txt

pdm_load -v -i -f Survey_Answer_Template.txt
TABLE Survey_Answer_Template del id last_mod_by last_mod_dt owning_survey_question persid sequence tenant txt { "0" ,"400001" ,"F4C2A60100EA154695D233F90ABFFD21", "06/18/2015 16:38:25" ,"400001" ,"svy_atpl:400001" ,"10" ,"" ,"Ótimo" }

TABLE Survey_Answer_Template

del id last_mod_by last_mod_dt owning_survey_question persid sequence tenant txt

{ "0" ,"400001" ,"F4C2A60100EA154695D233F90ABFFD21", "06/18/2015 16:38:25" ,"400001" ,"svy_atpl:400001" ,"10" ,"" ,"Ótimo" }