in reply to Extract metadata using syb_nsql

Have you tried:

my @metadata = $dbh->syb_nsql( 'sp_help tablename', 'HASH' );

Sure the fact that sp_help prints to STDOUT (or is it STDERR) leads to some funky output that can easily be ignored (or write your own error callback), but all the metadata should be there.

-derby

Replies are listed 'Best First'.
Re^2: Extract metadata using syb_nsql
by perl@1983 (Sexton) on Nov 11, 2010 at 21:15 UTC
    This doesn't seem to capturing proper results from sp_help . I am doing below: my $sql = "sp_help master"; my @arr = $dbhndl->($sql,"HASH"); print keys %$arr; Any idea if I am doing anything wrong over here?
    [reply]

    In Section Seekers of Perl Wisdom