How to Capture the Output of the Function That Has Two Outputs of Different Datatypes
- July 17, 2019 at 1:01 am #240480
sowmya1994Participant@sowmya1994 Include @sowmya1994 in your post and this person will
be notified via email.
CP and CPK function is working fine with R-script in SQL.
@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);
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-20190
You must be logged in to reply to this topic.