Close command-UPDATE

jpraveen · 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.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 21, 2010 5:05 am

jpraveen · Post by **jpraveen** » Thu Oct 21, 2010 5:12 am

Hi Ray

so we can write any SQL for any table in close command

chulett · 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.

ray.wurlod · 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.