DSXchange

You can determine whether national language support (NLS) is enabled or not easily; every passive stage link properties window will include an NLS tab. Alternately, you could examine the uvconfig file in the DataStage "home" directory ($DSHOME) and look for the NLSMODE parameter. If it's present, an...

DataStage does not limit the size of a dataset, but your operating system may. Does your operating system have a limit set on file size? If you are not running on a 64-bit-enabled file system, the maximum UNIX file size is 2GB. What is your ulimit setting for file size? Type the command ulimit -a to...

You write a simple job control (server) job that runs your parallel job, setting the required parameters. The code would include code such as * Generate current month and day with no delimiters MonthDay = Oconv(@DATE, "DMD" : @VM : "MCN") * hJob is the job handle assigned...

Look in the job log file for messages like "active stage finishing". From that, determine how many rows were read, how many were written. Look also for messages (in the log) from Oracle that might indicate that the data your job sent were rejected - the messages will usually tell you why, for exampl...

The site I'm on at present isn't using PX, so I can't verify your claim. I trust you've reported it to Ascential?

You need to "escape" the quote characters. Otherwise they are interpreted by the operating system shell as quote characters rather than being passed. InputArg = "dev_pds_my,dev_pds_my,devpdsmy,EXECUTE DATASTAGE_TEST_SP(\'abcd\');" I have found the -S (silent) option to sqlplus to b...

There is nothing in DataStage to reverse-engineer a repository table definition from a bulk loader control script, or even from a create table statement. The latter has been on my low-priority "to do" list for about 30 months.

FUNCTION CheckDate(TheDate) * TheDate is expected to be in DataStage internal format * Calculate internal forms of boundary dates ThisMonth = @MONTH PrevMonth = ThisMonth - 1 ThisYear = @YEAR PrevYear = ThisYear - 1 If PrevMonth <= 0 Then PrevYear = ThisYear -1 PrevMonth += 12 End FirstOfPr...

Then ask the customer how they will get 21 litres of water into a 13 litre bucket.

I wrote one of these that's been in production for nearly two years. It uses BCI functions to access an ODBC database (Oracle 7 as it happens). The tricky part was an arbitrarily deep level of nesting in the dependencies.

Try adding zero to the column.

sushanth wrote:Hai I need to change derivations in Transformer stage from OR logic to IF then Else if ,for the following Logic help
If IsNull(Tocl1) Or Len(Tocol1) = 0 Then 'sample' Else Tocol1

Why do you need to change? The logic you have will work perfectly well.

Except for the word Unix, Ken's "solution" is platform-independent.

Probably a bit more math needed; break the decimal number using integer division and remainder, and convert the pieces.

Why not just convert to hexadecimal?
A 21-digit decimal number made up entirely of "9" reduces to DE9FFFFF (that is, eight characters) in hexadecimal.

The conversion is easy. Use to convert to hexadecimal.