This script (B200144.sql) is run by the B.20.01.44 module after all export parameters have been specified and the export job is started. It calls the server side main procedure and spools out the extracted BOM data from the interface table to the specified file. For batch download, another script file (B200144B.sql) with slightly different options is provided.
REM ---------------------------------------------------
REM Smart Materials
REM ---------------------------------------------------
REM
REM File: B200144.SQL
REM List Download
REM Author: PSchneider
REM Created: 16-MAR-1997
REM
REM Modifications, changes, enhancements, fixes:
REM
REM When Who What
REM --------- ---------- ---------------------------------------------------
REM 13-MAR-98 PSchneider Added m_list_pos.input_3 - input_5 to exported data
REM 06-APR-98 PSchneider Added support for query condition on node structure,
REM new parameter is p_aqc_id
REM 02-JUL-98 PSchneider Added Issue Status for BOM position selection,
REM new parameter is p_stat_id
REM 12-JAN-99 PSchneider Added maxdata and array size parameters
REM 17-FEB-1999 PSchneider Added new fields for OMI 5.1.0
REM 13-DEC-1999 PSchneider Changed field sizes for OMI 5.2.0
REM --------------------------------------------------------------------------
REM
REM
REM Parameters for procedure call are:
REM
REM &1: p_from_project BOOLEAN
REM &2: p_from_pr_name V2(10)
REM &3: p_luv_id NUMBER(12)
REM &4: p_user_dp_id NUMBER(12)
REM &5: p_ln_id_start NUMBER(12)
REM &6: p_with_struc BOOLEAN
REM &7: p_with_pos BOOLEAN
REM &8: p_assem_option NUMBER
REM &9: p_attr_option NUMBER
REM &12: p_aqc_id NUMBER
REM &13: p_stat_id NUMBER
REM
REM Spool parameters:
REM
REM &10: Name of spoolfile
REM &11: Path for spoolfile
REM
REM WHENEVER SQLERROR EXIT FAILURE
REM WHENEVER OSERROR EXIT FAILURE
SET TAB OFF
SET TIMING OFF
SET FEEDBACK OFF
SET LINESIZE 3710
SET MAXDATA 50000
SET ARRAYSIZE 1
SET PAGESIZE 0
SET TIMING OFF
SET HEADING OFF
PROMPT
PROMPT
SELECT '******************' FROM dual;
SELECT '* *' FROM dual;
SELECT '* SMat ' || m_pck_install_infos.marian_version || ' *' FROM dual;
SELECT '* *' FROM dual;
SELECT '******************' FROM dual;
PROMPT
SELECT m_pck_install_infos.copyright_1 FROM dual;
PROMPT
PROMPT
PROMPT Module: B.20.01.44 List download
PROMPT
PROMPT
PROMPT Call parameters:
PROMPT
PROMPT Projekt: &2
PROMPT Spoolfile: &11.\&10
PROMPT
PROMPT LUV id: &3
PROMPT Assembly option: &8
PROMPT Attribute option: &9
PROMPT Query condition id: &12
PROMPT
PROMPT Calling download procedure...
PROMPT
SET TERMOUT ON
SET ECHO OFF
EXECUTE m_pck_bom_download.m_list_download_prc(&1, '&2', &3, &4, &5, &6, &7, &8, &9, &12, &13)
SET TERMOUT ON
PROMPT Procedure completed. Starting download...
SPOOL &11.\&10
SET TERMOUT OFF
SET TRIMSPOOL ON
SELECT
RTRIM(DECODE(import,'Y',kind,'N', rpad('--|',3+2*(ei_level-1),'__') || kind)
|| '|' || one || '|' || two || '|' || three || '|' || four || '|' || five || '|'
|| six || '|' || seven || '|' || eight || '|' || nine || '|' || ten || '|'
|| eleven || '|' || ei_level || '|' || object || '|' || rev || '|' || unit || '|'
|| option_code || '|' || item || '|' || in_3 || '|' || in_4 || '|' || in_5 || '|'
|| thirteen || '|' || fourteen || '|' || fifteen || '|' || sixteen || '|' ||
seventeen || '|')
FROM m_export_interfaces
ORDER BY ei_seq_id;
SPOOL OFF
SET HEADING ON
SET PAGESIZE 24
SET LINESIZE 100
SET FEEDBACK ON
SET TERMOUT ON
PROMPT
PROMPT Download done. Press <ENTER> to return to Smart Materials.
PAUSE
EXIT