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
jpraveen
Participant
Posts: 71 Joined: Sat Jun 06, 2009 7:10 am
Location: HYD
Post
by jpraveen » Thu Oct 21, 2010 3:31 am
HI
i had developed a job of inserting into dummy table ,the source & target's is dummy tables i.e, no records are inserted(no Transformation logic)
now,
can i write update SQL's in close command for original table i.e, another table
what my doubt is
we should write close command for the particular table which we had developed the job or we can write any SQL(Delete/Update) for any table in Close command.
Jaypee
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Oct 21, 2010 5:05 am
Any.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
jpraveen
Participant
Posts: 71 Joined: Sat Jun 06, 2009 7:10 am
Location: HYD
Post
by jpraveen » Thu Oct 21, 2010 5:12 am
Hi Ray
so we can write any SQL for any table in close command
Jaypee
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Thu Oct 21, 2010 7:27 am
"Any table" - as long as it is in the connected database and you have the required permission, of course. Not necessarily "any SQL", however.
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Oct 21, 2010 4:48 pm
Pretty much any SQL, subject to the usual caveats you'd have from any other client utility - privileges for the connected user and so on.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.