Re: Wanted information on SQR

In article 499_at_busadm1.cba.hawaii.edu, radar_at_busadm1.cba.hawaii.edu (Johnson, James) writes:
> A person who was in my Oracle DBA class mentioned that they use SQR and
> recommends it over SQL*ReportWriter. I've not been able to get in touch
> with him for more information. My questions are:
>
> 1) Who makes the product?
> 2) What is there phone number?
> 3) Personal experience with SQR?
> 4) Strong points and weak points?
> 5) Cost?

Jim:

Here's a few answers. Hope they help!

1. It is made by (or currently owned by) Sybase, and previously owned By SQL Solutions.
2. The last phone number I have is 310-424-4399
3. We have been developing in SQR at this site for about 4-5 years now.
4. IMHO: Strong Points:
   • Very easy to write a quick report if you already have knowledge of SQL.
   • Procedural language
   • Compiles to a run-time form just like a SQL*Forms .FRM.
   • Can be used for other things as well as reports. We currently have a plethora of programs written such as data loads, flat-file dumps, etc.
   • Available on a variety of platforms (We currently run VMS, DOS, and Unix versions) Weak Points:
   • Can be somewhat slow sometimes, but only if you're using it to do strange stuff like data loads, etc.
   • A couple of environment variable bugs in the Unix version don't allow for use of environment variables very easy (they're "working on it")
   • Don't know if this is applicable, but it seems that the company has changed hands a lot in the past two years. The quality of the product and service hasn't changed though.
5. It varies based on platform. It would be best for you to call the number and I'm *SURE* they will be glad to tell you! ;^>

        Hope this helps!

---

--------------------------------+------------------------+--------------------
Gary B. Eckhardt                |  Software Development  |  This space for
Computer Sciences Corporation   |  MISTS HSC Support     |  rent or lease.
eckhardg_at_radon.brooks.af.mil    |  (210) 536-2826        |  (Cheap!)

   "If the world was a logical place, all cowboys would ride side-saddle."
                         --Ranger Doug, "The Riders In The Sky"