topic Executing pass through only once in a project in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Executing-pass-through-only-once-in-a-project/m-p/105702#M9204 <HTML><HEAD></HEAD><BODY><P><BR />I am trying to write a program which connects to oracle to extract sequence object and storing it into a variable.</P><P></P><P>How can I modify my sql pass through statement so that it runs only once ? My requirement is that first time i run eg project, i need to run the pass through and next time when i run the project, I need to have the value which i retained first...</P><P></P><P></P><P>Can anyone help me out with this?</P></BODY></HTML> Thu, 11 Apr 2013 23:51:39 GMT Sheeba 2013-04-11T23:51:39Z Executing pass through only once in a project https://communities.sas.com/t5/SAS-Enterprise-Guide/Executing-pass-through-only-once-in-a-project/m-p/105702#M9204 <HTML><HEAD></HEAD><BODY><P><BR />I am trying to write a program which connects to oracle to extract sequence object and storing it into a variable.</P><P></P><P>How can I modify my sql pass through statement so that it runs only once ? My requirement is that first time i run eg project, i need to run the pass through and next time when i run the project, I need to have the value which i retained first...</P><P></P><P></P><P>Can anyone help me out with this?</P></BODY></HTML> Thu, 11 Apr 2013 23:51:39 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Executing-pass-through-only-once-in-a-project/m-p/105702#M9204 Sheeba 2013-04-11T23:51:39Z Re: Executing pass through only once in a project https://communities.sas.com/t5/SAS-Enterprise-Guide/Executing-pass-through-only-once-in-a-project/m-p/105703#M9205 <HTML><HEAD></HEAD><BODY><P>The simplest would be to split into two projects - one for your one time job, and store it's results in permanent location.</P><P>And the next project will read from that.</P></BODY></HTML> Fri, 12 Apr 2013 08:08:47 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Executing-pass-through-only-once-in-a-project/m-p/105703#M9205 LinusH 2013-04-12T08:08:47Z Re: Executing pass through only once in a project https://communities.sas.com/t5/SAS-Enterprise-Guide/Executing-pass-through-only-once-in-a-project/m-p/105704#M9206 <HTML><HEAD></HEAD><BODY><P>Thanks Linush... I will try that....Since it is oracle sequence number, I want that to be created for each project.</P></BODY></HTML> Fri, 12 Apr 2013 15:20:34 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Executing-pass-through-only-once-in-a-project/m-p/105704#M9206 Sheeba 2013-04-12T15:20:34Z