Reg DS_Audit
Moderators: chulett, rschirm, roy
Reg DS_Audit
Folks,
I am accessing DS_Audit from DS Command prompt.
IS there any way I can access this thru a mapping.
I tried using Unierse plugin with "localluv" as DSN but i couldnt see any of the tables.
Help me out
rajesh
I am accessing DS_Audit from DS Command prompt.
IS there any way I can access this thru a mapping.
I tried using Unierse plugin with "localluv" as DSN but i couldnt see any of the tables.
Help me out
rajesh
The repository table names are filtered out from the standard ODBC and direct hashed file view. You can type in the name explicitly to access the table.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Since the names are explicitly filtered out, you cannot use the Manager to load the column metadata using either the UniVerse Table or UniVerse hashed file tabs. You will have to manually enter the metadata. But the hashed file as well as the Table view can be read. Just remember the standard caveat - "Life as we know it might cease to exist on this planet if you write to or modify contents of any DataStage repository file"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
You have to trick it. You have to create a q-pointer to access a repository table. This means you need to learn more about Universe. A q-pointer is a Universe equivalent of a synonym. It is a VOC entry.
at TCL:
ED VOC Q_DS_AUDIT
1: Q
2:
3: DS_AUDIT
Should look like above. Once you have a q-pointer then you can use it in a job but only in a UV stage. You should only read these tables and never write to them. This is a good way to create your own metadata. There are examples of jobs doing this in EtlStats.
at TCL:
ED VOC Q_DS_AUDIT
1: Q
2:
3: DS_AUDIT
Should look like above. Once you have a q-pointer then you can use it in a job but only in a UV stage. You should only read these tables and never write to them. This is a good way to create your own metadata. There are examples of jobs doing this in EtlStats.
Mamu Kim
Hi Kim,kduke wrote:You have to trick it. You have to create a q-pointer to access a repository table. This means you need to learn more about Universe. A q-pointer is a Universe equivalent of a synonym. It is a VOC entry.
at TCL:
ED VOC Q_DS_AUDIT
1: Q
2:
3: DS_AUDIT
Should look like above. Once you have a q-pointer then you can use it in a job but only in a UV stage. You should only read these tables and never write to them. This is a good way to create your own metadata. There are examples of jobs doing this in EtlStats.
When i try to give Q as the first parameter it goes back to command prompt
Code: Select all
>ED VOC Q_DS_AUDIT
New record.
----: Q
>
-Kumar
ED is a line editor and a really good way to hork things up if you don't know what you are doing. In the words of the immortal Pink Floyd: Careful with that Axe, Eugene.
Of course, it was an instrumental song, so no words - but I digress...
Of course, it was an instrumental song, so no words - but I digress...
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
You could use vi if you are on UNIX. UV.VI instead of ED.
ED has help. Just type HELP or ?. It is like any line editor. Use I to insert until you type a blank line.
C/KIM/KEN/99
Will change the first KIM on a line to KEN on the next 99 lines.
EX
Will exit.
FI
Will FILE or save your record.
T
Will go to the top line.
P
Will print a page of lines to the screen.
What else do you need?
ED has help. Just type HELP or ?. It is like any line editor. Use I to insert until you type a blank line.
C/KIM/KEN/99
Will change the first KIM on a line to KEN on the next 99 lines.
EX
Will exit.
FI
Will FILE or save your record.
T
Will go to the top line.
P
Will print a page of lines to the screen.
What else do you need?
Mamu Kim
Entering "I" in edit mode will switch you into input mode, and entering a <CR> on an empty input line will switch you back into edit mode.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This is going to be a very long, very slow way to learn ED, one command per post at a time. Why not download the UniVerse manuals from IBM website (track down manuals on line for version 9.6) and learn from those?
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.