View previous topic :: View next topic
|
Author |
Message |
mugil
New User
Joined: 19 May 2010 Posts: 1 Location: chennai
|
|
|
|
Hi,
I am facing 'B204 SQL - DB2 subsystem "DB2Q" does not exist' error when i try to run an easytrieve program which handles a cursor in it. i did check my DB2 panel. i found DB2S as my subsystem ID.
The above mentioned error is followed by 'B204 SQL - CHANGING TO "PARTIAL" SQL SYNTAX CHECKING'
below is the job log:
12 *
13 SQL INCLUDE LOCATION * FROM DNBA.TABLE1
13 *******B204 SQL - DB2 SUBSYSTEM "DB2Q" DOES NOT EXIST
13 *******B204 SQL - CHANGING TO "PARTIAL" SQL SYNTAX CHECKING
14 SQL INCLUDE LOCATION * FROM DNBA.TABLE2
14 *******B204 SQL - DB2 CATALOG NOT AVAILABLE DUE TO ATTACH FAILURE
15 *
16 SQL DECLARE CURS01 CURSOR FOR +
16 *******B204 SQL - DB2 SUBSYSTEM "DB2Q" DOES NOT EXIST
16 *******B204 SQL - CHANGING TO "PARTIAL" SQL SYNTAX CHECKING
SELECT A.COD_PERSONA || ';' || +
, A.COD_CENTRO_INS || ';' || +
, B.COD_P1 +
FROM DNBA.TABLE1 A, +
DNBA.TABLE2 B +
WHERE A.COD_F = :W-INPUT1 +
WITH UR
here DNBA is the table owner.
can anybody please help on this?
Thanks,
Mugil |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10882 Location: italy
|
|
|
|
Quote: |
DB2 subsystem "DB2Q" does not exist' error |
Quote: |
can anybody please help on this? |
how in <opposite of heaven> are we supposed to know the names of the db2 subsystems defined/active in Your organization
ask Your support |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
especially since:
Quote: |
DB2 subsystem "DB2Q" does not exist |
and
Quote: |
i found DB2S as my subsystem ID |
|
|
Back to top |
|
|
|