Desktop productivity for business analysts and programmers

Executing pass through only once in a project

Reply
Regular Contributor
Posts: 158

Executing pass through only once in a project


I am trying to write a program which connects to oracle to extract sequence object and storing it into a variable.

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...

Can anyone help me out with this?

Esteemed Advisor
Posts: 5,202

Re: Executing pass through only once in a project

The simplest would be to split into two projects - one for your one time job, and store it's results in permanent location.

And the next project will read from that.

Data never sleeps
Regular Contributor
Posts: 158

Re: Executing pass through only once in a project

Thanks Linush... I will try that....Since it is oracle sequence number, I want that to be created for each project.

Ask a Question
Discussion stats
  • 2 replies
  • 162 views
  • 3 likes
  • 2 in conversation