[sqr-users] Dynamic Programming and Output Generation

[Matt Rogish <rogishmn@muohio.edu>]

Hi all,

We're using SQR 4.3.4 (on AIX??) to write many, many SQR reports.  The 
problem we've found is that over the years (and hundreds of programs later) 
we've got a mix of different styles etc. and it's becoming increasingly 
difficult.  Oftentimes we have reports that take the same input parameters 
but, of course, they are written differently so that some have bounds 
checking and others don't etc.

What I'd like to do is store the input parameters in a DBMS table and then 
run it at the beginning of every report to build the input list, e.g. 
something like this:
(pseudocode)
begin-select
name            &name
prompt  &prompt
length          &len
type            &type

   !this way
   input &name MAXLEN=&len &text TYPE=&type

   !or with an array to be gone over later
   Put &name &prompt &len &type Into paramArray( #something )

  FROM params
WHERE program_name = '{program_name}'
end-select

But I can't get SQR to accept any sort of input like that.

Secondly, we use BRIO Portal 6 (whatever is one or two version(s) behind 
the current one) which doesn't support emailing the output from a job (SQR 
Program) to more than one person.  We're not entirely sure the latest 
version of BRIO.Portal supports this, so if it doesn't we'd like a way to 
be able to email output to more than one person using SQR.

I was thinking storing the distribution lists in another DBMS table and 
then using the Unix mail command to mail it to someone else.  I see from 
this old thread (http://www.sqrug.org/sqr-users/sqrusers_97/msg00150.html) 
that I can close the output of the current program, but how do I find out 
the file name of the output file (usually a .pdf via -printer:pd) so that I 
can use it as an attachment.  Anyone tried something like this and have a 
better way?  Or is Brio Portal 7 (the version we're looking at upgrading 
to) more advanced than the version we're using now?


Thanks,

--
Matt Rogish - rogishmn@muohio.edu
Programmer
Advancement Services
Miami University
513.529.1420

Do not meddle in the affairs of SQR,
for it is subtle and quick to anger! 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users