SQL Commands to interact with Windows Files in 9iR2

[Akhwashah]

HI,
I am currently working with Oracle OLAP 9i. We have some old express syntax
in our OLAP Web Agent application
which doesn't seem to work in 9i, where we require to check for and get a
list of certain files sitting on the Server.

I have not been able to find an alternate command in OLAP DML/Express SPL to
do this in 9i, so was wondering is there any SQL commands to allow you to do
this?

I have Express / VB knowledge, but my SQL / Relational knowledge is a bit
rusty.

regards,
Imran

[Daniel Morgan]

Akhwashah wrote:

HI,
I am currently working with Oracle OLAP 9i. We have some old express syntax
in our OLAP Web Agent application
which doesn't seem to work in 9i, where we require to check for and get a
list of certain files sitting on the Server.

I have not been able to find an alternate command in OLAP DML/Express SPL to
do this in 9i, so was wondering is there any SQL commands to allow you to do
this?

I have Express / VB knowledge, but my SQL / Relational knowledge is a bit
rusty.

regards,
Imran

I am just fed up with people that post to every usenet group they can
spell so yes I know the answer but no I'm not going to tell you. Please
repost to a single usenet group and then you will get a response. What
keeps happening is that we all pile on and it profilerates everywhere
and this is just ridiculous.

This message should be at c.d.o.server ... and nowhere else.

See what pain from a broken leg can do for you. ;-)

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace 'x' with a 'u' to reply)

[Bit Twister]

On Thu, 15 Jan 2004 22:25:48 -0800, Daniel Morgan wrote:

I am just fed up with people that post to every usenet group they can
spell

Do what I do, create a canned text file to include something like
what follows after the dashes. In this case the OP did crosspost but
did not set a followup.
-------------------------------------------------------
Net Etiquette/Newsgroup tip:

If you want to send the same message to more than one NG, CROSSPOST!

Some will argue that you not even crosspost do to the amount/type
of newsgroups that we have today.

As an example to post to "comp.os.linux.security", and
"comp.os.linux.hardware", use the following Newsgroups line:
Newsgroups: comp.os.linux.security,comp.os.linux.hardware

See http://www.cs.tut.fi/~jkorpela/usenet/xpost.html

You conserve resources on NNTP servers, and other readers
see the follow up answers and do not have to provide the same answer.
It makes it much harder to keep track of a discussion.
Also, once a reader has "read" a message in one group, they do
not have to see it again unless someone has provided a follow up.

[Galen Boyer]

Daniel,

Instead of answering all the posts and trying to educate all
those that would violate this rule, just configure your
newsreader to ignore multi-posted newsposts.

--
Galen Boyer

[Hans Forbrich]

Galen Boyer wrote:

Daniel,

Instead of answering all the posts and trying to educate all
those that would violate this rule, just configure your
newsreader to ignore multi-posted newsposts.

What an absolutely wonderful idea.

Please tell me how to do that with Netscape Navigator 4.8 so I too can
avoid getting upset about cross (and multi) posts.

[Galen Boyer]

On Fri, 16 Jan 2004, hf******@yahoo.net wrote:

Galen Boyer wrote:

Daniel,

Instead of answering all the posts and trying to educate all
those that would violate this rule, just configure your
newsreader to ignore multi-posted newsposts.

What an absolutely wonderful idea.

Please tell me how to do that with Netscape Navigator 4.8 so I
too can avoid getting upset about cross (and multi) posts.

Hm... I don't know that newsreader. I would assume you could
find it.
--
Galen Boyer

[Hans Forbrich]

Galen Boyer wrote:

On Fri, 16 Jan 2004, hf******@yahoo.net wrote:

Galen Boyer wrote:

Daniel,

Instead of answering all the posts and trying to educate all
those that would violate this rule, just configure your
newsreader to ignore multi-posted newsposts.

What an absolutely wonderful idea.

Please tell me how to do that with Netscape Navigator 4.8 so I
too can avoid getting upset about cross (and multi) posts.

Hm... I don't know that newsreader. I would assume you could
find it.

I can't. That's why I asked.

And since it appears that my newsreader can not handle cross posts, I
assume there might be others with the same limitation. Perhaps the
answer lies in netiquette rather than technology, after all? (Just a
thought.)

[Joel Garry]

Bit Twister <Bi********@localhost.localdomain> wrote in message news:<sl***********************@wb.home>...

On Thu, 15 Jan 2004 22:25:48 -0800, Daniel Morgan wrote:

I am just fed up with people that post to every usenet group they can
spell

Do what I do, create a canned text file to include something like
what follows after the dashes. In this case the OP did crosspost but
did not set a followup.

Do you understand that the charter of these groups specifically bans
crossposting these groups?

http://members.cox.net/oracleunix/ORACLECH.HTM

There is a work in progress on a readme for this newsgroup for new
users at http://www.dbaoracle.net

There is also an open issue as to whether a periodic faq should be
posted. Use google to find that.

