DSXchange

Hi,

We are trying to collect statistics in the M-Load stage by calling the procedure (which takes the DB Name and the Table name as parameters)

CALL QLFR.COLLECT_STATS('DBName','TableName');

But the job is getting aborted saying

**** 15:23:13 UTY1014 Unsupported RDBMS/SQL statement: "CALL"

We can not do a 'COLLECT STATISTICS ON DBName.Tablename' as the teradata id will not have access to call this stmt. (it has access to only call the proc)

Is there any other way to collect stats in the datastage m-load stage(apart from writing a Mainframe JCL to do collect stats)??

Thanks
Roy

not sure but looks like the ID you are using does not have the necessary priviledges. In that case, you should not waste your energy finding different ways to do the task. Rather you should try and get the necessary priviledges first.+