Re: Accesssing External Databases

On Thu, Sep 14, 2017 at 8:45 AM, Alan Shore <ashore@xxxxxxxx> wrote:

Thanks Justin
That's misleading

​No it isn't...

ADDENVVAR ENVVAR(CLASSPATH) VALUE('/java/jdbc/jtds-1.3.1.jar')

"Environment variable name exists.​"

The "environment variable name" (ENVVAR) is "CLASSPATH".

The message detail clearly tells you the problem

Cause . . . . . : You tried to add an environment variable (ADDENVVAR),
'CLASSPATH', of level *JOB, that already exists.
Recovery . . . : Do one of the following:
- Specify the REPLACE(*YES) option to replace the existing value with
the
new value.
- Use the CHGENVVAR command to change the specified environment
variable.
- Retry the command with an environment variable that does not exist.


The message isn't any different from any other "object already exists"
message you'd get from an ADDxxx, or CRTxxx command I can think of.

Charles