Export Script - Intergraph Smart Materials - Version 10.2 - Help - Hexagon

Intergraph Smart Materials Classic Help

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2

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