Basic Routine in dataStage PX
Moderators: chulett, rschirm, roy
Basic Routine in dataStage PX
Hi All,
First time I am trying to write a basic routine. My requirement is to extract the first warning message written to director (Log) and write that message to a given table. I do not know the correct function as in Datastage 8 there is no help has been given regarding basic function. can anyone please help me in this regard?
Thanks
Sanjeev
First time I am trying to write a basic routine. My requirement is to extract the first warning message written to director (Log) and write that message to a given table. I do not know the correct function as in Datastage 8 there is no help has been given regarding basic function. can anyone please help me in this regard?
Thanks
Sanjeev
sanjeev kumar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can not use BASIC routines from within a parallel job (except if you are using a BASIC Transformer stage, or before/after subroutine). Are you using one of these techniques? If so, you need to create the appropriate type of server routine.
There is LOTS of help given on BASIC functions in the help. Start from, for example, the topic "BASIC Tasks" which I believe is a useful portal into all tasks you can perform with the DataStage BASIC programming language.
There is LOTS of help given on BASIC functions in the help. Start from, for example, the topic "BASIC Tasks" which I believe is a useful portal into all tasks you can perform with the DataStage BASIC programming language.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Basic Routine in dataStage PX
Ray,
I will write the routine and use that in sequence in routine stage...
Craig,
There is no online help available in Dstage 8.0 like Dstage 7.5.1. That is the problem and hence I put this question.
Thanks
Sanjeev
I will write the routine and use that in sequence in routine stage...
Craig,
There is no online help available in Dstage 8.0 like Dstage 7.5.1. That is the problem and hence I put this question.
Thanks
Sanjeev
sanjeev kumar
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
Re: Basic Routine in dataStage PX
Odd, I have V8 and on-line help.sanjumsm wrote:...There is no online help available in Dstage 8.0 like Dstage 7.5.1. That is the problem and hence I put this question...
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
For what it's worth, I think samjumsm's comment regarding the lack of online help refers to topics that were specific to server jobs. We've recently converted to v. 8.0.1, and are still running mostly server jobs. I've found that references to functions used only by server jobs (eReplace for example) are no longer to be found in the help for v 8.0.1.
Help files in version 8.0.1 are messed-up, it's very hard to find help on functions, plug-ins, DS Macros, DS Function, DS Contatants.
DataStage integration with Websphere screwed-up all help files, they are no more user friendly the it was until 7.5.x.
DataStage integration with Websphere screwed-up all help files, they are no more user friendly the it was until 7.5.x.
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster
Yeah, that really sucks! Somebody should open up a case to IBM to fix it.
I will definitely put this alert to my client for upgrading to V8. Maybe that is IBM's strategy to suppress DataStage community from using Server jobs...
I will definitely put this alert to my client for upgrading to V8. Maybe that is IBM's strategy to suppress DataStage community from using Server jobs...
Pneuma Lin.
pneumalin@yahoo.com
pneumalin@yahoo.com
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Look in the repository for the "Stage Types" folder. Your toolbox holds shortcuts to stage types but the full list is held in the repository. You can drag and drop the BASIC Transformer from the Repository to your toolbox areas.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn