I just found a PDF file on the IBM developer works which explains step by step to create a simple operator and it covers basics of OSH.http://www.ibm.com/developerworks/data/tutorials/dm0702chard/dm0702chard-pdf.pdf
Category: Datastage
Take care while using column import stage
When we are using column import stage then you need to take care in defining the column order in the output mapping page. Recently one of my friend called me for a different problem. She said that in her job at a particular stage the data is getting rotated. Means she is expecting data as […]
Datastage Functions Tutorial
A very good article describing the usage and syntax for various functions for datastage. Please check theis link : DATASTAGE FUNCTIONS
FATAL : Access to sys.dba_extents is required but not available
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
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 […]
Dont Ignore This Warning : APT_CombinedOperatorController(1),0: Field 'XXXXXX' from input dataset '0' is NULL. Record dropped.
When you get any warning like below, APT_CombinedOperatorController(1),0: Field ‘XXXXX’ from input dataset ‘0’ is NULL. Record dropped. Then don’t ignore this. Because this will case the job to ignore some records, Means those records will not be processed by any of the following records and you you will not get these records in the […]
Things to keep in mind while using Column Import Stage
In datastage while using the column import stage we may get the following error, main_program: Syntax error: Error in “export” operator: Error in operator arg: In field “Opt”: Expected “;”, got: “.”, line 53Error in “field_import” operator: Error in operator arg: In field “Opt”: Expected “;”, got: “.”, line 92 The main reason for this […]
Parallel Routines in Datastage
I was trying to do some string manipulation things in a Job in Datastage. Oops i forgot to mention the tool, its Datastage 7.5.1. As we knows it supports basic functions and few stages where we can do data manipulation and other stuffs. Still we cannot say that we can achieve all manipulations using those […]
Problem With Attachment in Notification Stage
In datastage notification stage if there is no attachment specified then also am getting some empty file. Donno why this file is getting attached. I think there may be a pblm with my send mail template. but that also looks good.