jg
--
@home.com is bogus.
"If there's something you can't explain to a 10-year-old kid in five
sentences, then you don't understand it yourself." - David Brin
I'd like to see him explain Oracle performance tuning.

[Galen Boyer]

On Fri, 16 Jan 2004, hf******@yahoo.net wrote:

Galen Boyer wrote:

> Please tell me how to do that with Netscape Navigator 4.8 so
> I too can avoid getting upset about cross (and multi) posts.
Hm... I don't know that newsreader. I would assume you could
find it.

I can't. That's why I asked.

And since it appears that my newsreader can not handle cross
posts, I assume there might be others with the same limitation.

Sorry about that. Mine allows me to do so. The functionality I
actually use is a different flavor of it. I have it notice the
message-id so I only read the message once, no matter how many
groups it shows up in.
Perhaps the answer lies in netiquette rather than technology,
after all? (Just a thought.)

Well, I wouldn't think the scolding responses held so little
water if the people yelling about them also were good usenet
citizens and sufficiently trimmed their posts (Daniel is a big
offender in this regard). If one wants to measure the affect on
usenet experience, not sufficiently trimming one's posts if far
more of a gregious error against usenet humanity than
cross-posting.

--
Galen Boyer

[Hans Forbrich]

Joel Garry wrote:

Bit Twister <Bi********@localhost.localdomain> wrote in message news:<sl***********************@wb.home>...

On Thu, 15 Jan 2004 22:25:48 -0800, Daniel Morgan wrote:

I am just fed up with people that post to every usenet group they can
spell

Do what I do, create a canned text file to include something like
what follows after the dashes. In this case the OP did crosspost but
did not set a followup.

Do you understand that the charter of these groups specifically bans
crossposting these groups?

http://members.cox.net/oracleunix/ORACLECH.HTM

There is a work in progress on a readme for this newsgroup for new
users at http://www.dbaoracle.net

There is also an open issue as to whether a periodic faq should be
posted. Use google to find that.

A separate, tailored, vote on the periodic FAQ for each of the CDO
newsgroups was asked (in each NG) on Dec 24, 2003. Amusingly we have
received a total of 3 responses, including mine.

/Hans

[Daniel Morgan]

Hans Forbrich wrote:

Joel Garry wrote:

Bit Twister <Bi********@localhost.localdomain> wrote in message news:<sl***********************@wb.home>...

On Thu, 15 Jan 2004 22:25:48 -0800, Daniel Morgan wrote:

I am just fed up with people that post to every usenet group they can
spell
Do what I do, create a canned text file to include something like
what follows after the dashes. In this case the OP did crosspost but
did not set a followup.

Do you understand that the charter of these groups specifically bans
crossposting these groups?

http://members.cox.net/oracleunix/ORACLECH.HTM

There is a work in progress on a readme for this newsgroup for new
users at http://www.dbaoracle.net

There is also an open issue as to whether a periodic faq should be
posted. Use google to find that.

A separate, tailored, vote on the periodic FAQ for each of the CDO
newsgroups was asked (in each NG) on Dec 24, 2003. Amusingly we have
received a total of 3 responses, including mine.

/Hans

I was out of town for the holiday and did not have access. Perhaps it
was a matter of timing for others too.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace 'x' with a 'u' to reply)

[Hans Forbrich]

Daniel Morgan wrote:

A separate, tailored, vote on the periodic FAQ for each of the CDO
newsgroups was asked (in each NG) on Dec 24, 2003. Amusingly we have
received a total of 3 responses, including mine.

/Hans

I was out of town for the holiday and did not have access. Perhaps it
was a matter of timing for others too.

The CFV for each NG has been reposted. Deadline is still Jan 24, 2004
23:59:59 UTC.

A reminder: for a vote to count, the sending email address will be
verified by sending a confirmation email. Bounces will cause a vote to
be rejected. Email address will NOT be recorded and the target address
and all email traffic and local files will be destroyed by Feb 15, 2004
after the summary has been posted.

(With due apologies for the cross-post.)
/Hans

[Joel Garry]

Hans Forbrich <hf******@yahoo.net> wrote in message news:<40**************@yahoo.net>...

Galen Boyer wrote:

On Fri, 16 Jan 2004, hf******@yahoo.net wrote:

Galen Boyer wrote:
>
> Daniel,
>
> Instead of answering all the posts and trying to educate all
> those that would violate this rule, just configure your
> newsreader to ignore multi-posted newsposts.
>

What an absolutely wonderful idea.

Please tell me how to do that with Netscape Navigator 4.8 so I
too can avoid getting upset about cross (and multi) posts.

Hm... I don't know that newsreader. I would assume you could
find it.

I can't. That's why I asked.

And since it appears that my newsreader can not handle cross posts, I
assume there might be others with the same limitation. Perhaps the
answer lies in netiquette rather than technology, after all? (Just a
thought.)

And of course, some of us use google or other strange access methods.
If it were up to me, we'd all use slrn.

jg
--
@home.com is bogus.
Hey, programming is easy!
http://www.signonsandiego.com/news/u...6offshore.html