From owner-sqr-users@list.iex.net Sun Apr 1 00:05:23 2001 Date: Sun, 1 Apr 2001 00:00:01 -0500 From: Nathan Stratton Treadway Subject: Monthly sqr-users Hints Posting sqr-users Mailing List Hints and Guidelines Nathan Stratton Treadway, Ray Ontko & Co. (nathant@ontko.com) $Revision: 1.8 $ $Date: 2001-01-26 18:09:09-05 $ This document gathers in one location information about the sqr-users mail list. Directions for common list-server commands (including unsubscribing) are given, as are guidelines for list usage. ______________________________________________________________________ Table of Contents 1. Changes Since Previous Version 2. Introduction 2.1 sqr-users Mailing List 2.2 sqr-users Hints and Guidelines Document 2.3 Related Mailing Lists 3. Basic List Server Commands 3.1 Subscribing to the List 3.2 Unsubscribing from the List 3.3 Digests 3.4 Problems 4. Posting to the sqr-users List 4.1 General Guidelines 4.2 Posting a Message 4.3 Replying to a Message 5. Job Announcements ______________________________________________________________________ 1. Changes Since Previous Version Changes since the version dated 2000/11/05: o Egroups has become Yahoo! Groups; changed the psusers and PeopleSoft Fans mailing lists links in the Related Mailing Lists section. 2. Introduction 2.1. sqr-users Mailing List The sqr-users mailing list was created to enable discussion related to the SQR database language from Brio Technology (and to other products in the Brio.Report line). Note: SQR used to be published by SQRIBE Technologies, which was merged into Brio Technology on August 3, 1999. 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 . 2.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 Copyright (C) 1999-2001 by Ray Ontko & Co. It may be freely copied and distributed provided it is not modified in any way and it retains the original copyright notice. 2.3. Related Mailing Lists peoplesoft-fans : PeopleSoft Fans Moderated list covering technical and functional aspects of PeopleSoft. To join, follow the link above, or send any message to "peoplesoft-fans-subscribe@yahoogroups.com". psusers : PeopleSoft Users For questions related to any aspect of PeopleSoft (including PeopleSoft-specific SQR issues). This list has merged with the Peoplesoft Fans mailing list and is no longer active, but the message achive can still be found at the link above. rm-users : ReportMart Users List for discussion of Brio.Portal (previously called ReportMart). To join, follow the link above, or send a message containing the word "subscribe" in the body to "rm-users- request@sqrug.com". 3. Basic List Server Commands Note: The list used to be hosted on usa.net , but the list-hosting service was moved to list.iex.net . The old addresses for the list, list server, and list owner no longer work. A few basic list server commands are listed below. Send these commands as the only line in the body (not the subject line) of an e- mail message sent to "listserv@list.iex.net". 3.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. 3.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. 3.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. 3.4. Problems If the above commands do not work, please contact the list manager at "sqr-users-request@list.iex.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. 4. Posting to the sqr-users List In order to post to the mailing list, you must be subscribed to it (see directions above). 4.1. General Guidelines For any message you send to the list, please: o make sure your mail software is not requesting a "Return Receipt". (If a "Return Receipt Requested" message is sent to the list, several dozen receipt messages will be sent out to the mailing list in reply from other subscribers.) o do not send messages in HTML or other special formats. (These are not usable by many subscribers, especially those who receive their messages in digest format.) o keep in mind that over 500 people will receive your message, and that it will appear in the list archives. Try to keep your messages on-topic and relatively short. Consider sending your message directly to particular people if it won't interest many of the list's subscribers. 4.2. Posting a Message Once you are subscribed, you can post to the list by sending a message to "sqr-users@list.iex.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 Brio 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 or proprietary code, since the posting will be placed in a public web archive.) Note that your question should relate to SQR or other Brio Report 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. 4.3. 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 original 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. (Remember that some people read the mailing list in digest form, and the digests become much larger if unnecessary lines are quoted.) 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. 5. 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 Mon Apr 2 09:22:48 2001 Date: Mon, 2 Apr 2001 10:14:38 -0700 From: Chuck Harkness Subject: new sqr book? Hello SQR Gurus, I own a copy of the "SQR in PeopleSoft and Other Applications" book and I was wondering if there are any other SQR reference books available. I use SQR in combination with MAXIMO and not peoplesoft. I have used this book extensively, but would love to see another good SQR reference. Chuck From owner-sqr-users@list.iex.net Mon Apr 2 14:58:29 2001 Date: Mon, 2 Apr 2001 14:47:53 -0500 From: Yuri Hunter Subject: Printing to HP - Trouble changing point-size in courier font
Greetings to the group -
 
I've written an SQR report that uses Times-Roman font (different sizes with some bold and limited use of boxes).  There are some header and footer fields (e.g., Contact Person) that I pass as parameters to the program that I want to print in Courier to make it plain what fields have been entered by appearing they were "typed in."
 
The problem I'm having is that when I issue the alter-printer command to change the font to Courier 10-pt, the font changes from Times-Roman to Courier, but the size is super small (like 5-pt or less!).
 
I can't make the Courier point-size increase in size on the report output no matter what value I specify in the alter-printer point-size parameter.  A sample of my code follows:
 
#include 'setenv.sqc'          
begin-setup
   #include 'setup02b.sqc'      !Printer specifications for HPLASERJET
end-setup
begin-footing 
     alter-printer font=5 point-size=6
     print 'Contact Person:'                 (,90)    bold
     alter-printer font=3 point-size=10
     print $name                             (,107)   underline
end-footing
 
Platform information:
 
 $sqr-platform   : WINDOWS-NT
 $sqr-ver           : SQR/4.3.4/PC/Windows NT 4.0/Oracle 7.3.4/Jun 03 1999
 
Thanks in advance for any assistance!

Get your FREE download of MSN Explorer at http://explorer.msn.com

From owner-sqr-users@list.iex.net Tue Apr 3 09:18:43 2001 Date: Tue, 3 Apr 2001 08:15:22 -0600 From: Jon Alsager Subject: Re: Printing to HP - Trouble changing point-size in courier font Try specifiying pitch instead of point-size for Courier. HTH Jon -----Original Message----- From: Yuri Hunter [mailto:lakef250@HOTMAIL.COM] Sent: Monday, April 02, 2001 1:48 PM To: SQR-USERS@list.iex.net Subject: Printing to HP - Trouble changing point-size in courier font Greetings to the group - I've written an SQR report that uses Times-Roman font (different sizes with some bold and limited use of boxes). There are some header and footer fields (e.g., Contact Person) that I pass as parameters to the program that I want to print in Courier to make it plain what fields have been entered by appearing they were "typed in." The problem I'm having is that when I issue the alter-printer command to change the font to Courier 10-pt, the font changes from Times-Roman to Courier, but the size is super small (like 5-pt or less!). I can't make the Courier point-size increase in size on the report output no matter what value I specify in the alter-printer point-size parameter. A sample of my code follows: #include 'setenv.sqc' begin-setup #include 'setup02b.sqc' !Printer specifications for HPLASERJET end-setup begin-footing alter-printer font=5 point-size=6 print 'Contact Person:' (,90) bold alter-printer font=3 point-size=10 print $name (,107) underline end-footing Platform information: $sqr-platform : WINDOWS-NT $sqr-ver : SQR/4.3.4/PC/Windows NT 4.0/Oracle 7.3.4/Jun 03 1999 Thanks in advance for any assistance! _____ Get your FREE download of MSN Explorer at http://explorer.msn.com From owner-sqr-users@list.iex.net Tue Apr 3 14:50:00 2001 Date: Tue, 3 Apr 2001 14:44:22 -0500 From: Yuri Hunter Subject: Re: Printing to HP - Trouble changing point-size in courier font

Thanks, Jon.  That did the trick.

However, instead of replacing point-size, I added pitch as follows:                          

    alter-printer font=3 point-size=8 pitch=15      

I found a calculation for pitch on the archive as follows:      120/pitch=point-size

Does this seem appropriate? 

FINAL QUESTION:  Adding the pitch to just the one alter-printer stmt above affected all other 26 alter-printer stmts that changed font to courier.  The pitch was not impacted for other alter-printer stmts where font was Times-Roman but the alter-printer stmts that changed font to Courier were changed as if the pitch parm were used.  Why would only adding pitch parm to the one alter-printer stmt affect all the other courier stmts?  Is this expected?

>From: Jon Alsager

>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: Re: Printing to HP - Trouble changing point-size in courier font
>Date: Tue, 3 Apr 2001 08:15:22 -0600
>
>Try specifiying pitch instead of point-size for Courier.
>
>HTH
>
>Jon
>-----Original Message-----
>From: Yuri Hunter [mailto:lakef250@HOTMAIL.COM]
>Sent: Monday, April 02, 2001 1:48 PM
>To: SQR-USERS@list.iex.net
>Subject: Printing to HP - Trouble changing point-size in courier font
>
>
>Greetings to the group -
>
>I've written an SQR report that uses Times-Roman font (different sizes with
>some bold and limited use of boxes). There are some header and footer
>fields (e.g., Contact Person) that I pass as parameters to the program that
>I want to print in Courier to make it plain what fields have been entered by
>appearing they were "typed in."
>
>The problem I'm having is that when I issue the alter-printer command to
>change the font to Courier 10-pt, the font changes from Times-Roman to
>Courier, but the size is super small (like 5-pt or less!).
>
>I can't make the Courier point-size increase in size on the report output no
>matter what value I specify in the alter-printer point-size parameter. A
>sample of my code follows:
>
>#include 'setenv.sqc'
>
>begin-setup
> #include 'setup02b.sqc' !Printer specifications for HPLASERJET
>end-setup
>
>begin-footing
> alter-printer font=5 point-size=6
> print 'Contact Person:' (,90) bold
> alter-printer font=3 point-size=10
> print $name (,107) underline
>end-footing
>
>
>Platform information:
>
> $sqr-platform : WINDOWS-NT
> $sqr-ver : SQR/4.3.4/PC/Windows NT 4.0/Oracle 7.3.4/Jun 03 1999
>
>
>Thanks in advance for any assistance!
>
> _____
>
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>

Get your FREE download of MSN Explorer at http://explorer.msn.com

