Skip to Content
0
Former Member
Nov 05, 2012 at 03:17 PM

Passing selection values in manually added Z field in DS extract structure

50 Views

Hi All,

We have a Z data source on a standard table. We manually added a Z Date field in its extract structure.

We want to pass a selection value for this date (say 20120501) which we will use for data manipulation in CMOD.

When we tried with some selection values in this date field we got an error 'A dynamically specified column name is unknown.'

When we debug we found that its passing through this cursor statement

OPEN CURSOR WITH HOLD g_cursor FOR
SELECT * FROM (g_s_oltpsource-extractor)
WHERE (l_t_dynamic_select).

where g_s_oltpsource-extractor is that standard table and l_t_dynamic_select is date value in this form :

(

ZSELDAT EQ '20120501'

)

as ZSELDATE is not part of this standard tabele its getting failed.

Is there any way to achieve this scenario or overcome this problem.

Regards:

Jitendra