iSixSigma

How to Capture the Output of the Function That Has Two Outputs of Different Datatypes

Six Sigma – iSixSigma Forums General Forums Tools & Templates How to Capture the Output of the Function That Has Two Outputs of Different Datatypes

This topic contains 0 replies, has 1 voice, and was last updated by  sowmya1994 1 month, 1 week ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #240480

    sowmya1994
    Participant

    CP and CPK function is working fine with R-script in SQL.

    EXECUTE sp_execute_external_script

    @language = N’R’ ,

    @script = N’library(qualitytools)

    x <- rweibull(30, 2, 8) +100;

    (output dataset as.data.frame(cp(x, “weibull”, lsl = 100, usl = 117))),

    (df <- cp(x, “weibull”, lsl = 100, usl = 117);

    image_file = tempfile();

    jpeg(filename = image_file, width=500, height=500);

    hist(cp); dev.off();

    OutputDataset <- data.frame(data=readBin(file(image_file,”rb”),what=raw(),n=1e6)); ‘ ,@input_data_1 = N'(cp(x, “weibull”, lsl = 100, usl = 117));’

    @input_data_1_name = N’inputDataSet’ ,

    @output_data_1_name = N’OutputDataset’

    WITH RESULT SETS ((plot varbinary(max)));

    Please let me know how to capture the output of the function that has two outputs of different datatypes using R-script in SQL server-2019

    0
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.