Hello,
I'm trying to find some options for a pass through query to SQL which would allow the table to still have new records appended while the query is running. Here's a version of what I've tried so far:
rsubmit;
proc sql;
%odbc_connect(alias=CRGMT,dsn=NeuAnalytics,user=&sqlpw.,password=&EIW_pwd.);
/* Connection=sharedread ?? */
execute(SET NOCOUNT ON
OPEN SYMMETRIC KEY AccountAudit_Key11
DECRYPTION BY CERTIFICATE AccountAudit09) by CRGMT;
execute(SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED) by CRGMT;
create table R1Remed as
select * from connection to CRGMT
(
SELECT distinct
WorkItemId
, StartDate
, QTemplateVersionWorkItemId
, QTemplateInfoId
, QTemplateVersionId
, QuestionAnswerOptionId
, AnswerOption
, cast(AnswerText as varchar(1000)) as AnswerText
, AccountImportDetailId
,[FileName]
FROM WorkItem.QTemplateVersionWorkItem TVWI
LEFT JOIN workitem.[WorkItemQTemplateAnswer] WTA ON TVWI.QTemplateVersionWorkItemId = WTA.QTemplateVersionWorkItemId
WHERE StartDate > '9/1/2016'
AND StatusId <> 6
);
disconnect from CRGMT;
quit;
endrsubmit;
