Export Script (B.20.01.44) - Intergraph Smart Materials - Version 2020 (10.0) - Help - Hexagon PPM

Intergraph Smart Materials Classic Help (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Help
Smart Materials/Smart Reference Data Version
2020 (10.0)

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