From owner-sqr-users@list.iex.net Fri Jan 1 00:03:25 1999 Date: Fri, 1 Jan 1999 00:00:00 -0500 From: Nathan Treadway Subject: Monthly sqr-users Hints Posting sqr-users Mailing List Hints and Guidelines Nathan Treadway, Ray Ontko & Co. (nathant@ontko.com) $Revision: 1.2 $ $Date: 1998/10/10 10:03:39 $ This document gathers in one location information about the sqr-users mail list. Directions for common list-server commands are given, as are guidelines for list usage. ______________________________________________________________________ Table of Contents 1. Introduction 1.1 sqr-users Mailing List 1.2 sqr-users Hints and Guidelines Document 2. Basic List Server Commands 2.1 Subscribing to the List 2.2 Unsubscribing from the List 2.3 Digests 2.4 Problems 3. Posting to the sqr-users List 3.1 Posting a Message 3.2 Replying to a Message 4. Job Announcements ______________________________________________________________________ 1. Introduction 1.1. sqr-users Mailing List The sqr-users mailing list was created to enable discussion related to the SQR database language (and to other products from SQRIBE Technologies). The mailing list is provided as a service of Ray Ontko & Co. . A searchable archive of past postings to the mailing list is available from the SQR Users Group web site . 1.2. sqr-users Hints and Guidelines Document This document gives various hints and guidelines about the sqr-users mailing list. It will be posted approximately monthly to the mailing list so that new users can see it (and existing users can find it easily). An HTML version of the document is always available at http://www.sqrug.com/sqr-users/sqr-users-hints.html. If you have comments or suggestions about this document, please contact me directly at the address listed in the title section. This document is (C)Copyright 1998 by Nathan Treadway. It may be freely copied and distributed provided it is not modified in any way and it retains the original copyright notice. 2. Basic List Server Commands Here are a few basic list server commands. Subscriptions and unsubscriptions can normally be processed automatically by sending the proper command as the only line in the body (not the subject line) of an e-mail message sent to "listserv@usa.net". 2.1. Subscribing to the List To subscribe to the mailing list, the command is subscribe sqr-users Your Name Note that you do not need to provide your e-mail address as it is taken from your message's header. You will be e-mailed a confirmation number, which you must then send back to the list server software before the command goes into effect. 2.2. Unsubscribing from the List To unsubscribe, the command is simply unsubscribe sqr-users Once again, you will need to confirm your command before it goes into effect. 2.3. Digests Once you are subscribed, you can request to get your messages in digest form (one large message containing all of the posts made each day) by sending the command set sqr-users digests If you use digests you should not just "reply" to the digest mailing. Instead, be sure your message's subject header matches the subject in the original posting to which you are replying, and that you don't include a quoted copy of the entire digest in your post. Use "nodigests" instead of "digests" to restore normal distribution. 2.4. Problems If the above commands do not work, please contact the list manager at "sqr-users-request@usa.net". (Do not send a message to the list itself -- no one there can help you with your problem!) Please include a copy of the error message you received from the list server. 3. Posting to the sqr-users List In order to post to the mailing list, you must be subscribed to it (see directions above). 3.1. Posting a Message Once you are subscribed, you can post to the list by sending a message to "sqr-users@usa.net". Be sure your subject heading describes your specific problem or question (i.e. don't just use "SQR Question"). In the body of your message, please include the following information: o SQRIBE product and version number o Operating system and version number o Database name and version number o Application name (i.e. PeopleSoft) and a version number, if any Also, include a short code sample whenever possible. It's much easier for other people to understand what you are trying to do when they can see the actual code. (At the same time, be careful not to post confidential code, since the posting will be placed in a public web archive.) Note that your question should relate to a SQRIBE product in some way. Don't ask questions about PeopleSoft, for example, unless you are having SQR-related issues. (To find out your version of SQR, you can run the following program: begin-program show $sqr-ver end-program This will produce a line that looks something like this: SQR/3.0.15/Intel/SCO Unix R3.2 V5.0/Oracle 7.2.2.3/Sep 25 1996 Include the full line of output in your message. Note that the oper- ating system version number listed here is the one under which this copy of SQR was compiled, so you'll still need to include your own information.) 3.2. Replying to a Message Messages sent out on the list have a Reply-To header pointing to the list. This means that you should be able to simply use your mail reader's "reply" function to send a reply to the list. Generally, all answers to questions sent out on the list should be public replies, so that other subscribers can benefit. In those cases where a private reply is appropriate, be sure to over-ride the default Reply-To address. If your message is not actually a reply to the earlier message, please do not use the "reply" function. Instead, address a new e-mail message to the list as described in the previous section. (This is because the list archives will incorrectly show the new message in the original thread if you use "reply".) You should quote enough lines from the original message that later readers can understand your answer even if they missed the orginal question. At the same time, you should remove any unnecessary lines from the quote in order to make your message shorter and easier to understand. In particular, in order to prevent mail loops, the list server will not accept messages that contain From:, Sender:, etc. lines pointing back to the sqr-users list, even if these lines are quoted (i.e. with ">" characters). Be sure to delete these from your reply message before sending it. 4. Job Announcements SQR-related job announcements are currently allowed on the list, subject to the following restrictions: o The subject line must begin with the words "JOB ANNOUNCEMENT:". o The message should be very short (fewer than 20 lines), giving brief details of the job and a way for those interested to get more information directly (i.e. web page or phone number). o The message should specifically remind people interested in the job to respond directly to the message author (and not to use their mailer's "reply" function, since that would send the reply out on the list). o Post job announcements as infrequently as possible. From owner-sqr-users@list.iex.net Sun Jan 3 16:15:27 1999 Date: Sun, 3 Jan 1999 16:03:34 -0500 From: Ray Ontko Subject: Re: Array name as parameter Bruce, Arrays cannot be passed as parameters to a procedure, sadly. Even if you pass the name, you cannot "dereference" the name to make a reference to the array itself (although that's an interesting idea). You might be able to do what you want by making clever use of #include and #define to create a separate copy of the procedure for each array you intend to use it with. This would allow you to use a "procedure" with many different arrays, but still have a single source module in which to define the logic of the procedure. Ray P.S. Note, however, you CAN pass an array to an external C routine (go figure), but I wouldn't recommend this unless you're willing to compile and re-link this into your SQR image each time you get a new SQR distribution. To learn more about this, look at the "array" function under "LET", and at ufunc.c in the "lib" directory of your SQR distribuition. > Can anyone tell me if an array name can be passed to a procedure as a > parameter and if so how do I refer to the array in a GET statement? I believe I > can not pass the array as a parameter but what about the name? > > Bruce Mitchell > Sierra Systems Consultants Inc. > ---------------------------------------------------------------------- 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@list.iex.net Mon Jan 4 10:12:04 1999 Date: Tue, 5 Jan 1999 07:01:31 -0800 From: Albert Howard Subject: Re: Diet Expert Software !!!!!! Aackkk!! SPAM!!!!!!!!! Please keep it off this list!!!! At 01:00 PM 12/26/98 +0100, you wrote: >Visit our web site http://www.dietexpert.com and look at our software >Diet expert. It is an easy-to-use, and still very sophisticated >programme for dieting with healthy eating both for you and members of >your family. If you are interested in diet without dieting, don't miss >it. 30 days free evaluation. >Special treatment for diabetics. Over 600 recipes!!!! From owner-sqr-users@list.iex.net Mon Jan 4 10:23:34 1999 Date: Mon, 4 Jan 1999 20:43:19 +0530 From: Srinivasan S Subject: SQR.INI Hello all, Could anyone tell me the significance of the file SQR.INI. It justs contains the following entry [Environment:Common] SQRDIR=f:\hr700\sqrbinw [Environment:Oracle] SQRDIR=f:\hr700\sqrbinw Thankx in Advance. From owner-sqr-users@list.iex.net Mon Jan 4 10:34:45 1999 Date: Tue, 5 Jan 1999 07:25:10 -0800 From: Albert Howard Subject: Oops (sorry folks) Ok my turn to apologize...Had a large clutter of email upon return and didn't see the original poster's apology for the accidental spam posting... From owner-sqr-users@list.iex.net Mon Jan 4 10:46:52 1999 Date: Tue, 5 Jan 1999 07:37:33 -0800 From: Albert Howard Subject: Re: SQR.INI This file can be used to set the various sqr flags such as -f and -o. In a PeopleSoft installation, these flags are set by the Process Scheduler or at the SQRW command line since they have to be different occasionally based on which database you execute from or whether you execute from SQRW directly. Setting the values in SQR.INI overrides command line parameters, so PeopleSoft does not set them in the SQR.INI. Therefore what you see is the minimum required values in SQR.INI required to execute SQRW. At 08:43 PM 1/4/99 +0530, you wrote: >Hello all, > Could anyone tell me the significance of the file SQR.INI. It justs >contains the following entry > >[Environment:Common] >SQRDIR=f:\hr700\sqrbinw >[Environment:Oracle] >SQRDIR=f:\hr700\sqrbinw > > >Thankx in Advance. From owner-sqr-users@list.iex.net Mon Jan 4 10:49:48 1999 Date: Mon, 4 Jan 1999 10:28:11 -0500 From: "Brunelle, Cindy - AD/Corporate" Subject: Re: SQR.INI This file contains your environment settings - points to where your SQR prog files are located. Cindy Brunelle > -----Original Message----- > From: Srinivasan S [SMTP:srinivasan.seetharaman@DB.COM] > Sent: Monday, January 04, 1999 10:13 AM > To: Multiple recipients of list SQR-USERS > Subject: SQR.INI > > Hello all, > Could anyone tell me the significance of the file SQR.INI. It justs > contains the following entry > > [Environment:Common] > SQRDIR=f:\hr700\sqrbinw > [Environment:Oracle] > SQRDIR=f:\hr700\sqrbinw > > > Thankx in Advance. From owner-sqr-users@list.iex.net Mon Jan 4 10:53:41 1999 Date: Mon, 4 Jan 1999 10:45:28 -0500 From: "Wanko, Christopher G, CFCTR" Subject: Re: SQR.INI > Hello all, > Could anyone tell me the significance of the file > SQR.INI. It justs > contains the following entry > > [Environment:Common] > SQRDIR=f:\hr700\sqrbinw > [Environment:Oracle] > SQRDIR=f:\hr700\sqrbinw Delete it and see what happens. I'm sorry, I couldn't resist... -Chris From owner-sqr-users@list.iex.net Mon Jan 4 12:52:51 1999 Date: Mon, 4 Jan 1999 09:49:33 -0800 From: Michael Lee Subject: Re: SQR.INI Chris, I know that you have been on this list for awhile, and this is not the first sarcastic mail that you have sent to this list. If you cannot add any value to this list, please refrain from mailing your sarcastic remarks. We all use this list to add value. You, on the other hand, are wasting bandwidth. Please take this constructively and act a little more mature. Michael "Wanko, Christopher G, CFCTR" on 01/04/99 07:45:28 AM Please respond to SQR-USERS@USA.NET To: Multiple recipients of list SQR-USERS cc: (bcc: Michael Lee/Application Group) Subject: Re: SQR.INI > Hello all, > Could anyone tell me the significance of the file > SQR.INI. It justs > contains the following entry > > [Environment:Common] > SQRDIR=f:\hr700\sqrbinw > [Environment:Oracle] > SQRDIR=f:\hr700\sqrbinw Delete it and see what happens. I'm sorry, I couldn't resist... -Chris From owner-sqr-users@list.iex.net Mon Jan 4 13:05:00 1999 Date: Mon, 4 Jan 1999 09:46:41 -0800 From: Bill Winkfield Subject: SQR 'wrtite' command Hello all, I'm using the following structure to create a data file with version 3 of SQR. I can write a new file with no problem, but it is inserting a blank line at the beginning of the file, which I don't need. Has anyone encountered this problem or have a clue as to a solution. open 'e:\psoft\final\fshift\fsheader.dat' as 3 for-writing record=200 status=#open3 Thanks in advance. Bill Winkfield From owner-sqr-users@list.iex.net Mon Jan 4 14:27:21 1999 Date: Mon, 4 Jan 1999 11:23:17 -0800 From: Grant Chappell Subject: Re: SQR.INI Or better yet, maybe look it up in the archives. Maybe do a little research before asking. -----Original Message----- From: Discussion of SQR, SQRIBE Technologies's database reporting language [mailto:SQR-USERS@list.iex.net] On Behalf Of Wanko, Christopher G, CFCTR Sent: Monday, January 04, 1999 7:45 AM To: Multiple recipients of list SQR-USERS Subject: Re: SQR.INI > Hello all, > Could anyone tell me the significance of the file > SQR.INI. It justs > contains the following entry > > [Environment:Common] > SQRDIR=f:\hr700\sqrbinw > [Environment:Oracle] > SQRDIR=f:\hr700\sqrbinw Delete it and see what happens. I'm sorry, I couldn't resist... -Chris From owner-sqr-users@list.iex.net Mon Jan 4 15:01:24 1999 Date: Mon, 4 Jan 1999 14:56:34 -0500 From: Anthony Leung-New York Subject: Re: SQR.INI Grant, The main idea behind this user list is to provide a gateway for SQR users to help out each other. You have a choice of not adding any values to the list, but to put people down by responding with sarcastic remarks seems to be a bit out of line here! Anthony > -----Original Message----- > From: Grant Chappell [SMTP:gchappell@CARRERACONSULTING.COM] > Sent: Monday, January 04, 1999 2:23 PM > To: Multiple recipients of list SQR-USERS > Subject: Re: SQR.INI > > Or better yet, maybe look it up in the archives. Maybe do a little > research > before asking. > > -----Original Message----- > From: Discussion of SQR, SQRIBE Technologies's database > reporting language [mailto:SQR-USERS@list.iex.net] On Behalf Of Wanko, > Christopher G, CFCTR > Sent: Monday, January 04, 1999 7:45 AM > To: Multiple recipients of list SQR-USERS > Subject: Re: SQR.INI > > > Hello all, > > Could anyone tell me the significance of the file > > SQR.INI. It justs > > contains the following entry > > > > [Environment:Common] > > SQRDIR=f:\hr700\sqrbinw > > [Environment:Oracle] > > SQRDIR=f:\hr700\sqrbinw > > Delete it and see what happens. > > I'm sorry, I couldn't resist... > > -Chris From owner-sqr-users@list.iex.net Mon Jan 4 15:16:14 1999 Date: Tue, 5 Jan 1999 13:01:16 -0700 From: Albert Howard Subject: Re: SQR 'wrtite' command Nothing there should be causing a blank record. Put a show statement in front of your 'writes' to make sure you aren't executing one without realizing it. At 09:46 AM 1/4/99 -0800, you wrote: >Hello all, > >I'm using the following structure to create a data file with version 3 >of SQR. I can write a new file with no problem, but it is inserting a >blank line at the beginning of the file, which I don't need. Has anyone >encountered this problem or have a clue as to a solution. > > open 'e:\psoft\final\fshift\fsheader.dat' as 3 > for-writing > record=200 > status=#open3 > > >Thanks in advance. >Bill Winkfield From owner-sqr-users@list.iex.net Mon Jan 4 15:28:05 1999 Date: Mon, 4 Jan 1999 15:02:40 -0500 From: Bob Buford Subject: Re: SQR 'wrtite' command Bill, Take a look at your first WRITE command following this OPEN command. That is where you are most likely sending a blank line. Check out what the character is (Programmer's File Editor or similar program can help here); that could give a clue as well. The OPEN command as you wrote it here would not issue a line-feed. Best regards, Bob >>> Bill Winkfield 01/04 12:46 PM >>> Hello all, I'm using the following structure to create a data file with version 3 of SQR. I can write a new file with no problem, but it is inserting a blank line at the beginning of the file, which I don't need. Has anyone encountered this problem or have a clue as to a solution. open 'e:\psoft\final\fshift\fsheader.dat' as 3 for-writing record=200 status=#open3 Thanks in advance. Bill Winkfield From owner-sqr-users@list.iex.net Mon Jan 4 15:31:05 1999 Date: Mon, 4 Jan 1999 15:25:23 -0500 From: Ravi Ginjupalli Subject: Re: SQR.INI I agree. I think this is the very reason why this list has very few posting's compared to other list's. Ravi. Anthony Leung-New York on 01/04/99 02:56:34 PM Please respond to SQR-USERS@USA.NET To: Multiple recipients of list SQR-USERS cc: (bcc: Ravi Ginjupalli/HQ/USA/Kelly) Subject: Re: SQR.INI Grant, The main idea behind this user list is to provide a gateway for SQR users to help out each other. You have a choice of not adding any values to the list, but to put people down by responding with sarcastic remarks seems to be a bit out of line here! Anthony > -----Original Message----- > From: Grant Chappell [SMTP:gchappell@CARRERACONSULTING.COM] > Sent: Monday, January 04, 1999 2:23 PM > To: Multiple recipients of list SQR-USERS > Subject: Re: SQR.INI > > Or better yet, maybe look it up in the archives. Maybe do a little > research > before asking. > > -----Original Message----- > From: Discussion of SQR, SQRIBE Technologies's database > reporting language [mailto:SQR-USERS@list.iex.net] On Behalf Of Wanko, > Christopher G, CFCTR > Sent: Monday, January 04, 1999 7:45 AM > To: Multiple recipients of list SQR-USERS > Subject: Re: SQR.INI > > > Hello all, > > Could anyone tell me the significance of the file > > SQR.INI. It justs > > contains the following entry > > > > [Environment:Common] > > SQRDIR=f:\hr700\sqrbinw > > [Environment:Oracle] > > SQRDIR=f:\hr700\sqrbinw > > Delete it and see what happens. > > I'm sorry, I couldn't resist... > > -Chris From owner-sqr-users@list.iex.net Mon Jan 4 15:58:18 1999 Date: Mon, 4 Jan 1999 12:52:31 PST From: ravi kumar Subject: Need Help in Upgrade 6.0 to 7.0 HRMS process Hi all can anybody help me... I want to know the process fro 6.0 to 7.0 upgradation. Please let me know the process Thanks in advance Ravi ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Mon Jan 4 17:38:27 1999 Date: Mon, 4 Jan 1999 17:27:40 -0500 From: "Williams, Kara" Subject: -F Flag question January 4, 1999 5:15 PM Platform: UNIX AIX Database: Oracle Question: I know that I can override the name that SQR or the program assigns to a report file by specifying the -F flag, but what if the report produces multiple outputs? Would I use multiple -F flags with the name for each output file specified? If so, do I put them in sequential order? Thanks. From owner-sqr-users@list.iex.net Mon Jan 4 17:55:28 1999 Date: Mon, 4 Jan 1999 16:49:46 -0500 From: Ken Burcham Subject: Catching a new-page Hey! Is there a way to 'catch' a page-break when the buffer fills up and pushes it to the next page? I'd like to rewrite a header on the new page.... Is there something more elegant than counting lines? ken. ====================================== Ken Burcham Peoplesoft Programmer Campus Crusade for Christ From owner-sqr-users@list.iex.net Mon Jan 4 18:29:48 1999 Date: Mon, 4 Jan 1999 15:25:46 PST From: Parijat Sahai Subject: Re: -F Flag question In my case, platform is Win95, Database SQL Server 6.5. I'm also interested in the solution to Kara's question. I have another query though. Is there a way to specify the name of output report (multiple reports, in fact) file during run-time, in the program itself? I wish to name my reports like YYYYMMDD.SUM, YYYYMMDD.DTL depending on a date calculated in the program itself. TIA, Parijat. > >January 4, 1999 5:15 PM >Platform: UNIX AIX >Database: Oracle > >Question: I know that I can override the name that SQR or the program >assigns to a report file by specifying the -F flag, but what if the report >produces multiple outputs? Would I use multiple -F flags with the name for >each output file specified? If so, do I put them in sequential order? > >Thanks. > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Mon Jan 4 18:37:54 1999 Date: Mon, 4 Jan 1999 15:32:13 -0800 From: David Donnelly Subject: Re: Catching a new-page You can check the value of #current-line to see if it's equal to 1. BUT, you have to write something to force it to be updated. If I have nothing I want to write first, I write a zero length string ( '' ) in column one. You might also use the declare-procedure before-page facility Dave Donnelly At 04:49 PM 1/4/1999 -0500, you wrote: >Hey! > > Is there a way to 'catch' a page-break when the buffer fills up and pushes it to the next page? I'd like to rewrite a header on the new page.... Is there something more elegant than counting lines? > >ken. > >====================================== >Ken Burcham >Peoplesoft Programmer >Campus Crusade for Christ > From owner-sqr-users@list.iex.net Tue Jan 5 07:37:21 1999 Date: Tue, 5 Jan 1999 07:32:08 -0500 From: Bob Buford Subject: Re: -F Flag question Being somewhat curious myself, I thought I'd look this up in my SQR3 Workbench manual. Multiple reports are created as declared in the DECLARE-REPORT section. All reports will have the same filename, with file extensions being .LIS, ..L01, .L02, etc. in the order they are declared. The filename will be the name of the SQR program unless -F is invoked to change that filename. The report name cited in each DECLARE-REPORT is used internally to select the specific report, using USE-REPORT. What I'm not sure about, but it seems to be the case, is that USE-REPORT causes subsequent output from PRINT statements to be appended to (as opposed to overwriting) existing file contents. This would allow the programmer to have several reports open and switch output feeds to each as appropriate. Reference command discussions on DECLARE-REPORT, USE-REPORT and the section "Writing Applications to Create Multiple Reports" (p.94 in the SQR3 book). Ken, you wouldn't use multiple -F flags; each one issued would override the previous one. Just declare the reports you need, understanding that all will have the same name with file extensions differing. Check with Brian if you have further questions; he's experienced in doing this. Parijat, the only way I know to rename a file would be in using the CALL...USING function, such as Let $file1 = 'report.lis' Let $file2 = 'newname.txt' Let $cmd = ''cmd.exe \C rename ' || $file1 || ' ' || $file2 CALL SYSTEM USING $cmd #dos_status show 'Renamed ' $file1 ' to ' $file2 ', status=' #dos_status You're welcome, Bob >>> Parijat Sahai 01/04 6:25 PM >>> In my case, platform is Win95, Database SQL Server 6.5. I'm also interested in the solution to Kara's question. I have another query though. Is there a way to specify the name of output report (multiple reports, in fact) file during run-time, in the program itself? I wish to name my reports like YYYYMMDD.SUM, YYYYMMDD.DTL depending on a date calculated in the program itself. TIA, Parijat. > >January 4, 1999 5:15 PM >Platform: UNIX AIX >Database: Oracle > >Question: I know that I can override the name that SQR or the program >assigns to a report file by specifying the -F flag, but what if the report >produces multiple outputs? Would I use multiple -F flags with the name for >each output file specified? If so, do I put them in sequential order? > >Thanks. > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Tue Jan 5 08:07:38 1999 Date: Tue, 5 Jan 1999 08:04:08 -0500 From: John Walker Subject: Re: Catching a new-page I use the #page-count system variable in V3 SQR. e.g. if #page-count = 1 ........ if #page-count = 2 ........ You could also examine this variable to see when it changes. Hope this helps. Ken Burcham on 01/04/99 04:49:46 PM Please respond to SQR-USERS@USA.NET To: Multiple recipients of list SQR-USERS cc: (bcc: John A. Walker/CEI/FirstEnergy) Subject: Catching a new-page Hey! Is there a way to 'catch' a page-break when the buffer fills up and pushes it to the next page? I'd like to rewrite a header on the new page.... Is there something more elegant than counting lines? ken. ====================================== Ken Burcham Peoplesoft Programmer Campus Crusade for Christ From owner-sqr-users@list.iex.net Tue Jan 5 08:24:11 1999 Date: Tue, 5 Jan 1999 08:20:54 -0500 From: Brian Nice Subject: Re: -F Flag question Try using the new-report command. If you issue this command before anything gets printed on the page, you can set what you want the output file to be. let $file = $year || $month || $day || '.SUM' new-report $file As you switch between reports, I believe that you can just issue a new-report command for each one. declare-report report1 ... declare report report2 ... use-report report1 new-report $file1 use-report report2 new-report $file2 Just make sure that the new-report command is used before anything is printed on any of the reports that you declare. /******************** * Brian Nice * Senior Programmer/Analyst * Campus Crusade for Christ * bnice@ccci.org *********************************/ >>> Parijat Sahai 01/04 6:25 PM >>> In my case, platform is Win95, Database SQL Server 6.5. I'm also interested in the solution to Kara's question. I have another query though. Is there a way to specify the name of output report (multiple reports, in fact) file during run-time, in the program itself? I wish to name my reports like YYYYMMDD.SUM, YYYYMMDD.DTL depending on a date calculated in the program itself. TIA, Parijat. > >January 4, 1999 5:15 PM >Platform: UNIX AIX >Database: Oracle > >Question: I know that I can override the name that SQR or the program >assigns to a report file by specifying the -F flag, but what if the report >produces multiple outputs? Would I use multiple -F flags with the name for >each output file specified? If so, do I put them in sequential order? > >Thanks. > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Tue Jan 5 09:25:38 1999 Date: Tue, 5 Jan 1999 08:48:31 -0500 From: Sam Spritzer Subject: Re: Need Help in Upgrade 6.0 to 7.0 HRMS process Ravi, I am assuming you are using PeopleSoft. You need to contact your account manager for information regarding this. In effect, it can be a lengthy process which is why I am suggesting that. Sam >>> ravi kumar 01/04 3:52 PM >>> Hi all can anybody help me... I want to know the process fro 6.0 to 7.0 upgradation. Please let me know the process Thanks in advance Ravi ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Tue Jan 5 09:28:51 1999 Date: Tue, 5 Jan 1999 08:24:42 -0600 From: "Maikranz, Sheila" Subject: Re: Need Help in Upgrade 6.0 to 7.0 HRMS process This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BE38B6.FF694066 Content-Type: text/plain > -----Original Message----- > From: ravi kumar [SMTP:ammalu@HOTMAIL.COM] > Sent: Monday, January 04, 1999 2:53 PM > To: Multiple recipients of list SQR-USERS > Subject: Need Help in Upgrade 6.0 to 7.0 HRMS process > Ravi, Upgrade instructions are posted on Customer Connection in PeopleBook format. You will need your Customer Connection User Name and Password. You can log on to Customer Connection and browse to the Upgrades category in News and Information. Or, if you have Folio Web-enabled, you can follow this Web link to the URL: http://www4.peoplesoft.com/psgbbs2.nsf/Categories?ReadForm In the Upgrades category you will find the latest version of the upgrade instructions for this release. Download the upgrade instructions files for your upgrade path. Unzip them into the PSBOOKS directory you created on a server or your local drive and run the PSBOOKS.EXE program to select and view the upgrade instructions. Once you've downloaded the files, use the File, Open command from this PeopleBook file to view: UH675ENG.NFO Upgrading PeopleSoft 6.0x HRMS to PeopleSoft 7.5 HRMS (Commercial) UH775ENG.NFO Upgrading PeopleSoft 7.0x HRMS to PeopleSoft 7.5 HRMS (Commercial) Hope this helps. Sheila Maikranz > Hi all > > can anybody help me... > > I want to know the process fro 6.0 to 7.0 upgradation. > > Please let me know the process > > Thanks in advance > Ravi > > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com ------_=_NextPart_001_01BE38B6.FF694066 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: Need Help in Upgrade 6.0 to 7.0 HRMS process

    -----Original Message-----
    From:   ravi kumar [SMTP:ammalu@HOTMAIL.COM]
    Sent:   Monday, January 04, 1999 2:53 PM
    To:     Multiple recipients of list SQR-USERS
    Subject:       = Need Help in Upgrade 6.0 to 7.0 HRMS = process

    Ravi,

    Upgrade instructions = are posted on Customer Connection in PeopleBook format.
    You will need your = Customer Connection User Name and Password.
    You can log on to = Customer Connection and browse to the Upgrades category in News and = Information. Or, if you have Folio Web-enabled, you can follow this Web = link to the URL:

    http://www4.peoplesoft.com/psgbbs2.nsf/Categories?Read= Form
    In the Upgrades = category you will find the latest version of the upgrade instructions = for this release.  Download the upgrade instructions files for = your upgrade path.  Unzip them into the PSBOOKS directory you = created on a server or your local drive and run the PSBOOKS.EXE program = to select and view the upgrade instructions.

    Once you've = downloaded the files, use the File, Open command from this PeopleBook = file to view:
    UH675ENG.NFO  = Upgrading PeopleSoft 6.0x HRMS to PeopleSoft 7.5 HRMS = (Commercial)
    UH775ENG.NFO  = Upgrading PeopleSoft 7.0x HRMS to PeopleSoft 7.5 HRMS = (Commercial)
    Hope this = helps.

    Sheila = Maikranz


    Hi all

    can anybody help = me...

    I want to know the = process fro 6.0 to 7.0 upgradation.

    Please let me know = the process

    Thanks in = advance
    Ravi


    ______________________________________________________
    Get Your Private, = Free Email at http://www.hotmail.com

