- Back to Home »
- MultiExport list file ".lst" file create from ODI Rep SQL
Posted by :
Arjun Lagisetty
Thursday, April 20, 2017
Use the following code for creating a .lst file from ODI repository database. This file can be used for backup or migration.
This query gives the list of all project folders whose parent folder name start with 'CUSTOM'. 1100 is the object type code for folder objects in SNP_FOLDER table.
You can modify the SQL query as per your needs, query spooling options will deliver a clean file which can be directly used in the multi-export interface.
This query gives the list of all project folders whose parent folder name start with 'CUSTOM'. 1100 is the object type code for folder objects in SNP_FOLDER table.
You can modify the SQL query as per your needs, query spooling options will deliver a clean file which can be directly used in the multi-export interface.
SET TRIM ON
SET HEADING ON
SET PAGESIZE 660
SET NEWPAGE NONE
SET LINESIZE 40
SET TRIMSPOOL ON
SET FEEDBACK OFF
SET UNDERLINE OFF
SPOOL C:\TEMP\MULTEXPORTLIST.lst
SELECT 1100 || ',' || CHILD_FOLDER.I_FOLDER AS DESIGNER
FROM OBIA_BIA_ODIREPO.SNP_FOLDER CHILD_FOLDER
JOIN OBIA_BIA_ODIREPO.SNP_FOLDER PAR_FOLDER
ON PAR_FOLDER.I_FOLDER = CHILD_FOLDER.PAR_I_FOLDER
WHERE PAR_FOLDER.FOLDER_NAME LIKE 'CUSTOM%';
SPOOL OFF;