Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett, rschirm, roy
-
raji33
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 151
- Joined: Thu Sep 23, 2010 9:21 pm
- Location: NJ
Post
by raji33 »
Hi All,
I need to get all job information and load to the table can any one tel me how to parse the datastage log/DB.
Thanks in advance
-
anbu
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 596
- Joined: Sat Feb 18, 2006 2:25 am
- Location: india
Post
by anbu »
You are the creator of your destiny - Swami Vivekananda
-
raji33
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 151
- Joined: Thu Sep 23, 2010 9:21 pm
- Location: NJ
Post
by raji33 »
Hi Anbu
This we need to give on unix or in the before/after subroutine?
-
anbu
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 596
- Joined: Sat Feb 18, 2006 2:25 am
- Location: india
Post
by anbu »
From Unix
You are the creator of your destiny - Swami Vivekananda
-
raji33
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 151
- Joined: Thu Sep 23, 2010 9:21 pm
- Location: NJ
Post
by raji33 »
Hi anbu
but how do do you fetch that in formation into a file
-
anbu
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 596
- Joined: Sat Feb 18, 2006 2:25 am
- Location: india
Post
by anbu »
When you run the dsjob command from Unix, it will fetch you the info about the job. Just redirect output of the command to a file.
Check manual for complete syntax
You are the creator of your destiny - Swami Vivekananda
-
raji33
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 151
- Joined: Thu Sep 23, 2010 9:21 pm
- Location: NJ
Post
by raji33 »
Thanks Anbu i will try that