From owner-sqr-users@USA.NET Thu Jan 2 12:49:00 1997 Date: Thu, 2 Jan 1997 12:37:34 -0500 From: Allen Wong Subject: Creating a box I would like to create a square box, and I am using the following code to acheive this : PRINT ' ' (,59) BOX PRINT ' ' (,61) BOX PRINT ' ' (,63) BOX PRINT '.' (,66) BOLD PRINT ' ' (,67) BOX PRINT ' ' (,69) BOX As one can tell this is probably not the best method, if someone can show me the light, much will be appreciated. Thanks, Allen From owner-sqr-users@USA.NET Mon Jan 6 18:08:53 1997 Date: Mon, 6 Jan 1997 11:11:31 EST From: David Colangelo Subject: 1099-FORM Has anyone developed an SQR program that prints the layout for the IRS 1099 series of forms? I'd like to avoid reinventing the wheel if someone has already done it. Thanks in advance. Thank you, David Colangelo david_colangelo@mail.amsinc.com From owner-sqr-users@USA.NET Mon Jan 6 19:29:57 1997 Date: Mon, 6 Jan 1997 18:19:46 -0500 From: Ray Ontko Subject: Re: 1099-FORM > Has anyone developed an SQR program that prints the layout for the IRS > 1099 series of forms? I'd like to avoid reinventing the wheel if > someone has already done it. Thanks in advance. > > Thank you, > > David Colangelo David, I don't know if this will work, but you can get the official version of the forms from the IRS website (www.irs.ustreas.gov) as postscript files and use these as background for your printing. If you're not using postscript printers, you may have to fuss around. Hope this helps. Ray ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Ask me about Forte Software" rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@USA.NET Wed Jan 8 03:48:52 1997 Date: Tue, 7 Jan 1997 08:35:56 -0600 From: Melissa Santamaria Subject: Re: 1099-FORM Yes, we sure have. We have SQR code used with Oracle that we have been using for about 3 years to create both printed 1099s and the IRS file format. I don't know if it has yet been reviewed/updated for any potential changes for tax year 1996. If you would like an email copy of the critical parts of that SQR program, reply to: melissa@medianet.com. Good luck! Melissa On Mon, 6 Jan 1997, David Colangelo wrote: > Has anyone developed an SQR program that prints the layout for the IRS > 1099 series of forms? I'd like to avoid reinventing the wheel if > someone has already done it. Thanks in advance. > > Thank you, > > David Colangelo > david_colangelo@mail.amsinc.com > From owner-sqr-users@USA.NET Wed Jan 8 04:25:42 1997 Date: Tue, 7 Jan 1997 12:00:16 -0500 From: Ray Ontko Subject: Win 95 Has anyone had any success running 32-bit SQR (3 or 4) under Win 95? I'm trying to connect to a Sybase 10 or 11 server using a copy of SQR for Windows NT/Sybase 4.0 and get a general protection violation on exit (SQR seems to run my program, but I get this error...) Ray ---------------------------------------------------------------------- rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@USA.NET Wed Jan 8 08:06:01 1997 Date: Wed, 8 Jan 1997 07:53:34 -0500 From: Shivakumar Rajagopal Subject: next-listing problem... I used next-listing after printing every detail line of a report in order to get one blank line between detail lines. Towards the end of the report, a line that was being printed within begin-heading...end-heading, was getting printed partially in the detail line i.e the detail line was garbled....When I used next-listing skiplines=0, the same problem occurred...next-listing skiplines=1 ran successfully but there were 2 blank lines between detail lines...is it a known bug or what ? Is there any list of known SQR bugs around ?....Would appreciate your help.......shiv From owner-sqr-users@USA.NET Wed Jan 8 13:57:32 1997 Date: Wed, 8 Jan 1997 12:00:28 -0500 From: "Eric A. Eastman" Subject: Fetch out of sequence error. Hello all, I have a problem where an extremely simple select causes a "fetch out of sequence" error. I think that it is caused by the cursor unexpectedly closing in the middle of the select. This always occurs after a specific record is read ( sys_fkey = 16852 ) regaurdless of what "order by" is used. Even though I have trapped the error with on error the select stops after this record. ( fyi_char30 is NULL for that record). The select works fine in sqlplus. Does anyone have any thoughts? Thanks, Eric here is the code: begin-program do main end-program begin-procedure main show 'start' begin-select on-error=error fyi_char30 &char30 sys_fkey show &sys_fkey ' - ' &char30 from fyi_asset_fold@bfnfyi.world where sys_fkey > 16850 and sys_fkey < 16860 end-select show 'done' end-procedure begin-procedure error show 'begin-error' show #sql-status show $sql-error show 'Char30 = ' &char30 show 'Fkey = ' &sys_fkey show 'end-error' end-procedure and here are the results: SQR: Structured Query Report Writer V3.0.12.1 Copyright (C) MITI, 1994, 1995. All Worldwide Rights Reserved. start 16851 - BFN-3-XIS -099-0002 16852 - begin-error -1002.000000 ORA-01002: fetch out of sequence Char30 = Fkey = 16852 end-error done SQR: End of Run. $ sqr -id SQR/3.0.12.1/Sun/Solaris 2.4/Oracle 7.0.16/Dec 01 1995 From owner-sqr-users@USA.NET Wed Jan 8 14:30:44 1997 Date: Wed, 8 Jan 1997 12:29:31 -0500 From: DAReiser@AOL.COM Subject: PeopleSoft Consulting Opportunities Happy New Year! Do you work with PeopleSoft? I would be interested in speaking with you. Deb Reiser, Technical Recruiter Dimension Systems, Inc. 41621 West Eleven Mile Road Novi, MI 48375-1804 Phone: (810)305-9399 E-Mail: DAReiser@aol.com From owner-sqr-users@USA.NET Wed Jan 8 17:19:57 1997 Date: Wed, 8 Jan 1997 13:58:08 -0800 From: Raja Rajaram Subject: help with General Protection Faults... Hi All, I would like to know the reasons and ways to avoid any GPF's. We are planning on shipping our s/w and would like to know more about GPF's so that we can build a concrete product. We will be calling SQR from a VB front end. So if ther are any specific steps to avoid GPF's within the SQRWIN.DLL file kindly let me know. During the developments i have gottne the GPF in WMCOMN.LIB many a times. ANy way to avoid these?? Help much appreciated.. Thanks Raja raja@wise.com From owner-sqr-users@USA.NET Wed Jan 8 21:31:47 1997 Date: Wed, 8 Jan 1997 21:00:45 -0500 From: Terri Jenkins Subject: Re: PeopleSoft Consulting Opportunities Yes I do, for about 2 years now. Currently am with an implementation partner and travelling a lot. From owner-sqr-users@USA.NET Thu Jan 9 08:31:08 1997 Date: Thu, 9 Jan 1997 08:22:30 -0500 From: "\"Fernando Villaamil" Subject: Re: help with General Protection Faults... GPFs are a strange animal. We used to suffer from them until we upgraded our machines memory to 16Mb from 8. From owner-sqr-users@USA.NET Fri Jan 10 07:34:04 1997 Date: Fri, 10 Jan 1997 06:02:26 -0500 From: Steve Krim Hi all, I'm new to this list server, hopefully I can contribute something to it! A couple of questions open for discussion... 1) What kinds of things have others done to do remote report / interface development? I'm an independant contractor and would rather work at home on client reports (Less travel time, less interuptions, etc...) The issues I see are differing DB platforms, how to get good test data into my DB, performance of a home server (I don't bill enough to buy an Ultra Sparc 6000!), and others I'm sure. 2) Has anyone done anything to put a report into native Excel 5.x format? I don't have a lot of faith this is possible with out getting the Excel file format spec. Thanks alot to all! Steve From owner-sqr-users@USA.NET Fri Jan 10 08:54:04 1997 Date: Fri, 10 Jan 1997 08:41:55 -0500 From: Ray Ontko Subject: Re: your mail > 1) What kinds of things have others done to do remote report / interface > development? I'm an independant contractor and would rather work at home > on client reports (Less travel time, less interuptions, etc...) The issues > I see are differing DB platforms, how to get good test data into my DB, > performance of a home server (I don't bill enough to buy an Ultra Sparc > 6000!), and others I'm sure. Steve, We've done a fair amount of remote development of SQR applications. Here are a few thoughts: 1) get a fast connection to the internet. Many clients will at least allow you to telnet into their machines to do development or ftp to upload and download files easily. A ppp connection (available through your internet service provider) would often allow you to test remotely against a database server at your client. 2) if most of your work is with a particular database, (say Oracle or Sybase), get a copy to run on an intel machine in your office. Because your client won't have to provide a machine for you, you may be able to justify a slightly higher rate. 3) although SQR runs against many databases, I wouldn't expect you to be very productive writing SQR reports against Oracle with the intention of running them against a Sybase database. Ray ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Ask me about SQR and the WEB." rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@USA.NET Fri Jan 10 18:19:27 1997 Date: Fri, 10 Jan 1997 10:28:37 -0800 From: John Kellogg Subject: Re: Fetch out of sequence error. From owner-sqr-users@USA.NET Mon Jan 13 04:55:16 1997 Date: Tue, 14 Jan 1997 11:39:57 +0200 From: Marcel Groenewald Subject: Using SQR3 for batch processing Because of the power and ease of use of SQR3, we are contemplating using it for purposes other than reportwriting. Is anyone else currently using SQR3 in the UNIX environment for other tasks (e.g. batch jobs)? These tasks could include database housekeeping and interfacing to outside systems (e.g. file transfers, etc.) If you are using SQR3 in this manner, I would like to know how issues like error logging, security, etc. are handled. Thank you Marcel Groenewald From owner-sqr-users@USA.NET Mon Jan 13 08:19:53 1997 Date: Tue, 14 Jan 1997 07:56:00 -0500 From: Michael Docteroff Subject: Re: Using SQR3 for batch processing Marcel, I have worked on systems that use SQR for all daily and nightly batch processing. Including Material Requirements Planning modules, Accounts Payable check processing, Physical Inventory systems and even Accounts Payable Check Reconciliation processes that read interfaced files from a companies financial institution. I think SQR is a real powerful transaction processing tool and would be a great choice for what you are trying to accomplish. The systems I worked on were running under HP-UX and using an Oracle database and the security issues were handled by the operating system and the database. Now that SQR allows you to write to multiple output files error logging has become easier to handle. If you have any questions please feel free to contact me at 609-716-3233. Michael A.Docteroff M.A.D. Technologies ______________________________ Reply Separator _________________________________ Subject: Using SQR3 for batch processing Author: marcelg@NEW.ISCORLTD.CO.ZA at GATEWAY Date: 1/14/97 4:39 AM Because of the power and ease of use of SQR3, we are contemplating using it for purposes other than reportwriting. Is anyone else currently using SQR3 in the UNIX environment for other tasks (e.g. batch jobs)? These tasks could include database housekeeping and interfacing to outside systems (e.g. file transfers, etc.) If you are using SQR3 in this manner, I would like to know how issues like error logging, security, etc. are handled. Thank you Marcel Groenewald From owner-sqr-users@USA.NET Tue Jan 14 12:22:10 1997 Date: Tue, 14 Jan 1997 11:58:00 -0500 From: james rader Subject: Re: Using SQR3 for batch processing Marcel, Most SQR shops quickly extend it's use beyond reportwriting. In fact, we get really testy when someone refers to it as a "reportwriter". We at INTELSAT, like many SQR shops, have used it to convert between ORACLE versions, fix ORACLE databases, and do very heavy duty batch processing. We also use it to provide world-wide on-line database query capability as part of multi-teir distributed systems architectures. If you only use it for reports, you have but scratched the surface. - Jim Rader Internet: james.rader@intelsat.int ------------- Original Text >From MARCELG@SMTPGATE (Marcel Groenewald) {marcelg@NEW.ISCORLTD.CO.ZA}, on 14/1/97 4:39 AM: To: SQR-USER@SMTPGATE (Multiple recipients of list SQR-USERS) {SQR-USERS@USA.NET} Because of the power and ease of use of SQR3, we are contemplating using it for purposes other than reportwriting. Is anyone else currently using SQR3 in the UNIX environment for other tasks (e.g. batch jobs)? These tasks could include database housekeeping and interfacing to outside systems (e.g. file transfers, etc.) If you are using SQR3 in this manner, I would like to know how issues like error logging, security, etc. are handled. Thank you Marcel Groenewald From owner-sqr-users@USA.NET Tue Jan 14 18:38:26 1997 Date: Tue, 14 Jan 1997 17:07:57 -0600 From: Richard Watts Subject: Using SQR3 for batch processing -Reply Marcel, I don't know how familiar, if at all, you are with PeopleSoft Financials, but the entire Asset Management server product is written in SQR, and quite a few pieces of their GL and Project Costing modules are written in SQR. To that end we have written maintenance processes, tree loader processes, and entire source system interface/edit modules for PeopleSoft Financials in SQR. >>> Marcel Groenewald 01/14/97 03:39am >>> Because of the power and ease of use of SQR3, we are contemplating using it for purposes other than reportwriting. Is anyone else currently using SQR3 in the UNIX environment for other tasks (e.g. batch jobs)? These tasks could include database housekeeping and interfacing to outside systems (e.g. file transfers, etc.) If you are using SQR3 in this manner, I would like to know how issues like error logging, security, etc. are handled. Thank you Marcel Groenewald From owner-sqr-users@USA.NET Wed Jan 15 10:43:25 1997 Date: Wed, 15 Jan 1997 10:22:00 -0500 From: Callis David Subject: Re: PeopleSoft Consulting Opportunities Are you considering new opportunities? >---------- >From: Terri Jenkins[SMTP:LDYGLFR@AOL.COM] >Sent: Wednesday, January 08, 1997 9:00 PM >To: Multiple recipients of list SQR-USERS >Subject: Re: PeopleSoft Consulting Opportunities > >Yes I do, for about 2 years now. Currently am with an implementation partner >and travelling a lot. > From owner-sqr-users@USA.NET Wed Jan 15 13:35:16 1997 Date: Thu, 16 Jan 1997 14:29:22 +0000 From: Simone Curtis Subject: SQR report developer I am looking for an SQR report developer to work in an Oracle 7 and Sysbase 10 environment on out Great Ormond Street project. I would prefer a new permenent member of staff but if any contractors are available for the next 2-3 months, please let me know. The company is KPMG Health Systems, based in Manchester city center, England. If you are interested please send your C.V. to me as soon as possible. Thanks Simone Curtis Consultant KPMG Health Systems From owner-sqr-users@USA.NET Wed Jan 15 15:25:02 1997 Date: Wed, 15 Jan 1997 14:43:59 -0500 From: Sean Collins Has anyone else out there experienced this problem. I received this message from one of our users. *************************************************************************************** After successfully running to completion several of my EasySQR programs - and obtaining the expected results - I may need to return and run the given program a second time. Many times, I have re-run a program without making changes to the program whatsoever. When the system message informs me that the run is completed and I view what should be the output on the screen, I instead have received the message that informs me that: "The report output file does not exist o You haven't run the report yet o One or more of the following clauses ("Join", "Where") didn't allow any data to be selected from the database." Logically, this is impossible because I have previously tested the program, obtained the results, and have not amended the program in any way. **************************************************************************************** Thanks in advance for any light you can shed on the subject. From owner-sqr-users@USA.NET Wed Jan 15 15:29:38 1997 Date: Wed, 15 Jan 1997 11:13:26 -0800 From: Raja Rajaram Subject: Re: SQR report developer Hi, I would like to know if the position will be based in England itself or if there is an opportuinity for any positions here in the US. IF so please let me know. I have about 5 months experience in SQR and i am also in the Health Care business. Raja raja@wise.com ____________________Reply Separator____________________ Subject: SQR report developer Author: SQR-USERS@USA.NET Date: 1/16/97 2:29 PM I am looking for an SQR report developer to work in an Oracle 7 and Sysbase 10 environment on out Great Ormond Street project. I would prefer a new permenent member of staff but if any contractors are available for the next 2-3 months, please let me know. The company is KPMG Health Systems, based in Manchester city center, England. If you are interested please send your C.V. to me as soon as possible. Thanks Simone Curtis Consultant KPMG Health Systems From owner-sqr-users@USA.NET Wed Jan 15 23:00:58 1997 Date: Wed, 15 Jan 1997 22:49:34 -0500 From: Ed Crotty <73747.1247@COMPUSERVE.COM> Subject: Using SQR3 for batch processing -Reply If you're NOT using SQR for batch processing - you're missing the boat!! From owner-sqr-users@USA.NET Wed Jan 15 23:49:08 1997 Date: Thu, 16 Jan 1997 11:52:25 +0800 From: Raymond Yip Subject: 32-bit version of SQR Viewer Is there any 32-bit version of SQR Viewer? Raymond From owner-sqr-users@USA.NET Thu Jan 16 03:14:42 1997 Date: Thu, 16 Jan 1997 09:07:08 +0200 From: Marcel Groenewald Subject: Re: Using SQR3 for batch processing Thank you for your reply. I work for a large steel manufacturing company on exactly the same platform you are (i.e. Oracle on HPUX). I would appreciate it if you could tell me how you handle certain issues: 1. How does your SQR programs log on to the database? Is the username and password hard coded in your programs? If so, what do you do when a password changes? Don't you see this as a possible security problem (i.e. anyone with access to your program can get a database login) ? 2. Are your SQR systems 24x7 type of systems? If so, what do you do when an error occurs? We have 24 hr operations people who could monitor for errors or resource usage, but I'm just wondering what will be the best way to do this (e.g. using some systems management tool like HP/Openview). How are your systems handling this? Can your systems notify a user when an error occured? 3. Do you keep logs of execution times? (i.e. when last a certain program executed) 4. Do you have any architecture for kicking of your batches from a client PC running Windows? (I.e. a client wants to run a certain SQR program on the HPUX server, and not on his PC. He may want to be notified when it completed and view the results, log, etc.) 5. How many people in your environment are coding using SQR3? Do you have some coding standards or guidelines? (e.g. the general layout of the program, how to handle errors, what to log where and when, etc.) Thank you for your interest Marcel Groenewald ---------- > Marcel, > > I have worked on systems that use SQR for all daily and nightly batch > processing. Including Material Requirements Planning modules, Accounts > Payable check processing, Physical Inventory systems and even Accounts > Payable Check Reconciliation processes that read interfaced files from > a companies financial institution. > > I think SQR is a real powerful transaction processing tool and would > be a great choice for what you are trying to accomplish. > > The systems I worked on were running under HP-UX and using an Oracle > database and the security issues were handled by the operating system > and the database. > > Now that SQR allows you to write to multiple output files error > logging has become easier to handle. > > > If you have any questions please feel free to contact me at > 609-716-3233. > > Michael A.Docteroff > M.A.D. Technologies From owner-sqr-users@USA.NET Sat Jan 18 14:52:29 1997 Date: Sat, 18 Jan 1997 08:42:40 -0500 From: Ray Ontko Subject: Re: next-listing problem... > I used next-listing after printing every detail line of a report in order to > get one blank line between detail lines. Towards the end of the report, a > line that was being printed within begin-heading...end-heading, was getting > printed partially in the detail line i.e the detail line was garbled....When > I used next-listing skiplines=0, the same problem occurred...next-listing > skiplines=1 ran successfully but there were 2 blank lines between detail > lines...is it a known bug or what ? Is there any list of known SQR bugs > around ?....Would appreciate your help.......shiv Make sure that you have the correct number of lines declared for your heading. Also, an early version of 3.0 had a problem with putting an extra blank line at the top of a page (below the header) if wrap continued onto a second page (if I remember correctly). I'm not aware of any other problems, but call MITI for the official word. Hope this helps. Ray ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Time for a new signature line." rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@USA.NET Sat Jan 18 14:52:34 1997 Date: Sat, 18 Jan 1997 07:48:17 -0500 From: Ray Ontko Subject: Re: 32-bit version of SQR Viewer > Is there any 32-bit version of SQR Viewer? > > Raymond I assume you mean for Win95. The 16 bit version is the only supported one for Win95. Is there a reason the 16 bit version won't work for your application? Ray ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Ask me about SQR and the WEB." rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@USA.NET Sun Jan 19 04:30:48 1997 Date: Sun, 19 Jan 1997 04:13:23 -0800 From: Recruiting Subject: SQR Openings... ------------7EC358124C0415 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii We have SQR openings...Salary:$35-$45/hr...Length:1 year. Interested candidates please e-mail resumes to recruiting@proconinc.com or fax to 1-810-213-0314. For more details please call 1-810-244-8536. Thanks, Ron Procon Inc. 810-244-8536 ------------7EC358124C0415 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset=us-ascii
 We have SQR openings...Salary:$35-$45/hr...Length:1 year. Interested candidates please e-mail resumes to recruiting@proconinc.com or fax to 1-810-213-0314. For more details please call 1-810-244-8536.
 