------_=_NextPart_001_01BE38B6.FF694066-- From owner-sqr-users@list.iex.net Tue Jan 5 10:10:56 1999 Date: Tue, 5 Jan 1999 10:08:14 -0500 From: Ken Burcham Subject: Re: Catching a new-page Dave, others, Is there a list of all of the sqr variables somewhere? Also environmental variables? Sheesh, that's sure to be a faq question... ken. At 03:32 PM 1/4/99 -0800, you wrote: >You can check the value of #current-line to see if it's equal to 1. BUT, >you have to write something to force it to be updated. If I have nothing I >want to write first, I write a zero length string ( '' ) in column one. > >You might also use the declare-procedure before-page facility > >Dave Donnelly > >At 04:49 PM 1/4/1999 -0500, you wrote: >>Hey! >> >> Is there a way to 'catch' a page-break when the buffer fills up and >pushes it to the next page? I'd like to rewrite a header on the new >page.... Is there something more elegant than counting lines? >> >>ken. >> >>====================================== >>Ken Burcham >>Peoplesoft Programmer >>Campus Crusade for Christ >> > > ====================================== Ken Burcham Peoplesoft Programmer Campus Crusade for Christ From owner-sqr-users@list.iex.net Tue Jan 5 10:21:17 1999 Date: Wed, 6 Jan 1999 08:11:48 -0700 From: Albert Howard Subject: Re: Catching a new-page Buried in your SQRBINW directory (where the sqr runtime files are stored), you will find a file that is named either sqr_cmd.hlp or cmdhlp.hlp, depending on your version of SQR. This file is an on-line SQR documentation file and it has a link to this information. You might make a desktop link to this file. Also, if you are using PFE to edit SQR's, you can make a hotkey help button to bring it up. Its very helpful. At 10:08 AM 1/5/99 -0500, you wrote: >Dave, others, > >Is there a list of all of the sqr variables somewhere? Also environmental >variables? Sheesh, that's sure to be a faq question... > >ken. > > >At 03:32 PM 1/4/99 -0800, you wrote: >>You can check the value of #current-line to see if it's equal to 1. BUT, >>you have to write something to force it to be updated. If I have nothing I >>want to write first, I write a zero length string ( '' ) in column one. >> >>You might also use the declare-procedure before-page facility >> >>Dave Donnelly >> >>At 04:49 PM 1/4/1999 -0500, you wrote: >>>Hey! >>> >>> Is there a way to 'catch' a page-break when the buffer fills up and >>pushes it to the next page? I'd like to rewrite a header on the new >>page.... Is there something more elegant than counting lines? >>> >>>ken. >>> >>>====================================== >>>Ken Burcham >>>Peoplesoft Programmer >>>Campus Crusade for Christ >>> >> >> >====================================== >Ken Burcham >Peoplesoft Programmer >Campus Crusade for Christ From owner-sqr-users@list.iex.net Tue Jan 5 10:30:02 1999 Date: Tue, 5 Jan 1999 10:25:11 -0500 From: Sam Spritzer Subject: Re: Catching a new-page Ken, It depends on what product you are using SQR for. The SQR training manual from PeopleSoft provides most of what you are probably looking for. Also, on their Customer Connection website, there is a whitepaper on the variables used for PeopleSoft. Sam >>> Ken Burcham 01/05 10:08 AM >>> Dave, others, Is there a list of all of the sqr variables somewhere? Also environmental variables? Sheesh, that's sure to be a faq question... ken. At 03:32 PM 1/4/99 -0800, you wrote: >You can check the value of #current-line to see if it's equal to 1. BUT, >you have to write something to force it to be updated. If I have nothing I >want to write first, I write a zero length string ( '' ) in column one. > >You might also use the declare-procedure before-page facility > >Dave Donnelly > >At 04:49 PM 1/4/1999 -0500, you wrote: >>Hey! >> >> Is there a way to 'catch' a page-break when the buffer fills up and >pushes it to the next page? I'd like to rewrite a header on the new >page.... Is there something more elegant than counting lines? >> >>ken. >> >>====================================== >>Ken Burcham >>Peoplesoft Programmer >>Campus Crusade for Christ >> > > ====================================== Ken Burcham Peoplesoft Programmer Campus Crusade for Christ From owner-sqr-users@list.iex.net Tue Jan 5 14:59:18 1999 Date: Tue, 5 Jan 1999 09:01:14 PST From: "madav ." Subject: How to include Instance ID in SQR output file name? I would like to pad Process Instance ID from Process Scheduler with in the SQR report to generate a unique output filename (eg., abc101234.lis where 101234 is current Instance ID) . Any idea to resolve this? Your help is much appreciated. Madav ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Tue Jan 5 15:07:56 1999 Date: Tue, 5 Jan 1999 10:25:11 -0600 From: Richard Wagner Subject: Executing Stored Procedure in SQR 4.2.3 on platform MSSQL 6.5 Hello All, I'm having problems executing a stored procedure on a Microsoft SQL Server 6.5 database. The line that kills the SQR is: execute sp_rename 'PS_1', 'PS_DUMMY_RECORD' The first time I attempt to run the SQR containing the above command, I receive the error message, Error on line 166: (SQR 3913) Could not EXECUTE stored procedure. When I attempt to run the stored procedure a second time, I receive the message, SQR: Program Aborting. (SQR 5528) ODBC SQL dbxact: SQLTransact error 0 in cursor 0: [Microsoft][ODBC SQL Server Driver]Communication link failure At this point the database freezes and I have to stop and restart the database at the SQL Server level. The documentation seems to indicate that I need an INTO argument....... "If the stored procedure specified in stored_procedure_name contains a SELECT query, the EXECUTE command must specify an INTO argument in order to process the values from the query. If no INTO argument is specified then the values from the query will be ignored." The problem is the sp_rename procedure contains multiple select statements. Can anyone help me out with the correct use of the execute command? Thank You. From owner-sqr-users@list.iex.net Tue Jan 5 15:16:55 1999 Date: Tue, 5 Jan 1999 15:12:12 -0500 From: Brian Nice Subject: Re: How to include Instance ID in SQR output file name? In the process definition for that SQR, under the Process Definition Options tab, SQR Parameters line, change the drop down to Append and add %%INSTANCE%% to the parameter line. Then in your SQR, use an input statement to get the command line parameter. input $processInstance Now that you have the instance, construct a filename, and use the NEW-REPORT command in SQR to change the name of the .LIS file. Be sure and issue this before any Print statements are done in the SQR. let $file = 'abc' || $processInstance || .LIS' new-report $file Hope that helps /******************** * Brian Nice * Senior Programmer/Analyst * Campus Crusade for Christ * bnice@ccci.org *********************************/ >>> "madav ." 01/05 12:01 PM >>> I would like to pad Process Instance ID from Process Scheduler with in the SQR report to generate a unique output filename (eg., abc101234.lis where 101234 is current Instance ID) . Any idea to resolve this? Your help is much appreciated. Madav ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Tue Jan 5 15:38:26 1999 Date: Tue, 5 Jan 1999 15:36:48 -0500 From: Tony DeLia Subject: Re: How to include Instance ID in SQR output file name? madav, Easy. Try this... .... let $Rpt_Name = 'default.lis' if $process_instance <> '' let $p_id = lpad($process_instance,6,'0') let $Rpt_Name = 'pi' || $p_id || '.lis' end-if new-report $Rpt_Name .... This is a very basic solution... I'm assuming 6 digits for process instance... Change to suit your needs... Also I'm checking if it was run outside of Process Scheduler (using the standard PeopleSoft convention)... If it's not the Process Scheduler (i.e. run from SQRW prompt) I default the report name to 'default.lis' since there is NO process instance to use. Example yields $Rpt_Name of 'pi001234.lis'... -Tony DeLia madav . wrote: > > I would like to pad Process Instance ID from Process Scheduler with in > the SQR report to generate a unique output filename (eg., abc101234.lis > where 101234 is current Instance ID) . > > Any idea to resolve this? > Your help is much appreciated. > > Madav > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com -- Tony DeLia AnswerThink Consulting Group PeopleSoft Solutions Practice - Delphi Partners tdelia@erols.com From owner-sqr-users@list.iex.net Tue Jan 5 15:42:02 1999 Date: Tue, 5 Jan 1999 12:22:25 -0500 From: Don Mellen Subject: Re: Catching a new-page On Tue, 5 Jan 1999, Ken Burcham wrote: > Is there a list of all of the sqr variables somewhere? Also > environmental variables? Sheesh, that's sure to be a faq question... FYI, The SQR variables can also be found on our quick reference card at http://www.ontko.com/sqrcard4.html HTH, ----------------------------------------------------------------------- Donald Mellen | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/ donm@ontko.com | "In the beginning, there was nothing, which exploded" From owner-sqr-users@list.iex.net Tue Jan 5 15:42:32 1999 Date: Tue, 5 Jan 1999 12:01:18 -0500 From: Don Mellen Subject: Re: -F Flag question On Mon, 4 Jan 1999, Williams, Kara wrote: > Question: I know that I can override the name that SQR or the program > assigns to a report file by specifying the -F flag, but what if the report > produces multiple outputs? Would I use multiple -F flags with the name for > each output file specified? If so, do I put them in sequential order? OK, a few things here, Yes multiple -F flags can be used to overide the output names of the reports in the order that they are "declare"d in the report program. If you simply want all of the reports with their default names to go in a different directory, you can use a single -F flag with the new directory and no file name. If you want to name the reports at run-time (like Parijat wanted to) then you don't need the -F flag at all, declare your reports, then do a "use-report" followed by a "new-report" before you print anything. The "new-report" will allow you to change the file name of the report, and you can then use the "use-report" command to switch between outputs (w/o another "new-report"). HTH, ----------------------------------------------------------------------- Donald Mellen | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/ donm@ontko.com | "In the beginning, there was nothing, which exploded" From owner-sqr-users@list.iex.net Tue Jan 5 16:55:33 1999 Date: Tue, 5 Jan 1999 13:26:41 -0800 From: Grant Chappell Subject: SQR viewer - (SQR 5) Corrupt message file: Invalid header information I'm running SQR version 3.0.16.4 on NT 4.0 service pack 3. SQR reporter works fine. When I try to run SQR viewer I this message " (SQR 5) Corrupt message file: Invalid header information." I check the sqr.ini file and SQRDIR is set correctly in both places. Just to be on the safe side I added SQRDIR to my NT environment settings list. I looked through the SQRUG archives and could not find an exact reference to this problem. The archive did have a reference to an "Invalid count..." which then discussed properly setting SQRDIR as a solution. There was also a reference to sqrerr.dat, but not a thorough discussion so I didn't try anything. I also searched PeopleSofts web site but did not find anything. Could someone please shed a little light on this problem. Grant From owner-sqr-users@list.iex.net Tue Jan 5 18:18:20 1999 Date: Tue, 5 Jan 1999 14:30:58 PST From: Parijat Sahai Subject: Re: SQR viewer - (SQR 5) Corrupt message file: Invalid header information All you need to do is to replace sqrverr.dat file from your release media, i.e., installation diskette. That'll correct the problem. Parijat. >Date: Tue, 5 Jan 1999 13:26:41 -0800 >Reply-To: SQR-USERS@USA.NET >From: Grant Chappell >Subject: SQR viewer - (SQR 5) Corrupt message file: Invalid header > information >To: Multiple recipients of list SQR-USERS > >I'm running SQR version 3.0.16.4 on NT 4.0 service pack 3. > >SQR reporter works fine. When I try to run SQR viewer I this message " (SQR >5) Corrupt message file: Invalid header information." I check the sqr.ini >file and SQRDIR is set correctly in both places. Just to be on the safe >side I added SQRDIR to my NT environment settings list. I looked through >the SQRUG archives and could not find an exact reference to this problem. >The archive did have a reference to an "Invalid count..." which then >discussed properly setting SQRDIR as a solution. There was also a reference >to sqrerr.dat, but not a thorough discussion so I didn't try anything. I >also searched PeopleSofts web site but did not find anything. > >Could someone please shed a little light on this problem. > >Grant > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Tue Jan 5 20:19:44 1999 Date: Tue, 5 Jan 1999 17:12:18 -0800 From: Grant Chappell Subject: Re: SQR viewer - (SQR 5) Corrupt message file: Invalid header information Here is the answer I got from PeopleSoft. Your response is the same as #2. A few things to check: 1) What is the version of SQR that you are trying to use? Please refer to the file called VERSION in the SQRBINW directory. 2) Do you have a file call SQRVERR.DAT (this is different than SQRERR.DAT) in the SQRBINW directory? Try re-loading it from the CD. 3) In the SQR.INI file, you should have the SQRDIR environment variable defined under the [Environment:Common] and [Environment:ODBC] sections. They should both point to the SQRBINW directory -- the directory where the SQRW.EXE and SQRWV.EXE reside. 4) What type of network are you currently on? Banyan Vines? NFS? Other? -----Original Message----- From: Discussion of SQR, SQRIBE Technologies's database reporting language [mailto:SQR-USERS@list.iex.net] On Behalf Of Parijat Sahai Sent: Tuesday, January 05, 1999 2:31 PM To: Multiple recipients of list SQR-USERS Subject: Re: SQR viewer - (SQR 5) Corrupt message file: Invalid header information All you need to do is to replace sqrverr.dat file from your release media, i.e., installation diskette. That'll correct the problem. Parijat. >Date: Tue, 5 Jan 1999 13:26:41 -0800 >Reply-To: SQR-USERS@USA.NET >From: Grant Chappell >Subject: SQR viewer - (SQR 5) Corrupt message file: Invalid header > information >To: Multiple recipients of list SQR-USERS > >I'm running SQR version 3.0.16.4 on NT 4.0 service pack 3. > >SQR reporter works fine. When I try to run SQR viewer I this message " (SQR >5) Corrupt message file: Invalid header information." I check the sqr.ini >file and SQRDIR is set correctly in both places. Just to be on the safe >side I added SQRDIR to my NT environment settings list. I looked through >the SQRUG archives and could not find an exact reference to this problem. >The archive did have a reference to an "Invalid count..." which then >discussed properly setting SQRDIR as a solution. There was also a reference >to sqrerr.dat, but not a thorough discussion so I didn't try anything. I >also searched PeopleSofts web site but did not find anything. > >Could someone please shed a little light on this problem. > >Grant > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jan 6 05:47:38 1999 Date: Wed, 6 Jan 1999 18:42:33 +0800 From: Raja Gade Subject: Re: Date format from YYYYDDD TO DD-MON-YYYY I am trying to convert the date format from yyyyddd to dd-mon-yyyy in sqr. For example 198345 to 11-DEC-1998 In oracle the solution is SQL> SELECT TO_CHAR(TO_DATE('1998345','YYYYDDD'),'DD-MON-YYYY') FROM DUAL; TO_CHAR(TO_ ----------- 11-DEC-1998 Can someone help me in modifying the date format from yyyyddd to dd-mon-yyyy format in SQR I am using SQR ver 3.0 ,Oracle Database & peoplesoft 6 financials. Raja From owner-sqr-users@list.iex.net Wed Jan 6 08:57:24 1999 Date: Wed, 6 Jan 1999 08:45:57 -0500 From: "Ranade, Sameer" Subject: Re: Date format from YYYYDDD TO DD-MON-YYYY Hi Raja, U can use the same SQL inside SQR to get required formatting. begin-select TO_CHAR(TO_DATE($dtin ,'YYYYDDD'),'DD-MON-YYYY') &dtout move &dtout to $dtout FROM DUAL end-sql HTH, -Sameer -----Original Message----- From: Raja Gade [mailto:rgade@ACS.UWA.EDU.AU] Sent: Wednesday, January 06, 1999 5:43 AM To: Multiple recipients of list SQR-USERS Subject: Re: Date format from YYYYDDD TO DD-MON-YYYY I am trying to convert the date format from yyyyddd to dd-mon-yyyy in sqr. For example 198345 to 11-DEC-1998 In oracle the solution is SQL> SELECT TO_CHAR(TO_DATE('1998345','YYYYDDD'),'DD-MON-YYYY') FROM DUAL; TO_CHAR(TO_ ----------- 11-DEC-1998 Can someone help me in modifying the date format from yyyyddd to dd-mon-yyyy format in SQR I am using SQR ver 3.0 ,Oracle Database & peoplesoft 6 financials. Raja From owner-sqr-users@list.iex.net Wed Jan 6 09:20:28 1999 Date: Wed, 6 Jan 1999 09:14:02 -0500 From: Dominick Logiudice Subject: Help, SQL buffer to small; Use -mfile to increase buffer size I am getting this error when I am making and additional call to the job table. I get the entire job record and then I want to goback to get additional information just 3 fields from a prior record. on the job table i am using key fields, emplid, date How do I fix this ? From owner-sqr-users@list.iex.net Wed Jan 6 09:30:10 1999 Date: Wed, 6 Jan 1999 05:53:20 -0800 From: Cameron Armbruster Subject: Max Array Size I am writing an SQR which will be using a large predefined array and was wondering if there is a maximum size limit on an SQR array? _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com From owner-sqr-users@list.iex.net Wed Jan 6 10:22:14 1999 Date: Wed, 6 Jan 1999 10:13:31 -0500 From: Carlton Conley Subject: Re: Max Array Size at least in V 3 the max number of arrays in a report is 20 and max fields in an array is 200 From owner-sqr-users@list.iex.net Wed Jan 6 10:44:49 1999 Date: Wed, 6 Jan 1999 10:40:41 -0500 From: Ray Subject: Re: Date format from YYYYDDD TO DD-MON-YYYY On Wed, 6 Jan 1999, Ranade, Sameer wrote: > Hi Raja, > > begin-select > TO_CHAR(TO_DATE($dtin ,'YYYYDDD'),'DD-MON-YYYY') &dtout > move &dtout to $dtout > FROM DUAL > end-select You can also use the SQR functions strtodate and datetostr : let $dtout = datetostr(strtodate($dtin,'YYYYDDD'),'DD-MON-YYYY') HTH, Ray From owner-sqr-users@list.iex.net Wed Jan 6 10:51:50 1999 Date: Wed, 6 Jan 1999 07:47:05 PST From: "madav ." Subject: Re: How to include Instance ID in SQR output file name? Thanks for your valuable input and it saves me time. Madav. >From owner-sqr-users@list.iex.net Tue Jan 5 12:14:13 1999 >Received: from list.iex.net (list.iex.net [192.156.196.15]) by list.iex.net (8.8.5/8.8.5) with SMTP id NAA21620; Tue, 5 Jan 1999 13:13:39 -0700 (MST) >Received: from LIST.IEX.NET by LIST.IEX.NET (LISTSERV-TCP/IP release 1.8b) with > spool id 30306 for SQR-USERS@LIST.IEX.NET; Tue, 5 Jan 1999 13:13:07 > -0700 >Received: from ccci.org (ccci.org [208.135.115.37]) by list.iex.net > (8.8.5/8.8.5) with SMTP id NAA21546 for ; > Tue, 5 Jan 1999 13:12:58 -0700 (MST) >Received: from HQ-Message_Server by ccci.org with Novell_GroupWise; Tue, 05 Jan > 1999 15:12:30 -0500 >X-Mailer: Novell GroupWise 5.2 >Mime-Version: 1.0 >Content-Type: text/plain; charset=US-ASCII >Content-Transfer-Encoding: quoted-printable >Content-Disposition: inline >Message-ID: >Date: Tue, 5 Jan 1999 15:12:12 -0500 >Reply-To: SQR-USERS@USA.NET >Sender: "Discussion of SQR, > SQRIBE Technologies's database reporting language" > >From: Brian Nice >Subject: Re: How to include Instance ID in SQR output file name? >X-To: vmadav@HOTMAIL.COM, SQR-USERS@USA.NET >To: Multiple recipients of list SQR-USERS > >In the process definition for that SQR, under the Process Definition = >Options tab, SQR Parameters line, change the drop down to Append and add = >%%INSTANCE%% to the parameter line. Then in your SQR, use an input = >statement to get the command line parameter. > > input $processInstance > >Now that you have the instance, construct a filename, and use the = >NEW-REPORT command in SQR to change the name of the .LIS file. Be sure and = >issue this before any Print statements are done in the SQR. > > let $file =3D 'abc' || $processInstance || .LIS' > new-report $file > >Hope that helps > > >/******************** >* Brian Nice >* Senior Programmer/Analyst >* Campus Crusade for Christ >* bnice@ccci.org >*********************************/ > >>>> "madav ." 01/05 12:01 PM >>> >I would like to pad Process Instance ID from Process Scheduler with in >the SQR report to generate a unique output filename (eg., abc101234.lis >where 101234 is current Instance ID) . > >Any idea to resolve this? >Your help is much appreciated. > >Madav > >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jan 6 10:52:15 1999 Date: Wed, 6 Jan 1999 07:43:01 -0800 From: Cameron Armbruster Subject: max array size I didn't word my last question properly. I was wondering what the maximum memory size of an array is. In other words, how large, as in number of rows, not number of fields, can my array be. I have already created an array that is about 11 meg, but am wondering how much larger I can go. Cameron _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com From owner-sqr-users@list.iex.net Wed Jan 6 10:52:39 1999 Date: Wed, 6 Jan 1999 10:48:21 -0500 From: Don Mellen Subject: Re: Date format from YYYYDDD TO DD-MON-YYYY On Wed, 6 Jan 1999, Ray wrote: > You can also use the SQR functions strtodate and datetostr : > > let $dtout = datetostr(strtodate($dtin,'YYYYDDD'),'DD-MON-YYYY') One could if one had version 4.x, but this question came from a version 3.x individual. Version 3.x does not contain the date functions. ----------------------------------------------------------------------- Donald Mellen | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/ donm@ontko.com | "In the beginning, there was nothing, which exploded" From owner-sqr-users@list.iex.net Wed Jan 6 11:40:49 1999 Date: Wed, 6 Jan 1999 11:19:50 -0500 From: Brian Nice Subject: Re: How to include Instance ID in SQR output file name? Your welcome. There is an easier way that I didn't think of when I sent the message. When you do the calls in the SQR do Define-Prcs-Vars do Get-Run-Control-Parms (these are in prcsapi.sqc and prcsdef.sqc) it gets a process instance for you: #prcs_process_instance You should be able to use that variable. That should be easier! /******************** * Brian Nice * Senior Programmer/Analyst * Campus Crusade for Christ * bnice@ccci.org *********************************/ >>> "madav ." 01/06 10:47 AM >>> Thanks for your valuable input and it saves me time. Madav. >From owner-sqr-users@list.iex.net Tue Jan 5 12:14:13 1999 >Received: from list.iex.net (list.iex.net [192.156.196.15]) by list.iex.net (8.8.5/8.8.5) with SMTP id NAA21620; Tue, 5 Jan 1999 13:13:39 -0700 (MST) >Received: from LIST.IEX.NET by LIST.IEX.NET (LISTSERV-TCP/IP release 1.8b) with > spool id 30306 for SQR-USERS@LIST.IEX.NET; Tue, 5 Jan 1999 13:13:07 > -0700 >Received: from ccci.org (ccci.org [208.135.115.37]) by list.iex.net > (8.8.5/8.8.5) with SMTP id NAA21546 for ; > Tue, 5 Jan 1999 13:12:58 -0700 (MST) >Received: from HQ-Message_Server by ccci.org with Novell_GroupWise; Tue, 05 Jan > 1999 15:12:30 -0500 >X-Mailer: Novell GroupWise 5.2 >Mime-Version: 1.0 >Content-Type: text/plain; charset=US-ASCII >Content-Transfer-Encoding: quoted-printable >Content-Disposition: inline >Message-ID: >Date: Tue, 5 Jan 1999 15:12:12 -0500 >Reply-To: SQR-USERS@USA.NET >Sender: "Discussion of SQR, > SQRIBE Technologies's database reporting language" > >From: Brian Nice >Subject: Re: How to include Instance ID in SQR output file name? >X-To: vmadav@HOTMAIL.COM, SQR-USERS@USA.NET >To: Multiple recipients of list SQR-USERS > >In the process definition for that SQR, under the Process Definition = >Options tab, SQR Parameters line, change the drop down to Append and add = >%%INSTANCE%% to the parameter line. Then in your SQR, use an input = >statement to get the command line parameter. > > input $processInstance > >Now that you have the instance, construct a filename, and use the = >NEW-REPORT command in SQR to change the name of the .LIS file. Be sure and = >issue this before any Print statements are done in the SQR. > > let $file =3D 'abc' || $processInstance || .LIS' > new-report $file > >Hope that helps > > >/******************** >* Brian Nice >* Senior Programmer/Analyst >* Campus Crusade for Christ >* bnice@ccci.org >*********************************/ > >>>> "madav ." 01/05 12:01 PM >>> >I would like to pad Process Instance ID from Process Scheduler with in >the SQR report to generate a unique output filename (eg., abc101234.lis >where 101234 is current Instance ID) . > >Any idea to resolve this? >Your help is much appreciated. > >Madav > >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jan 6 14:04:48 1999 Date: Wed, 6 Jan 1999 11:55:52 -0700 From: "Eaton, Robert" Subject: Manual Feed for LaserJet 5 I am running SQR3, Windows '95, SQL Base with CSS HRizon which I also think is People Soft. Can anyone tell me how to get a LaserJet 5 to expect manual feed when I want to print a single check instead of having to use the printer menus. From owner-sqr-users@list.iex.net Wed Jan 6 14:11:26 1999 Date: Wed, 6 Jan 1999 11:02:34 PST From: Deepak Shirguppi Subject: Re: max array size I think there is a limit for the max size of an array . It is set in the allmaxes.max file . Also in a single sqr program a max of 20 arrays with a max of 200 fields per array is permitted. Also each array cannot cross 64k . How did u manage to create an array of 11MB. Curious ???? -- Deepak. >From: Cameron Armbruster >Subject: max array size >To: Multiple recipients of list SQR-USERS > >I didn't word my last question properly. I was wondering what the >maximum memory size of an array is. In other words, how large, as in >number of rows, not number of fields, can my array be. I have >already created an array that is about 11 meg, but am wondering how >much larger I can go. > >Cameron ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jan 6 14:22:44 1999 Date: Wed, 6 Jan 1999 13:19:20 -0600 From: Richard Tomancikl Subject: Re: Date format from YYYYDDD TO DD-MON-YYYY This date issue is not deep one but it is something that you run into all the time, like when an outside vendor wants an interface with the date in their new favorite format. If you use PeopleSoft, the datetime.sqc is used to stay platform independent. But their formats are limited. And its better to use the platform specific functions to select and format the date the way you want it. The new cool thing I figured out today is that you can use the 'select from dual' on fields that are not even in 'dual' or any table. Probably not something you want to do all the time, but if you are converting unusual (at least to me) like Julian concatenated with a year, it's quick. See my SQR code below. !*********************************************** begin-procedure main-proc let $date_text1 = '01-FEB-1999' let $date_text2 = '1998125' begin-select to_char( to_date( $date_text1, 'DD-MON-YYYY'), 'YYYYDDD SYEAR Q MONTH RM WW W D') &test_date1 to_char( to_date( $date_text2, 'YYYYDDD'), 'DD-MON-YYYY') &test_date2 from dual end-select display '&test_date1: ' noline display &test_date1 display '&test_date2: ' noline display &test_date2 end-procedure main-proc !*********************************************** Result: &test_date1: 1999032 NINETEEN NINETY-NINE 1 FEBRUARY II 05 1 2 &test_date2: 05-MAY-1998 OK, so I got a little carried away with Oracles format options but you get the idea. RT From owner-sqr-users@list.iex.net Wed Jan 6 14:40:45 1999 Date: Wed, 6 Jan 1999 14:34:08 -0500 From: Guy Simonian Subject: Getting PeopleSoft Panel Name Is there a way to find out which Peoplesoft panel invoked the SQR process. I have several panels that call 1 SQR and want to find out which one it was that started the job. I can get the RUN_CNTL_ID and OPER_ID, of course, but am looking for a way to get the panel name. Guy From owner-sqr-users@list.iex.net Wed Jan 6 14:43:06 1999 Date: Wed, 6 Jan 1999 14:21:28 -0500 From: Helen Moore Subject: Re: Manual Feed for LaserJet 5 I am using the following statement in my code encode '<27>&l2H' into $top_tray print $top_tray () code Helen At 11:55 AM 1/6/99 -0700, you wrote: >I am running SQR3, Windows '95, SQL Base with CSS HRizon which I also think >is People Soft. Can anyone tell me how to get a LaserJet 5 to expect manual >feed when I want to print a single check instead of having to use the >printer menus. > Helen Moore Senior Programmer Analyst IT/IIS James Madison University From owner-sqr-users@list.iex.net Wed Jan 6 15:31:06 1999 Date: Wed, 6 Jan 1999 15:24:41 -0500 From: Mark Kraft Subject: SQR Not finding Rows Ok, I have a rather interesting problem, I have an SQR that has worked in the past, but all of a sudden, it is not retrieving any rows from the database. I know this sounds like an easy question, but here is the kicker. I Cut & Paste the SQL from the SQR into SQL*Plus in the same database instance, and the SQL brings back the correct rows. I have set a flag in the SQR to see if any rows are being fetched and the flag shows that there are no rows fetched. Does Anyone have any ideas why this could be happening. Thanks ahead of time. Mark Kraft mkraft@gunet.georgetown.edu From owner-sqr-users@list.iex.net Wed Jan 6 15:35:10 1999 Date: Wed, 6 Jan 1999 15:26:39 -0500 From: Brian Nice Subject: Re: Getting PeopleSoft Panel Name This is probably not the best way, but you could make a derived work record with a field on it that could hold the panel name. record_der.panel_name Add that field to all the panels that can run the SQR and initialize it to the panel name upon entering the panel with peoplecode. Then on the SQR parameters line in the process definition, pass it as a parameter :record_der.panel_name Then use an input statement in the SQR to get the command line parameter (in this case the panel name) and parse it from there. I'm sure there is a better way, and this may be hard to maintain, but it could be an option. HTH /******************** * Brian Nice * Senior Programmer/Analyst * Campus Crusade for Christ * bnice@ccci.org *********************************/ >>> Guy Simonian 01/06 2:34 PM >>> Is there a way to find out which Peoplesoft panel invoked the SQR process. I have several panels that call 1 SQR and want to find out which one it was that started the job. I can get the RUN_CNTL_ID and OPER_ID, of course, but am looking for a way to get the panel name. Guy From owner-sqr-users@list.iex.net Wed Jan 6 15:41:24 1999 Date: Wed, 6 Jan 1999 12:02:43 -0800 From: Les Hancock Subject: Re: Getting PeopleSoft Panel Name For SQR's run thru the Process Scheduler, you can find the Panel Group Name(s) (see PS_PRCSDEFNPNL) if you know the name of the SQR. But, not the panel. For SQR's run thru Peoplecode, you could pass an additional parameter to the SQR to tell it from what Panel it was being run from. Les ---Guy Simonian wrote: > > Is there a way to find out which Peoplesoft panel invoked the SQR process. > > I have several panels that call 1 SQR and want to find out which one it was that started the job. > > I can get the RUN_CNTL_ID and OPER_ID, of course, but am looking for a way to get the panel name. > > Guy > _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com From owner-sqr-users@list.iex.net Wed Jan 6 15:41:53 1999 Date: Wed, 6 Jan 1999 15:35:51 -0500 From: Brian Nice Subject: Re: SQR Not finding Rows Did you need to issue a commit some place? This may not be the case, but one thing that has driven me nuts is when I do an insert into a table in SQLTalk and do not issue a commit and then run the SQR. The SQR doesn't pick up any of the inserts that happened in SQLTalk because I didn't commit. /******************** * Brian Nice * Senior Programmer/Analyst * Campus Crusade for Christ * bnice@ccci.org *********************************/ >>> Mark Kraft 01/06 3:24 PM >>> Ok, I have a rather interesting problem, I have an SQR that has worked in the past, but all of a sudden, it is not retrieving any rows from the database. I know this sounds like an easy question, but here is the kicker. I Cut & Paste the SQL from the SQR into SQL*Plus in the same database instance, and the SQL brings back the correct rows. I have set a flag in the SQR to see if any rows are being fetched and the flag shows that there are no rows fetched. Does Anyone have any ideas why this could be happening. Thanks ahead of time. Mark Kraft mkraft@gunet.georgetown.edu From owner-sqr-users@list.iex.net Wed Jan 6 16:10:14 1999 Date: Wed, 6 Jan 1999 16:03:54 EST From: Venugopala R vatti Subject: How to run a shell script with in sqr and check status As a part of our pay cycle we need to FTP check file after verifying amounts. Currently one sqr(chverify.sqr) verifyes check totals. Based on the success of this sqr(chverify.sqr), check file will be manually sent to file print server. Is there any way to run this FTP shell script with in the sqr(chverify.sqr) and check the status of FTP. Thanks for any help. From owner-sqr-users@list.iex.net Wed Jan 6 16:37:49 1999 Date: Wed, 6 Jan 1999 13:26:54 -0800 From: Les Hancock Subject: Re: How to run a shell script with in sqr and check status In SQR, set #return-status -- (Pre-defined variable) -- "Value to be returned to the operating system when SQR exits". Set this just before SQR ends. Then let UNIX script act appropriately based on value of return code. ---Venugopala R vatti wrote: > > As a part of our pay cycle we need to FTP check file after verifying amounts. > Currently one sqr(chverify.sqr) verifyes check totals. Based on the success > of this sqr(chverify.sqr), check file will be manually sent to file print > server. Is there any way to run this FTP shell script with in the > sqr(chverify.sqr) and check the status of FTP. > > Thanks for any help. > _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com From owner-sqr-users@list.iex.net Wed Jan 6 16:43:38 1999 Date: Wed, 6 Jan 1999 16:30:15 -0500 From: Ray Ontko Subject: Re: max array size Cameron, I assume that you're working on a NON-Windows platform. For Windows, see BULLETIN.TXT (T-00007) which should be in the "readme" directory of the SQR distribution. The basic idea is that on 16-bit systems, each char field takes 6 bytes per row, and each number takes 8 bytes per row, so under Windows, I think you're limited to about 1092 char rows or 819 number rows. For Unix, I think the limitation is on the amount of virtual memory your operating system can allocate for a process. I believe that this is depends on the site-specific unix parameters. Hope this helps. Ray > I didn't word my last question properly. I was wondering what the > maximum memory size of an array is. In other words, how large, as in > number of rows, not number of fields, can my array be. I have already > created an array that is about 11 meg, but am wondering how much > larger I can go. > > Cameron > > > > > _________________________________________________________ > DO YOU YAHOO!? > Get your free @yahoo.com address at http://mail.yahoo.com > ---------------------------------------------------------------------- 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@list.iex.net Wed Jan 6 16:58:19 1999 Date: Wed, 6 Jan 1999 13:52:35 PST From: "madav ." Subject: Re: How to include Instance ID in SQR output file name? You are correct , I did same way , I got solution. Thanks to Brian and Tony. -Madav >From owner-sqr-users@list.iex.net Wed Jan 6 08:41:17 1999 >Received: from list.iex.net (list.iex.net [192.156.196.15]) by list.iex.net (8.8.5/8.8.5) with SMTP id JAA03048; Wed, 6 Jan 1999 09:40:17 -0700 (MST) >Received: from LIST.IEX.NET by LIST.IEX.NET (LISTSERV-TCP/IP release 1.8b) with > spool id 27269 for SQR-USERS@LIST.IEX.NET; Wed, 6 Jan 1999 09:34:38 > -0700 >Received: from mx04.netaddress.usa.net (mx04.netaddress.usa.net > [204.68.24.141]) by list.iex.net (8.8.5/8.8.5) with SMTP id JAA01122 > for ; Wed, 6 Jan 1999 09:20:09 -0700 (MST) >Received: (qmail 24967 invoked by uid 0); 6 Jan 1999 16:20:09 -0000 >Received: from ccci.org [208.135.115.37] by mx04 via mtad (2.6) with ESMTP id > 139DaFqui0047M04; Wed, 06 Jan 1999 16:20:08 GMT >Received: from HQ-Message_Server by ccci.org with Novell_GroupWise; Wed, 06 Jan > 1999 11:20:07 -0500 >X-Mailer: Novell GroupWise 5.2 >Mime-Version: 1.0 >Content-Type: text/plain; charset=US-ASCII >Content-Transfer-Encoding: quoted-printable >Content-Disposition: inline >Message-ID: >Date: Wed, 6 Jan 1999 11:19:50 -0500 >Reply-To: SQR-USERS@USA.NET >Sender: "Discussion of SQR, > SQRIBE Technologies's database reporting language" > >From: Brian Nice >Subject: Re: How to include Instance ID in SQR output file name? >X-To: SQR-USERS@USA.NET >To: Multiple recipients of list SQR-USERS > >Your welcome. There is an easier way that I didn't think of when I sent = >the message. When you do the calls in the SQR > do Define-Prcs-Vars > do Get-Run-Control-Parms >(these are in prcsapi.sqc and prcsdef.sqc) > >it gets a process instance for you: > #prcs_process_instance > >You should be able to use that variable. >That should be easier! > > >/******************** >* Brian Nice >* Senior Programmer/Analyst >* Campus Crusade for Christ >* bnice@ccci.org >*********************************/ > >>>> "madav ." 01/06 10:47 AM >>> >Thanks for your valuable input and it saves me time. > >Madav. > >>From owner-sqr-users@list.iex.net Tue Jan 5 12:14:13 1999 >>Received: from list.iex.net (list.iex.net [192.156.196.15]) by >list.iex.net (8.8.5/8.8.5) with SMTP id NAA21620; Tue, 5 Jan 1999 >13:13:39 -0700 (MST) >>Received: from LIST.IEX.NET by LIST.IEX.NET (LISTSERV-TCP/IP release >1.8b) with >> spool id 30306 for SQR-USERS@LIST.IEX.NET; Tue, 5 Jan 1999 >13:13:07 >> -0700 >>Received: from ccci.org (ccci.org [208.135.115.37]) by list.iex.net >> (8.8.5/8.8.5) with SMTP id NAA21546 for >; >> Tue, 5 Jan 1999 13:12:58 -0700 (MST) >>Received: from HQ-Message_Server by ccci.org with Novell_GroupWise; >Tue, 05 Jan >> 1999 15:12:30 -0500 >>X-Mailer: Novell GroupWise 5.2 >>Mime-Version: 1.0 >>Content-Type: text/plain; charset=3DUS-ASCII >>Content-Transfer-Encoding: quoted-printable >>Content-Disposition: inline >>Message-ID: >>Date: Tue, 5 Jan 1999 15:12:12 -0500 >>Reply-To: SQR-USERS@USA.NET=20 >>Sender: "Discussion of SQR, >> SQRIBE Technologies's database reporting language" >> >>From: Brian Nice >>Subject: Re: How to include Instance ID in SQR output file name? >>X-To: vmadav@HOTMAIL.COM, SQR-USERS@USA.NET=20 >>To: Multiple recipients of list SQR-USERS >> >>In the process definition for that SQR, under the Process Definition =3D >>Options tab, SQR Parameters line, change the drop down to Append and >add =3D >>%%INSTANCE%% to the parameter line. Then in your SQR, use an input =3D >>statement to get the command line parameter. >> >> input $processInstance >> >>Now that you have the instance, construct a filename, and use the =3D >>NEW-REPORT command in SQR to change the name of the .LIS file. Be sure >and =3D >>issue this before any Print statements are done in the SQR. >> >> let $file =3D3D 'abc' || $processInstance || .LIS' >> new-report $file >> >>Hope that helps >> >> >>/******************** >>* Brian Nice >>* Senior Programmer/Analyst >>* Campus Crusade for Christ >>* bnice@ccci.org=20 >>*********************************/ >> >>>>> "madav ." 01/05 12:01 PM >>> >>I would like to pad Process Instance ID from Process Scheduler with in >>the SQR report to generate a unique output filename (eg., abc101234.lis >>where 101234 is current Instance ID) . >> >>Any idea to resolve this? >>Your help is much appreciated. >> >>Madav >> >>______________________________________________________ >>Get Your Private, Free Email at http://www.hotmail.com=20 >> > > >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jan 6 17:05:50 1999 Date: Wed, 6 Jan 1999 14:00:45 PST From: mahesh bhor Subject: Re: SQR Not finding Rows Mark , We once faced such problem . RDBMS - Informix ( -- is comment ) My code was something like this - begin-select count(*) from ps_dept_tbl where [$condn1] --and deptid like '01%' and [$condn2] and [$condn3] end-select The condition for deptid was put in for testing & for actual run instead of '!' , '--' was put as comment . Because of this the cursor built was 'select count(*) from ps_dept_tbl where [$condn1] --and ..'. All conditions after '--' were never executed since all statements were considered as comments . Maybe you can run the SQR with -S option to get the cursor and check the cursor . Hope this helps . Mahesh ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Jan 6 18:37:50 1999 Date: Wed, 6 Jan 1999 18:38:13 -0500 From: Tony DeLia Subject: Re: Getting PeopleSoft Panel Name Guy, This is probably the easiest way to obtain the Panel name from within the SQR process... very slight modifications required... A - Add the field PNLNAME to your Run Control Record (hopefully you're using a custom Run Control instead of delivered)... B - Under PNLNAME.RowInit (for the Run Control Record) add this line of PeopleCode: PNLNAME = %Panel; C - In your SQR add the field PNLNAME to the Run Control Select list: begin-select rc.pnlname let $PNL_name = &rc.pnlname from ps_run_control_xxx where ... end-select D - BINGO!!! display $PNL_name This should suit your needs without adding any complexity... If this is critical there should be no objection to adding a column to the delivered Run Control table(s)... This simple change allows the Panel to be obtained by ALL SQR processes using this Run Control record... If the "derived field" method were used it would have to be added to "every" Run Control Panel AND "every" Process Definition that needed the Panel name via SQR... -Tony DeLia Guy Simonian wrote: > > Is there a way to find out which Peoplesoft panel invoked the SQR process. > > I have several panels that call 1 SQR and want to find out which one it was that started the job. > > I can get the RUN_CNTL_ID and OPER_ID, of course, but am looking for a way to get the panel name. > > Guy -- Tony DeLia AnswerThink Consulting Group PeopleSoft Solutions Practice - Delphi Partners tdelia@erols.com From owner-sqr-users@list.iex.net Wed Jan 6 19:58:03 1999 Date: Wed, 6 Jan 1999 19:49:13 -0800 From: Steve Hall Subject: Command-Line syntax for Connectivity A prosperous and happy New Year to all of us! To run an sqr under DB2 without having to type anything into the command box I can set up a command line like this: sqrexe scriptname connectstring flags p:\ps\sqrbinw\sqrw.exe c:\temp\myscript.sqr DBNAME/USERID/PWD -ic:\temp\ .... where DBNAME/USERID/PWD is the connectivity information. What about to run an sqr under ORACLE. What is the syntax? Is it DBNAME/USERID@PWD? TIA, -S Steve Hall Convoy srh@convoy.com From owner-sqr-users@list.iex.net Wed Jan 6 20:17:32 1999 Date: Wed, 6 Jan 1999 20:17:01 -0500 From: Tony DeLia Subject: Re: SQR Not finding Rows Hi Mark, I like interesting problems... Can you forward the SQR begin-select statement as well as the SQL*Plus version... Without actually seeing the two I can only guess a bind variable (if there's any used at all) isn't set to what you think it is... A mispelled bind variable could wreak havoc... Just a thought... -Tony DeLia Mark Kraft wrote: > > Ok, I have a rather interesting problem, > I have an SQR that has worked in the past, but all of a sudden, it is not > retrieving any rows from the database. I know this sounds like an easy > question, but here is the kicker. I Cut & Paste the SQL from the SQR into > SQL*Plus in the same database instance, and the SQL brings back the > correct rows. I have set a flag in the SQR to see if any rows are being > fetched and the flag shows that there are no rows fetched. Does > Anyone have any ideas why this could be happening. Thanks ahead of > time. > > Mark Kraft > mkraft@gunet.georgetown.edu -- Tony DeLia AnswerThink Consulting Group PeopleSoft Solutions Practice - Delphi Partners tdelia@erols.com From owner-sqr-users@list.iex.net Wed Jan 6 20:49:51 1999 Date: Wed, 6 Jan 1999 17:41:25 -0800 From: Les Hancock Subject: Re: Command-Line syntax for Connectivity For Oracle: Username/Password@DBInstance such as sysadm/sysadm@DEV ---Steve Hall wrote: > > A prosperous and happy New Year to all of us! > > To run an sqr under DB2 without having to type anything into the command box > I can set up a command line like this: > > sqrexe scriptname connectstring flags > p:\ps\sqrbinw\sqrw.exe c:\temp\myscript.sqr DBNAME/USERID/PWD -ic:\temp\ > .... > > where DBNAME/USERID/PWD is the connectivity information. > > What about to run an sqr under ORACLE. What is the syntax? Is it > DBNAME/USERID@PWD? > > TIA, > -S > > > Steve Hall > Convoy > srh@convoy.com > _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com From owner-sqr-users@list.iex.net Wed Jan 6 22:00:36 1999 Date: Thu, 7 Jan 1999 10:54:48 +0800 From: Wayne Perry Subject: Stripping Carriage Returns/Linefeeds from Flat File Could anyone suggest the best way to create a fixed length flat file (used for taxation interfaces) which does not have any carriage return/line feeds at the end of each record ? Is this possible in Sqr ? I have not seen any references to it so I suppose the best option would be to strip out these characters after the file has been created on our server...... We are running on a Sun/Unix platform. TIA Wayne From owner-sqr-users@list.iex.net Thu Jan 7 06:23:49 1999 Date: Thu, 7 Jan 1999 11:13:55 +0000 From: Martin Hunter Subject: Unable to print SQR report direct from Maximo4 or SQRWB4 Dear All, RE: Unable to print direct from PSDI Maximo v4 or SQR WB v4. I am running PSDI Maximo v4 (NT Terminal Server) over an Oracle (Unix) database. Users access the server through Citrix Metaframe, over a Novell LAN. I am having difficulty getting a report that I have written to print directly (i.e. NOT via preview) from both the Maximo front-end and SQRWB. I can preview, and I can print from preview, but an address exception error occurs when I try to print direct. The printers I am trying to print to are on the Novell LAN. Dr Watson for NT has provided me with the associated machine code, which on close inspection reveals a div/0 error. This machine code belongs to SQRP.exe (SQR Print). SQRP.exe's error file logs the error '6602' - which is usually associated with resource problems. This print problem occurs only with one report - all others (some 20+) print directly, and preview, perfectly from both Maximo and SQRWB. These reports include both ones written by PSDI for Maximo, and ones written by myself. There are two avenues that I have so far pursued: (1) Memory inadequate. At first glance the machine code and SQRP.exe errors pointed me towards a lack of memory. However, the server machine has 750MB RAM - so I thought it unlikely that this could be the problem. To be sure I have run the report (through both Maximo and SQRWB) with only skeleton processes and all users logged out. I have also given SQRP.exe real-time memory priority. The problem still occurs. (2) Compilation error. I thought it possible that the SQR compiler has turned out some rubbish on this occasion. To test this, I have compiled my report several times on three different NT Terminal Servers, and tried attaching each server to three separate Oracle databases. I have also re-written the report in a fresh SQR file in order to remove any possible blips in the SQR code. The problem persists. It seems strange also that the preview (SQRV.exe, SQR Viewer) CAN read the report without any problems, but SQR Print (SQRP.exe) should not be able to do the same. If it were a compilation error, could I expect both to fall over? I am assuming that I can print from SQRV.exe because it has it's own print routine, and does not call SQRP.exe. Any ideas? Cheers, Martin Hunter, SSIL. From owner-sqr-users@list.iex.net Thu Jan 7 08:06:54 1999 Date: Thu, 7 Jan 1999 08:03:32 -0500 From: "Ranade, Sameer" Subject: Re: Command-Line syntax for Connectivity It's : username/pwd@dbname HTH, -Sameer -----Original Message----- From: Steve Hall [mailto:srh@CONVOY.COM] Sent: Wednesday, January 06, 1999 10:49 PM To: Multiple recipients of list SQR-USERS Subject: Command-Line syntax for Connectivity A prosperous and happy New Year to all of us! To run an sqr under DB2 without having to type anything into the command box I can set up a command line like this: sqrexe scriptname connectstring flags p:\ps\sqrbinw\sqrw.exe c:\temp\myscript.sqr DBNAME/USERID/PWD -ic:\temp\ ..... where DBNAME/USERID/PWD is the connectivity information. What about to run an sqr under ORACLE. What is the syntax? Is it DBNAME/USERID@PWD? TIA, -S Steve Hall Convoy srh@convoy.com From owner-sqr-users@list.iex.net Thu Jan 7 09:02:42 1999 Date: Thu, 7 Jan 1999 08:59:21 -0500 From: Jeremy Smith Subject: Re: Unable to print SQR report direct from Maximo4 or SQRWB4 I ran into a similar problem when I upgraded to Maximo 3.02. The solution that was passed on to me (from another user as PSDI wsa NO help) was to craete an empty directory on my local hard drive. Then, right click on the shortcut icon that is used to start maximo (be it in the start directory or just on the desktop) and click on 'PROPERTIES' and go to the 'SHORTCUT' tab. In there, delete whatever is in the 'START IN' line and replace it with the path to the newly created empty directory. Once I did this, I was able to print directly. The only painful part of it is that it has to be done on all user systems to all shortcuts that they use to run Maximo. Hope this helps. Jeremy Smith jcsmith@cmu.edu On Thu, 7 Jan 1999 11:13:55 +0000 Martin Hunter wrote: > Dear All, > > RE: Unable to print direct from PSDI Maximo v4 or SQR WB v4. > > I am running PSDI Maximo v4 (NT Terminal Server) over an Oracle (Unix) > database. Users access the server through Citrix Metaframe, over a Novell > LAN. > > I am having difficulty getting a report that I have written to print > directly (i.e. NOT via preview) from both the Maximo front-end and SQRWB. I > can preview, and I can print from preview, but an address exception error > occurs when I try to print direct. The printers I am trying to print to are > on the Novell LAN. > > Dr Watson for NT has provided me with the associated machine code, which on > close inspection reveals a div/0 error. This machine code belongs to > SQRP.exe (SQR Print). > > SQRP.exe's error file logs the error '6602' - which is usually associated > with resource problems. > > This print problem occurs only with one report - all others (some 20+) > print directly, and preview, perfectly from both Maximo and SQRWB. These > reports include both ones written by PSDI for Maximo, and ones written by > myself. > > There are two avenues that I have so far pursued: > > (1) Memory inadequate. > > At first glance the machine code and SQRP.exe errors pointed me towards a > lack of memory. However, the server machine has 750MB RAM - so I thought it > unlikely that this could be the problem. To be sure I have run the report > (through both Maximo and SQRWB) with only skeleton processes and all users > logged out. I have also given SQRP.exe real-time memory priority. The > problem still occurs. > > (2) Compilation error. > > I thought it possible that the SQR compiler has turned out some rubbish on > this occasion. To test this, I have compiled my report several times on > three different NT Terminal Servers, and tried attaching each server to > three separate Oracle databases. I have also re-written the report in a > fresh SQR file in order to remove any possible blips in the SQR code. The > problem persists. > > It seems strange also that the preview (SQRV.exe, SQR Viewer) CAN read the > report without any problems, but SQR Print (SQRP.exe) should not be able to > do the same. If it were a compilation error, could I expect both to fall > over? > > > I am assuming that I can print from SQRV.exe because it has it's own print > routine, and does not call SQRP.exe. > > > Any ideas? > > > Cheers, > > Martin Hunter, SSIL. ---------------------- Jeremy Smith jcsmith@cmu.edu x86093 From owner-sqr-users@list.iex.net Thu Jan 7 09:14:20 1999 Date: Thu, 7 Jan 1999 09:09:05 -0500 From: Mark Kraft Subject: Re: SQR Not finding Rows -Reply This was the problem, thanks for the help. I had given it some thought and the only difference was the comments, but I know they were in there before when it was running fine. I took the comments out of the SQR and everything is running like a champ. Thanks Again for everyone's help. Mark Kraft kraftm@gunet.georgetown.edu >>> mahesh bhor 01/06/99 05:00pm >>> Mark , We once faced such problem . RDBMS - Informix ( -- is comment ) My code was something like this - begin-select count(*) from ps_dept_tbl where [$condn1] --and deptid like '01%' and [$condn2] and [$condn3] end-select The condition for deptid was put in for testing & for actual run instead of '!' , '--' was put as comment . Because of this the cursor built was 'select count(*) from ps_dept_tbl where [$condn1] --and ..'. All conditions after '--' were never executed since all statements were considered as comments . Maybe you can run the SQR with -S option to get the cursor and check the cursor . Hope this helps . Mahesh ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Thu Jan 7 09:20:35 1999 Date: Thu, 7 Jan 1999 09:15:11 -0500 From: Mark Kraft Subject: Re: SQR Not finding Rows -Reply You can check this out if you would like, but for some reason, it just all of a suddent stopped liking the comments at the end. I took them out and it started working fine again. I have no idea why, but here you go. Mark Kraft !************************************************************************ begin-procedure get_journal_header !************************************************************************ let $journal_found = 'N' begin-select JH.BUSINESS_UNIT JH.JOURNAL_ID JH.BBF_DATE JH.FISCAL_YEAR JH.UNPOST_SEQ JH.JOURNAL_DATE JH.POSTED_DATE let $journal_found = 'Y' do process-main FROM ps_jrnl_header JH where JH.bbf_date is null AND JH.JRNL_HDR_STATUS = 'P' !Added 10/21/98 AND JH.SOURCE != 'SQR' !Added 10/21/98 AND JH.TRANS_REF_NUM != 'FJ' !Added 10/21/98 AND JH.JOURNAL_ID = '0000003427' !For Testing Purposes ONLY order by JH.business_unit, JH.journal_id end-select end-procedure get_journal_header SQL Version select JH.BUSINESS_UNIT, JH.JOURNAL_ID, JH.BBF_DATE, JH.FISCAL_YEAR, JH.UNPOST_SEQ, JH.JOURNAL_DATE, JH.POSTED_DATE, FROM ps_jrnl_header JH where JH.bbf_date is null AND JH.JRNL_HDR_STATUS = 'P' AND JH.SOURCE != 'SQR' AND JH.TRANS_REF_NUM != 'FJ' AND JH.JOURNAL_ID = '0000003427' order by JH.business_unit, JH.journal_id >>> Tony DeLia 01/06/99 08:17pm >>> Hi Mark, I like interesting problems... Can you forward the SQR begin-select statement as well as the SQL*Plus version... Without actually seeing the two I can only guess a bind variable (if there's any used at all) isn't set to what you think it is... A mispelled bind variable could wreak havoc... Just a thought... -Tony DeLia Mark Kraft wrote: > > Ok, I have a rather interesting problem, > I have an SQR that has worked in the past, but all of a sudden, it is not > retrieving any rows from the database. I know this sounds like an easy > question, but here is the kicker. I Cut & Paste the SQL from the SQR into > SQL*Plus in the same database instance, and the SQL brings back the > correct rows. I have set a flag in the SQR to see if any rows are being > fetched and the flag shows that there are no rows fetched. Does > Anyone have any ideas why this could be happening. Thanks ahead of > time. > > Mark Kraft > mkraft@gunet.georgetown.edu -- Tony DeLia AnswerThink Consulting Group PeopleSoft Solutions Practice - Delphi Partners tdelia@erols.com From owner-sqr-users@list.iex.net Thu Jan 7 09:54:55 1999 Date: Thu, 7 Jan 1999 08:54:01 -0600 From: Richard Tomancikl Subject: Re: Stripping Carriage Returns/Linefeeds from Flat File Page 51, SQRW3 Users Guide: FIXED_NOLF - This file type specifies that all records contained within the file are the same length with no line terminator (no CR or LF, I checked in HEX mode). When writing records, SQR pads short records with the blank characters to insure each record is the same length. Just tested the following command syntax and it works. open 'c:\temp\test.txt' as 1 for-writing record=20:fixed_nolf >From a select: write 1 from 'Another Record':14 Results: Another Record Another Record Another Record Another Record Anot................................... Without the line-terminator, it will appear all on one line in any editor. I had done this before, but not in SQRW yet, so I had to try it. Richard Tomancik Wayne Perry on 01/06/99 08:54:48 PM Please respond to SQR-USERS@USA.NET To: Multiple recipients of list SQR-USERS cc: (bcc: Richard Tomancik/Consultant/Dallas/TIG) Subject: Stripping Carriage Returns/Linefeeds from Flat File Could anyone suggest the best way to create a fixed length flat file (used for taxation interfaces) which does not have any carriage return/line feeds at the end of each record ? Is this possible in Sqr ? I have not seen any references to it so I suppose the best option would be to strip out these characters after the file has been created on our server...... We are running on a Sun/Unix platform. TIA Wayne From owner-sqr-users@list.iex.net Thu Jan 7 14:30:51 1999 Date: Thu, 7 Jan 1999 13:31:15 -0600 From: Chuck Chauvin Subject: Re: Command-Line syntax for Connectivity This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BE3A74.4B0BDB50 Content-Type: text/plain; charset="iso-8859-1" However, if I'm not mistaken, everyone with access to the logs will be able to read your password. If you enter Username@DBInstance , you will be prompted for your password, and others will not be able to read it. HTH -----Original Message----- From: Les Hancock [SMTP:les_hanc@YAHOO.COM] To: Multiple recipients of list SQR-USERS For Oracle: Username/Password@DBInstance such as sysadm/sysadm@DEV ------_=_NextPart_001_01BE3A74.4B0BDB50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Command-Line syntax for Connectivity

