Check environment variables in Jobs set to $PROJDEF

[MT]

Hi,

we want to double check that all our environment variables are really set to $PROJDEF before we move the projekt from development to production.
I am looking for a script / universe sql / job or any trick how I could list all the variable settings in a project (or export) to check the variables are really set to $PROJDEF.

Any help is appreciated
Thanks in advance
MT

[kduke]

I think I posted the SQL. Do a search for MvParam and kduke as the poster.

[MT]

Hi,

thanks KDUKE super input
but I would like a little more details what is going on when you do i.e.

INSERT INTO DICT DS_JOBOBJECTS
(
FIELD,
CODE,
EXP,
NAME,
FORMAT,
SM,
ASSOC
) VALUES (
'ParamNames',
'D',
'14',
'ParamNames',
'50L',
'M',
'MvParams'
)
;

Sorry - this might be trivial to you but I could not find a satisfying answer in the documentation....
What does the DICT Keyword mean in INSERT INTO DICT ...
Where can I find what the input fields and values mean (i.e. SM = M???)

Thanks in advance
kind regards
MT

[kduke]

DICT is short for dictionary. This is where Universe stores its column names. The repository was originally written in Universe. Universe is a database whic IBM owns. It is slowly being phased out. There are lots of posts on how this has been happening.