A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.
Moderators: chulett, rschirm, roy
-
DSRajesh
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 297
- Joined: Mon Feb 05, 2007 10:37 pm
Post
by DSRajesh »
Dear All,
How would i get the user information for the columns create user id and update user id in server routine.
Is there any DS macro or function can i use the server routine?
Could any one please suggest me here.
RD
-
chulett
- Charter Member
![Charter Member Charter Member](./images/ranks/charter_member%s.gif)
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
What columns are you referring to? I don't mean their names but where they live, what table(s) they are associated with.
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
A
Search for DS_AUDIT may reveal what you require.
Default Engine credentials may thwart your efforts.
Last edited by
ray.wurlod on Wed Oct 16, 2013 6:03 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
chulett
- Charter Member
![Charter Member Charter Member](./images/ranks/charter_member%s.gif)
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
I suspected that might be the case but was hoping they could be more precise in their requirements statement.
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
DSRajesh
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 297
- Joined: Mon Feb 05, 2007 10:37 pm
Post
by DSRajesh »
These columns are from audit table which holds job statistics information.
Is there any specific basic language functions or macros which return the information for the create_user_id and update_user_id columns.
RD
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
No.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.