However, if I'm not mistaken, everyone = with access to the logs will be able to read your password.  If = you enter Username@DBInstance, you will be prompted for your password, and others = will not be able to read it.

HTH

    -----Original = Message-----
    From:   Les Hancock = [SMTP:les_hanc@YAHOO.COM]
    To:     Multiple recipients of list SQR-USERS

    For Oracle:


    Username/Password@DBInstance

    such as

    sysadm/sysadm@DEV

------_=_NextPart_001_01BE3A74.4B0BDB50-- From owner-sqr-users@list.iex.net Thu Jan 7 15:44:03 1999 Date: Thu, 7 Jan 1999 15:40:47 -0500 From: Tony DeLia Subject: Re: SQR Not finding Rows -Reply Mark, I read you're additional follow-up post where you said the comments were removed and it ran fine after... Here's something else you can try... Put the comments back where they were and replace the conditional operators that read != with <>... Using the exclamation point as an operator AND a comment on the same line could give strange results... I've run into this before - I don't use the != (not equal) condition for this reason... -Tony DeLia Mark Kraft wrote: > > You can check this out if you would like, but for some reason, it just all of > a suddent stopped liking the comments at the end. I took them out and it > started working fine again. I have no idea why, but here you go. > > Mark Kraft > > !************************************************************************ > begin-procedure get_journal_header > !************************************************************************ > let $journal_found = 'N' > > begin-select > JH.BUSINESS_UNIT > JH.JOURNAL_ID > JH.BBF_DATE > JH.FISCAL_YEAR > JH.UNPOST_SEQ > JH.JOURNAL_DATE > JH.POSTED_DATE > > let $journal_found = 'Y' > do process-main > > FROM ps_jrnl_header JH > where JH.bbf_date is null > AND JH.JRNL_HDR_STATUS = 'P' !Added 10/21/98 > AND JH.SOURCE != 'SQR' !Added 10/21/98 > AND JH.TRANS_REF_NUM != 'FJ' !Added 10/21/98 > AND JH.JOURNAL_ID = '0000003427' !For Testing Purposes > ONLY > order by JH.business_unit, JH.journal_id > end-select > end-procedure get_journal_header > > SQL Version > > select > JH.BUSINESS_UNIT, > JH.JOURNAL_ID, > JH.BBF_DATE, > JH.FISCAL_YEAR, > JH.UNPOST_SEQ, > JH.JOURNAL_DATE, > JH.POSTED_DATE, > FROM ps_jrnl_header JH > where JH.bbf_date is null > AND JH.JRNL_HDR_STATUS = 'P' > AND JH.SOURCE != 'SQR' > AND JH.TRANS_REF_NUM != 'FJ' > AND JH.JOURNAL_ID = '0000003427' > order by JH.business_unit, JH.journal_id > > >>> Tony DeLia 01/06/99 08:17pm >>> > Hi Mark, > I like interesting problems... Can you forward the SQR begin-select > statement as well as the SQL*Plus version... Without actually seeing the > two I can only guess a bind variable (if there's any used at all) isn't > set to what you think it is... A mispelled bind variable could wreak > havoc... Just a thought... > -Tony DeLia > > Mark Kraft wrote: > > > > Ok, I have a rather interesting problem, > > I have an SQR that has worked in the past, but all of a sudden, it is not > > retrieving any rows from the database. I know this sounds like an > easy > > question, but here is the kicker. I Cut & Paste the SQL from the SQR > into > > SQL*Plus in the same database instance, and the SQL brings back the > > correct rows. I have set a flag in the SQR to see if any rows are being > > fetched and the flag shows that there are no rows fetched. Does > > Anyone have any ideas why this could be happening. Thanks ahead > of > > time. > > > > Mark Kraft > > mkraft@gunet.georgetown.edu > > -- > Tony DeLia > AnswerThink Consulting Group > PeopleSoft Solutions Practice - Delphi Partners > tdelia@erols.com -- Tony DeLia AnswerThink Consulting Group PeopleSoft Solutions Practice - Delphi Partners tdelia@erols.com From owner-sqr-users@list.iex.net Thu Jan 7 16:18:55 1999 Date: Thu, 7 Jan 1999 13:13:39 -0800 From: Les Hancock Subject: Re: Command-Line syntax for Connectivity I've never been able to get an SQR to run in this manner without specifying the password. I tried this: O:\fs610\SQRBINW\SQRW.EXE c:\misc\sqr\descrb2.sqr -oc:\temp\descrb2.log -fc:\temp\descrb2.lis -mo:\fs610\sqr\allmaxes.max -Io:\fs610\sqr -S sysadm@tech (All on the command line) It never asks me for a password -- I get: (SQR 5528) ORACLE ORLON error -1017 in cursor 0: ORA-01017: invalid username/password; logon denied (SQR 4701) Can't logon to the database. SQRW: Program Aborting. If I am doing something wrong, let me know. I hope that Chuck is correct. I have dozens of icons for SQR's and have the password in the command line in each to save time when executing. I know this is not good for security purposes. LH --------------------------------------------------- ---Chuck Chauvin wrote: > > However, if I'm not mistaken, everyone with access to the logs will be able > to read your password. If you enter Username@DBInstance, > you will be prompted for your password, and > others will not be able to read it. > > HTH > _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com From owner-sqr-users@list.iex.net Thu Jan 7 16:50:40 1999 Date: Thu, 7 Jan 1999 15:35:47 -0600 From: Richard Tomancikl Subject: Re: Command-Line syntax for Connectivity You have to place a question mark in the command line to get it to prompt. The command line below is from an icon on my WinNT desktop. The SQRW dialog box appears and the cursor is at the password line T:\PSOFT\HR701\sqrbinw\sqrw.exe t:\psoft\hr701\sqr\temp.sqr ?username/@hrdev {flags....} You can place the question mark in other places, like program name, and it will prompt you even if the program name is filled in. RT Les Hancock on 01/07/99 03:13:39 PM Please respond to SQR-USERS@USA.NET To: Multiple recipients of list SQR-USERS cc: (bcc: Richard Tomancik/Consultant/Dallas/TIG) Subject: Re: Command-Line syntax for Connectivity I've never been able to get an SQR to run in this manner without specifying the password. I tried this: O:\fs610\SQRBINW\SQRW.EXE c:\misc\sqr\descrb2.sqr -oc:\temp\descrb2.log -fc:\temp\descrb2.lis -mo:\fs610\sqr\allmaxes.max -Io:\fs610\sqr -S sysadm@tech (All on the command line) It never asks me for a password -- I get: (SQR 5528) ORACLE ORLON error -1017 in cursor 0: ORA-01017: invalid username/password; logon denied (SQR 4701) Can't logon to the database. SQRW: Program Aborting. If I am doing something wrong, let me know. I hope that Chuck is correct. I have dozens of icons for SQR's and have the password in the command line in each to save time when executing. I know this is not good for security purposes. LH --------------------------------------------------- ---Chuck Chauvin wrote: > > However, if I'm not mistaken, everyone with access to the logs will be able > to read your password. If you enter Username@DBInstance, > you will be prompted for your password, and > others will not be able to read it. > > HTH > _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com From owner-sqr-users@list.iex.net Thu Jan 7 16:51:03 1999 Date: Thu, 7 Jan 1999 15:37:41 -0600 From: Marian Swenson Subject: Re: Command-Line syntax for Connectivity -Reply This command line works with an Informix database: E:\FsDevl\sqrbinw\sqrw.exe e:\fsdevl\sqr\gls4002.sqr mydatabase/sysadm/sysadmpassword -Ie:\fsdevl\sqr\ -Me:\fsdevl\sqr\allmaxes.max -oc:\temp\sqr.log -pb -cb -printer:lp >>> Les Hancock 01/07/99 03:13pm >>> I've never been able to get an SQR to run in this manner without specifying the password. I tried this: O:\fs610\SQRBINW\SQRW.EXE c:\misc\sqr\descrb2.sqr -oc:\temp\descrb2.log -fc:\temp\descrb2.lis -mo:\fs610\sqr\allmaxes.max -Io:\fs610\sqr -S sysadm@tech (All on the command line) It never asks me for a password -- I get: (SQR 5528) ORACLE ORLON error -1017 in cursor 0: ORA-01017: invalid username/password; logon denied (SQR 4701) Can't logon to the database. SQRW: Program Aborting. If I am doing something wrong, let me know. I hope that Chuck is correct. I have dozens of icons for SQR's and have the password in the command line in each to save time when executing. I know this is not good for security purposes. LH --------------------------------------------------- ---Chuck Chauvin wrote: > > However, if I'm not mistaken, everyone with access to the logs will be able > to read your password. If you enter Username@DBInstance, > you will be prompted for your password, and > others will not be able to read it. > > HTH > _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com From owner-sqr-users@list.iex.net Fri Jan 8 03:31:56 1999 Date: Fri, 8 Jan 1999 03:21:00 -0800 From: Steve Hall Subject: Re: Command-Line syntax for Connectivity This is a multi-part message in MIME format. ------=_NextPart_000_0004_01BE3AB6.50A67E20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Yes, everyone with access to the logs will be able to read passwords. I need to spawn multiple sqr programs - 50 to 100 child programs -hence the need for complete command lines. This is a gaping security hole. The only way around it I can think of is to put some kind of front end together with VB or something? Any other ideas for hiding passwords? -----Original Message----- From: Discussion of SQR, SQRIBE Technologies's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Chuck Chauvin Sent: Thursday, January 07, 1999 11:31 AM To: Multiple recipients of list SQR-USERS Subject: Re: Command-Line syntax for Connectivity However, if I'm not mistaken, everyone with access to the logs will be able to read your password. If you enter Username@DBInstance, you will be prompted for your password, and others will not be able to read it. HTH -----Original Message----- From: Les Hancock [SMTP:les_hanc@YAHOO.COM] To: Multiple recipients of list SQR-USERS For Oracle: Username/Password@DBInstance such as sysadm/sysadm@DEV ------=_NextPart_000_0004_01BE3AB6.50A67E20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Command-Line syntax for Connectivity
Yes, everyone with access to the logs will be able to read=20 passwords.
 
I need to spawn multiple sqr programs - 50 to 100 child = programs -hence=20 the need for complete command lines.
 
This is a gaping security hole. The only = way around it=20 I can think of is to
put some kind of front end together with = VB or=20 something?
 
Any other ideas for hiding passwords?
 
 
-----Original Message-----
From: Discussion of = SQR, SQRIBE=20 Technologies's database reporting language=20 [mailto:SQR-USERS@list.iex.net]On Behalf Of Chuck=20 Chauvin
Sent: Thursday, January 07, 1999 11:31 = AM
To:=20 Multiple recipients of list SQR-USERS
Subject: Re: = Command-Line=20 syntax for Connectivity

However, if I'm not mistaken, = everyone with=20 access to the logs will be able to read your password.  If you=20 enter Username@DBInstance, you will be prompted for your password, and others will = not be able=20 to read it.

HTH

    -----Original = Message-----
    From:  =20 Les Hancock [SMTP:les_hanc@YAHOO.COM]=20
    To:    =20 Multiple recipients of list = SQR-USERS=20

    For Oracle:


    Username/Password@DBInstance

    such as

    sysadm/sysadm@DEV

------=_NextPart_000_0004_01BE3AB6.50A67E20-- From owner-sqr-users@list.iex.net Fri Jan 8 08:01:05 1999 Date: Fri, 8 Jan 1999 06:55:05 -0600 From: Wes Williams Subject: Re: Command-Line syntax for Connectivity -Reply I use VB to launch sqr. command line x = Shell("r:\woclose\sqrwt.exe t:\sqr3\woclosit maximo/maximo/pwd -fC:\spl\", 1) The SQR writes to a file when the process is complete so my VB app knows that it has finished. The VB code is very simple. Hope this helps Wes Williams >>> Steve Hall 01/08/99 05:21am >>> Yes, everyone with access to the logs will be able to read passwords. I need to spawn multiple sqr programs - 50 to 100 child programs -hence the need for complete command lines. This is a gaping security hole. The only way around it I can think of is to put some kind of front end together with VB or something? Any other ideas for hiding passwords? -----Original Message----- From: Discussion of SQR, SQRIBE Technologies's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Chuck Chauvin Sent: Thursday, January 07, 1999 11:31 AM To: Multiple recipients of list SQR-USERS Subject: Re: Command-Line syntax for Connectivity However, if I'm not mistaken, everyone with access to the logs will be able to read your password. If you enter Username@DBInstance, you will be prompted for your password, and others will not be able to read it. HTH -----Original Message----- From: Les Hancock [SMTP:les_hanc@YAHOO.COM] To: Multiple recipients of list SQR-USERS For Oracle: Username/Password@DBInstance such as sysadm/sysadm@DEV From owner-sqr-users@list.iex.net Fri Jan 8 11:50:39 1999 Date: Fri, 8 Jan 1999 16:41:53 +0000 From: Martin Hunter Subject: Possible solution to: Unable to print SQR report direct from Maximo4 or SQRWB4 Dear All, Possible solution to problem raised below. Report will not print directly, but can preview and print from preview. Detail: As far as I am aware, this problem relates to SQRP.exe version 4.0.3, and possibly to earlier versions too. The report will run in PREVIEW, and print from preview, through Maximo (using SQRT.exe) and SQR Workbench, but will NOT PRINT DIRECTLY through either. An SQRP.exe or SQRWB.exe application error may occur; possibly stating a "divide by zero", a memory address exception of some kind, or an "access denied". In extreme cases when using SQRWB, SQRWB may crash and the operating system kills it. You may get a (6602) - Error in the SQR Print error log file, which may relate to a lack of system resources or an access problem. Solutions: (1) SQR.ini FONTS. (a) Find the SQR.ini file, which will probably be under the Windows directory. (b) Find the [fonts] setup section. (c) Check that the font-number that you are using in your report is registered in the SQR.ini. (i) If it isn't - EITHER register the font-number with a valid font OR use a font-number / font that is registered in the SQR.ini. (ii) If it is - check that the font that your font-number points to (e.g 4=Arial,Proportional) actually exists on your system. This may be a particular problem with font 6=AvantGarde,Proportional which does not come as standard with Windows NT 4. NOTE: Despite the fact that the SQR.ini file states that a 'substitute' is used if the SQR application cannot find a font, this is not so with SQRWP.exe 4.0.3 and earlier. You may find that the report previews (through SQRWV.exe) with a font different to that which you chose in your code - e.g Arial instead of AvantGarde. This is SQRWV.exe substituting the font. Unfortunately SQRWP.exe does not do this - it falls over instead. (2) MAXIMO Shortcut (courtacy of Jeremy Smith). (a) Locate the Maximo shortcut, which may reside on the desktop, on the start menu, or both. (b) Create a new directory on your root drive. (c) Click the right button over the Maximo shortcut and select 'properties'. (d) Goto the 'Short-cut' tab and set the 'Start in:' path to your new directory. (e) Run Maximo from the short cut, and try the report. Many thanks for your help again Peter. Regards, Martin Hunter, SSIL. From owner-sqr-users@list.iex.net Fri Jan 8 18:18:57 1999 Date: Fri, 8 Jan 1999 15:12:46 -0800 From: John Cox Subject: SQR Issue - Can I read a Excel Flat File into SQR Variables? Hello All, I have a SQR problem for all you guru's out there. I am trying to read in an excel flat file (saved as a .CSV) and read that into SQR variables. The problem is that some of the variables contain commas... Here's a row from my flat file (.CSV) file JOB,ACCT_CD,Account Code,"paydes,209","Defines a link between the distribution of an employee's earnings to funding from a grant, loan, etc." I want to store this row into these variables into my SQR program $RecName $Fieldname $LongName $Source $Descr The problem is that Excel puts quotes around the columns with a comma in them. Does anyone know a way to code this so I can open this file and read these elements into variables? Every row has a different length of Recname, Fieldname, etc. Thanks for any info... -jc From owner-sqr-users@list.iex.net Fri Jan 8 18:45:50 1999 Date: Fri, 8 Jan 1999 18:40:44 -0500 From: Ray Ontko Subject: Re: SQR Issue - Can I read a Excel Flat File into SQR Variables? JC, Take a look at: http://www.ontko.com/sqr/csv.html You'll find a free collection of SQR procedures to help manipulate CSV files, along with example programs. You should be able to use them to solve your problem. Ray On Fri, Jan 08, 1999 at 03:12:46PM -0800, John Cox wrote: > Hello All, I have a SQR problem for all you guru's out there. I am > trying to read in an excel flat file (saved as a .CSV) and read that into > SQR variables. The problem is that some of the variables contain commas... > Here's a row from my flat file (.CSV) file > > JOB,ACCT_CD,Account Code,"paydes,209","Defines a link between the > distribution of an employee's earnings to funding from a grant, loan, etc." > > I want to store this row into these variables into my SQR program > > $RecName > $Fieldname > $LongName > $Source > $Descr > > The problem is that Excel puts quotes around the columns with a comma in > them. Does anyone know a way to code this so I can > open this file and read these elements into variables? Every row has a > different length of Recname, Fieldname, etc. > Thanks for any info... > > -jc ---------------------------------------------------------------------- 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@list.iex.net Fri Jan 8 18:46:16 1999 Date: Fri, 8 Jan 1999 18:39:16 -0500 From: David Anderson Subject: SQR Issue - Can I read a Excel Flat File into SQR Variables? -Reply This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages. --=_6F38C234.CBAAD6EB Content-Type: text/plain Content-Disposition: inline Here is some code I wrote to attack that very problem. See the attachment and look for the procedure Check-For-Quotes. This is not the best, but it does work! Dave --=_6F38C234.CBAAD6EB Content-Type: text/plain Content-Disposition: attachment; filename="CSV2TXT.SQR" !****************************************************************************** ! CSV2TXT.sqr ! Converts CSV file to fixed length TXT file for PS Import. ! Creates Short_Description, based on first ten characters of description, ! if absent. Gives the user the option to WRITE an new file or APPEND an ! existing file. ! ! ASSUMPTIONS: ! ! INPUT: ! SETUP defines CSV filename (through input command), Path, and TXT filename. ! ! OUTPUT: ! SETUP defines Path and TXT filename. ! ! AUTHOR: ! Computer Management Sciences, Inc (CMSI) 248 262-1495 ! David Anderson (DCA) May 1998 ! ! MODIFICATIONS: ! Company/Name Initials Phone# ! !****************************************************************************** ! CONFIDENTIALITY INFORMATION ! Property of Henry Ford Health System !****************************************************************************** ! ! MODIFICATION HISTORY: ! Date Mod# Request# Initials Description of Modification ! !****************************************************************************** #include 'setenv.sqc' !Determines environment SQR executes in !****************************************************************************** BEGIN-SETUP !****************************************************************************** #define $Path 'm:\jobcod~1\' End-Setup !****************************************************************************** BEGIN-REPORT #debug show 'Begin Report' !****************************************************************************** do Init-DateTime do Init-Number do Get-Current-DateTime do Init-Report let #FileCounter = 1 let $FileCounter = edit(#FileCounter, '009') do Process-Main do Reset do Get-Current-DateTime() move $AsOfNow to $Ended show ' ' show $ReportTitle ', ' $ReportID ' completed at ' $Ended '.' END-REPORT !****************************************************************************** BEGIN-PROCEDURE INIT-REPORT #debug show 'Init Report' !****************************************************************************** do Init-DateTime do Get-Current-DateTime() move $AsOfNow to $Began Get_FileName: input $FileName maxlen=8 'Filename (without extension) to be converted' status=#istat if #istat !=0 show 'Please reenter filename (without extension) with less than 9 chars' goto Get_FileName end-if move 'CSV to TXT Conversion' to $ReportTitle move $FileName to $ReportID show ' ' show $ReportTitle ' began at ' $Began show ' ' END-PROCEDURE !****************************************************************************** BEGIN-PROCEDURE PROCESS-MAIN #debug show 'BEGIN-PROCEDURE PROCESS-MAIN' !****************************************************************************** do Open-Files do Read-File do Close-Files END-PROCEDURE !****************************************************************************** BEGIN-PROCEDURE READ-FILE #debug show 'BEGIN PROCEDURE READ-FILES' !****************************************************************************** while 1 read 1 into $RawData:250 if #End-File show 'Lines Read ' #RecordCount Break else add 1 to #RecordCount add 1 to #RowCount do CHECK-FOR-QUOTES do EXTRACT-DATA do FIX-DEFAULTS if #RecordCount != 1 if #RowCount >= 1000 add 1 to #FileCounter let $FileCounter = edit(#FileCounter, '009') move 0 to #RowCount close 2 let $File = 'Jobcd' || $FileCounter let $OutputFile = {$Path} || $File || '.txt' open $OutputFile as 2 for-writing record=155 end-if do Write-File end-if end-if end-while END-PROCEDURE !****************************************************************************** BEGIN-PROCEDURE CHECK-FOR-QUOTES #debug show 'BEGIN PROCEDURE CHECK-FOR-QUOTES' #debug show #RecordCount ' ' $RawData !****************************************************************************** move '' to $RefinedData let #LineLength = length($RawData) move 0 to #Position move 0 to #QuotesFound while #Position <= #LineLength extract $Value from $RawData #Position 1 if #QuotesFound = 0 if $Value = '"' move 1 to #QuotesFound add 1 to #Position else let $RefinedData = $RefinedData || $Value add 1 to #Position end-if else evaluate $Value when = ',' let $RefinedData = $RefinedData || '-' add 1 to #Position when = '"' move 0 to #QuotesFound add 1 to #Position when-other let $RefinedData = $RefinedData || $Value add 1 to #Position end-evaluate end-if end-while END-PROCEDURE !****************************************************************************** BEGIN-PROCEDURE EXTRACT-DATA #debug show 'BEGIN PROCEDURE EXTRACT-DATA > ' #debug show $RefinedData #debug show #Position ' ' #LineLength !****************************************************************************** unstring $RefinedData by ',' into $L1L2 $DBS_CODE $PS_CODE $EFFECT_DATE $STATUS