Re: {SPAM?} RE: Teradata baned from IOUG???

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: Jared Still
  INET: jkstill_at_cybcon.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).