DB Configurable Variable?



IBM's flagship relational database management system

DB Configurable Variable?

Postby pulsar22 » Wed Sep 11, 2013 10:41 am

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.
pulsar22
 
Posts: 34
Joined: Mon Sep 09, 2013 12:39 pm
Has thanked: 14 times
Been thanked: 0 time

Re: DB Configurable Variable?

Postby dick scherrer » Wed Sep 11, 2013 7:21 pm

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".
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: DB Configurable Variable?

Postby pulsar22 » Wed Sep 11, 2013 9:03 pm

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?
pulsar22
 
Posts: 34
Joined: Mon Sep 09, 2013 12:39 pm
Has thanked: 14 times
Been thanked: 0 time

Re: DB Configurable Variable?

Postby dick scherrer » Wed Sep 11, 2013 9:40 pm

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.
Hope this helps,
d.sch.

These users thanked the author dick scherrer for the post:
pulsar22 (Mon Sep 16, 2013 8:50 pm)
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: DB Configurable Variable?

Postby m4mainframe » Wed Sep 11, 2013 11:16 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)
m4mainframe
 
Posts: 13
Joined: Tue Aug 13, 2013 10:04 am
Has thanked: 0 time
Been thanked: 1 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post