× 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. January 2013

Re: Embedded static sql case

If I understand you correctly, you want to select a specific company, or all companies.

What about this approach?

WHERE COMPANY BETWEEN :LO_CMPNY and :HI_CMPNY

Before you open the cursor:

If you want a specific company set both LO_CMPNY and HI_CMPNY to the same value, the company you want.

If you want all companies, set LO_CMPNY to *LOVAL and HI_CMPNY to *HIVAL.

Sam

On 1/29/2013 9:28 AM, Horn, Jim wrote:
I know I could do this with dynamic sql but how about static -

I want to put options in the select criteria based on something entered
into the program. Is there some kind of case statement that would work?
Something like -
WHERE
(CASE WHEN 0 = :@COMPANY THEN 1
WHEN 0 < :@COMPANY AND A.ITCOMPANY = @COMPANY THEN 1
ELSE 0
END) = 1

where @company is 0 or a company# entered into the program

Jim

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
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.