open command in Oracle enterprise stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
_chamak
Premium Member
Premium Member
Posts: 29
Joined: Tue Aug 24, 2010 10:29 am

open command in Oracle enterprise stage

Post by _chamak »

Hi
I need to truncate the table and load the same table using Enterprise stage. We used Oracle connector stage which worked fine with no issues, but recently we faced an issue in the data having accented charcters. We changed the NLS and it worked for accented characters. Connector stage does not have NLS option. I am trying to use Enterprise stage and I used open command to run the truncate stored proc but its throwing me an error saying Fatal Error: Invalid open command: CALL SCHEMA.TRUNCATETAB_WITHCONS('SCHEMA.TABLE_NM');
I tried removing the semicolon at the end but it did not work. I tried EXEC but no luck.

Did anyone had this scenario before.
-Thanks
Chamak
Post Reply