> ## Documentation Index
> Fetch the complete documentation index at: https://docs.flexagon.com/llms.txt
> Use this file to discover all available pages before exploring further.

# packageBuild(SQLcl)

> Collects a group of SQL and other files to be run by the operation. Files can be populated from the SCM of your choice. See for information about the

Collects a group of SQL and other files to be run by the [packageDeploy(SQLcl)](https://flexagon.atlassian.net/wiki/spaces/FD111/pages/12596421897/packageDeploy+SQLcl) operation. Files can be populated from the SCM of your choice. See [the appendix](https://docs.flexagon.com/flexdeploy-11-1-documentation/flexdeploy-plugin-guides/flexdeploy-sqlcl-plugin-guide/appendix-sqlcl.md) for information about the project file attributes.

Please note that the statements in the SQL files must be delimited properly.the operation here.

# Project Properties

<table><colgroup><col /><col /><col /><col /></colgroup><tbody><tr><th>**Property Name**</th><th>**Property Code**</th><th>**Required**</th><th>**Description**</th></tr><tr><td>Project File Includes\
</td><td>`FD_PARTIAL_FILE_INCLUDES`</td><td>No</td><td>Controls files included in Project Files. Enter expressions separated by ##. Leave empty to select all files. Begin or end the expression with \* for simple wildcards. Otherwise, regex\
is used. (e.g. /java/*##*.java##*person*##/java/.*\[tT]est.*.java)</td></tr><tr><td>Project File Excludes</td><td>`FD_PARTIAL_FILE_EXCLUDES`</td><td>No</td><td>Controls files excluded from Project Files. Enter expressions separated by ##. Leave empty to select all files. Begin or end the expression with \* for simple wildcards. Otherwise,\
regex is used. (e.g. /java/*##*.java##*person*##/java/.*\[tT]est.*.java)</td></tr></tbody></table>

# Artifacts

This operation produces package deploy file packages for use by the [packageDeploy(SQLcl)](https://flexagon.atlassian.net/wiki/spaces/FD111/pages/12596421897/packageDeploy+SQLcl) operation.

# Endpoint Selection

This operation will select all available endpoints associated to the target.

# Endpoint Execution

This operation will randomly execute on one of the endpoints identified during selection.

# Special Considerations

Please see below for information about the project file attributes

# Supported Object Types

The SQLcl plugin partial deploy support allows for deploying File and Folder type objects. These links explain the three types and their attributes.

## Object Types

1. [DB Objects](https://docs.flexagon.com/flexdeploy-11-1-documentation/flexdeploy-plugin-guides/flexdeploy-sqlcl-plugin-guide/appendix-sqlcl/sqlcl-package-object-types/sqlcl-object-types-db-objects.md)

2. [Other Objects](https://docs.flexagon.com/flexdeploy-11-1-documentation/flexdeploy-plugin-guides/flexdeploy-sqlcl-plugin-guide/appendix-sqlcl/sqlcl-package-object-types/sqlcl-object-types-other-objects.md)
Property Name	Property Code	Required	Description
Project File Includes\	`FD_PARTIAL_FILE_INCLUDES`	No	Controls files included in Project Files. Enter expressions separated by ##. Leave empty to select all files. Begin or end the expression with \* for simple wildcards. Otherwise, regex\ is used. (e.g. /java/##.java##person##/java/.\[tT]est..java)
Project File Excludes	`FD_PARTIAL_FILE_EXCLUDES`	No	Controls files excluded from Project Files. Enter expressions separated by ##. Leave empty to select all files. Begin or end the expression with \* for simple wildcards. Otherwise,\ regex is used. (e.g. /java/##.java##person##/java/.\[tT]est..java)