Functions and CALL Routines

DQSRVPROFJOBREP Function

Runs a repository-type DataFlux dfProfile job on a DataFlux Integration Server and returns a job identifier.

Requirement:	The character variable that receives the return value must have a minimum length of 52 characters.
Valid in:	DATA step, PROC SQL, and SCL

Syntax
Arguments
Example
See Also

Syntax

DQSRVPROFJOBREP (job-name<,host><,port>,repository,report,description<,macro-name1> <,macro-value1> <,macro-name2> <,macro-value2...>)

Arguments

description: is a character variable whose value describes the current run of the job. The descriptive text is added either to the top of the results file or above the results that is appended to the bottom of the results file.
host: identifies the host of the DataFlux Integration Server. If this value is not specified, then localhost is used
job-name: is the DataFlux dfPower Profile job as it exists on the specified DataFlux Integration Server.
macro-name1: identifies a DataFlux dfPower Profile macro that exists on the DataFlux Integration Server. The value of macro-name1 can be specified as text or as the name of a character variable. The value of the variable specifies the name of the macro.
macro-value1: specifies the character value that is used by the associated DataFlux dfPower Profile macro. Macro-value1 is used by macro-name1. The value of macro-value1 can be specified as text, or as the name of a character variable.
macro-name2: identifies a DataFlux dfPower Profile macro that exists on the DataFlux Integration Server. The value of macro-name2 can be specified as text or as the name of a character variable. The value of the variable specifies the name of the macro.
macro-value2: specifies the character value that is used by the associated DataFlux dfPower Profile macro. Macro-value2 is used by macro-name2. The value of macro-value2 can be specified as text, or as the name of a character variable.
port: identifies the port through which the local host communicates with the DataFlux Integration Server. If this value is not specified, or if the value is 0 or a negative number, then the default port number 21036 is used.
report: is the file that receives the report that is generated by the DataFlux dfPower Profile job.
repository: is the repository on the DataFlux Integration Server that contains the DataFlux dfPower Profile job.

Example

The following example runs a data analysis job on a repository of sales data using a DataFlux Integration Server and the DataFlux dfPower Profile software. A macro identifies the location of the data.

jobid= dqsrvProfJobRep('ProfileSalesRepository','profServer2',5001,
   'Sales_Repository',1,'Profile of Sales Data','datapath',
   '/dept/sales/Q3');