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 […]
Month: January 2010
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 […]
Good and Great use of 'tr' command
Apart from the regular tr command usage, it can be used for performing the following tasks too, for converting a windows file to UNIX file use the following command, tr -d ‘15’ if you need to concatenate the digits from a string, here is a way: $ echo “Abc123d56E” | tr -cd ‘[[:digit:]]’Output:12356
SED Tutorial for sed command
I found this tutorial quite useful for the beginners to understand the sed command. It starts from the very basic and goes beautifully. So its a really good tutorial. Link: http://www.grymoire.com/Unix/Sed.html#uh-1
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.