ORCHESTRATE value

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
subrat
Premium Member
Premium Member
Posts: 77
Joined: Tue Dec 11, 2007 5:54 am
Location: UK

ORCHESTRATE value

Post by subrat »

Hi,

I have a query in lookup stage like
select A,B,(MIN(D)+ORCHESTRATE.D)
from TABLE where <jon conditions>.......

Generated query is like
select A,B,(MIN(D)+?)
from TABLE where <jon conditions>.......


Error log is saying "[IIS-CONN-TERA-005004] RDBMS code 3706: Syntax error: parameter token '?' is not allowed in select list. SQL statement:".

Is the issue related to DS? Any idea where its went wrong, and how to identify if ORCHEDTRATE is passing value.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

*Topic Relocated - Content Editor*
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply