- All Products
executequery -q <query_name> [-t <query_type (shared or personal)>] [-u <output_persistent_file_name>] [-a (append)] [-c <column_separator] [-r <end-of-record_separator>] [-l <end-of-listing_indicator>] [-b (verbose)] [-y (print database type)] [-n (do not include parent path)] [-s <dbd_separator>]
Required. Name of the query to run.
Optional. Type of query to run. You can specify public or private. If not specified,
pmrepsearches all the private queries first to find the matching query name. Then it searches the public queries.
Optional. Send the query result to a text file. If you do not enter a file name, the query result goes to stdout.
Optional. Appends the query results to the persistent output file. If you do not enter this option,
pmrepoverwrites the file content.
Optional. Character or set of characters used to separate object metadata columns. Use a character or set of characters that is not used in repository object names. If any repository object name contains spaces, you might want to avoid using a space as a column separator.
If you omit this option,
pmrepuses a single space.
Optional. Character or set of characters used to specify the end of the object metadata. Use a character or set of characters that is not used in repository object names. If you omit this option,
pmrepuses a new line.
Optional. Character or set of characters used to specify the end of the object list. Enter a character or set of characters that is not used in repository object names. If you omit this option,
pmrepuses a period.
Optional. Verbose. Displays more than the minimum information about the objects. If you omit this option,
pmrepprints a shorter format including the object type, the word reusable or non-reusable, the object name and path. Verbose format includes the object status, version number, folder name, and checked out information.
The short format for global objects, such as label, query, deployment group, and connection, includes the object type and object name. Verbose format includes the label type, query type, deployment group type, creator name, and creation time.
Optional. Displays the database type of sources and targets.
Optional. Does not include the full parent path of non-reusable objects in the query result. For example, if you use this option and the result includes a non-reusable transformation,
pmrepprints transformation_name instead of mapping_name.transformation_name. This option can improve
Optional. If an ODBC source has a period (.) in the name, define a different separator character when you define the source object. For example, instead of database_name.source_name, define the source object as database_name\source_name, and define the dbd_separator as backslash (\).
Updated October 17, 2022