I am finding that a program which reads a Focus database and which contains dates with a format of A8 has quit selecting records properly when based on a date range. This database contains only 2008 and 2009 dates. I believe this is happening because of a '-INCLUDE' program change. The -include program does date calculations using DATEADD, DATEMOV and is where the dates used to select records come from.

If I add YRTHRESH AND DEFCENT to the program, the date selection works properly. My question is this...is it dangerous to use yrthresh and defcent at any time? In other words, I don't really see why I need these values set here and I'm wondering if perhaps this is NOT the real answer to fixing the program, even though it allows the program to work.

I'm also wondering if maybe I should be using YRTHRESH and DEFCENT in the -INCLUDE program itself, making it unnecessary in my main program...but I have MANY other programs that also -include this same program, which are running fine. What might happen to them if I add the yrthresh and defcent to the program being -included IF they don't need it?

This message has been edited. Last edited by: LaVonne,

Yes, imho, it is dangerous to do so. The YRTHRESH and DEFCENT should be set at a systems level. If you were to include the setting of these in a specific program (-INCLUDEd or MAIN) then some programs will act differently then others to to, potentially, different settings for YRTHRESH and DEFCENT.

Thanks Doug, thats what I thought.

Does anyone know of an alternative to set these parameters at system level?

Thanks.

Hua

edasprof.cfg ?

It's edasprof.prf, not edasprof.cfg. It can be edited from the reporting server console.

Thanks a lot! Ginny & njsden.


Hua

quote:

It's edasprof.prf, not edasprof.cfg

Oops! Sorry about the confusing answer. It's obvious that I didn't even check my server for the right file name ... for some reason I had cgivars.cfg in my head and that ".cfg" piece got stuck to my head

Thanks Ginny for your timely correction