Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

collection of reusable code, programs, and database objects that provides common functionality across all E-Business products.

Object Type Identification

  • If a .sql file is not a Concurrent program (indicated by parent folder), then it is considered DB Objects (SQLs).
  • Files ending in file extensions added to the EBS SQL Extensions (FDEBS_SQL_EXTENSIONS) project property are also added.
    • EBS SQL Extensions property defaults to seq,tbl,idx,typ,tps,tpb,sql,pkh,plb,pks,pkb,pls,pck,fnc,trg,spc,bdy,prc.
Tip

Files with .sql extension are identified as this type only AFTER excluding them as Concurrent Program SQLs (by source folder).

Files that start with "SCHEMA" will automatically update the user and password properties accordingly. See SQL File Considerations for more information.

File Extensions 

NameDescription
.seq,tbl,idx,typ,tps,tpb,sql,pkh,plb,pks,pkb,pls,pck,fnc,trg,spc,bdy,prcA file containing sql statements. Extensions may be customized using the FDEBS_SQL_EXTENSIONSthe SQL Extensions project property.

Object Type

...

NameCode
DB Objects (SQLs)SQL

Object Type Attributes

NameCodeDescriptionDefault ValueSupported Values
SourceSOURCEObject Source Location Type

SCM

SCM
Target LocationTARGET_LOCATIONPath to where the file should be deployed to.$<PROD_TOP>/patch/115/sql/
TypeTYPEDB Object TypeGeneric SQL
DB User PropertyDB_USERFlexDeploy property to use as the user to connect to the database with.

FDEBS_DB_USER

You can use file name like SCHEMASCHEMANAME_FILENAME.sql. For example, SCHEMAPOS_registertrans.tbl. In this case this will default to FDEBS_DB_SCHEMAPOS_USER.


DB Password PropertyDB_PASSWORDFlexDeploy property to use as the password for the DB User Property.

FDEBS_DB_PASSWORD

You can use file name like SCHEMASCHEMANAME_FILENAME.sql. For example, SCHEMAPOS_registertrans.tbl. In this case this will default to FDEBS_DB_SCHEMAPOS_PASSWORD.


Ignore FailureIGNORE_FAILURE

Check if failure in file should be ignored.

If file contains WHENEVER SQLERROR CONTINUE case insensitively, this property will default to true.
Fix SQL SyntaxFIX_SQL_SYNTAX

If there is need to add / at the end of file, FlexDeploy will add it at deploy time. For example, if there is program block as last statement, we need / and new line after it.

True
Target File PermissionFILE_PERMISSIONSPermissions to apply to the file after it is deployed
<None>
Defaults to the project property FDEBS_FILE_PERMISSIONS

Related Project Properties

NameCodeDescriptionDefault Value
EBS
SQL Root Source DirectoryFDEBS_SQL_ROOT_SOURCE_DIRSource folder for sql and pls files (e.g. db).sql
EBS
SQL Root Destination DirectoryFDEBS_SQL_ROOT_DESTINATION_DIRTarget directory for SQL and PLS files (e.g. XXHR_TOP/admin/sql).$<PROD_TOP>/patch/115/sql
EBS
SQL ExtensionsFDEBS_SQL_EXTENSIONSSQL file extensions in their order to process.

seq,tbl,idx,typ,tps,tpb,sql,pkh,plb,pks,pkb,pls,pck,fnc,trg,spc,bdy,prc

See Database SQL file extensions and their order of process.

EBS
SQL Ignore Compile Errors
File ListList of files to ignore errors (e.g. DropHRTables.sql,*_ddl.sql).EBS SQL Ignore Compile Errors
FDEBS_SQL_IGNORE_COMPILE_ERRORSIgnore SQL compilation errors
.
for all files in the projectfalse
EBS
SQL Retry CountFDEBS_SQL_RETRY_COUNTRetry count for SQLs and PL/SQLs.5
File PermissionsFDEBS_FILE_PERMISSIONSTarget File Permission. Will be set to target file after deployment using chmod. eg: 755
Ignore Errors File ListFDEBS_IGNORE_ERRORS_FILE_LISTList of files to ignore errors (e.g. DropHRTables.sql,*_ddl.sql).

Sample Build Commands 

N/A - Build commands not supported for this type.

...