Thanks,
Ron
Procon Inc.
810-244-8536
------------7EC358124C0415-- From owner-sqr-users@USA.NET Tue Jan 21 13:36:26 1997 Date: Tue, 21 Jan 1997 13:15:47 -0500 From: "JUNNARKAR, SWAPNIL" Subject: Password & Porting on NT Hi, I am using SQR 3 on UNIX. I need some help on the following issues. 1>Can U get the password in some reserved variable? like $username gives you the user id. I have a driver SQR which runs other SQRs as per the parameters. 2>Currently I am running the SQRs on UNIX, but it can happen that they might be ported onto NT. I am issuing operating system commands for eg call system using 'UNIX comm' DOes anyone know how to do the same on NT ? Thanks in advance, Swapnil. From owner-sqr-users@USA.NET Wed Jan 22 06:47:13 1997 Date: Wed, 22 Jan 1997 10:40:40 +0000 From: lclarke@SPS-UK.CO.UK Subject: SQR Contractors Needed SPS, MITI's primary supplier of SQR consultancy and training services in th= e UK, are currently looking for SQR contractors to undertake a variety of SQR=20 development projects in the UK. If you have experience of SQR and would be interested in finding out more a= bout=20 the sort of assignments SPS could offer you, send a copy of your Resume/CV=20= to: Linda Clarke For more information about SPS and its services you can visit our web site=20= at: http://www.sps-uk.co.uk ---------------------------------------------------------------------- >From : Linda Clarke Date : 22 January 1996 Company : Software Product Services Limited Tel : +44 (0)1483 730771 =20 Fax : +44 (0)1483 727417 E-Mail : sps@sps-uk.co.uk URL : http://www.sps-uk.co.uk ---------------------------------------------------------------------- From owner-sqr-users@USA.NET Wed Jan 22 13:06:30 1997 Date: Wed, 22 Jan 1997 08:20:35 -0800 From: John Kellogg Subject: Re: Password & Porting on NT Swapnil, 1) We have an enhancement request already open for a $password reserved variable (# 558). So far, the request has not been implemented. It may be considered for V5. There are obvious security considerations in implementing this variable. 2) Your choices are to convert the call system command from a UNIX command to a DOS or Windows equivalent if available, or, to run a UNIX shell package on the NT such as MKS. John L. Kellogg SQRiBE (Formerly MITI) Technical Support Manager JUNNARKAR, SWAPNIL wrote: > > Hi, > I am using SQR 3 on UNIX. > I need some help on the following issues. > > 1>Can U get the password in some reserved variable? like $username gives > you the user id. > I have a driver SQR which runs other SQRs as per the parameters. > > 2>Currently I am running the SQRs on UNIX, but it can happen that they > might be ported onto NT. > I am issuing operating system commands for eg call system using 'UNIX > comm' > DOes anyone know how to do the same on NT ? > Thanks in advance, > Swapnil. From owner-sqr-users@USA.NET Thu Jan 23 19:26:33 1997 Date: Thu, 23 Jan 1997 09:38:54 -0800 From: Angel Guzman Subject: SQR3 on WIN-NT We are going to migrate to WIN-NT this summer. I currently use SQR3, will SQR work in NT? From owner-sqr-users@USA.NET Thu Jan 23 19:38:59 1997 Date: Thu, 23 Jan 1997 16:43:33 +0000 From: Harry at Planet Connect Subject: Including inverted commas within the STRING statement How can I include a ' within a STRING statement (so as to build a dynamic variable). Thanks Harry From owner-sqr-users@USA.NET Thu Jan 23 22:07:52 1997 Date: Thu, 23 Jan 1997 19:56:46 -0500 From: "Eric A. Eastman" Subject: Re: Including inverted commas within the STRING statement Harry, You simply double the quotation mark: print 'The Beatles sang ''Can''t Buy Me Love.''' () result The Beatles sang 'Can't Buy Me Love.' Welcome, Eric PS. The same goes for exclaimation marks in strings: print 'Go Packers!!' () print 'Go Pats!' () is an error. On Thu, 23 Jan 1997, Harry at Planet Connect wrote: > How can I include a ' within a STRING statement (so as to build a > dynamic variable). > > Thanks > > Harry > From owner-sqr-users@USA.NET Thu Jan 23 22:21:50 1997 Date: Thu, 23 Jan 1997 17:12:52 -0800 From: Raja Rajaram Subject: How can this be done?? Hi All, I have this question. I have a select statement which has an IN clause, for eg. select emp_iid from emp where dept in ('HR',ENG') This is the problem. I would like to have th IN clause parameters to be a variable number. I have an upper limit though (say 10) I dont know how many different Dept's i might have to include. I tried passing all the depts as a comma seperated string. I UNSTRING them into 10 different variables and them make them into a string like 'HR','ENG','SALES' (including the ' and , ) say $Dept. so now the select clause could look like as select emp_iid where dept in ($Dept). This apparently does not work. Does anybody have any suggestion for this kinda problem? Thanks Raja raja@wise.com From owner-sqr-users@USA.NET Fri Jan 24 01:48:27 1997 Date: Thu, 23 Jan 1997 22:42:40 -0500 From: Ray Ontko Subject: Re: How can this be done?? > Hi All, > I have this question. I have a select statement which has an IN clause, for eg. > > select emp_iid > from emp > where dept in ('HR',ENG') > > This is the problem. I would like to have th IN clause parameters to be a > variable number. I have an upper limit though (say 10) I dont know how many > different Dept's i might have to include. I tried passing all the depts as a > comma seperated string. I UNSTRING them into 10 different variables and them > make them into a string like 'HR','ENG','SALES' (including the ' and , ) say > $Dept. so now the select clause could look like as > select emp_iid where dept in ($Dept). > This apparently does not work. Does anybody have any suggestion for this kinda > problem? Raja, What you're trying to do is called a "dynamic query". To include variable text in the where clause, put square brackets around the variable containing the text. For example: where dept in ( [$dept] ) The square brackets tell SQR to treat the contents of the variable as part of the literal SQL statement, not as a host variable. Ray ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Ask me about SQR and the WEB." rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@USA.NET Fri Jan 24 01:56:15 1997 Date: Thu, 23 Jan 1997 18:27:12 -0800 From: Bob Lowell Subject: Re: Including inverted commas within the STRING statement At 04:43 PM 1/23/97 +0000, Harry at Planet Connect wrote: >How can I include a ' within a STRING statement (so as to build a >dynamic variable). You have to comment it with an additional ' ie: STRING 'bp.release_group = ' '''' $rg '''' BY '' INTO $dynamic_rg where the four ' in a row preceding and trailing $rg represent 1) opening quote 2) comment quote 3) quote written into $dynamic_rg variable 4) closing quote Enjoy, Bob From owner-sqr-users@USA.NET Fri Jan 24 01:59:31 1997 Date: Fri, 24 Jan 1997 05:32:17 -0000 From: "Ward, Martin" Subject: SQR/SQR3 Querying on Database Views Can SQR/SQR3 'select' from a database view?. My version(s) of SQR come bundled with the MAXIMO Maintenance Management Package. I have tried to select from a view that I have created at the database level, but I receive a 'TABLE not CREATED' SQR Error. Interestingly, the MAXIMO Application has views on its tables, and SQR can select from them. I am not sure whether the catalog that the SQR sees is purely linked to the MAXIMO application. For information I am running a SQLBase database. Many thanks for any help. Regards M.J.Ward MAXIMO Analyst Systems Development News International Newspapers Ltd. email : martin.ward@it.newsint.co Tel: 0171-782-6389 fax: 0171-782-6416 From owner-sqr-users@USA.NET Fri Jan 24 15:18:45 1997 Date: Fri, 24 Jan 1997 13:10:33 -0500 From: "Brent S. Templeton" Subject: Re: SQR/SQR3 Querying on Database Views ------ =_NextPart_000_01BC09F8.4D4024C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Should work, you might re-check permissions on the view to include the SQR login user. I am not familiar with Maximo however. Regards, Brent btempleton@pmai.org -----Original Message----- From: Ward, Martin [SMTP:martin.ward@IT.NEWSINT.CO.UK] Sent: Friday, January 24, 1997 8:52 AM To: Multiple recipients of list SQR-USERS Subject: SQR/SQR3 Querying on Database Views Can SQR/SQR3 'select' from a database view?. My version(s) of SQR come bundled with the MAXIMO Maintenance Management Package. I have tried to select from a view that I have created at the database level, but I receive a 'TABLE not CREATED' SQR Error. Interestingly, the MAXIMO Application has views on its tables, and SQR can select from them. I am not sure whether the catalog that the SQR sees is purely linked to the MAXIMO application. For information I am running a SQLBase database. Many thanks for any help. Regards M.J.Ward MAXIMO Analyst Systems Development News International Newspapers Ltd. email : martin.ward@it.newsint.co Tel: 0171-782-6389 fax: 0171-782-6416 ------ =_NextPart_000_01BC09F8.4D4024C0 Content-Type: application/ms-tnef Content-Transfer-Encoding: base64 eJ8+IjMSAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQmAAQAhAAAANjdBMjUwOUVGMjc1RDAxMTkwMzQwMEEwQzkxMjEw QTYA1QYBBYADAA4AAADNBwEAGAANAAoAIQAFACoBASCAAwAOAAAAzQcBABgADQAKACEABQAqAQEE kAYAsAEAAAEAAAARAAAAAwAAMAAAAAALAA8OAAAAAAIB/w8BAAAAQwAAAAAAAACBKx+kvqMQGZ1u AN0BD1QCAAAAACdTUVItVVNFUlNAVVNBLk5FVCcAU01UUABTUVItVVNFUlNAVVNBLk5FVAAAHgAC MAEAAAAFAAAAU01UUAAAAAAeAAMwAQAAABIAAABTUVItVVNFUlNAVVNBLk5FVAAAAAIB9g8BAAAA BAAAAAAAAAADABUMAQAAAAIBCzABAAAAFwAAAFNNVFA6U1FSLVVTRVJTQFVTQS5ORVQAAB4AATAB AAAAFAAAACdTUVItVVNFUlNAVVNBLk5FVCcAHgAgOgEAAAAUAAAAJ1NRUi1VU0VSU0BVU0EuTkVU JwALAEA6AQALMAMA/g8GAAAAAwAAOQAAAAADAP9fAAAAAAMA/V8BAAAAHgD2XwEAAAASAAAAU1FS LVVTRVJTQFVTQS5ORVQAAAACAfdfAQAAAEEAAAAAAAAAgSsfpL6jEBmdbgDdAQ9UAgAAAABTUVIt VVNFUlNAVVNBLk5FVABTTVRQAFNRUi1VU0VSU0BVU0EuTkVUAAAAADdKAQ2ABAACAAAAAgACAAEE gAEAKAAAAFJFOiBTUVIvU1FSMyBRdWVyeWluZyBvbiBEYXRhYmFzZSBWaWV3cwATDQEDkAYARA4A ACgAAAADADYAAAAAAAMAQIAIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAC3DQAAHgBggAggBgAAAAAA wAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOC4wAAMAYYAIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAA AAAACwA7gAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAALAGqACCAGAAAAAADAAAAAAAAARgAA AAAOhQAAAAAAAAMAPYAIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAAwBrgAggBgAAAAAAwAAA AAAAAEYAAAAAEYUAAAAAAAADAG2ACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAB4AfIAIIAYA AAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeAH2ACCAGAAAAAADAAAAAAAAARgAAAAA3 hQAAAQAAAAEAAAAAAAAAHgB+gAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAAIB CRABAAAAaQgAAGUIAAByEwAATFpGdUWmFQ8DAAoAcmNwZzEyNXIyDGBjMQMwAQcLYG6RDhAwMzMP FmZlD5JPAfcCpANjAgBjaArAc4RldALRcHJxMgAAkioKoW5vElAgMAHQhQHQNg+gMDUwNBQh8wHQ FBA0fQdtAoMAUAPU+xH/EwtiE+EUUBOyGPQU0BsHEwKDMw5QEZ0yMzjFF1QgB20gQ0UaBA/ATxqO FEAbrxy1eXIaBDW5EY4xNhYxHv8DgkcJ0eprGgQ2IO82GmEiPwOC1lQIcBoENyRPOCQxJZ/1A4JC B0B0DeAaBBuRFmz3G3gHEx0HOSr/HrcslSBV3jQWPyHoLJQjiDQaYTBO9yVmLJQm5jQdkTBNKJcs lFcqJgKRCOY7CW8wOL9l/Q4wNTnqOwE6vzvJOdQ78n86Xz4vPe09bzufOe8QYDL+OEO6RNFEj0WZ OdRFwkQv30f/R71HP0VvSTQ5DlBMhA9N4UYDTeACgnN0eWx1B5BoCeB0AAATUAPwZChjdGwKsVxQ OGFkzGp1T1AFEGdoBUIwEh0MAWMJwFBAAzBzbmW+eBcwB7AFsADAAnNzAFBYc2IyFFBPQGET8Fz6 awngcAuQUB9QgwhgUHD1C4BlT4B2V0ABQFF7DDDfUkQbkFUgBKALgGdF0VLG9GJhFxBkAiBTgFMm T7DzUXBZcSAxTxMOUFR/VY//Vp8AUVfcAKBSTlpfW2ZPBP8PwFxvXX9ejw5QV89g72H/7VuTMwKC ExBjVEBpgVFwJ1uQKlBXcCBEARBhdSkqQCBQCsBhCcBhcDhoIEYCIVQEINFpLX0PkDgBQFcQbhNk 71CDYj0LIHIJUHAyFqBwMnc0+0MhFwBwAdBrUlGfaH9phm9tsGxwBRACMC1tEANhOoUpEG91kFN1 YmoFkIJ0dZBEYXRlOlQE/yQxbf9vD3AfcS9yN0+gW4O/DiFpgViWDlBzT3ReUldh+RcBIEhbcQSQ VAQncXdv/3h/eY96m1bve58PkIdQCNDyYgqwdDhn2g9UY/B9n89+pofgf7ALUHkvbSB6kPsLEYAl c1QEG5GBL4I/g0//ep9yP4lPil+LZHWydVR2ie8tcI2vUS+HhDmRf5KPmIDwRG9jdQeAAjAF0Gzg vzfhlrKWEJZQjzEBgG52EH8AYAnwa4Ca4AIBU8B8MmWXAPCa4E9gcDxgXHYIkPR3awuAZB7AnoIE 8AdAfxBhAUAOAI8CW2Kf5QIQb+8FQhchEvJ2oG0LUXagHQCoOlxcdOBvbMFtbRA3AxAHkKKQTQ3g A2Bzb7kBgCBPASAN4J3QXKRG1kUAwAMQLmlQdJuwFxB3llBTAYVSeGQRpgJsFGPPAyAS8wCABZBs dl+BZLD/DnBTwKfiAZAAIKhyntGbIf8BwafhFuAPcAAAZLAM0AGQ/CAuN/Kn2A5QqJIqQJag/6kP qh+rLw/AZLAFgazPrd/tru9sHsBksGysj7FPslU+KatcINCwL7UPskRiIP4oApG2L6gjJDCz37if ua//ur+oUCdwvAKo371vvn+rXP8bkLwPwY/Cn8OvqFAtcMCP/8Yfxy/INAr5AzCWD5cfmK2oe1No CGBsUwB3BbCQaywgeQhgIG3Po8040C0W0AWQayCeQFPAnQQBaQIgBCACICB0T7BmIJ6C09BvIAuA p4B1QwEA09NTUVIgCQBnB82Rz2AEkC4gIEkg/6MBE1AFQGwg0gCFUArBA/C70+CbUXgHcNSA0QB3 f8IuLgqFCoV/sGcLEXMs/djcQjjQAjAKhcz0zb/OzzkFQHtioeMXIAIgQHD1pVEuBbBn2Nzb1oVQ yvI/3F/dbwjBUtJTgBLyYmvkbWvKAyBfm2ADEHaB6GF9LeWiT8+RC4AswfZNB5BkMGfScOWi22vN Vv+A3Y0A4V+On4+vhR+GL4c/n4hP0JTjpnVTDIIgVwsRD9Ggm2AAIM2RW1NNVCxQOgDA8xIui3JA SQBULk5FV1NJToH0kENPLlVLXedP/+hUjJvpj+qf66+Qn9AcDCF/47UGYAIw8jQ4AvGW+EBhqnnR oEoAcHUKwHljQAY00aBN0Dk3IDg6ew5ALIBN22b86XWx/e1N72xBBSBPgNJRYwUgCJAQ8D3TkWbV kBaAoTDVYS1V8FNFUlMA3/1xdgX97cXVYS/VYTMgUQpQ/6DPW6LTseVSaRIgVp8y9Z9/zZLhH+Iv +5/QowV447VDuxzhCBcnE3BPgAxAJ9bwuyEB1oAg/wAJhZ6CP9jNjk3/sH/S02EocykEUsfVYjgw mxAgYnWc8E+AB9FB16LT4k1BWElN/k+bUXUBOVD/YKSAm1HmQP/m0JsS4CVsgNLA5sHWQNZw/zDA a9ENoRWx1HERBBF21CT/MMChMBlFyaBbcHagUwAbkf/T4eAlEfftU9GgFWAbogOxBmVrwrKgJ1RB QkwCRdazQ1JFQVRFZkQRYNViRXIkYNi+SX8XETjQT1BZcYsQ0aAWOUH+cKIQo7B2kNNhGVHTkJ8j /9Oia6DTkAmBT4HRoP9gUwC/1WHgJZ9wzaAaStPhbRki7daVczTwolB3T7DT4dmQ/9PiJDGfgKLQ G2TVJeAlgAB3o2DUkNOQcCkRixAEgW7/ZIAZ8xY5bOAkB9jNi0HUkfedUiRE1nNyFXBZYhHB1WD+ TDeAgAER9hLe/2D/sBtx/yzQ05CdUSYh/7BPsA0A2Mbj2bUTVi5KLvKSE1Yjhe3mQXlPUOAlUzgB ofDTkNtsAO1xb98w2zhOJQIiQ3/mQCRS5lE6QuBQ0vHTkEzvpiDYxqHwpWEgdZDzymugbi5TQJ9Q dQEuFRDgJVQTHkB1kCAwgOAxLTeAODItNjM4OeAl7dcAeHWQP7g0dyDkJpzhE+T54CZ9AEQQAAAA AwAmAAAAAAADAC4AAAAAAAsAAgABAAAACwAjAAAAAAALACkAAQAAAAIBMQABAAAAQwEAAFBDREZF QjA5AAEAAgCKAAAAAAAAADihuxAF5RAaobsIACsqVsIAAEVNU01EQi5ETEwAAAAAAAAAABtV+iCq ZhHNm8gAqgAvxFoMAAAAU1JWVUtURVNUAC9vPVBob3RvIE1hcmtldGluZyBBc3NvY2lhdGlvbiBJ bnRsLi9vdT1QTUEvY249UmVjaXBpZW50cy9jbj1CcmVudFQALgAAAAAAAABmPzQfvUPQEZAeAKDJ EhCmAQBB+qDwNkLQEZAWAKDJEhCmAAAAACcnAAAAAAAALgAAAAAAAABmPzQfvUPQEZAeAKDJEhCm AQBB+qDwNkLQEZAWAKDJEhCmAAAAACcoAAAQAAAAZ6JQnvJ10BGQNACgyRIQpigAAABSRTogU1FS L1NRUjMgUXVlcnlpbmcgb24gRGF0YWJhc2UgVmlld3MAAB4AcAABAAAAKAAAAFJFOiBTUVIvU1FS MyBRdWVyeWluZyBvbiBEYXRhYmFzZSBWaWV3cwACAXEAAQAAABYAAAABvAoiNSDTxjdrdgYR0JtJ AKDJEhAuAAADAIAQ/////0AAOQCwa/PjIQq8AQMA8T8JBAAAHgAeDAEAAAADAAAARVgAAB4AHwwB AAAARAAAAC9PPVBIT1RPIE1BUktFVElORyBBU1NPQ0lBVElPTiBJTlRMLi9PVT1QTUEvQ049UkVD SVBJRU5UUy9DTj1CUkVOVFQAAgH5PwEAAABgAAAAAAAAANynQMjAQhAatLkIACsv4YIBAAAAAAAA AC9PPVBIT1RPIE1BUktFVElORyBBU1NPQ0lBVElPTiBJTlRMLi9PVT1QTUEvQ049UkVDSVBJRU5U Uy9DTj1CUkVOVFQAHgD4PwEAAAAQAAAAQnJlbnQgVGVtcGxldG9uAAIB+z8BAAAAYAAAAAAAAADc p0DIwEIQGrS5CAArL+GCAQAAAAAAAAAvTz1QSE9UTyBNQVJLRVRJTkcgQVNTT0NJQVRJT04gSU5U TC4vT1U9UE1BL0NOPVJFQ0lQSUVOVFMvQ049QlJFTlRUAB4A+j8BAAAAEAAAAEJyZW50IFRlbXBs ZXRvbgBAAAcwcBXh4yEKvAFAAAgw4PL04yEKvAEDAAYQw1987QMABxBdAwAAAwAQEAAAAAADABEQ AAAAAB4ACBABAAAAZQAAAFNIT1VMRFdPUkssWU9VTUlHSFRSRS1DSEVDS1BFUk1JU1NJT05TT05U SEVWSUVXVE9JTkNMVURFVEhFU1FSTE9HSU5VU0VSSUFNTk9URkFNSUxJQVJXSVRITUFYSU1PSE9X RVYAAAAAAwANNP0/AAACARQ0AQAAABAAAABUlKHAKX8QG6WHCAArKiUXHgA9AAEAAAAFAAAAUkU6 IAAAAADsng== ------ =_NextPart_000_01BC09F8.4D4024C0-- From owner-sqr-users@USA.NET Fri Jan 24 15:55:12 1997 Date: Fri, 24 Jan 1997 13:06:18 -0500 From: "Brent S. Templeton" Subject: Re: How can this be done?? ------ =_NextPart_000_01BC09F7.B5956450 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Pass in a comma seperated list eg: hr,eng,sales,etc. Write a routine = that puts quotes around the string and pass that into the in clause. Here is this exact procedure from one of my SQR programs. It was = written may years ago and much of the logic could be updated to use the = let statement and other new commands, but it works. Then use the variable in brackets [] for the in clause eg: where field = in [$ql_out_list] =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D begin-procedure quote_list ! takes a comma seperated list and quotes each ql_item ! a,b,c =3D> 'a','b','c' ! ! input $ql_in_list ! output $ql_out_list ! destroys $ql_in_list ! move '' to $ql_out_list move ',' to $ql_dummy concat $ql_in_list with $ql_dummy move $ql_dummy to $ql_in_list concat ',' with $ql_in_list ! ,a,b,c, move 1 to #ql_start_loc move 1 to #ql_loc1 find ',' in $ql_in_list #ql_start_loc #ql_loc2 while #ql_loc2 !=3D -1 move #ql_loc2 to #ql_len subtract #ql_loc1 from #ql_len extract $ql_item from $ql_in_list #ql_loc1 #ql_len if #ql_num_flag !=3D 0 move $ql_item to #ql_tmp move #ql_tmp to $ql_item 099 else move $ql_item to $ql_tmp xxxxx move $ql_tmp to $ql_item end-if string '''' $ql_item '''' by '' into $q_ql_item move #ql_loc2 to #ql_start_loc concat $q_ql_item with $ql_out_list find ',' in $ql_in_list #ql_start_loc #ql_loc1 add 1 to #ql_loc1 find ',' in $ql_in_list #ql_loc1 #ql_loc2 if #ql_loc2 !=3D -1 concat ',' with $ql_out_list end-if end-while end-procedure =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D -----Original Message----- From: Raja Rajaram [SMTP:raja@WISE.COM] Sent: Friday, January 24, 1997 8:52 AM To: Multiple recipients of list SQR-USERS Subject: How can this be done?? Hi All, I have this question. I have a select statement which has an IN clause, = for eg. select emp_iid from emp where dept in ('HR',ENG') This is the problem. I would like to have th IN clause parameters to be = a variable number. I have an upper limit though (say 10) I dont know how = many different Dept's i might have to include. I tried passing all the depts = as a comma seperated string. I UNSTRING them into 10 different variables and = them make them into a string like 'HR','ENG','SALES' (including the ' and , ) = say $Dept. so now the select clause could look like as select emp_iid where dept in ($Dept). This apparently does not work. Does anybody have any suggestion for this = kinda problem? Thanks Raja raja@wise.com ------ =_NextPart_000_01BC09F7.B5956450 Content-Type: application/ms-tnef Content-Transfer-Encoding: base64 eJ8+IiQSAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQmAAQAhAAAANTJBMjUwOUVGMjc1RDAxMTkwMzQwMEEwQzkxMjEw QTYAzwYBBYADAA4AAADNBwEAGAANAAYAEgAFABcBASCAAwAOAAAAzQcBABgADQAGABIABQAXAQEE kAYAsAEAAAEAAAARAAAAAwAAMAAAAAALAA8OAAAAAAIB/w8BAAAAQwAAAAAAAACBKx+kvqMQGZ1u AN0BD1QCAAAAACdTUVItVVNFUlNAVVNBLk5FVCcAU01UUABTUVItVVNFUlNAVVNBLk5FVAAAHgAC MAEAAAAFAAAAU01UUAAAAAAeAAMwAQAAABIAAABTUVItVVNFUlNAVVNBLk5FVAAAAAIB9g8BAAAA BAAAAAAAAAADABUMAQAAAAIBCzABAAAAFwAAAFNNVFA6U1FSLVVTRVJTQFVTQS5ORVQAAB4AATAB AAAAFAAAACdTUVItVVNFUlNAVVNBLk5FVCcAHgAgOgEAAAAUAAAAJ1NRUi1VU0VSU0BVU0EuTkVU JwALAEA6AQAAAAMA/g8GAAAAAwAAOQAAAAADAP9fAAAAAAMA/V8BAAAAHgD2XwEAAAASAAAAU1FS LVVTRVJTQFVTQS5ORVQAAAACAfdfAQAAAEEAAAAAAAAAgSsfpL6jEBmdbgDdAQ9UAgAAAABTUVIt VVNFUlNAVVNBLk5FVABTTVRQAFNRUi1VU0VSU0BVU0EuTkVUAAAAAPxJAQ2ABAACAAAAAgACAAEE gAEAGwAAAFJFOiBIb3cgY2FuIHRoaXMgYmUgZG9uZT8/AHQIAQOQBgCEEAAAKAAAAAMANgAAAAAA AwBAgAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAALcNAAAeAGCACCAGAAAAAADAAAAAAAAARgAAAABU hQAAAQAAAAQAAAA4LjAAAwBhgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAALADuACCAGAAAA AADAAAAAAAAARgAAAAADhQAAAAAAAAsAaoAIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwA9 gAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADAGuACCAGAAAAAADAAAAAAAAARgAAAAARhQAA AAAAAAMAbYAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAAHgB8gAggBgAAAAAAwAAAAAAAAEYA AAAANoUAAAEAAAABAAAAAAAAAB4AfYAIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAA AAAeAH6ACCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAAAgEJEAEAAADDCgAAvwoA AEoaAABMWkZ1EJm6aQMACgByY3BnMTI1cjIMYGMxAzABBwtgbpEOEDAzMw8WZmUPkk8B9wKkA2MC AGNoCsBzhGV0AtFwcnEyAACSKgqhbm8SUCAwAdCFAdA2D6AwNTA0FCHzAdAUEDR9B20CgwBQA9T7 Ef8TC2IT4RRQE7IY9BTQGwcTAoMzDlARnTIzOMUXVCAHbSBDRRoED8BPGo4UQBuvHLV5choENbkR jjE2FjEe/wOCRwnR6msaBDYg7zYaYSI/A4LWVAhwGgQ3JE84JDEln/UDgkIHQHQN4BoEG5EWbPcb eAcTHQc5Kv8etyyVIFXeNBY/IegslCOINBphME73JWYslCbmNB2RME0olyyUVyomApEI5jsJbzA4 v2X9DjA1Oeo7ATq/O8k51DvyfzpfPi897T1vO5857xBgMv44Q7pE0USPRZk51EXCRC/fR/9HvUc/ RW9JNDkOUEyED03hRgNN4AKCc3R5bHUHkGgJ4HQAABNQA/BkKGN0bAqxXFA4YWTManVPUAUQZ2gF QjASHQwBYwnAUEADMHNuZb54FzAHsAWwAMACc3MAUFhzYjIUUE9AYRPwXPprCeBwC5BQH1CDCGBQ cPULgGVPgHZXQAFAUXsMMN9SRBuQVSAEoAuAZ0XRUsb0YmEXEGQCIFOAUyZPsPNRcFlxIDFPEw5Q VH9Vj/9WnwBRV9wAoFJOWl9bZk8E/w/AXG9df16PDlBXz2DvYf/tW5MzAoITEGNUQGmBUXAnW5Aq UFdwIEQBEGF1KSpAIFAKwGEJwGFwOGggRgIhVAQg0WktfQ+QOAFAVxBuE2TvUINiPQsgcglQcDIW oHAydzT7QyEXAHAB0GtSUZ9of2mGb22wbHAFEAIwLW0QA2E6hSkQb3WQU3ViagWQgnR1kERhdGU6 VAT/JDFt/28PcB9xL3I3T6Bbg78OIWmBWJYOUHNPdF5SV2H5FwEgSFtxBJBUBCdxd2//eH95j3qb Vu97nw+Qh1AI0PJiCrB0OGfaD1Rj8H2fz36mh+B/sAtQeS9tIHqQ+wsRgCVzVAQbkYEvgj+DT/96 n3I/iU+KX4tkdbJ1VHaJ7y1wja9RL4eEOZF/ko+YgPBEb2N1B4ACMAXQbOC/N+GWspYQllCPMQGA bnYQfwBgCfBrgJrgAgFTwHwyZZcA8JrgT2BwPGBcdgiQ9HdrC4BkHsCeggTwB0B/EGEBQA4AjwJb Yp/lAhBv7wVCFyES8nagbQtRdqAdAKg6XFx04G9swW1tEDcDEAeQopBNDeADYHNvuQGAIE8BIA3g ndBcpEbWRQDAAxAuaVB0m7AXEHeWUFMBhVJ4ZBGmAmwUY88DIBLzAIAFkGx2X4FksP8OcFPAp+IB kAAgqHKe0Zsh/wHBp+EW4A9wAABksAzQAZD8IC438qfYDlCokipAlqD/qQ+qH6svD8BksAWBrM+t 3+2u72wewGSwbKyPsU+yVT4pq1wg0LAvtQ+yRGIg/igCkbYvqCMkMLPfuJ+5r/+6v6hQJ3C8Aqjf vW++f6tc/xuQvA/Bj8Kfw6+oUC1wwI//xh/HL8g0CvkDMJYPlx+Yrb57bIAEEc2RsqAFoG0AwP4g FxCeQGygdqBTAIVQT1CIIGVndZBociwJ8DxnLGQwT4HTQKdwLiD8IFcFEKJBsqADYIUwhWFsIHQW 4AVAcIUwBCBx/nWhIAeRCsAIYJzw1UETgP/PcluxAHBTAAqwBBHVU3UBvm/Ww82Rp4BsMBcQLgqF /wqFgDA40NEw1/LawVNQANB31YEDYKSAZAhwE4ADUiBHAiATgKQAIG15BgBR1lLbkqLic9QhSQVA i3B9BCB31GF2oAOgAMDdEHm3W3AXANFgZ9iQ14JtDnDvbQDc0dbSCQBnDeDRgWxAxVMAYhOAdXBk 0kPYgf/ZUeCkFyDXAXaRmxPXgqEg/0+wBcBTQAfg0ZOc8NPQ4aBvhTDRMN4xBbBr3eDZnFT3T7AD oOKWdgrABzACYNjTz48AANBkgNXBW13cMAWx+9i70tN35FHcIQiQ4YHNkaBbJHFsX4UhX9KS+l0K hT3tH+4v7z/v+dmcb8z0zb/OzwVAe+Gw4RBuXi3bqNXz7EPZnCHVQGH/ZIDWQdGP0pPXgtX1W3Dg UQvr4dRxbfanYSxiLAHhMD0+ICdhJyzkJ2L7sWMn9qb2pwuA/dWhIOvSC4D16vcQhSH9ds/sFvan DyDPcW95BCD9v+f8pwRga9EnJ+JS/28Cxm/7wANW2/D30HkKheFQbv+fcP2b3kBroG0ABY4C4wWH vwNW/fwGhQUSB7f9/iz7A9Ys2ZwCejHiUiPr4coD3+xAmuAO3w/iEIExBhWMsL/WoQUS65EG+g/r EbYy2ZzP6tCjQRUH9wA9IIzQ2Zy/1DAC4xbXEZY5UBgnc3YA/8+A22IRxtw0GcwYJ1NRGwO/DEOh 4dw0E34bkxnOadzg4w/iqKBtX2aIsFvAF2HeMBgnGJUeJw+1dKIAIp5HJFUJ5x5yMDk5HRhs34AA Ip8jqevSJgJ4KkIoD+8l3/pmHYGc8C0hUBe+1xXvAzADMR4nLyNi3RADMdhj/evQXyxeGL8P7xf6 BocxJv8HqP+tMacSvxPPFNkSNtQw/2txEW837zj/IAgVbyE3Fx9/KGILTzafLS4tUhZz8XZ7/y1S 26fsr0i/Sc9K3/Af8Zv/hVDK8vJv839tgFLDU4Cnsphia23mEMoSIF+bYKOlcHaBYX0tUmJPZ4Gf 65CfgJtQ92BkMGdlUmP/8XvNVoDdjQBOH46fj6+FH/+GL4c/iE/QlFBmdVOh0OgwOX+gYWqyoF9S ovJbUzBNVFA6bKBfcEBXgElTRS5DT03slv9UfoybVk9XX1hvkJ/QHFyB/VB1U5shXvTMMV5HZBDf IPXlUErf8HUGUN0QiRDlUIGV0Dk3IDg6NRlwvEFNRldoyJSRab1Np1HuaaIQEVDakGNvMJ6QzHBP 93Dc0dKT3TEtVWDwUt5TbK9pQXYFab1IY/D3oI/f8Nrk4bF+YWU/P2Fvf82STd9O72dv0KNxSHN2 ablscGxsDebeENMQYQMB99rz1fAAwWl+cNQgfBX38v/jEBsh41gWceBR2CD3cc2g/ElO2RXlUOly 0uDZjX4F/6Hx+iB3IBJG3FKh8RYH2oKNyrBw2ELHoCdIUvuw4EVORycp5k7bEdrD9xFQ26HoQW19 UuXg4XJZ0P/3UOJSfDV/2NexovGhcIwBe+JS4bFhBhXn9yHB4bBy231Y51Fw0hHSgW3lsdgQv/+g l+DHoFNw3RBbwCl8AfuS0aEwa3bx0xBz8eUBBgavW4Ck0NqBmzFEhJEn0SG/3PCX03w02JDrkKeA dcqw/31SeKHSYdfC10N7YNbDhII/93H3cQYX99zXFH1SVU7oU1RSf+BH1sKjENhj/1vAkKnn9n+S 1rP6ZqVQiILfmCf38dckiGOFEyeFYvvAoFNBTEVTA0AoksT/10LW0gNA3/LlUI7gjoEGFf4kkVLU IKPw5IBz8dbTfhTn6iXhVODwb2uIVNEAgX+3goKEHqBDKdmGhpNhjVD7DjDjsWzdEHTg92F28OXE jdQgRKeikBFib2TdEPeMxd0QGsBnU5B9A+ll2xH+a8qRixaHVXU25rff8OYQ/wYVX1IGFWCDB7DZ YfexUOYnLVFRufF2fQCxkAADACYAAAAAAAMALgAAAAAACwACAAEAAAALACMAAAAAAAsAKQABAAAA AgExAAEAAAA2AQAAUENERkVCMDkAAQACAIoAAAAAAAAAOKG7EAXlEBqhuwgAKypWwgAARU1TTURC LkRMTAAAAAAAAAAAG1X6IKpmEc2byACqAC/EWgwAAABTUlZVS1RFU1QAL289UGhvdG8gTWFya2V0 aW5nIEFzc29jaWF0aW9uIEludGwuL291PVBNQS9jbj1SZWNpcGllbnRzL2NuPUJyZW50VAAuAAAA AAAAAGY/NB+9Q9ARkB4AoMkSEKYBAEH6oPA2QtARkBYAoMkSEKYAAAAAJycAAAAAAAAuAAAAAAAA AGY/NB+9Q9ARkB4AoMkSEKYBAEH6oPA2QtARkBYAoMkSEKYAAAAAJygAABAAAABSolCe8nXQEZA0 AKDJEhCmGwAAAFJFOiBIb3cgY2FuIHRoaXMgYmUgZG9uZT8/AAAAHgBwAAEAAAAbAAAAUkU6IEhv dyBjYW4gdGhpcyBiZSBkb25lPz8AAAIBcQABAAAAFgAAAAG8CiGdL9PGN2Z2BhHQm0kAoMkSEC4A AAMAgBD/////QAA5ABDFA0whCrwBAwDxPwkEAAAeAB4MAQAAAAMAAABFWAAAHgAfDAEAAABEAAAA L089UEhPVE8gTUFSS0VUSU5HIEFTU09DSUFUSU9OIElOVEwuL09VPVBNQS9DTj1SRUNJUElFTlRT L0NOPUJSRU5UVAACAfk/AQAAAGAAAAAAAAAA3KdAyMBCEBq0uQgAKy/hggEAAAAAAAAAL089UEhP VE8gTUFSS0VUSU5HIEFTU09DSUFUSU9OIElOVEwuL09VPVBNQS9DTj1SRUNJUElFTlRTL0NOPUJS RU5UVAAeAPg/AQAAABAAAABCcmVudCBUZW1wbGV0b24AAgH7PwEAAABgAAAAAAAAANynQMjAQhAa tLkIACsv4YIBAAAAAAAAAC9PPVBIT1RPIE1BUktFVElORyBBU1NPQ0lBVElPTiBJTlRMLi9PVT1Q TUEvQ049UkVDSVBJRU5UUy9DTj1CUkVOVFQAHgD6PwEAAAAQAAAAQnJlbnQgVGVtcGxldG9uAEAA BzCQ8cmUIAq8AUAACDAQxQNMIQq8AQMABhA6U4pVAwAHEHcHAAADABAQAAAAAAMAERAAAAAAHgAI EAEAAABlAAAAUEFTU0lOQUNPTU1BU0VQRVJBVEVETElTVEVHOkhSLEVORyxTQUxFUyxFVENXUklU RUFST1VUSU5FVEhBVFBVVFNRVU9URVNBUk9VTkRUSEVTVFJJTkdBTkRQQVNTVEhBVElOVAAAAAAD AA00/T8AAAIBFDQBAAAAEAAAAFSUocApfxAbpYcIACsqJRceAD0AAQAAAAUAAABSRTogAAAAAGTd ------ =_NextPart_000_01BC09F7.B5956450-- From owner-sqr-users@USA.NET Sat Jan 25 05:02:42 1997 Date: Sat, 25 Jan 1997 09:11:47 +0000 From: Harry Subject: Inout field limitation using SQR with MAXIMO 3.0A I have just started to code a set of reports for a client who is using MAXIMO 3.0A. I am using SQR 3.0.7.1 . The reports I am writing require a number of fields to be input by the user. MAXIMO appears to cater for a maximum of four fields, and after that the standard SQR prompt boxes are used. i) Is it possible to increase the number of prompts offered by Maximo ? ii) Is it possible to carry out any validation on the data input through these MAXIMO prompts - including if possible the ability to write error messages to the user ? iii)I would be interested to hear from anybody who has used SQR to code reports of any complexity for MAXIMO. Thanks Harry From owner-sqr-users@USA.NET Sun Jan 26 12:09:14 1997 Date: Sun, 26 Jan 1997 11:55:48 -0500 From: "\"Fernando Villaamil" Subject: Re: How can this be done?? In a message dated 97-01-23 22:19:33 EST, you write: << Hi All, I have this question. I have a select statement which has an IN clause, for eg. select emp_iid from emp where dept in ('HR',ENG') This is the problem. I would like to have th IN clause parameters to be a variable number. I have an upper limit though (say 10) I dont know how many different Dept's i might have to include. I tried passing all the depts as a comma seperated string. I UNSTRING them into 10 different variables and them make them into a string like 'HR','ENG','SALES' (including the ' and , ) say $Dept. so now the select clause could look like as select emp_iid where dept in ($Dept). This apparently does not work. Does anybody have any suggestion for this kinda problem? Thanks Raja raja@wise.com >> Raja, Why don't you load the departments into a lookup table and reference it every time you need it. Fernando Villaamil Miami Herald Publishing Co. From owner-sqr-users@USA.NET Sun Jan 26 15:29:44 1997 Date: Sun, 26 Jan 1997 15:16:03 -0500 From: Nathan Treadway Subject: Re: SQR3 on WIN-NT > We are going to migrate to WIN-NT this summer. > I currently use SQR3, will SQR work in NT? Yes, there is a 32-bit version of SQR3 for Win NT, at least for most databases. SQR4 for Win NT is also in production now, or at least will be soon. I just looked at the website but it seems they are not publishing actual availablity information there. Still, you might find what you need from http://www.sqribe.com/products/sqravail.htm . Nathan p.s. Note that MITI just changed its name to "SQRiBE Technologies". ---------------------------------------------------------------------------- Nathan Treadway | Ray Ontko & Co. | info@ontko.com (auto-reply server) nathant@ontko.com | Richmond, IN | ftp.ontko.com, http://www.ontko.com/ From owner-sqr-users@USA.NET Mon Jan 27 10:49:33 1997 Date: Mon, 27 Jan 1997 10:15:37 -0500 From: "Goodwin, Melissa" Subject: SQR To whom it may concern: I am a technical recruiter for the Maxim Group, an information technologies consulting firm. I have an opportunity in the Harrisburg, PA area for a programmer with experience in Sybase, Visual Basic, and SQR. I am having a difficult time trying to find anybody with experience in SQR. Therefore, I am hoping you will be able to assist me. If you know of anyone who would be interested in a position with these skills, I would appreciate any names. Also, if you know of any other terms I could use to look up people who would have SQR experience, I would appreciate those. Please feel free to forward this message to anyone you might know who could help. I really appreciate it. Thank you for your time and I look forward to hearing from you. Sincerely, Melissa Goodwin email: mgoodwin@maximgroup.com Technical Recruiter http://www.maximgroup.com 2605 Interstate Drive Ste 260 Phone: (800)206-2639 Harrisburg, PA 17110 Fax: (717)652-1394 From owner-sqr-users@USA.NET Mon Jan 27 11:55:15 1997 Date: Mon, 27 Jan 1997 11:14:19 -0500 From: DEPUY@SGENAA.CC.GENESEO.EDU Subject: SQR3 problem Good Morning, I have a report that was previously running ok on VAX/VMS with Oracle version 6 and SQR 2.5. We have recently moved to a Digital Alpha with Oracle version 7 and SQR V3.0.12.1. The problem with the report is it is creating an SPF output file instead of a .lis file. The program does this eventhough no KEEP or NOLIS flags have been used. It even overrides the -F flag where the name of the output file is specified as XXXXX.lis. It also overrides the new-report command. Any assistance you can provide will be greatly appreciated. Glenn DePuy SUNY Geneseo Depuy@sgenaa.cc.geneseo.edu From owner-sqr-users@USA.NET Mon Jan 27 17:55:56 1997 Date: Mon, 27 Jan 1997 14:38:57 -0800 From: "Jeffrey S. Buckley" Subject: Re: SQR3 on WIN-NT Yes... it works with NT. At 09:38 AM 1/23/97 -0800, you wrote: >We are going to migrate to WIN-NT this summer. >I currently use SQR3, will SQR work in NT? > > From owner-sqr-users@USA.NET Mon Jan 27 19:35:02 1997 Date: Mon, 27 Jan 1997 15:38:51 -0800 From: Raja Rajaram Subject: Hi.. Hi All, I am trying to generate reports with bitmaps in it. The bitmap files themselves are not static, so I use the print-image command. I am facing this problem the bitmap sometimes overruns the footer of my report. Is there anyway in which SQR can print the image on the top line of the next page is it cannot fit in the present page?? Thanks Raja raja@wise.com From owner-sqr-users@USA.NET Mon Jan 27 20:09:39 1997 Date: Mon, 27 Jan 1997 18:54:43 -0600 From: danian liu Subject: No enuf room for image printing ... Raja, You may want to try NEXT-LISTING command with NEED={int_var} option. You can refer to pg. 247 if you are using SQR3 Workbench User's Guide. Hope this helps, danian liu dliu@uhc.com -- There is no future in time travel. > Hi All, > I am trying to generate reports with bitmaps in it. The bitmap files themselves > are not static, so I use the print-image command. I am facing this problem the > bitmap sometimes overruns the footer of my report. Is there anyway in which SQR > can print the image on the top line of the next page is it cannot fit in the > present page?? > > > Thanks > Raja > raja@wise.com From owner-sqr-users@USA.NET Mon Jan 27 23:23:02 1997 Date: Mon, 27 Jan 1997 17:08:04 -0800 From: "J.J. Freitag" Subject: Re: 32-bit version of SQR Viewer ------------247F7A517D9A11 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii Raymond, We have a 32 bit viewer in development. We will likely release it in March. J.J. Freitag Product Manager SQRIBE Technologies (formerly MITI) jfreitag@sqribe.com ------------247F7A517D9A11 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset=us-ascii
Raymond,
 
