View previous topic :: View next topic
|
Author |
Message |
vyasricha
New User
Joined: 17 Mar 2008 Posts: 27 Location: banaglore
|
|
|
|
Hi ,
Can we use varchar host variable with occurs clause in multi row concept ? I am using a varchar variable during a fetch cursor ,
Code: |
Defination of variable :
01 WS-variable
10 Ws-NAME PIC x(10) OCCURS 10 TIMES.
10 WS-CLASS OCCURS 10 TIMES.
49 Ws-CLASS-NAME-LEN PIC S9(4) USAGE COMP.
49 Ws-CLASS-TEXT PIC X(35).
Fetch cursor :
EXEC-SQL
FETCH NEXT ROWSET
FROM NEW-CLASS FOR 10 ROWS
INTO :WS-NAME
, :WS-CLASS
END-EXEC
|
Its working fine for WS-NAME but for WS-CLASS it is giving error that ws-class not defined or unused ?
Code: |
DSN5011I AE DSNHSMUD LINE 1789 COL 25 HOST VARIABLE ARRAY "WS-CLASS" IS EITHER NOT DEFINED OR IS NOT USABLE.
|
Please suggest ! |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
Try adding SYNC clause to "Ws-CLASS-NAME-LEN" |
|
Back to top |
|
|
Naish
New User
Joined: 07 Dec 2006 Posts: 82 Location: UK
|
|
Back to top |
|
|
|