Files
Customer/onces/UWVA/uwva97_3.sql
Maarten van der Heide f25888e399 UWVA#35039 KOS-procedure starten via interface
svn path=/Customer/; revision=27742
2016-01-13 12:52:10 +00:00

49 lines
1.3 KiB
SQL

-- Customer specific once-script UWVA97_3.
--
-- (c) 2015 Facilitor B.V.
SET ECHO ON
SPOOL xuwva97_3.lst
SET DEFINE OFF
-- UWVA#35039: 47=PRSSYS
INSERT INTO fac_export_app (fac_export_app_code,
fac_export_app_oms,
fac_functie_key,
fac_export_app_charset,
fac_export_app_folder,
fac_export_app_prefix,
fac_export_app_file_prefix,
fac_export_app_postfix,
fac_export_app_log_postfix,
fac_export_app_flags,
fac_export_app_xsl,
fac_export_app_timestamp,
fac_export_app_datum)
VALUES ('KOS',
'KOS',
47,
NULL,
'.\KOS',
'UWVA',
'KOS',
'.xml',
'.log',
2, -- Manual allowed!
NULL,
'yyyymmdd_HHMMSS',
NULL);
COMMIT;
BEGIN adm.systrackscriptId('$Id$'); END;
/
SPOOL OFF
--@@uwva_prs.sql
--@@uwva_fin.sql
--@@uwva_hv.sql
@@uwva_misc.sql
BEGIN fac.registercustversion('UWVA', 97); END;
/
COMMIT;