× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. June 2007

Re: Creating SQL view for RPG at runtime.

David,

Instead of creating a view, build the SQL select statement using a
character string at run time and then EXECUTE IMMEDIATE the character
string.

Hope this helps.

Glenn

Hi all,

Using SQL with RPG is totally new in our company.

I have created a view which uses CURRENT DATE amongst other criteria that
I read as a primary file in my RPG.
This program will be planned to run at the end of the last working day of
each month.

What if the program has to be run on the first day in case of a problem?
It would use the data from the wrong month.

I have a CLP which inititializes my output files: I think I should I be
creating my view at the same time, using my planned date instead of
CURRENT DATE.

Where or how would one do this?

My output files can be created simply but for the input (view) I would
need a source file for RUNSQLSTM or a separate SQLRPGLE program.

Is there a correct way to go about this.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.