Another avenue that hasn't been mentioned yet is using the SPDE engine/format.  We had a set of very large files and processing streams that took several days to run.  Converting the masters to SPDE datasets resulted in substantial disk savings.  Often 90%.   While not all applications will benefit (random I/O being one), that is certainly something to consider.  SPDE also uses available memory and CPU which is both good and bad.  On the largest monthly job I was politely asked if I would run that on the weekend.  Oops.   --Ben ... View more

Try use ODS TEXT='xxxxxxx'  to replace TITLE .   ods escapechar='~' ; ods text='xxxxxx  ~n yyyyy'; ... View more

@SASKiwi wrote: @andreas_lds - Only problem is I'm the wise Admin who should know these things...I tried adding EG Advanced Role (since that was the role listed in the documentation) to my user but that didn't seem to help. Interesting, we have disabled the capability in our custom EG-role, but when i switch to EG Advanced Role, the option does not appear in File/Open. Strange. Maybe a problem with EG 7.15 HF6 - will check this as soon as i can spare the time. ... View more

Right now I am just trying to understand if X an Y are associated. Or to state it another way ( I think) are X and Y independent of each other. Which it looks like they are not. ... View more

It depends on the rest of the query - COALESECE() may be an option for example. Is table B already in the query somewhere? ... View more