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
Collecting Stats in M-Load stage
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio