From sqrusers@sqrug.com Thu Sep 12 20:33:52 1994 Date: Mon, 12 Sep 94 14:33:52 MDT From: Nathan Treadway Subject: sample message II This is a sample message, number II. I think we are ready to send an announcement about the list now.... Nathan ---------------------------------------------------------------------------- Nathan Treadway | Ray Ontko & Co. | info@ontko.com (auto-reply server) nathant@ontko.com | Richmond, IN | ftp.ontko.com:/users/ontko (anon ftp) From sqr-users@usa.net Sat Oct 8 17:53:45 1994 Date: Sat, 8 Oct 94 11:53:45 MDT From: "Ray Ontko" Subject: RE: Creating and using temporary tables > Howard Hartsfield has run into a problem which he posted to the > Comp.Databases.Sybase Usenet group. He wants to create a temporary > table in a program and use it. Of course the parser complains at > compile time that the table doesn't exist. Is his only recourse to make > it a permanent table? >From a system administration and efficiency standpoint, it may make sense to create the table permanently. If the table needs to be separate for each user or session, you may want to add a column identifying the user and have periodic batch jobs to clean up any old data that gets left around. If he's generating an SQT file, it is possible to create the table, compile the program, and then drop the table (assuming of course that the program creates the table and drops it during its execution.) If he's not generating an SQT file, I can't think of any other work around besides a permanent table. Ray ----------------------------------------------------------------------- Ray Ontko rayo@ontko.com "Ask me about Database Illustrator(tm)" Ray Ontko & Co info@ontko.com ftp.ontko.com:/users/ontko (anon ftp) From sqr-users@usa.net Wed Nov 2 12:43:50 1994 Date: Wed, 2 Nov 94 05:43:50 MST From: "robert Voysey" Subject: Processing results fro a stored procedure Is there a way to process rows or return values returned from a stored procedure in sqr? From sqr-users@usa.net Wed Nov 2 13:17:09 1994 Date: Wed, 2 Nov 94 06:17:09 MST From: "Chalice Burbage..ROPT1..ext 651 8651" Subject: RE: Processing results fro a stored procedure You could always store the values to a file and have the next procedure read that file. Regards, Chalice From sqr-users@usa.net Wed Nov 2 16:17:22 1994 Date: Wed, 2 Nov 94 09:17:22 MST From: "Schindler,John,JF" Subject: RE: Processing results fro a stored procedure Yes it is very easy to do, but some cautions are required. You will need to use "Begin-Sql" and execute a PL/SQL block that in turn calls the procedure. Begin-Sql Begin .();; End;; End-Sql The caution is related to the variable initialization of your return parms. If you want to return a character string greater than 30 characters in length, make sure you pre-allocate the string with spaces. SQR will trunc it to 30 chars as this is their default, and they have no idea the length of the returned value. Also, this only works in later versions of SQR. ie not in 2.27. This is working on VMS 2.5.2.2, and Unix Sys 5 Rel 4 SQR 2.4.2. Good Luck John ---------- From: sqr-users To: schindjf Subject: Processing results fro a stored procedure Date: Wednesday, November 02, 1994 5:43AM Is there a way to process rows or return values returned from a stored procedure in sqr? From sqr-users@usa.net Wed Nov 2 19:43:25 1994 Date: Wed, 2 Nov 94 12:43:25 MST From: gadiy@sun4.miti.com Subject: Re: Processing results from a stored procedure >>>> Is there a way to process rows or return values returned >>>> from a stored procedure in SQR? With SQR/ORACLE, you can execute a PL/SQL block (that invokes the stored procedure) in a "begin-sql" section. You can pass variables both IN and OUT. The feature of returning multiple rows from an ORACLE stored procedure does not exist in ORACLE yet. I understand its coming soon in the form of a procedure that returns a cursor. We'll have to think of a mechanism in SQR to support that when it comes. With SQR/Sybase (and I believe also with Ingres), you can use the SQR EXECUTE command to process rows or return values returned from a stored procedure. I hope this answers your question. If not, please give more details of what you are trying to do. Gadi Yedwab MITI From sqr-users@usa.net Wed Nov 2 19:45:55 1994 Date: Wed, 2 Nov 94 12:45:55 MST From: gadiy@sun4.miti.com Subject: Re[2]: Processing results from a stored procedure >>>> If you want to return a character string greater than 30 >>>> characters in length, make sure you pre-allocate the string >>>> with spaces. SQR will trunc it to 30 chars as this is their >>>> default, and they have no idea the length of the returned value. FYI, this was further improved in SQR Version 3 where you don't need to pre-allocate any more and SQR will handle the length. If any of you SQR users out there want to take part in the SQR Version 3 beta program (on SunOS, HP-UX, AIX, VMS or Windows), call MITI at 310-424-4399 ext. 363 or email to "sqrbeta@miti.com". Gadi Yedwab MITI From sqr-users@earth.usa.net Sat Nov 5 23:26:33 1994 Date: Sat, 5 Nov 94 16:26:33 MST From: "Gardberg,Mindy,ML" Subject: sorting an array Currently I am trying to sort an array based on a dated value. (I can not do this using an SQL statement because of the other requirements in the report). does anyone have a generic swapping procedure to take care of this situation, Possibly, a procedure that uses two arrays: first one with the data filled array and the second for swapping the pointers. Thanks in advance, Mindy Bohannon BP Oil From sqr-users@earth.usa.net Sun Nov 6 00:08:28 1994 Date: Sat, 5 Nov 94 17:08:28 MST From: gadiy@sun4.miti.com Subject: Re[3]: Processing results fro a stored procedure What's your version of the SQR manual? The 2.5 version has the EXECUTE command described on page 4-59. If you don't have it you should certainly get a copy. The execute command goes like that: EXECUTE Executes a stored procedure. (EXECUTE is restricted to the Sybase and Ingres versions of SQR.) Syntax EXECUTE [ -Cnn ] [ ON-ERROR= procedure [ ( arg1 [, argi ] ... ) ] [ DO= procedure [ ( arg1 [, argi ] ... ) ] [ @#status_var= ] stored_procedure_name [ [ @param= ] { any_var | _lit } [ OUT[PUT] ] ] [, ...] [ INTO any_col data_type [ ( length_int_lit ) ] ] [, ...] [ WITH RECOMPILE ] The syntax of this command roughly follows that of the Sybase Transact-SQL EXECUTE command, with the exception of the three optional arguments and the INTO argument. Arguments -Cnn - Specifies the logical connection number. ON-ERROR - Declares a procedure to execute if an error occurs. If ON-ERROR is omitted and an error occurs, SQR halts with an error message. For severe errors (for example, passing too few arguments) SQR halts, even if an error procedure is specified. You can optionally specify arguments to be passed to the ON-ERROR procedure. Arguments can be any variable, column, or literal. DO - Specifies a procedure to execute for each row selected in the query. Processing continues until all rows have been retrieved. You can optionally specify arguments to be passed to the procedure. Arguments can be any variable, column, or literal. @#status_variable - Returns the procedure's status in the specified numeric variable. The status is returned only after selected rows are retrieved. stored_procedure_name - Names the stored procedure to execute. @param - Names the parameter to pass to the stored procedure. Parameters can be passed with or without names. If used without names, they must be listed in the same sequence as defined in the stored procedure. any_var | _lit - Specifies the value passed to the stored procedure. It can be a string or numeric variable, a previously selected column, a numeric literal, or a string literal. OUT[PUT] - Indicates that the parameter will receive a value from the stored procedure. The parameter must be a string or numeric SQR variable. Output parameters receive their values only after rows selected have been retrieved. If multiple output parameters are specified, they must be in the same sequence as defined in the stored procedure. INTO - Indicates where to store rows that are retrieved from the stored procedure's SELECT statement. The INTO argument contains the names of the columns with data types and lengths (if needed). The columns must be specified in the same sequence and match the data type used in the stored procedure's SELECT statement. If the stored procedure contains more than one SELECT query, only the first query is described with the INTO argument. Rows from subsequent queries are ignored. WITH RECOMPILE - Causes the query to recompile each time it is executed rather than using the plan stored with the procedure. Normally, this is not required or recommended. Description The stored procedure must contain a SELECT statement, and the EXECUTE command must contain an INTO argument. If no DO procedure is specified and the stored procedure specified in stored_procedure_name nevertheless selects one or more rows and an INTO argument is specified, EXECUTE retrieves the first row only, ignoring the remainder of the rows. This is useful for queries returning a single row. Examples In the following example, the stored procedure get_total is invoked with two parameters: a string literal and a string variable. The result from the stored procedure is stored in the variable #total. execute get_total 'S. Q. Reporter' $State #Total Output In the following example, the stored procedure get_products is invoked with two parameters. The stored procedure selects data into four &columns. The SQR procedure print_products is called for each row retrieved. The return status from the stored procedure is placed in the variable #proc_return_status: execute do=print_products @#proc_return_status= get_products @prodcode=&code, @max=#maximum INTO &prod_code int, &description char (45), &discount float, &restock char begin-procedure print_products print &prod_code (+1,1) print &description (+5,45) print &discount (+5) edit 99.99 print &restock (+5) match Y 0 5 Yes N 0 5 No end-procedure Gadi. ______________________________ Reply Separator _________________________________ Subject: Re[2]: Processing results fro a stored procedure Author: usa.net!sqr-users@netcomsv.netcom.com at Internet Date: 11/3/94 1:23 PM I did not specify how I was running SQR. I am running it from windows version 2.5 using sybase database. I will also be runnig it from SunOS using sybase. I had heard that to get rows back you use EXEC but the manual I have does not have this documented. Could someone send me the syntax with perhaps an example program. Thanks Robert Voysey From sqr-users@earth.usa.net Mon Nov 7 15:24:39 1994 Date: Mon, 7 Nov 1994 08:24:39 -0700 From: Nick Moscaritolo x2542 Subject: Re: sorting an array Mindy, SORTing an Array cannot be done unless you off-load the data. I like to use a flat file. Dump your array into a file, then use the VMS SORT command (or your system SORT function). Once SORTed, "READ" the data from the SORTed flat file into an array. I find it much faster and much efficient. It is a bit messy, but the rewards greatly exceed the costs. Nick Moscaritolo Bentley College From sqr-users@earth.usa.net Mon Nov 7 19:26:34 1994 Date: Mon, 7 Nov 1994 12:26:34 -0700 From: "robert Voysey" Subject: Re[2]: sorting an array Is it not be possibe to use a bubble sort instead? ______________________________ Reply Separator _________________________________ Subject: Re: sorting an array Author: sqr-users@earth.usa.net at NYCCIP01 Date: 11/7/94 10:39 AM Mindy, SORTing an Array cannot be done unless you off-load the data. I like to use a flat file. Dump your array into a file, then use the VMS SORT command (or your system SORT function). Once SORTed, "READ" the data from the SORTed flat file into an array. I find it much faster and much efficient. It is a bit messy, but the rewards greatly exceed the costs. Nick Moscaritolo Bentley College From sqr-users@earth.usa.net Mon Nov 7 19:41:45 1994 Date: Mon, 7 Nov 1994 12:41:45 -0700 From: mike@rmf41.usace.army.mil Subject: Reply to sorting an array Mindy, if your problem involves merging data from 2 or more tables and sorting them together, I can suggest the UNION statement, and also perhaps the DECODE statement. I have used these in such a situation recently. -------------------------------------------------------------------------- "It was not called the Net of a Million Lies for nothing." Vernor Vinge -------------------------------------------------------------------------- Michael Stone (205) 890-2410 | A TTTTTTT SSSSS Advanced Technology Systems (ATS), Inc. | A A T S 4801 University Square, Suite 2 | AaaaA T SSSSS Huntsville, AL 35816-3431 | A A T S mike@rmf41.usace.army.mil | A A T SSSSS -------------------------------------------------------------------------- From sqr-users@earth.usa.net Mon Nov 7 20:16:39 1994 Date: Mon, 7 Nov 1994 13:16:39 -0700 From: "Gardberg,Mindy,ML" Subject: RE: Re[2]: sorting an array Actually, I ended up using a bubble sort and it works just fine. Also, the sort is inside the program, which makes it system independent too. Thanks for your help. Mindy Bohannon BP Oil From sqr-users@earth.usa.net Mon Nov 7 20:33:23 1994 Date: Mon, 7 Nov 1994 13:33:23 -0700 From: Nick Moscaritolo x2542 Subject: Re: Re[2]: sorting an array Although a BUBBLE SORT is possible, it is CPU costly and therefore not worth it. Using the VMS SORT command works great. NICK MOSCARITOLO Bentley College From sqr-users@earth.usa.net Mon Nov 7 21:11:01 1994 Date: Mon, 7 Nov 1994 14:11:01 -0700 From: "Schindler,John,JF" Subject: RE: Reply to sorting an array Mindy The response to SORTing data by using "SYSTEM" is one which locks you into the host operating. If your needs are to due internal sorts, such that you only get data from the database once, and always stay within the SQR program, a Bubble sort is a way to due this. Another more drastic approach which will also work is to write a "C" userexit . Then link this into SQR on all of the platforms you run. You have then enhanced SQR for the next programmer with the same needs. Happy Coding The Snowman From markjo@ix.netcom.com Sat Nov 26 15:37:46 1994 From: markjo@ix.netcom.com (Mark Johnson) Subject: SQR-Users: SQR-Users administrative note Date: Sat, 26 Nov 1994 15:37:46 -0700 Dear SQR-Users, Welcome to the SQR-Users mailing list! Myself and others would like to see this list become a forum where serious inquiries can reach a healthy number of SQR-savy users. Currently I think that we, as a group, have a sizeable amount of expertise on our list. The list has grown to over ninety people, and we have such luminaries as Matt Reagan, Chair of the National SQR Users Group, and Israel Stern who we can thank for having written SQR in the first place. We have a number of MITI's finest technical folks, including the Vice President of Engineering, the Project Leader for SQR Porting and QA Group, the Applications Engineer, and the Project Leader, SQR. With these feathers in our cap, I hope that we can recognize this mailing list as a viable means of obtaining support, and use it to tighten the SQR community. I would also like to make an administrative note. When posting mail to the group, start the subject line with "SQR-Users:" as I have done. Because different mail reader programs display the sender information differently, this will avoid ambiguity as to whether the mail was sent from an individual to an individual, or sent from an individual to the group and back to the individuals. One final note about SQR quick reference cards. Ray Ontko & Co. provides reference cards for version 2.28, and MITI provides reference cards for the latest versions. Both are free. If MITI sends you a reference card, please fill out the customer profile card and the SQR survey for them. Here is the contact information. MITI Ray Ontko & Co. 2895 Temple Ave. 822 Promenade Long Beach, CA 90806 Richmond In, 47374 Attn.: Candice Tuttle Attn.: Lori Rhoda Tel: 310/424-4399 Tel: 800/935.4283 Fax: 310/424-9385 Fax: 317/962/9788 E-mail: markjo@ix.netcom.com Thank you, and enjoy, -Markjo -- ---------------------------------------------------------------------------- Mark Johnson markjo@ix.netcom.com Ray Ontko & Co. (415)397-7152 Have a nice day. From markjo@ix.netcom.com Thu Dec 01 21:00:40 1994 From: markjo@ix.netcom.com (Mark Johnson) Subject: SQR-Users: Administrative note Date: Thu, 01 Dec 1994 21:00:40 -0700 Dear SQR-Users, Pardon the SQR-Users mailing list administrative note. The SQR-Users Mailing List has become a forum where serious inquiries can reach a healthy number of SQR-savy users. Currently I think that we, as a group, have a sizeable amount of expertise on our list. The list has grown to over ninety people, and we have such luminaries as Matt Reagan (Chair of the National SQR Users Group), and Israel Stern (who we can thank for having written SQR in the first place). We have a number of MITI's finest technical folks, including the Vice President of Engineering, the Project Leader for SQR Porting and QA Group, the Applications Engineer, and the Project Leader of SQR. With these feathers in our cap, I hope that we can recognize this mailing list as a viable means of obtaining support, and use it to tighten the SQR community. Here is the administrative part. When posting mail to the group, start the subject line with "SQR-Users:" as I have done. Because different mail reader programs display the sender information differently, this will avoid ambiguity as to whether the mail was sent from an individual to an individual, or sent from an individual to the group and back to the individuals. One final note about SQR quick reference cards. Ray Ontko & Co. provides reference cards for version 2.28, and MITI provides reference cards for the latest versions. Both are free. If MITI sends you a reference card, please fill out the customer profile card and the SQR survey for them. Here is the contact information. MITI Ray Ontko & Co. 2895 Temple Ave. 822 Promenade Long Beach, CA 90806 Richmond In, 47374 Attn.: Candice Tuttle Attn.: Lori Rhoda Tel: 310/424-4399 Tel: 800/935.4283 Fax: 310/424-9385 Fax: 317/962/9788 E-mail: candicet@miti.com E-mail: lorir@ontko.com Thank you, and enjoy, -Markjo -- ------------------------------------------------------------------------------ Mark Johnson markjo@ix.netcom.com Ray Ontko & Co. (415)397-7152 Have a nice day. From markjo@ix.netcom.com Tue Dec 20 10:39:57 1994 Date: Tue, 20 Dec 1994 10:39:57 -0700 From: Nick Moscaritolo x2542 Subject: Re: SQR puzzle o' the week ! Nick Moscaritolo ! Bentley College ! >>>>> for SQR 2.x - we do not have SQR 3 yet BEGIN-REPORT move '' to $new_str_var move 1 to #char_ctr DO get_column show (15,1) cs $new_str_var END-REPORT BEGIN-PROCEDURE get_column BEGIN-SELECT 'HOWDY' &str_var WHILE #char_ctr <= length(&str_var) let $new_str_var = $new_str_var||substr(&str_var,#char_ctr,1)||' ' add 1 to #char_ctr END-WHILE FROM system.dual END-SELECT END-PROCEDURE get_column From markjo@ix.netcom.com Tue Dec 20 13:54:04 1994 From: markjo@ix.netcom.com (Mark Johnson) Subject: Re: SQR puzzle o' the week Date: Tue, 20 Dec 1994 13:54:04 -0700 Nick's solution looks like a good one. I don't think you will find more efficient solutions than this when using SQR3. Two points though: SYS owns the Dual table and the last line utilizes an undocumented "feature". Look at the syntax for end-procedure in the manual, and you will see that there is not supposed to be a procedure name. Although it won't break under SQR3 either, it is unsupported, so there is no guarantee for future releases. I recommend: begin-procedure get_column end-procedure ! get_column > >! Nick Moscaritolo >! Bentley College >! >>>>> for SQR 2.x - we do not have SQR 3 yet > >BEGIN-REPORT > move '' to $new_str_var > move 1 to #char_ctr > DO get_column > show (15,1) cs $new_str_var >END-REPORT > >BEGIN-PROCEDURE get_column >BEGIN-SELECT >'HOWDY' &str_var > WHILE #char_ctr <= length(&str_var) > let $new_str_var = $new_str_var||substr(&str_var,#char_ctr,1)||' ' > add 1 to #char_ctr > END-WHILE >FROM system.dual >END-SELECT >END-PROCEDURE get_column > > -- ------------------------------------------------------------------------------ Mark Johnson markjo@ix.netcom.com Ray Ontko & Co. (415)397-7152 Have a nice day. From markjo@netcom.com Sat Apr 1 00:26:29 1995 Date: Mon, 27 Feb 1995 11:56:42 -0700 From: jefff@sun4.miti.com Subject: 3rd Party Books For SQR Does or has anyone heard of any 3rd Party Books for SQR. I know I heard a couple of guys were thinking of writing one, but I don't think it ever materialized. I would appreciate all feedback. Jeff Fishman Regional Manager MITI jefff@miti.com 800/366-6484 ext. 1227 From markjo@netcom.com Sat Apr 1 00:26:53 1995 Date: Mon, 27 Feb 1995 15:14:21 -0700 From: garyj@sun4.miti.com Subject: Re: 3rd Party Books For SQR Off-hand, I don't recall ever seeing one in print, Jeff. Have you tapped Kirsten's brain for possibilities? --- gary ______________________________ Reply Separator _________________________________ Subject: 3rd Party Books For SQR Author: usa.net!sqr-users@netcomsv.netcom.com at Internet Date: 2/27/95 11:32 AM Does or has anyone heard of any 3rd Party Books for SQR. I know I heard a couple of guys were thinking of writing one, but I don't think it ever materialized. I would appreciate all feedback. Jeff Fishman Regional Manager MITI jefff@miti.com 800/366-6484 ext. 1227 From markjo@netcom.com Sat Apr 1 00:28:04 1995 Date: Mon, 27 Feb 1995 15:24:43 -0700 From: Gillam Ahn Subject: Re: 3rd Party Books For SQR PeopleSoft,Inc(Walnut Creek, CA) published SQL/SQR training/user guide for their customers. regards, Gillam Ahn From markjo@netcom.com Sat Apr 1 00:29:46 1995 Date: Mon, 27 Feb 1995 19:05:16 -0700 From: KINGD@randb.abbott.com Subject: Trouble with rownum in where clause I am receiving this error when rownum is used in a where clause. (sqr 5528) ORACLE OPEN error 600 in cursor 1: ORA-00600: internal error code, arguments: [12401], [], [], [], [], The version of SQR is 2.5.7 on Oracle V7.0.16 This error is not listed in the sqr manual. The code goes basically like this: begin-report do my_proc end-report begin-procedure my_proc begin-select val1 val2 val3 from table where rownum < 10 end-select end-procedure Thanks, David ---------------------------------------------------------------------------- KINGD@RANDD.ABBOTT.COM David R. King Abbott Laboratories Inc. Research Computing Time is a train that changes future to past.... ----------------------------------------------------------------------------- From markjo@netcom.com Sat Apr 1 00:29:51 1995 Date: Tue, 28 Feb 1995 08:20:18 -0700 From: Gillam Ahn Subject: Re: Trouble with rownum in where clause I don't see anything wrong with the syntax of 'my_proc' including "rownum<10". Perhaps, something wrong with the table itself ? You may find out more information about the problem from the alert file. regards, Gillam Ahn From markjo@netcom.com Sat Apr 1 00:29:59 1995 Date: Tue, 28 Feb 1995 09:11:01 -0700 From: Nick Moscaritolo x2542 Subject: Re: Trouble with rownum in where clause You might look at 2 possibilities: 1. The FROM clause should be up against the LEFT hand column (I think ????) 2. If the FROM clause is a join, then you must define specifically which TABLE.ROWNUM Good Luck NICK MOSCARITOLO Bentley College From markjo@netcom.com Sat Apr 1 00:32:06 1995 Date: Wed, 1 Mar 1995 19:47:04 -0700 From: gadiy@sun4.miti.com Subject: Re: Trouble with rownum in where clause David, As you may know, ORA-00600 is an error generated by the ORACLE RDBMS. This particular error is an internal ORACLE error. I would try the following: 1. Run the same query from SQL*Plus or SQL*DBA to see if you get the same error. If you do, pursue with ORACLE support. 2. Try, if possible, to test the same with another database (if there is one) or using another SQL*Net driver. 3. Re-link SQR. This is a process of rebuilding the SQR executable by linking with the ORACLE libraries. It is explain in the installation guide. You can call out Tech Support for help on this one. In any case, if the problem persists, please open a case with out technical support. You can do so by e-mail to sqrgroup@miti.com Gadi Yedwab MITI ______________________________ Reply Separator _________________________________ Subject: Trouble with rownum in where clause Author: usa.net!sqr-users@netcomsv.netcom.com at Internet Date: 2/27/95 6:33 PM I am receiving this error when rownum is used in a where clause. (sqr 5528) ORACLE OPEN error 600 in cursor 1: ORA-00600: internal error code, arguments: [12401], [], [], [], [], The version of SQR is 2.5.7 on Oracle V7.0.16 This error is not listed in the sqr manual. The code goes basically like this: begin-report do my_proc end-report begin-procedure my_proc begin-select val1 val2 val3 from table where rownum < 10 end-select end-procedure Thanks, David ---------------------------------------------------------------------------- KINGD@RANDD.ABBOTT.COM David R. King Abbott Laboratories Inc. Research Computing Time is a train that changes future to past.... ----------------------------------------------------------------------------- From markjo@netcom.com Sat Apr 1 00:32:18 1995 Date: Thu, 2 Mar 1995 19:57:10 -0700 From: Edward Forman Subject: SQR Version 2.5.7 on DEC AXP Platform My organization just moved from a DEC VAX to a DEC AXP platform. I've just discovered that while the LTRIM function works as before, the RTRIM function does NOT! The following is a test of some code that is used to see if a character string is a potential social security number (contains all numbers). On the VAX the LTRIM and RTRIM lines would both be blank. On the AXP the results are different. Has anyone else esperienced this? Ed Forman SUNY College at Oneonta FORMANEL@ONEONTA.EDU Test Results: [FORMANEL]>ty test.sqr ! Program to test editing in MOVEs begin-report do test_it end-report begin-procedure test_it let $str1 = '123456789' let $str2 = ltrim($str1,'0123456789') let $str3 = rtrim($str1,'0123456789') let $msg1 = 'Original String: ' || $str1 let $msg2 = 'LTRIMed String: ' || $str2 let $msg3 = 'RTRIMed String: ' || $str3 <==== Should result in a null string display $msg1 display $msg2 display $msg3 end-procedure [FORMANEL]>sqr test -xl a/b SQR: Structured Query Report Writer V2.5.7 Copyright (C) MITI, 1994. All Worldwide Rights Reserved. Original String: 123456789 LTRIMed String: RTRIMed String: 123456789 <==== But doesn't SQR: End of Run. From markjo@netcom.com Sat Apr 1 00:32:42 1995 Date: Sat, 4 Mar 1995 01:37:15 -0700 From: peteh@amgen.com (Peter Hill) Subject: Re: SQR Version 2.5.7 on DEC AXP Platform I tried this on our installation of SQR: SQR V2.4.1 on SunOS 4.1.3 I got exactly the same result as you. Reading the manual I thought it should return a null string too, looks like the manual's wrong... Pete Hill Amgen Ltd From markjo@netcom.com Sat Apr 1 00:33:07 1995 Date: Sat, 4 Mar 1995 01:43:19 -0700 From: PAULDP@SFITVA.CC.FITSUNY.EDU Subject: SQR 2.57 After migration to the Dec Alpha machine under banner 7.1.3, we encountered a number of problems here at FIT when running SQR's that had been working previously: 1. When using a date substitution variable in the "where clause" of select statements, it had to be enclosed with a set of quotation marks. When running this under 7.1.3, an error message was received "a non numeric character was found where a numeric was expected". This was fixed when we took off the quotes. For example, instead of ''''||$date||''', we are now using $date. 2. An "include" file that had always been working fine was creating error messages. We moved the "include" statement to an arbitrary different place in the SQR and it worked. Sorry we can't be more specific, but we don't have a better handle of this. If anyone can give us more information, it would be greatly appreciated.. 3. When using an outerjoin in a "where clause" in conjunction with an "or" operator, the select statement fails . Example: SPRIDEN_PIDM = SPRADDR_PIDM (+) OR... is now not functioning. This is a change in ORACLE 7. 4. When selecting out the same column twice in the same select clause, we got an error 'Ambiguous columns..' This appears to happen when the select clause is large. We don't hit the error if there are only a few fields in the clause. Except for #3 which we know is an Oracle 7 "feature", we don't know if these problems will be encountered on other platforms or operating systems. ELLEN MEDINS INTERNET ADDRESS ELLEN@SFITVA.CC.FITSUNY.EDU Diane Paul Fashion Institute of Technology INTERNET ADDRESS PAULDP@SFITVA.CC.FITSUNY.EDU 212-760-7854 From markjo@netcom.com Sat Apr 1 00:33:13 1995 Date: Sat, 4 Mar 1995 01:49:50 -0700 From: KINGD@randb.abbott.com Subject: Re: SQR version 2.5.7 on DEC AXP Platform Ed, RTRIM in SQR V2.5.7 works the way RTRIM works in SQL. Try these selects in SQL. Select ltrim('12345','123') from dual; RETURN VALUE: 45 Select rtrim('12345','123') from dual; RETURN VALUE: 12345 No try this: Select rtrim('12345','543') from dual; RETURN VALUE: 12 Since you are trying to RTRIM(X,Y) it is reading X from right to left and reading Y from left to right searching for matches until Y is no longer found in X. Thusly your RTRIM('123456789','123456789') is not working 9 in X does not match 1 in Y and so on. For this to work you need RTRIM('123456789','987654321'). Hope this helped a little. David ---------------------------------------------------------------------------- KINGD@RANDD.ABBOTT.COM David R. King Abbott Laboratories Inc. Research Computing Time is a train that changes future to past.... ----------------------------------------------------------------------------- From markjo@netcom.com Sat Apr 1 00:33:26 1995 Date: Sat, 4 Mar 1995 01:54:58 -0700 From: Dawn Dennis <76105.3147@compuserve.com> Subject: Median I am trying to get the median of a list of numbers. Does anybody have an SQR routine to do this? From markjo@netcom.com Sat Apr 1 00:33:30 1995 Date: Sat, 4 Mar 1995 02:00:18 -0700 From: gadiy@sun4.miti.com Subject: Re: SQR Version 2.5.7 on DEC AXP Platform Ed, The problem that you are reporting has been fixed in SQR Version 3. SQR Version 3 is already available on several platforms and should be available on Open VMS within the next couple of months. Gadi Yedwab MITI ______________________________ Reply Separator _________________________________ Subject: SQR Version 2.5.7 on DEC AXP Platform Author: usa.net!sqr-users@netcomsv.netcom.com at Internet Date: 3/2/95 7:32 PM My organization just moved from a DEC VAX to a DEC AXP platform. I've just discovered that while the LTRIM function works as before, the RTRIM function does NOT! The following is a test of some code that is used to see if a character string is a potential social security number (contains all numbers). On the VAX the LTRIM and RTRIM lines would both be blank. On the AXP the results are different. Has anyone else esperienced this? Ed Forman SUNY College at Oneonta FORMANEL@ONEONTA.EDU Test Results: [FORMANEL]>ty test.sqr ! Program to test editing in MOVEs begin-report do test_it end-report begin-procedure test_it let $str1 = '123456789' let $str2 = ltrim($str1,'0123456789') let $str3 = rtrim($str1,'0123456789') let $msg1 = 'Original String: ' || $str1 let $msg2 = 'LTRIMed String: ' || $str2 let $msg3 = 'RTRIMed String: ' || $str3 <==== Should result in a null string display $msg1 display $msg2 display $msg3 end-procedure [FORMANEL]>sqr test -xl a/b SQR: Structured Query Report Writer V2.5.7 Copyright (C) MITI, 1994. All Worldwide Rights Reserved. Original String: 123456789 LTRIMed String: RTRIMed String: 123456789 <==== But doesn't SQR: End of Run. From markjo@netcom.com Sat Apr 1 00:33:35 1995 Date: Sat, 4 Mar 1995 13:25:26 -0700 From: iroyle@cix.compulink.co.uk (Ian Royle) Subject: Re: SQR Version 2.5.7 on DEC AXP Platform In-Reply-To: <9502037942.AA794271236@mailbridge.miti.com> Can you tell me which platforms SQR 3 is out on & what the expected dates are on the remaining ones. Thanks Ian Royle -------- Original Message -------- Ed, The problem that you are reporting has been fixed in SQR Version 3. SQR Version 3 is already available on several platforms and should be available on Open VMS within the next couple of months. Gadi Yedwab MITI From markjo@netcom.com Sat Apr 1 00:33:39 1995 Date: Mon, 6 Mar 1995 06:44:08 -0700 From: Edward Forman Subject: Re: SQR version 2.5.7 on DEC AXP Platform David, The code I sent worked just fine in our previous installation. The order of the characters in the 'y' string makes no difference, Winess: SQL> Select rtrim('12345','543') from dual; RT -- 12 SQL> Select rtrim('12345','345') from dual; RT -- 12 The manual says 'until the characters is not in set y'. It aught to (and used to ) work just fine. In SQLPLUS: SQL> select rtrim('123453984756839845','0123456789') from dual; R - Ed Forman Date: Sat, 04 Mar 1995 01:51:36 -0700 From: KINGD@randb.abbott.com Subject: Re: SQR version 2.5.7 on DEC AXP Platform Ed, RTRIM in SQR V2.5.7 works the way RTRIM works in SQL. Try these selects in SQL. Select ltrim('12345','123') from dual; RETURN VALUE: 45 Select rtrim('12345','123') from dual; RETURN VALUE: 12345 No try this: Select rtrim('12345','543') from dual; RETURN VALUE: 12 Since you are trying to RTRIM(X,Y) it is reading X from right to left and reading Y from left to right searching for matches until Y is no longer found in X. Thusly your RTRIM('123456789','123456789') is not working 9 in X does not match 1 in Y and so on. For this to work you need RTRIM('123456789','987654321'). Hope this helped a little. David ---------------------------------------------------------------------------- KINGD@RANDD.ABBOTT.COM David R. King Abbott Laboratories Inc. Research Computing Time is a train that changes future to past.... ----------------------------------------------------------------------------- From markjo@netcom.com Sat Apr 1 00:33:44 1995 Date: Mon, 6 Mar 1995 15:13:31 -0700 From: gadiy@sun4.miti.com Subject: Re: Median I believe that the problem of finding the median is equivalent to the problem of sorting. After you sort, the median is in the middle. SQR does not provide sorting. To sort in SQR there are basically two ways: 1. Write the data to an external file using a WRITE command. Sort the data using the O/S SORT command. This is invoked from SQR with the CALL SYSTEM command. Read the data back in from the external file using the SQR READ command. 2. Store the data into an SQR array. Write a simple array sorting procedure such as bubble sort to sort the array. Gadi Yedwab MITI ______________________________ Reply Separator _________________________________ Subject: Median Author: usa.net!sqr-users@netcomsv.netcom.com at Internet Date: 3/4/95 6:40 AM I am trying to get the median of a list of numbers. Does anybody have an SQR routine to do this? From markjo@netcom.com Sat Apr 1 00:33:54 1995 Date: Mon, 6 Mar 1995 16:07:56 -0700 From: Edward Forman Subject: FWD: Additional bugs(?) in SQR 2.5.7 on DEC AXP I have 2 other items in SQR programs which ran fine on our DEC VAX under Oracle 6 and SQR 2.11 and now act differently on our DEC AXP under Oracle 7 and SQR 2.5.7. 1. Reading data files: I had to remove the ':fixed' clauses in all the 'open' statements in the SQR programs which read normal data files (so called 'flat files') or else each record was read incorrectly. Once this was done all the programs tested so far have worked OK. This is probably platform specific, and the ':fixed' clause had never really been needed for anything we do; it was more documentation than anything else. 2. I have one SQR which has a DEFINE PRINTER and 2 #DEFINE statements in the BEGIN-SETUP paragraph. The SQR compilation produced error messages dealing with the variable in the second #DEFINE statement. I tried reversing the two #DEFINE statements and got similar results. I solved the problem by placing the DEFINE PRINTER statement after the #DEFINE statements. Original code: BEGIN-SETUP declare printer BEFORE-BOLD =<27>[1m AFTER-BOLD = <27>[22m #define page_length 80 #define page_width 80 page-size {page_length} {page_width} <==== This is line 87 END-SETUP Result: Error messages like Error on line 87: (SQR 4707) No value found for substitution variable: {page_width} {page_width} Error on line 87: (SQR 4102) Bad number found. page-size 80 {page_width} Changed to: BEGIN-SETUP #define page_length 80 #define page_width 80 page-size {page_length} {page_width} declare printer BEFORE-BOLD =<27>[1m AFTER-BOLD = <27>[22m END-SETUP Result: No error messages. I tried to reproduce this error in a small, test program but could not. I just thought people should be alerted. Ed Forman Associate Director, Computer Services SUNY - College at Oneonta FORMANEL@SNYONEVA.CC.ONEONTA.EDU (607)436-2706 From markjo@netcom.com Sat Apr 1 00:34:02 1995 From: Nathan Treadway Subject: recursion in SQR 3? Date: Fri, 10 Mar 1995 11:54:17 +0000 (EST) Does the new version of SQR support recursion with true local variables? Nathan ---------------------------------------------------------------------------- Nathan Treadway | Ray Ontko & Co. | info@ontko.com (auto-reply server) nathant@ontko.com | Richmond, IN | ftp.ontko.com:/users/ontko (anon ftp) From markjo@netcom.com Sat Apr 1 00:34:08 1995 Date: Thu, 23 Mar 1995 04:56:24 -0700 From: Tomoaki.Yamaguchi@ts.ctc.citoh.co.jp Subject: Does SQR Support SYBASE SQL Server 10.x? Hello, Does SQR Ver2.5 support SYBASE SQL Server Version 10.x? I'm using SQR Ver2.5 to SYBASE SQL Server 10.0.1, the following problem occursed. My Probrem --------------------------------------------------------- SQR Script : begin-procedure proc_a let #value = 2 begin-select substring(col, 1, #value) &res1 right(col, #value) &res2 from testdata_table end-select end-procedure : The following error does occur when the execute SQR Script. SQR Error File: cale error during implicit conversion of NUMERIC value '1.2' to a INT field. SQL: select substring(col, 1, 1.2), right(col, 1.2) from string_func_test where 1 = 2 Error on line 37: (SQR 3716) Error in SQL statement. Errors were found in the program file. SQR Command Syntax: % sqr string_func.sqr sa/xxxx -S -Eresult -VSYBASE10 Environment: Platform : SPARC Station IPX OS : SunOS 4.1.3 SQR : Ver2.5 EBF 1989 SYBASE SQL Server 10.0.1 EBF 2753 -------------------------------------------------------------------- If you have any infomation. teach me please. v /u)/u) v Tomoaki Yamaguchi CTC Support Center v (= ''=) ) v E-Mail : Tomoaki.Yamaguchi@ts.ctc.citoh.co.jp v (o o)/ v=========================================================== v O---O v We are seed of The Earth. From markjo@netcom.com Sat Apr 1 00:34:29 1995 Date: Thu, 23 Mar 1995 20:28:16 -0700 From: Raymond Yip Subject: Reply - Does SQR Support SYBASE SQL Server 10.x? >> Does SQR Ver2.5 support SYBASE SQL Server Version 10.x? I'm using SQR Ver2.5 to SYBASE SQL Server 10.0.1, the following problem occursed. My Probrem --------------------------------------------------------- SQR Script : begin-procedure proc_a let #value = 2 begin-select substring(col, 1, #value) &res1 right(col, #value) &res2 from testdata_table end-select end-procedure : The following error does occur when the execute SQR Script. SQR Error File: cale error during implicit conversion of NUMERIC value '1.2' to a INT field. SQL: select substring(col, 1, 1.2), right(col, 1.2) from string_func_test where 1 = 2 Error on line 37: (SQR 3716) Error in SQL statement. Errors were found in the program file. << Hajimemashite When SQR compiles a program, it first validates the syntax of the SQL statement by substituting the SQR variables and adding an always false where clause (where 1 = 2) to it and execute it. The problem is that SQR has only 2 types of variables: string and numeric. When it encounters a numeric variable, it arbitarily substitutes a decimal value for it. When Sybase actually expects an INTEGER, not a DECIMAL, then you will get the above error. The workaround is to force the conversion of the SQR variable to integer. For your problem, you should code: begin-select substring(col, 1, convert(int, #value)) &res1 right(col, convert(int, #value)) &res2 from testdata_table end-select Good luck. Raymond Yip MTRC Hong Kong From markjo@netcom.com Sat Apr 1 00:34:38 1995 Date: Tue, 28 Mar 1995 01:25:36 -0700 From: Tomoaki.Yamaguchi@ts.ctc.citoh.co.jp Subject: Re: Does SQR Support SYBASE SQL Server 10.x? Hello, Thank you for your kind responces. I had settlemented the probrem. Thank you very much. v /u)/u) v Tomoaki Yamaguchi CTC Support Center v (= ''=) ) v E-Mail : Tomoaki.Yamaguchi@ts.ctc.citoh.co.jp v (o o)/ v=========================================================== v O---O v We are seed of The Earth. >Does SQR Ver2.5 support SYBASE SQL Server Version 10.x? > >I'm using SQR Ver2.5 to SYBASE SQL Server 10.0.1, the following problem >occursed. > > My Probrem -------------------------------------------------------- > > SQR Script > : > begin-procedure proc_a > > let #value = 2 > > begin-select > substring(col, 1, #value) &res1 > right(col, #value) &res2 > from testdata_table > end-select > > end-procedure > : > > The following error does occur when the execute SQR Script. > > SQR Error File: > cale error during implicit conversion of NUMERIC value '1.2' > to a INT field. > SQL: select substring(col, 1, 1.2), right(col, 1.2) > from string_func_test > where 1 = 2 > > Error on line 37: > (SQR 3716) Error in SQL statement. > > Errors were found in the program file. > > SQR Command Syntax: > > % sqr string_func.sqr sa/xxxx -S -Eresult -VSYBASE10 > > Environment: > > Platform : SPARC Station IPX > OS : SunOS 4.1.3 > SQR : Ver2.5 EBF 1989 > > SYBASE SQL Server 10.0.1 EBF 2753 > ------------------------------------------------------------------- > >If you have any infomation. teach me please. From markjo@netcom.com Tue Apr 18 11:07:24 1995 Date: Sun, 16 Apr 1995 19:03:38 -0600 From: "Steven R. Roberts" <71204.3676@compuserve.com> Subject: Selecting a batch reporting tool. I am in the process of evaluating batch reporting tools. I am working with Powerbuilder and Oracle on multiple platforms (dos and unix). I am looking for any information that may help in the selection process. The two front runners are Oracle Reports and SQR. I would appreciate any information that may help me in making my decision. My three areas of concern are 1) Portability, 2) Ease of coding and maintianing, and 3) runtimes. Thanks. Steve Roberts From markjo@netcom.com Tue Apr 18 11:07:29 1995 Date: Mon, 17 Apr 1995 07:14:37 -0600 From: hoffma@rpi.edu (Adam Hoffman) Subject: Re: Selecting a batch reporting tool. I have been working with SQR for several years and find it to be an excellent product both for report development and system process development since you can embed DDL and DML into it. To address your areas of concern: 1. With version 3.0 of the SQR Workbench, compiled reports are portable across multiple platforms without having to re-compile. I use SQR on UNIX but I know they support several other platforms. You can contact MITI for further information. 2. For a developer with SQL and 3GL experience, programming with SQR is very easy and powerful. It is a procedure oriented language and comes with many functions to ease development such as array processing, dynamic variables etc.. SQR Workbench comes with Easy SQR, which is more geared towards end-user development. 3. As stated in point 1, you can compile SQR routines and purchase seperate runtime licenses for your various machines. I have not used ORACLE Reports but have not heard great things about it. I hope this helps. >I am in the process of evaluating batch reporting tools. I am working >with Powerbuilder and Oracle on multiple platforms (dos and unix). I am >looking for any information that may help in the selection process. The >two front runners are Oracle Reports and SQR. I would appreciate any >information that may help me in making my decision. My three areas of >concern are 1) Portability, 2) Ease of coding and maintianing, and 3) >runtimes. Thanks. > >Steve Roberts > > > Adam Hoffman Consultant Still-Life With Systems Inc. RPI Phone: (518) 276-3095 RPI Email: hoffma@rpi.edu From markjo@netcom.com Tue Apr 18 11:07:35 1995 Date: Mon, 17 Apr 1995 08:25:20 -0600 From: Howard Nelson <76543.2321@compuserve.com> Subject: Porting SQR to UNIX SQR user, My company has been using SQR for Windows with Sybase for a year the time has come to move some complex reports to run on UNIX (HP-UX). We have a long running task that runs unattended overnight. My SQR report runs in the middle of this, so it is vital that we control how it starts and stops. We have to be able to initiate the report from the client and the overnight process must wait until the report is finished before continuing. Has anybody out there ever done anything like this before? How did you do it? Any comments or suggestions would be appreciated. Howard Nelson Phoenix International From markjo@netcom.com Tue Apr 18 11:07:41 1995 Date: Mon, 17 Apr 1995 09:06:51 -0600 From: marka@sun4.miti.com Subject: Re: Selecting a batch reporting tool. Steve, If you would like to give me a call I can set you up with a 30 day Evaluation of SQR3 Workbench. Here at MITI we have access to many testimonials + user references. Please give me a call I'll be glad to help you learn more about the benefits of using SQR3 Workbench in a client server environment. Mark Abrams 800\366-6484 Ext 1-205 marka@miti.com ______________________________ Reply Separator _________________________________ Subject: Selecting a batch reporting tool. Author: usa.net!sqr-users@netcomsv.netcom.com at Internet Date: 4/16/95 6:35 PM I am in the process of evaluating batch reporting tools. I am working with Powerbuilder and Oracle on multiple platforms (dos and unix). I am looking for any information that may help in the selection process. The two front runners are Oracle Reports and SQR. I would appreciate any information that may help me in making my decision. My three areas of concern are 1) Portability, 2) Ease of coding and maintianing, and 3) runtimes. Thanks. Steve Roberts From markjo@netcom.com Tue Apr 18 11:07:45 1995 Date: Mon, 17 Apr 1995 11:15:00 -0600 From: marka@sun4.miti.com Subject: Re: Porting SQR to UNIX Howard Nelson, PHOENIX INTERNATIONAL If you would like to give me a call I can set you up with a 30 day Evaluation of SQR3 Workbench on your server. Here at MITI we have access to many testimonials + user references. Please give me a call I'll be glad to help you learn more about the benefits of using SQR3 Workbench in a client server environment. Mark Abrams 800\366-6484 Ext 1-205 marka@miti.com ______________________________ Reply Separator _________________________________ Subject: Porting SQR to UNIX Author: usa.net!sqr-users@netcomsv.netcom.com at Internet Date: 4/17/95 7:30 AM SQR user, My company has been using SQR for Windows with Sybase for a year the time has come to move some complex reports to run on UNIX (HP-UX). We have a long running task that runs unattended overnight. My SQR report runs in the middle of this, so it is vital that we control how it starts and stops. We have to be able to initiate the report from the client and the overnight process must wait until the report is finished before continuing. Has anybody out there ever done anything like this before? How did you do it? Any comments or suggestions would be appreciated. Howard Nelson Phoenix International From markjo@netcom.com Tue Apr 18 11:07:52 1995 Date: Mon, 17 Apr 1995 13:51:32 -0600 From: gadiy@sun4.miti.com Subject: Re: Porting SQR to UNIX Howard, Many users use a database table to keep track of report requests. A status field is updated at the end of the report to indicate that it is finished. Another idea -- SQR can fire-off your process -- the one that must wait for the report to finish. Using the "CALL SYSTEM USING" command you can start the overnight process. I'm not sure if I'm hitting the target with these ideas. Perhaps if you'd give some more specifics of how you run these jobs, I could offer more ideas. Gadi Yedwab MITI ______________________________ Reply Separator _________________________________ Subject: Porting SQR to UNIX Author: usa.net!sqr-users@netcomsv.netcom.com at Internet Date: 4/17/95 9:35 AM SQR user, My company has been using SQR for Windows with Sybase for a year the time has come to move some complex reports to run on UNIX (HP-UX). We have a long running task that runs unattended overnight. My SQR report runs in the middle of this, so it is vital that we control how it starts and stops. We have to be able to initiate the report from the client and the overnight process must wait until the report is finished before continuing. Has anybody out there ever done anything like this before? How did you do it? Any comments or suggestions would be appreciated. Howard Nelson Phoenix International From markjo@netcom.com Tue Apr 18 11:07:59 1995 Date: Mon, 17 Apr 1995 15:34:35 -0600 From: Howard Nelson <76543.2321@compuserve.com> Subject: Re: Porting SQR to UNIX Thank you for ALL your comments. I have thought about using a control table to trigger the report as some have suggested, but I am also trying to investigate other possibilities. I have been considering the feasability of using WINSOCK. I have found a few products that access winsock through a very simple API, so I could have status and control sent back to the client instead of having to log everything from UNIX and then rely on the client to get it back. Has anyone had any experience doing something similar to this? Another consideration for me is that we have to copy the output from the UNIX box to the Novell network, so when the report is finished the client must initiate a file transfer. I know there are various means of doing that, by using a FTP bundled with a TCP/IP product, but our marketplace is such that we dont want to be tied to a particular product like that, and WINSOCK is vendor independant. Anyone doing something similar? Thanks again for the help, any more comments would be appreciated. Howard Nelson From markjo@netcom.com Tue Apr 18 11:08:04 1995 Date: Mon, 17 Apr 1995 19:22:30 -0600 From: mreagan@epix.net (Matthew F. Reagan) Subject: Re: Porting SQR to UNIX >We have a long running task that runs unattended overnight. My SQR report runs >in the middle of this, so it is vital that we control how it starts and stops. >We have to be able to initiate the report from the client and the overnight >process must wait until the report is finished before continuing. > >Has anybody out there ever done anything like this before? How did you do it? Howard, We use two different techniques to accomplish this type of task. The first is a quick and dirty (and platform specific) method, while the second is platform independent: 1) Let the SQR program submit the rest of the batch job by using CALL SYSTEM USING. This submits the remaining job to the batch queue. However, this implementation is not easily moved from platform to platform, since each operating system has a different JCL/JPL/DCL/Shell script and batch job invocation. 2) Let the SQR program write a completion mark (update a field in a specific job control table in the database). Another program (on the machine that will run the remaining batch job) checks the job control table and launches the remaining work when the completion mark is present. This method allows the SQR to run on a completely different host than the other program(s) in the batch job. Moving any component in the sequence does not impact any other job, since they are coordinated by the database table (which all can access). Matt... Oh. *THAT'S* what the Signature is...Alas, I have no witty comments. I musta left them back at the office. From markjo@netcom.com Tue Apr 18 11:08:11 1995 Date: Tue, 18 Apr 1995 08:22:32 -0600 From: mike@ascadm1.adams.edu >From mike Tue Apr 18 08:20:30 0600 1995 remote from ascadm1.adams.edu Date: Tue, 18 Apr 1995 08:20:30 -0600 (MDT) From: Mike Henry Subject: Re: Porting SQR to UNIX To: sqr-users@usa.net In-Reply-To: <950417212542_76543.2321_BHT140-1@CompuServe.COM> Message-ID: MIME-Version: 1.0 Received: from ascadm1.adams.edu by ascadm1.adams.edu; Tue, 18 Apr 1995 08:20 MDT Content-Type: TEXT/PLAIN; charset=US-ASCII Content-Length: 1625 Howard, As far as getting your data to the Novell Network I use a FTP server on the Novell server (HellSoft Shareware). I then run bftp on our UNIX machine that schedules file transfers between machines. This FTPD NLM is available on the internet. This seems to work fine. One nice thing about the FTP on NOVELL is that I run one deamon(NLM) on server and that gives me FTP access to all servers. Mike Henry Adams State College Alamosa CO 81102 (719)589-7796 mike@ascadm1.adams.edu On Mon, 17 Apr 1995, Howard Nelson wrote: > Thank you for ALL your comments. > > I have thought about using a control table to trigger the report as some have > suggested, but I am also trying to investigate other possibilities. > > I have been considering the feasability of using WINSOCK. I have found a few > products that access winsock through a very simple API, so I could have status > and control sent back to the client instead of having to log everything from > UNIX and then rely on the client to get it back. > > Has anyone had any experience doing something similar to this? > > Another consideration for me is that we have to copy the output from the UNIX > box to the Novell network, so when the report is finished the client must > initiate a file transfer. I know there are various means of doing that, by > using a FTP bundled with a TCP/IP product, but our marketplace is such that we > dont want to be tied to a particular product like that, and WINSOCK is vendor > independant. Anyone doing something similar? > > Thanks again for the help, any more comments would be appreciated. > > Howard Nelson > > From markjo@netcom.com Sat Apr 22 02:04:47 1995 Date: Thu, 20 Apr 1995 13:14:04 -0600 From: Scott May - SICAS Center - SUNY Oneonta Subject: SQR Array Question. I am having some difficulty with creating procedures to handle my simple array operations, before I even get to the tough ones. I am using the following INSERT procedure(function) for the array. BEGIN-PROCEDURE INSERT_ARRAY(#pidm, $deli_code, $rec_type, #position, :#status) if #position >= {array_size} move 0 to #status else move 1 to #status put #pidm into deli_array(#position) deli_array_pidm put $deli_code into deli_array(#position) deli_array_deli_code put $rec_type into deli_array(#position) deli_array_rec_type get #pidm_1, $deli_code_1, $rec_type_1, $err_flg_1 from deli_array(#positio show (+1,1) #pidm_1 ' ' $deli_code_1 ' ' $rec_type_1 ' ' $err_flg_1 ' - ' # end-if END-PROCEDURE INSERT_ARRAY The array is Global, the procedure is local. Therefore I can not insert into the array. I am using 2.11, 2.27, and 2.42 versions of SQR. How do I tell the procedure that the array I want to insert into is a global array? I can access all other global vars with the $_, #_, and &_. Does some prefix for the array exist? And as a curious side note, why does SQR acknowledge the existence of the array in the local procedure? It doesn't say the array doesn't exist, within the local procedure, eventhough for all uses it doesn't! I would think that if the compiler took the time to decide that the procedure could not insert into the global array that it would be a logical progression to state that it was an error. I have wore the binding out of my programming manual, and could not find any refrences to dealing with arrays on a global/local basis. I have also tried to recreate the array within the local procedure, since it is not seeing the global array, and I get a duplicate array created error, so I know that SQR sees the global array inside the local procedure. Help! Thanks in advance, Scott... ************************************************************ * Programmer / Analyst | Internet: maysa@oneonta.edu * * SICAS Center | SUNY Oneonta * * | Lee Hall * * | Oneonta, NY 13820 * ************************************************************ From markjo@netcom.com Sat Apr 22 02:05:00 1995 Date: Thu, 20 Apr 1995 15:47:25 -0600 From: johng@rmf41.usace.army.mil Subject: Reply to SQR Array Question. > > I am having some difficulty with creating procedures to handle > my simple array operations, before I even get to the tough ones. > > I am using the following INSERT procedure(function) for the array. > > BEGIN-PROCEDURE INSERT_ARRAY(#pidm, $deli_code, $rec_type, #position, :#status) > > if #position >= {array_size} > move 0 to #status > else > move 1 to #status > put #pidm into deli_array(#position) deli_array_pidm > put $deli_code into deli_array(#position) deli_array_deli_code > put $rec_type into deli_array(#position) deli_array_rec_type > get #pidm_1, $deli_code_1, $rec_type_1, $err_flg_1 from deli_array(#positio > show (+1,1) #pidm_1 ' ' $deli_code_1 ' ' $rec_type_1 ' ' $err_flg_1 ' - ' # > end-if > > END-PROCEDURE INSERT_ARRAY > > The array is Global, the procedure is local. Therefore I can not > insert into the array. I am using 2.11, 2.27, and 2.42 versions of SQR. > How do I tell the procedure that the array I want to insert into is > a global array? I can access all other global vars with the $_, #_, and &_. > Does some prefix for the array exist? > > And as a curious side note, why does SQR acknowledge the existence > of the array in the local procedure? It doesn't say the array doesn't exist, > within the local procedure, eventhough for all uses it doesn't! I would > think that if the compiler took the time to decide that the procedure > could not insert into the global array that it would be a logical progression > to state that it was an error. > > I have wore the binding out of my programming manual, and could not > find any refrences to dealing with arrays on a global/local basis. I have > also tried to recreate the array within the local procedure, since it is > not seeing the global array, and I get a duplicate array created error, > so I know that SQR sees the global array inside the local procedure. > > Help! > > Thanks in advance, > Scott... > ************************************************************ > * Programmer / Analyst | Internet: maysa@oneonta.edu * > * SICAS Center | SUNY Oneonta * > * | Lee Hall * > * | Oneonta, NY 13820 * > ************************************************************ > Scott, I needed to do the same type of things, ie: global arrays, local procedures to manipulate them, and wrote a small test program to prove the concept before continuing. Since you didn't include all your source code, there may be something you did (or didn't do!?!) in calling the procedures that affected your results. The sample program attached will execute under SQR 2.4.2 and demonstrates: 1) creating a global array 2) inserting into it from a local procedure being passed the array index and data to insert 3) getting and displaying data from the array within a local procedure being passed the array index Hope this helps! ------------------------------------------------------------------------------ John Griffin (205) 890-2401 | A TTTTTTT SSSSS Advanced Technology Systems (ATS), Inc. | A A T S 4801 University Square, Suite 2 | AaaaA T SSSSS Huntsville, AL 35816-3431 | A A T S johng@rmf41.usace.army.mil | A A T SSSSS ------------------------------------------------------------------------------ Body-Part: 2; Text ------------------------------------------------------ begin-report do test-loc-array end-report begin-procedure test-loc-array create-array name=dummy size=10 field=a-field:char move 0 to #i move 'xxx' to $char-str do insert-array($char-str,#i) do display-array(#i) end-procedure begin-procedure insert-array($char-string,#index) put $char-string into dummy(#index) a-field end-procedure begin-procedure display-array(#indx) display #indx 99 get $a-string from dummy(#indx) a-field display 'contents of array ' noline display $a-string end-procedure From markjo@netcom.com Sat Apr 22 02:05:07 1995 Date: Fri, 21 Apr 1995 01:50:01 -0600 From: hans.schermer@PICA.NL Subject: Insert in temporary table Hello, I have been trying to do the following: I want to sort a report by a string value. I first select all the records I want in the report. For every record I 'compute' an associated string in a user defined procedure. I then want to store the record with the associated string in order to sort by the string. Alas, because the insert is nested in the main select loop, SQR has opened another session to the SQL server in which the temporary table is not known. I can not use a permanent table, because the logging could fill up the transaction log in some situations. Any suggestions? Hans Schermer, Pica Library Automation, Leiden, The Netherlands +31-71-257168 hans.schermer@pica.nl From markjo@netcom.com Sat Apr 22 02:05:11 1995 Date: Fri, 21 Apr 1995 03:18:24 -0600 From: iroyle@cix.compulink.co.uk (Ian Royle) Subject: Re: Insert in temporary table In-Reply-To: <9503217984.AA798481891@stoffel.pica.nl> Try using -c1 next to Begin-select & begin-sql i.e. begin-select -c1 & begin-sql -c1. This forces SQR to use the same connection to the server & therefore see the temp table. If you're accessing the temp table in a subquery with begin-select you can't do this though, you would need to restructure your report so this is not the case. Ian Royle From markjo@netcom.com Sat Apr 22 02:05:18 1995 Date: Fri, 21 Apr 1995 06:23:59 -0600 From: Scott May - SICAS Center - SUNY Oneonta Subject: Re: Reply to SQR Array Question. Thanks for your example John. It was very helpful. I went back to a single field, and built it back up one field at a time and it now works. I had an error in one of my gets. I was seperating the get varibles with commas. It never tripped and error, but that was 90% of the problem. I hope someone else can learn from this stupid mistake. The fresh perspective reassured me I was not trying the impossible. Thanks again, Scott... ************************************************************ * Programmer / Analyst | Internet: maysa@oneonta.edu * * SICAS Center | SUNY Oneonta * * | Lee Hall * * F:(607)436-2038 | Oneonta, NY 13820 * ************************************************************ Scott, I needed to do the same type of things, ie: global arrays, local procedures to manipulate them, and wrote a small test program to prove the concept before continuing. Since you didn't include all your source code, there may be something you did (or didn't do!?!) in calling the procedures that affected your results. The sample program attached will execute under SQR 2.4.2 and demonstrates: 1) creating a global array 2) inserting into it from a local procedure being passed the array index and data to insert 3) getting and displaying data from the array within a local procedure being passed the array index Hope this helps! ------------------------------------------------------------------------------ John Griffin (205) 890-2401 | A TTTTTTT SSSSS Advanced Technology Systems (ATS), Inc. | A A T S 4801 University Square, Suite 2 | AaaaA T SSSSS Huntsville, AL 35816-3431 | A A T S johng@rmf41.usace.army.mil | A A T SSSSS ------------------------------------------------------------------------------ Body-Part: 2; Text ------------------------------------------------------ begin-report do test-loc-array end-report begin-procedure test-loc-array create-array name=dummy size=10 field=a-field:char move 0 to #i move 'xxx' to $char-str do insert-array($char-str,#i) do display-array(#i) end-procedure begin-procedure insert-array($char-string,#index) put $char-string into dummy(#index) a-field end-procedure begin-procedure display-array(#indx) display #indx 99 get $a-string from dummy(#indx) a-field display 'contents of array ' noline display $a-string end-procedure From markjo@netcom.com Sat Apr 22 02:05:22 1995 Date: Fri, 21 Apr 1995 07:07:44 -0600 From: Dawn Dennis <76105.3147@compuserve.com> Subject: Good SQR Books Does anybody know of a good book about SQR and where I could get it? I've looked in bookstores but have found nothing. Thanks. From markjo@netcom.com Sat Apr 22 02:05:28 1995 Date: Fri, 21 Apr 1995 10:34:26 -0600 From: jefff@sun4.miti.com Subject: Re: Good SQR Books This question has come up before. I don't think there's a good answer. Lots of SQR programmer have talked about writing some 3rd party book on SQR. I think it would really sell w/i the SQR circle. You might want to call Peoplesoft, they teach their own SQR class w/ materials. They might sell you their book. Good luck, Jeff Fishman Western Region Account Manager jefff@miti.com ______________________________ Reply Separator _________________________________ Subject: Good SQR Books Author: usa.net!sqr-users@netcomsv.netcom.com at Internet Date: 4/21/95 8:37 AM Does anybody know of a good book about SQR and where I could get it? I've looked in bookstores but have found nothing. Thanks. From markjo@netcom.com Sat Apr 22 02:05:35 1995 Date: Fri, 21 Apr 1995 11:36:11 -0600 From: ayudante@netcom.com (Para Siempre Ayudar) Subject: Re: Good SQR Books > > This question has come up before. I don't think there's a good > answer. Lots of SQR programmer have talked about writing some 3rd no offense, but I think you'd make MITI look a bit stronger if you ran a spell check at least on what you send out. I assume you mean 'programmers' here. > party book on SQR. I think it would really sell w/i the SQR circle. > You might want to call Peoplesoft, they teach their own SQR class w/ > materials. They might sell you their book. don't you people have a teaching or training group? if you do, the training materials they use should be helpful too I'd guess. of course, if you like giving free ad space to PeopleSoft, your option. > > Good luck, > > Jeff Fishman > Western Region > Account Manager > jefff@miti.com -- _______________________________________________________________________________ Helper ayudante@netcom.com NETCOM, the West Coast's Leading Internet Service Provider. (408) 554-8649 From markjo@netcom.com Sat Apr 22 02:05:38 1995 Date: Fri, 21 Apr 1995 13:17:15 -0600 From: gadiy@sun4.miti.com Subject: Re: Good SQR Books MITI is completing a Language Tutorial for SQR3. It's an excellent book for learning SQR programming. The intention is to make it available as soon as it's ready. I expect this should happen before the summer or very early in the summer. Gadi Yedwab gadi@miti.com MITI ______________________________ Reply Separator _________________________________ Subject: Good SQR Books Author: usa.net!sqr-users@netcomsv.netcom.com at Internet Date: 4/21/95 8:37 AM Does anybody know of a good book about SQR and where I could get it? I've looked in bookstores but have found nothing. Thanks. From markjo@netcom.com Sat Apr 22 02:05:42 1995 Date: Fri, 21 Apr 1995 14:18:24 -0600 From: Terry Davlin Subject: Re: Good SQR Books Don't bother contacting Peoplesoft. I tried this, and they do not sell their materials. You can get them by going to class. -- Terry Davlin terryd@medianet.com Database & Systems Director MEDIANET, Inc. P.O. Box 203218 Voice: (512) 343-2002 Austin, Texas 78720-3218 Fax: (512) 343-1717 On Fri, 21 Apr 1995 jefff@sun4.miti.com wrote: > This question has come up before. I don't think there's a good > answer. Lots of SQR programmer have talked about writing some 3rd > party book on SQR. I think it would really sell w/i the SQR circle. > You might want to call Peoplesoft, they teach their own SQR class w/ > materials. They might sell you their book. > > Good luck, > > Jeff Fishman > Western Region > Account Manager > jefff@miti.com > > > ______________________________ Reply Separator _________________________________ > Subject: Good SQR Books > Author: usa.net!sqr-users@netcomsv.netcom.com at Internet > Date: 4/21/95 8:37 AM > > > Does anybody know of a good book about SQR and where I could get it? I've > looked in bookstores but have found nothing. Thanks. > > From markjo@netcom.com Sat Apr 22 02:05:46 1995 Date: Fri, 21 Apr 1995 15:53:41 -0600 From: Scott May - SICAS Center - SUNY Oneonta Subject: SQR Bug? - Variable names. I have another question. I found the source of my problem with the array. It is not an array problem, it was a variable problem. Maybe I am naive in reguards to this, and would appreciate it if someone could clear this up, or explain why. My previous problem was the following get #pidm, $var2, .......... Comma's aren't used in this statement, but no error was generated, and no values returned, or so I though..... (ASSUMED!) show (+1,1) #pidm I get nothing. show (+1,1) #pidm, I get the proper value. I guess I never realized that the SQR compiler doesn't care what the variable name is after the leading symbol. I also can not find in the manual (2.5) that I can have radical names for my variables, which in my opinion is worth noting! Here are a few VALID VARIABLE NAMES that will illustrate my point. #$pidm,1 - valid # var name #pidm,$deli_code - valid # var name #pidm, - valid # var name I understand why this happens, there are no characters that are not allowed in a variable name, and the space is the only delimeter. This can frustrate a programmer beyond belief (person experience). If this fact was mentioned in my original SQR training I have long since forgotten it, and find no OBVIOUS refrence in the manual, to an OBVIOUS problem that can occur without even realizing it. Maybe I'm way out on a limb here, but I use SQL*Plus to develop my larger selects before I integrate them into SQR. I happen to sometimes use a COMMA in these statements. When I go into SQR I accidentially use them without thinking. From markjo@netcom.com Sat Apr 22 02:05:50 1995 Date: Fri, 21 Apr 1995 16:04:04 -0600 From: Scott May - SICAS Center - SUNY Oneonta Subject: SQR BUG? Variable names. - Full Question -------------------------------------------------------------------------------- Apologies to all for accidentially sending the unfinished version, my mouse went out of control, side swiped the send button and ......... -------------------------------------------------------------------------------- I have another question. I found the source of my problem with the array. It is not an array problem, it was a variable problem. Maybe I am naive in reguards to this, and would appreciate it if someone could clear this up, or explain why. My previous problem was the following get #pidm, $var2, .......... Comma's aren't used in this statement, but no error was generated, and no values returned, or so I though..... (ASSUMED!) show (+1,1) #pidm I get nothing. show (+1,1) #pidm, I get the proper value. I guess I never realized that the SQR compiler doesn't care what the variable name is after the leading symbol. I also can not find in the manual (2.5) that I can have radical names for my variables, which in my opinion is worth noting! Here are a few VALID VARIABLE NAMES that will illustrate my point. #$pidm,1 - valid # var name #pidm,$deli_code - valid # var name #pidm, - valid # var name I understand why this happens, there are no characters that are not allowed in a variable name, and the space is the only delimeter. This can frustrate a programmer beyond belief (person experience). If this fact was mentioned in my original SQR training I have long since forgotten it, and find no OBVIOUS refrence in the manual, to an OBVIOUS problem that can occur without even realizing it. Maybe I'm way out on a limb here, but I use SQL*Plus to develop my larger selects before I integrate them into SQR. I happen to sometimes use a COMMA in these statements. When I go into SQR I accidentially use them without thinking. This tends to create problems. Is this an acknowledged bug in SQR, or just a fact of life? Has this been fixed in later versions of SQR? Has anyone else ever had this problem? And not know it? Thanks for you responses and time, Scott... ************************************************************ * Programmer / Analyst | Internet: maysa@oneonta.edu * * SICAS Center | SUNY Oneonta * * | Lee Hall * * | Oneonta, NY 13820 * ************************************************************ From markjo@netcom.com Sat Apr 22 02:05:54 1995 Date: Fri, 21 Apr 1995 20:26:30 -0600 From: gadiy@sun4.miti.com Subject: Re: SQR BUG? Variable names. - Full Question Scott, Thanks very much for all the information. We're looking into the problem of SQR not reporting an error when a comma is used in the variable name. It seems like a bug. I expect by Monday to confirm that it is a bug and provide you with a bug number. Sincerely, Gadi Yedwab MITI ______________________________ Reply Separator _________________________________ Subject: SQR BUG? Variable names. - Full Question Author: usa.net!sqr-users@netcomsv.netcom.com at Internet Date: 4/21/95 3:40 PM -------------------------------------------------------------------------------- Apologies to all for accidentially sending the unfinished version, my mouse went out of control, side swiped the send button and ......... -------------------------------------------------------------------------------- I have another question. I found the source of my problem with the array. It is not an array problem, it was a variable problem. Maybe I am naive in reguards to this, and would appreciate it if someone could clear this up, or explain why. My previous problem was the following get #pidm, $var2, .......... Comma's aren't used in this statement, but no error was generated, and no values returned, or so I though..... (ASSUMED!) show (+1,1) #pidm I get nothing. show (+1,1) #pidm, I get the proper value. I guess I never realized that the SQR compiler doesn't care what the variable name is after the leading symbol. I also can not find in the manual (2.5) that I can have radical names for my variables, which in my opinion is worth noting! Here are a few VALID VARIABLE NAMES that will illustrate my point. #$pidm,1 - valid # var name #pidm,$deli_code - valid # var name #pidm, - valid # var name I understand why this happens, there are no characters that are not allowed in a variable name, and the space is the only delimeter. This can frustrate a programmer beyond belief (person experience). If this fact was mentioned in my original SQR training I have long since forgotten it, and find no OBVIOUS refrence in the manual, to an OBVIOUS problem that can occur without even realizing it. Maybe I'm way out on a limb here, but I use SQL*Plus to develop my larger selects before I integrate them into SQR. I happen to sometimes use a COMMA in these statements. When I go into SQR I accidentially use them without thinking. This tends to create problems. Is this an acknowledged bug in SQR, or just a fact of life? Has this been fixed in later versions of SQR? Has anyone else ever had this problem? And not know it? Thanks for you responses and time, Scott... ************************************************************ * Programmer / Analyst | Internet: maysa@oneonta.edu * * SICAS Center | SUNY Oneonta * * | Lee Hall * * | Oneonta, NY 13820 * ************************************************************ From markjo@netcom.com Fri Apr 28 22:39:54 1995 Date: Fri, 28 Apr 1995 14:42:19 -0600 From: "Ray Ontko" Subject: Fw: SQR to PL/SQL2 Does anyone want to take this up? ------------------------------ From: Christopher Larson Thu, 20 Apr 1995 08:52:17 -0500 To: Multiple recipients of list ORACLE-L Subject: SQR to PL/SQL2 Subject: Time: 8:34 AM OFFICE MEMO SQR to PL/SQL2 Date: 4/20/95 Hello all you "Oracle Heads"!! I have a slight problem I am hoping you can help me with. I have recently converted from V6 to V7.1.3.2 on a MIPS ABI system. Along with this we have decided to convert our SQR reports to PL/SQL2. (an attempt to save a little cash!) All these new PL/SQL reports are now running an average of 25% longer than the SQR using the exact same SQL code. It appears once the first page is displayed it runs just fine through the rest. Does the "PL/SQL startup process (so to speak)" have that much overhead?? Has anyone else noticed this? Any suggestions on speeding this up would be of great help!!! Thanks! Chris Larson Oracle DBA, Contol Data Systems Christopher.D.Larson@cdc.com ----------------------------------------------------------------------- Ray Ontko rayo@ontko.com "Ask me about Database Illustrator(tm)" Ray Ontko & Co info@ontko.com ftp.ontko.com:/users/ontko (anon ftp) From markjo@netcom.com Fri Apr 28 22:40:00 1995 Date: Fri, 28 Apr 1995 14:54:16 -0600 From: Aaron Evans Subject: Re: Reply to SQR Array Question. -Reply Hey Scott: If you know a way to get me off this list I would greatly appreciate it if you could clue me in. I thought it was for SQL not SQR what a ding dong. Anyway I just want the E-mails to go away any help would be appreciated. Aaron From markjo@netcom.com Fri Apr 28 22:40:05 1995 Date: Fri, 28 Apr 1995 23:31:27 -0600 From: "Benjamin Le" Subject: Re: Fw: SQR to PL/SQL2 In-Reply-To: ORUNIX:sqr-users@usa.net's message of 04-28-95 14:47 Chris - You may want to change the order a little in SQL code query to make it processes faster. This prompted me a question for you. Why did you convert SQR to PL/SQL2? SQR (my opition) is an excellent report writer. I would prefer to write report programs in SQR other than other languages (my opition again). ***************************************** Ben Le Information Services, (503)-977-4970 Campus E-mail: ble Internet: ble@pcc.edu ***************************************** From markjo@netcom.com Fri Apr 28 23:06:20 1995 Date: Fri, 28 Apr 1995 23:37:20 -0600 From: gadiy@sun4.miti.com Subject: Re[2]: Reply to SQR Array Question. -Reply to subscribe, send "subscribe sqr-users" to "listserv@usa.net" to unsubscribe, send "unsubscribe sqr-users" to "listserv@usa.net" to send to the list, address to "sqr-users@usa.net" ______________________________ Reply Separator _________________________________ Subject: Re: Reply to SQR Array Question. -Reply Author: usa.net!sqr-users@netcomsv.netcom.com at Internet Date: 4/28/95 2:40 PM Hey Scott: If you know a way to get me off this list I would greatly appreciate it if you could clue me in. I thought it was for SQL not SQR what a ding dong. Anyway I just want the E-mails to go away any help would be appreciated. Aaron From markjo@netcom.com Fri Apr 28 23:06:23 1995 Date: Fri, 28 Apr 1995 23:42:43 -0600 From: "Ray Ontko" Subject: Re: Reply to SQR Array Question. -Reply Anyone interested in unsubscribing should send a single line message: UNSUBSCRIBE SQR-USERS to the address: LISTSERV@USA.NET Y'all come back now, y'hear. Ray ----------------------------------------------------------------------- Ray Ontko rayo@ontko.com "Ask me about Database Illustrator(tm)" Ray Ontko & Co info@ontko.com ftp.ontko.com:/users/ontko (anon ftp) From sqr-users@usa.net Thu May 4 10:06:52 1995 Date: Thu, 4 May 1995 06:37:59 -0600 From: Scott May - SICAS Center - SUNY Oneonta Subject: Re: FILE WRITING Are you using one write statement for the whole record, or one write for each field? This can make a big difference. Scott... ************************************************************ * Programmer / Analyst | Internet: maysa@oneonta.edu * * SICAS Center | SUNY Oneonta * ************************************************************ From sqr-users@usa.net Thu May 4 10:07:34 1995 Date: Thu, 4 May 1995 01:36:18 -0600 From: "Brace-Evelyn" Subject: FILE WRITING Does anyone know of any tricks to improve SQR's file writing efficiency? We are writing a very large file 6000 records of 1960 bytes each and it takes quite a while. We were wondering if there are any ways to make the i/o faster. We are running version 2.5 on a VAX midrange. From sqr-users@usa.net Thu May 4 22:57:03 1995 Date: Thu, 4 May 1995 15:23:17 -0600 From: "Brace-Evelyn" Subject: SQR vs C Has anyone done any benchmarking between SQR programs and C programs? We have gotten varying results and pretty much concluded the following: C is faster when there are numerous and complicated calculations. SQR is faster when there is file i/o. More people in our area are familiar with SQR and therefore for us development time is shorter and maintenance easier. Has anyone gotten different results or in other areas? From sqr-users@usa.net Thu May 4 22:57:43 1995 Date: Thu, 4 May 1995 12:14:46 -0600 From: "Brace-Evelyn" Subject: RE: FILE WRITING Thanks, we did have an index problem. _______________________________________________________________________________ From: UNIX.SQRUSERS on Thu, May 4, 1995 11:52 AM Subject: Re: FILE WRITING To: Brace-Evelyn Be sure to check your queries as it may be your selects from tables that are performing poorly. We write to/read from files often and find few problems. Nick Moscaritolo Bentley College From sqr-users@usa.net Thu May 4 22:58:41 1995 Date: Thu, 4 May 1995 09:44:29 -0600 From: Nick Moscaritolo x2542 Subject: Re: FILE WRITING Be sure to check your queries as it may be your selects from tables that are performing poorly. We write to/read from files often and find few problems. Nick Moscaritolo Bentley College From sqr-users@usa.net Fri May 5 13:19:13 1995 Date: Fri, 5 May 1995 11:43:55 -0600 From: garyj@sun4.miti.com Subject: Re: SQR vs C Benchmarking SQR vs. C (and other entities) is one project that is hot on my list. I have not started our full-scale benchmarking yet, but I would be interested in any test results that you all have done, as well as any ideas you may have (whether you've done any benchmarking or not) regarding test conditions, constraints, categorizing of benchmarks, etc. We (MITI) realize that such experiments are useful to our customers and provide valuable insight as to future product development and product direction, ensuring that SQR is not only driven to leading edge, but continues to meet your needs. I will be most happy to summarize any benchmark findings past, present, or future. Please feel free to send your ideas/results etc. to us via the sqr-users list or to me directly. aTdHvAaNnKcSe --- gary jerep (garyj@miti.com) --- systems consultant --- MITI's Technology Transfer Group ______________________________ Reply Separator _________________________________ Subject: SQR vs C Author: usa.net!sqr-users@netcomsv.netcom.com at Internet Date: 5/4/95 2:40 PM Has anyone done any benchmarking between SQR programs and C programs? We have gotten varying results and pretty much concluded the following: C is faster when there are numerous and complicated calculations. SQR is faster when there is file i/o. More people in our area are familiar with SQR and therefore for us development time is shorter and maintenance easier. Has anyone gotten different results or in other areas? From markjo@netcom.com Thu May 25 11:46:49 1995 Date: Tue, 2 May 1995 07:18:37 -0600 From: Nick Moscaritolo x2542 Subject: Re: Lookup Table Problem Catherine, I believe DUPLICATE KEYS means that your "SQL" in the LOAD-LOOKUP command returns rows that contains DUPLICATES in the KEY column(s). Check your SQL and insure that in brings back DISTINCT rows. Nick MOscaritolo Bentley College From markjo@netcom.com Thu May 25 12:33:22 1995 Date: Mon, 8 May 1995 09:29:55 -0600 From: "Benjamin Le" Subject: SQR This message is for Mark Johnson: In your reply to Catherine Cleveline, you mentioned about new release of SQR which is very stable and include additional functionality. Which release you are talking about? SQR 2.3.4; 2.5.7; 3.0.0? Thanks for verifying. ________________________________________________ Benjamin Le Portland Community College Computer Information Technology, (503)-977-4970 Campus E-mail: ble - Internet: ble@pcc.edu ------------------------------------------------ From markjo@netcom.com Thu May 25 12:33:32 1995 Date: Mon, 8 May 1995 11:29:47 -0600 From: "Young" Subject: SQR/SQRW and Windows NT We are having a problem printing with SQR/SQRW (2.5) and Windows NT Workstation (3.5). Here is the scenario: Novell network (3.11), and a workstation that has LPT1 captured to a network print queue. We call SQRW from Windows and specify the -F parameter to be '-Fprn' to print directly to the PRN device. Under Windows 3.1, this works fine, but using Windows NT, it has various problems. The first print job sent to the printer doesn't come-out, and when you tell it to print a second time, it print, but the print output is screwed-up (body of the report prints first, followed by a page with the headings). Any ideas/suggestions? We've thought of upgrading the SQR/SQRW 3.0, but wanted to see if we could resolve first. Thanks. Wally MicroSim Corporation From markjo@netcom.com Thu May 25 12:33:37 1995 Date: Mon, 8 May 1995 19:34:26 -0600 From: Howard Nelson <76543.2321@compuserve.com> Subject: SQR/SQRW and Windows NT Wally, and other SQR Users: Its OK to send output to LPT1 under DOS but Windows isn't designed to do that. Windows has a device independant architecture which means that it provides a driver for each device. Each program then talks to the device through its API. So by using LPT1 you are actually circumventing the driver. You can probably get away with this for a while on Windows 3.1 but eventually you will run into problems. With our SQR reports we are creating a file using -F switch and once the report is finished then call NPRINT (a Novell utility) to send it to the printer. We like this because we can archive the file on an optical disk. NPRINT is very fast at spooling so its not a great sacrifice of performance. SQR 3.0 has a new switch on the command line, -PRINTER:WP, which uses the default Window Print Driver to produce the output. You may prefer this. I have been testing SQR 3.0 and I am very pleased with it. I have also tried running it on Windows 95 and I have found very few problems. I hope this helps. Howard Nelson Phoenix International ----------------------- We are having a problem printing with SQR/SQRW (2.5) and Windows NT Workstation (3.5). Here is the scenario: Novell network (3.11), and a workstation that has LPT1 captured to a network print queue. We call SQRW from Windows and specify the -F parameter to be '-Fprn' to print directly to the PRN device. Under Windows 3.1, this works fine, but using Windows NT, it has various problems. The first print job sent to the printer doesn't come-out, and when you tell it to print a second time, it print, but the print output is screwed-up (body of the report prints first, followed by a page with the headings). Any ideas/suggestions? We've thought of upgrading the SQR/SQRW 3.0, but wanted to see if we could resolve first. From markjo@netcom.com Thu May 25 12:33:47 1995 Date: Mon, 8 May 1995 20:00:50 -0600 From: mreagan@fast.net (Matthew F. Reagan) Subject: Re: SQR >This message is for Mark Johnson: >In your reply to Catherine Cleveline, you mentioned about new release of SQR >which is very stable and include additional functionality. Which release you >are talking about? SQR 2.3.4; 2.5.7; 3.0.0? Thanks for verifying. Benjamin, Mark was (I'm pretty sure) referring to SQR V 3, which is available on a number of platforms (and more are being added each week). I have had a chance to play with it and believe it to be stable. I only crashed it once, and that was on a pre-release version. Would you believe, at the East Coast Oracle conference last week, I loaded Oracle7 for Windows and SQR3 for Windows on a 486 laptop (33mhz) with 12 meg of memory and 100 meg of free disk. It took about 2 hours (and 1 beer) once I got the PCMCIA SCSI card in and hooked up the SCSI CD Rom drive, and most of that (1 3/4 hours) was the Oracle7 installation. Ran like a dream. Did everything I asked of it, and then some. I was in heaven. Then I had to give the laptop back, and returned to my hand-me-down 286 laptop. Sniff, sniff. Matt... Oh. *THAT'S* what the Signature is...Alas, I have no witty comments. I musta left them back at the office. From markjo@netcom.com Thu May 25 12:39:44 1995 Date: Thu, 18 May 1995 21:17:39 -0600 From: mreagan@fast.net (Matthew F. Reagan) Subject: Re: Preview of SQR reports >Does anybody know if there is any software or method in Windows to >preview SQR reports that were created for HP LaserJet printers in a >WYSWYG manner? Raymond, Using SQR3, it is possible to create a .SPF file, which is a printer independent file. Then, using SQRViewer, you can view the report file in almost WYSIWYG format. I say almost, because there are a few items that you cannot view under Windows. I don't recall all of them, but barcodes are one, EPS files are another. SQRPrint can be used to print the SPF file to the output device of your choice, including HPLaserJets (subject to font and memory requirements of course). Under 2.x versions of SQR, I never could find a solution to view HPLaserJet output files in WYSIWYG. Matt... From markjo@netcom.com Thu May 25 12:39:49 1995 Date: Thu, 18 May 1995 22:16:00 -0600 From: Raymond Yip Subject: Re: Preview of SQR reports -Reply >> Using SQR3, it is possible to create a .SPF file, which is a printer independent file. Then, using SQRViewer, you can view the report file in almost WYSIWYG format. I say almost, because there are a few items that you cannot view under Windows. I don't recall all of them, but barcodes are one, EPS files are another. SQRPrint can be used to print the SPF file to the output device of your choice, including HPLaserJets (subject to font and memory requirements of course). Under 2.x versions of SQR, I never could find a solution to view HPLaserJet output files in WYSIWYG. << Matthew, Thanks for your reply. I want to know more about SQR3. Is SPF file platform independent, i.e, if I can create it under HP-UX and view it under Windows? Is SQR3 availbale now in HP-UX and Windows? Raymond From markjo@netcom.com Thu May 25 12:39:53 1995 Date: Fri, 19 May 1995 09:28:44 -0600 From: mreagan@fast.net (Matthew F. Reagan) Subject: Re: Preview of SQR reports -Reply > >Thanks for your reply. I want to know more about SQR3. Is SPF file >platform independent, i.e, if I can create it under HP-UX and view it under >Windows? Yes. It is completely transportable. The SPF file is standard ASCII, so it can be e-mailed to the destination site as a normal attachment (even throuh x.400 or the internet). The viewer is only available under Windows (I believe) at this time. >Is SQR3 availbale now in HP-UX and Windows? Yes, under HP-UX V 9.05. Oh. *THAT'S* what the Signature is...Alas, I have no witty comments. I musta left them back at the office. From markjo@netcom.com Thu May 25 12:40:23 1995 Date: Fri, 19 May 1995 11:40:29 -0600 From: gadiy@sun4.miti.com Subject: Re[2]: Preview of SQR reports -Reply Raymond, 1. Yes, SPF is platform independent. 2. Yes, you can create output in SPF format on the HP-UX. 3. Yes, SQR3 is now available for HP-UX and Windows. The following text is taken from the SQR3 User's Guide: SQR allows you to create a printer-independent output file. Even if your report has a variety of fonts and graphics, you can print the report on a number of different printers. When you choose printer-independent output, SQR creates a file in SPF (SQR Portable Output File) format. The default extension for this type of file is .SPF instead of the usual .LIS extension. You gain a good deal of flexibility by using SPF files: You can run a report and postpone the decision of printer type until print time. For example, you can distribute the SPF file electronically without knowing the type of printer that each recipient has. The recipients of the report can use the SQRP program (described below) to print on their printers. You can use a PostScript viewer to preview the output of your report even if the report is designed for an HP printer. You do this by creating an SPF file, rendering PostScript for viewing, and rendering HP LaserJet (PCL) for printing. You can view, search, or E-mail the text portions of a graphic output by rendering a line-printer output. You can separate the printing from the report execution. For example, you might want to run the report on the database server computer and then print it on another computer (the print server computer). The overhead associated with producing the graphics will be shifted to the other computer. SPF Files and SQR for Windows Since SPF files can be produced by SQR on any platform, you can take advantage of the Windows printing capabilities even though you created the SQR report on another platform. For example, you can run a report on a UNIX server and then print the output on a PC using Windows. When you direct SQR for Windows to print using Windows printer drivers, there is normally no output file created. The output goes directly to the printer. If you use the -KEEP flag, SQR will save the output as an SPF file. This allows you to view and re-print the report on Windows. Requesting an SPF file To create an SPF file, use the -KEEP or -NOLIS command line flag. With the -KEEP flag you can generate a printer-specific output file (a .LIS file) and keep the SPF file as well. With -NOLIS you will create only SPF files. If you do not care to have the SPF file, do not specify these command line flags. SQR will create the printer-specific output directly. The SQR Print (SQRP) program Once you have created the SPF file you are ready to prepare it for printing. The SQRP program renders the printer-specific language such as PostScript or PCL. For line printers, SQRP will filter out the graphics. Viewing SPF files To view the SPF file on UNIX you can use SQRP to create line-printer or PostScript output. The PostScript output may be viewed using a PostScript viewer. To view the SPF file on Windows, use the SQR Viewer. Gadi Yedwab, MITI ______________________________ Reply Separator _________________________________ Subject: Re: Preview of SQR reports -Reply Author: usa.net!sqr-users@netcomsv.netcom.com at Internet Date: 5/19/95 8:44 AM >> Using SQR3, it is possible to create a .SPF file, which is a printer independent file. Then, using SQRViewer, you can view the report file in almost WYSIWYG format. I say almost, because there are a few items that you cannot view under Windows. I don't recall all of them, but barcodes are one, EPS files are another. SQRPrint can be used to print the SPF file to the output device of your choice, including HPLaserJets (subject to font and memory requirements of course). Under 2.x versions of SQR, I never could find a solution to view HPLaserJet output files in WYSIWYG. << Matthew, Thanks for your reply. I want to know more about SQR3. Is SPF file platform independent, i.e, if I can create it under HP-UX and view it under Windows? Is SQR3 availbale now in HP-UX and Windows? Raymond From sqr-users@usa.net Thu Jun 8 16:30:24 1995 Date: Thu, 8 Jun 1995 15:22:00 -0600 From: CASAVANTK@randb.pprd.abbott.com Subject: Numeric Var Comparisons We are running SQR 2.5.7 on Oracle 7.0.16.4.0 on a VAX. When trying to compare some calculated values against stored values in our database and flag the ones that were different, SQR was flagging values that were the same. SQR was not consistent in doing this though. For example, sometimes it would flag #calc = 345.89 as different from #database = 345.89, and other times it would say it was the same. It did however always catch the incorrect values. Below is a little sample program that I just created to see if it was SQR or me that was messing up. When the program is run it flags them as NOT EQUAL. If I put a TRUNC(#val,3) around each variable in the IF statement then it catches them as EQUAL. But this is not the case in the actual code that runs against ORACLE. What's up with this? Any help or suggestions on where to go would be greatly appreciated. Thanks, Kay BEGIN-REPORT let #database = 45.321 do q END-REPORT begin-procedure q let #calc = 145.321 - 100.000 display 'database ' noline show #database edit 99999.9999999 display 'cacl ' noline show #calc edit 99999.9999999 if trunc(#database,3) != trunc(#calc,3) display 'NOT EQUAL' else display 'EQUAL' end-if end-procedure From markjo@netcom.com Thu Jun 8 21:01:23 1995 Date: Wed, 31 May 1995 11:08:50 -0600 From: Michael K. Hamian <75467.3377@compuserve.com> Subject: 'sqrt' versus 'sqr -rt' We just purchased sqr workbench 2.5.7 on HP 9000. I have the following question to everyone: Is 'sqrt program_name' the same as 'sqr program_name -rt' ? If yes, which one is more efficient to use and why? If not, what is the difference? Any responses will greatly be appreciated. Thank you, Michael Hamian  From markjo@netcom.com Thu Jun 8 21:01:32 1995 Date: Wed, 31 May 1995 14:44:48 -0600 From:gadiy@sun4.miti.com Subject: Re: 'sqrt' versus 'sqr -rt' The two commands accomplish the same and should perform the same. sqrt restricts your users to running only pre-compiled reports. They cannot write SQR programs and run them with sqrt. sqrt facilitates a run-time only license for SQR. You would develop the reports on another platform, save the .sqt file and deploy them on the run-time platform using sqrt. Gadi Yedwab MITI ______________________________ Reply Separator _________________________________ Subject: 'sqrt' versus 'sqr -rt' Author: usa.net!sqr-users@netcomsv.netcom.com at Internet Date: 5/31/95 11:27 AM We just purchased sqr workbench 2.5.7 on HP 9000. I have the following question to everyone: Is 'sqrt program_name' the same as 'sqr program_name -rt' ? If yes, which one is more efficient to use and why? If not, what is the difference? Any responses will greatly be appreciated. Thank you, Michael Hamian  From sqr-users@usa.net Thu Jun 8 21:01:52 1995 Date: Thu, 8 Jun 1995 18:31:32 -0600 From: gadiy@sun4.miti.com Subject: Re: Numeric Var Comparisons Kay, The problem that you're outlining is due to the fact that SQR uses machine floating point (C double) for numbers. Certain calculation result in 45.320999998 instead of 45.321. Truncating makes the problem worse. Instead you should round: if round(#database,3) != round(#calc,3) The next release of SQR (Version 3.5 due later this year) will offer exact match using high precision decimal numbers. Gadi Yedwab MITI ______________________________ Reply Separator _________________________________ Subject: Numeric Var Comparisons Author: usa.net!sqr-users@netcomsv.netcom.com at Internet Date: 6/8/95 2:26 PM We are running SQR 2.5.7 on Oracle 7.0.16.4.0 on a VAX. When trying to compare some calculated values against stored values in our database and flag the ones that were different, SQR was flagging values that were the same. SQR was not consistent in doing this though. For example, sometimes it would flag #calc = 345.89 as different from #database = 345.89, and other times it would say it was the same. It did however always catch the incorrect values. Below is a little sample program that I just created to see if it was SQR or me that was messing up. When the program is run it flags them as NOT EQUAL. If I put a TRUNC(#val,3) around each variable in the IF statement then it catches them as EQUAL. But this is not the case in the actual code that runs against ORACLE. What's up with this? Any help or suggestions on where to go would be greatly appreciated. Thanks, Kay BEGIN-REPORT let #database = 45.321 do q END-REPORT begin-procedure q let #calc = 145.321 - 100.000 display 'database ' noline show #database edit 99999.9999999 display 'cacl ' noline show #calc edit 99999.9999999 if trunc(#database,3) != trunc(#calc,3) display 'NOT EQUAL' else display 'EQUAL' end-if end-procedure From sqr-users@usa.net Fri Jun 9 08:10:49 1995 Date: Fri, 9 Jun 1995 07:05:46 -0600 From: Scott May - SICAS Center - SUNY Oneonta Subject: SQR Create Array Hello all, Another Programmer here fell into a common pitfall with arrays yesterday, and while I was thinking about it I thought I'd pose this as a possible enhancement to SQR at some future date, as well as a technical note. Our Programming Standards require that all procedures are alphabetized. A program starts with the Setup and Report Sections and then is followed by the procedures in alphabetical order. If I have an Access Array procedure and a Create Array procedure in alphabetical order, the array access statement in the Access Array procedure will generate an error stating that the array has not been created. The logical calling of these procedures is correct though. This occurs because SQR did not physically encounter the CREATE ARRAY before the GET or PUT statement. I make it a standard practice to define all arrays in either the REPORT section, or the Setup section since they are the first two sections in our programs, and arrays are most usually global in nature. I understand compiler design enough to know why this occurs, and that there is not a quick modification to resolve this either. The error can cause confusion if a programmer is not aware of this. Thanks, Scott May **************************************************************** * Programmer / Analyst | State University of New York * * SICAS Center | SUCO * * | Lee Hall * * Internet: maysa@oneonta.edu | Oneonta, NY 13820 * **************************************************************** From sqr-users@usa.net Fri Jun 9 08:36:28 1995 Date: Fri, 9 Jun 1995 07:28:35 -0600 From: mike@rmf41.usace.army.mil Subject: Reply to SQR Create Array > If I have an Access Array procedure and a Create Array procedure > in alphabetical order, the array access statement in the Access Array > procedure will generate an error stating that the array has not been created. > The logical calling of these procedures is correct though. This occurs > because SQR did not physically encounter the CREATE ARRAY before the GET or PUT > statement. > The same thing can occur in PRO*COBOL if the declaration of a cursor is physically after the first usage of that cursor. The pre-compiler scans top to bottom. -------------------------------------------------------------------------- Michael Stone (205) 890-2410 | A TTTTTTT SSSSS Advanced Technology Systems (ATS), Inc. | A A T S 4801 University Square, Suite 2 | AaaaA T SSSSS Huntsville, AL 35816-3431 | A A T S mike@rmf41.usace.army.mil | A A T SSSSS -------------------------------------------------------------------------- From markjo@netcom.com Fri Jun 9 12:02:32 1995 Date: Mon, 8 May 1995 19:34:26 -0600 From: Howard Nelson <76543.2321@compuserve.com> Subject: SQR/SQRW and Windows NT Wally, and other SQR Users: Its OK to send output to LPT1 under DOS but Windows isn't designed to do that. Windows has a device independant architecture which means that it provides a driver for each device. Each program then talks to the device through its API. So by using LPT1 you are actually circumventing the driver. You can probably get away with this for a while on Windows 3.1 but eventually you will run into problems. With our SQR reports we are creating a file using -F switch and once the report is finished then call NPRINT (a Novell utility) to send it to the printer. We like this because we can archive the file on an optical disk. NPRINT is very fast at spooling so its not a great sacrifice of performance. SQR 3.0 has a new switch on the command line, -PRINTER:WP, which uses the default Window Print Driver to produce the output. You may prefer this. I have been testing SQR 3.0 and I am very pleased with it. I have also tried running it on Windows 95 and I have found very few problems. I hope this helps. Howard Nelson Phoenix International ----------------------- We are having a problem printing with SQR/SQRW (2.5) and Windows NT Workstation (3.5). Here is the scenario: Novell network (3.11), and a workstation that has LPT1 captured to a network print queue. We call SQRW from Windows and specify the -F parameter to be '-Fprn' to print directly to the PRN device. Under Windows 3.1, this works fine, but using Windows NT, it has various problems. The first print job sent to the printer doesn't come-out, and when you tell it to print a second time, it print, but the print output is screwed-up (body of the report prints first, followed by a page with the headings). Any ideas/suggestions? We've thought of upgrading the SQR/SQRW 3.0, but wanted to see if we could resolve first. From markjo@netcom.com Fri Jun 9 12:02:44 1995 Date: Mon, 8 May 1995 20:00:50 -0600 From: Matthew F. Reagan Subject: Re: SQR >This message is for Mark Johnson: >In your reply to Catherine Cleveline, you mentioned about new release of SQR >which is very stable and include additional functionality. Which release you >are talking about? SQR 2.3.4; 2.5.7; 3.0.0? Thanks for verifying. Benjamin, Mark was (I'm pretty sure) referring to SQR V 3, which is available on a number of platforms (and more are being added each week). I have had a chance to play with it and believe it to be stable. I only crashed it once, and that was on a pre-release version. Would you believe, at the East Coast Oracle conference last week, I loaded Oracle7 for Windows and SQR3 for Windows on a 486 laptop (33mhz) with 12 meg of memory and 100 meg of free disk. It took about 2 hours (and 1 beer) once I got the PCMCIA SCSI card in and hooked up the SCSI CD Rom drive, and most of that (1 3/4 hours) was the Oracle7 installation. Ran like a dream. Did everything I asked of it, and then some. I was in heaven. Then I had to give the laptop back, and returned to my hand-me-down 286 laptop. Sniff, sniff. Matt... Oh. *THAT'S* what the Signature is...Alas, I have no witty comments. I musta left them back at the office. From markjo@netcom.com Fri Jun 9 12:02:56 1995 Date: Thu, 18 May 1995 21:17:39 -0600 From: Matthew F. Reagan Subject: Re: Preview of SQR reports >Does anybody know if there is any software or method in Windows to >preview SQR reports that were created for HP LaserJet printers in a >WYSWYG manner? Raymond, Using SQR3, it is possible to create a .SPF file, which is a printer independent file. Then, using SQRViewer, you can view the report file in almost WYSIWYG format. I say almost, because there are a few items that you cannot view under Windows. I don't recall all of them, but barcodes are one, EPS files are another. SQRPrint can be used to print the SPF file to the output device of your choice, including HPLaserJets (subject to font and memory requirements of course). Under 2.x versions of SQR, I never could find a solution to view HPLaserJet output files in WYSIWYG. Matt... From markjo@netcom.com Fri Jun 9 12:03:12 1995 Date: Thu, 18 May 1995 22:16:00 -0600 From: Raymond Yip Subject: Re: Preview of SQR reports -Reply >> Using SQR3, it is possible to create a .SPF file, which is a printer independent file. Then, using SQRViewer, you can view the report file in almost WYSIWYG format. I say almost, because there are a few items that you cannot view under Windows. I don't recall all of them, but barcodes are one, EPS files are another. SQRPrint can be used to print the SPF file to the output device of your choice, including HPLaserJets (subject to font and memory requirements of course). Under 2.x versions of SQR, I never could find a solution to view HPLaserJet output files in WYSIWYG. << Matthew, Thanks for your reply. I want to know more about SQR3. Is SPF file platform independent, i.e, if I can create it under HP-UX and view it under Windows? Is SQR3 availbale now in HP-UX and Windows? Raymond From markjo@netcom.com Fri Jun 9 12:03:15 1995 Date: Mon, 8 May 1995 09:29:55 -0600 From: Benjamin Le Subject: SQR This message is for Mark Johnson: In your reply to Catherine Cleveline, you mentioned about new release of SQR which is very stable and include additional functionality. Which release you are talking about? SQR 2.3.4; 2.5.7; 3.0.0? Thanks for verifying. ________________________________________________ Benjamin Le Portland Community College Computer Information Technology, (503)-977-4970 Campus E-mail: ble - Internet: ble@pcc.edu ------------------------------------------------ From markjo@netcom.com Fri Jun 9 12:03:26 1995 Date: Fri, 19 May 1995 09:28:44 -0600 From: Matthew F. Reagan Subject: Re: Preview of SQR reports -Reply > >Thanks for your reply. I want to know more about SQR3. Is SPF file >platform independent, i.e, if I can create it under HP-UX and view it under >Windows? Yes. It is completely transportable. The SPF file is standard ASCII, so it can be e-mailed to the destination site as a normal attachment (even throuh x.400 or the internet). The viewer is only available under Windows (I believe) at this time. >Is SQR3 availbale now in HP-UX and Windows? Yes, under HP-UX V 9.05. Oh. *THAT'S* what the Signature is...Alas, I have no witty comments. I musta left them back at the office. From markjo@netcom.com Fri Jun 9 12:03:32 1995 Date: Mon, 8 May 1995 11:29:47 -0600 From: Young Subject: SQR/SQRW and Windows NT We are having a problem printing with SQR/SQRW (2.5) and Windows NT Workstation (3.5). Here is the scenario: Novell network (3.11), and a workstation that has LPT1 captured to a network print queue. We call SQRW from Windows and specify the -F parameter to be '-Fprn' to print directly to the PRN device. Under Windows 3.1, this works fine, but using Windows NT, it has various problems. The first print job sent to the printer doesn't come-out, and when you tell it to print a second time, it print, but the print output is screwed-up (body of the report prints first, followed by a page with the headings). Any ideas/suggestions? We've thought of upgrading the SQR/SQRW 3.0, but wanted to see if we could resolve first. Thanks. Wally MicroSim Corporation From markjo@netcom.com Fri Jun 9 12:03:40 1995 Date: Fri, 19 May 1995 11:40:29 -0600 From:gadiy@sun4.miti.com Subject: Re[2]: Preview of SQR reports -Reply Raymond, 1. Yes, SPF is platform independent. 2. Yes, you can create output in SPF format on the HP-UX. 3. Yes, SQR3 is now available for HP-UX and Windows. The following text is taken from the SQR3 User's Guide: SQR allows you to create a printer-independent output file. Even if your report has a variety of fonts and graphics, you can print the report on a number of different printers. When you choose printer-independent output, SQR creates a file in SPF (SQR Portable Output File) format. The default extension for this type of file is .SPF instead of the usual .LIS extension. You gain a good deal of flexibility by using SPF files: You can run a report and postpone the decision of printer type until print time. For example, you can distribute the SPF file electronically without knowing the type of printer that each recipient has. The recipients of the report can use the SQRP program (described below) to print on their printers. You can use a PostScript viewer to preview the output of your report even if the report is designed for an HP printer. You do this by creating an SPF file, rendering PostScript for viewing, and rendering HP LaserJet (PCL) for printing. You can view, search, or E-mail the text portions of a graphic output by rendering a line-printer output. You can separate the printing from the report execution. For example, you might want to run the report on the database server computer and then print it on another computer (the print server computer). The overhead associated with producing the graphics will be shifted to the other computer. SPF Files and SQR for Windows Since SPF files can be produced by SQR on any platform, you can take advantage of the Windows printing capabilities even though you created the SQR report on another platform. For example, you can run a report on a UNIX server and then print the output on a PC using Windows. When you direct SQR for Windows to print using Windows printer drivers, there is normally no output file created. The output goes directly to the printer. If you use the -KEEP flag, SQR will save the output as an SPF file. This allows you to view and re-print the report on Windows. Requesting an SPF file To create an SPF file, use the -KEEP or -NOLIS command line flag. With the -KEEP flag you can generate a printer-specific output file (a .LIS file) and keep the SPF file as well. With -NOLIS you will create only SPF files. If you do not care to have the SPF file, do not specify these command line flags. SQR will create the printer-specific output directly. The SQR Print (SQRP) program Once you have created the SPF file you are ready to prepare it for printing. The SQRP program renders the printer-specific language such as PostScript or PCL. For line printers, SQRP will filter out the graphics. Viewing SPF files To view the SPF file on UNIX you can use SQRP to create line-printer or PostScript output. The PostScript output may be viewed using a PostScript viewer. To view the SPF file on Windows, use the SQR Viewer. Gadi Yedwab, MITI ______________________________ Reply Separator _________________________________ Subject: Re: Preview of SQR reports -Reply Author: usa.net!sqr-users@netcomsv.netcom.com at Internet Date: 5/19/95 8:44 AM >> Using SQR3, it is possible to create a .SPF file, which is a printer independent file. Then, using SQRViewer, you can view the report file in almost WYSIWYG format. I say almost, because there are a few items that you cannot view under Windows. I don't recall all of them, but barcodes are one, EPS files are another. SQRPrint can be used to print the SPF file to the output device of your choice, including HPLaserJets (subject to font and memory requirements of course). Under 2.x versions of SQR, I never could find a solution to view HPLaserJet output files in WYSIWYG. << Matthew, Thanks for your reply. I want to know more about SQR3. Is SPF file platform independent, i.e, if I can create it under HP-UX and view it under Windows? Is SQR3 availbale now in HP-UX and Windows? Raymond From sqr-users@usa.net Fri Jun 9 12:58:17 1995 Date: Fri, 9 Jun 1995 11:53:01 -0600 From: Mark Johnson Subject: Re: SQR Create Array Scott, I think that I see your problem. It is probably best to either warn your programmers about this, or enhance your conventions to take this into account. Putting create-array statements in the setup section is a good idea. Alternatively, you could have procedures that create arrays have their procedure names start with 'aa_' (announce array) or have the names start with an underscore. Although there always seems to be resistance to changing conventions, it is usually easier than redesigning a compiler. Hope this helps. Mark On Fri, 9 Jun 1995, Scott May - SICAS Center - SUNY Oneonta wrote: > Hello all, > > Another Programmer here fell into a common pitfall with arrays > yesterday, and while I was thinking about it I thought I'd pose this as > a possible enhancement to SQR at some future date, as well as a technical > note. > > Our Programming Standards require that all procedures are alphabetized. > A program starts with the Setup and Report Sections and then is followed by > the procedures in alphabetical order. > > If I have an Access Array procedure and a Create Array procedure > in alphabetical order, the array access statement in the Access Array > procedure will generate an error stating that the array has not been created. > The logical calling of these procedures is correct though. This occurs > because SQR did not physically encounter the CREATE ARRAY before the GET or PUT > statement. > > I make it a standard practice to define all arrays in either the REPORT > section, or the Setup section since they are the first two sections in our > programs, and arrays are most usually global in nature. I understand compiler > design enough to know why this occurs, and that there is not a quick > modification to resolve this either. The error can cause confusion if a > programmer is not aware of this. > > > Thanks, > Scott May > **************************************************************** > * Programmer / Analyst | State University of New York * > * SICAS Center | SUCO * > * | Lee Hall * > * Internet: maysa@oneonta.edu | Oneonta, NY 13820 * > **************************************************************** > > From sqr-users@usa.net Wed Jul 12 14:29:43 1995 Date: Wed, 12 Jul 1995 13:25:37 -0600 From: diannej@sun4.miti.com Subject: SQR3 Beta News MITI is pleased to announce the introduction of a new major release of SQR3 that adds new functionality, addresses enhancement requests from customers, and improves the product user interface on Microsoft Windows. At MITI we constantly look for ways to enhance our products, in order to respond to the changing market and ever-increasing complex requirements of the computer industry. As a Beta Associate with MITI you can look forward to many advantages, such as: * The capacity to develop your applications before competitors if you are integrating SQR3 into your products * The ability to have many value-added enhancements before the production release * Access to dedicated technical engineers should you need assistance * The ability to have your specific needs met through feedback directly to our developing engineers * Assistance with developing applications to meet your specific needs * The advantage of being on the cutting edge of the computer processing industry * The advantage of potential worldwide recognition in our press events, advertising and user profiles at no cost MITI is currently in the process of selecting only a limited number of BETA Associates for our SQR Workbench 3.5 Beta Program. The testing period will be from September 1995 through October 1995. If you are interested, please reply to diannej@miti.com. I need your name, company name, address, and phone number, to mail you the materials. If you have any questions, please feel free to call me at (310) 424-4399 extension 215. From sqr-users@usa.net Tue Aug 1 10:36:17 1995 Date: Tue, 1 Aug 1995 09:32:25 -0600 From: Richard Vernick Subject: SQR for windows We're currently running SQR 2.5.7 on OpenVMS and are considering the windows product. Are there any strong feelings/comments on the win platform? From sqr-users@usa.net Tue Aug 1 14:57:43 1995 Date: Tue, 1 Aug 1995 13:53:48 -0600 From: gadiy@sun4.miti.com Subject: Re: SQR for windows To the author of the "SQR for windows" inquiry, When you say that you're considering using the Windows product. What would you be using it for? - Running reports on the PC instead of the OpenVMS? - Developing reports on the PC and then running them on OpenVMS? - Giving the PC version to some end-users in your organization? I think that the pros and cons of using SQR on the PC depend on the applica