IBM Mainframe Forum

Hi,

What is DB configurable variable/file? Can somebody please explain this in layman terms or provide a good link where it is explained. Also how is it created in DB2?

I searched internet before posting here but couldn't find anything substantial.

Hello,

Where did you learn of this terminology? It is not a term with which i'm familiar.

How might you use this?

From one perspective, almost everything is a "configurable variable".

Thanks Sir, i guess my issue is resolved now. We actually needed a method in which we have to perform a particular validation for some particular values. We don't want to hardcode these values. So i suggested that we keep this in file and update that as and when required. But my manager came up with this term - "Configurable variable". So got a bit confused and posted here. So this is just any variable/file which is configurable,ryt?

Hello,

So this is just any variable/file which is configurable,ryt?

Yup, sounds like this is what your manager meant.

I'd suggest creating one or more validation tables in the database and using these to ensure values are correct.

They would be maintained just like application data tables but would be restricted as to who can maintain them.

These users thanked the author dick scherrer for the post:

pulsar22 (Mon Sep 16, 2013 8:50 pm)

@pulsar22 - as dick suggested, create a table having some columns for storing the configurable variable\item\data like
01. ID of the Configurable item\variable\data
02. Name of the Configurable item\variable\data
03. input Value 1 (string) for the Configurable item\variable\data
04. input Value 1 (numeric) for the Configurable item\variable\data
05. input Value 1 (date) for the Configurable item\variable\data
06. output Value 1 (string) for the Configurable item\variable\data
07. output Value 1 (numeric) for the Configurable item\variable\data
08. output Value 1 (date) for the Configurable item\variable\data
09. tracking variables for creation - like user id who created , when created, which application created it, program id which creates it.
10. tracking variables for updation- like user id who updated , when updated, which application updated it, program id which updates it.

you can pass input values for a variable and get the output values for the Configurable item\variable\data.

If you will follow the above or similar one you will be able to use the same variable in various ways and can dynamically change the behavior of the same program as and when required.

-Regards
m4mainframe

These users thanked the author m4mainframe for the post:

pulsar22 (Mon Sep 16, 2013 8:50 pm)