call subroutine in after-job subroutine

[chooi]

Hi,
is it possible to call subroutine in after-job subroutine of job properties? how the statement will be?
what option should choose ?
Thanks 1st.

[roy]

Hi,
can you please specify more what it is you want to acomplish?

If you mean simply invoke a DS transform routine the answer is:
Yes, but indirectly - meaning you must build a before/after wrapper routine that runs the ds transform rouine and use it there.

depending on the functionality you want to perform you might need more info.

IHTH,

[ArndW]

chooi,

Usually you will write & wish to call DataStage functions (as opposed to before-after subroutines); they allow you to specify as many parameters as you wish. Before/After subroutines have a defined 2-parameter limit, although you can always put multiple values in the one parameter you do have available.

If you write a function AddMe with 2 parameters, a & b and compile it in the Manager then to use it in a before/after subroutine (or another function) you need to include code such as:

Code: Select all

DEFFUN AddMe(a,b) CALLING 'DSU.AddMe'
a = 3
b = 4
c = AddMe(a,b)

The method for calling a subroutine is similar, only you don't need to tell the compiler to define a function, just call

Code: Select all

DSU.MyBeforeAfterRoutineName(ParameterValue,ReturnCode)

[chooi]

Hi ArndW,
what I know is, the job parameter only functioned during run-time . So, after the job runned, job parameter will not abled to "used" in after-job routine. am i right?

[chulett]

No, the funny thing is... "after job" is still during the run-time of the job, so job parameters can be used by them. The job hasn't finished running until any after job routines finish as well.

[chooi]

Hi chulett,
how do i put my job parameter inside the input value of "after-job routine"? let say my job parameter is : DATA

so ,is it put like this in input value box:

:DATA:

Plz advice.

[chulett]

Job Parameters are (in almost all cases) enclosed in pound signs or 'hashes' (#) when referenced. The colon is used for concatenation. So, if you simply wanted to refer to a job parameter called DATA, you would do it like this:

Code: Select all

#DATA#

If you wanted to include it as part of a string in a command, then something like this might be in order:

Code: Select all

'Some string ' : #DATA# : ' the rest of the string'

[chooi]

Hi chulett,
u r right. job parameter can be used in after-job routine. how about the stage variable? can it be put into after-job routine as well?

[chulett]

No. Stage variables are local variables and don't exist outside of the stage they are defined in.

[chooi]

ok .roger that.