iwat File attatch to Submit

FredGravel

Hi all

I am using a trigger to find out and log how many files get submit. I would like to know if there is a way to find the filename attatched to the Submit Event. here is the code I ise

Thanks

my ($user, $role, $action, $area, $objid, $file);



init();
sub init{
    $user = $ARGV[1];
    $role = $ARGV[2];
    $action = $ARGV[3];
    $area = $ARGV[4];
    $objid = $ARGV[5];
    initializeLogging("log_submit_rdbms", $user);


    my $store = $area;
    $store =~ m|^(\\[^\\]+)|;
    $store = $1;



    my $cmd = "iwattrib -o $objid $store entries";
    $file = `$cmd 2>&1` . "\n";
    chop($file);
    chop($file);

    DEBUG "This is the cmd: $cmd";
    DEBUG "This is the result: $file";    

    insert();
}


sub insert{
    #$file = "";
    chdir "D:\\iw-home\\local\\java";
    my $cmd = "D:\\iw-home\\tools\\java\\bin\\java OraThin \"insert into log values(CURRENT_TIMESTAMP, lower('$user'), '$role', '$action', '$area', '$file', '')\"";
    DEBUG "This is the cmd: $cmd";

    print " : " . `$cmd`;

}

ISCBorisB

is [there] a way to find the filename attatched to the Submit Event

Take a look at CLT "iwevents" Command. CLT Manual describes output format.

You can use "iwevents -s YourVpath latest" format or better yet, "iwevents -s $objid"
to parse Submission Object that triggered your Event Handler.