Setting env variable in DB2 env

[shaan.shaan]

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 <11**********************@j8g2000cwa.googlegroups. com>,
sh*********@gmail.com says...

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

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

[shaan.shaan]

Hi thanks for the reply but I am not able to access this link.
Can you help me?
Gert van der Kooij wrote:

In article <11**********************@j8g2000cwa.googlegroups. com>,
sh*********@gmail.com says...

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

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

[Serge Rielau]

Gert van der Kooij wrote:

In article <11**********************@j8g2000cwa.googlegroups. com>,
sh*********@gmail.com says...

>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

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

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/ond...ness/conf2006/

[shaan.shaan]

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

Gert van der Kooij wrote:

In article <11**********************@j8g2000cwa.googlegroups. com>,
sh*********@gmail.com says...

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

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

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/ond...ness/conf2006/

[Darin McBride]

sh*********@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.shaan]

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

Darin McBride wrote:

sh*********@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