Setting env variable in DB2 env

[shaan...@gmail.com]

Hi
I am trying to set an env. variable by exporting in unix environment on
DB2.
I am using export var_name=ON, but it is not taking the value of the
var_name.
This thing is working fine when I am doing it on a simple c++ program
and retieving it by using getenv() function.
Can anyone help me in getting the solution how to set an env variable
in db2
zeeshan

[Gert van der Kooij]

In article <1152178679.1...@j8g2000cwa.googlegroups.com>,
shaan...@gmail.com says...

Check the description of the DB2ENVLIST variable at
http://tinyurl.com/jah5m

[shaan...@gmail.com]

Hi thanks for the reply but I am not able to access this link.
Can you help me?

[Serge Rielau]

Gert van der Kooij wrote:

Information Center: Reference->Registry and environment
variables->System environent

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

[shaan...@gmail.com]

hi please tell me exactly what to do for setting the env. variable .
I am not able to understand in the document.
zeeshan

[Darin McBride]

shaan...@gmail.com wrote:

> hi please tell me exactly what to do for setting the env. variable .
> I am not able to understand in the document.

This variable lists specific variable names for either stored procedures or
user-defined functions. By default, the db2start command filters out all
user environment variables except those prefixed with DB2 or db2. If
specific environment variables must be passed to either stored procedures
or user-defined functions, you can list the variable names in the
DB2ENVLIST environment variable. Separate each variable name by one or more
spaces.

What exactly have you tried after reading the document?

$ db2set DB2ENVLIST=var_name
$ export var_name=ON
$ db2start

[shaan...@gmail.com]

Hi Darin ,
Thanks for the info.
Do I have to give the below mentioned command on the command prompt
directly before running the application?
Best Regards,
Zeeshan