Output to Causes Core Dumps? Elvis seen in Peru?
Posted in 1991
Topics: Storage & Space Management
I am trying to help someone with ISQL 2.10.3k. They have a bunch of small
reports on a small database. Most of them work. One core dumps.
Here is a chunk of it:
==============================================================================
input PROMPT for var_begdate USING "Enter Beginning date ... "
PROMPT for var_endate USING "Enter Ending date .... "
end
output
{ report to pipe "lp" THIS Gets "memory fault - core dumped"}
{ report to pipe "cat > nrpz.out" THIS Gets "memory fault - core dumped"}
report to "nrpz.out" {THIS works just fine...sheesh! }
left margin 0
right margin 133
end
SELECT * FROM enroll, program, outer genacct
WHERE (enr_paydate between $var_begdate AND $var_endate)
AND enr_program = prog_code
AND enr_progqtr = prog_qtr
AND enr_year = prog_year
AND prog_genacct = gen_acct
ORDER BY gen_acct, gen_acctnam, enr_paydate
END
==============================================================================
I noticed that by changing the REPORT TO clause I can make it execute. But
other reports do work with an output to pipe. Am I missing something, or
was there a goofy bug in that version of ISQL?
------------------------------------------------------------------------------
Neal Rhodes MNOP Ltd (404)- 972-5430
President Lilburn (atlanta) GA 30247 Fax: 978-4741
emory!mnopltd!neal
------------------------------------------------------------------------------
(ok. I stuck that Elvis thing in to get your attention.......)