Hi,
I am using DataStage 7.0 in AIX.. We know that we can call a DataStage
Routine(User defined or DataStage supplied) through Transformer Stage and
can apply on any field in Derivation area..
Can anybody tell me whether I can call a DataStage routine from any other
stage in DataStage 7.0.
Regards
Amitava Ghosh
Calling Routine
Calling Routine
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Calling Routine
If the Routine is a Transform function, the answer is no, because transform functions are intended to be invoked from Transformer stages.
If the Routine is a before/after subroutine, the answer is yes for any active stage, because active stage types support before/after subroutines.
If the Routine is an external (UniVerse) routine, the answer is "depends", but in general is no.
----- Original Message -----
From: "AmitavaJr_Ghosh"
Date: Wed, 5 Nov 2003 09:33:45 +0530
To:
Subject: Calling Routine
> Hi,
>
> I am using DataStage 7.0 in AIX.. We know that we can call a DataStage
> Routine(User defined or DataStage supplied) through Transformer Stage and
> can apply on any field in Derivation area..
>
> Can anybody tell me whether I can call a DataStage routine from any other
> stage in DataStage 7.0.
>
> Regards
> Amitava Ghosh
>
>
> DISCLAIMER: The information contained in this message is intended only and solely for the addressed individual or entity indicated in this message and for the exclusive use of the said addressed individual or entity indicated in this message (or responsible for delivery of the message to such person) and may contain legally privileged and confidential information belonging to Tata Consultancy Services. It must not be printed, read, copied, disclosed, forwarded, distributed or used (in whatsoever manner) by any person other than the addressee. Unauthorized use, disclosure or copying is strictly prohibited and may constitute unlawful act and can possibly attract legal action, civil and/or criminal. The contents of this message need not necessarily reflect or endorse the views of Tata Consultancy Services on any subject matter. Any action taken or omitted to be taken based on this message is entirely at your risk and neither the originator of this message nor Tata Consultancy Se
> rvices takes any responsibility or liability towards the same. Opinions, conclusions and any other information contained in this message that do not relate to the official business of Tata Consultancy Services shall be understood as neither given nor endorsed by Tata Consultancy Services or any affiliate of Tata Consultancy Services. If you have received this message in error, you should destroy this message and may please notify the sender by e-mail. Thank you.
>
If the Routine is a before/after subroutine, the answer is yes for any active stage, because active stage types support before/after subroutines.
If the Routine is an external (UniVerse) routine, the answer is "depends", but in general is no.
----- Original Message -----
From: "AmitavaJr_Ghosh"
Date: Wed, 5 Nov 2003 09:33:45 +0530
To:
Subject: Calling Routine
> Hi,
>
> I am using DataStage 7.0 in AIX.. We know that we can call a DataStage
> Routine(User defined or DataStage supplied) through Transformer Stage and
> can apply on any field in Derivation area..
>
> Can anybody tell me whether I can call a DataStage routine from any other
> stage in DataStage 7.0.
>
> Regards
> Amitava Ghosh
>
>
> DISCLAIMER: The information contained in this message is intended only and solely for the addressed individual or entity indicated in this message and for the exclusive use of the said addressed individual or entity indicated in this message (or responsible for delivery of the message to such person) and may contain legally privileged and confidential information belonging to Tata Consultancy Services. It must not be printed, read, copied, disclosed, forwarded, distributed or used (in whatsoever manner) by any person other than the addressee. Unauthorized use, disclosure or copying is strictly prohibited and may constitute unlawful act and can possibly attract legal action, civil and/or criminal. The contents of this message need not necessarily reflect or endorse the views of Tata Consultancy Services on any subject matter. Any action taken or omitted to be taken based on this message is entirely at your risk and neither the originator of this message nor Tata Consultancy Se
> rvices takes any responsibility or liability towards the same. Opinions, conclusions and any other information contained in this message that do not relate to the official business of Tata Consultancy Services shall be understood as neither given nor endorsed by Tata Consultancy Services or any affiliate of Tata Consultancy Services. If you have received this message in error, you should destroy this message and may please notify the sender by e-mail. Thank you.
>
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Calling Routine
Hi,
I have written some routines in BASIC language and they are in 'Routines'
directory of DataStage Manager although they are not Before/After
subroutine. They are not in 'Transform' folder.
Can we call these routine from any stage other than Transformer ?
Regards
Amitava
----- Original Message -----
From: "Ray Wurlod"
To:
Sent: Wednesday, November 05, 2003 9:44 AM
Subject: Re: Calling Routine
> If the Routine is a Transform function, the answer is no, because
transform functions are intended to be invoked from Transformer stages.
> If the Routine is a before/after subroutine, the answer is yes for any
active stage, because active stage types support before/after subroutines.
> If the Routine is an external (UniVerse) routine, the answer is "depends",
but in general is no.
>
> ----- Original Message -----
> From: "AmitavaJr_Ghosh"
> Date: Wed, 5 Nov 2003 09:33:45 +0530
> To:
> Subject: Calling Routine
>
> > Hi,
> >
> > I am using DataStage 7.0 in AIX.. We know that we can call a DataStage
> > Routine(User defined or DataStage supplied) through Transformer Stage
and
> > can apply on any field in Derivation area..
> >
> > Can anybody tell me whether I can call a DataStage routine from any
other
> > stage in DataStage 7.0.
> >
> > Regards
> > Amitava Ghosh
> >
>
> >
> > DISCLAIMER: The information contained in this message is intended only
and solely for the addressed individual or entity indicated in this message
and for the exclusive use of the said addressed individual or entity
indicated in this message (or responsible for delivery of the message to
such person) and may contain legally privileged and confidential information
belonging to Tata Consultancy Services. It must not be printed, read,
copied, disclosed, forwarded, distributed or used (in whatsoever manner) by
any person other than the addressee. Unauthorized use, disclosure or copying
is strictly prohibited and may constitute unlawful act and can possibly
attract legal action, civil and/or criminal. The contents of this message
need not necessarily reflect or endorse the views of Tata Consultancy
Services on any subject matter. Any action taken or omitted to be taken
based on this message is entirely at your risk and neither the originator of
this message nor Tata Consultancy Se
> > rvices takes any responsibility or liability towards the same.
Opinions, conclusions and any other information contained in this message
that do not relate to the official business of Tata Consultancy Services
shall be understood as neither given nor endorsed by Tata Consultancy
Services or any affiliate of Tata Consultancy Services. If you have received
this message in error, you should destroy this message and may please notify
the sender by e-mail. Thank you.
> >
>
I have written some routines in BASIC language and they are in 'Routines'
directory of DataStage Manager although they are not Before/After
subroutine. They are not in 'Transform' folder.
Can we call these routine from any stage other than Transformer ?
Regards
Amitava
----- Original Message -----
From: "Ray Wurlod"
To:
Sent: Wednesday, November 05, 2003 9:44 AM
Subject: Re: Calling Routine
> If the Routine is a Transform function, the answer is no, because
transform functions are intended to be invoked from Transformer stages.
> If the Routine is a before/after subroutine, the answer is yes for any
active stage, because active stage types support before/after subroutines.
> If the Routine is an external (UniVerse) routine, the answer is "depends",
but in general is no.
>
> ----- Original Message -----
> From: "AmitavaJr_Ghosh"
> Date: Wed, 5 Nov 2003 09:33:45 +0530
> To:
> Subject: Calling Routine
>
> > Hi,
> >
> > I am using DataStage 7.0 in AIX.. We know that we can call a DataStage
> > Routine(User defined or DataStage supplied) through Transformer Stage
and
> > can apply on any field in Derivation area..
> >
> > Can anybody tell me whether I can call a DataStage routine from any
other
> > stage in DataStage 7.0.
> >
> > Regards
> > Amitava Ghosh
> >
>
> >
> > DISCLAIMER: The information contained in this message is intended only
and solely for the addressed individual or entity indicated in this message
and for the exclusive use of the said addressed individual or entity
indicated in this message (or responsible for delivery of the message to
such person) and may contain legally privileged and confidential information
belonging to Tata Consultancy Services. It must not be printed, read,
copied, disclosed, forwarded, distributed or used (in whatsoever manner) by
any person other than the addressee. Unauthorized use, disclosure or copying
is strictly prohibited and may constitute unlawful act and can possibly
attract legal action, civil and/or criminal. The contents of this message
need not necessarily reflect or endorse the views of Tata Consultancy
Services on any subject matter. Any action taken or omitted to be taken
based on this message is entirely at your risk and neither the originator of
this message nor Tata Consultancy Se
> > rvices takes any responsibility or liability towards the same.
Opinions, conclusions and any other information contained in this message
that do not relate to the official business of Tata Consultancy Services
shall be understood as neither given nor endorsed by Tata Consultancy
Services or any affiliate of Tata Consultancy Services. If you have received
this message in error, you should destroy this message and may please notify
the sender by e-mail. Thank you.
> >
>
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Calling Routine
A Transform is not the same thing as a transform function.
A Transform is an encapsulated expression, saved with accompanying documentation in the Transforms branch of the repository as a re-usable component. For example, to convert miles to kilometres you multiply by a constant. Having the Transform already in the respository aids your developer productivity because it means that you don't have to spend time researching what the actual constant is.
A transform function is one type of Routine. It has one or more input arguments, can contain more than one statement, and returns a value. Transform functions should be written to execute as efficiently as possible, because they are likely to be executed for every row processed.
Transform functions are stand-alone, and thus jobs that use them do not have to be re-compiled if the function itself is changed and re-compiled. Transforms, on the other hand, become in-line code in the jobs that use them, and so such jobs do need to be re-compiled if the Transform definition changes.
----- Original Message -----
From: "AmitavaJr_Ghosh"
Date: Wed, 5 Nov 2003 10:36:11 +0530
To:
Subject: Re: Calling Routine
> Hi,
>
> I have written some routines in BASIC language and they are in 'Routines'
> directory of DataStage Manager although they are not Before/After
> subroutine. They are not in 'Transform' folder.
>
> Can we call these routine from any stage other than Transformer ?
>
> Regards
> Amitava
>
>
>
>
> ----- Original Message -----
> From: "Ray Wurlod"
> To:
> Sent: Wednesday, November 05, 2003 9:44 AM
> Subject: Re: Calling Routine
>
>
> > If the Routine is a Transform function, the answer is no, because
> transform functions are intended to be invoked from Transformer stages.
> > If the Routine is a before/after subroutine, the answer is yes for any
> active stage, because active stage types support before/after subroutines.
> > If the Routine is an external (UniVerse) routine, the answer is "depends",
> but in general is no.
> >
> > ----- Original Message -----
> > From: "AmitavaJr_Ghosh"
> > Date: Wed, 5 Nov 2003 09:33:45 +0530
> > To:
> > Subject: Calling Routine
> >
> > > Hi,
> > >
> > > I am using DataStage 7.0 in AIX.. We know that we can call a DataStage
> > > Routine(User defined or DataStage supplied) through Transformer Stage
> and
> > > can apply on any field in Derivation area..
> > >
> > > Can anybody tell me whether I can call a DataStage routine from any
> other
> > > stage in DataStage 7.0.
> > >
> > > Regards
> > > Amitava Ghosh
> > >
> >
> > >
> > > DISCLAIMER: The information contained in this message is intended only
> and solely for the addressed individual or entity indicated in this message
> and for the exclusive use of the said addressed individual or entity
> indicated in this message (or responsible for delivery of the message to
> such person) and may contain legally privileged and confidential information
> belonging to Tata Consultancy Services. It must not be printed, read,
> copied, disclosed, forwarded, distributed or used (in whatsoever manner) by
> any person other than the addressee. Unauthorized use, disclosure or copying
> is strictly prohibited and may constitute unlawful act and can possibly
> attract legal action, civil and/or criminal. The contents of this message
> need not necessarily reflect or endorse the views of Tata Consultancy
> Services on any subject matter. Any action taken or omitted to be taken
> based on this message is entirely at your risk and neither the originator of
> this message nor Tata Consultancy Se
> > > rvices takes any responsibility or liability towards the same.
> Opinions, conclusions and any other information contained in this message
> that do not relate to the official business of Tata Consultancy Services
> shall be understood as neither given nor endorsed by Tata Consultancy
> Services or any affiliate of Tata Consultancy Services. If you have received
> this message in error, you should destroy this message and may please notify
> the sender by e-mail. Thank you.
> > >
> >
>
>
> DISCLAIMER: The information contained in this message is intended only and solely for the addressed individual or entity indicated in this message and for the exclusive use of the said addressed individual or entity indicated in this message (or responsible for delivery of the message to such person) and may contain legally privileged and confidential information belonging to Tata Consultancy Services. It must not be printed, read, copied, disclosed, forwarded, distributed or used (in whatsoever manner) by any person other than the addressee. Unauthorized use, disclosure or copying is strictly prohibited and may constitute unlawful act and can possibly attract legal action, civil and/or criminal. The contents of this message need not necessarily reflect or endorse the views of Tata Consultancy Services on any subject matter. Any action taken or omitted to be taken based on this message is entirely at your risk and neither the originator of this message nor Tata Consultancy Se
> rvices takes any responsibility or liability towards the same. Opinions, conclusions and any other information contained in this message that do not relate to the official business of Tata Consultancy Services shall be understood as neither given nor endorsed by Tata Consultancy Services or any affiliate of Tata Consultancy Services. If you have received this message in error, you should destroy this message and may please notify the sender by e-mail. Thank you.
>
A Transform is an encapsulated expression, saved with accompanying documentation in the Transforms branch of the repository as a re-usable component. For example, to convert miles to kilometres you multiply by a constant. Having the Transform already in the respository aids your developer productivity because it means that you don't have to spend time researching what the actual constant is.
A transform function is one type of Routine. It has one or more input arguments, can contain more than one statement, and returns a value. Transform functions should be written to execute as efficiently as possible, because they are likely to be executed for every row processed.
Transform functions are stand-alone, and thus jobs that use them do not have to be re-compiled if the function itself is changed and re-compiled. Transforms, on the other hand, become in-line code in the jobs that use them, and so such jobs do need to be re-compiled if the Transform definition changes.
----- Original Message -----
From: "AmitavaJr_Ghosh"
Date: Wed, 5 Nov 2003 10:36:11 +0530
To:
Subject: Re: Calling Routine
> Hi,
>
> I have written some routines in BASIC language and they are in 'Routines'
> directory of DataStage Manager although they are not Before/After
> subroutine. They are not in 'Transform' folder.
>
> Can we call these routine from any stage other than Transformer ?
>
> Regards
> Amitava
>
>
>
>
> ----- Original Message -----
> From: "Ray Wurlod"
> To:
> Sent: Wednesday, November 05, 2003 9:44 AM
> Subject: Re: Calling Routine
>
>
> > If the Routine is a Transform function, the answer is no, because
> transform functions are intended to be invoked from Transformer stages.
> > If the Routine is a before/after subroutine, the answer is yes for any
> active stage, because active stage types support before/after subroutines.
> > If the Routine is an external (UniVerse) routine, the answer is "depends",
> but in general is no.
> >
> > ----- Original Message -----
> > From: "AmitavaJr_Ghosh"
> > Date: Wed, 5 Nov 2003 09:33:45 +0530
> > To:
> > Subject: Calling Routine
> >
> > > Hi,
> > >
> > > I am using DataStage 7.0 in AIX.. We know that we can call a DataStage
> > > Routine(User defined or DataStage supplied) through Transformer Stage
> and
> > > can apply on any field in Derivation area..
> > >
> > > Can anybody tell me whether I can call a DataStage routine from any
> other
> > > stage in DataStage 7.0.
> > >
> > > Regards
> > > Amitava Ghosh
> > >
> >
> > >
> > > DISCLAIMER: The information contained in this message is intended only
> and solely for the addressed individual or entity indicated in this message
> and for the exclusive use of the said addressed individual or entity
> indicated in this message (or responsible for delivery of the message to
> such person) and may contain legally privileged and confidential information
> belonging to Tata Consultancy Services. It must not be printed, read,
> copied, disclosed, forwarded, distributed or used (in whatsoever manner) by
> any person other than the addressee. Unauthorized use, disclosure or copying
> is strictly prohibited and may constitute unlawful act and can possibly
> attract legal action, civil and/or criminal. The contents of this message
> need not necessarily reflect or endorse the views of Tata Consultancy
> Services on any subject matter. Any action taken or omitted to be taken
> based on this message is entirely at your risk and neither the originator of
> this message nor Tata Consultancy Se
> > > rvices takes any responsibility or liability towards the same.
> Opinions, conclusions and any other information contained in this message
> that do not relate to the official business of Tata Consultancy Services
> shall be understood as neither given nor endorsed by Tata Consultancy
> Services or any affiliate of Tata Consultancy Services. If you have received
> this message in error, you should destroy this message and may please notify
> the sender by e-mail. Thank you.
> > >
> >
>
>
> DISCLAIMER: The information contained in this message is intended only and solely for the addressed individual or entity indicated in this message and for the exclusive use of the said addressed individual or entity indicated in this message (or responsible for delivery of the message to such person) and may contain legally privileged and confidential information belonging to Tata Consultancy Services. It must not be printed, read, copied, disclosed, forwarded, distributed or used (in whatsoever manner) by any person other than the addressee. Unauthorized use, disclosure or copying is strictly prohibited and may constitute unlawful act and can possibly attract legal action, civil and/or criminal. The contents of this message need not necessarily reflect or endorse the views of Tata Consultancy Services on any subject matter. Any action taken or omitted to be taken based on this message is entirely at your risk and neither the originator of this message nor Tata Consultancy Se
> rvices takes any responsibility or liability towards the same. Opinions, conclusions and any other information contained in this message that do not relate to the official business of Tata Consultancy Services shall be understood as neither given nor endorsed by Tata Consultancy Services or any affiliate of Tata Consultancy Services. If you have received this message in error, you should destroy this message and may please notify the sender by e-mail. Thank you.
>
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Calling Routine
Amitava,
You can call routines before and after an active stage (i.e., transformer or
sort) as well as before and after the job. Click on the properties option of
the stage or the job.
Alejandro
-----Original Message-----
From: AmitavaJr_Ghosh [mailto:AmitavaJr_Ghosh@tcscal.co.in]
Sent: Tuesday, November 04, 2003 8:04 PM
To: datastage-users@oliver.com
Subject: Calling Routine
Hi,
I am using DataStage 7.0 in AIX.. We know that we can call a DataStage
Routine(User defined or DataStage supplied) through Transformer Stage and
can apply on any field in Derivation area..
Can anybody tell me whether I can call a DataStage routine from any other
stage in DataStage 7.0.
Regards
Amitava Ghosh
You can call routines before and after an active stage (i.e., transformer or
sort) as well as before and after the job. Click on the properties option of
the stage or the job.
Alejandro
-----Original Message-----
From: AmitavaJr_Ghosh [mailto:AmitavaJr_Ghosh@tcscal.co.in]
Sent: Tuesday, November 04, 2003 8:04 PM
To: datastage-users@oliver.com
Subject: Calling Routine
Hi,
I am using DataStage 7.0 in AIX.. We know that we can call a DataStage
Routine(User defined or DataStage supplied) through Transformer Stage and
can apply on any field in Derivation area..
Can anybody tell me whether I can call a DataStage routine from any other
stage in DataStage 7.0.
Regards
Amitava Ghosh
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.