RE: if defined syntax in sql rpg?

[Buck Calabro <Buck.Calabro@xxxxxxxxxxxx>]

>Is there some reason the regular RPG preprocessor 
>can't be run before the SQL preprocessor - or the 
>SQL preprocessor be taught about preprocessor
>macros?!?!?!?!

Yes; there have been several threads on this topic in the past.  The bottom
line is that there are two development groups at work here, and they don't
operate on the same schedule, so to speak.

>>Isolate all the SQL stuff in a separate service program.  
>>Make it so generic that you don't need precompiler/compiler 
>>directives, etc.  

>The problem is that I need to chose between two different 
>SQL statements.  The idea here is that our code should 
>be portable across different customers.  I need different 
>select statements depending on whose machine I am 
>compiling on.  So I have:
>
>C/if defined(USE_NUM_COLOC)
>   <use numeric comparison in select>
>C/else
>   <use alpha comparison in select>
>C/endif
>
>Other than that little select statement the rest of the 
>program is identical to all our other customers' versions.  

You have several ways round this.  Build two internal functions: a numeric
function and an alpha function.  Wrap them in a "get this data" function.
THAT function can query a system constant which you configure (by customer)
and call the proper "internal" function.

You can also investigate CLI http://www.as400.ibm.com/db2/clifaq.htm

Midrange Computing did an article in Dec 99 called "picklists on the fly"  I
have the save file for their library.

Buck