This error you will get when the user who is running the DSJob is not having the SELECT permissions to the DB Tables. For Clearing this Just Refer the Article Here : http://www.ibm.com/developerworks/forums/message.jspa?messageID=14157876
Month: February 2010
Removing First Few Lines From Text File – Unix
For removing the first lines from file use this command, tail +(n+1) where ‘n’ is the number of lines you want to remove,If you want to remove first 3 lines then use, more filename.txt | tail +4
File Copy Stage In Datastage
When you need to send the output from a single input link to many output links then don’t do this in a transformer itself. Instead do it using file copy stage. This really improves the performance and preserves the datatypes.
How to remove Runtime Column Propogation in all the components in single step – Datastage
For removing the Runtime column propagation in all the stages defined in the current job, Goto Job Properties – > General Tab -> Un check “Enable Runtime Column Propagation for new link” It will ask whether you want to remove the RCP for the existing components also, Say ‘Yes’ now in all the existing links […]