Page 1 of 2
Reg DS_Audit
Posted: Wed Feb 08, 2006 6:08 am
by raj_konig
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
Posted: Wed Feb 08, 2006 6:09 am
by ArndW
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.
Posted: Wed Feb 08, 2006 6:14 am
by raj_konig
Yes arndW i did that too.
With "localluv" as DSN i typed "DS_Audit" in 'Name contains' tab and clicked OK.
yet it resulted "No Match Found"
rajesh
Posted: Wed Feb 08, 2006 6:29 am
by ArndW
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"
Posted: Wed Feb 08, 2006 6:44 am
by kumar_s
ArndW wrote:"Life as we know it might cease to exist on this planet if you write to or modify contents of any DataStage repository file"
Worth flashing in Home Page.
I guess that is the reason UV stages are restricted in Parallel Edition.
-Kumar
Posted: Wed Feb 08, 2006 7:07 am
by kduke
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.
Posted: Wed Feb 08, 2006 7:28 am
by kumar_s
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.
Hi Kim,
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
>
May i know how can i give the rest of the option .
-Kumar
Posted: Wed Feb 08, 2006 7:41 am
by kduke
ED is a line editor. You have to learn this editor's commands. You can also use SETFILE.
Posted: Wed Feb 08, 2006 7:46 am
by chulett
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...
Posted: Wed Feb 08, 2006 7:03 pm
by kduke
Exactly, there are no shortcuts for learning this properly. If I make a mistake at this level then I know how to fix it. You better do full exports before playing around at this level.
Posted: Wed Feb 08, 2006 10:12 pm
by kumar_s
Hi,
I already have one screwed up project.
Operation on a live body may be dangerous for a new doctor, but not a postmortem over a dead body.
So i wish someone could shed some light on ED
-Kumar
Posted: Wed Feb 08, 2006 11:00 pm
by kduke
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?
Posted: Thu Feb 09, 2006 1:55 am
by ArndW
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.
Posted: Thu Feb 09, 2006 3:25 am
by ray.wurlod
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?
Posted: Thu Feb 09, 2006 8:01 am
by chulett
ray.wurlod wrote:This is going to be a very long, very slow way to learn ED, one command per post at a time.
