Reg DS_Audit

raj_konig · Post by **raj_konig** » Wed Feb 08, 2006 6:08 am

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

ArndW · Post by **ArndW** » Wed Feb 08, 2006 6:09 am

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.

raj_konig · Post by **raj_konig** » Wed Feb 08, 2006 6:14 am

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

ArndW · Post by **ArndW** » Wed Feb 08, 2006 6:29 am

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"

kumar_s · Post by **kumar_s** » Wed Feb 08, 2006 6:44 am

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

kduke · Post by **kduke** » Wed Feb 08, 2006 7:07 am

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.

kumar_s · Post by **kumar_s** » Wed Feb 08, 2006 7:28 am

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

kduke · Post by **kduke** » Wed Feb 08, 2006 7:41 am

ED is a line editor. You have to learn this editor's commands. You can also use SETFILE.

chulett · Post by **chulett** » Wed Feb 08, 2006 7:46 am

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...

kduke · Post by **kduke** » Wed Feb 08, 2006 7:03 pm

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.

kumar_s · Post by **kumar_s** » Wed Feb 08, 2006 10:12 pm

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

kduke · Post by **kduke** » Wed Feb 08, 2006 11:00 pm

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?

ArndW · Post by **ArndW** » Thu Feb 09, 2006 1:55 am

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.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 09, 2006 3:25 am

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?

chulett · Post by **chulett** » Thu Feb 09, 2006 8:01 am

ray.wurlod wrote:This is going to be a very long, very slow way to learn ED, one command per post at a time.