Ds repository tables in Basic routines
Moderators: chulett, rschirm, roy
Ds repository tables in Basic routines
HI,
Shall we use Datastage repository tables in the basic routines.
I would like to calculate the current date of the job and i want to populate to sequential file.
by executing the below query in the administratori am getting the current date value, but i would like to know, how to implement thislogic in the routines
"SELECT INSTANCE,CREATOR,DTC FROM DS_AUDIT WHERE CLASS ='2' AND INSTANCE = <JobName>; "
2) Shall we use the same tables in the scripts also? If yes, please tell me.
Kindly help me
Shall we use Datastage repository tables in the basic routines.
I would like to calculate the current date of the job and i want to populate to sequential file.
by executing the below query in the administratori am getting the current date value, but i would like to know, how to implement thislogic in the routines
"SELECT INSTANCE,CREATOR,DTC FROM DS_AUDIT WHERE CLASS ='2' AND INSTANCE = <JobName>; "
2) Shall we use the same tables in the scripts also? If yes, please tell me.
Kindly help me
I would advise to minimize the use of the DS repository as that is/will change (as heard here on dsx). Then your piece of code will be obsolete and will not work with a newer version.
As kumar suggested, try to utilize macros to get the information you need.
Regards,
As kumar suggested, try to utilize macros to get the information you need.
Regards,
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
I would bet money this command works in the next release. I doubt if the next release changes that much. I think a lot of these types of hacks are the only way you can get this information. If the information is valuable then get it and use it. Hack the new later.
Using the macros are better when they can get what you need. Otherwise hack away and Craig you can quote me.
Using the macros are better when they can get what you need. Otherwise hack away and Craig you can quote me.
Mamu Kim
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Except that you may need to issue such a request via the Metadata Delivery service.kduke wrote:I would bet money this command works in the next release. I doubt if the next release changes that much.
The Repository database will not be (is not) UniVerse-based, and there's no guarantee that the table names will be (are) identical to those currently used. That's the difficulty with service-oriented architectures - you are isolated from what actually happens.
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.
Hello Kumar,kumar_s wrote:You can use DSExecute to execute UV commands. But its is also possible to retrive the informations like DSJobStartDate, DSJobStartTime... through DsMacro from JobSequencer itself.
thanks a ton..!!
I want to learn how to use DSExecute command to use UV commands. Could i get the documents related to this topic.
Please give me the syntax of this command. thanks in advance
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DSExecute() is not a command. It is a subroutine callable from your own Routines, which can execute operating system or DataStage commands. You can find the full syntax in on-line help. For a fee, someone might be prepared to transcribe that information into this post for you.
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.