| 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???
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 >>
-- 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 - 16:23:46 CST
 |
 |