Functions and CALL Routines

DQSRVPROFJOBFILE Function

Runs a file-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

identifies 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

(optional) identifies the host of the DataFlux Integration Server. If this value is not specified, then localhost is used

job-name

identifies 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 associatedDataFlux 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 associatedDataFlux 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

(optional) 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.

results-filename

identifies the file that receives job results.

Example

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

jobid=dqsrvProfJobFile('ProfileCustomerData','profServer2',5001,
  'custprof.pfo',1,'Profile of Customer Data','datapath',
   '/dept/marketing/customers');

0	appends job results below any existing content in the results file.
1	overwrites any existing content in the results file.

DQSRVPROFJOBFILE Function

Syntax

Arguments