From owner-sqr-users@list.iex.net Tue Apr 3 15:12:27 2001 Date: Tue, 3 Apr 2001 14:09:27 -0600 From: Jon Alsager Subject: Re: Printing to HP - Trouble changing point-size in courier font Yuri -- Yes, the formula does seem appropriate While I'm still fairly new at SQR, my suspicion is that when pitch is defined, it holds that value until its changed. In nearly all of the programs that I have worked on where the alter-printer command is used, both the font and pitch/point-size are stated each time. So I have not necessarily seen what you are experiencing. But it does not suprise me. Jon -----Original Message----- From: Yuri Hunter [mailto:lakef250@HOTMAIL.COM] Sent: Tuesday, April 03, 2001 1:44 PM To: SQR-USERS@list.iex.net Subject: Re: Printing to HP - Trouble changing point-size in courier font Thanks, Jon. That did the trick. However, instead of replacing point-size, I added pitch as follows: alter-printer font=3 point-size=8 pitch=15 I found a calculation for pitch on the archive as follows: 120/pitch=point-size Does this seem appropriate? FINAL QUESTION: Adding the pitch to just the one alter-printer stmt above affected all other 26 alter-printer stmts that changed font to courier. The pitch was not impacted for other alter-printer stmts where font was Times-Roman but the alter-printer stmts that changed font to Courier were changed as if the pitch parm were used. Why would only adding pitch parm to the one alter-printer stmt affect all the other courier stmts? Is this expected? >From: Jon Alsager >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: Re: Printing to HP - Trouble changing point-size in courier font >Date: Tue, 3 Apr 2001 08:15:22 -0600 > >Try specifiying pitch instead of point-size for Courier. > >HTH > >Jon >-----Original Message----- >From: Yuri Hunter [mailto:lakef250@HOTMAIL.COM] >Sent: Monday, April 02, 2001 1:48 PM >To: SQR-USERS@list.iex.net >Subject: Printing to HP - Trouble changing point-size in courier font > > >Greetings to the group - > >I've written an SQR report that uses Times-Roman font (different sizes with >some bold and limited use of boxes). There are some header and footer >fields (e.g., Contact Person) that I pass as parameters to the program that >I want to print in Courier to make it plain what fields have been entered by >appearing they were "typed in." > >The problem I'm having is that when I issue the alter-printer command to >change the font to Courier 10-pt, the font changes from Times-Roman to >Courier, but the size is super small (like 5-pt or less!). > >I can't make the Courier point-size increase in size on the report output no >matter what value I specify in the alter-printer point-size parameter. A >sample of my code follows: > >#include 'setenv.sqc' > >begin-setup > #include 'setup02b.sqc' !Printer specifications for HPLASERJET >end-setup > >begin-footing > alter-printer font=5 point-size=6 > print 'Contact Person:' (,90) bold > alter-printer font=3 point-size=10 > print $name (,107) underline >end-footing > > >Platform information: > > $sqr-platform : WINDOWS-NT > $sqr-ver : SQR/4.3.4/PC/Windows NT 4.0/Oracle 7.3.4/Jun 03 1999 > > >Thanks in advance for any assistance! > > _____ > >Get your FREE download of MSN Explorer at http://explorer.msn.com > _____ Get your FREE download of MSN Explorer at http://explorer.msn.com From owner-sqr-users@list.iex.net Mon Apr 2 17:06:59 2001 Date: Mon, 2 Apr 2001 14:58:28 -0700 From: Chris Campbell Subject: SQR - Source Control - Endevor ? Hello everyone, Just wondering what everyone was using for source control / change management for their SQR programs. I'm particularly interested in the MVS environment. We currently have Endevor on our mainframe, and I was wondering if anyone else was using Endevor for their PeopleSoft SQR's (or COBOLs for that matter). Thanks, Chris _______________________________________________________ Send a cool gift with your E-Card http://www.bluemountain.com/giftcenter/ From owner-sqr-users@list.iex.net Tue Apr 3 08:56:59 2001 Date: Tue, 3 Apr 2001 09:52:50 -0400 From: "Schelske, Steve K." Subject: Re: SQR - Source Control - Endevor ? Yes, we use Endevor for version management and change control on the mainframe platform. We have not experienced any significant *new* problems using Endevor for PeopleSoft elements. The biggest issue we face currently with Endevor is that it just takes a long time to migrate elements through for a large implementation. I just put through a new release of PeopleTools and it was taking between 10 and 12 hours to move 600 elements from one environment to another. Let me know if you have any specific things you'd like to discuss. -----Original Message----- From: Discussion of SQR, Brio Technology's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Chris Campbell Sent: Monday, April 02, 2001 5:58 PM To: SQR-USERS@list.iex.net Subject: SQR - Source Control - Endevor ? Hello everyone, Just wondering what everyone was using for source control / change management for their SQR programs. I'm particularly interested in the MVS environment. We currently have Endevor on our mainframe, and I was wondering if anyone else was using Endevor for their PeopleSoft SQR's (or COBOLs for that matter). Thanks, Chris _______________________________________________________ Send a cool gift with your E-Card http://www.bluemountain.com/giftcenter/ From owner-sqr-users@list.iex.net Mon Apr 2 22:56:50 2001 Date: Mon, 2 Apr 2001 21:45:56 -0600 From: Ed Kelly Subject: image in report Don, and others: I have found a great utility call ImageConverter Plus from FCoderSoft. If converts 20 different formats including GIF to JPEG. http://www.fcodersoft.com/products/imgconv.htm Supported formats: • reads 20 graphic formats (BMP, DIB, RLE, TIFF, GIF, JPEG, PNG, PCX, DCX, TGA, DXF, EPSF, WMF, WPG, IMG, PCD, ICO, CUR, ANI and FMF); • converts into 12 formats (TIFF, GIF, BMP, PCX, DCX, EPS, TGA, JPEG, PNG, WMF, EMF, FMF). Hope this helps. Ed Kelly _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com From owner-sqr-users@list.iex.net Tue Apr 3 08:49:32 2001 Date: Tue, 3 Apr 2001 09:33:44 -0400 From: "Nemes, Deanna" Subject: Job Announcement Company: Idea Integration (www.idea.com) Location: Philadelphia Status: Fulltime/Hourly/Contract (any will do) Timeframe: ASAP thru July 24, 2001 Title: SQR Reporting Architect Respond to deanna.nemes@idea.com SQR Reporting architect that can analyze Business requirements, create report specifications and required templates, understand relational databases, and data warehousing, and can code, test, and publish reports in SQR. ********For more information please respond DIRECTLY to deanna.nemes@idea.com********** Deanna M. Nemes Idea Integration E-mail: deanna.nemes@idea.com From owner-sqr-users@list.iex.net Tue Apr 3 09:34:21 2001 Date: Tue, 3 Apr 2001 10:31:23 -0400 From: "Nemes, Deanna" Subject: Re: Job Announcement Hi Nicholas, Thanks for the response - but this position is pretty visible and work needs to be done on site! Deanna M. Nemes Idea Integration E-mail: deanna.nemes@idea.com -----Original Message----- From: Nicolas Moscaritolo [mailto:Nicolas.Moscaritolo@brio.com] Sent: Tuesday, April 03, 2001 10:09 AM To: 'Nemes, Deanna ' Subject: RE: Job Announcement Deanna, If they are interested in part time off-site programming, I am available. I have been programming in SQR for 12 years. -----Original Message----- From: Nemes, Deanna To: SQR-USERS@list.iex.net Sent: 4/3/01 6:33 AM Subject: Job Announcement Company: Idea Integration (www.idea.com) Location: Philadelphia Status: Fulltime/Hourly/Contract (any will do) Timeframe: ASAP thru July 24, 2001 Title: SQR Reporting Architect Respond to deanna.nemes@idea.com SQR Reporting architect that can analyze Business requirements, create report specifications and required templates, understand relational databases, and data warehousing, and can code, test, and publish reports in SQR. ********For more information please respond DIRECTLY to deanna.nemes@idea.com********** Deanna M. Nemes Idea Integration E-mail: deanna.nemes@idea.com From owner-sqr-users@list.iex.net Tue Apr 3 10:03:33 2001 Date: Tue, 3 Apr 2001 10:51:18 -0400 From: "Hood Louise (app1lxh)" Subject: Re: Job Announcement Now EVERYBODY IN THIS LISTING KNOWS that Deanna is a headhunter AND DOES NOT EXERCISE DISCRETION in dealing with individuals. Better find a new line of work. . . . -----Original Message----- From: Nemes, Deanna [mailto:Deanna.Nemes@IDEA.COM] Sent: Tuesday, April 03, 2001 10:31 AM To: SQR-USERS@list.iex.net Subject: Re: Job Announcement Hi Nicholas, Thanks for the response - but this position is pretty visible and work needs to be done on site! Deanna M. Nemes Idea Integration E-mail: deanna.nemes@idea.com -----Original Message----- From: Nicolas Moscaritolo [mailto:Nicolas.Moscaritolo@brio.com] Sent: Tuesday, April 03, 2001 10:09 AM To: 'Nemes, Deanna ' Subject: RE: Job Announcement Deanna, If they are interested in part time off-site programming, I am available. I have been programming in SQR for 12 years. -----Original Message----- From: Nemes, Deanna To: SQR-USERS@list.iex.net Sent: 4/3/01 6:33 AM Subject: Job Announcement Company: Idea Integration (www.idea.com) Location: Philadelphia Status: Fulltime/Hourly/Contract (any will do) Timeframe: ASAP thru July 24, 2001 Title: SQR Reporting Architect Respond to deanna.nemes@idea.com SQR Reporting architect that can analyze Business requirements, create report specifications and required templates, understand relational databases, and data warehousing, and can code, test, and publish reports in SQR. ********For more information please respond DIRECTLY to deanna.nemes@idea.com********** Deanna M. Nemes Idea Integration E-mail: deanna.nemes@idea.com From owner-sqr-users@list.iex.net Fri Apr 13 16:26:38 2001 Date: Fri, 13 Apr 2001 17:22:22 -0400 From: Kenneth Lawrence Gartman Subject: Re: Job Announcement Hi, Deanna! Is this opening still active? Ken Gartman "Nemes, Deanna" wrote: > Company: Idea Integration (www.idea.com) > Location: Philadelphia > Status: Fulltime/Hourly/Contract (any will do) > Timeframe: ASAP thru July 24, 2001 > Title: SQR Reporting Architect > Respond to deanna.nemes@idea.com > > SQR Reporting architect that can analyze Business requirements, create > report specifications and required templates, understand relational > databases, and data warehousing, and can code, test, and publish reports in > SQR. > > ********For more information please respond DIRECTLY to > deanna.nemes@idea.com********** > > Deanna M. Nemes > Idea Integration > > E-mail: deanna.nemes@idea.com From owner-sqr-users@list.iex.net Tue Apr 3 11:11:29 2001 Date: Tue, 3 Apr 2001 15:57:40 -0000 From: Tejus Shah Subject: Multi server architecture in Brio Hi, I am trying to configure mulit server architecture for load balancing in Brio. I have a manager server and a node server. I am not able to syncronize both the servers. Also I am not too sure of the configuration paramateres which needs to be set up in both the servers. When ever I register a new document or a OCE file on the manager node it is not getting replicated on the node server. Can anyone tell me what configuration parameters needs to be set up . Also if there is any documentation available please send me across. Any help is highly appreciated Thanks and Regards Tejus Shah _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. From owner-sqr-users@list.iex.net Tue Apr 3 16:02:31 2001 Date: Tue, 3 Apr 2001 16:44:52 -0400 From: Mike Wheeler Subject: SQR for PowerBuilder and iPlanet Hi, I am researching what it will take to use SQR in a PowerBuilder 5.04 application. The application will be running on a windows NT machine. Is it possible to trigger the SQR from the PowerBuilder app, and if so, how would I do this. I also am investigating how to use SQR with an iPlanet web-server. I am developing using Java 1.3. Does anyone know how I can incorporate SQR in my java code? Or at least point me in a direction where I can read how to do this. Thanks, Mike From owner-sqr-users@list.iex.net Wed Apr 4 08:26:41 2001 Date: Wed, 4 Apr 2001 09:25:44 -0400 From: Scott Eubank Subject: Re: SQR for PowerBuilder and iPlanet Mike , We successfully called an SQR from VB in the client server mode. You will have to have SQR availiable to the Client machine, you cant bundle it with VB or PB , I think. But we simply used the command line statements , putting each part into a variable then kicking of the API to run a shell commmand. I dont know how to do this in PB but I bet you can find out. TRY www.planetsourcecode.com for code on how to execute shell commands from PB. GOOD Luck .. Let us know your results $A = "P:\FDM753\sqrbinw\SQRW.EXE" $B = "C:\TEMP\USER\SQR\gls9002a.sqr" $C = "FSRPT/fsrpt/fsrpt" $D = "-ip:\FDM753\sqr\;" $E = "C:\SCOTTs_DOCs\SQR's\GL_SQRs\" $F = "-mp:\FDM753\sqr\allmaxes.max" $G = "-fC:\Temp\" $H = "-ZIFp:\FDM753\sqr\pssqr.ini" runsqr = $A + $B + $C + $D + $E + $F + $G + $H EXECUTE_SHELL_COMMAND (runsqr & sqrparameter) -----Original Message----- From: Mike Wheeler [mailto:Michael_Wheeler@PUTNAMINV.COM] Sent: Tuesday, April 03, 2001 4:45 PM To: SQR-USERS@list.iex.net Subject: SQR for PowerBuilder and iPlanet Hi, I am researching what it will take to use SQR in a PowerBuilder 5.04 application. The application will be running on a windows NT machine. Is it possible to trigger the SQR from the PowerBuilder app, and if so, how would I do this. I also am investigating how to use SQR with an iPlanet web-server. I am developing using Java 1.3. Does anyone know how I can incorporate SQR in my java code? Or at least point me in a direction where I can read how to do this. Thanks, Mike From owner-sqr-users@list.iex.net Wed Apr 4 08:24:42 2001 Date: Wed, 4 Apr 2001 09:20:33 -0400 From: "Schelske, Steve K." Subject: SQRW not a valid Windows NT application I'm trying to run SQRW from Windows Explorer and I get the following message in an error dialog: q:\fsdev\ifs\sqrbinw\sqrw.exe is not a valid Windows NT application. I can copy sqrw.exe to a different directory and it works fine. I can copy a working sqrw.exe into q:\fsdev\ifs\sqrbinw and it fails with the same error. I tried reinstalling SQR into the "bad" directory and I get the same error. I have full permissions on all of the directories on this box. Any ideas as to what might be the problem? tia From owner-sqr-users@list.iex.net Wed Apr 4 09:16:02 2001 Date: Wed, 4 Apr 2001 10:08:55 -0400 From: Joan Keith Subject: Can SQR be invoked from Powerbuilder? from IPlanet I have a powerbuilder application (version 5.04) that needs to create some reports. I was hoping to use SQR, but I'm not sure if I can. Do you know of anyone who I can talk to about this? If it can be done, I'm not sure how it can be triggered from within the application. I also have the same questions for an iPlanet application using Java 1.3. From owner-sqr-users@list.iex.net Wed Apr 4 09:42:25 2001 Date: Wed, 4 Apr 2001 10:38:47 -0400 From: Mario Mendoza Subject: Re: Can SQR be invoked from Powerbuilder? from IPlanet The (very) short answer is that yes, you can generate SQR reports from PB. Set up a table with Report_id, sqr_path, output_path, user_lookup, args .... The front end application should connect PB to the location of the SQR (in our case a Unix box) and the SQR will take in the args passed in from PB. > -----Original Message----- > From: Joan Keith [SMTP:Joan_Keith@PUTNAMINV.COM] > Sent: April 04, 2001 10:09 AM > To: SQR-USERS@list.iex.net > Subject: Can SQR be invoked from Powerbuilder? from IPlanet > > I have a powerbuilder application (version 5.04) that needs to create some > reports. I was hoping to use SQR, but I'm not sure if I can. Do you know > of anyone who I can talk to about this? If it can be done, I'm not sure > how it can be triggered from within the application. I also have the same > questions for an iPlanet application using Java 1.3. From owner-sqr-users@list.iex.net Wed Apr 4 18:12:38 2001 Date: Thu, 5 Apr 2001 01:07:45 +0200 From: Franck Masson Subject: Re: Can SQR be invoked from Powerbuilder? from IPlanet This is a multi-part message in MIME format. --------------B76B1500C7AD01F1135158B0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Joan, 1) Java >From java you can either call the executable sqr or you can call the C code of SQR Look to the documentation of SQR there is a chapter that explain this not for java but for a C code or a Perl code 2) Powerbuilder with SQR/Brio.report we provide an activex call Brio.Report Activator Brio.Report Activator is a set of ActiveX controls that allow you to run SQR programs launched from within your application, and to view and print the output within the same application. These ActiveX Controls are: SQR ActiveX Control For running SQR programs on the local PC or remote servers. Brio.Report Viewer ActiveX Control For viewing the report output. The report can also be printed, or sent to other people via e-mail. SQR Print ActiveX Control For printing the report output. Other software components include: · A Visual Basic Sample Application · Online help Look to your CD or call your BRIO sales REP Franck, Joan Keith wrote: > > I have a powerbuilder application (version 5.04) that needs to create some > reports. I was hoping to use SQR, but I'm not sure if I can. Do you know > of anyone who I can talk to about this? If it can be done, I'm not sure > how it can be triggered from within the application. I also have the same > questions for an iPlanet application using Java 1.3. --------------B76B1500C7AD01F1135158B0 Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Franck Masson Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Franck Masson n: ;Franck Masson org: Brio Technology EMEA adr;dom: Le capitol;;55 av. des champs Pierreux;Nanterre;92000;; email;internet: franck.masson@brio.com title: Sales Manager Northern Europe tel;work: 33 1 55 69 36 00 tel;fax: 33 1 47 25 02 59 tel;home: Mobile : 33 6 84 80 17 05 x-mozilla-cpt: ;0 x-mozilla-html: FALSE version: 2.1 end: vcard --------------B76B1500C7AD01F1135158B0-- From owner-sqr-users@list.iex.net Wed Apr 4 09:24:02 2001 Date: Wed, 4 Apr 2001 10:20:06 -0400 From: "Weinstein, Bruce" Subject: SQL statement issue Can anyone tell me if it is OK to end a SQL statement with a ;(semi-colon). We have following code... BEGIN-SQL COMMIT; END-SQL Is this OK to do in SQR? Thanks.. .Bruce Bruce Weinstein E-Mail: bruceweinstein@canada.com From owner-sqr-users@list.iex.net Wed Apr 4 09:31:28 2001 Date: Wed, 4 Apr 2001 10:28:01 -0400 From: Paul Hoyte Subject: Re: SQL statement issue Yes that will work just fine. It is used to actually trigger the execution of the sql statement but is only needed if you have more that one sql statement in a sql paragraph..... Regards, Paul Hoyte Sharidionne, Inc. (248) 559-6868 www.sharidionne.com phoyte@sharidionne.com -----Original Message----- From: Discussion of SQR, Brio Technology's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Weinstein, Bruce Sent: Wednesday, April 04, 2001 10:20 AM To: SQR-USERS@list.iex.net Subject: SQL statement issue Can anyone tell me if it is OK to end a SQL statement with a ;(semi-colon). We have following code... BEGIN-SQL COMMIT; END-SQL Is this OK to do in SQR? Thanks.. .Bruce Bruce Weinstein E-Mail: bruceweinstein@canada.com From owner-sqr-users@list.iex.net Wed Apr 4 09:36:05 2001 Date: Wed, 4 Apr 2001 10:28:29 -0400 From: "Johnson, Dan" Subject: Re: SQL statement issue You may actually need to semi-colons (not sure). However, if all you are doing is a commit there is an SQR keyword that you can use anywhere outside of a SQL block. The keyword is commit. >>>>>>>>>Bruce sent Sent: Wednesday, April 04, 2001 10:20 AM To: SQR-USERS@list.iex.net Subject: SQL statement issue Can anyone tell me if it is OK to end a SQL statement with a ;(semi-colon). We have following code... BEGIN-SQL COMMIT; END-SQL Is this OK to do in SQR? Thanks.. .Bruce Bruce Weinstein E-Mail: bruceweinstein@canada.com From owner-sqr-users@list.iex.net Wed Apr 4 09:33:13 2001 Date: Wed, 4 Apr 2001 09:30:50 -0500 From: "Cook, Andy" Subject: Re: SQL statement issue I have used the semicolon without any error, but I took it out and it seemed to make no difference. I have only used it when inserting or selecting, not when doing a commit. I do not know if this makes a difference. Hope this helps. -----Original Message----- From: Weinstein, Bruce [mailto:bweinste@NRCAN.GC.CA] Sent: Wednesday, April 04, 2001 9:20 AM To: SQR-USERS@list.iex.net Subject: SQL statement issue Can anyone tell me if it is OK to end a SQL statement with a ;(semi-colon). We have following code... BEGIN-SQL COMMIT; END-SQL Is this OK to do in SQR? Thanks.. .Bruce Bruce Weinstein E-Mail: bruceweinstein@canada.com ************************************************************ Omaha World-Herald Company computer systems are for business use only. This e-mail was scanned by MailSweeper ************************************************************ From owner-sqr-users@list.iex.net Wed Apr 4 09:39:46 2001 Date: Wed, 4 Apr 2001 10:34:32 -0400 From: Mike Morgan Subject: Re: SQL statement issue You would use this if you are 'stacking' SQL statements, i.e.; putting 2 or more SQL statements in the same BEGIN-SQL procedure. -----Original Message----- From: Weinstein, Bruce [mailto:bweinste@NRCAN.GC.CA] Sent: Wednesday, April 04, 2001 10:20 AM To: SQR-USERS@list.iex.net Subject: SQL statement issue Can anyone tell me if it is OK to end a SQL statement with a ;(semi-colon). We have following code... BEGIN-SQL COMMIT; END-SQL Is this OK to do in SQR? Thanks.. .Bruce Bruce Weinstein E-Mail: bruceweinstein@canada.com ************************************************************** NOTICE: The information contained in this e-mail is confidential and may be privileged or otherwise protected from disclosure. This e-mail is intended solely for the use of the named addressee. Please be aware that any other use, printing, copying, disclosure or dissemination may be subject to legal restriction. If you are not the intended recipient, please notify us immediately by return e-mail to the sender. From owner-sqr-users@list.iex.net Wed Apr 4 09:45:22 2001 Date: Wed, 4 Apr 2001 11:39:27 -0300 From: Peter Clark Subject: Re: SQL statement issue Hi Bruce, >From the manual: "If a single paragraph contains more than one SQL statement, each statement *except the last* must be terminated by a semicolon." (emphasis mine) This would seem to imply that your single line paragraph does not need a semicolon. According the the last Cluster Departmental Technical Survey, you are an Oracle shop, so you could also get away with using a double semicolon ("For Oracle, PL/SQL is supported in a BEGIN-SQL paragraph. This requires an additional semicolon at the end of each PL/SQL statement.") e.g. BEGIN-SQL COMMIT; ; END-SQL HTH, Peter >>> "Weinstein, Bruce" 2001/04/04 11:20:06 am >>> Can anyone tell me if it is OK to end a SQL statement with a ;(semi-colon). We have following code... BEGIN-SQL COMMIT; END-SQL Is this OK to do in SQR? Thanks.. .Bruce Bruce Weinstein E-Mail: bruceweinstein@canada.com From owner-sqr-users@list.iex.net Wed Apr 4 10:16:19 2001 Date: Wed, 4 Apr 2001 11:12:58 -0400 From: "Jamadagni, Rajendra" Subject: Re: SQL statement issue Me thinks that (at-least for oracle) if you enclose something in begin-sql ... end-sql one has to use TWO semicolons. begin-sql commit;; end-sql HTH Raj ______________________________________________________ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! ********************************************************************* This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ********************************************************************* From owner-sqr-users@list.iex.net Wed Apr 4 12:39:39 2001 Date: Wed, 4 Apr 2001 10:33:10 -0700 From: David Donnelly Subject: Re: SQL statement issue In some earlier versions of SQR (I don't remember how early, maybe v3), under Oracle, using the COMMIT command within BEGIN-SQL would blow up. You had to use the separate SQR COMMIT command outside BEGIN-SQL. If you are having a problem with commit within begin-sql, try SQR command instead. At 10:20 AM 4/4/2001 -0400, you wrote: >Can anyone tell me if it is OK to end a SQL statement with a ;(semi-colon). > >We have following code... > >BEGIN-SQL > COMMIT; >END-SQL > >Is this OK to do in SQR? > >Thanks.. > > .Bruce > >Bruce Weinstein >E-Mail: bruceweinstein@canada.com Dave Donnelly ISIS BioComp phone (909) 677-2446 fax (781) 207-5533 From owner-sqr-users@list.iex.net Wed Apr 4 09:42:25 2001 Date: Wed, 4 Apr 2001 10:40:00 -0700 From: "Charles A. Harkness" Subject: Re: SQL statement issue Bruce, Yes, you should use the semicolon as you would normally do with sql. Chuck At 10:20 AM 4/4/01 -0400, you wrote: >Can anyone tell me if it is OK to end a SQL statement with a ;(semi-colon). > >We have following code... > >BEGIN-SQL > COMMIT; >END-SQL > >Is this OK to do in SQR? > >Thanks.. > > .Bruce > >Bruce Weinstein >E-Mail: bruceweinstein@canada.com > > From owner-sqr-users@list.iex.net Wed Apr 4 10:01:53 2001 Date: Wed, 4 Apr 2001 16:51:00 +0200 From: LEBLANC Philippe FTC Subject: =?ISO-8859-1?Q?R=E9p.=20:=20SQL=20statement=20issue?= yes, it is. But you have also a commit command under SQR ! Cordialement, Philippe. >>> "Weinstein, Bruce" 04/04/01 16h20 >>> Can anyone tell me if it is OK to end a SQL statement with a ;(semi-colon). We have following code... BEGIN-SQL COMMIT; END-SQL Is this OK to do in SQR? Thanks.. .Bruce Bruce Weinstein E-Mail: bruceweinstein@canada.com From owner-sqr-users@list.iex.net Wed Apr 4 22:26:45 2001 Date: Thu, 5 Apr 2001 13:22:32 +1000 From: Daniel Archibald Subject: Selecting EMPLOYEE_PHOTO column of type LONG RAW using SQR Hi, I was just wondering if anyone has ever tried selecting a LONG RAW column from an Oracle database using SQR. The field EMPLOYEE_PHOTO is storing a BMP-File image, the image is displayed on a PeopleSoft panel. When executing the SQL against the database to select this column the following error is displayed: ORA-00932: inconsistent datatypes What I am trying to do is select the image from the database in the SQR and then print it on a report. Any assistance on overcoming this problem would be greatly appreciated. Thanks in advance. Regards, Dan Archibald. Environment: Oracle 8.0.5.0.0 SQR V4.3.4 PeopleSoft 7.6 From owner-sqr-users@list.iex.net Thu Apr 5 06:05:08 2001 Date: Thu, 5 Apr 2001 12:56:52 +0200 From: Arnon Oppenheimer Subject: From OpenIngres to Oracle Hi, I need to make a list of issues for a site that plan to move from = CA-OpenIngres to Oracle. Do you have some tips for us ? (about SQR of course ;-) Thanks in advance. Regards, Arnon Oppenheimer ------------------------------------------------------------------- SEMECH SOFTWARE MARKETING LTD. TEL : (972) - 3 - 5333144 FAX : (972) - 3 - 5333132 Email: arnono@semech.co.il ------------------------------------------------------------------- From owner-sqr-users@list.iex.net Thu Apr 5 13:46:28 2001 Date: Thu, 5 Apr 2001 09:58:57 -0700 From: David Donnelly Subject: Re: From OpenIngres to Oracle Hi Aaron, First of all, be happy you don't have to go from Oracle to Ingres! I have an extensive application that had to run both in Oracle and Ingres, but it evolved in the early 1990s. I generally found Ingres (version 2.28f) more restrictive than Oracle, and of course there are the semantic differences to be addressed, but in general there weren't any SQR issues. There were some things that did not work correctly with Ingres, notably determining the correct type when functions were used in selects, but since you are going FROM Ingres these issues should have already been ironed out. Here are some of my notes: Since Oracle converts datatypes more automatically than Ingres, you may find many type conversions you no longer need, but they are fine to keep. The date processing in Ingres is much cleaner than Oracle; basically if it looks like a date, Ingres will convert it from char to date type. One odd thing: dates stored with times of midnight in Ingres are converted to character as if there were no time; Oracle will return a time of 00:00:00. In Ingres, "where not exists" performs very poorly, but this is not true in Oracle. In Ingres, there can be zero-length character strings. These are different from NULL. In Oracle, these would appear to be NULL. I'm not sure if this is true any more. In Ingres, there is a maximum length of a line in a begin-select; I think it was 255, and SQR used to blow up if you exceeded it. I don't think this happens in Oracle. Semantics: char vs to_char date vs to_date date('now') or date('today') vs sysdate lower vs lowercase pad vs rpad locate vs instr + vs || date_trunc vs date INT4 (etc) vs floor "as" in column aliasing vs none (doesn't affect SQR) COPY from/to table not in Oracle system catalog differences updates with coordinated subqueries have vastly different syntax Hardly anyone seems to use Ingres anymore; please feel free to email me if you have any questions. Dave At 12:56 PM 4/5/2001 +0200, you wrote: >Hi, > >I need to make a list of issues for a site that plan to move from CA-OpenIngres to Oracle. >Do you have some tips for us ? (about SQR of course ;-) > >Thanks in advance. > >Regards, >Arnon Oppenheimer > ------------------------------------------------------------------- >SEMECH SOFTWARE MARKETING LTD. >TEL : (972) - 3 - 5333144 >FAX : (972) - 3 - 5333132 >Email: arnono@semech.co.il >------------------------------------------------------------------- Dave Donnelly ISIS BioComp phone (909) 677-2446 fax (781) 207-5533 From owner-sqr-users@list.iex.net Thu Apr 5 08:58:12 2001 Date: Thu, 5 Apr 2001 09:55:41 -0400 From: "Wagner, Jennifer A" Subject: SQL in SQR I'm trying to create temp tables in my SQR program. It will allow me to create one, but I can't seem to get it to create more than one. My ultimate goal would be to have a a multi-module program where I select different things from different tables and then insert them into the various temp tables. Do you know if you can create more than one temp table in a SQL paragraph in SQR? My temp table create statement looks like this: begin-setup page-size 56 132 BEGIN-SQL ON-ERROR=SKIP CREATE TABLE PMCGEN_TEMP (GENERIC_NAME VARCHAR2(40)) TABLESPACE USER_ACCOUNTS STORAGE (INITIAL 5000K NEXT 500K); end-sql end-setup and the insert statement looks like this: begin-procedure INSERT_TEMP BEGIN-SQL INSERT INTO PMCGEN_TEMP (GENERIC_NAME) values (&GEN); END-SQL COMMIT end-procedure That works fine. But, I've tried to add another create table... and insert into... and I get the message: "table for view does not exist" for the second table. Thanks, Jenny From owner-sqr-users@list.iex.net Thu Apr 5 09:45:26 2001 Date: Thu, 5 Apr 2001 09:41:59 -0500 From: the dragon Subject: Re: SQL in SQR show us the code you're attempting to use to create multiple tables. clark 'the dragon' willis dragon enterprises, consulting services ----Original Message Follows---- I'm trying to create temp tables in my SQR program. It will allow me to create one, but I can't seem to get it to create more than one. My ultimate goal would be to have a a multi-module program where I select different things from different tables and then insert them into the various temp tables. Do you know if you can create more than one temp table in a SQL paragraph in SQR? My temp table create statement looks like this: begin-setup page-size 56 132 BEGIN-SQL ON-ERROR=SKIP CREATE TABLE PMCGEN_TEMP (GENERIC_NAME VARCHAR2(40)) TABLESPACE USER_ACCOUNTS STORAGE (INITIAL 5000K NEXT 500K); end-sql end-setup and the insert statement looks like this: begin-procedure INSERT_TEMP BEGIN-SQL INSERT INTO PMCGEN_TEMP (GENERIC_NAME) values (&GEN); END-SQL COMMIT end-procedure That works fine. But, I've tried to add another create table... and insert into... and I get the message: "table for view does not exist" for the second table. Thanks, Jenny _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com From owner-sqr-users@list.iex.net Thu Apr 5 09:47:47 2001 Date: Thu, 5 Apr 2001 10:47:34 -0400 From: "Wagner, Jennifer A" Subject: Re: SQL in SQR Well, I've tried various and assorted things... this is the most recent one I tried: BEGIN-SQL ON-ERROR=SKIP CREATE TABLE PMCGEN_TEMP (GENERIC_NAME VARCHAR2(40)), create table pmcapp_temp (appl_type varchar2(1), appl_no varchar2(6)) TABLESPACE USER_ACCOUNTS STORAGE (INITIAL 5000K NEXT 500K); end-sql end-setup I also tried it without the comma separating the two create tables and I tried it with the semi-colon after the first table. Also I tried this: BEGIN-SQL ON-ERROR=SKIP CREATE TABLE PMCGEN_TEMP (GENERIC_NAME VARCHAR2(40)) TABLESPACE USER_ACCOUNTS STORAGE (INITIAL 5000K NEXT 500K); create table pmcapp_temp (appl_type varchar2(1), appl_no varchar2(6)) TABLESPACE USER_ACCOUNTS STORAGE (INITIAL 5000K NEXT 500K); end-sql Each time it seems to create the first but the second comes up with the error: table or view does not exist when it goes to do the insert. Thanks, Jenny > -----Original Message----- > From: the dragon [mailto:ceprn@hotmail.com] > Sent: Thursday, April 05, 2001 10:42 AM > To: sqr-users@list.iex.net > Cc: WAGNERJ@CDER.FDA.GOV > Subject: Re: SQL in SQR > > > show us the code you're attempting to use to create multiple tables. > > clark 'the dragon' willis > dragon enterprises, consulting services > > > ----Original Message Follows---- > > I'm trying to create temp tables in my SQR program. It will > allow me to > create one, but I can't seem to get it to create more than > one. My ultimate > goal would be to have a a multi-module program where I select > different > things from different tables and then insert them into the > various temp > tables. > > Do you know if you can create more than one temp table in a > SQL paragraph in > SQR? > > My temp table create statement looks like this: > > begin-setup > page-size 56 132 > > BEGIN-SQL ON-ERROR=SKIP > > CREATE TABLE PMCGEN_TEMP (GENERIC_NAME VARCHAR2(40)) > TABLESPACE USER_ACCOUNTS > STORAGE > (INITIAL 5000K > NEXT 500K); > end-sql > end-setup > > and the insert statement looks like this: > > begin-procedure INSERT_TEMP > BEGIN-SQL > INSERT INTO PMCGEN_TEMP (GENERIC_NAME) > values (&GEN); > END-SQL > COMMIT > end-procedure > > > That works fine. But, I've tried to add another create > table... and insert > into... and I get the message: "table for view does not > exist" for the > second table. > > > Thanks, > > > Jenny > > _________________________________________________________________ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > From owner-sqr-users@list.iex.net Thu Apr 5 09:54:10 2001 Date: Thu, 5 Apr 2001 10:50:34 -0400 From: "Jamadagni, Rajendra" Subject: Re: SQL in SQR Jennifer, remove on-error=skip and see if second (and next one) create table throws any error. I assume that you have sufficient space in the specified tablespace. HTH Raj ______________________________________________________ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! ********************************************************************* This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ********************************************************************* From owner-sqr-users@list.iex.net Thu Apr 5 09:56:38 2001 Date: Thu, 5 Apr 2001 10:56:17 -0400 From: "Wagner, Jennifer A" Subject: Re: SQL in SQR Thanks, Raj... No, I don't have sufficient space in the tablespace, as that is the error I get! Hmmm... not sure how to do that. Thing is, I don't even have those create writes...I'm using someone else's account to run the program and was using her initial program (just tweaking it). I'll have to see about that. Thanks again Jenny > -----Original Message----- > From: Jamadagni, Rajendra [mailto:rajendra.jamadagni@espn.com] > Sent: Thursday, April 05, 2001 10:51 AM > To: 'sqr-users@list.iex.net'; 'WAGNERJ@CDER.FDA.GOV' > Subject: RE: SQL in SQR > > > Jennifer, > > remove on-error=skip and see if second (and next one) create > table throws > any error. I assume that you have sufficient space in the specified > tablespace. > > HTH > Raj > ______________________________________________________ > Rajendra Jamadagni MIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't reflect > that of ESPN Inc. > > QOTD: Any clod can have facts, but having an opinion is an art ! > > ********************************************************************* > > This e-mail message is confidential, intended only for the > named recipient(s) above and may contain information that is > privileged, attorney work product or exempt from disclosure > under applicable law. If you have received this message in > error, or are not the named recipient(s), please immediately > notify ESPN at (860) 766-2000 and delete this e-mail message > from your computer, Thank you. > > ********************************************************************* > > From owner-sqr-users@list.iex.net Thu Apr 5 10:02:35 2001 Date: Thu, 5 Apr 2001 11:01:19 -0400 From: "Wagner, Jennifer A" Subject: Re: SQL in SQR It's working now... I cut the space requirements in half... I just don't know if it will be enough space for all the temp tables I need to create... so I may have to ask for more space or something. Thanks!!! > -----Original Message----- > From: Jamadagni, Rajendra [mailto:rajendra.jamadagni@espn.com] > Sent: Thursday, April 05, 2001 10:51 AM > To: 'sqr-users@list.iex.net'; 'WAGNERJ@CDER.FDA.GOV' > Subject: RE: SQL in SQR > > > Jennifer, > > remove on-error=skip and see if second (and next one) create > table throws > any error. I assume that you have sufficient space in the specified > tablespace. > > HTH > Raj > ______________________________________________________ > Rajendra Jamadagni MIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't reflect > that of ESPN Inc. > > QOTD: Any clod can have facts, but having an opinion is an art ! > > ********************************************************************* > > This e-mail message is confidential, intended only for the > named recipient(s) above and may contain information that is > privileged, attorney work product or exempt from disclosure > under applicable law. If you have received this message in > error, or are not the named recipient(s), please immediately > notify ESPN at (860) 766-2000 and delete this e-mail message > from your computer, Thank you. > > ********************************************************************* > > From owner-sqr-users@list.iex.net Thu Apr 5 10:40:31 2001 Date: Thu, 5 Apr 2001 11:35:49 -0400 From: ANDERSD2 Subject: Re: SQL in SQR Are you sure you need to create TEMP tables? Would ARRAYS work with your scenario?? ARRAYS are generally quicker than tables, require no DBA/security clearance, and are temporary by nature. -----Original Message----- From: Wagner, Jennifer A [mailto:WAGNERJ@CDER.FDA.GOV] Sent: Thursday, April 05, 2001 11:01 AM To: SQR-USERS@list.iex.net Subject: Re: SQL in SQR It's working now... I cut the space requirements in half... I just don't know if it will be enough space for all the temp tables I need to create... so I may have to ask for more space or something. Thanks!!! > -----Original Message----- > From: Jamadagni, Rajendra [mailto:rajendra.jamadagni@espn.com] > Sent: Thursday, April 05, 2001 10:51 AM > To: 'sqr-users@list.iex.net'; 'WAGNERJ@CDER.FDA.GOV' > Subject: RE: SQL in SQR > > > Jennifer, > > remove on-error=skip and see if second (and next one) create > table throws > any error. I assume that you have sufficient space in the specified > tablespace. > > HTH > Raj > ______________________________________________________ > Rajendra Jamadagni MIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't reflect > that of ESPN Inc. > > QOTD: Any clod can have facts, but having an opinion is an art ! > > ********************************************************************* > > This e-mail message is confidential, intended only for the > named recipient(s) above and may contain information that is > privileged, attorney work product or exempt from disclosure > under applicable law. If you have received this message in > error, or are not the named recipient(s), please immediately > notify ESPN at (860) 766-2000 and delete this e-mail message > from your computer, Thank you. > > ********************************************************************* > > From owner-sqr-users@list.iex.net Thu Apr 5 10:49:30 2001 Date: Thu, 5 Apr 2001 11:42:01 -0400 From: "Jamadagni, Rajendra" Subject: Re: SQL in SQR IMHO The drawback of arrays is also that you hace to specify an upper bound limit and SQR will allocate that much of memory. So, arrays don't turn out to be dynamically extendable and also I loose the wonderful DMLs facility on arrays. I do believe arrays have their own place, but the flexibility offered by TEMP tables is much much more to overlook the required maintenance. Another drawback, arrays are linear ... Cheers Raj ______________________________________________________ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! -----Original Message----- From: ANDERSD2 [mailto:ANDERSD2@OAKWOOD.ORG] Sent: Thursday, April 05, 2001 11:36 AM To: SQR-USERS@list.iex.net Subject: Re: SQL in SQR Are you sure you need to create TEMP tables? Would ARRAYS work with your scenario?? ARRAYS are generally quicker than tables, require no DBA/security clearance, and are temporary by nature. ********************************************************************* This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ********************************************************************* From owner-sqr-users@list.iex.net Thu Apr 5 09:14:24 2001 Date: Thu, 5 Apr 2001 16:08:48 +0200 From: LEBLANC Philippe FTC Subject: =?ISO-8859-1?Q?R=E9p.=20:=20SQL=20in=20SQR?= You can create several temp table by using several 'create table' orders in a paragraph begin-select with ;; order separator like 'commit;;'. Cordialement, Philippe. >>> "Wagner, Jennifer A" 05/04/01 15h55 >>> I'm trying to create temp tables in my SQR program. It will allow me to create one, but I can't seem to get it to create more than one. My ultimate goal would be to have a a multi-module program where I select different things from different tables and then insert them into the various temp tables. Do you know if you can create more than one temp table in a SQL paragraph in SQR? My temp table create statement looks like this: begin-setup page-size 56 132 BEGIN-SQL ON-ERROR=SKIP CREATE TABLE PMCGEN_TEMP (GENERIC_NAME VARCHAR2(40)) TABLESPACE USER_ACCOUNTS STORAGE (INITIAL 5000K NEXT 500K); end-sql end-setup and the insert statement looks like this: begin-procedure INSERT_TEMP BEGIN-SQL INSERT INTO PMCGEN_TEMP (GENERIC_NAME) values (&GEN); END-SQL COMMIT end-procedure That works fine. But, I've tried to add another create table... and insert into... and I get the message: "table for view does not exist" for the second table. Thanks, Jenny From owner-sqr-users@list.iex.net Thu Apr 5 10:41:57 2001 Date: Thu, 5 Apr 2001 17:06:35 +0200 From: LEBLANC Philippe FTC Subject: =?ISO-8859-1?Q?R=E9p.=20:=20Re:=20SQL=20in=20SQR?= try using this; BEGIN-SQL ON-ERROR=SKIP CREATE TABLE PMCGEN_TEMP (GENERIC_NAME VARCHAR2(40)) TABLESPACE USER_ACCOUNTS STORAGE (INITIAL 5000K NEXT 500K);; create table pmcapp_temp (appl_type varchar2(1), appl_no varchar2(6)) TABLESPACE USER_ACCOUNTS STORAGE (INITIAL 5000K NEXT 500K);; commit;; end-sql Cordialement, Philippe. >>> "Wagner, Jennifer A" 05/04/01 16h47 >>> Well, I've tried various and assorted things... this is the most recent one I tried: BEGIN-SQL ON-ERROR=SKIP CREATE TABLE PMCGEN_TEMP (GENERIC_NAME VARCHAR2(40)), create table pmcapp_temp (appl_type varchar2(1), appl_no varchar2(6)) TABLESPACE USER_ACCOUNTS STORAGE (INITIAL 5000K NEXT 500K); end-sql end-setup I also tried it without the comma separating the two create tables and I tried it with the semi-colon after the first table. Also I tried this: BEGIN-SQL ON-ERROR=SKIP CREATE TABLE PMCGEN_TEMP (GENERIC_NAME VARCHAR2(40)) TABLESPACE USER_ACCOUNTS STORAGE (INITIAL 5000K NEXT 500K); create table pmcapp_temp (appl_type varchar2(1), appl_no varchar2(6)) TABLESPACE USER_ACCOUNTS STORAGE (INITIAL 5000K NEXT 500K); end-sql Each time it seems to create the first but the second comes up with the error: table or view does not exist when it goes to do the insert. Thanks, Jenny > -----Original Message----- > From: the dragon [mailto:ceprn@hotmail.com] > Sent: Thursday, April 05, 2001 10:42 AM > To: sqr-users@list.iex.net > Cc: WAGNERJ@CDER.FDA.GOV > Subject: Re: SQL in SQR > > > show us the code you're attempting to use to create multiple tables. > > clark 'the dragon' willis > dragon enterprises, consulting services > > > ----Original Message Follows---- > > I'm trying to create temp tables in my SQR program. It will > allow me to > create one, but I can't seem to get it to create more than > one. My ultimate > goal would be to have a a multi-module program where I select > different > things from different tables and then insert them into the > various temp > tables. > > Do you know if you can create more than one temp table in a > SQL paragraph in > SQR? > > My temp table create statement looks like this: > > begin-setup > page-size 56 132 > > BEGIN-SQL ON-ERROR=SKIP > > CREATE TABLE PMCGEN_TEMP (GENERIC_NAME VARCHAR2(40)) > TABLESPACE USER_ACCOUNTS > STORAGE > (INITIAL 5000K > NEXT 500K); > end-sql > end-setup > > and the insert statement looks like this: > > begin-procedure INSERT_TEMP > BEGIN-SQL > INSERT INTO PMCGEN_TEMP (GENERIC_NAME) > values (&GEN); > END-SQL > COMMIT > end-procedure > > > That works fine. But, I've tried to add another create > table... and insert > into... and I get the message: "table for view does not > exist" for the > second table. > > > Thanks, > > > Jenny > > _________________________________________________________________ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > From owner-sqr-users@list.iex.net Thu Apr 5 10:56:19 2001 Date: Thu, 5 Apr 2001 11:44:29 -0400 From: "Jamadagni, Rajendra" Subject: =?iso-8859-1?Q?RE=3A_R=E9p=2E_=3A_Re=3A_SQL_in_SQR?= Philippe, CREATE TABLE is a DDL and I believe in most RDBMS, DDL perform an implicit COMMIT statement, so you don't actually need a commit for CREATE TABLE, and even if you have, it won't do any good. HTH Raj ______________________________________________________ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! -----Original Message----- From: LEBLANC Philippe FTC [mailto:p.leblanc@FRANCETELECOM.COM] Sent: Thursday, April 05, 2001 11:07 AM To: SQR-USERS@list.iex.net Subject: Rép. : Re: SQL in SQR try using this; BEGIN-SQL ON-ERROR=SKIP CREATE TABLE PMCGEN_TEMP (GENERIC_NAME VARCHAR2(40)) TABLESPACE USER_ACCOUNTS STORAGE (INITIAL 5000K NEXT 500K);; create table pmcapp_temp (appl_type varchar2(1), appl_no varchar2(6)) TABLESPACE USER_ACCOUNTS STORAGE (INITIAL 5000K NEXT 500K);; commit;; end-sql ********************************************************************* This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ********************************************************************* From owner-sqr-users@list.iex.net Thu Apr 5 10:29:25 2001 Date: Thu, 5 Apr 2001 15:22:54 -0000 From: Tejus Shah Subject: Running Jobs in sequence in Broadcast server Hi, There are 5 jobs in broadcast server which I want to run in sequence one after the other. The second job should kick off as soon as the first job completion status has changed from "RUNNING" to something else. The Brio Repository is on SQL server and the jobs are connected to Oracle databases. Is there any way in Brio to achieve that?? The Data model option in Brio Query seems to be valid only if Repository and Job databases are same. Any help would be appreciated!! Thanks and Regards Tejus Shah _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. From owner-sqr-users@list.iex.net Thu Apr 5 12:57:19 2001 Date: Thu, 5 Apr 2001 17:49:04 -0000 From: Tejus Shah Subject: Re: Running Jobs in sequence in Broadcast server Let me know how to unscribe from this list. Thanks Tejus Shah >From: David Lyons >Reply-To: sqr-users@list.iex.net >To: "'Tejus Shah '" >Subject: RE: Running Jobs in sequence in Broadcast server >Date: Thu, 5 Apr 2001 09:02:02 -0700 > > This list is an SQR/BrioReport user list. You may want to try joining >the >BrioQuery list on Yahoo clubs. > >-----Original Message----- >From: Tejus Shah >To: SQR-USERS@list.iex.net >Sent: 4/5/01 8:22 AM >Subject: Running Jobs in sequence in Broadcast server > >Hi, >There are 5 jobs in broadcast server which I want to run in sequence one >after the other. >The second job should kick off as soon as the first job completion >status >has changed from "RUNNING" to something else. >The Brio Repository is on SQL server and the jobs are connected to >Oracle >databases. >Is there any way in Brio to achieve that?? > >The Data model option in Brio Query seems to be valid only if Repository >and >Job databases are same. > >Any help would be appreciated!! > >Thanks and Regards >Tejus Shah > > > > > >________________________________________________________________________ >_ >Get Your Private, Free E-mail from MSN Hotmail at >http://www.hotmail.com. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. From owner-sqr-users@list.iex.net Thu Apr 5 13:08:43 2001 Date: Thu, 5 Apr 2001 14:01:58 -0400 From: Rick_Creel@AONCONS.COM Subject: Re: Running Jobs in sequence in Broadcast server All you have to do is this: Send a message to listserv@list.iex.net with the following in the body of the message: unsubscribe sqr-users Tejus Shah on 04/05/2001 01:49:04 PM Please respond to sqr-users@list.iex.net To: SQR-USERS@list.iex.net cc: (bcc: Rick Creel/IT/Aon Consulting) Subject: Re: Running Jobs in sequence in Broadcast server Let me know how to unscribe from this list. Thanks Tejus Shah >From: David Lyons >Reply-To: sqr-users@list.iex.net >To: "'Tejus Shah '" >Subject: RE: Running Jobs in sequence in Broadcast server >Date: Thu, 5 Apr 2001 09:02:02 -0700 > > This list is an SQR/BrioReport user list. You may want to try joining >the >BrioQuery list on Yahoo clubs. > >-----Original Message----- >From: Tejus Shah >To: SQR-USERS@list.iex.net >Sent: 4/5/01 8:22 AM >Subject: Running Jobs in sequence in Broadcast server > >Hi, >There are 5 jobs in broadcast server which I want to run in sequence one >after the other. >The second job should kick off as soon as the first job completion >status >has changed from "RUNNING" to something else. >The Brio Repository is on SQL server and the jobs are connected to >Oracle >databases. >Is there any way in Brio to achieve that?? > >The Data model option in Brio Query seems to be valid only if Repository >and >Job databases are same. > >Any help would be appreciated!! > >Thanks and Regards >Tejus Shah > > > > > >________________________________________________________________________ >_ >Get Your Private, Free E-mail from MSN Hotmail at >http://www.hotmail.com. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. From owner-sqr-users@list.iex.net Thu Apr 5 10:53:48 2001 Date: Thu, 5 Apr 2001 12:45:48 -0300 From: Peter Clark Subject: =?ISO-8859-1?Q?R=E9p.=20:=20Re:=20SQL=20in=20SQR?= remembering, of course, that this (Phillipe's) syntax is only valid on Oracle. >>> LEBLANC Philippe FTC 2001/04/05 12:06:35 pm >>> try using this; BEGIN-SQL ON-ERROR=SKIP CREATE TABLE PMCGEN_TEMP (GENERIC_NAME VARCHAR2(40)) TABLESPACE USER_ACCOUNTS STORAGE (INITIAL 5000K NEXT 500K);; create table pmcapp_temp (appl_type varchar2(1), appl_no varchar2(6)) TABLESPACE USER_ACCOUNTS STORAGE (INITIAL 5000K NEXT 500K);; commit;; end-sql Cordialement, Philippe. >>> "Wagner, Jennifer A" 05/04/01 16h47 >>> Well, I've tried various and assorted things... this is the most recent one I tried: BEGIN-SQL ON-ERROR=SKIP CREATE TABLE PMCGEN_TEMP (GENERIC_NAME VARCHAR2(40)), create table pmcapp_temp (appl_type varchar2(1), appl_no varchar2(6)) TABLESPACE USER_ACCOUNTS STORAGE (INITIAL 5000K NEXT 500K); end-sql end-setup I also tried it without the comma separating the two create tables and I tried it with the semi-colon after the first table. Also I tried this: BEGIN-SQL ON-ERROR=SKIP CREATE TABLE PMCGEN_TEMP (GENERIC_NAME VARCHAR2(40)) TABLESPACE USER_ACCOUNTS STORAGE (INITIAL 5000K NEXT 500K); create table pmcapp_temp (appl_type varchar2(1), appl_no varchar2(6)) TABLESPACE USER_ACCOUNTS STORAGE (INITIAL 5000K NEXT 500K); end-sql Each time it seems to create the first but the second comes up with the error: table or view does not exist when it goes to do the insert. Thanks, Jenny > -----Original Message----- > From: the dragon [mailto:ceprn@hotmail.com] > Sent: Thursday, April 05, 2001 10:42 AM > To: sqr-users@list.iex.net > Cc: WAGNERJ@CDER.FDA.GOV > Subject: Re: SQL in SQR > > > show us the code you're attempting to use to create multiple tables. > > clark 'the dragon' willis > dragon enterprises, consulting services > > > ----Original Message Follows---- > > I'm trying to create temp tables in my SQR program. It will > allow me to > create one, but I can't seem to get it to create more than > one. My ultimate > goal would be to have a a multi-module program where I select > different > things from different tables and then insert them into the > various temp > tables. > > Do you know if you can create more than one temp table in a > SQL paragraph in > SQR? > > My temp table create statement looks like this: > > begin-setup > page-size 56 132 > > BEGIN-SQL ON-ERROR=SKIP > > CREATE TABLE PMCGEN_TEMP (GENERIC_NAME VARCHAR2(40)) > TABLESPACE USER_ACCOUNTS > STORAGE > (INITIAL 5000K > NEXT 500K); > end-sql > end-setup > > and the insert statement looks like this: > > begin-procedure INSERT_TEMP > BEGIN-SQL > INSERT INTO PMCGEN_TEMP (GENERIC_NAME) > values (&GEN); > END-SQL > COMMIT > end-procedure > > > That works fine. But, I've tried to add another create > table... and insert > into... and I get the message: "table for view does not > exist" for the > second table. > > > Thanks, > > > Jenny > > _________________________________________________________________ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > From owner-sqr-users@list.iex.net Thu Apr 5 11:28:26 2001 Date: Thu, 5 Apr 2001 10:16:46 -0600 From: Richard McComb Subject: Re: SQRWP printing - version 4.0.1 to version 4.3 I have the reports all specifying the HP printer option. I had tried LinePrinter, but got even worse print results. It would only print portrait format. With HP specified it switches based on the report. THe reports also have alter-printer options in use. The headers are in 16pt, some text in the report is 10pt, most of the report is in 8pt. It properly changes the font size, but not the font spacing. Some of the data is numeric, that prints properly. The data that is alpha is what prints strangely. I have both on the same line, the numbers print as 8 pt and 16.6 CPI, but the characters (which are really the account number, etc) print at 8pt and 10CPI. What I need is for the whole thing to print at 16.6CPI. The other thing that is weird is that the columns start in the correct places. Here is the code I have for the printer begin-setup declare-printer hp_laser type=HP font=3 point-size=8 end-declare declare-layout hp_default paper-size=(11,8.5) formfeed=NO orientation=LANDSCAPE left-margin=0.75 right-margin=0.25 top-margin=0.25 bottom-margin=0.25 end-declare declare-report newmess layout=hp_default printer-type=hplaserjet end-declare end-setup Then the page is laid out for where the columns should be: begin-procedure initialize_vars move 1 to #col1 !00 Status move 4 to #col2 !00000 CSN move 09 to #col3 !9999 Auto# move 14 to #col4 !999999 SEQ# move 19 to #col5 !xx-xx-xxxx tran date move 27 to #col6 !xx:xx:xx tran time move 35 to #col7 ! Personal move 50 to #col8 ! Description move 69 to #col9 !99,999,990.00 Credit move 82 to #col10 !99,999,990.00 Debit move 59 to #col11 ! Finish move 'empty string' to $adj_reason move 'YES' to $firsttime end-procedure ! initialize_vars The alter-printers look like this alter-printer point-size=8 The first four columns are properly spaced, columns 9 and 10 are properly spaced. All the data in between is spaced much too widely. The spaces between columns are spaced too widely as well. (Example col1 and col2 have a single space between them. This space is printing much wider that a 16.6 CPI space). This is driving me crazy. From owner-sqr-users@list.iex.net Thu Apr 5 11:49:54 2001 Date: Thu, 5 Apr 2001 11:44:30 -0500 From: Bob Helm Subject: dateadd problem I have a problem that should be easy to fix, but I'm stuck. I simply want to add 2 months to a date. My code is as follows: let $run_day = edit(Datenow(),'DD') if $run_day != '05' let $chart_for_date = dateadd(datenow(),'month',1) print $chart_for_date (+1,1) edit 'Month YYYY' else let $chart_for_date = Datenow() print $chart_for_date (+1,1) edit 'Month YYYY' end-if let $chart_thru_date = dateadd($chart_for_date,'month',2) print $chart_thru_date (+1,1) When I try to run I get the following error message: Error on line 282: (SQR 4045) Function or operator 'dateadd' requires date argument. As you can see, if I use Datenow() for the date value, it works. Otherwise, I get the error and am having to write unnecessary lines of code. Thanks a ton, B The Programmer formally known as Bob Mediware Information Systems Inc. (913) 307-1045 Bob.Helm@Mediware.com From owner-sqr-users@list.iex.net Thu Apr 5 11:58:05 2001 Date: Thu, 5 Apr 2001 12:57:17 -0400 From: ANDERSD2 Subject: Re: dateadd problem I'm not sure, but I think this is what is happening. The variable $Chart_For_Date is set to Month YYYY. This is not a "valid" date format so the code doesn't see the variable as a date. -----Original Message----- From: Bob Helm [mailto:Bob.Helm@MEDIWARE.COM] Sent: Thursday, April 05, 2001 12:45 PM To: SQR-USERS@list.iex.net Subject: dateadd problem I have a problem that should be easy to fix, but I'm stuck. I simply want to add 2 months to a date. My code is as follows: let $run_day = edit(Datenow(),'DD') if $run_day != '05' let $chart_for_date = dateadd(datenow(),'month',1) print $chart_for_date (+1,1) edit 'Month YYYY' else let $chart_for_date = Datenow() print $chart_for_date (+1,1) edit 'Month YYYY' end-if let $chart_thru_date = dateadd($chart_for_date,'month',2) print $chart_thru_date (+1,1) When I try to run I get the following error message: Error on line 282: (SQR 4045) Function or operator 'dateadd' requires date argument. As you can see, if I use Datenow() for the date value, it works. Otherwise, I get the error and am having to write unnecessary lines of code. Thanks a ton, B The Programmer formally known as Bob Mediware Information Systems Inc. (913) 307-1045 Bob.Helm@Mediware.com From owner-sqr-users@list.iex.net Thu Apr 5 12:02:29 2001 Date: Thu, 5 Apr 2001 12:59:37 -0400 From: Rick_Creel@AONCONS.COM Subject: Re: dateadd problem You have to explicitly DECLARE your date variable as a date type item, otherwise SQR assumes your variable to be of type = character and you will get the "dateadd" error. Put this at the top of your program and I think it will resolve your problem. begin-setup declare-variable date $chart_for_date $chart_thru_date end-declare end-setup When you do this, you might need to convert the date to a string (DATETOSTR) before printing it. Bob Helm on 04/05/2001 12:44:30 PM Please respond to sqr-users@list.iex.net To: SQR-USERS@list.iex.net cc: (bcc: Rick Creel/IT/Aon Consulting) Subject: dateadd problem I have a problem that should be easy to fix, but I'm stuck. I simply want to add 2 months to a date. My code is as follows: let $run_day = edit(Datenow(),'DD') if $run_day != '05' let $chart_for_date = dateadd(datenow(),'month',1) print $chart_for_date (+1,1) edit 'Month YYYY' else let $chart_for_date = Datenow() print $chart_for_date (+1,1) edit 'Month YYYY' end-if let $chart_thru_date = dateadd($chart_for_date,'month',2) print $chart_thru_date (+1,1) When I try to run I get the following error message: Error on line 282: (SQR 4045) Function or operator 'dateadd' requires date argument. As you can see, if I use Datenow() for the date value, it works. Otherwise, I get the error and am having to write unnecessary lines of code. Thanks a ton, B The Programmer formally known as Bob Mediware Information Systems Inc. (913) 307-1045 Bob.Helm@Mediware.com From owner-sqr-users@list.iex.net Thu Apr 5 12:08:58 2001 Date: Thu, 5 Apr 2001 11:01:57 -0600 From: Alan Lane Subject: Re: dateadd problem With release 4 they introduced a 'date' type. Define "$chart_for_date" as a date and I think the function will probably work OK. Good luck. Thanks, Alan Lane ajlane@carolina.rr.com (704) 543-7270 or (704) 516-4463 www.AJLaneInc.com FAX: (877) 877-4878 ext 3540 [follow verbal prompts] -----Original Message----- From: Discussion of SQR, Brio Technology's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Bob Helm Sent: Thursday, April 05, 2001 10:45 AM To: SQR-USERS@list.iex.net Subject: dateadd problem I have a problem that should be easy to fix, but I'm stuck. I simply want to add 2 months to a date. My code is as follows: let $run_day = edit(Datenow(),'DD') if $run_day != '05' let $chart_for_date = dateadd(datenow(),'month',1) print $chart_for_date (+1,1) edit 'Month YYYY' else let $chart_for_date = Datenow() print $chart_for_date (+1,1) edit 'Month YYYY' end-if let $chart_thru_date = dateadd($chart_for_date,'month',2) print $chart_thru_date (+1,1) When I try to run I get the following error message: Error on line 282: (SQR 4045) Function or operator 'dateadd' requires date argument. As you can see, if I use Datenow() for the date value, it works. Otherwise, I get the error and am having to write unnecessary lines of code. Thanks a ton, B The Programmer formally known as Bob Mediware Information Systems Inc. (913) 307-1045 Bob.Helm@Mediware.com From owner-sqr-users@list.iex.net Thu Apr 5 12:37:33 2001 Date: Thu, 5 Apr 2001 12:27:12 -0500 From: Bob Helm Subject: Re: dateadd problem That was the problem...Thanks for all your help! B The Programmer formally known as Bob Mediware Information Systems Inc. (913) 307-1045 Bob.Helm@Mediware.com -----Original Message----- From: Joy Hoyte [mailto:JoyHoyte_sqr@hotmail.com] Sent: Thursday, April 05, 2001 12:09 PM To: Bob.Helm@MEDIWARE.COM Subject: Re: dateadd problem Just checking...you did declare $run_day, $chart_for_date, etc. all as date variables, yes? Joy Hoyte ----- Original Message ----- From: "Bob Helm" To: Sent: Thursday, April 05, 2001 12:44 PM Subject: dateadd problem > I have a problem that should be easy to fix, but I'm stuck. > > I simply want to add 2 months to a date. My code is as follows: > > let $run_day = edit(Datenow(),'DD') > if $run_day != '05' > let $chart_for_date = dateadd(datenow(),'month',1) > print $chart_for_date (+1,1) edit 'Month YYYY' > else > let $chart_for_date = Datenow() > print $chart_for_date (+1,1) edit 'Month YYYY' > end-if > > let $chart_thru_date = dateadd($chart_for_date,'month',2) > print $chart_thru_date (+1,1) > > When I try to run I get the following error message: > > Error on line 282: > (SQR 4045) Function or operator 'dateadd' requires date argument. > > As you can see, if I use Datenow() for the date value, it works. Otherwise, > I get the error > and am having to write unnecessary lines of code. > > > Thanks a ton, > > B > The Programmer formally known as Bob > Mediware Information Systems Inc. > (913) 307-1045 > Bob.Helm@Mediware.com > From owner-sqr-users@list.iex.net Thu Apr 5 14:35:56 2001 Date: Thu, 5 Apr 2001 15:28:25 -0400 From: Patty Bergin Subject: Signed Numeric Edit I am trying to work with a value from a file that I received from an outside source. It is defined as S9(5)v99. The value on the input file is 001158A. This should represent 115.81, however, I cannot figure out a way to edit the signed numeric field. Any advice? Thanks. Patty Patricia Bergin Information Systems Syracuse University (315) 443-9277 From owner-sqr-users@list.iex.net Thu Apr 5 15:34:14 2001 Date: Thu, 5 Apr 2001 16:24:26 -0400 From: Patty Bergin Subject: Re: Signed Numeric Edit Thanks...that did the trick! Patricia Bergin Information Systems Syracuse University (315) 443-9277 >>> tdelia@EROLS.COM 04/05/01 05:01PM >>> Hi Patty, I have a routine you can find on my site, www.sqrtools.com, that can accept signed numeric data. There's also many utilities, techniques and other functions as well. See the section under TDFUNC for the library of functions... let #W_in = '001158A' do MFI-Func(#W_in, 2, #W_out) show #W_out The function returns 115.81 Cheers, Tony DeLia Patty Bergin wrote: > > I am trying to work with a value from a file that I received from an outside source. It is defined as S9(5)v99. The value on the input file is 001158A. This should represent 115.81, however, I cannot figure out a way to edit the signed numeric field. Any advice? > > Thanks. > Patty > > Patricia Bergin > Information Systems > Syracuse University > (315) 443-9277 -- Tony DeLia AnswerThink Consulting Group PeopleSoft Solutions Practice - Delphi Partners tdelia@erols.com http://www.sqrtools.com From owner-sqr-users@list.iex.net Thu Apr 5 14:55:34 2001 Date: Thu, 5 Apr 2001 16:01:44 -0500 From: Tony DeLia Subject: Re: Signed Numeric Edit Hi Patty, I have a routine you can find on my site, www.sqrtools.com, that can accept signed numeric data. There's also many utilities, techniques and other functions as well. See the section under TDFUNC for the library of functions... let #W_in = '001158A' do MFI-Func(#W_in, 2, #W_out) show #W_out The function returns 115.81 Cheers, Tony DeLia Patty Bergin wrote: > > I am trying to work with a value from a file that I received from an outside source. It is defined as S9(5)v99. The value on the input file is 001158A. This should represent 115.81, however, I cannot figure out a way to edit the signed numeric field. Any advice? > > Thanks. > Patty > > Patricia Bergin > Information Systems > Syracuse University > (315) 443-9277 -- Tony DeLia AnswerThink Consulting Group PeopleSoft Solutions Practice - Delphi Partners tdelia@erols.com http://www.sqrtools.com From owner-sqr-users@list.iex.net Thu Apr 5 20:42:39 2001 Date: Thu, 5 Apr 2001 21:29:04 -0400 From: a_moosa Subject: eCRM Survey: Graduate Thesis Role of Data Integration in eCRM. I am a graduate student concentrating in Data Warehousing and data mining. I am currently working on my capstone project which is a research paper on the role of data integration in eCRM. If you are a CRM Professional or CIO/CEO/CFO involved in an eCRM initiative, please take 5 minutes to fill out this short survey. This is a learning opportunity for me and I sincerely appreciate your time in filling this out.If interested, I can send you a copy of the results. Survey can be accessed at the link below: http://isomnt.uncg.edu/a_moosa/survey/ecrm-survey.htm Thanks, Ashfaaq Moosa ashfaaq@yahoo.com From owner-sqr-users@list.iex.net Fri Apr 6 09:01:39 2001 Date: Fri, 6 Apr 2001 09:55:11 -0400 From: Scott Eubank Subject: absolute value : not working whats up with that code: *************************************************************** let #Sum-Debits = abs(#Sum-Debits) let #Sum-Credit = abs(#Sum-Credit) show 'Sum Debits :' #Sum-Debits edit 9999999999.99 show 'Sum Crdits :' #Sum-Credits edit 9999999999.99 show ' H Debits :' $Debits show ' H Credits :'$Credits ******************************************************************** end code yeilds results: ---------------------------------------------------------------------- Sum Debits : 379434039.78 Sum Crdits :-379434039.78 H Debits : 379434039.78 H Credits : 379434039.78 --------------------------------------------------------------------- So whats up with the abs function if it does not work correctly. What am I doing wrong here? From owner-sqr-users@list.iex.net Fri Apr 6 09:08:02 2001 Date: Fri, 6 Apr 2001 10:05:05 -0400 From: "Combs, Shawn (Contractor)" Subject: Re: absolute value : not working whats up with that I might be missing something but... Below you are letting #Sum-Credit(Singular) = abs(#Sum-Credit) But you are Showing #Sum-Credits(Plural) Check your code and make sure that you are using the same variable name through out your code. Thanks! Shawn Combs, ULIT Soft, Inc. Bus: 321-674-4683, Cell: 321-960-1008 Email: scombs@ulitsoft.com -----Original Message----- From: Scott Eubank [mailto:SEUBANK@advanceautoparts.com] Sent: Friday, April 06, 2001 9:55 AM To: SQR-USERS@list.iex.net Subject: absolute value : not working whats up with that code: *************************************************************** let #Sum-Debits = abs(#Sum-Debits) let #Sum-Credit = abs(#Sum-Credit) show 'Sum Debits :' #Sum-Debits edit 9999999999.99 show 'Sum Crdits :' #Sum-Credits edit 9999999999.99 show ' H Debits :' $Debits show ' H Credits :'$Credits ******************************************************************** end code yeilds results: ---------------------------------------------------------------------- Sum Debits : 379434039.78 Sum Crdits :-379434039.78 H Debits : 379434039.78 H Credits : 379434039.78 --------------------------------------------------------------------- So whats up with the abs function if it does not work correctly. What am I doing wrong here? From owner-sqr-users@list.iex.net Fri Apr 6 09:21:12 2001 Date: Fri, 6 Apr 2001 10:16:13 -0400 From: Scott Eubank Subject: Re: absolute value : not working whats up with that DOH!!!!! DAMN IT! I hate it that you dont have ot declare your varialbes GOOD GREIF! THANKS SHAWN.... You related to Puffy .. isnt his name Shawn Combs . :) Have a nice day floks -----Original Message----- From: Combs, Shawn (Contractor) [mailto:scombs@HARRIS.COM] Sent: Friday, April 06, 2001 10:05 AM To: SQR-USERS@list.iex.net Subject: Re: absolute value : not working whats up with that I might be missing something but... Below you are letting #Sum-Credit(Singular) = abs(#Sum-Credit) But you are Showing #Sum-Credits(Plural) Check your code and make sure that you are using the same variable name through out your code. Thanks! Shawn Combs, ULIT Soft, Inc. Bus: 321-674-4683, Cell: 321-960-1008 Email: scombs@ulitsoft.com -----Original Message----- From: Scott Eubank [mailto:SEUBANK@advanceautoparts.com] Sent: Friday, April 06, 2001 9:55 AM To: SQR-USERS@list.iex.net Subject: absolute value : not working whats up with that code: *************************************************************** let #Sum-Debits = abs(#Sum-Debits) let #Sum-Credit = abs(#Sum-Credit) show 'Sum Debits :' #Sum-Debits edit 9999999999.99 show 'Sum Crdits :' #Sum-Credits edit 9999999999.99 show ' H Debits :' $Debits show ' H Credits :'$Credits ******************************************************************** end code yeilds results: ---------------------------------------------------------------------- Sum Debits : 379434039.78 Sum Crdits :-379434039.78 H Debits : 379434039.78 H Credits : 379434039.78 --------------------------------------------------------------------- So whats up with the abs function if it does not work correctly. What am I doing wrong here? From owner-sqr-users@list.iex.net Fri Apr 6 09:26:30 2001 Date: Fri, 6 Apr 2001 07:01:03 -0700 From: Rachael Beatty Subject: Re: absolute value : not working whats up with that --0__=vRMNBpHFHSk8Dg08yBUnZrnwnu6eDFDD4Xra7MuCigqeHH6eHYH5jOln Content-type: text/plain; charset=us-ascii Content-Disposition: inline Your abs function refers to sum-credit (no ending s), your display statement refers to sum-credits (with s). Do you have the variable sum-credits set higher up? Rachael > -----Original Message----- > From: Scott Eubank @INTERNET > Sent: Friday, April 06, 2001 6:55 AM > To: SQR-USERS@list.iex.net > Subject: absolute value : not working whats up with that > > > code: > *************************************************************** > let #Sum-Debits = abs(#Sum-Debits) > let #Sum-Credit = abs(#Sum-Credit) > > > > show 'Sum Debits :' #Sum-Debits edit 9999999999.99 > show 'Sum Crdits :' #Sum-Credits edit 9999999999.99 > > show ' H Debits :' $Debits > show ' H Credits :'$Credits > ******************************************************************** > end code > > yeilds results: > ---------------------------------------------------------------------- > Sum Debits : 379434039.78 > Sum Crdits :-379434039.78 > H Debits : 379434039.78 > H Credits : 379434039.78 > --------------------------------------------------------------------- > > So whats up with the abs function if it does not work correctly. What am > I > doing wrong here? (See attached file: C.DTF) --0__=vRMNBpHFHSk8Dg08yBUnZrnwnu6eDFDD4Xra7MuCigqeHH6eHYH5jOln Content-type: application/octet-stream; name="C.DTF" Content-Disposition: attachment; filename="C.DTF" Content-transfer-encoding: base64 eJ8+Ih0OAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQWAAwAOAAAA0QcEAAYABwABAAMABQDyAAEggAMADgAAANEHBAAG AAcAAwAbAAUADAEBCYABACEAAAA4N0U4M0UxNjE1MjlENTExODg2QjAwMDYyOTE3QkYxOQDqBgEE gAEANQAAAFJFOiBhYnNvbHV0ZSB2YWx1ZSA6ICBub3Qgd29ya2luZyB3aGF0cyB1cCB3aXRoIHRo YXQAkhIBDYAEAAIAAAACAAIAAQOQBgDACgAAMwAAAAMAAW4AAAAAAwAAgAggBgAAAAAAwAAAAAAA AEYAAAAAUoUAAH1uAQAeAAGACCAGAAAAAADAAAAAAAAARgAAAABUhQAAAQAAAAQAAAA5LjAACwAC gAggBgAAAAAAwAAAAAAAAEYAAAAABoUAAAAAAAADAAOACCAGAAAAAADAAAAAAAAARgAAAAABhQAA AAAAAAsABIAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAAAAAACwAFgAggBgAAAAAAwAAAAAAAAEYA AAAADoUAAAAAAAADAAaACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMAB4AIIAYAAAAAAMAA AAAAAABGAAAAABGFAAAAAAAACwAPgAggBgAAAAAAwAAAAAAAAEYAAAAAFIUAAAAAAAADAAiACCAG AAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAAsAEYAIIAYAAAAAAMAAAAAAAABGAAAAAIKFAAABAAAA AgEJEAEAAAC7AwAAtwMAABUHAABMWkZ1m7QUPQMACgByY3BnMTI1PjIA9AH3AqQD4wIAY2jBCsBz ZXQwIAcTAoNjAFAPpnBycQ5QEBhUPGFoA3ECgxIhA2RUbdEEIFJtbgKDMwRHCFXNAoB9CoAIyCA7 CW8OMF41Fv8KYAKACoF2CJB30msLgGQ0DGBjAFALA5ZjAEELYG4OEDAzFOHVC8QgHDBZCGEgAaAE IEBmdW5jdGkCICANGGBmBJAEIHRvIHNYdW0tBQAJgGkFQCg+bh4ACfAekBtQHhApLKwgeRxyHpBz C1F5HhB5AZB0ZQeAAjAdfQogICseZAQhYhCQKAPwdGi1H3EuHDBEHgAfwSAQMNR2ZR3gaCRQdgrA BzA/AmAkUB4oBCAQYSQQaWfjJIAFwHVwPwqiCoQKgHZSANAQMGUJUCb5CvRseGkzNgFAGvABQBHw b/cgwB0gC9I0HDAbJSpwETRQMTYgLSvSTwUQZw8LgAdABdAHkHNhZ2U/K9Mm5inkKbELEynmaS0Y MTQ0AUApMDE4MK8BQAzQL3MiIEYDYToDMBsMkiLRUwWgAkAgRXUCYgBwayA8U0VVAEJBTktAQURW ATLAQ0VBVVRPUABBUlRTLkNPTQA+QElOVEVSTnxFVCqRJvQiIAZgAjA6szEmMMBpZCBgH6BBEfAZ AxEwNh+gAdAwMSAsNjoYIBCgTTUHVG9BNddTUVItVTKAUixTQCkwIJAuCJB4Lu5uEHA1CDIQaioR NdccsV0G8HUgwCShCkEgMQAgux7gBUB3BbAaAR9gdxAw/yKRJrA9wCMiIzAgsCgcLf8zKhIpNHNs KnBB4m11ZmwuQRs+XG87kCCwdPBwaFwnDAETgiphJuXvGvASIRThK5A4IjAEcTXQ/SbzKkcfSC9J P0n5JuQcMBslEAVAIztwHkBEZWJVIoI9HKIoS8kpSw9D/x50TIlOtE2VUE9LUR4QEwCdB+AnS9Ej oEwkOidLu+sfAB6SOVRXLlRQUW9ScP9OsCJzUwZOtAQgVA9VFVUt7CBIUoZS8iRMFFlPVkH7ImRT ACRXRUa/Xs9f32DvT0qqHxFGUybqeWUDEGTvBCAYYB4gQqBzRqUr02WfH2avZ79orCbkUlogMzco OTQzL5AzVOA3OOtpuFZWLWrvClpJHDFuov9s323hXKdur2uGaK9zf3SP/3WfLWdp0x4APl4kUBy7 BpBzeZAFQGRvB5E9lkZRctMYYB0gbHkjgVc+YRyg/VJwSSbkegA+EwNgH1EmcRZlJtUWEQB+QAAe AHAAAQAAADEAAABhYnNvbHV0ZSB2YWx1ZSA6ICBub3Qgd29ya2luZyB3aGF0cyB1cCB3aXRoIHRo YXQAAAAAAgFxAAEAAAAbAAAAAcC+ooDPF5AgimxrQhG33I8Aa6WN5wAALiZwAAMALgAAAAAACwAC AAEAAAACATEAAQAAADkBAABQQ0RGRUIwOQABAAIAcwAAAAAAAAA4obsQBeUQGqG7CAArKlbCAABF TVNNREIuRExMAAAAAAAAAAAbVfogqmYRzZvIAKoAL8RaDAAAAExBU0lTTVhTMDEAL289SGlsdG9u L291PUxBU0lTL2NuPVJlY2lwaWVudHMvY249cmJlYXR0eQAuAAAAAAAAAL2giI/oQ9QRiF0ABikX vxkBAO8DZiv9P9QRiFcABKxMcKMAAAAARocAAAAAAAAuAAAAAAAAAL2giI/oQ9QRiF0ABikXvxkB AO8DZiv9P9QRiFcABKxMcKMAAAAARogAABAAAACH6D4WFSnVEYhrAAYpF78ZNQAAAFJFOiBhYnNv bHV0ZSB2YWx1ZSA6ICBub3Qgd29ya2luZyB3aGF0cyB1cCB3aXRoIHRoYXQAAAAAAwAJWQMAAAAe AEIQAQAAAEsAAAA8MTYzRUMzRTA2NEFFNDA0MTkyNDA1RDVGMDQ5RDZGNTMwMUZGOTVDNkBoaGNk Y214czAyLmhvdGVscy5hZC5oaWx0b24uY29tPgAAAwDeP69vAABAADkAcP6RBKK+wAEDAPE/CQQA AB4AMUABAAAACAAAAFJCRUFUVFkAAwAaQAAAAAAeADBAAQAAAAgAAABSQkVBVFRZAAMAGUAAAAAA AwAmAAAAAAADADYAAAAAAAMA/T/kBAAAAwCAEP////8CAUcAAQAAADIAAABjPVVTO2E9IDtwPUhp bHRvbjtsPUxBU0lTTVhTMDEtMDEwNDA2MTQwMTAzWi0xNzM5AAAAAgH5PwEAAABIAAAAAAAAANyn QMjAQhAatLkIACsv4YIBAAAAAAAAAC9PPUhJTFRPTi9PVT1MQVNJUy9DTj1SRUNJUElFTlRTL0NO PVJCRUFUVFkAHgD4PwEAAAAPAAAAUmFjaGFlbCBCZWF0dHkAAB4AOEABAAAACAAAAFJCRUFUVFkA AgH7PwEAAABIAAAAAAAAANynQMjAQhAatLkIACsv4YIBAAAAAAAAAC9PPUhJTFRPTi9PVT1MQVNJ Uy9DTj1SRUNJUElFTlRTL0NOPVJCRUFUVFkAHgD6PwEAAAAPAAAAUmFjaGFlbCBCZWF0dHkAAB4A OUABAAAACAAAAFJCRUFUVFkAQAAHMCZ8ptWhvsABQAAIMGDSbVqivsABHgA9AAEAAAAFAAAAUkU6 IAAAAAAeAB0OAQAAADEAAABhYnNvbHV0ZSB2YWx1ZSA6ICBub3Qgd29ya2luZyB3aGF0cyB1cCB3 aXRoIHRoYXQAAAAAHgA1EAEAAAA/AAAAPEVGMDM2NjJCRkQzRkQ0MTE4ODU3MDAwNEFDNEM3MEEz M0U0OTg2QGxhc2lzbXhzMDEuaGlsdG9uLmNvbT4AAAsAKQABAAAACwAjAAEAAAADAAYQR247WwMA BxC7AwAAAwAQEAAAAAADABEQAAAAAB4ACBABAAAAZQAAAFlPVVJBQlNGVU5DVElPTlJFRkVSU1RP U1VNLUNSRURJVChOT0VORElOR1MpLFlPVVJESVNQTEFZU1RBVEVNRU5UUkVGRVJTVE9TVU0tQ1JF RElUUyhXSVRIUylET1lPVUhBVkUAAAAAAgF/AAEAAAA/AAAAPEVGMDM2NjJCRkQzRkQ0MTE4ODU3 MDAwNEFDNEM3MEEzM0U0OTg2QGxhc2lzbXhzMDEuaGlsdG9uLmNvbT4AAFuXAgKQBgAOAAAAAgCN AQAA/////wAAAACMBAIQgAEAFAAAAFVudGl0bGVkIEF0dGFjaG1lbnQAcgcCEoADAA4AAADRBwQA BgAHAAEAAgAFAPEAAhOAAwAOAAAA0QcEAAYABwABAAIABQDxAAIFkAYAzA4AAA0AAAADACEOAAAA AAMACzeNAQAAAwAgDk4OAAADAPcPAAAAAAIBEGgBAAAADgAAAAAAAAAAAAAAAAAAAAAAAABAAAcw AMvvA6K+wAFAAAgwAMvvA6K+wAEDAAU3BgAAAAIBAjcBAAAAAAAAAB4AATABAAAAAQAAAAAAAAAC AQo3AQAAAAsAAAAqhkiG9xQDCgMCAQACAfkPAQAAABAAAAA387fTkSrVEbqjAASsTKV3DQABNwEA AAAQDgAACwAAAAAAAADAAAAAAAAARtDPEeChsRrhAAAAAAAAAAAAAAAAAAAAAD4AAwD+/wkABgAA AAAAAAAAAAAAAQAAAAEAAAAAAAAAABAAAAIAAAABAAAA/v///wAAAAAAAAAA//////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// /////////////////////////////f///wQAAAD+////BQAAAP7////+//////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////9SAG8AbwB0ACAARQBuAHQAcgB5AAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAFgAFAP//////////AgAAABYDAAAAAAAAwAAAAAAA AEYAAAAAAAAAAAAAAAAAdLRno77AAQMAAABAAgAAAAAAAAEATwBsAGUAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAKAAIB//////////////// AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABQAAAAAAAAAQwBPAE4AVABF AE4AVABTAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABIA AgEBAAAAAwAAAP////8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAXgEA AAAAAAADAE0AYQBpAGwAUwB0AHIAZQBhAG0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAGAACAf////8EAAAA/////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAcAAAAMAAAAAAAAAP7///8CAAAAAwAAAAQAAAAFAAAABgAAAP7////+/////v////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// ////////////////////////AQAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEJNXgEAAAAAAAAAAAAAKAAAADkCAAAEAAAAAQABAAAA AAAgAQAAxA4AAMQOAAAAAAAAAAAAAAAAAAD///8A//////////////////////////////////// //////////////////////////////////////////////////////////+AAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAGAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAGA//////////////////////////////////////////////////// //////////////////////////////////////////+AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAEAAADPOgAAagAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAABSAGkAYwBoAEUAZABpAHQARgBsAGEAZwBzAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHAACAP///////////////wAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAgAAAAMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA////////////////AAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD/ //////////////8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAP///////////////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAEAAEAAAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAJ7E= --0__=vRMNBpHFHSk8Dg08yBUnZrnwnu6eDFDD4Xra7MuCigqeHH6eHYH5jOln-- From owner-sqr-users@list.iex.net Fri Apr 6 09:27:42 2001 Date: Fri, 6 Apr 2001 14:25:14 -0000 From: Elvis Pressly Subject: Re: absolute value : not working whats up with that scott, You are showing two different kind of apples. One is numeric and the other is character type. Try using the mi mask in $Credits like.......... SHOW 'Credits ' $Credits 999999999.99mi If this wont work, then convert $credits into a numeric var. >From: Scott Eubank >Reply-To: sqr-users@list.iex.net >To: SQR-USERS@list.iex.net >Subject: absolute value : not working whats up with that >Date: Fri, 6 Apr 2001 09:55:11 -0400 > >code: >*************************************************************** > let #Sum-Debits = abs(#Sum-Debits) > let #Sum-Credit = abs(#Sum-Credit) > > > > show 'Sum Debits :' #Sum-Debits edit 9999999999.99 > show 'Sum Crdits :' #Sum-Credits edit 9999999999.99 > > show ' H Debits :' $Debits > show ' H Credits :'$Credits >******************************************************************** >end code > >yeilds results: >---------------------------------------------------------------------- >Sum Debits : 379434039.78 >Sum Crdits :-379434039.78 >H Debits : 379434039.78 >H Credits : 379434039.78 >--------------------------------------------------------------------- > >So whats up with the abs function if it does not work correctly. What am I >doing wrong here? _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com From owner-sqr-users@list.iex.net Sun Apr 8 20:37:37 2001 Date: Sun, 8 Apr 2001 18:34:18 -0700 From: Nicolas Moscaritolo Subject: MANY questions about SQR / Portal If you can point me in the right direction on ANY of these items, that would be great. 1. How can I hide the SPF file in the Portal. Currently, (by default), when an SQR job runs, it displays the HTML and the SPF. 2. PDF and fonts. I created an SQR program to produce a simple report. When I also had the SQR create a PDF, the fonts I had in the HTML did NOT show up in the PDF. Any ideas. 3. Using SQL Server and SQR 6.0, I could not get the LEFT JOIN to work. The client said that SQL Server takes ANSI SQL and therefore SQR is expected to. I am used to Oracle so the only join clause I've seen is Oracle style. 4. I tried to execute a SQL Server Stored Procedure using SQR 6.0. When I did (either through ReportBuilder or SQR Server), Dr. Watson paid a visit and it blew up. 5. Essbase and Oracle. What does the code look like. I assume that we would use DDO. A sample program would be great !!!!! 6. Creating an HTML doc from SQR 6.1.3, I coded links and anchor within SQR. When I click to link to an anchor and then click another link to go back to the top (and anchor), the VCR controls in the top HTML frame are gone. How do I get them back? 7. I would like HTML output. The layout has a number within a box. The number needs to be centered within the box and the box needs to be a standard width (not the width of the number). It seems that doing this with the HTML SQR tags is the only solution. Any other ideas? 8. CHARTS with color. I created a chart in SQR with a legend. Using the Create Pallete command, I created many colors to represent each bar within my graph. The legend came out fine with the proper colors but the bars in the graph all came out red. Any ideas? Enough question for now. Thanks for your attention to these issues. I will be working on these issues and would appreciate ANY feedback on ANY issues and/or SAMPLE CODE. I will re-publish the answers once I solve each for everyones benefit. Thanks Nick Moscaritolo Brio Technology Systems Consultant 15 Crestwood Drive Ashland, MA 01721 (617) 823-6783 From owner-sqr-users@list.iex.net Tue Apr 10 08:27:48 2001 Date: Tue, 10 Apr 2001 09:25:37 -0400 From: Paul Hoyte Subject: Re: MANY questions about SQR / Portal Lets give this a shot.... 1. I don't know of a way to hide or suppress the production of the SPF file in the portal. We tried to do this a a class recently and found that the Portal JF is defaulting to using the -keep parameter which will automatically produce the spf file. Would have to change portal internally to keep the spf from being produced. 2. If you do not have the PDF fonts defined in the SQR.ini file with the same font number as the HTML section, then you will get the default PDF font which if I remember correctly is Courier. 3. Just completed an assignment using SQL Server7 and Sqr 6 and it worked fine. Use the *= or =* to indicated the left or right outer joins. EG And PERSEXTRNL.RELATION_CD *= CODESET.ID. Can't use the same table however in a join to another. 4. Dr. Watson appearances require a little more research with a lot more information. One thing to look at is to make sure that you are authorized to execute the procedure. 5. The DDO interface is the way to connect to Essbase. Don't have a sample program handy but you might want to check with the developers at your home office for some pointers.... 7. Another idea is to make a gif file for the square and then use the precision printing to position the square and them print the number inside of the square. That's all for now..... Paul Hoyte Sharidionne, Inc. (248) 559-6868 www.sharidionne.com phoyte@sharidionne.com -----Original Message----- From: Discussion of SQR, Brio Technology's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Nicolas Moscaritolo Sent: Sunday, April 08, 2001 9:34 PM To: SQR-USERS@list.iex.net Subject: MANY questions about SQR / Portal If you can point me in the right direction on ANY of these items, that would be great. 1. How can I hide the SPF file in the Portal. Currently, (by default), when an SQR job runs, it displays the HTML and the SPF. 2. PDF and fonts. I created an SQR program to produce a simple report. When I also had the SQR create a PDF, the fonts I had in the HTML did NOT show up in the PDF. Any ideas. 3. Using SQL Server and SQR 6.0, I could not get the LEFT JOIN to work. The client said that SQL Server takes ANSI SQL and therefore SQR is expected to. I am used to Oracle so the only join clause I've seen is Oracle style. 4. I tried to execute a SQL Server Stored Procedure using SQR 6.0. When I did (either through ReportBuilder or SQR Server), Dr. Watson paid a visit and it blew up. 5. Essbase and Oracle. What does the code look like. I assume that we would use DDO. A sample program would be great !!!!! 6. Creating an HTML doc from SQR 6.1.3, I coded links and anchor within SQR. When I click to link to an anchor and then click another link to go back to the top (and anchor), the VCR controls in the top HTML frame are gone. How do I get them back? 7. I would like HTML output. The layout has a number within a box. The number needs to be centered within the box and the box needs to be a standard width (not the width of the number). It seems that doing this with the HTML SQR tags is the only solution. Any other ideas? 8. CHARTS with color. I created a chart in SQR with a legend. Using the Create Pallete command, I created many colors to represent each bar within my graph. The legend came out fine with the proper colors but the bars in the graph all came out red. Any ideas? Enough question for now. Thanks for your attention to these issues. I will be working on these issues and would appreciate ANY feedback on ANY issues and/or SAMPLE CODE. I will re-publish the answers once I solve each for everyones benefit. Thanks Nick Moscaritolo Brio Technology Systems Consultant 15 Crestwood Drive Ashland, MA 01721 (617) 823-6783 From owner-sqr-users@list.iex.net Mon Apr 9 08:22:17 2001 Date: Mon, 9 Apr 2001 10:04:11 -0300 From: Peter Clark Subject: Re: strike through characters The answer depends on the character set you are using. You might find the answer at this site (I did note that there is a Ø in the MS Windows set which may work for you): http://www.jimprice.com/jim-asc.htm HTH, Peter >>> "Charles A. Harkness" 2001/04/09 12:48:13 pm >>> Hello, I've been searching the SQR database and my book "SQR in Peoplesoft" and I have not found a way to print strike through characters. I am mainly interested in having a slash through the number zero, to differentiate it from the letter O. Does anyone have any ideas on how to do this. Thank you, Chuck From owner-sqr-users@list.iex.net Mon Apr 9 09:06:51 2001 Date: Mon, 9 Apr 2001 09:35:45 -0400 From: Philippe Godin Subject: Error Management Good day, I was wondering if SQR got some sort of error management. I would like to catch all errors that are produce within the execution of a report. To give you an example, let's pretend I'm using an input to get a date from the user. Instead of validating if the date correspond to our edit-mask or if it is valid, I would like to catch the error it produce on execution and associate this with a procedure that would do some some of processing. Giving the wrong date format produces that error: (SQR 5528) ODBC SQL dbexec: SQLExecute error 317 in cursor 1: [INTERSOLV][ODBC SQLBase driver][SQLBase]00317 EXE DND Data is not a date Error on line 242: (SQR 3723) Problem executing cursor. SQRT: Program Aborting. Does anyone can help... (SQR/4.0.3/PC/WINDOWS NT 4.0/ODBC Level1/Jun 11 1997) Philippe Godin CiM Maintenance Inc. Philippe.Godin@videotron.ca From owner-sqr-users@list.iex.net Mon Apr 9 09:59:36 2001 Date: Mon, 9 Apr 2001 15:52:50 +0100 From: =?iso-8859-1?q?Hari=20Haran?= Subject: Appln Messg - PT 8.11 - FileLayout & Comp.Intfc Hi friends, I need some help. 1. Is it necessary for me to convert a generic xml into predefined xml format before subscribing from peoplesoft or can we use an xml file layout for our specifc xml. 2. Can we use Component Interface to do Inbound Data Validations or should it be done in PeopleCode. Thanking you in advance. Hari. ____________________________________________________________ Do You Yahoo!? For regular News updates go to http://in.news.yahoo.com From owner-sqr-users@list.iex.net Mon Apr 9 10:17:31 2001 Date: Mon, 9 Apr 2001 12:12:17 -0300 From: Peter Clark Subject: Re: Appln Messg - PT 8.11 - FileLayout & Comp.Intfc Wrong mail list, Hari. Try PeopleSoft-Fans. >>> Hari Haran 2001/04/09 11:52:50 am >>> Hi friends, I need some help. 1. Is it necessary for me to convert a generic xml into predefined xml format before subscribing from peoplesoft or can we use an xml file layout for our specifc xml. 2. Can we use Component Interface to do Inbound Data Validations or should it be done in PeopleCode. Thanking you in advance. Hari. ____________________________________________________________ Do You Yahoo!? For regular News updates go to http://in.news.yahoo.com From owner-sqr-users@list.iex.net Mon Apr 9 10:24:48 2001 Date: Mon, 9 Apr 2001 11:22:05 -0400 From: "Love, Kristin" Subject: Keeping lines together: wrap Is there an option for WRAP which tells the computer not to split the WRAP text between lines? Or do I have to do some sort of math with the maximum wrap depth? Kristin Love Management Science Associates Pittsburgh, PA From owner-sqr-users@list.iex.net Mon Apr 9 14:02:07 2001 Date: Mon, 9 Apr 2001 13:56:11 -0500 From: Don Mellen Subject: Re: Keeping lines together: wrap On Mon, 9 Apr 2001, Love, Kristin wrote: > Is there an option for WRAP which tells the computer not to split the WRAP > text between lines? > > Or do I have to do some sort of math with the maximum wrap depth? I'm assuming you meant to ask if their was a way to prevent Wrap from splitting between *pages*. For that, you do need to use WrapDepth() and either calc where you are on the page, or (much easier) use "next-listing" with the "need=nn" option. 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 Mon Apr 9 14:22:01 2001 Date: Mon, 9 Apr 2001 15:12:52 -0400 From: "Love, Kristin" Subject: Re: Keeping lines together: wrap Yes, sorry about the mistype. next-listing need=nn is what I was trying to remember. > -----Original Message----- > From: Don Mellen [SMTP:donm@ONTKO.COM] > Sent: Monday, April 09, 2001 2:56 PM > To: SQR-USERS@list.iex.net > Subject: Re: Keeping lines together: wrap > > On Mon, 9 Apr 2001, Love, Kristin wrote: > > > Is there an option for WRAP which tells the computer not to split the > WRAP > > text between lines? > > > > Or do I have to do some sort of math with the maximum wrap depth? > > I'm assuming you meant to ask if their was a way to prevent Wrap from > splitting between *pages*. For that, you do need to use WrapDepth() and > either calc where you are on the page, or (much easier) use "next-listing" > with the "need=nn" option. > > 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 Mon Apr 9 13:42:41 2001 Date: Mon, 9 Apr 2001 14:39:05 -0700 From: "Charles A. Harkness" Subject: Re: Keeping lines together: wrap Kristin, I think the point of the of WRAP, is to wrap a line to another line. The example in the book is: Print $Comments (1,1) Wrap 15,3 Which prints the value of $Comments in several lines, 15 character per line for a maximum of 3 lines. Chuck At 11:22 AM 4/9/01 -0400, you wrote: >Is there an option for WRAP which tells the computer not to split the WRAP >text between lines? > >Or do I have to do some sort of math with the maximum wrap depth? > >Kristin Love >Management Science Associates >Pittsburgh, PA > > From owner-sqr-users@list.iex.net Mon Apr 9 08:12:49 2001 Date: Mon, 9 Apr 2001 08:48:13 -0700 From: "Charles A. Harkness" Subject: strike through characters Hello, I've been searching the SQR database and my book "SQR in Peoplesoft" and I have not found a way to print strike through characters. I am mainly interested in having a slash through the number zero, to differentiate it from the letter O. Does anyone have any ideas on how to do this. Thank you, Chuck From owner-sqr-users@list.iex.net Mon Apr 9 10:19:10 2001 Date: Mon, 9 Apr 2001 11:13:21 -0700 From: "Charles A. Harkness" Subject: Re: strike through characters Peter, Thanks, I have tried playing with the sqr since you sent me this email. I was using the ascii function and I am only able to get results on the first character of the string. I'm still working on it. Chuck At 10:04 AM 4/9/01 -0300, you wrote: >The answer depends on the character set you are using. You might find the answer at this site (I did note that there is a Ø in the MS Windows set which may work for you): >http://www.jimprice.com/jim-asc.htm > >HTH, >Peter > >>>> "Charles A. Harkness" 2001/04/09 12:48:13 pm >>> >Hello, > I've been searching the SQR database and my book "SQR in Peoplesoft" and >I have not found a way to print strike through characters. I am mainly >interested in having a slash through the number zero, to differentiate it >from the letter O. Does anyone have any ideas on how to do this. > >Thank you, > Chuck > > From owner-sqr-users@list.iex.net Mon Apr 9 17:28:26 2001 Date: Mon, 9 Apr 2001 15:22:25 -0700 From: Carolyn Woods Subject: Call to a COBOL program from an SQR We are trying to figure out how to call a COBOL program from inside an SQR, has anyone done this? Thanks, Carolyn Woods MiraCosta College Oceanside, CA From owner-sqr-users@list.iex.net Thu Apr 12 12:50:14 2001 Date: Thu, 12 Apr 2001 13:47:20 -0400 From: "Schelske, Steve K." Subject: Re: Call to a COBOL program from an SQR If you know how to start the COBOL program from the command line, you can use the CALL SYSTEM USING function to execute the COBOL program. You can search the sqrug.com archives for lots of examples on how to properly use CALL SYSTEM. If you don't know how to start the program from the command line, try to run it that way and you may get prompted for the information that is required at run time. -----Original Message----- From: Discussion of SQR, Brio Technology's database reporting language [mailto:SQR-USERS@list.iex.net]On Behalf Of Carolyn Woods Sent: Monday, April 09, 2001 6:22 PM To: SQR-USERS@list.iex.net Subject: Call to a COBOL program from an SQR We are trying to figure out how to call a COBOL program from inside an SQR, has anyone done this? Thanks, Carolyn Woods MiraCosta College Oceanside, CA From owner-sqr-users@list.iex.net Thu Apr 12 12:59:17 2001 Date: Thu, 12 Apr 2001 12:54:33 -0500 From: David Thompson-Hall Subject: Re: Call to a COBOL program from an SQR At 01:47 PM 4/12/01 -0400, you wrote: >If you know how to start the COBOL program from the command line, you can >use the CALL SYSTEM USING function to execute the COBOL program. > >You can search the sqrug.com archives for lots of examples on how to >properly use CALL SYSTEM. > >If you don't know how to start the program from the command line, try to run >it that way and you may get prompted for the information that is required at >run time. However, if you're trying to call a COBOL that does DB access, then the situation is more complex. You need to be able to pass the logon and password to the database. I don't think this has been done successfully in PeopleSoft, since in that case the DB SYSADM password is a closely guarded secret, and you have to modify the PS process for calling COBOLs to pass along the password. (This is described but not detailed fully in the "SQR in Peoplesoft and other applications" book by Landries and Landries. If you can get your DBAs or Sysadmins to agree to customizing this central piece of PS functionality, maybe it would work, but ours won't.) I say I don't think it's been done in PS because I asked about this a few months ago, and nobody had an answer then either... I think for non-PeopleSoft, the trick is just calling the COBOL program correctly, and then CALL SYSTEM USING should do the trick. DTH David Thompson-Hall 1210 W. Dayton St. Programmer/Analyst Madison, WI 53706 Apps Tech/Business Operations Apps 608/265-9571 Div of Info Technology (DoIT) University of Wisconsin-Madison david.thompson-hall@doit.wisc.edu From owner-sqr-users@list.iex.net Tue Apr 10 04:17:43 2001 Date: Tue, 10 Apr 2001 09:52:15 +0100 From: John Roddy Subject: SQR/REPORT BUILDER Hi All, I am new to the above products an was hoping somone could advise me on the following please. I have installed the above products, and want to create a report that will pull back 2.65 million rows from an Oracle 8i DB. The server that I have tried to run this type of report on has a dual processor, 2.75 GB of hard disk space and .5 GB of RAM. The report crashes as the machine runs out of memory. Has anybody had experience building such a large report using report builder, and what time frames could I expect to complete such