DSXchange

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.

Any.

Hi Ray

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

"Any table" - as long as it is in the connected database and you have the required permission, of course. Not necessarily "any SQL", however.

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.