SP Debugger for SQR

  Save time in programming and testing
  Get an in-depth view of your program
  Improve code quality

Even well-designed programs can conceal obscure bugs and inefficiencies. Stop wasting time and cluttering your programs with #DEBUG and SHOW statements. Discover what your program is really doing, as it does it, in real time.

SP Debugger for SQR is a flexible, easy-to-use tool that helps you monitor and interact with your program on a line-by-line basis. It's an affordable solution that could pay for itself in time savings with your next program fix.

See it in a quick online demo

Try it with a free download

Buy it or view pricing and options

Features

Step through your program one statement at a time
Set and clear breakpoints; run to the next breakpoint
Step over an entire procedure, or step through it
Watch the debugger "auto-step" through your code
Pause program execution at any time
Rerun the program from the beginning
Force a database COMMIT at any time

Plus:

View and modify variable values (including SQR reserved variables)
Explore arrays; view and modify individual array cells
View the values of substitution variables ({variable})
Run until a variable or array cell changes or satisfies a specified condition
Debugger catches unhandled runtime SQL errors
Program structure tree, variable list, and other views
All #INCLUDE files expanded and debuggable
Configurable syntax highlighting
"Code Alerts" checks for common hard-to-find programming errors
An integrated profiler identifies slow, inefficient code
Run SQRs under the debugger or SQRW's "black box"
Single-click program execution; no separate compile step to run
Comprehensive, indexed and searchable help information
A clean, easy-to-use interface; no commands to enter
Works seamlessly with SQR Express™— a complete Integrated Development
Environment for SQR by Business Computing Solutions LLC

System Requirements

•  Windows XP SP2, Windows Vista, or Windows 7¹
•  Brio/Hyperion/Oracle SQR 4.3+ or PeopleSoft SQR
•  Oracle, MS SQL Server, Sybase, or ODBC database
•  Two-tier database access²
•  Microsoft .NET Framework 2.0+³

¹	For Unix, see the FAQ.
²	Two-tier database access means that you can connect to the database from your PC using a database user ID and password. If you can successfully run SQRW, SQL*Plus, Query Analyzer, SQL Advantage, Toad, or a similar SQL tool, then you have two-tier access.
³	You probably already have the .NET Framework—the installation program will check. The Framework is a free download from Microsoft and is bundled with most current versions of Windows. Want to check right now? Open Windows Explorer or My Computer, paste the following string into the address bar, and hit Enter. %systemroot%\Microsoft.NET\Framework\v2.0.50727 If the folder opens (i.e., no error message is displayed), then you do have the Framework.

Frequently Asked Questions

Is Unix supported for interactive debugging?
No—this is a Windows program. However, we have many customers who use Unix for their production SQR processing. These customers develop and debug their SQR programs on Windows PCs and then migrate the final code to Unix. There are no plans to develop a native Unix version.

Can the program be run from a shared network drive?
Yes, although we strongly recommend that you install it locally on your own PC. During debugging sessions there is I/O traffic that is handled much more efficiently when the program is installed on your PC.

Can the program be run on a remote access or Citrix^® server?
Yes.

Does the debugger support PeopleSoft^® systems? Is PeopleSoft required?
The debugger does not require PeopleSoft, but any PeopleSoft version is supported as long as your SQR version is 4.3 or higher.

Can programs be debugged from the PeopleSoft menu (or portal or Process Scheduler)?
Programs run through the debugger are run outside of the PeopleSoft system. This question is related to PeopleSoft run control and how an SQR program receives run control parameters. The debugger can supply these parameters, simulating a run under Process Scheduler in such a way that your SQR program can't tell the difference. The setup for this is explained in the help file.

Does this product include the SQR language compiler/interpreter?
No. SQR is a separate product that is a part of Oracle^® Production Reporting and is bundled with various other products. For information, contact Oracle Corporation.

We have several developers working remotely. Would a site license apply in our situation?
It may—please contact us to see what type of licensing is best for you.

I am a consultant. Can I use my licensed copy of the program at my client's site?
Yes. (Remember to uninstall it when your assignment ends.)

Will this product teach me how to develop SQR programs? Is it a tutorial?
No, that's not its purpose.

Selected Customers

Licensed users of SP Debugger for SQR include public and private sector organizations of all sizes in a wide variety of industries. Here is a partial list:

Our Customers Say...

"I really do love your debugger and wonder how I was able to develop without it.
Thanks for making such a great product."

"This tool will make doing the work of 3 people manageable."

"I have used the debugger for many years now... Many thanks for such a useful product."

"What a pleasure it is to step through code and watch both the program execution and
variable assignments. This thing is really slick!"

"Love your debugger! It's one of those programs that pays for itself many times over."

"I need to let you know I love your new version. It remains a wonderful tool, and the
new features are very helpful."

"I'm happily using SP Debugger daily and haven't had any issues. So many thanks
for such a useful and stable product!"

30-day Free Trial Download

For an evaluation copy, simply fill out the form below.

The evaluation version is identical to the licensed version and will function for 30 days. Instructions for downloading the program will be sent to your email address. Once you receive the instructions, you can have the program installed in about five minutes. No reboot is needed.

We hope you will find the product useful!

Your name
Company/organization name
Your email address *
Enter email again to confirm *
In the field below, please enter any one of the SQR commands that begin with the word "BEGIN". For example, you could enter BEGIN-SQR if that is a legal SQR command. What's this?
An SQR "BEGIN" command *
* = Required field

This is just an attempt to filter out some of the spam bots, plus those who know nothing about SQR and would only be confused by the download.

• Questions about SP Debugger for SQR?
• Licensing questions?
• Need a W-9?
• Have a purchase order to send?
• Need help ordering online?
• Need any other information?

Or contact Kevin Reschenberg
Phone: (949) 276-3833
Fax: (480) 247-5349

SparkPath Technologies, Inc.
26895 Aliso Creek Road, Suite B-684
Aliso Viejo, CA 92656-5301
USA

By using this site, you agree to the following Terms of Use.

The information, services, and assistance provided on this site are necessarily general in nature and are provided AS-IS AND WITHOUT WARRANTY OF ANY KIND WHATSOEVER. Because of great variations in individual circumstances, no assurance can be given that the information, services, and assistance provided on this site will be accurate or complete with respect to any user's particular system or applicable to any particular installation or situation. ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO ANY WARRANTY OF FITNESS FOR A PARTICULAR PURPOSE, ARE EXPRESSLY DISCLAIMED.

By using this site, you agree that none of the providers of the information, services, or assistance on this site will be held liable for any damages, liabilities, costs, expenses or special, incidental, consequential, punitive, or exemplary damages (including, without limitation, any lost revenue or profit, even if the person or entity has been advised of the possibility of such damages) related to or connected with the information, services, or assistance you obtain from this site.

We use third-party advertising companies to serve ads when you visit our website. These companies may use information (not including your name, address, email address, or telephone number) about your visits to this and other websites in order to provide advertisements about goods and services of interest to you. If you would like more information about this practice and to know your choices about not having this information used by these companies, click here.

An essential tool for the SQR programmer