This script is called when the main export program has finished spooling the data out to a flat ASCII file.
REM ---------------------------------------------------
REM Smart Materials
REM ---------------------------------------------------
REM
REM File: OIE_510.SQL
REM Spool script for Open Ident Interface -
REM Online Export of Data.
REM Will be called immediately after export
REM main procedure has finished
REM Author: PSchneider, UBH
REM Created: 27-NOV-1998
REM Changed: 30-Jan-2001, NR, Reading version and
REM copyright from database
REM ---------------------------------------------------
REM
REM
REM Parameters for script call are:
REM
REM &1: oiiej_id m_oii_import_jobs.oij_id%TYPE -> NUMBER(12)
REM &2: Fully qualified name for spoolfile
REM
WHENEVER SQLERROR EXIT FAILURE
WHENEVER OSERROR EXIT FAILURE
SET TAB OFF
SET ECHO OFF
SET TIMING OFF
SET FEEDBACK OFF
SET LINESIZE 4320
SET TRIMSPOOL ON
SET PAGESIZE 0
SET ARRAYSIZE 1
SET VERIFY OFF
SPOOL &2
SELECT '--' || chr(10) ||
'-- ******************' || chr(10) ||
'-- * *' || chr(10) ||
'-- * SMat ' || m_pck_install_infos.marian_version || ' *' || chr(10) ||
'-- * *' || chr(10) ||
'-- ******************' || chr(10) ||
'--' || chr(10) ||
'-- Open Ident Interface - Data Export File' || chr(10) ||
'--' || chr(10) ||
'-- ' || m_pck_install_infos.copyright_1 || chr(10) ||
'--' || chr(10) ||
'--' || chr(10) ||
'-- Call parameters:' || chr(10) ||
'--' || chr(10) ||
'-- OIIE Job ID : ' || o.oiiej_id || chr(10) ||
'-- Job Code : ' || o.oiiej_code || chr(10) ||
'-- Project (PG) : ' || o.proj_id || chr(10) ||
'-- Query Cond (Idents) : ' || NVL(aqci.aqc_code, 'None') || chr(10) ||
'-- Query Cond (Assembly) : ' || NVL(aqca.aqc_code, 'None') || chr(10) ||
'-- Started on : ' || to_char(o.job_start_date, 'DD-MON-YYYY') || chr(10) ||
'-- Server side log file : ' || o.mar_logfile_name || chr(10) ||
'-- Spoolfile : &&2' || chr(10) ||
'--' || chr(10) ||
'-- -------------------------------------------------------' || chr(10) ||
'-- ---------------- Data Section starts ----------------' || chr(10) ||
'-- -------------------------------------------------------' || chr(10) ||
'--'
FROM m_sys.m_adm_query_conds aqca,
m_sys.m_adm_query_conds aqci,
m_sys.m_oii_export_jobs o
WHERE o.oiiej_id = &&1
AND o.aqc_id_idents = aqci.aqc_id (+)
AND o.aqc_id_assemblies = aqca.aqc_id (+);
SET TERMOUT OFF
SELECT rec_type || '|' ||
f1 || '|' ||
REPLACE(REPLACE(f2, chr(10), ' '), chr(13), ' ') || '|' ||
REPLACE(REPLACE(f3, chr(10), ' '), chr(13), ' ') || '|' ||
f4 || '|' ||
f5 || '|' ||
f6 || '|' ||
f7 || '|' ||
f8 || '|' ||
f9 || '|' ||
f10 || '|'
FROM m_sys.m_oii_export_data
WHERE oiiej_id = &&1
ORDER BY oiied_id;
SET TERMOUT ON
DELETE FROM m_sys.m_oii_export_data
WHERE oiiej_id = &&1;
COMMIT WORK;
SELECT '--' || chr(10) ||
'-- -------------------------------------------------------' || chr(10) ||
'-- ----------------- Data Section ends -----------------' || chr(10) ||
'-- -------------------------------------------------------' || chr(10) ||
'--' || chr(10) ||
'--' || chr(10) ||
'--' || chr(10) ||
'-- OII Export done.' || chr(10) ||
'--' || chr(10)
FROM dual;
SPOOL OFF
EXIT