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

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. The host name can be a variable or a literal string. The literal string or the value of the variable is the URL of the server in single quotation marks.

When DataFlux Data Management Server is secured with SSL, the URL must use https instead of http (for example, https://myhost.unx.com).
Interaction If a zero-length string is entered for the host argument, then the value localhost is used.
Example
        /* Incorrect use of function arguments */
           dmsrvProfileJob('jobname');

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

        /* Correct */
           dmsrvProfileJob(jobname, 'http://myhost.unx.com', 
          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', 'http://myhost.unx.com', 
          0, 1);

        /* Correct */
           dmsrvProfileJob('jobname', 'http://myhost.unx.com', 
          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', 
       'http://myhost.unx.com', 21036, 1);
run;