DSXchange

Persist them in the database table, and index them.

Can you post a few rows of your data, particularly the fields you are having the MNS rule set operate on?

prasson_ibm wrote:I can not change these functions in datastage because it belong to different infrastructure team.

I did not ask you to change the functions; I suggested that you could replicate what they do using native DataStage functionality.

Did you contact your official support provider with a view to getting the problem investigated and, perhaps, fixed?

Then you need to set the environment variable (called something like APT_SHOW_SCHEMAS) to find out whereabouts in your job the unbounded string is being used. Though, from the error message, it would appear to be in a stage called Xfmr_1. Possibly in a stage variable derivation?

Which browser, and which version, are you using?

Are you using values files in conjunction with your Parameter Sets? It seems to me that this is the ideal way to make your design as dynamic as possible.

prasson_ibm wrote:I need to call below oracle functions into datastage once load completes or fails....

Why?

Why can't you replicate the logic using regular DataStage components?

Worst case, envelop the function in a stored procedure and invoke that.

The Nested Condition activity is one that has no body, only triggers. There is nothing special about its triggers; the same triggers can be used on other kinds of activity as well.

Welcome aboard.

Some things are just tiresome.

Welcome aboard.

I have no idea. Judging from the number taking exams at IOD, the answer is "quite a few". You might try asking at IBM Certification website

The Client components can be installed on Windows 7. As far as I am aware an attempt to install the other tiers results in a fairly immediate "unsupported platform" error.

Something internal fouled up in generating the query against XMETA?

Can you drag the routine to a different folder?

At a guess, you will need to have published one or more of these from IA.

Why it's not there as a class is a bit more of a mystery. Can you find them by inspection of any of the models in model view on the Administration tab?