I'd like to understand the use of EXEC SQL INCLUDE a bit better.
Can somebody explain (or point me to a good doc explanation)... what does EXEC SQL INCLUDE actually do and also what happens if host variables i.e. table layouts etc aren't declared inside one i.e. are just declared as regular working-storage items? Also does it matter if fields 'included' as it were, are not actually used with sql?
Do I need the special sqlda and sqlca includes or are they created automatically? If I do,can I copy the content into my own copybook? - ideally I'll have just one db related copybook that I can put it into the 100 or so programs I'm converting?
Should mfsqlmessagetext be 'included' ? Does it matter if it is or isn't?
Thanks in advance,