We have a 32 bit viewer in development.  We will likely release it in March.
 
J.J. Freitag
Product Manager
SQRIBE Technologies (formerly MITI)
jfreitag@sqribe.com 
------------247F7A517D9A11-- From owner-sqr-users@USA.NET Tue Jan 28 11:51:57 1997 Date: Tue, 28 Jan 1997 08:21:45 -0800 From: Marcos Rodrigues Subject: Re: 32-bit version of SQR Viewer J.J. In the new development are we going to have a SQR Viewer 4.0 user object in 16-bit and 32-bit for the PowerBuilder extension? Regards, Marcos J.J. Freitag wrote: > > Raymond, > > We have a 32 bit viewer in development. We will likely release it in > March. > > J.J. Freitag > Product Manager > SQRIBE Technologies (formerly MITI) > jfreitag@sqribe.com From owner-sqr-users@USA.NET Tue Jan 28 14:38:16 1997 Date: Tue, 28 Jan 1997 13:00:00 -0500 From: Michael Docteroff Subject: Position available Any independent consultant/contractor with SQR, SQL*Forms 3.0 interested in a position in Central New Jersey please contact me at 609-716-3233 or fax a resume to 201-364-0411. Michael Docteroff M.A.D. Technologies, LLC From owner-sqr-users@USA.NET Wed Jan 29 04:22:28 1997 Date: Wed, 29 Jan 1997 09:14:40 PST From: Semech@POBOX.COM Subject: Re: SQR3 problem Hi, Do you know about convertor from RPT (old oracle report writer) to SQR ? And maybe about PL/1 to SQR ? Thanks in advance, Arnon Oppenheimer ------------------------------------- Semech Software Marketing LTD. Phone : 972-3-5333144 Fax : 972-3-5333132 Email : semech@pobox.com Date: 29/1/97 Time: 09:14:40 AM ------------------------------------- From owner-sqr-users@USA.NET Wed Jan 29 07:37:38 1997 Date: Wed, 29 Jan 1997 13:24:31 +0100 From: "Stephane Rognon (ok)" Subject: Encode <0> My problem is about non-display character. When I try to encode '<1>' into a variable that works fine. But when I try to encode '<0>' my output file doesn't contain any value. My source code is : begin-report encode '<0>' into $pp print $pp (,) end-report Do I make a mistake ? Is there another way to put '<0>' into my output file ? Best regards Stephane Rognon FINACOR 52 champs elysees 75008 Paris Tel 33140741796 Fax 33142892549 Rognon@elysees.finacor.fr Rognon@city.finacor.co.uk Rognon@finacor.com www.finacor.fr www.finacor.co.uk www.finacor.com From owner-sqr-users@USA.NET Wed Jan 29 08:59:18 1997 Date: Wed, 29 Jan 1997 08:48:17 -0500 From: Nathan Treadway Subject: Re: Encode <0> > My source code is : > begin-report > encode '<0>' into $pp > print $pp (,) > end-report > > Do I make a mistake ? > Is there another way to put '<0>' into my output file ? > No, you are doing the right thing, but it won't work. The problem is that SQR uses 0-terminated strings internally. So, when you encode a 0, the string handling routines treat that as an end-of-string marker and truncate the string at that point. I know of two work-arounds for this problem. One is to write an external routine that does what you need and then link that into SQR. (See UCALL and UFUNC in the SQR manual for more information.) The other is to choose some other character to act as a placeholder and then run a filter on the output file after SQR writes it. For example, you could output a # where ever you needed a 0, and then run (on Unix) something like "tr '#' '\0'" on the output file. (Note that not all version of tr can handle 0s.) You can even fire off the tr command (or whatever) from within SQR with a "call system using" command. Hope this helps. Nathan ---------------------------------------------------------------------------- Nathan Treadway | Ray Ontko & Co. | info@ontko.com (auto-reply server) nathant@ontko.com | Richmond, IN | ftp.ontko.com, http://www.ontko.com/ From owner-sqr-users@USA.NET Wed Jan 29 10:12:08 1997 Date: Wed, 29 Jan 1997 09:55:13 -0500 From: Larry Young Subject: decimal point Quick question. Is there a way, other than hard coding, to use the percent sign as an edit format character? In the print section of my book, it has 'Decimal point' in the description but does not show the character mask. I've tried using the decimal symbol in edit and it does not work. From owner-sqr-users@USA.NET Wed Jan 29 11:42:29 1997 Date: Wed, 29 Jan 1997 11:01:46 -0500 From: Brenda Sherwood Subject: WANT TO LEARN PEOPLESOFT? WANT TO LEARN PEOPLESOFT?????? We publish a weekly email report called "PeopleSoft Opportunities" that highlights current permanent and contract PeopleSoft positions in the marketplace. If you would like to subscribe to this report, send an email with the message "SUBSCRIBE PS_OPS " to brendas@mindspring.com and we will add you to our list. On occasion we have opportunities for SQR programmers in a PeopleSoft environment where PeopleSoft knowledge is not necessary. I currently have two positions for strong SQR programmers that will give you the opportunity to learn PeopleSoft and will significantly raise your marketability as a programmer. They are: GA - MB1002 - ATLANTA, GEORGIA Position: PeopleSoft Programmer (2) Type: Permanent Start Date: ASAP Duration: Permanent DESCRIPTION: 2 PeopleSoft Programmers needed with experience in PeopleSoft HR/Payroll or Financials with strong SQR experience. Will consider a strong SQR person w/o PeopleSoft as long as they have full life-cycle, client-server development experience. High base salary with great bonus structure. Wonderful benefits. Relocation package available. FL - RB1000 - GAINESVILLE, FLORIDA Position: PeopleSoft SQR Programmer Type: Consulting Start Date: ASAP Duration: 2 months DESCRIPTION: Strong SQR programmer required for PeopleSoft HR implementation. Does not require PeopleSoft experience. Local candidates preferred. Travel is not paid for. If you are interested in discussing either of these positions, please email or fax your resume to us along with the job code of the job(s) you are interested in, your desired salary or hourly rate, the date you are available, and your desired locations. Brenda S. Sherwood Magellan Consulting, Inc. 8046 Roswell Road Suite 101 Atlanta, GA 30350-3930 Phone/Fax: 770-998-2703 Alternate Phone/Fax: 770-993-5739 brendas@mindspring.com From owner-sqr-users@USA.NET Wed Jan 29 12:18:26 1997 Date: Wed, 29 Jan 1997 17:38:52 +0100 From: "Stephane Rognon (ok)" Subject: Re: Encode <0> Thanks for your help Nathan. Is there a easy way to do the replace job using Windows NT ? >-----Original Message----- >From: Nathan Treadway [SMTP:nathant@ONTKO.COM] >Sent: mercredi 29 janvier 1997 14:48 >To: Multiple recipients of list SQR-USERS >Subject: Re: Encode <0> > >> My source code is : >> begin-report >> encode '<0>' into $pp >> print $pp (,) >> end-report >> >> Do I make a mistake ? >> Is there another way to put '<0>' into my output file ? >> > >No, you are doing the right thing, but it won't work. > >The problem is that SQR uses 0-terminated strings internally. So, when you >encode a 0, the string handling routines treat that as an end-of-string >marker and truncate the string at that point. > >I know of two work-arounds for this problem. One is to write an external >routine that does what you need and then link that into SQR. (See UCALL and >UFUNC in the SQR manual for more information.) > >The other is to choose some other character to act as a placeholder and then >run a filter on the output file after SQR writes it. For example, you could >output a # where ever you needed a 0, and then run (on Unix) something like >"tr '#' '\0'" on the output file. (Note that not all version of tr can >handle 0s.) You can even fire off the tr command (or whatever) from within >SQR with a "call system using" command. > >Hope this helps. > > Nathan > > >---------------------------------------------------------------------------- >Nathan Treadway | Ray Ontko & Co. | info@ontko.com (auto-reply server) >nathant@ontko.com | Richmond, IN | ftp.ontko.com, http://www.ontko.com/ From owner-sqr-users@USA.NET Wed Jan 29 15:30:46 1997 Date: Wed, 29 Jan 1997 11:02:52 -0800 From: Angel Guzman Subject: faster select Which of these selects would be more efficient/faster in comparing data from two different databases? from tt_shop where department = $dept and shop in (select master-shop from ldsloc.dbo.tt_shop) ! and exists (select master-shop from ldsloc.dbo.tt_shop ! where master-shop = shop) order by department, division, branch, shop Angel From owner-sqr-users@USA.NET Wed Jan 29 15:35:43 1997 Date: Wed, 29 Jan 1997 14:52:43 -0500 From: Pat Cherundolo Subject: Re: WANT TO LEARN PEOPLESOFT? ------ =_NextPart_000_01BC0DF4.18B30CE0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi Brenda, Jim has me set up with a verbal interview in an hour. If it doesn't work out, keep me in mind for Gainesville. I'll let you know later. Thanks for everything. You PeopleSoft are very nice. ---------- From: Brenda Sherwood[SMTP:brendas@MINDSPRING.COM] Sent: Wednesday, January 29, 1997 11:01 AM To: Multiple recipients of list SQR-USERS Subject: WANT TO LEARN PEOPLESOFT? WANT TO LEARN PEOPLESOFT?????? We publish a weekly email report called "PeopleSoft Opportunities" that highlights current permanent and contract PeopleSoft positions in the marketplace. If you would like to subscribe to this report, send an email with the message "SUBSCRIBE PS_OPS " to brendas@mindspring.com and we will add you to our list. On occasion we have opportunities for SQR programmers in a PeopleSoft environment where PeopleSoft knowledge is not necessary. I currently have two positions for strong SQR programmers that will give you the opportunity to learn PeopleSoft and will significantly raise your marketability as a programmer. They are: GA - MB1002 - ATLANTA, GEORGIA Position: PeopleSoft Programmer (2) Type: Permanent Start Date: ASAP Duration: Permanent DESCRIPTION: 2 PeopleSoft Programmers needed with experience in PeopleSoft HR/Payroll or Financials with strong SQR experience. Will consider a strong SQR person w/o PeopleSoft as long as they have full life-cycle, client-server development experience. High base salary with great bonus structure. Wonderful benefits. Relocation package available. FL - RB1000 - GAINESVILLE, FLORIDA Position: PeopleSoft SQR Programmer Type: Consulting Start Date: ASAP Duration: 2 months DESCRIPTION: Strong SQR programmer required for PeopleSoft HR implementation. Does not require PeopleSoft experience. Local candidates preferred. Travel is not paid for. If you are interested in discussing either of these positions, please email or fax your resume to us along with the job code of the job(s) you are interested in, your desired salary or hourly rate, the date you are available, and your desired locations. Brenda S. Sherwood Magellan Consulting, Inc. 8046 Roswell Road Suite 101 Atlanta, GA 30350-3930 Phone/Fax: 770-998-2703 Alternate Phone/Fax: 770-993-5739 brendas@mindspring.com ------ =_NextPart_000_01BC0DF4.18B30CE0 Content-Type: application/ms-tnef Content-Transfer-Encoding: base64 eJ8+IjETAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAENgAQAAgAAAAIAAgABBJAG ABABAAABAAAADAAAAAMAADADAAAACwAPDgAAAAACAf8PAQAAAEEAAAAAAAAAgSsfpL6jEBmdbgDd AQ9UAgAAAABTUVItVVNFUlNAVVNBLk5FVABTTVRQAFNRUi1VU0VSU0BVU0EuTkVUAAAAAB4AAjAB AAAABQAAAFNNVFAAAAAAHgADMAEAAAASAAAAU1FSLVVTRVJTQFVTQS5ORVQAAAADABUMAQAAAAMA /g8GAAAAHgABMAEAAAAUAAAAJ1NRUi1VU0VSU0BVU0EuTkVUJwACAQswAQAAABcAAABTTVRQOlNR Ui1VU0VSU0BVU0EuTkVUAAADAAA5AAAAAAsAQDoBAAAAAgH2DwEAAAAEAAAAAAAAA5koAQiABwAY AAAASVBNLk1pY3Jvc29mdCBNYWlsLk5vdGUAMQgBBIABAB4AAABSRTogV0FOVCBUTyBMRUFSTiBQ RU9QTEVTT0ZUPwDgBwEFgAMADgAAAM0HAQAdAA4ANAArAAMAYgEBIIADAA4AAADNBwEAHQAOADMA LwADAGUBAQmAAQAhAAAAMkMyRTQ0Q0JCQzc5RDAxMTg5RTQwMEEwMjRCQzYzRjAAKQcBA5AGAKQI AAASAAAACwAjAAAAAAADACYAAAAAAAsAKQAAAAAAAwA2AAAAAABAADkA4E+s/R0OvAEeAHAAAQAA AB4AAABSRTogV0FOVCBUTyBMRUFSTiBQRU9QTEVTT0ZUPwAAAAIBcQABAAAAFgAAAAG8Dh39rMtE Li15vBHQieQAoCS8Y/AAAB4AHgwBAAAAAwAAAE1TAAAeAB8MAQAAABsAAABQSE5JWE1BSUwvQUxM TUFJTC9wY2hlcnVuZAAAAwAGEMLJFOIDAAcQaAcAAB4ACBABAAAAZQAAAEhJQlJFTkRBLEpJTUhB U01FU0VUVVBXSVRIQVZFUkJBTElOVEVSVklFV0lOQU5IT1VSSUZJVERPRVNOVFdPUktPVVQsS0VF UE1FSU5NSU5ERk9SR0FJTkVTVklMTEVJTExMRVQAAAAAAgEJEAEAAAAfBwAAGwcAAKYMAABMWkZ1 4WVBX/8ACgEPAhUCqAXrAoMAUALyCQIAY2gKwHNldDI3BgAGwwKDMgPFAgBwckJxEeJzdGVtAoMz NwLkBxMCgzQDxg/fZjW7A8YUxX0KgAjPCdk7GO94MjU1AoAKgQ2xC2Bu8GcxMDMUUAsKFFEL8oJj AEAgSGkgQhjwUG5kYSwKhUoHcCAXEYAEIAeAIBGxIHVwAiAD8HRoIGEgdjUEkGIHQCALgBPQcnZf CJAH4AuAIEADoGgIYS6YIElmINAFQGRvB5CUbicFQHcFsGsgCGDwdCwgawngH+AfYSGBsm0LgGQg AhAFwEcLcaMHkCEwbGxlIiEnJYA2ICWQBUB5CGAjsG5vVwfgC2AhAS4KhVQRgG7WawQgJMJlIHF5 ICALgIpnIiBZJnFQZW8LUHhlU28BgCBAGPAgYnk6IAMAYyWgCoUKi2xpCDE4MALRaS0xNJ40DfAM 0CzjC1kxNgqg6wNgE9BjBUAtLwcKhy276wwwLoZGA2E6MA4uhgyCOx31BgBoBJAjIARwW1MgTVRQ OmIeE3NAgE1JTkRTUFI1oMBHLkNPTV0vrzC97wZgAjAx7zL7VwmAJTEeQGp5I6BKAHB1CsAqkDJC OSOgMTk5NzwAMWQ6MB2wQU02jzC9VIZvOM8y+011bHQFIPUlkCAY8GMFIAiQAjAEIA8p4CYQBAA4 YVFSLVUwU0VSUzzvN551Yo5qLsE/DzncQU5UJ7CATyBMRUFSTilgCEVPUEgAU09GVOY/Kw8sEzM2 LYcdJS6Gn0ePSJZNk0kcOqAgcEVAy0JRIDJ3CeBrbCqQE+CXC3ADIBjwcBiRIGMHQEslkCSgIil5 T3BQknXnAwBBEAeQIiAgICcACoW5KNBnaCxAU9BB8WMIcPseEQVAcASQA4FUogBwJKD7BaACMHIA 0AVAKXlQkACQ30EQAiAEICGBICBlCoUAwO8jQBHAC1Eq0SAiMiZiIyDfQPAkoCxAI8BS8G8fgEVA /QTyYlpTKMEEIFB0I6ARsP8kkQORUBMKhSADV9EfUQQQBGFnH3AiU1VCU5JDNfBCRSlgU19IgI0F 8DwssBGgdG5hB4DePl+gC2Bf9VLhbwqFNRb9JHJzE1Ao4gWgHwBVgk+g8x/xJfFhZCSgJmJacQhh y0JDKv1PA6BvY1DgAJD/AiBjYhGAIHAjYFIqJLNCof9O8ANgCcBgIAeAEaAhcylpbwqFCfAhMANg bgeAVLF3/zRBH3ApeSaiURFeYVuRJrD/BUAlMCrQXjEooFkiVFZP4ftnAgqFdCMgVvkkwhPAaxHO Z2hvUwJjlGdpZyFkM/td4WdYeW92WoAlkArAA6DvKXpjQmOyAJBnAwAssFDg/27jVgAEAHNDWFYB oAMQdGF7IEAEIGEKhWi4WSEnwGXLeSEY8DpJHEdBLvAF0BpCHBAwEeB8YEFUTBVMIUEjoEdIcFJH SbpBCoVQVxVFoCl5UGjH0CAoMiknVnlU4H8C21UFCoVTAZBQsUQnAUWgsEFTQVBZMIOERAhwNycA ftWBrERIsF7hUFT4SU9ORaAR4H8vaRQlMOcJgFEhIANleFThQcEq0MMhcmnPSFIvUDsQA2D7JfEF sUYLgABwQZAHQAQg7yADcQmIyFkhV2OyVcEAkH8EgSBBcQSCFmiCaTFmoi//WoApegQgGIBxQR8x V9FvFA8ksEDwJgEGkGUtY3neYyWQHmaTkEHCLRGwISDvgFENsCBwGIBwa0ONSx3Q/1PQYbAfMB9x B0A7kiADCcG3cpEG4DtwcwqFcQF1LtD/CHCN0wIgBIGS0WGwCfANwPUgEHNZIVKVUVDgV0JO8P0A 0GteUmcQUDEBoCWRSRzURkx8UVJ8kjB8UXww4zWgSLBWSUxMkCOgnfD5fcBJRH4PKWpocn/YgLv/ CFAAgEDyj1iCn4OuEeAEYP0CMGiYtoWrpIFxL4BRGPD8cXVf0FEhJMIpeYqwCoXfB3ApoWtChDNZ IUQisW1j96nlKWqNS0ybcY5BVYGOoP8nAZi2E1ANwASQGPF6klYA/5VBbTYKsI6gJLIq/VlVKiL/ IOMHkBPQJKAhgbAgBPCYoPsAkKjBZSARgFFCIVfRd+E/VwcjoCmhlxJcygWxZmH2eHgEtQF1H2Fa cZigIEDzkbNdh2pvM6AFoA2wtrXxu6Iocym0NquGtNojoP94Ew2wAJCqMpdVBbEh4neD/xPQI6Bd 0rBCvR2cdyOgVYL/vvubZpsASRwzxiIgNDYKhb5NXlElgAORo4gjoEmJMPMnRixwNDYH8QPgx6EH 8V9j8KQmqhDBkRwQMQqFQU9u8HdRHlB8IiAzHCA18DAtMznMwKAWIeAlMMwvRrlwqFE3N80APCDo OC0yzqAzy4ZBAASRh8GCzdnOlDMtNTfNIH9hX2JqSR9KL0s8CoUYEQAB11AAAwAQEAAAAAADABEQ AAAAAEAABzAAZi7cHQ68AUAACDAAZi7cHQ68AR4APQABAAAABQAAAFJFOiAAAAAARts= ------ =_NextPart_000_01BC0DF4.18B30CE0-- From owner-sqr-users@USA.NET Wed Jan 29 16:10:04 1997 Date: Wed, 29 Jan 1997 15:48:31 -0500 From: Scott McCann Subject: Getting current setting of columns per page Is there a reserved variable name, or any way to extract what the current number of columns are set to for a report? I want to develop a generic heading routine for all reports to look extactly the same and need to position some text X characters from the right side of the page. The declare-report in any of these reports could be using any number of pre-defined layouts. Thanks in advance, --_ Scott _-- From owner-sqr-users@USA.NET Wed Jan 29 17:37:39 1997 Date: Wed, 29 Jan 1997 07:24:36 -0800 From: John Kellogg Subject: Re: SQR3 problem A company called TUSC (The Ultimate Software Company) wrote an RPT to SQR conversion tool several years ago. Contact them at 708-960-2909 to see if it is still available. John L. Kellogg Semech@POBOX.COM wrote: > > Hi, > > Do you know about convertor from RPT (old oracle report writer) to SQR ? > And maybe about PL/1 to SQR ? > > Thanks in advance, > Arnon Oppenheimer > ------------------------------------- > Semech Software Marketing LTD. > > Phone : 972-3-5333144 > Fax : 972-3-5333132 > Email : semech@pobox.com > > Date: 29/1/97 > Time: 09:14:40 AM > ------------------------------------- From owner-sqr-users@USA.NET Wed Jan 29 18:03:18 1997 Date: Wed, 29 Jan 1997 16:27:44 -0500 From: Lynn Francis Subject: faster select -Reply Generally the "exists" format is preferable since the subquery simply needs to find on row to qualify the statement as 'TRUE' . Lynn Francis American Bankers Association >>> Angel Guzman 01/29/97 02:02pm >>> Which of these selects would be more efficient/faster in comparing data from two different databases? from tt_shop where department = $dept and shop in (select master-shop from ldsloc.dbo.tt_shop) ! and exists (select master-shop from ldsloc.dbo.tt_shop ! where master-shop = shop) order by department, division, branch, shop Angel From owner-sqr-users@USA.NET Wed Jan 29 19:12:54 1997 Date: Wed, 29 Jan 1997 15:46:00 -0700 From: "Butterfield, Bruce - Brmfld" Subject: Re: SQR3 problem Yes it is still available Bruce A. Butterfield TUSC consultant ---------- From: John Kellogg To: Multiple recipients of list SQR-USERS Subject: Re: SQR3 problem Date: Wednesday, January 29, 1997 8:24AM A company called TUSC (The Ultimate Software Company) wrote an RPT to SQR conversion tool several years ago. Contact them at 708-960-2909 to see if it is still available. John L. Kellogg Semech@POBOX.COM wrote: > > Hi, > > Do you know about convertor from RPT (old oracle report writer) to SQR ? > And maybe about PL/1 to SQR ? > > Thanks in advance, > Arnon Oppenheimer > ------------------------------------- > Semech Software Marketing LTD. > > Phone : 972-3-5333144 > Fax : 972-3-5333132 > Email : semech@pobox.com > > Date: 29/1/97 > Time: 09:14:40 AM > ------------------------------------- From owner-sqr-users@USA.NET Wed Jan 29 21:01:55 1997 Date: Wed, 29 Jan 1997 19:16:27 -0500 From: Louisa L Tripp Subject: Re: faster select the "in" statement as written is slower, but I'm not sure what happens if you add the "where master-shop = shop" to the "in" subquery. Louisa Tripp Norwich University SysMan/Prog/NWMan/DBA On Wed, 29 Jan 1997, Angel Guzman wrote: > Which of these selects would be more efficient/faster in comparing > data from two different databases? > > from tt_shop > where department = $dept > and shop in (select master-shop from ldsloc.dbo.tt_shop) > ! and exists (select master-shop from ldsloc.dbo.tt_shop > ! where master-shop = shop) > order by department, division, branch, shop > > Angel > From owner-sqr-users@USA.NET Thu Jan 30 00:01:31 1997 Date: Wed, 29 Jan 1997 21:36:10 -0600 From: wesb@HENDRIX.USA.NET Subject: Re: faster select Angel, The IN is definitely the slower of the 2 selects. Another solution to your problem which might be faster is to choose the sub-query as your driving select, and use an SQR procedure for the outer select, as illustrated below. -------------------------------------------------- begin-select DISTINCT master-shop move &master-shop to $master-shop do shop_stuff($master-shop) from ldsloc.dbo.tt_shop .... end-select begin-procedure shop_stuff($shop) begin-select shop ... from tt_shop where shop = $shop .... end-select end-procedure !shop_stuff -------------------------------------------------- I always thought 2 seperate selects done in this way is faster than using a subquery. Perhaps I am wrong? Anyone have any thoughts on this? Wes Bailey Associate Consultant Coopers & Lybrand Consulting 1100 Louisiana St., Suite 4100 Houston, TX 77002 From owner-sqr-users@USA.NET Thu Jan 30 05:44:36 1997 Date: Thu, 30 Jan 1997 11:22:37 +0100 From: "Mansfeld, Fredrik" Subject: Re: Getting current setting of columns per page Hi, I have solved that problem by using the #define statement. I have a couple of general files with such things as headers and footers and other things that the users feels must look the same on every report. I #include those files in all my reports, but before the #include statement I make sure to #define all constants needed, preferably in a file for it self. So the beginning of my reports could look something like this (very much lika a C-file, I know): #include 'MyDefine.dat' #include 'GenHead.dat' #include 'GenFoot.dat' #include 'GenProc.dat' In the MyDefine.dat I have a line that might look like this: #define Columns 120 And in GenHead.dat you find this: Page-Size {Lines} {Columns} This works fine with me. Regards, Fredrik > ---------- > From: Discussion of MITI's SQR database reporting > language[SMTP:SQR-USERS@USA.NET] on behalf of Scott > McCann[SMTP:smccann@IONLINE.NET] > Sent: den 29 januari 1997 21:48 > To: Multiple recipients of list SQR-USERS > Subject: Getting current setting of columns per page > > Is there a reserved variable name, or any way to extract what the > current > number of columns are set to for a report? > > I want to develop a generic heading routine for all reports to look > extactly the same and need to position some text X characters from the > right side of the page. The declare-report in any of these reports > could > be using any number of pre-defined layouts. > > Thanks in advance, > > --_ Scott _-- > From owner-sqr-users@USA.NET Thu Jan 30 11:12:02 1997 Date: Wed, 29 Jan 1997 15:00:11 -0800 From: John Kellogg Subject: Re: Getting current setting of columns per page Scott, You should probably by using a #define variable in each of the layouts so that you can refer to it when printing the text. For example: Include file layout1.inc ------------------------ #define maxcols 75 declare-layout default max-columns = {maxcols} SQR Program ----------- #include begin-setup include 'layout1.inc' end-setup begin-program let #print_position = {maxcols} - 10 print ... John L. Kellogg Scott McCann wrote: > > Is there a reserved variable name, or any way to extract what the current > number of columns are set to for a report? > > I want to develop a generic heading routine for all reports to look > extactly the same and need to position some text X characters from the > right side of the page. The declare-report in any of these reports could > be using any number of pre-defined layouts. > > Thanks in advance, > > --_ Scott _-- From owner-sqr-users@USA.NET Thu Jan 30 14:19:48 1997 Date: Thu, 30 Jan 1997 13:58:05 -0500 From: Toni Iacobo 617-441-2364 Subject: Converting to Local Date-Time Zones on VAX/OpenVMS Hello, I am writing Customer Usage reports for customers in the US, UK, Canada, and Australia. (This list could be expanded in the future.) Our accounting files record event data in the time of the US Eastern time zone. I would like to convert this time into the local time of the customer. We are using SQR on VMS and Sybase. Does anyone know of any resources or have suggestions for handling this? I've seen a set of "time zone" functions on HP-UNIX. They have all the time rules and zone definitions and a "zone" compiler. By setting the appropriate TZ environment variable, you can use the standard C time functions (gmtime, localtime, asctime, etc.) to convert the time. My plan is to try and write a UFUNC function using VAX system routines and logicals to do the same once I find VAX documentation on their time zone rules format and time system services. Does anyone have other suggestions or comments or have tackled this problem before with SQR on the VAX? or know of where this can be found? Thanks in advance for any help, Toni Toni Iacobo Information Access Co. toni_iacobo@iacnet.com From owner-sqr-users@USA.NET Thu Jan 30 17:22:51 1997 Date: Thu, 30 Jan 1997 13:48:49 -0500 From: Shawn Dunn Subject: Duplex printing From owner-sqr-users@USA.NET Fri Jan 31 01:04:02 1997 Date: Fri, 31 Jan 1997 12:07:44 +0800 From: Raymond Yip Subject: composite key in lookup How can I define a composite key in the load-lookup command? Raymond Yip MTRC Hong Kong From owner-sqr-users@USA.NET Fri Jan 31 04:23:01 1997 Date: Fri, 31 Jan 1997 00:18:37 -0600 From: hendrix!wesb@UUNET.UU.NET Subject: Re: composite key in lookup Raymond, Just string together the columns which makeup the composite key: -------------------------------------------------- load-lookup name=salary_lookup table=s_emp key=emp_id||project_id return_value=salary where=salary < 1000000 .... begin-select a.emp_id||b.project_id &key move &key to $key lookup salary_lookup $return_value $key from table1 a , table2 b .... end-select -------------------------------------------------- Wes Bailey Associate Consultant Coopers & Lybrand Consulting 1100 Louisiana St., Suite 4100 Houston, TX 77002 From owner-sqr-users@USA.NET Fri Jan 31 14:03:23 1997 Date: Fri, 31 Jan 1997 10:14:46 -0500 From: Shawn Dunn Subject: Duplex printing From owner-sqr-users@USA.NET Fri Jan 31 14:13:12 1997 Date: Fri, 31 Jan 1997 11:27:00 -0700 From: "Butterfield, Bruce - Brmfld" Subject: Sqr Help Hi Ya'all I have an issue I hope someone may have seen before. We are using SQR v 3.0.5 on a HP server with Oracle v 7. All the output documents are setup for postscript. my problem: at random times when printing out I get the following error : ERROR: undefined OFFENDING COMMAND: @PJL STACK: This error may or not appear when printing out several copies of the same report. We may get the error when printing out an invoice and when the same invoice is printed again it may print ok. We are requesting the latest version of SQR for UNIX but I was hoping for a work-around . bruce From owner-sqr-users@USA.NET Fri Jan 31 15:52:43 1997 Date: Fri, 31 Jan 1997 14:34:02 -0500 From: Shawn Dunn Subject: Duplex printing? Hi All, Sorry about the blank messages - the mail server choked on the text. Anyway, I'll try again - Has anyone had any luck printing duplex forms from within SQR? We're trying to print some loan notes and have the forms designed (both front and back), but can't seem to get the duplex unit to work correctly for this particular application. The printer is an HP 4si and the duplex unit IS working - if I manually change the duplex mode to ON through the control panel, but we don't want to have duplex on all the time. The post script command that I'm using is &l1S to print duplex. I've tried a couple of other things that haven't worked, also. Any ideas? TIA Shawn ------------------------------- Shawn Dunn - SDUNN@MIT.EDU Analyst/Programmer III - MIT Bursar's Office, Cambridge, MA http://web.mit.edu/sdunn/www/ From owner-sqr-users@USA.NET Fri Jan 31 19:11:01 1997 Date: Fri, 31 Jan 1997 18:52:27 -0500 From: Ray Ontko Subject: Re: Duplex printing? > Has anyone had any luck printing duplex forms from within SQR? > > We're trying to print some loan notes and have the forms designed (both > front and back), but can't seem to get the duplex unit to work correctly for > this particular application. > > The printer is an HP 4si and the duplex unit IS working - if I manually > change the duplex mode to ON through the control panel, but we don't want > to have duplex on all the time. > > The post script command that I'm using is &l1S to print duplex. I've tried a > couple of other things that haven't worked, also. > > Any ideas? Shawn, I'm not sure about this, but are you using PRINT-DIRECT to send the command to the printer? Is it preceded by an escape character? You may need to use the ENCODE command to get an escape character onto the front of the escape sequence. Ray ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Time for a new signature line." rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@USA.NET Sun Feb 2 08:26:18 1997 Date: Sun, 2 Feb 1997 08:11:51 -0500 From: "Mark W. Salem" Subject: Numeric Money Conversion to Words Help! I am in desperate need of a solution to converting a numeric money field into its word equivilent; e.g., $1,652.97 --> One thousand - six hundred - fifty - two and 97/100 I am using Oracle on a Unix server with a Window's 95 client... Any suggestions? From owner-sqr-users@USA.NET Sun Feb 2 17:31:43 1997 Date: Mon, 3 Feb 1997 09:10:50 +1100 From: "Xavier K. Lau" Subject: Re: Sqr Help Hi Bruce, you message did not coome through at all ( or maybe my mail server is having some problem ) , do you mind sendind that out again please !! thanks !! -- Xavier K. Lau MITI Asia Pacific Technical Support Engineer E-Mail : xavier.lau@miti.com.au OR support@miti.com.au From owner-sqr-users@USA.NET Sun Feb 2 18:37:30 1997 Date: Sun, 2 Feb 1997 18:19:14 -0500 From: "Mark W. Salem" Subject: Re: Sqr Help Thanks for responding. Here is my question: Help! I am in desperate need of a solution to converting a numeric money field into its word equivilent; e.g., $1,652.97 --> One thousand - six hundred - fifty - two and 97/100 I am using Oracle on a Unix server with a Window's 95 client... Any suggestions? From owner-sqr-users@USA.NET Mon Feb 3 11:29:13 1997 Date: Mon, 3 Feb 1997 10:16:44 -0500 From: Lynn Francis Subject: Re: Sqr Help -Reply You can design two tables to designate first: the alpha equivalents of the digits and secondly the positional multipliers (million, thousand, hundred, etc.) Lynn Francis American Bankers Association >>> "Mark W. Salem" 02/02/97 06:19pm >>> Thanks for responding. Here is my question: Help! I am in desperate need of a solution to converting a numeric money field into its word equivilent; e.g., $1,652.97 --> One thousand - six hundred - fifty - two and 97/100 I am using Oracle on a Unix server with a Window's 95 client... Any suggestions? From owner-sqr-users@USA.NET Mon Feb 3 14:12:23 1997 Date: Mon, 3 Feb 1997 18:35:34 PST From: Semech@POBOX.COM Subject: Re: Numeric Money Conversion to Words Look on spell.inc and ex19a.sqr in the SQR 3 Tutorial ! (ex17a.sqr in SQR 4) Arnon ------------------------------------- Semech Software Marketing LTD. Phone : 972-3-5333144 Fax : 972-3-5333132 Email : semech@pobox.com Date: 3/2/97 Time: 06:35:34 PM ------------------------------------- --- On Sun, 2 Feb 1997 08:11:51 -0500 "Mark W. Salem" wrote: >Help! I am in desperate need of a solution to converting a numeric money >field into its word equivilent; e.g., $1,652.97 --> One thousand - six >hundred - fifty - two and 97/100 > >I am using Oracle on a Unix server with a Window's 95 client... > >Any suggestions? > -----------------End of Original Message----------------- From owner-sqr-users@USA.NET Mon Feb 3 14:19:04 1997 Date: Mon, 3 Feb 1997 11:57:54 -0500 From: Shawn Dunn Subject: Re: Duplex printing? Ray, This is the code that I'm using: encode '<27>&l1S' into $duplex print $duplex (,+1) If I use the print command at the beginning of the program only, I get the output of page 2 written over page 1. If I use the print command at the beginning of the program and where the second page of output starts, I get 2 seperate pages of output. Any other ideas? TIA. Shawn >> Has anyone had any luck printing duplex forms from within SQR? > >I'm not sure about this, but are you using PRINT-DIRECT to send >the command to the printer? Is it preceded by an escape character? >You may need to use the ENCODE command to get an escape character >onto the front of the escape sequence. > >Ray ------------------------------- Shawn Dunn - SDUNN@MIT.EDU Analyst/Programmer III - MIT Bursar's Office, Cambridge, MA http://web.mit.edu/sdunn/www/ From owner-sqr-users@USA.NET Mon Feb 3 14:23:49 1997 Date: Mon, 3 Feb 1997 07:42:04 -0800 From: John Kellogg Subject: Re: Numeric Money Conversion to Words Mark, There is an example in chapter 19 of the SQR3 Language Tutorial. The sample program spell.inc is in the tutorial directory if you have it. If not, here it is: John L. Kellogg SQRiBE Technologies Support Manager ! SPELL.INC 10/23/95 ! ! Copyright (C) 1995, 1996 MITI All Worldwide Rights Reserved ! ! Disclaimer ! ! This program is provided as an example and, while it is thought to be free ! from defect, MITI makes no representations or warranties, either ! expressed or implied, with respect to the adequacy of the program in regard ! to merchantability or fitness for any particular result. The program is ! provided "as is" and the entire risk as to quality and performance is with ! the buyer. In no event shall MITI be liable for special, direct, ! indirect or consequential damages resulting from any defect in this program. ! Some states do not allow the exclusion or limitations of implied warranties ! or liability for incidental or consequential damages, in which case the ! above limitations and exclusions may not apply to you. ! !*************************************************************************** ! ! Modification History: ! ! Date Eng Description ! -------- --- ------------------------------------------------------------ ! (_V3.5.3_) ! 10-23-95 LHS (DEV-4039) ! o Incorporate into V3.5 codeline ! (_V3.5.4_) ! 04-03-96 PAB (DEV-4088) ! o Cleaned up the modification history. ! (_V4.0_) ! 06-04-96 AIK (1355) ! o Incorporate into V4.0 codeline. ! (_EOH_) !*************************************************************************** begin-procedure spell_number(#num,:$str) let $str = '' ! break the number to it's 3-digit parts let #trillions = floor(#num / 1000000000000) let #billions = mod(floor(#num / 1000000000),1000) let #millions = mod(floor(#num / 1000000),1000) let #thousands = mod(floor(#num / 1000),1000) let #ones = mod(floor(#num),1000) ! spell each 3-digit part do spell_3digit(#trillions,'trillion',$str) do spell_3digit(#billions,'billion',$str) do spell_3digit(#millions,'million',$str) do spell_3digit(#thousands,'thousand',$str) do spell_3digit(#ones,'',$str) end-procedure ! spell_number begin-procedure spell_3digit(#num,$part_name,:$str) let #hundreds = floor(#num / 100) let #rest = mod(#num,100) if #hundreds do spell_digit(#hundreds,$str) concat 'hundred ' with $str end-if if #rest do spell_2digit(#rest,$str) end-if if #hundreds or #rest if $part_name != '' concat $part_name with $str concat ' ' with $str end-if end-if end-procedure ! spell_3digit begin-procedure spell_2digit(#num,:$str) let #tens = floor(#num / 10) let #ones = mod(#num,10) if #num < 20 and #num > 9 evaluate #num when = 10 concat 'ten ' with $str break when = 11 concat 'eleven ' with $str break when = 12 concat 'twelve ' with $str break when = 13 concat 'thirteen ' with $str break when = 14 concat 'fourteen ' with $str break when = 15 concat 'fifteen ' with $str break when = 16 concat 'sixteen ' with $str break when = 17 concat 'seventeen ' with $str break when = 18 concat 'eighteen ' with $str break when = 19 concat 'nineteen ' with $str break end-evaluate else evaluate #tens when = 2 concat 'twenty' with $str break when = 3 concat 'thirty' with $str break when = 4 concat 'forty' with $str break when = 5 concat 'fifty' with $str break when = 6 concat 'sixty' with $str break when = 7 concat 'seventy' with $str break when = 8 concat 'eighty' with $str break when = 9 concat 'ninety' with $str break end-evaluate if #num > 20 if #ones concat '-' with $str else concat ' ' with $str end-if end-if if #ones do spell_digit(#ones,$str) end-if end-if end-procedure ! spell_2digit begin-procedure spell_digit(#num,:$str) evaluate #num when = 1 concat 'one ' with $str break when = 2 concat 'two ' with $str break when = 3 concat 'three ' with $str break when = 4 concat 'four ' with $str break when = 5 concat 'five ' with $str break when = 6 concat 'six ' with $str break when = 7 concat 'seven ' with $str break when = 8 concat 'eight ' with $str break when = 9 concat 'nine ' with $str break end-evaluate end-procedure ! spell_digit Mark W. Salem wrote: > > Help! I am in desperate need of a solution to converting a numeric money > field into its word equivilent; e.g., $1,652.97 --> One thousand - six > hundred - fifty - two and 97/100 > > I am using Oracle on a Unix server with a Window's 95 client... > > Any suggestions? From owner-sqr-users@USA.NET Mon Feb 3 16:06:06 1997 Date: Mon, 3 Feb 1997 11:33:26 -0600 From: TOM CHAPIN Subject: Re: Sqr Help (money to words) Cc: attmail!tjchapin (TOM CHAPIN) Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii If you have access to the book "The AWK Programming Language" by Alfred V. Aho, Brian W. Kernighan, and Peter J. Weinberger [Addison- Wesley, 1988], section 3.1, page 75 contains an awk script to convert money to words for a check-writing application. I would expect the algorithm could be converted to other languages if desired. Tom Chapin On Feb 2, 6:19pm, Mark W. Salem wrote: > Subject: Re: Sqr Help > Thanks for responding. Here is my question: > > Help! I am in desperate need of a solution to converting a numeric > money field into its word equivilent; e.g., > $1,652.97 --> One thousand - six hundred - fifty - two and 97/100 > > I am using Oracle on a Unix server with a Window's 95 client... > > Any suggestions? > >-- End of excerpt from Mark W. Salem -- Tom Chapin - attmail!tjchapin = tjchapin@mail.att.net - 314-519-5576 From owner-sqr-users@USA.NET Mon Feb 3 18:06:42 1997 Date: Mon, 3 Feb 1997 14:44:31 -0500 From: Finbar Crean Subject: Training Dear SQR User, We are a SQRIBE certified training partne, and we will be running classes in the Boston area the week of March 17th. and April 21st, and we can also work to your schedule. We limit classes to four participants for greater effectivness. If you are interested in attending, please send an e-mail with contact information. Sincerely, Finbar Crean IDFM, Inc. 131 Middlesex Turnpike, Burlington, MA 01803 (617) 229-7771 x 312 From owner-sqr-users@USA.NET Mon Feb 3 18:11:19 1997 Date: Mon, 3 Feb 1997 10:29:08 -0800 From: Gadi Yedwab Subject: Re: Numeric Money Conversion to Words This is a multi-part message in MIME format. ------=_NextPart_000_01BC11BD.168A8840 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Mark, The code to do exactly that is provided with the SQR3 Language Tutorial book from SQRIBE Technology (formerly MITI, the maker of SQR) see chapter 19. Same is also in the SQR Version 4 User's Guide. The code is also attached here. Gadi Yedwab Chief Technology Officer SQRIBE Technologies gadi@sqribe.com ------=_NextPart_000_01BC11BD.168A8840 Content-Type: application/octet-stream; name="Spell.inc" Content-Transfer-Encoding: quoted-printable Content-Description: Spell.inc (INC File) Content-Disposition: attachment; filename="Spell.inc" ! SPELL.INC 10/23/95 =20 ! ! Copyright (C) 1995, 1996 MITI All Worldwide Rights Reserved ! ! Disclaimer ! ! This program is provided as an example and, while it is thought to be = free ! from defect, MITI makes no representations or warranties, either ! expressed or implied, with respect to the adequacy of the program in = regard ! to merchantability or fitness for any particular result. The program = is ! provided "as is" and the entire risk as to quality and performance is = with ! the buyer. In no event shall MITI be liable for special, direct, ! indirect or consequential damages resulting from any defect in this = program. ! Some states do not allow the exclusion or limitations of implied = warranties ! or liability for incidental or consequential damages, in which case = the ! above limitations and exclusions may not apply to you. ! !************************************************************************= *** ! ! Modification History: ! ! Date Eng Description ! -------- --- = ------------------------------------------------------------ ! (_V3.5.3_) ! 10-23-95 LHS (DEV-4039) ! o Incorporate into V3.5 codeline ! (_V3.5.4_) ! 04-03-96 PAB (DEV-4088) ! o Cleaned up the modification history. ! (_V4.0_) =20 ! 06-04-96 AIK (1355) ! o Incorporate into V4.0 codeline. ! (_EOH_) !************************************************************************= *** begin-procedure spell_number(#num,:$str) let $str =3D '' ! break the number to it's 3-digit parts let #trillions =3D floor(#num / 1000000000000) let #billions =3D mod(floor(#num / 1000000000),1000) let #millions =3D mod(floor(#num / 1000000),1000) let #thousands =3D mod(floor(#num / 1000),1000) let #ones =3D mod(floor(#num),1000) ! spell each 3-digit part do spell_3digit(#trillions,'trillion',$str) do spell_3digit(#billions,'billion',$str) do spell_3digit(#millions,'million',$str) do spell_3digit(#thousands,'thousand',$str) do spell_3digit(#ones,'',$str) end-procedure ! spell_number begin-procedure spell_3digit(#num,$part_name,:$str) let #hundreds =3D floor(#num / 100) let #rest =3D mod(#num,100) if #hundreds do spell_digit(#hundreds,$str) concat 'hundred ' with $str end-if if #rest do spell_2digit(#rest,$str) end-if if #hundreds or #rest if $part_name !=3D '' concat $part_name with $str concat ' ' with $str end-if end-if end-procedure ! spell_3digit begin-procedure spell_2digit(#num,:$str) let #tens =3D floor(#num / 10) let #ones =3D mod(#num,10) if #num < 20 and #num > 9 evaluate #num when =3D 10 concat 'ten ' with $str break when =3D 11 concat 'eleven ' with $str break when =3D 12 concat 'twelve ' with $str break =20 when =3D 13 concat 'thirteen ' with $str break when =3D 14 concat 'fourteen ' with $str break when =3D 15 concat 'fifteen ' with $str break when =3D 16 concat 'sixteen ' with $str break when =3D 17 concat 'seventeen ' with $str break when =3D 18 concat 'eighteen ' with $str break when =3D 19 concat 'nineteen ' with $str break end-evaluate else evaluate #tens when =3D 2 concat 'twenty' with $str break when =3D 3 concat 'thirty' with $str break when =3D 4 concat 'forty' with $str break when =3D 5 concat 'fifty' with $str break when =3D 6 concat 'sixty' with $str break when =3D 7 concat 'seventy' with $str break when =3D 8 concat 'eighty' with $str break when =3D 9 concat 'ninety' with $str break end-evaluate if #num > 20 if #ones concat '-' with $str else concat ' ' with $str end-if end-if if #ones do spell_digit(#ones,$str) end-if end-if end-procedure ! spell_2digit begin-procedure spell_digit(#num,:$str) evaluate #num when =3D 1 concat 'one ' with $str break when =3D 2 concat 'two ' with $str break when =3D 3 concat 'three ' with $str break when =3D 4 concat 'four ' with $str break when =3D 5 concat 'five ' with $str break when =3D 6 concat 'six ' with $str break when =3D 7 concat 'seven ' with $str break when =3D 8 concat 'eight ' with $str break when =3D 9 concat 'nine ' with $str break end-evaluate end-procedure ! spell_digit ------=_NextPart_000_01BC11BD.168A8840-- From owner-sqr-users@USA.NET Mon Feb 3 21:24:31 1997 Date: Mon, 3 Feb 1997 15:15:00 -0800 From: Tai Luong Subject: Re Comparing array element Hi all, Would somebody tell me how to compare an array element with a variable. I have created and loaded the following array, but when I try to compare an array element with the following code SQR gives me an error. Any help will be greatly appreciated! Create-Array Name=camp_array Size=20 Field=camp_code:char:1 Field=camp_desc:char:20 Field=camp_cnt:number:3=0 move 0 to #j while camp_code(#j) not = $cmp_code and (#j < 19 ) add 1 to #arr_idx end-while if camp_code(#j) = $cmp_code array-add 1 2 3 to camp_array(#arr_idx) camp_cnt(0) camp_cnt(1) camp_cnt(2) end-if Tai Luong, Programmer/Analyst City College of San Francisco Voice: 415-452-5050 50 Phelan Avenue, room LB-2 Fax: 415-239-3919 San Francisco, CA 94112 E-mail: tluong@hills.ccsf.cc.ca.us From owner-sqr-users@USA.NET Tue Feb 4 03:02:04 1997 Date: Mon, 3 Feb 1997 19:26:23 -0600 From: Richard Watts Subject: faster select -Reply Hi Angel, I don't know what db your on, but if it is Oracle the answer is "it depends". Since the exists is a correlated sub-query it will be performed for every row of data returned in the main query, following a nested loop execution plan. This is similar to the solution offered earlier, using an SQR cursor based approach and looping through the main query and executing the secondary query, the only difference being where you spend your CPU. For large volume tables the looping approach will almost always be slower. If the list of master shops is shorter than the list of shops then I would implement the 'in' clause, which will cause a sort-join, retrieving a distinct list of master shops first then returning all shops that are master shops. If the second database is remote then there is only one call to it instead of many. >>> Angel Guzman 01/29/97 01:02pm >>> Which of these selects would be more efficient/faster in comparing data from two different databases? from tt_shop where department = $dept and shop in (select master-shop from ldsloc.dbo.tt_shop) ! and exists (select master-shop from ldsloc.dbo.tt_shop ! where master-shop = shop) order by department, division, branch, shop Angel From owner-sqr-users@USA.NET Tue Feb 4 11:31:07 1997 Date: Tue, 4 Feb 1997 14:06:04 +1100 From: "Xavier K. Lau" Subject: Re: Re Comparing array element Your problem lies in the way you have used "not" : > while camp_code(#j) not = $cmp_code and (#j < 19 ) > add 1 to #arr_idx > end-while This is an example that I have used : if not ( #true = #true ) print 'a' (2,1) end-if Also check the example at the bottom of p. 224 of user guide !! -- Xavier K. Lau SQRiBE Technologies Asia Pacific Technical Support Engineer E-Mail : xavier.lau@miti.com.au OR support@miti.com.au From owner-sqr-users@USA.NET Tue Feb 4 11:55:00 1997 Date: Mon, 3 Feb 1997 20:51:56 -0600 From: Richard Watts Subject: Re Comparing array element -Reply Hi Tai, I think your element variables are out of sync. You are incrementing a varaible (#arr_idx) that is not in your test for the while loop (#j). I know one of the ways we do this is the following: size={size} while #j < {size} if camp_code(#j) = $cmp_code array-add 1 2 3 to camp_array(#arr_idx) camp_cnt(0) camp_cnt(1) camp_cnt(2) let #j = {size} else add 1 to #j end-if end-while >>> Tai Luong 02/03/97 05:15pm >>> Hi all, Would somebody tell me how to compare an array element with a variable. I have created and loaded the following array, but when I try to compare an array element with the following code SQR gives me an error. Any help will be greatly appreciated! Create-Array Name=camp_array Size=20 Field=camp_code:char:1 Field=camp_desc:char:20 Field=camp_cnt:number:3=0 move 0 to #j while camp_code(#j) not = $cmp_code and (#j < 19 ) add 1 to #arr_idx end-while if camp_code(#j) = $cmp_code array-add 1 2 3 to camp_array(#arr_idx) camp_cnt(0) camp_cnt(1) camp_cnt(2) end-if Tai Luong, Programmer/Analyst City College of San Francisco Voice: 415-452-5050 50 Phelan Avenue, room LB-2 Fax: 415-239-3919 San Francisco, CA 94112 E-mail: tluong@hills.ccsf.cc.ca.us From owner-sqr-users@USA.NET Tue Feb 4 14:56:42 1997 Date: Tue, 4 Feb 1997 08:07:13 -0800 From: John Kellogg Subject: Re: Re Comparing array element Tai, You are only listing the array element and not the array name in the if statement. If should be like this: while camp_array.camp_code(#j) not = $cmp_code and (#j < 19 ) JLKellogg Tai Luong wrote: > > Hi all, > > Would somebody tell me how to compare an array element with a > variable. I have created and loaded the following array, but > when I try to compare an array element with the following code > SQR gives me an error. Any help will be greatly appreciated! > > Create-Array > Name=camp_array > Size=20 > Field=camp_code:char:1 > Field=camp_desc:char:20 > Field=camp_cnt:number:3=0 > > move 0 to #j > while camp_code(#j) not = $cmp_code and (#j < 19 ) > add 1 to #arr_idx > end-while > > if camp_code(#j) = $cmp_code > array-add 1 2 3 to camp_array(#arr_idx) > camp_cnt(0) camp_cnt(1) camp_cnt(2) > end-if > > Tai Luong, Programmer/Analyst > City College of San Francisco Voice: 415-452-5050 > 50 Phelan Avenue, room LB-2 Fax: 415-239-3919 > San Francisco, CA 94112 E-mail: tluong@hills.ccsf.cc.ca.us From owner-sqr-users@USA.NET Tue Feb 4 16:52:27 1997 Date: Tue, 4 Feb 1997 10:59:01 -0800 From: John Kellogg Subject: Re: Duplex printing? Have you tried the print-direct instead of print as Ray recommended in his reply. All of our HelpDesk cases mention that print-direct must be used. John L. Kellogg SQRiBE Technologies Support Manager Shawn Dunn wrote: > > Ray, > > This is the code that I'm using: > > encode '<27>&l1S' into $duplex > > print $duplex (,+1) > > If I use the print command at the beginning of the program only, I get the > output of page 2 written over page 1. > > If I use the print command at the beginning of the program and where the > second page of output starts, I get 2 seperate pages of output. > > Any other ideas? > > TIA. > > Shawn > > >> Has anyone had any luck printing duplex forms from within SQR? > > > >I'm not sure about this, but are you using PRINT-DIRECT to send > >the command to the printer? Is it preceded by an escape character? > >You may need to use the ENCODE command to get an escape character > >onto the front of the escape sequence. > > > >Ray > > ------------------------------- > Shawn Dunn - SDUNN@MIT.EDU > Analyst/Programmer III - MIT Bursar's Office, Cambridge, MA > http://web.mit.edu/sdunn/www/ From owner-sqr-users@USA.NET Tue Feb 4 17:01:41 1997 Date: Tue, 4 Feb 1997 14:48:37 -0500 From: Finbar Crean Subject: Boston Area Certified Training This is a multi-part message in MIME format. --------------380917866D1A Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I am enclosing the upcoming training schedule for the coming months for the Greater Boston Area from IDFM, Inc. Finbar Crean --------------380917866D1A Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="sqrtrain.txt" IDFM, Inc. Integrating Data For Management Our Vision - Delight Every Customer SQR Certified Training Schedule Held at our offices at 131 Middlesex Turnpike, Burlington, MA 01803 SQR For Programmers Part 1 Feb 17,18 Full March 17,18 April 21,22 May 19,20 SQR For Programmers Part 2 Feb 19,20 Full March 19,20 April 23,24 May 21,22 Pricing: $750 per student per class, includes materials. *Note: We will run a class to meet your schedule at our site for a minimum of 4 people or at your site for $1,500 per day for up to 6 people. Registration: e-mail your class dates and number of students to idfm@idfm.com or call us at (617) 229-7771x312 ask for Finbar Crean or fax us at (617) 229-8638. SQR Certified Training Course Outlines SQR For Programmers Part 1 I. Whirlwind Tour II. Piece-by-piece Building bloks of SQR Language III. More of the SQR Language IV. Topics in Reporting SQR For Programmers Part 2 I. In-memory Data Types (lookup/Array) II. Multiple Reporting III. Special Page Handling IV. Graphics and Charting v. Break Processing VI. Calling the Operating System VII. Writing to or Reading from Flat Lines VIII. Linking in (or with) 3GL's IX. Writing SQR from SQR X. The "-M" File and Default Program Limits XI. Specifying Compiler Directives XII. Special Purpose Commands XIII. Strategies --------------380917866D1A-- From owner-sqr-users@USA.NET Tue Feb 4 21:20:07 1997 Date: Tue, 4 Feb 1997 13:42:12 -0800 From: Tai Luong Subject: Re Comparing array element Thank you all for responding to may question about camparing array element. It turned out my real problem was array element indexing. All the responses gave me good example and John Kellog's is one I'm going to use. Thanks again! Tai. From owner-sqr-users@USA.NET Tue Feb 4 22:19:10 1997 Date: Tue, 4 Feb 1997 16:29:38 -0800 From: Tai Luong Subject: How to create a 3-dimensional array Hi, all I need your help to create a 3-demensional array with an example with appropriate element indexing. Any response will be greately appreciated! Tai Luong Programmer Analyst City College of San Francisco Voice: 415-452-5050 50 Phelan Avenue, room LB-2 Fax: 415-239-3919 San Francisco, CA 94112 E-mail: tluong@hills.ccsf.cc.ca.us From owner-sqr-users@USA.NET Tue Feb 4 23:21:05 1997 Date: Tue, 4 Feb 1997 20:18:09 -0500 From: Ed Crotty <73747.1247@COMPUSERVE.COM> Subject: Re: faster select Message text written by Louisa L Tripp >On Wed, 29 Jan 1997, Angel Guzman wrote: > Which of these selects would be more efficient/faster in comparing > data from two different databases? > > from tt_shop > where department = $dept > and shop in (select master-shop from ldsloc.dbo.tt_shop) > ! and exists (select master-shop from ldsloc.dbo.tt_shop > ! where master-shop = shop) > order by department, division, branch, shop > > Angel > < If the ldsloc.dbo.tt_shop table is indexed on master-shop the the exists wil be faster. A join between the two tables would likely be fastest. An exists clause is a "filter" which is the executed for each row of the "main" query. If this is an indexed query then it can be very efficient, especially if the number of rows in the "main" query is not enormous. If the number of rows in the main query is very large, then a join would be faster Ex: select a.* from table1 a , table2 b where a.key = b.key if the tables are not equivalent , say a.key is unique but b.key is not, in Oracle7 you can use an "inline view" in place of a table select a.* from table1 a, (select distinct key from table2) b where a.key = b.key Ed Crotty BALR Corporation Oak Brook IL (630)575-8200 From owner-sqr-users@USA.NET Wed Feb 5 00:55:55 1997 Date: Tue, 4 Feb 1997 22:11:01 -0500 From: "Mark W. Salem" Subject: Re: Numeric Money Conversion to Words Thank you very much!!! From owner-sqr-users@USA.NET Wed Feb 5 01:43:57 1997 Date: Tue, 4 Feb 1997 22:10:56 -0500 From: "Mark W. Salem" Subject: Re: Sqr Help -Reply thank you! From owner-sqr-users@USA.NET Wed Feb 5 01:50:49 1997 Date: Tue, 4 Feb 1997 23:05:56 -0500 From: "Mark W. Salem" Subject: Re: Numeric Money Conversion to Words Thank you very much! From owner-sqr-users@USA.NET Wed Feb 5 03:31:21 1997 Date: Wed, 5 Feb 1997 00:11:14 -0500 From: "Mark W. Salem" Subject: Re: Numeric Money Conversion to Words Thank you! From owner-sqr-users@USA.NET Wed Feb 5 08:36:38 1997 Date: Wed, 5 Feb 1997 08:08:00 -0500 From: Michael Docteroff Subject: Re: Boston Area Certified Training --Boundary (ID EEjplpHmpLz3gRZ2/3/9iw) Content-type: TEXT/PLAIN I am enclosing the upcoming training schedule for the coming months for the Greater Boston Area from IDFM, Inc. Finbar Crean --Boundary (ID EEjplpHmpLz3gRZ2/3/9iw) Content-type: TEXT/PLAIN Is anyone aware of any training for the SQR for PowerBuilder product. Michael A. Docteroff ______________________________ Reply Separator _________________________________ Subject: Boston Area Certified Training Author: idfm@IDFM.COM at GATEWAY Date: 2/4/97 2:48 PM IDFM, Inc. Integrating Data For Management Our Vision - Delight Every Customer SQR Certified Training Schedule Held at our offices at 131 Middlesex Turnpike, Burlington, MA 01803 SQR For Programmers Part 1 Feb 17,18 Full March 17,18 April 21,22 May 19,20 SQR For Programmers Part 2 Feb 19,20 Full March 19,20 April 23,24 May 21,22 Pricing: $750 per student per class, includes materials. *Note: We will run a class to meet your schedule at our site for a minimum of 4 people or at your site for $1,500 per day for up to 6 people. Registration: e-mail your class dates and number of students to idfm@idfm.com or call us at (617) 229-7771x312 ask for Finbar Crean or fax us at (617) 229-8638. SQR Certified Training Course Outlines SQR For Programmers Part 1 I. Whirlwind Tour II. Piece-by-piece Building bloks of SQR Language III. More of the SQR Language IV. Topics in Reporting SQR For Programmers Part 2 I. In-memory Data Types (lookup/Array) II. Multiple Reporting III. Special Page Handling IV. Graphics and Charting v. Break Processing VI. Calling the Operating System VII. Writing to or Reading from Flat Lines VIII. Linking in (or with) 3GL's IX. Writing SQR from SQR X. The "-M" File and Default Program Limits XI. Specifying Compiler Directives XII. Special Purpose Commands XIII. Strategies --Boundary (ID EEjplpHmpLz3gRZ2/3/9iw)-- From owner-sqr-users@USA.NET Wed Feb 5 11:48:40 1997 Date: Wed, 5 Feb 1997 10:38:24 -0500 From: Finbar Crean Subject: Consulting If you have any SQR consulting needs, please let us know. We have people who are skilled in client/server development in addition to SQR development. We are a certified training and consulting partner. Finbar Crean (617) 229-7771x312 From owner-sqr-users@USA.NET Wed Feb 5 21:45:10 1997 Date: Wed, 5 Feb 1997 16:48:00 -0500 From: Hall Jeri A Subject: Subtract Dates Hi! Trying to subtract two selected dates and display the result. Not having much luck. I tried using to_date and to_char. Any ideas are greatly appreciated. Jeri From owner-sqr-users@USA.NET Wed Feb 5 22:46:16 1997 Date: Wed, 5 Feb 1997 20:20:20 -0500 From: Shivakumar Rajagopal Subject: return status... I work on HP unix environment with Oracle7 and SQR 3.0. How do I check for the following statuses in SQR :- 1) record not found in SELECT 2) invalid write for INSERT (record already present) 3) invalid rewrite....for UPDATE (record does not exist) 4) invalid DELETE..... record does not exist I gather that #sql-status and ON-ERROR are for sql syntax only. So would appreciate how error handling can be achieved in SQR. my email is srajago774@aol.com Thanks shiv From owner-sqr-users@USA.NET Thu Feb 6 02:58:54 1997 Date: Wed, 5 Feb 1997 19:47:49 -0700 From: Surit Maharana Subject: Re: Subtract Dates You should be able to subtract in the select statement itself. The result comes in terms of days. Both the operands should be date-type, though. select to_date('06-feb-97') - to_date('05-feb-97') from dual; I suppose, you are using Oracle. Surit Maharana >---------- >From: Hall Jeri A[SMTP:HALLJA@SNYCOB.COBLESKILL.EDU] >Sent: Wednesday, February 05, 1997 2:48 PM >To: Multiple recipients of list SQR-USERS >Subject: Subtract Dates > >Hi! > >Trying to subtract two selected dates and display the result. Not >having >much luck. I tried using to_date and to_char. Any ideas are greatly >appreciated. > >Jeri > From owner-sqr-users@USA.NET Thu Feb 6 07:31:41 1997 Date: Thu, 6 Feb 1997 00:41:40 -0700 From: Surit Maharana Subject: Re: Numeric Money Conversion to Words (Oracle specific. Can be customized for others too) Hi Mark, Using Julian date format (J) and spell-out(SP) suffix of Oracle, any numeric money can be converted to words easily. You can play with 'j' and 'sp' to get required case also. Try the following in SQL*Plus. select decode(instr(amount,'.'),1,'ZERO',to_char(to_date(substr (amount,1,decode(instr(amount,'.'),0,length(amount), instr(amount,'.')-1)),'J'),'JSP'))||' AND '||decode(instr (amount,'.'),0,'00',substr(amount,instr(amount,'.')+1))||'/100' from dual / 150 one hundred fifty and 00/100 123001.25 One Hundred Twenty-Three Thousand One And 25/100 ..75 ZERO AND 75/100 Good Luck Surit Maharana surit@workmail.com PeopleSoft/Oracle DBA PS:- As it can be seen, the amount should be char-type. >---------- >From: Mark W. Salem[SMTP:MSALEM2306@AOL.COM] >Sent: Sunday, February 02, 1997 6:11 AM >To: Multiple recipients of list SQR-USERS >Subject: Numeric Money Conversion to Words > >Help! I am in desperate need of a solution to converting a numeric >money >field into its word equivilent; e.g., $1,652.97 --> One thousand - >six >hundred - fifty - two and 97/100 > >I am using Oracle on a Unix server with a Window's 95 client... > >Any suggestions? > From owner-sqr-users@USA.NET Thu Feb 6 08:20:36 1997 Date: Thu, 6 Feb 1997 07:16:32 -0500 From: Shivakumar Rajagopal Subject: Re: Subtract Dates If it is oracle7 then the following should work:- begin-select (date1 - date2) &datediff from dual end-select let me know what happened......shiv From owner-sqr-users@USA.NET Thu Feb 6 08:50:34 1997 Date: Thu, 6 Feb 1997 07:45:52 -0500 From: Ragunathan Sadasivam Subject: Re: return status... Hi Shiv, I am not sure if you are looking for Oracle Status. On SELECT the way we handle record not found is to set a variable $Found = 'N' before entering Begin-Select and set it to 'Y' within the SELECT and check if it 'Y' after end-select. If it is 'N' then it didn't find any record that matched the criteria. Ragu Sadasivam rsadasiv@mitre.org Example: begin-procedure get_Pct move 'N' to $Found begin-select maximum_pct_under/100 &maximum_pct_under move 'Y' to $Found from benefit_table a where emplid = $emplid end-select if $Found = 'N' move 0 to $maximum_pct_under else move &maximum_pct_under to $maximum_pct_under end-if end-procedure =================================================================== >I work on HP unix environment with Oracle7 and SQR 3.0. How do I check for >the following statuses in SQR :- > >1) record not found in SELECT >2) invalid write for INSERT (record already present) >3) invalid rewrite....for UPDATE (record does not exist) >4) invalid DELETE..... record does not exist > >I gather that #sql-status and ON-ERROR are for sql syntax only. So would >appreciate how error handling can be achieved in SQR. > >my email is srajago774@aol.com > >Thanks > >shiv > > From owner-sqr-users@USA.NET Thu Feb 6 23:46:51 1997 Date: Thu, 6 Feb 1997 21:01:39 -0500 From: "Eric A. Eastman" Subject: Re: return status... Shiv, 1) The easiest way of doing this is do it yourself in sqr: move 0 to #row_count begin-select some_column &some_variable add 1 to #row_count from some_table where some_other_column = $key end-select if #row_count < 1 Not Found end-if if #row_count > 1 Too many rows end-if 2) If there is a unique constraint on some column (or group of columns), an oracle error will occur if an insert or update violates it. See the begin-sql qualifier "on-error" and the special variables "#sql-status" and "$sql-error". 3 and 4) See the special variable #sql-count. Eric PS. Alternately some error handling can be done in oracle directly. Example begin-sql on-error=sql_error('update_link') DECLARE no_fish_to_fry EXCEPTION;; BEGIN update food set food_type = 'Fish' where food_type = 'Sushi' and $action = 'FRY';; EXCEPTION WHEN no_data_found raise no_fish_to_fry WHEN OTHERS THEN raise;; END;; end-sql ------------------------------------------------------------------------ Eric Eastman | Ray Ontko & Co. | Adverbs are endangered, act quickly. erice@ontko.com | Richmond, IN | http://www.ontko.com/, ftp.ontko.com On Wed, 5 Feb 1997, Shivakumar Rajagopal wrote: > I work on HP unix environment with Oracle7 and SQR 3.0. How do I check for > the following statuses in SQR :- > > 1) record not found in SELECT > 2) invalid write for INSERT (record already present) > 3) invalid rewrite....for UPDATE (record does not exist) > 4) invalid DELETE..... record does not exist > > I gather that #sql-status and ON-ERROR are for sql syntax only. So would > appreciate how error handling can be achieved in SQR. > > my email is srajago774@aol.com > > Thanks > > shiv > From owner-sqr-users@USA.NET Fri Feb 7 13:16:38 1997 Date: Thu, 6 Feb 1997 14:08:42 -0800 From: John Kellogg Subject: Re: return status... 1. Another way to check for a record being selected is like this: begin-select 'true' &found col1 col2 from ... where ... end-select if &found <> 'true' display 'no records found' end-if 2. This should be handle in an On-Error procedure. 3. Whether any rows were updated can be found by checking #sql-count. 4. Whether any rows were deleted can be found by checking #sql-count. JLKellogg Shivakumar Rajagopal wrote: > > I work on HP unix environment with Oracle7 and SQR 3.0. How do I check for > the following statuses in SQR :- > > 1) record not found in SELECT > 2) invalid write for INSERT (record already present) > 3) invalid rewrite....for UPDATE (record does not exist) > 4) invalid DELETE..... record does not exist > > I gather that #sql-status and ON-ERROR are for sql syntax only. So would > appreciate how error handling can be achieved in SQR. > > my email is srajago774@aol.com > > Thanks > > shiv From owner-sqr-users@USA.NET Fri Feb 7 19:09:58 1997 Date: Fri, 7 Feb 1997 14:49:58 -0800 From: "James G. Flora" Subject: Access Does anyone know if it it possible to use sqr against an Access Database on a PC? any help would be appreciated. Jim jflora@earthlink.net From owner-sqr-users@USA.NET Sat Feb 8 22:53:59 1997 Date: Sun, 9 Feb 1997 09:07:49 +0500 From: "V.SHANKAR." Subject: SQR Porting from 2.26a to 4.0 We are looking at a project that refers to a simultaneous migration from Sybase 4.9 to 11, and SQR 2.26a to SQR 4.0. Our New Jersey location is running SQR reports under SQR 2.26a of a Sybase 4.9 database on a Solaris Server. We in India are specifically concerned with migrating a suite of SQR reports generated under SQR 2.26a with embedded Sybase 4.9 SQL to work under the new environment. (Sybase 11, SQR 4.0) Since this is a one time exercise, we do not wish to replicate the Solaris setup in India; instead, since we already have Sybase 11 running on Windows NT 4.0 on an Intel pentium platform, we wish to use SQR Workbench for Windows connected to SQR server 4.0 for Windows NT running on the same server as Sybase 11. 1. Are we correct in assuming that SQR source code transferred from New Jersey (SQRv2.26, Sybase 4.9) will run fully or partially on the NT setup (SQR 4.0, Sybase 11)? 2. I understand that the Sybase specific embedded SQL may have to be changed, and that is in fact the objective of the exercise; but will the SQR report code run unaltered (apart from version incompatibilities) on SQR Workbench? 3. Since there is hardly any mail on SQR 4.0 issues, is 4.0 a stable and tested version, and what are the migration issues between 2.26 and 4.0? 4. Finally, would SQR users recommend the approach being considered by us as reasonable to effect the migration? Are there any compatibility issues between SQR report code with embedded SQL generated using SQR Windows Workbench and SQR for Solaris? What about printer commands porting? Shankar From owner-sqr-users@USA.NET Sun Feb 9 17:57:42 1997 Date: Sun, 9 Feb 1997 17:31:54 -0500 From: Allen Wong Subject: Placing reports in a directory from within sqr code ... How can I place reports in directories from within sqr code, I have a table with a field specifying where the directory location is and I would like to grab the column with the specified output path and place the reports in the directory. For example