If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.
I have some tables where "truncate myTable;" run from iACS Run SQL Scripts reports success but does not remove any records. Nothing in the job log either.
Is it possible that it's actually working...BUT...not on the table you expected to be truncated? Without qualifying the table, Run SQL Scripts will use the current JDBC environment as it searches for the unqualified object.
I am qualifying the table: "truncate myLib/myTable;"
Apologies, bad description on my part - I should have specified that. It does work on some tables, so I assume it's something about the table itself that is blocking it
Thanks for the tip about debug, it never occurred to me to do that in iACS.
Turns out it was an authority issue - apparently *GROUP *CHANGE is enough for "delete * from mytable;" and for "CLRPFM mytable", but not enough for "truncate mytable". Job log showed CPF9822 Not authorized to file mytable in library mylib. Weird that I can still do deletes inserts, and CLRPFM's, but not truncate - and that truncate did not report an error except in debug job log. I wonder if this is a bug?
Comment