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
elias.shaik
Participant
Posts: 51 Joined: Sat Dec 09, 2006 3:32 am
Post
by elias.shaik » Mon Apr 19, 2010 12:23 pm
Hi,
Parameter set name :test
parameters in parameter set :schema
Used in SQL of RDBMS stage as
When i check the data by "view data" it works fine and I can see the data as well.But when i execute the job an error is occurred as below.
Dynamic_RDBMS_0,0: Info:
Code: Select all
jobname.Dynamic_RDBMS_0: SELECT CoCd FROM #test.schema#.table
the parameter is not resolved into a value.
Appreciate your help.
Thanks,
Elias.
Last edited by
elias.shaik on Mon Apr 19, 2010 2:48 pm, edited 1 time in total.
------------
Elias
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Mon Apr 19, 2010 2:08 pm
When you mark a topic as resolved, our expectation (to help future searchers) is that you make a post explaining how it was resolved.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Apr 19, 2010 2:27 pm
Not resolved as much as
superfluous because it was (I assume) an accidental double-post. Really should have just deleted it before someone (or two someones) replied to it.
-craig
"You can never have too many knives" -- Logan Nine Fingers
elias.shaik
Participant
Posts: 51 Joined: Sat Dec 09, 2006 3:32 am
Post
by elias.shaik » Mon Apr 19, 2010 2:45 pm
ya it was a double post, but i could not find a way to delete this post.Please throw some light .
Anyways if you know the solution please let me know.
Thanks,
Elias.
------------
Elias
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Apr 19, 2010 2:49 pm
The option is there in the upper right-hand side of any post that you have made: Delete this post up there with Reply with quote and Back to top. As long as there's no replies yet.
-craig
"You can never have too many knives" -- Logan Nine Fingers