Problem:

**    External Compiler Module message

**    DB0009 MF DB2 Connect program reported error condition ' 1403'.This

**    error prevents SQL processing from continuing - further EXEC SQL

**    statements will be ignored.

This error is produced when compiling a DB2 program under Server Express on AIX platform.

The DB2 database resides on a different server than the one that it is being used to compile.

Resolution:

When you compile or run a DB2  program using Server Express DB2 compiler directive, it must first connect to the database.  With a local DB2 server, DB2 will attempt to use the logon information you used to logon onto that server if you do not provide ID/PASSWORD.  Generally, this works fine.  However, if the ID/PASSWORD on a remote server is different or non-existent, then the compile will fail with the 1403 error.  To get around that, you must compile the program with db2 directive PASS=id.password ie DB2(PASS=myid.mypass)

After the program has been compiled and you try to run it against a remote server, the CONNECT statement must provide a ID/PASSWORD - format of CONNECT is

EXEC SQL CONNECT TO server | :hv-server  USER :hv-id  USING :hv-password  END-EXEC

Please refer to DB2 SQL Reference for additional details.

(From IBM documentation)

SQL1403N The username and/or password supplied is incorrect.

Explanation: The username and/or password supplied is incorrect or not a

valid username/password combination or the database to which you are

attempting to connect to has an authentication type of SERVER and no

username and password was supplied on the CONNECT TO statement.