Hi All , i am running a parallel job on LINUX my database is SQL server and target stage i am using is ODBC .I need to truncate the table before every insert so i used OPEN COMMAND as TRUNCATE TABLE tablename it is giving me error as invalid command But when i used DELETE command it worked fine . But i would preffer to go with truncate as the size of the data will be big.
I guess you have the permission to truncate the table but still it will be better to confirm with your DBA. re you trying to clear the table and insert or just want to truncate the table and where are you using this command? Also paste the error message here.
If you can do it from outside datastage then you do have Truncate permissions. Thats not it. Also make sure your using the same id to access the database within datastage.
You said that DELETE FROM TABLE works, you meant the delete command works in the OPEN command option? Please confirm.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
i am trying to truncate the table and insert for every new load. i dont have the error message now since i have ran the job with DELETE command and it ran fine . when i read the message it was showing as "invalid command for TRUNCATE TABLE tablename"
Hi , On the day when we discussed this topic my problem was solved at that time i ran the job with sample file like 1000 recs now i am running the job with 8 million recs , i am surprised to see the same error stating the query in open command " TRUNCATE TABLE table name ;" as invalid command . Can any one help me out here .