View previous topic :: View next topic
|
Author |
Message |
kalais
New User
Joined: 18 Apr 2006 Posts: 22
|
|
|
|
I want to know is it possible to use array (an integer array) in the
where clause like,
SELECT
......
INTO
....
FROM
...
WHERE
...
TABLE.COL_NAME IN :WS-INT-ARRAY
If yes how to code it. |
|
Back to top |
|
|
vijayakumar.yellala
New User
Joined: 19 Apr 2006 Posts: 63 Location: Chennai
|
|
|
|
you can use....
but not like, table.column name
directly u can use column name inthe Where clause |
|
Back to top |
|
|
dr_te_z
New User
Joined: 08 Jun 2007 Posts: 71 Location: Zoetermeer, the Netherlands
|
|
|
|
No. You must redefine. BUT! That's where session tables come in.
Code: |
where colonm_a in (select a from session.temp_tab)
|
So, instead of a cobol array you drop/create/populate a session tempory table. Very powerfull. |
|
Back to top |
|
|
|