| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: {SPAM?} RE: Teradata baned from IOUG???
Good Advice. But Alas, I have not yet had the time to learn Perl. Though I
have all the material to learn it. Including a interesting little book "Perl
for Oracle DBAs".
One of these days I will stop treading water and starting swimming for shore.
>From: Jared Still <jkstill_at_cybcon.com>
>To: ORACLE-L_at_fatcity.com, "david davis" <ddoralist_at_hotmail.com>
>Subject: Re: {SPAM?} RE: Teradata baned from IOUG???
>Date: Sat, 15 Feb 2003 18:50:05 -0800
>
>
>Try Perl.
>
>It's magnitudes better than PL/SQL for files and logs.
>
>Jared
>
>On Saturday 15 February 2003 14:23, david davis wrote:
> > Another advantage of SQR is multi-platform. We used to run SQR/MVS
>against
> > DB2, now run it on Unix against Oracle and of course the SQR for Windows
> > product against Oracle. It was simple to port our SQR code from DB2/MVS
>to
> > Oracle. Now it might be tougher as we use a lot of Oracle specific stuff
>in
> > our queries which makes it harder to port. But SQR is a decent product.
>We
> > use it with PeopleSoft but another part of our business (Investment
> > division) also uses the product for their systems.
> >
> > I wish I had it available for use with one of our finance systems.
>Having
> > to program in PL/SQL. That's a real drag when it comes to doing file i/o
> > for logs/reports.
> >
> >
> >
> >
> >
> >
> > From: "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com>
> >
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: RE: {SPAM?} RE: Teradata baned from IOUG???
> > >Date: Fri, 14 Feb 2003 07:29:29 -0800
> > >
> > >Well,
> > >
> > >I see one reason ... (I am no expert in Oracle reports), but it seems
>more
> > >maintainable to write in SQR than in reports (so they claim here).
>Plus
> > >SQR
> > >can act asa glorified data loader when a bunch of processing needs to
>be
> > >done on incoming raw data.
> > >
> > >I wouldn't discount SQR right away, but after all it is almost
>glorified
> > >COBOL (IMHO).
> > >
> > >Doing dynamic SQL is much much easier in SQR than in Oracle Reports
>(again
> > >my experience SQR 4/5/6 and ORacle Reports 6/6i). SQRs use of lookup
> > > tables and breaks make life simpler as well. It has usable array
> > > interface ... for data processing. We have couple of SQR reports that
>run
> > > in about 4000 lines of code (don't ask me why)
> > >
> > >My $0.01
> > >Raj
> > >______________________________________________________
> > >Rajendra Jamadagni MIS, ESPN Inc.
> > >Rajendra dot Jamadagni at ESPN dot com
> > >Any opinion expressed here is personal and doesn't reflect that of ESPN
> > >Inc.
> > >
> > >QOTD: Any clod can have facts, but having an opinion is an art!
> > >
> > >
> > >-----Original Message-----
> > >Sent: Friday, February 14, 2003 10:09 AM
> > >To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >
> > >We looked at SQR in 94.
> > >
> > >We didn't have need of controlling fonts and such, which I guess
> > >SQR is good at.
> > >
> > >The SQR rep could come up with no compelling reason to use SQR
> > >rather than Perl, so simple ( as in not much procedural processing
> > >needed ) reports were done in Sqlplus. Anything complex was done
> > >in Perl.
> > >
> > >We never regretted that decision.
> > >
> > >Jared
> > ><< ESPN_Disclaimer.txt >>
> >
> > _________________________________________________________________
> > Help STOP SPAM with the new MSN 8 and get 2 months FREE*
> > http://join.msn.com/?page=features/junkmail
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: ddoralist_at_hotmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Sat Feb 15 2003 - 21:58:50 CST
 |
 |