View previous topic :: View next topic |
Author |
Message |
bade_miya Beginner
Joined: 10 Dec 2003 Posts: 110 Topics: 38
|
Posted: Fri Dec 19, 2003 4:47 am Post subject: cobol+db2 |
|
|
i have written a cobol program which has an sql cursor declaration having a where clause as "WHERE ARR_TRAN.ARR_ID = :DCLARR-TRAN.ARR-ID
" for this i am getting the error as
DSNHSMUD LINE 303 COL 36 UNDEFINED OR UNUSABLE HOST VARIABLE "DCLARR-TRAN"
DSNHSMUD LINE 303 COL 48 UNDEFINED OR UNUSABLE HOST VARIABLE "ARR-ID"
could anyone please tell me what might be the problem. |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12370 Topics: 75 Location: San Jose
|
Posted: Fri Dec 19, 2003 6:24 am Post subject: |
|
|
Bade miya,
please show us the declaration of the DCLARR-TRAN.ARR-ID and also the table declaration of the column ARR_ID
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
hari_uss Beginner
Joined: 19 Dec 2002 Posts: 78 Topics: 6 Location: Trivandrum, India
|
Posted: Fri Dec 19, 2003 6:25 pm Post subject: |
|
|
Why would you need the qualifier DCLARR in host variable. Remove that and the period (or dot) between DCLARR-TRAN and ARR-ID and check whether that works.
Last edited by hari_uss on Mon Dec 22, 2003 1:14 am; edited 1 time in total |
|
Back to top |
|
|
Abhi Beginner
Joined: 03 Dec 2002 Posts: 21 Topics: 4 Location: India, Pune
|
Posted: Sun Dec 21, 2003 8:57 am Post subject: |
|
|
Just a quick check... have u included the DCLGEN in ur program? |
|
Back to top |
|
|
|
|