is serverjob functions and paralleljob functions are differe

vardhan354 · Post by **vardhan354** » Wed Oct 11, 2006 10:39 am

Hi,

i am new to Enterprise edition, i know the functions that are used in Server jobs Ex:- OCONV,TRIM,LEN.

is these functions are same in EE, or is there any difference

Please help me in this. If there is anything new

Where can i find all the functions that are available for EE.

thanks in advance.

kris007 · Post by **kris007** » Wed Oct 11, 2006 10:42 am

The BASIC Functions which are available in Server edition are not available in EE. However, there are few functions in EE which perform the equivalant job of what BASIC functions do such as TRIM etc. The functions that are available in EE are listed out in the EE pdf manuals.(Appendix B) Check them out.

Nageshsunkoji · Post by **Nageshsunkoji** » Wed Oct 11, 2006 10:43 am

Hi Welcome to EE,

Yes, some functions which are avialbale in the server is not present in Parallel.
Parallel have its own set of fucntions.
Go through the Parallel Job developers guide----- Functions at the end. You will get all functions.
You can check Orchestrate Reference Manual also for you reference.

vardhan354 · Post by **vardhan354** » Wed Oct 11, 2006 11:34 am

Thanks guys for your response.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 11, 2006 2:42 pm

The functions at the end of the Parallel Job Developers Guide are for the Transformer stage. Functions for the Modify stage are in the chapter for that stage. There are some errors; cross check with the Orchestrate Operators manual if you have a problem. For example, the Modify stage function for replacing null with a value is actually handle_null(), not null_to_value().

vardhan354 · Post by **vardhan354** » Wed Oct 11, 2006 3:09 pm

Thanks for the response Ray,

i searched for the orcherstate operators manul in Datastage EE guide provided by Ascential, it is not there.

Please provide more information where it is available.

Thanks in advance.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 11, 2006 3:18 pm

Ask your support provider to provide the "OEM 75" (Orchestrate) manuals. They should be able to get them from IBM in PDF format. They are handed out on all IBM training classes.