1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
| set term off
set colsep ";"
set heading OFF
set pagesize 0
set linesize 250
set numwidth 8
set tab off
set trimspool on
set verify off
set heading off
set space 0
set echo off
set feedback off
set trimout off
set termout off
SET HEADSEP off
/* accept spoolfile prompt 'Ouput file name ==> ' */
spool &1
define var_table = 'PLW_CODE_ARRIMAGE';
/* Check bool sur la table NETWORK et TASK */
SELECT
TRIM(SEQ_ARRIMAGE) AS SEQ_ARRIMAGE,
TRIM(NO_PA) AS NO_PA,
TRIM(LOT_DEBUT) AS LOT_DEBUT,
TRIM(TYPE_DEBUT) AS TYPE_DEBUT,
TRIM(SEQUENCE_DEBUT) AS SEQUENCE_DEBUT
.......
FROM PLW_CODE_ARRIMAGE;
spool off
prompt === Generated file : &1
set head on
set echo on
quit; |
Partager