DMSRVPROFILEJOB Function

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

Syntax

DMSRVPROFILEJOB (job-name, host, port, append-flag <,description-character> )

Required Arguments

job-name
identifies the DataFlux Data Management Profile job as it exists on the specified DataFlux Data Management Server.
host
identifies the host of the DataFlux Data Management Server.
Interaction:If a zero-length string is entered for the host argument, then the value localhost will be used.
Example:
        /* Incorrect use of function arguments */
           dmsrvProfileJob('jobname');

        /* Localhost is used for the host */
           dmsrvProfileJob(jobname, '', 21036, 0);

        /* Correct */
           dmsrvProfileJob(jobname, dmsrvhostname, 21036, 0);   
port
identifies the port through which the host communicates with the DataFlux Data Management Server.
Interaction:If the value specified is less than or equal to 0, then port number 21036 is used with SOAP, or port number 21037 is used when using Wireline.
Example:
        /* Incorrect use of function arguments */
           dmsrvProfileJob('jobname');

        /* Port 21036 or 21037 is used */   
           dmsrvProfileJob('jobname', dmsrvhostname, 0, 1);

        /* Correct */
           dmsrvProfileJob('jobname', dmsrvhostname, 21036, 1);   
append-flag
appends or overwrites job results.
0 appends job results below any existing content in the results file.
1 overwrites any existing content in the results file.

Optional Argument

description-character
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 are appended to the bottom of the results file.

Details

The DMSRVPROFILEJOB function generates a profile from a Data Management server repository.

Example: DMSRVPROFILEJOB Function

The following example generates a profile from the specified repository.
data _null_;
     jobid = dmsrvProfileJob('myfolder/prof_job', 'myserver', 21036, 1);
run;