DSXchange

Hi All,

I need to use a function which will return one value.

for Ex: Sum Function which adds two input values and returns a value.

How can i use this function in datastage job?

Please explain in brief if someone knows this b'coz i never used scripts and functions in datastage.

Thanks in Advance!

The obvious answer is to use the function within a user-defined SELECT statement.

ray.wurlod wrote:The obvious answer is to use the function within a user-defined SELECT statement. ...

Thanks for the reply ray.

yes we can call using the select statement, but i want to know how to call it from any of the other stages.

And how to invoke the procedures from datastage jobs please help me out if you have any idea.

It is not possible by any other means. A plsql function must be invoked from within an SQL statement. Therefore any stage that needs to use it must run some SQL. The stages that connect to Oracle are the only ones that can run Oracle SQL. (One exception: you could set up a command that runs sqlplus from the command line to execute an SQL statement, but that's introducing an extra layer of software (the operating system shell) for no good reason.)