From sqr-users-bounces@sqrug.org Sun Oct 07 07:50:10 2007 Date: Thu, 4 Oct 2007 03:57:13 -0400 From: "Kumar, Rahul" Subject: [sqr-users] Flags setting for #include files Hi,=0D =0D =0D =0D I am working on one case where I need to include one=0D particular(customized) sqc from a custom folder (a folder other than=0D where all the sqc are placed).The issue is : the normal folder where all=0D the sqcs are placed is also having this sqc with the same name but is=0D not customized.=0D =0D I need to do this task without making any changes to the SQR which uses=0D this sqc. I need to know if there Is any SQR Flag which will force it to=0D take this sqc from the custom folder. Please note that the sqc also=0D exist in the normal folder from where sqr will use all the other sqcs,=0D but I need to use only that sqc which is placed in the custom folder.=0D =0D Any help or suggestion will be appreciated.=0D =0D =0D =0D Thanks in Advance=0D =0D =0D =0D Regards,=0D =0D Rahul=0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D -----------------------------------------=0D This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, notify the sender immediately by return email and delete the message and any attachments from your system. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Sun Oct 07 07:56:33 2007 Date: Thu, 4 Oct 2007 18:01:47 -0400 From: maddy Subject: [sqr-users] Challenging issue with Brio SQR in UNIX Hi, We have a strange problem with all the Brio SQR Programs executing under UNIX environment.All these programs are working fine and giving data when executed in windows environment and giving no data in UNIX enviroment. We are creating a temp table and inserting data in the SQR program but unable to Select the data from the same table and print it on to the report.However when the ORDER BY clause in the select statement is commented out, data is pulled on to the report. If I run the same program again without droping and creating the table we get the data from the table even with ORDER BY clause which is strange. How can a ORDER BY clause in the SELECT statement cause this kind of issue ? I can send the skeleton program if any of the experts can look into this issue. Environment: Hyperion 8.5 installed on UNIX (AIX) Thanks, Maddy _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Sun Oct 07 10:36:17 2007 From: the dragon Subject: RE: [sqr-users] Loading fixed length flat file into Sybase table Date: Sun, 7 Oct 2007 07:23:05 -0500 That's the only choice you have. One insert =3D one tag to the database, a= nd each record needs to be inserted. =20 I beleieve that's the way it is with any RDBMS and any application. =20 What is it you're looking for? =20 peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your= services for 40 hours a week, not purchasing your soul. Your time is the o= nly real finite asset that you have, and once used it can never be recovere= d, so don't waste it by giving it away. I work to live; I don't live to wor= k. "Time is the coin of your life. It is the only coin you have, and only y= ou can determine how it will be spent. Be careful lest you let other people= spend it for you." -- Carl Sandburg (1878 - 1967) It is impossible to defe= at an ignorant man in argument. -- William G. McAdoo Religion is regarded b= y the common people as true, by the wise as false, and by the rulers as use= ful. -- Seneca "I distrust those people who know so well what God wants the= m to do because I notice it always coincides with their own desires." - Sus= an B. Anthony> Date: Thu, 27 Sep 2007 14:57:38 -0400> From: madhudvm@gmail.= com> To: sqr-users@sqrug.org> Subject: [sqr-users] Loading fixed length fla= t file into Sybase table> > Hi,> > What is the better way to load the data = from fixed length flat file into a> sybase database table using SQR. Number= of rows in the file vary from 10,000> to 50,000> > I'm doing something lik= e the code below, but my concern is for each insert> statement it goes to t= he database and could be performance issue.> ******************************= ***************************************************************************= *****************> open 'aaaa.txt' AS 100 for-reading record=3D600:fixed st= atus=3D#z> > while 1> > read 10 into $name:40 $Id:30 $location:50> > if #en= d-file> > break> > end-if> > begin-sql> > insert into cust (name, Id, locat= ion)> > values ($name, $ID, $location)> > end-sql> > add 1 to #inserts> > i= f #inserts >=3D 100> > begin-sql> > commit transaction> > begin transaction= > > end-sql> > move 0 to #inserts> > end-if> end-while> *******************= ***************************************************************************= **************> Thanks!!> Maddy>=20 _________________________________________________________________ Help yourself to FREE treats served up daily at the Messenger Caf=E9. Stop = by today. http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid=3DTXT_TAGLM_Oc= tWLtagline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Sun Oct 07 11:42:18 2007 From: the dragon Subject: RE: [sqr-users] Challenging issue with Brio SQR in UNIX Date: Sun, 7 Oct 2007 08:56:07 -0500 I guess my primary question is *why* would you ever be creating a temp tabl= e and putting crap into it to start with? That is so inefficient and one o= f the primary reason that the abortion called App Engine sucks so badly. J= ust select your data and process it. If this is a program that gets run re= gularly, and you absolutely need a temp table, just build a real table in a= pp designer/your database and truncate it before running the program. OK, now on to your question... Your program should be working OK, If it w= orks in Windoze, it will work on Unix. There may be some system variable c= ausing the issue, like a memory constraint, but I don't see that as an issu= e. Run your program in debug mode and with the -s flag in Unix and see wha= t you get. If the sqr creates the table, and populates it, then the data i= s there for selection and use. Are you getting any errors? Like snapshot too old, or unable to extend tem= p segment??? Also, what database are you using? Informix? Perhaps it's no= t committing the data to the table before the select and it uses a differen= t thread to do the select than the one used for the insert (real databases = don't have this problem).=20 Sure send us the program, and give us information about the environment/pla= tform. peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your= services for 40 hours a week, not purchasing your soul. Your time is the o= nly real finite asset that you have, and once used it can never be recovere= d, so don't waste it by giving it away. I work to live; I don't live to work. "Time is the coin of your life. It is the only coin you have, and only you = can determine how it will be spent. Be careful lest you let other people sp= end it for you." -- Carl Sandburg (1878 - 1967) It is impossible to defeat an ignorant man in argument. -- William G. McAdoo Religion is regarded by the common people as true, by the wise as false, an= d by the rulers as useful. -- Seneca "I distrust those people who know so well what God wants them to do because= I notice it always coincides with their own desires." - Susan B. Anthony > Date: Thu, 4 Oct 2007 18:01:47 -0400 > From: madhudvm@gmail.com > To: sqr-users@sqrug.org > Subject: [sqr-users] Challenging issue with Brio SQR in UNIX > > Hi, > > We have a strange problem with all the Brio SQR Programs executing under > UNIX environment.All these programs are working fine and giving data when > executed in windows environment and giving no data in UNIX enviroment. > > We are creating a temp table and inserting data in the SQR program but > unable to Select the data from the same table and print it on to the > report.However when the ORDER BY clause in the select statement is commen= ted > out, data is pulled on to the report. > > If I run the same program again without droping and creating the table we > get the data from the table even with ORDER BY clause which is strange. > How can a ORDER BY clause in the SELECT statement cause this kind of issue > ? I can send the skeleton program if any of the experts can look into this > issue. > > Environment: Hyperion 8.5 installed on UNIX (AIX) > > Thanks, > Maddy > _________________________________________________________________ Climb to the top of the charts!=A0 Play Star Shuffle:=A0 the word scramble = challenge with star power. http://club.live.com/star_shuffle.aspx?icid=3Dstarshuffle_wlmailtextlink_oct _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Sun Oct 07 11:46:42 2007 From: the dragon Subject: RE: [sqr-users] Flags setting for #include files Date: Sun, 7 Oct 2007 08:59:16 -0500 We need more information - are you using this with Peoplesoft, or stand alo= ne? How are you executing the program? If with PeopleSoft, what version o= f tools? You can generally set up the include path using the -i flag. peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your= services for 40 hours a week, not purchasing your soul. Your time is the o= nly real finite asset that you have, and once used it can never be recovere= d, so don't waste it by giving it away. I work to live; I don't live to work. "Time is the coin of your life. It is the only coin you have, and only you = can determine how it will be spent. Be careful lest you let other people sp= end it for you." -- Carl Sandburg (1878 - 1967) It is impossible to defeat an ignorant man in argument. -- William G. McAdoo Religion is regarded by the common people as true, by the wise as false, an= d by the rulers as useful. -- Seneca "I distrust those people who know so well what God wants them to do because= I notice it always coincides with their own desires." - Susan B. Anthony > Date: Thu, 4 Oct 2007 03:57:13 -0400 > From: Rahul_Kumar@adp.com > To: sqr-users@sqrug.org > Subject: [sqr-users] Flags setting for #include files > > Hi, > > I am working on one case where I need to include one > particular(customized) sqc from a custom folder (a folder other than > where all the sqc are placed).The issue is : the normal folder where all > the sqcs are placed is also having this sqc with the same name but is > not customized. > > I need to do this task without making any changes to the SQR which uses > this sqc. I need to know if there Is any SQR Flag which will force it to > take this sqc from the custom folder. Please note that the sqc also > exist in the normal folder from where sqr will use all the other sqcs, > but I need to use only that sqc which is placed in the custom folder. > > > > Any help or suggestion will be appreciated. > > Thanks in Advance > > Regards, > Rahul > > _________________________________________________________________ Boo!=A0Scare away worms, viruses and so much more! Try Windows Live OneCare! http://onecare.live.com/standard/en-us/purchase/trial.aspx?s_cid=3Dwl_hotma= ilnews _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Sun Oct 07 11:52:31 2007 Date: Sun, 7 Oct 2007 11:44:52 -0400 From: "Barilleaux, Rebecca" Subject: [sqr-users] RE: sqr-users Digest, Vol 44, Issue 1 I've used bcp to import text files into Sybase tables quickly. Here's an e= xample (you need to fill in the userid, password & server): let $comand =3D 'bcp cust in aaaa.txt -c -X -U userid -P password -S server' display $command call system using $comand #statuscode if #statuscode <> 0 display 'bcp failed' stop else display 'bcp successful' end-if I initially put it in a temp table, then I can run whatever edits I need be= fore inserting all the rows from the temp table into the real table. But i= f you know that all your data in the temp table is ok, then you may be able= to bcp directly into your real table. -----Original Message----- Date: Thu, 27 Sep 2007 14:57:38 -0400 From: maddy Subject: [sqr-users] Loading fixed length flat file into Sybase table To: "This list is for discussion about the SQR database reporting language from Hyperion Solutions." Message-ID: Content-Type: text/plain; charset=3DISO-8859-1 Hi, What is the better way to load the data from fixed length flat file into a sybase database table using SQR. Number of rows in the file vary from 10,000 to 50,000 I'm doing something like the code below, but my concern is for each insert statement it goes to the database and could be performance issue. ***************************************************************************= *********************************************** open 'aaaa.txt' AS 100 for-reading record=3D600:fixed status=3D#z while 1 read 10 into $name:40 $Id:30 $location:50 if #end-file break end-if begin-sql insert into cust (name, Id, location) values ($name, $ID, $location) end-sql add 1 to #inserts if #inserts >=3D 100 begin-sql commit transaction begin transaction end-sql move 0 to #inserts end-if end-while ***************************************************************************= ********************************* Thanks!! Maddy ------------------------------ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users =20 CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,=20 is for the sole use of the intended recipient(s) and may contain confidenti= al and privileged information or otherwise protected by law. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Sun Oct 07 11:57:12 2007 Subject: RE: [sqr-users] Flags setting for #include files Date: Sun, 7 Oct 2007 11:44:30 -0400 From: "Larry Roux" This is a multi-part message in MIME format... ------_=_NextPart_001_01C808F9.4874D151 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable You can include the new location in the order of the include seach (ie make= the new location first). ie: -ic:\newsqcs;d:\origsqcs. I forget if the t= railing \ is needed or not. Or you can hard-code the location in the SQR= (ie #include 'c:\newsqcs\abc.sqc') =20 =20 ________________________________ From: sqr-users-bounces+lroux=3Dsyr.edu@sqrug.org on behalf of Kumar, Rahul Sent: Thu 10/4/2007 3:57 AM To: This list is for discussion about the SQR database reportinglanguage fr= omHyperion Solutions. Subject: [sqr-users] Flags setting for #include files Hi, I am working on one case where I need to include one particular(customized) sqc from a custom folder (a folder other than where all the sqc are placed).The issue is : the normal folder where all the sqcs are placed is also having this sqc with the same name but is not customized. I need to do this task without making any changes to the SQR which uses this sqc. I need to know if there Is any SQR Flag which will force it to take this sqc from the custom folder. Please note that the sqc also exist in the normal folder from where sqr will use all the other sqcs, but I need to use only that sqc which is placed in the custom folder. Any help or suggestion will be appreciated. Thanks in Advance Regards, Rahul ----------------------------------------- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, notify the sender immediately by return email and delete the message and any attachments from your system. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ------_=_NextPart_001_01C808F9.4874D151 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Description: AUTOMATIC WARNING Here was a non admissible message part of 'application/ms-tnef' MIME type. It has been automatically discarded before sending the message to the list. ------_=_NextPart_001_01C808F9.4874D151 Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ------_=_NextPart_001_01C808F9.4874D151-- From sqr-users-bounces@sqrug.org Mon Oct 08 08:54:38 2007 Subject: RE: [sqr-users] Challenging issue with Brio SQR in UNIX Date: Mon, 8 Oct 2007 07:48:40 -0500 From: "Bambach, Tom" Maddy, See if making the select statement dynamic helps - ie, let $where =3D 'WHERE A.FIELD=3D' || chr(39) || $var || chr(39) then in the select statement: : : FROM table A [$where] : : I've had issues like you describe that were inexplicably solved by putting the WHERE statement in a variable... Tom -----Original Message----- From: maddy [mailto:madhudvm@gmail.com]=20 Sent: Thursday, October 04, 2007 6:02 PM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: [sqr-users] Challenging issue with Brio SQR in UNIX Hi, We have a strange problem with all the Brio SQR Programs executing under UNIX environment.All these programs are working fine and giving data when executed in windows environment and giving no data in UNIX enviroment. We are creating a temp table and inserting data in the SQR program but unable to Select the data from the same table and print it on to the report.However when the ORDER BY clause in the select statement is commented out, data is pulled on to the report. If I run the same program again without droping and creating the table we get the data from the table even with ORDER BY clause which is strange. How can a ORDER BY clause in the SELECT statement cause this kind of issue ? I can send the skeleton program if any of the experts can look into this issue. Environment: Hyperion 8.5 installed on UNIX (AIX) Thanks, Maddy _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Mon Oct 08 17:25:47 2007 From: rayo@ontko.com Date: Mon, 8 Oct 2007 23:20:21 +0200 Subject: [sqr-users] RETURNED MAIL: SEE TRANSCRIPT FOR DETAILS This is a multi-part message in MIME format... ------=_NextPart_000_0013_2DF6C964.135ABD37 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit The original message was received at Mon, 8 Oct 2007 23:20:21 +0200 from 180.102.241.87 ----- The following addresses had permanent fatal errors ----- sqr-users@sqrug.org ------=_NextPart_000_0013_2DF6C964.135ABD37 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Description: AUTOMATIC WARNING Here was a non admissible message part of 'application/octet-stream' MIME type. It has been automatically discarded before sending the message to the list. ------=_NextPart_000_0013_2DF6C964.135ABD37 Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ------=_NextPart_000_0013_2DF6C964.135ABD37-- From sqr-users-bounces@sqrug.org Mon Oct 08 17:43:56 2007 From: the dragon Subject: RE: [sqr-users] RETURNED MAIL: SEE TRANSCRIPT FOR DETAILS Date: Mon, 8 Oct 2007 16:40:59 -0500 Ray, =20 What are you sending me? =20 peace, clarkPSA: Salary <> Slavery. If you earn a salary, your employer is renting= your services for 40 hours a week, not purchasing your soul. Your time is = the only real finite asset that you have, and once used it can never be rec= overed, so don't waste it by giving it away. I work to live; I don't live t= o work. "Time is the coin of your life. It is the only coin you have, and o= nly you can determine how it will be spent. Be careful lest you let other p= eople spend it for you." -- Carl Sandburg (1878 - 1967) It is impossible to= defeat an ignorant man in argument. -- William G. McAdoo Religion is regar= ded by the common people as true, by the wise as false, and by the rulers a= s useful. -- Seneca "I distrust those people who know so well what God want= s them to do because I notice it always coincides with their own desires." = - Susan B. Anthony> From: rayo@ontko.com> To: sqr-users@sqrug.org> Date: Mo= n, 8 Oct 2007 23:20:21 +0200> Subject: [sqr-users] RETURNED MAIL: SEE TRANS= CRIPT FOR DETAILS> > The original message was received at Mon, 8 Oct 2007 2= 3:20:21 +0200 from 180.102.241.87> > ----- The following addresses had perm= anent fatal errors -----> sqr-users@sqrug.org> > >=20 _________________________________________________________________ Boo!=A0Scare away worms, viruses and so much more! Try Windows Live OneCare! http://onecare.live.com/standard/en-us/purchase/trial.aspx?s_cid=3Dwl_hotma= ilnews _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Oct 09 06:54:56 2007 From: "Steve Cavill" Subject: RE: [sqr-users] Challenging issue with Brio SQR in UNIX Date: Tue, 9 Oct 2007 20:51:25 +1000 Sounds like the inserts are not being committed. Running on Windows vs Unix implies a different driver, so it's possible one is doing some sort of autocommit. Try adding appropriate commit's to your code to see if that makes a difference. Steve. -----Original Message----- From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On Behalf Of maddy Sent: Friday, 5 October 2007 8:02 AM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: [sqr-users] Challenging issue with Brio SQR in UNIX Hi, We have a strange problem with all the Brio SQR Programs executing under UNIX environment.All these programs are working fine and giving data when executed in windows environment and giving no data in UNIX enviroment. We are creating a temp table and inserting data in the SQR program but unable to Select the data from the same table and print it on to the report.However when the ORDER BY clause in the select statement is commented out, data is pulled on to the report. If I run the same program again without droping and creating the table we get the data from the table even with ORDER BY clause which is strange. How can a ORDER BY clause in the SELECT statement cause this kind of issue ? I can send the skeleton program if any of the experts can look into this issue. Environment: Hyperion 8.5 installed on UNIX (AIX) Thanks, Maddy _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Tue Oct 09 11:22:39 2007 Date: Tue, 09 Oct 2007 11:19:10 -0400 From: "George Jansen" Subject: Re: [sqr-users] Challenging issue with Brio SQR in UNIX It strikes me that an ORDER BY clause means sorting, sorting means the use = of temporary space, and this could be limited. As for the location, are you using Oracle? With Oracle you could under some= circumstances be connecting through a shared server (sorting in the shared= pool) and in others connecting through a dedicated server. >>> maddy 10/4/2007 6:01 PM >>> Hi, We have a strange problem with all the Brio SQR Programs executing under UNIX environment.All these programs are working fine and giving data when executed in windows environment and giving no data in UNIX enviroment. We are creating a temp table and inserting data in the SQR program but unable to Select the data from the same table and print it on to the report.However when the ORDER BY clause in the select statement is commented out, data is pulled on to the report. If I run the same program again without droping and creating the table we get the data from the table even with ORDER BY clause which is strange. How can a ORDER BY clause in the SELECT statement cause this kind of issue ? I can send the skeleton program if any of the experts can look into this issue. Environment: Hyperion 8.5 installed on UNIX (AIX) Thanks, Maddy _______________________________________________ sqr-users mailing list sqr-users@sqrug.org=20 http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 11:11:09 2007 Date: Wed, 10 Oct 2007 20:38:17 +0530 From: Jiju Subject: [sqr-users] Peoplesoft multi-language issue Hi, I am extremely sorry to write in with a core Peoplesoft issue in this SQR group. But its extremely critical for me and I know the depth of PS understanding that SQRUG members possess. My issue is related multi language sessions in Peopletools 8.45. The Calendar prompts of date fields are not correctly populating. Clicking on any date field, starts the Calendar Load process and errors out saying that 'Calendar Cannot be loaded'. This issue is only present when accessing PIA in a non-Base language. Has anyone come across this issue? Any idea/suggestion would be of great help. Thanks, Jiju Cherian. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 12:53:12 2007 From: "Jean Myles" Date: Wed, 10 Oct 2007 12:50:18 -0400 Subject: [sqr-users] SQR Tecnical Documentation We are trying to locate a hard copy of the SQR Technical Documentation (mostly the language reference guide and designing reports with sqr developer) for the latest version of SQR. We can download the PDF's. but would like to know if a hard copy exists or if you would have any other documentation recommendations. Thanks in advance for the information. Jean Myles Information Management Specialist Fashion Institute of Technology P: 212-217-3440 F: 212-217-3452 E: jean_myles@fitnyc.edu _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 13:06:20 2007 From: "Joe" Subject: Re: [sqr-users] SQR Tecnical Documentation Date: Wed, 10 Oct 2007 11:03:17 -0600 Contact whoever it is that now owns SQR (Brio?). If they don't have them, just Kinko them. - jej1216 ----- Original Message ----- From: "Jean Myles" To: Sent: Wednesday, October 10, 2007 10:50 AM Subject: [sqr-users] SQR Tecnical Documentation > We are trying to locate a hard copy of the SQR Technical Documentation > (mostly the language reference guide and designing reports with sqr > developer) for the latest version of SQR. We can download the PDF's. but > would like to know if a hard copy exists or if you would have any other > documentation recommendations. > > > > Thanks in advance for the information. > > > > Jean Myles > > Information Management Specialist > > Fashion Institute of Technology > > P: 212-217-3440 > > F: 212-217-3452 > > E: jean_myles@fitnyc.edu > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 13:10:26 2007 From: the dragon Subject: RE: [sqr-users] SQR Tecnical Documentation Date: Wed, 10 Oct 2007 12:07:21 -0500 Contact Brio, Hyperion or whomever they are now... You may be able to oder= a set, or, since they are pdfs, you could print them out and bind them. =20 There are also a couple of books available through amazon that should be ab= le to help. =20 peace, clark 'the dragon' willisPSA: Salary <> Slavery. If you earn a salary, your= employer is renting your services for 40 hours a week, not purchasing your= soul. Your time is the only real finite asset that you have, and once used= it can never be recovered, so don't waste it by giving it away. I work to = live; I don't live to work. "Time is the coin of your life. It is the only = coin you have, and only you can determine how it will be spent. Be careful = lest you let other people spend it for you." -- Carl Sandburg (1878 - 1967)= It is impossible to defeat an ignorant man in argument. -- William G. McAd= oo Religion is regarded by the common people as true, by the wise as false,= and by the rulers as useful. -- Seneca "I distrust those people who know s= o well what God wants them to do because I notice it always coincides with = their own desires." - Susan B. Anthony> From: jean_myles@fitnyc.edu> To: sq= r-users@sqrug.org> Date: Wed, 10 Oct 2007 12:50:18 -0400> Subject: [sqr-use= rs] SQR Tecnical Documentation> > We are trying to locate a hard copy of th= e SQR Technical Documentation> (mostly the language reference guide and des= igning reports with sqr> developer) for the latest version of SQR. We can d= ownload the PDF's. but> would like to know if a hard copy exists or if you = would have any other> documentation recommendations.> > > > Thanks in advan= ce for the information.> > > > Jean Myles> > Information Management Special= ist> > Fashion Institute of Technology> > P: 212-217-3440> > F: 212-217-345= 2> > E: jean_myles@fitnyc.edu> > ___________= ____________________________________> sqr-users mailing list> sqr-users@sqr= ug.org> http://www.sqrug.org/mailman/listinfo/sqr-users _________________________________________________________________ Help yourself to FREE treats served up daily at the Messenger Caf=E9. Stop = by today. http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid=3DTXT_TAGLM_Oc= tWLtagline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 14:04:27 2007 Date: Wed, 10 Oct 2007 14:00:55 -0400 From: maddy Subject: Re: [sqr-users] Challenging issue with Brio SQR in UNIX This is a multi-part message in MIME format... ------=_Part_8186_10095497.1192039255300 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi, I have tried all the various things mentioned in the chain of emails but still have the same issue. The issue is with commit statement but not sure why it is not working with ORDER BY clause in the SELECT statement. Please take a look at the attached SQR program and the cursor information when compiled with -S flag. Thanks!! Maddy Environment : Hyperion 8.5.0.0.0.566/IBM RS6000/AIX 5.2/ODBC DataDirect 5.1 Database : Sybase 12.5 On 10/9/07, George Jansen wrote: > It strikes me that an ORDER BY clause means sorting, sorting means the use of temporary space, and this could be limited. > > As for the location, are you using Oracle? With Oracle you could under some circumstances be connecting through a shared server (sorting in the shared pool) and in others connecting through a dedicated server. > > >>> maddy 10/4/2007 6:01 PM >>> > Hi, > > We have a strange problem with all the Brio SQR Programs executing under > UNIX environment.All these programs are working fine and giving data when > executed in windows environment and giving no data in UNIX enviroment. > > We are creating a temp table and inserting data in the SQR program but > unable to Select the data from the same table and print it on to the > report.However when the ORDER BY clause in the select statement is commented > out, data is pulled on to the report. > > If I run the same program again without droping and creating the table we > get the data from the table even with ORDER BY clause which is strange. > How can a ORDER BY clause in the SELECT statement cause this kind of issue > ? I can send the skeleton program if any of the experts can look into this > issue. > > Environment: Hyperion 8.5 installed on UNIX (AIX) > > Thanks, > Maddy > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > ------=_Part_8186_10095497.1192039255300 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Description: AUTOMATIC WARNING Here was a non admissible message part of 'application/octet-stream' MIME type. It has been automatically discarded before sending the message to the list. ------=_Part_8186_10095497.1192039255300 Content-Type: text/plain; name="CID30_Cursor_Info.txt" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="CID30_Cursor_Info.txt"; filename="CID30_Cursor_Info.txt" X-Attachment-Id: f_f7m5ds4z Q3Vyc29yIFN0YXR1czoNCg0KIEN1cnNvciAjMToNCiAgIFNRTCA9IGNvbW1p dCB0cmFuc2FjdGlvbg0KIENvbXBpbGVzID0gMQ0KIEV4ZWN1dGVzID0gMQ0K IFJvd3MgICAgID0gMA0KDQogQ3Vyc29yICMyOg0KICAgU1FMID0gaWYgZXhp c3RzKHNlbGVjdCAxIGZyb20gc3lzb2JqZWN0cyB3aGVyZSBuYW1lID0nQ0lE MzBfSlAnYW5kDQogICAgICAgICB0eXBlPSdVJykgYmVnaW4gZHJvcCB0YWJs ZSBDSUQzMF9KUCBlbmQNCiBDb21waWxlcyA9IDENCiBFeGVjdXRlcyA9IDEN CiBSb3dzICAgICA9IDANCg0KIEN1cnNvciAjMzoNCiAgIFNRTCA9IGNyZWF0 ZSB0YWJsZSBDSUQzMF9KUCAoIEJMRUlfQklMTF9MRVZFTCAgICAgY2hhcigx KSAgbnVsbCwNCiAgICAgICAgIEJMRUlfTFNUX1RMX0RVRV9EVCAgZGF0ZXRp bWUgbnVsbCwgQkxFSV9MQVNUX0JJTExfRFRNICBkYXRldGltZQ0KICAgICAg ICAgbnVsbCwgQkxFSV9MU1RfQkxfRU5EX0RUICBkYXRldGltZSBudWxsLCBC TEVJX1NVU1BORF9CTF9JTkQNCiAgICAgICAgIGNoYXIoMSkgIG51bGwsIEdS R1JfSUQgICAgICAgICAgICAgY2hhcig4KSAgbnVsbCwgU0dTR19JRA0KICAg ICAgICAgICBjaGFyKDQpICBudWxsLCBTQlNCX0lEICAgICAgICAgICAgIGNo YXIoOSkgIG51bGwgKQ0KIENvbXBpbGVzID0gMQ0KIEV4ZWN1dGVzID0gMQ0K IFJvd3MgICAgID0gMA0KDQogQ3Vyc29yICM0Og0KICAgU1FMID0gY29tbWl0 IHRyYW5zYWN0aW9uDQogQ29tcGlsZXMgPSAxDQogRXhlY3V0ZXMgPSAxDQog Um93cyAgICAgPSAwDQoNCiBDdXJzb3IgIzU6DQogICBTUUwgPSB7Y2FsbCBS UFQuLkJFUlNQX0VWRU5UX1NURVBfSU5TRVJUKD8sPyw/LD8pfQ0KIENvbXBp bGVzID0gMA0KIEV4ZWN1dGVzID0gNA0KIFJvd3MgICAgID0gMA0KDQoNCiBD dXJzb3IgIzY6DQogICBTUUwgPSBpbnNlcnQgaW50byBDSUQzMF9KUCAoIEJM RUlfQklMTF9MRVZFTCwgQkxFSV9MU1RfVExfRFVFX0RULA0KICAgICAgICAg QkxFSV9MQVNUX0JJTExfRFRNLCBCTEVJX0xTVF9CTF9FTkRfRFQsIEJMRUlf U1VTUE5EX0JMX0lORCwNCiAgICAgICAgIEdSR1JfSUQsIFNHU0dfSUQsIFNC U0JfSUQgKSBzZWxlY3QgJ0knLCBCTEVJLkJMRUlfTFNUX1RMX0RVRV9EVCwN CiAgICAgICAgIEJMRUkuQkxFSV9MQVNUX0JJTExfRFRNLCBCTEVJLkJMRUlf TFNUX0JMX0VORF9EVCwNCiAgICAgICAgIEJMRUkuQkxFSV9TVVNQTkRfQkxf SU5ELCBHUkdSLkdSR1JfSUQsIG51bGwgLCBTQlNCLlNCU0JfSUQgZnJvbQ0K ICAgICAgICAgZmFkZnlpbjEuLkNNQ19CTEVJX0VOVFlfSU5GTyAgICAgIEJM RUksIGZhZGZ5aW4xLi5DTUNfR1JHUl9HUk9VUA0KICAgICAgICAgICAgICAg R1JHUiwgZmFkZnlpbjEuLkNNQ19TQlNCX1NVQlNDICAgICAgICAgIFNCU0Ig d2hlcmUNCiAgICAgICAgIEJMRUkuQkxFSV9CSUxMX0xFVkVMX0NLICA9ICAg U0JTQi5TQlNCX0NLIGFuZCBTQlNCLkdSR1JfQ0sNCiAgICAgICAgICAgID0g ICBHUkdSLkdSR1JfQ0sgYW5kIEJMRUkuQkxFSV9CSUxMX0xFVkVMICAgICA9 ICAgJ0knIGFuZA0KICAgICAgICAgQkxFSS5CTEVJX1NVU1BORF9CTF9JTkQg aW4gKCdCJywnRCcsJ1MnKSB1bmlvbiBzZWxlY3QgJ0cnLA0KICAgICAgICAg QkxFSS5CTEVJX0xTVF9UTF9EVUVfRFQsIEJMRUkuQkxFSV9MQVNUX0JJTExf RFRNLA0KICAgICAgICAgQkxFSS5CTEVJX0xTVF9CTF9FTkRfRFQsIEJMRUku QkxFSV9TVVNQTkRfQkxfSU5ELCBHUkdSLkdSR1JfSUQsDQogICAgICAgICBT R1NHLlNHU0dfSUQsIG51bGwgZnJvbSBmYWRmeWluMS4uQ01DX0JMRUlfRU5U WV9JTkZPICAgICAgQkxFSSwNCiAgICAgICAgIGZhZGZ5aW4xLi5DTUNfR1JH Ul9HUk9VUCAgICAgIEdSR1IsIGZhZGZ5aW4xLi5DTUNfU0dTR19TVUJfR1JP VVANCiAgICAgICAgIFNHU0cgd2hlcmUgQkxFSS5CTEVJX0JJTExfTEVWRUxf Q0sgPSAgIFNHU0cuU0dTR19DSyBhbmQNCiAgICAgICAgIFNHU0cuR1JHUl9D SyAgICAgICAgICAgID0gICBHUkdSLkdSR1JfQ0sgYW5kIEJMRUkuQkxFSV9C SUxMX0xFVkVMDQogICAgICAgICAgPSAgICdTJyBhbmQgQkxFSS5CTEVJX1NV U1BORF9CTF9JTkQgaW4gKCdCJywnRCcsJ1MnKSB1bmlvbiBzZWxlY3QNCiAg ICAgICAgICdHJywgQkxFSS5CTEVJX0xTVF9UTF9EVUVfRFQsIEJMRUkuQkxF SV9MQVNUX0JJTExfRFRNLA0KICAgICAgICAgQkxFSS5CTEVJX0xTVF9CTF9F TkRfRFQsIEJMRUkuQkxFSV9TVVNQTkRfQkxfSU5ELCBHUkdSLkdSR1JfSUQs DQogICAgICAgICBudWxsLCBudWxsIGZyb20gZmFkZnlpbjEuLkNNQ19CTEVJ X0VOVFlfSU5GTyAgICAgIEJMRUksDQogICAgICAgICBmYWRmeWluMS4uQ01D X0dSR1JfR1JPVVAgICAgICAgICAgR1JHUiB3aGVyZQ0KICAgICAgICAgQkxF SS5CTEVJX0JJTExfTEVWRUxfQ0sgPSAgIEdSR1IuR1JHUl9DSyBhbmQgQkxF SS5CTEVJX0JJTExfTEVWRUwNCiAgICAgICAgICA9ICAgJ0cnIGFuZCBCTEVJ LkJMRUlfU1VTUE5EX0JMX0lORCBpbiAoJ0InLCdEJywnUycpDQogQ29tcGls ZXMgPSAxDQogRXhlY3V0ZXMgPSAxDQogUm93cyAgICAgPSAzNTQNCg0KIEN1 cnNvciAjNzoNCiAgIFNRTCA9IFNFTEVDVCBCTFNVLkJMRUlfQklMTF9MRVZF TCwgQkxTVS5CTEVJX1NVU1BORF9CTF9JTkQsIEJMU1UuR1JHUl9JRCwNCiAg ICAgICAgIEJMU1UuU0dTR19JRCwgQkxTVS5TQlNCX0lELA0KICAgICAgICAg Y29udmVydChjaGFyKDEwKSxCTFNVLkJMRUlfTFNUX1RMX0RVRV9EVCwxMDEp LA0KICAgICAgICAgY29udmVydChjaGFyKDEwKSxCTFNVLkJMRUlfTEFTVF9C SUxMX0RUTSwxMDEpLA0KICAgICAgICAgY29udmVydChjaGFyKDEwKSxCTFNV LkJMRUlfTFNUX0JMX0VORF9EVCwxMDEpICBmcm9tIFJQVC4uQ0lEMzBfSlAN CiAgICAgICAgICAgQkxTVSBvcmRlciBieSBCTFNVLkJMRUlfQklMTF9MRVZF TCwgQkxTVS5CTEVJX1NVU1BORF9CTF9JTkQsDQogICAgICAgICBCTFNVLkdS R1JfSUQsIEJMU1UuU0dTR19JRCwgQkxTVS5TQlNCX0lEDQogQ29tcGlsZXMg PSAxDQogRXhlY3V0ZXMgPSAyDQogUm93cyAgICAgPSAzNTQNCg0KIEN1cnNv ciAjODoNCiAgIFNRTCA9IGRyb3AgdGFibGUgUlBULi5DSUQzMF9KUA0KIENv bXBpbGVzID0gMQ0KIEV4ZWN1dGVzID0gMQ0KIFJvd3MgICAgID0gMA0KDQoN ClNRUjogRW5kIG9mIFJ1bi4= ------=_Part_8186_10095497.1192039255300 Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ------=_Part_8186_10095497.1192039255300-- From sqr-users-bounces@sqrug.org Wed Oct 10 14:09:15 2007 Date: Wed, 10 Oct 2007 14:01:52 -0400 From: "Dee Lind" Subject: RE: [sqr-users] SQR Tecnical Documentation I think Oracle owns SQR - is that correct? Dee Lind Application Engineer ResCare, Inc. Ph: 502-394-2289 Fax: 502.394.2309 dlind@rescare.com CONFIDENTIALITY NOTICE: This email, including attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, or disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender immediately and destroy all copies of the original message. >>> the dragon 10/10/2007 1:07 PM >>> Contact Brio, Hyperion or whomever they are now... You may be able to oder a set, or, since they are pdfs, you could print them out and bind them. There are also a couple of books available through amazon that should be able to help. peace, clark 'the dragon' willisPSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. I work to live; I don't live to work. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." -- Carl Sandburg (1878 - 1967) It is impossible to defeat an ignorant man in argument. -- William G. McAdoo Religion is regarded by the common people as true, by the wise as false, and by the rulers as useful. -- Seneca "I distrust those people who know so well what God wants them to do because I notice it always coincides with their own desires." - Susan B. Anthony> From: jean_myles@fitnyc.edu> To: sqr-users@sqrug.org> Date: Wed, 10 Oct 2007 12:50:18 -0400> Subject: [sqr-users] SQR Tecnical Documentation> > We are trying to locate a hard copy of the SQR Technical Documentation> (mostly the language reference guide and designing reports with sqr> developer) for the latest version of SQR. We can download the PDF's. but> would like to know if a hard copy exists or if you would have any other> documentation recommendations.> > > > Thanks in advance for the information.> > > > Jean Myles> > Information Management Specialist> > Fashion Institute of Technology> > P: 212-217-3440> > F: 212-217-3452> > E: jean_myles@fitnyc.edu> > _______________________________________________> sqr-users mailing list> sqr-users@sqrug.org> http://www.sqrug.org/mailman/listinfo/sqr-users _________________________________________________________________ Help yourself to FREE treats served up daily at the Messenger Café. Stop by today. http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid=TXT_TAGLM_OctWLtagline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 14:12:38 2007 Subject: RE: [sqr-users] SQR Tecnical Documentation Date: Wed, 10 Oct 2007 14:04:41 -0400 From: Brio is now owned by Oracle. The last time a dug about the brio site, there was printed documentation manuals for sale, but that was about 3-4 years ago, prior to purchase by Oracle. FYI, Brio sqr started out as SQRIBE, by Sqribe Technologies where it was known as "SQR Server". That was when it was verion 4.x. It then was purchased by Brio Technology and renamed "Brio Report" It was version 6.x then and I believe also 7.x. Then Hyperion purchased it and tried to rename it something else, but users kept calling it "Brio" and SQR. About a year or so go Oracle bought it and re-instated the more familiar names. -Steve Jones=20=20 -----Original Message----- From: sqr-users-bounces+jones.steven=3Dups-scs.com@sqrug.org [mailto:sqr-users-bounces+jones.steven=3Dups-scs.com@sqrug.org] On Behalf Of Joe Sent: Wednesday, October 10, 2007 10:03 AM To: sqr-users@sqrug.org Subject: Re: [sqr-users] SQR Tecnical Documentation Contact whoever it is that now owns SQR (Brio?). If they don't have them, just Kinko them. - jej1216 ----- Original Message ----- From: "Jean Myles" To: Sent: Wednesday, October 10, 2007 10:50 AM Subject: [sqr-users] SQR Tecnical Documentation > We are trying to locate a hard copy of the SQR Technical Documentation > (mostly the language reference guide and designing reports with sqr > developer) for the latest version of SQR. We can download the PDF's.=20 > but would like to know if a hard copy exists or if you would have any=20 > other documentation recommendations. > > > > Thanks in advance for the information. > > > > Jean Myles > > Information Management Specialist > > Fashion Institute of Technology > > P: 212-217-3440 > > F: 212-217-3452 > > E: jean_myles@fitnyc.edu > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users >=20 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 14:18:34 2007 From: the dragon Subject: RE: [sqr-users] Challenging issue with Brio SQR in UNIX Date: Wed, 10 Oct 2007 13:15:25 -0500 The sqr failed to make it through, but the -s looks to me like it is workin= g correctly - 354 rows are inserted, and 354 are selected afterwards. I gu= ess my question is what makes you think it isn't working? =20 peace, clark 'the dragon' willisPSA: Salary <> Slavery. If you earn a salary, your= employer is renting your services for 40 hours a week, not purchasing your= soul. Your time is the only real finite asset that you have, and once used= it can never be recovered, so don't waste it by giving it away. I work to = live; I don't live to work. "Time is the coin of your life. It is the only = coin you have, and only you can determine how it will be spent. Be careful = lest you let other people spend it for you." -- Carl Sandburg (1878 - 1967)= It is impossible to defeat an ignorant man in argument. -- William G. McAd= oo Religion is regarded by the common people as true, by the wise as false,= and by the rulers as useful. -- Seneca "I distrust those people who know s= o well what God wants them to do because I notice it always coincides with = their own desires." - Susan B. Anthony> > Hi,> > I have tried all the vario= us things mentioned in the chain of emails> but still have the same issue. = The issue is with commit statement but> not sure why it is not working with= ORDER BY clause in the SELECT> statement.> > Please take a look at the att= ached SQR program and the cursor> information when compiled with -S flag.> = > > Thanks!!> Maddy> > > Environment : Hyperion 8.5.0.0.0.566/IBM RS6000/AI= X 5.2/ODBC DataDirect 5.1> Database : Sybase 12.5> > On 10/9/07, George Jan= sen wrote:> > It strikes me that an ORDER BY clause me= ans sorting, sorting means the use of temporary space, and this could be li= mited.> >> > As for the location, are you using Oracle? With Oracle you cou= ld under some circumstances be connecting through a shared server (sorting = in the shared pool) and in others connecting through a dedicated server.> >= > > >>> maddy 10/4/2007 6:01 PM >>>> > Hi,> >> > We ha= ve a strange problem with all the Brio SQR Programs executing under> > UNIX= environment.All these programs are working fine and giving data when> > ex= ecuted in windows environment and giving no data in UNIX enviroment.> >> > = We are creating a temp table and inserting data in the SQR program but> > u= nable to Select the data from the same table and print it on to the> > repo= rt.However when the ORDER BY clause in the select statement is commented> >= out, data is pulled on to the report.> >> > If I run the same program agai= n without droping and creating the table we> > get the data from the table = even with ORDER BY clause which is strange.> > How can a ORDER BY clause in= the SELECT statement cause this kind of issue> > ? I can send the skeleton= program if any of the experts can look into this> > issue.> >> > Environme= nt: Hyperion 8.5 installed on UNIX (AIX)> >> > Thanks,> > Maddy> > _________________________________________________________________ Help yourself to FREE treats served up daily at the Messenger Caf=E9. Stop = by today. http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid=3DTXT_TAGLM_Oc= tWLtagline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 14:22:15 2007 From: the dragon Subject: RE: [sqr-users] SQR Tecnical Documentation Date: Wed, 10 Oct 2007 13:17:54 -0500 Actually, I believe SQR started as a Sybase tool, then was owned by MITI (v= 2 and 3) which became SQRibe. =20 peace, clark 'the dragon' willisPSA: Salary <> Slavery. If you earn a salary, your= employer is renting your services for 40 hours a week, not purchasing your= soul. Your time is the only real finite asset that you have, and once used= it can never be recovered, so don't waste it by giving it away. I work to = live; I don't live to work. "Time is the coin of your life. It is the only = coin you have, and only you can determine how it will be spent. Be careful = lest you let other people spend it for you." -- Carl Sandburg (1878 - 1967)= It is impossible to defeat an ignorant man in argument. -- William G. McAd= oo Religion is regarded by the common people as true, by the wise as false,= and by the rulers as useful. -- Seneca "I distrust those people who know s= o well what God wants them to do because I notice it always coincides with = their own desires." - Susan B. Anthony> > Brio is now owned by Oracle. The = last time a dug about the brio site,> there was printed documentation manua= ls for sale, but that was about 3-4> years ago, prior to purchase by Oracle= .> > FYI, Brio sqr started out as SQRIBE, by Sqribe Technologies where it w= as> known as "SQR Server". That was when it was verion 4.x. It then was> pu= rchased by Brio Technology and renamed "Brio Report" It was version> 6.x th= en and I believe also 7.x. Then Hyperion purchased it and tried> to rename = it something else, but users kept calling it "Brio" and SQR.> About a year = or so go Oracle bought it and re-instated the more familiar> names.> -Steve= Jones > > -----Original Message-----> > Contact whoever it is that now own= s SQR (Brio?). If they don't have> them, just Kinko them.> > - jej1216> > -= ---- Original Message -----> From: "Jean Myles" > To= : > Sent: Wednesday, October 10, 2007 10:50 AM> Subjec= t: [sqr-users] SQR Tecnical Documentation> > > We are trying to locate a ha= rd copy of the SQR Technical Documentation> > > (mostly the language refere= nce guide and designing reports with sqr> > developer) for the latest versi= on of SQR. We can download the PDF's. > > but would like to know if a hard = copy exists or if you would have any > > other documentation recommendation= s.> >> >> >> > Thanks in advance for the information.> >> >> >> > Jean Myle= s> >> > Information Management Specialist> >> > Fashion Institute of Techno= logy> >> > P: 212-217-3440> >> > F: 212-217-3452> >> > E: jean_myles@fitnyc.edu> >> > _________________________________= ______________> > sqr-users mailing list> > sqr-users@sqrug.org> > http://w= ww.sqrug.org/mailman/listinfo/sqr-users> > > > ____________________________= ___________________> sqr-users mailing list> sqr-users@sqrug.org> http://ww= w.sqrug.org/mailman/listinfo/sqr-users> > > > _____________________________= __________________> sqr-users mailing list> sqr-users@sqrug.org> http://www= .sqrug.org/mailman/listinfo/sqr-users _________________________________________________________________ Peek-a-boo FREE Tricks & Treats for You! http://www.reallivemoms.com?ocid=3DTXT_TAGHM&loc=3Dus _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 14:27:38 2007 Subject: RE: [sqr-users] SQR Tecnical Documentation Date: Wed, 10 Oct 2007 14:23:44 -0400 From: You go back farther than I. thx=20 -----Original Message----- From: sqr-users-bounces+jones.steven=3Dups-scs.com@sqrug.org [mailto:sqr-users-bounces+jones.steven=3Dups-scs.com@sqrug.org] On Behalf Of the dragon Sent: Wednesday, October 10, 2007 11:18 AM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: RE: [sqr-users] SQR Tecnical Documentation Actually, I believe SQR started as a Sybase tool, then was owned by MITI (v2 and 3) which became SQRibe. =20 peace, clark 'the dragon' willisPSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. I work to live; I don't live to work. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." -- Carl Sandburg (1878 - 1967) It is impossible to defeat an ignorant man in argument. -- William G. McAdoo Religion is regarded by the common people as true, by the wise as false, and by the rulers as useful. -- Seneca "I distrust those people who know so well what God wants them to do because I notice it always coincides with their own desires." - Susan B. Anthony> > Brio is now owned by Oracle. The last time a dug about the brio site,> there was printed documentation manuals for sale, but that was about 3-4> years ago, prior to purchase by Oracle.> > FYI, Brio sqr started out as SQRIBE, by Sqribe Technologies where it was> known as "SQR Server". That was when it was verion 4.x. It then was> purchased by Brio Technology and renamed "Brio Report" It was version> 6.x then and I believe also 7.x. Then Hyperion purchased it and tried> to rename it something else, but users kept calling it "Brio" and SQR.> About a year or so go Oracle bought it and re-instated the more familiar> names.> -Steve Jones > > -----Original Message-----> > Contact whoever it is that now owns SQR (Brio?). If they don't have> them, just Kinko them.> > - jej1216> > ----- Original Message -----> From: "Jean Myles" > To: > Sent: Wednesday, October 10, 2007 10:50 AM> Subject: [sqr-users] SQR Tecnical Documentation> > > We are trying to locate a hard copy of the SQR Technical Documentation> > > (mostly the language reference guide and designing reports with sqr> > developer) for the latest version of SQR. We can download the PDF's. > > but would like to know if a hard copy exists or if you would have any > > other documentation recommendations.> >> >> >> > Thanks in advance for the information.> >> >> >> > Jean Myles> >> > Information Management Specialist> >> > Fashion Institute of Technology> >> > P: 212-217-3440> >> > F: 212-217-3452> >> > E: jean_myles@fitnyc.edu> >> > _______________________________________________> > sqr-users mailing list> > sqr-users@sqrug.org> > http://www.sqrug.org/mailman/listinfo/sqr-users> > > > _______________________________________________> sqr-users mailing list> sqr-users@sqrug.org> http://www.sqrug.org/mailman/listinfo/sqr-users> > > > _______________________________________________> sqr-users mailing list> sqr-users@sqrug.org> http://www.sqrug.org/mailman/listinfo/sqr-users _________________________________________________________________ Peek-a-boo FREE Tricks & Treats for You! http://www.reallivemoms.com?ocid=3DTXT_TAGHM&loc=3Dus _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 14:31:35 2007 Subject: RE: [sqr-users] SQR Tecnical Documentation Date: Wed, 10 Oct 2007 14:28:43 -0400 From: "Wes Williams" Written by a guy Israel Stern...right?=20 Wes Williams Manager Facilities Mgt. Systems Princeton University 609-258-7027 609-468-6344 -----Original Message----- From: sqr-users-bounces+wes=3Dprinceton.edu@sqrug.org [mailto:sqr-users-bounces+wes=3Dprinceton.edu@sqrug.org] On Behalf Of Jones.Steven@ups-scs.com Sent: Wednesday, October 10, 2007 2:24 PM To: sqr-users@sqrug.org Subject: RE: [sqr-users] SQR Tecnical Documentation You go back farther than I. thx=20 -----Original Message----- From: sqr-users-bounces+jones.steven=3Dups-scs.com@sqrug.org [mailto:sqr-users-bounces+jones.steven=3Dups-scs.com@sqrug.org] On Behalf Of the dragon Sent: Wednesday, October 10, 2007 11:18 AM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: RE: [sqr-users] SQR Tecnical Documentation Actually, I believe SQR started as a Sybase tool, then was owned by MITI (v2 and 3) which became SQRibe. =20 peace, clark 'the dragon' willisPSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. I work to live; I don't live to work. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." -- Carl Sandburg (1878 - 1967) It is impossible to defeat an ignorant man in argument. -- William G. McAdoo Religion is regarded by the common people as true, by the wise as false, and by the rulers as useful. -- Seneca "I distrust those people who know so well what God wants them to do because I notice it always coincides with their own desires." - Susan B. Anthony> > Brio is now owned by Oracle. The last time a dug about the brio site,> there was printed documentation manuals for sale, but that was about 3-4> years ago, prior to purchase by Oracle.> > FYI, Brio sqr started out as SQRIBE, by Sqribe Technologies where it was> known as "SQR Server". That was when it was verion 4.x. It then was> purchased by Brio Technology and renamed "Brio Report" It was version> 6.x then and I believe also 7.x. Then Hyperion purchased it and tried> to rename it something else, but users kept calling it "Brio" and SQR.> About a year or so go Oracle bought it and re-instated the more familiar> names.> -Steve Jones > > -----Original Message-----> > Contact whoever it is that now owns SQR (Brio?). If they don't have> them, just Kinko them.> > - jej1216> > ----- Original Message -----> From: "Jean Myles" > To: > Sent: Wednesday, October 10, 2007 10:50 AM> Subject: [sqr-users] SQR Tecnical Documentation> > > We are trying to locate a hard copy of the SQR Technical Documentation> > > (mostly the language reference guide and designing reports with sqr> > developer) for the latest version of SQR. We can download the PDF's. > > but would like to know if a hard copy exists or if you would have any > > other documentation recommendations.> >> >> >> > Thanks in advance for the information.> >> >> >> > Jean Myles> >> > Information Management Specialist> >> > Fashion Institute of Technology> >> > P: 212-217-3440> >> > F: 212-217-3452> >> > E: jean_myles@fitnyc.edu> >> > _______________________________________________> > sqr-users mailing list> > sqr-users@sqrug.org> > http://www.sqrug.org/mailman/listinfo/sqr-users> > > > _______________________________________________> sqr-users mailing list> sqr-users@sqrug.org> http://www.sqrug.org/mailman/listinfo/sqr-users> > > > _______________________________________________> sqr-users mailing list> sqr-users@sqrug.org> http://www.sqrug.org/mailman/listinfo/sqr-users _________________________________________________________________ Peek-a-boo FREE Tricks & Treats for You! http://www.reallivemoms.com?ocid=3DTXT_TAGHM&loc=3Dus _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 14:38:41 2007 From: "Alexander, Steven" Subject: RE: [sqr-users] SQR Tecnical Documentation Date: Wed, 10 Oct 2007 11:35:49 -0700 We should add this history to the Wikipedia article about SQR. -----Original Message----- From: sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org [mailto:sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org] On Behalf Of Wes Williams Sent: Wednesday, October 10, 2007 11:29 AM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: RE: [sqr-users] SQR Tecnical Documentation Written by a guy Israel Stern...right? Wes Williams Manager Facilities Mgt. Systems Princeton University 609-258-7027 609-468-6344 -----Original Message----- From: sqr-users-bounces+wes=princeton.edu@sqrug.org [mailto:sqr-users-bounces+wes=princeton.edu@sqrug.org] On Behalf Of Jones.Steven@ups-scs.com Sent: Wednesday, October 10, 2007 2:24 PM To: sqr-users@sqrug.org Subject: RE: [sqr-users] SQR Tecnical Documentation You go back farther than I. thx -----Original Message----- From: sqr-users-bounces+jones.steven=ups-scs.com@sqrug.org [mailto:sqr-users-bounces+jones.steven=ups-scs.com@sqrug.org] On Behalf Of the dragon Sent: Wednesday, October 10, 2007 11:18 AM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: RE: [sqr-users] SQR Tecnical Documentation Actually, I believe SQR started as a Sybase tool, then was owned by MITI (v2 and 3) which became SQRibe. peace, clark 'the dragon' willisPSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. I work to live; I don't live to work. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." -- Carl Sandburg (1878 - 1967) It is impossible to defeat an ignorant man in argument. -- William G. McAdoo Religion is regarded by the common people as true, by the wise as false, and by the rulers as useful. -- Seneca "I distrust those people who know so well what God wants them to do because I notice it always coincides with their own desires." - Susan B. Anthony> > Brio is now owned by Oracle. The last time a dug about the brio site,> there was printed documentation manuals for sale, but that was about 3-4> years ago, prior to purchase by Oracle.> > FYI, Brio sqr started out as SQRIBE, by Sqribe Technologies where it was> known as "SQR Server". That was when it was verion 4.x. It then was> purchased by Brio Technology and renamed "Brio Report" It was version> 6.x then and I believe also 7.x. Then Hyperion purchased it and tried> to rename it something else, but users kept calling it "Brio" and SQR.> About a year or so go Oracle bought it and re-instated the more familiar> names.> -Steve Jones > > -----Original Message-----> > Contact whoever it is that now owns SQR (Brio?). If they don't have> them, just Kinko them.> > - jej1216> > ----- Original Message -----> From: "Jean Myles" > To: > Sent: Wednesday, October 10, 2007 10:50 AM> Subject: [sqr-users] SQR Tecnical Documentation> > > We are trying to locate a hard copy of the SQR Technical Documentation> > > (mostly the language reference guide and designing reports with sqr> > developer) for the latest version of SQR. We can download the PDF's. > > but would like to know if a hard copy exists or if you would have any > > other documentation recommendations.> >> >> >> > Thanks in advance for the information.> >> >> >> > Jean Myles> >> > Information Management Specialist> >> > Fashion Institute of Technology> >> > P: 212-217-3440> >> > F: 212-217-3452> >> > E: jean_myles@fitnyc.edu> >> > _______________________________________________> > sqr-users mailing list> > sqr-users@sqrug.org> > http://www.sqrug.org/mailman/listinfo/sqr-users> > > > _______________________________________________> sqr-users mailing list> sqr-users@sqrug.org> http://www.sqrug.org/mailman/listinfo/sqr-users> > > > _______________________________________________> sqr-users mailing list> sqr-users@sqrug.org> http://www.sqrug.org/mailman/listinfo/sqr-users _________________________________________________________________ Peek-a-boo FREE Tricks & Treats for You! http://www.reallivemoms.com?ocid=TXT_TAGHM&loc=us _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 14:47:21 2007 Date: Wed, 10 Oct 2007 14:44:20 -0400 From: maddy Subject: Re: [sqr-users] Challenging issue with Brio SQR in UNIX This is a multi-part message in MIME format... ------=_Part_8301_4897302.1192041860710 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi dragon, Thanks for your quick response.By mistake I had sent you the wrong file with Cursor information. Please take a look at the new file attached. Thanks, Maddy On 10/10/07, the dragon wrote: > The sqr failed to make it through, but the -s looks to me like it is work= ing > correctly - 354 rows are inserted, and 354 are selected afterwards. I gu= ess > my question is what makes you think it isn't working? > > peace, > clark 'the dragon' willis > > PSA: Salary <> Slavery. If you earn a salary, your employer is renting yo= ur > services for 40 hours a week, not purchasing your soul. Your time is the > only real finite asset that you have, and once used it can never be > recovered, so don't waste it by giving it away. > > I work to live; I don't live to work. > > "Time is the coin of your life. It is the only coin you have, and only you > can determine how it will be spent. Be careful lest you let other people > spend it for you." -- Carl Sandburg (1878 - 1967) > > It is impossible to defeat an ignorant man in argument. -- William G. McA= doo > > Religion is regarded by the common people as true, by the wise as false, = and > by the rulers as useful. -- Seneca > > "I distrust those people who know so well what God wants them to do becau= se > I notice it always coincides with their own desires." - Susan B. Anthony > > > > > Hi, > > > > I have tried all the various things mentioned in the chain of emails > > but still have the same issue. The issue is with commit statement but > > not sure why it is not working with ORDER BY clause in the SELECT > > statement. > > > > Please take a look at the attached SQR program and the cursor > > information when compiled with -S flag. > > > > > > Thanks!! > > Maddy > > > > > > Environment : Hyperion 8.5.0.0.0.566/IBM RS6000/AIX 5.2/ODBC DataDirect > 5.1 > > Database : Sybase 12.5 > > > > On 10/9/07, George Jansen wrote: > > > It strikes me that an ORDER BY clause means sorting, sorting means the > use of temporary space, and this could be limited. > > > > > > As for the location, are you using Oracle? With Oracle you could under > some circumstances be connecting through a shared server (sorting in the > shared pool) and in others connecting through a dedicated server. > > > > > > >>> maddy 10/4/2007 6:01 PM >>> > > > Hi, > > > > > > We have a strange problem with all the Brio SQR Programs executing un= der > > > UNIX environment.All these programs are working fine and giving data > when > > > executed in windows environment and giving no data in UNIX enviroment. > > > > > > We are creating a temp table and inserting data in the SQR program but > > > unable to Select the data from the same table and print it on to the > > > report.However when the ORDER BY clause in the select statement is > commented > > > out, data is pulled on to the report. > > > > > > If I run the same program again without droping and creating the table > we > > > get the data from the table even with ORDER BY clause which is strang= e. > > > How can a ORDER BY clause in the SELECT statement cause this kind of > issue > > > ? I can send the skeleton program if any of the experts can look into > this > > > issue. > > > > > > Environment: Hyperion 8.5 installed on UNIX (AIX) > > > > > > Thanks, > > > Maddy > > > > > > ________________________________ > Help yourself to FREE treats served up daily at the Messenger Caf=E9. Sto= p by > today! ------=_Part_8301_4897302.1192041860710 Content-Type: text/plain; name="CID30_Cursor_Info.txt" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="CID30_Cursor_Info.txt"; filename="CID30_Cursor_Info.txt"; filename="CID30_Cursor_Info.txt" X-Attachment-Id: f_f7m6wkhn Q3Vyc29yIFN0YXR1czoNCg0KIEN1cnNvciAjMToNCiAgIFNRTCA9IGNvbW1p dCB0cmFuc2FjdGlvbg0KIENvbXBpbGVzID0gMQ0KIEV4ZWN1dGVzID0gMQ0K IFJvd3MgICAgID0gMA0KDQogQ3Vyc29yICMyOg0KICAgU1FMID0gaWYgZXhp c3RzKHNlbGVjdCAxIGZyb20gc3lzb2JqZWN0cyB3aGVyZSBuYW1lID0nQ0lE MzBfSlAnYW5kDQogICAgICAgICB0eXBlPSdVJykgYmVnaW4gZHJvcCB0YWJs ZSBDSUQzMF9KUCBlbmQNCiBDb21waWxlcyA9IDENCiBFeGVjdXRlcyA9IDEN CiBSb3dzICAgICA9IDANCg0KIEN1cnNvciAjMzoNCiAgIFNRTCA9IGNyZWF0 ZSB0YWJsZSBDSUQzMF9KUCAoIEJMRUlfQklMTF9MRVZFTCAgICAgY2hhcigx KSAgbnVsbCwNCiAgICAgICAgIEJMRUlfTFNUX1RMX0RVRV9EVCAgZGF0ZXRp bWUgbnVsbCwgQkxFSV9MQVNUX0JJTExfRFRNICBkYXRldGltZQ0KICAgICAg ICAgbnVsbCwgQkxFSV9MU1RfQkxfRU5EX0RUICBkYXRldGltZSBudWxsLCBC TEVJX1NVU1BORF9CTF9JTkQNCiAgICAgICAgIGNoYXIoMSkgIG51bGwsIEdS R1JfSUQgICAgICAgICAgICAgY2hhcig4KSAgbnVsbCwgU0dTR19JRA0KICAg ICAgICAgICBjaGFyKDQpICBudWxsLCBTQlNCX0lEICAgICAgICAgICAgIGNo YXIoOSkgIG51bGwgKQ0KIENvbXBpbGVzID0gMQ0KIEV4ZWN1dGVzID0gMQ0K IFJvd3MgICAgID0gMA0KDQogQ3Vyc29yICM0Og0KICAgU1FMID0gY29tbWl0 IHRyYW5zYWN0aW9uDQogQ29tcGlsZXMgPSAxDQogRXhlY3V0ZXMgPSAxDQog Um93cyAgICAgPSAwDQoNCiBDdXJzb3IgIzU6DQogICBTUUwgPSB7Y2FsbCBS UFQuLkJFUlNQX0VWRU5UX1NURVBfSU5TRVJUKD8sPyw/LD8pfQ0KIENvbXBp bGVzID0gMA0KIEV4ZWN1dGVzID0gNA0KIFJvd3MgICAgID0gMA0KDQoNCiBD dXJzb3IgIzY6DQogICBTUUwgPSBpbnNlcnQgaW50byBDSUQzMF9KUCAoIEJM RUlfQklMTF9MRVZFTCwgQkxFSV9MU1RfVExfRFVFX0RULA0KICAgICAgICAg QkxFSV9MQVNUX0JJTExfRFRNLCBCTEVJX0xTVF9CTF9FTkRfRFQsIEJMRUlf U1VTUE5EX0JMX0lORCwNCiAgICAgICAgIEdSR1JfSUQsIFNHU0dfSUQsIFNC U0JfSUQgKSBzZWxlY3QgJ0knLCBCTEVJLkJMRUlfTFNUX1RMX0RVRV9EVCwN CiAgICAgICAgIEJMRUkuQkxFSV9MQVNUX0JJTExfRFRNLCBCTEVJLkJMRUlf TFNUX0JMX0VORF9EVCwNCiAgICAgICAgIEJMRUkuQkxFSV9TVVNQTkRfQkxf SU5ELCBHUkdSLkdSR1JfSUQsIG51bGwgLCBTQlNCLlNCU0JfSUQgZnJvbQ0K ICAgICAgICAgZmFkZnlpbjEuLkNNQ19CTEVJX0VOVFlfSU5GTyAgICAgIEJM RUksIGZhZGZ5aW4xLi5DTUNfR1JHUl9HUk9VUA0KICAgICAgICAgICAgICAg R1JHUiwgZmFkZnlpbjEuLkNNQ19TQlNCX1NVQlNDICAgICAgICAgIFNCU0Ig d2hlcmUNCiAgICAgICAgIEJMRUkuQkxFSV9CSUxMX0xFVkVMX0NLICA9ICAg U0JTQi5TQlNCX0NLIGFuZCBTQlNCLkdSR1JfQ0sNCiAgICAgICAgICAgID0g ICBHUkdSLkdSR1JfQ0sgYW5kIEJMRUkuQkxFSV9CSUxMX0xFVkVMICAgICA9 ICAgJ0knIGFuZA0KICAgICAgICAgQkxFSS5CTEVJX1NVU1BORF9CTF9JTkQg aW4gKCdCJywnRCcsJ1MnKSB1bmlvbiBzZWxlY3QgJ0cnLA0KICAgICAgICAg QkxFSS5CTEVJX0xTVF9UTF9EVUVfRFQsIEJMRUkuQkxFSV9MQVNUX0JJTExf RFRNLA0KICAgICAgICAgQkxFSS5CTEVJX0xTVF9CTF9FTkRfRFQsIEJMRUku QkxFSV9TVVNQTkRfQkxfSU5ELCBHUkdSLkdSR1JfSUQsDQogICAgICAgICBT R1NHLlNHU0dfSUQsIG51bGwgZnJvbSBmYWRmeWluMS4uQ01DX0JMRUlfRU5U WV9JTkZPICAgICAgQkxFSSwNCiAgICAgICAgIGZhZGZ5aW4xLi5DTUNfR1JH Ul9HUk9VUCAgICAgIEdSR1IsIGZhZGZ5aW4xLi5DTUNfU0dTR19TVUJfR1JP VVANCiAgICAgICAgIFNHU0cgd2hlcmUgQkxFSS5CTEVJX0JJTExfTEVWRUxf Q0sgPSAgIFNHU0cuU0dTR19DSyBhbmQNCiAgICAgICAgIFNHU0cuR1JHUl9D SyAgICAgICAgICAgID0gICBHUkdSLkdSR1JfQ0sgYW5kIEJMRUkuQkxFSV9C SUxMX0xFVkVMDQogICAgICAgICAgPSAgICdTJyBhbmQgQkxFSS5CTEVJX1NV U1BORF9CTF9JTkQgaW4gKCdCJywnRCcsJ1MnKSB1bmlvbiBzZWxlY3QNCiAg ICAgICAgICdHJywgQkxFSS5CTEVJX0xTVF9UTF9EVUVfRFQsIEJMRUkuQkxF SV9MQVNUX0JJTExfRFRNLA0KICAgICAgICAgQkxFSS5CTEVJX0xTVF9CTF9F TkRfRFQsIEJMRUkuQkxFSV9TVVNQTkRfQkxfSU5ELCBHUkdSLkdSR1JfSUQs DQogICAgICAgICBudWxsLCBudWxsIGZyb20gZmFkZnlpbjEuLkNNQ19CTEVJ X0VOVFlfSU5GTyAgICAgIEJMRUksDQogICAgICAgICBmYWRmeWluMS4uQ01D X0dSR1JfR1JPVVAgICAgICAgICAgR1JHUiB3aGVyZQ0KICAgICAgICAgQkxF SS5CTEVJX0JJTExfTEVWRUxfQ0sgPSAgIEdSR1IuR1JHUl9DSyBhbmQgQkxF SS5CTEVJX0JJTExfTEVWRUwNCiAgICAgICAgICA9ICAgJ0cnIGFuZCBCTEVJ LkJMRUlfU1VTUE5EX0JMX0lORCBpbiAoJ0InLCdEJywnUycpDQogQ29tcGls ZXMgPSAxDQogRXhlY3V0ZXMgPSAxDQogUm93cyAgICAgPSAzNTQNCg0KIEN1 cnNvciAjNzoNCiAgIFNRTCA9IFNFTEVDVCBCTFNVLkJMRUlfQklMTF9MRVZF TCwgQkxTVS5CTEVJX1NVU1BORF9CTF9JTkQsIEJMU1UuR1JHUl9JRCwNCiAg ICAgICAgIEJMU1UuU0dTR19JRCwgQkxTVS5TQlNCX0lELA0KICAgICAgICAg Y29udmVydChjaGFyKDEwKSxCTFNVLkJMRUlfTFNUX1RMX0RVRV9EVCwxMDEp LA0KICAgICAgICAgY29udmVydChjaGFyKDEwKSxCTFNVLkJMRUlfTEFTVF9C SUxMX0RUTSwxMDEpLA0KICAgICAgICAgY29udmVydChjaGFyKDEwKSxCTFNV LkJMRUlfTFNUX0JMX0VORF9EVCwxMDEpICBmcm9tIFJQVC4uQ0lEMzBfSlAN CiAgICAgICAgICAgQkxTVSBvcmRlciBieSBCTFNVLkJMRUlfQklMTF9MRVZF TCwgQkxTVS5CTEVJX1NVU1BORF9CTF9JTkQsDQogICAgICAgICBCTFNVLkdS R1JfSUQsIEJMU1UuU0dTR19JRCwgQkxTVS5TQlNCX0lEDQogQ29tcGlsZXMg PSAxDQogRXhlY3V0ZXMgPSAxDQogUm93cyAgICAgPSAwDQoNCiBDdXJzb3Ig Izg6DQogICBTUUwgPSBkcm9wIHRhYmxlIFJQVC4uQ0lEMzBfSlANCiBDb21w aWxlcyA9IDENCiBFeGVjdXRlcyA9IDENCiBSb3dzICAgICA9IDANCg0KDQpT UVI6IEVuZCBvZiBSdW4u ------=_Part_8301_4897302.1192041860710 Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users ------=_Part_8301_4897302.1192041860710-- From sqr-users-bounces@sqrug.org Wed Oct 10 15:20:11 2007 From: the dragon Subject: RE: [sqr-users] SQR Tecnical Documentation Date: Wed, 10 Oct 2007 14:17:15 -0500 I'd love to do that - it would be the first time I have something that I kn= ow enough that I could add that isn't there already... =20 peace, clark 'the dragon' willisPSA: Salary <> Slavery. If you earn a salary, your= employer is renting your services for 40 hours a week, not purchasing your= soul. Your time is the only real finite asset that you have, and once used= it can never be recovered, so don't waste it by giving it away. I work to = live; I don't live to work. "Time is the coin of your life. It is the only = coin you have, and only you can determine how it will be spent. Be careful = lest you let other people spend it for you." -- Carl Sandburg (1878 - 1967)= It is impossible to defeat an ignorant man in argument. -- William G. McAd= oo Religion is regarded by the common people as true, by the wise as false,= and by the rulers as useful. -- Seneca "I distrust those people who know s= o well what God wants them to do because I notice it always coincides with = their own desires." - Susan B. Anthony> > We should add this history to the= Wikipedia article about SQR.> > -----Original Message-----> > Written by a= guy Israel Stern...right? > > Wes Williams> Manager Facilities Mgt. System= s> Princeton University> 609-258-7027> 609-468-6344> > -----Original Messag= e-----> > You go back farther than I. thx > > -----Original Message-----> >= > Actually, I believe SQR started as a Sybase tool, then was owned by MITI= > (v2 and 3) which became SQRibe.> > peace,> clark 'the dragon'=20 _________________________________________________________________ Windows Live Hotmail and Microsoft Office Outlook =96 together at last. =A0= Get it now. http://office.microsoft.com/en-us/outlook/HA102225181033.aspx?pid=3DCL10062= 6971033 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 15:41:09 2007 From: franck.masson2002@laposte.net Subject: Re: [sqr-users] Challenging issue with Brio SQR in UNIX Date: Wed, 10 Oct 2007 21:37:56 +0200 (CEST) what happen if you add a commit statement after the Insert and before the s= elect statement ? > Message du 10/10/07 20:47 > De : "maddy"=20 > A : "the dragon"=20 > Copie =C3=A0 : "This list is for discussion about the SQR database report= ing language from Hyperion Solutions."=20 > Objet : Re: [sqr-users] Challenging issue with Brio SQR in UNIX > > Hi dragon, >=20 > Thanks for your quick response.By mistake I had sent you the wrong > file with Cursor information. Please take a look at the new file > attached. >=20 >=20 > Thanks, > Maddy >=20 >=20 >=20 > On 10/10/07, the dragon wrote: > > The sqr failed to make it through, but the -s looks to me like it is wo= rking > > correctly - 354 rows are inserted, and 354 are selected afterwards. I g= uess > > my question is what makes you think it isn't working? > > > > peace, > > clark 'the dragon' willis > > > > PSA: Salary <> Slavery. If you earn a salary, your employer is renting = your > > services for 40 hours a week, not purchasing your soul. Your time is the > > only real finite asset that you have, and once used it can never be > > recovered, so don't waste it by giving it away. > > > > I work to live; I don't live to work. > > > > "Time is the coin of your life. It is the only coin you have, and only = you > > can determine how it will be spent. Be careful lest you let other people > > spend it for you." -- Carl Sandburg (1878 - 1967) > > > > It is impossible to defeat an ignorant man in argument. -- William G. M= cAdoo > > > > Religion is regarded by the common people as true, by the wise as false= , and > > by the rulers as useful. -- Seneca > > > > "I distrust those people who know so well what God wants them to do bec= ause > > I notice it always coincides with their own desires." - Susan B. Anthony > > > > > > > > Hi, > > > > > > I have tried all the various things mentioned in the chain of emails > > > but still have the same issue. The issue is with commit statement but > > > not sure why it is not working with ORDER BY clause in the SELECT > > > statement. > > > > > > Please take a look at the attached SQR program and the cursor > > > information when compiled with -S flag. > > > > > > > > > Thanks!! > > > Maddy > > > > > > > > > Environment : Hyperion 8.5.0.0.0.566/IBM RS6000/AIX 5.2/ODBC DataDire= ct > > 5.1 > > > Database : Sybase 12.5 > > > > > > On 10/9/07, George Jansen wrote: > > > > It strikes me that an ORDER BY clause means sorting, sorting means = the > > use of temporary space, and this could be limited. > > > > > > > > As for the location, are you using Oracle? With Oracle you could un= der > > some circumstances be connecting through a shared server (sorting in the > > shared pool) and in others connecting through a dedicated server. > > > > > > > > >>> maddy 10/4/2007 6:01 PM >>> > > > > Hi, > > > > > > > > We have a strange problem with all the Brio SQR Programs executing = under > > > > UNIX environment.All these programs are working fine and giving data > > when > > > > executed in windows environment and giving no data in UNIX envirome= nt. > > > > > > > > We are creating a temp table and inserting data in the SQR program = but > > > > unable to Select the data from the same table and print it on to the > > > > report.However when the ORDER BY clause in the select statement is > > commented > > > > out, data is pulled on to the report. > > > > > > > > If I run the same program again without droping and creating the ta= ble > > we > > > > get the data from the table even with ORDER BY clause which is stra= nge. > > > > How can a ORDER BY clause in the SELECT statement cause this kind of > > issue > > > > ? I can send the skeleton program if any of the experts can look in= to > > this > > > > issue. > > > > > > > > Environment: Hyperion 8.5 installed on UNIX (AIX) > > > > > > > > Thanks, > > > > Maddy > > > > > > > > > > ________________________________ > > Help yourself to FREE treats served up daily at the Messenger Caf=C3=A9= . Stop by > > today! > > > [ CID30_Cursor_Info.txt (4.3 Ko) ] > [ (pas de nom de fichier) (0.1 Ko) ] Cr=C3=A9ez votre adresse =C3=A9lectronique pr=C3=A9nom.nom@laposte.net 1 Go d'espace de stockage, anti-spam et anti-virus int=C3=A9gr=C3=A9s. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 16:59:39 2007 Date: Wed, 10 Oct 2007 15:51:11 -0500 From: "Leonard, Kyle" Subject: [sqr-users] SQRP v9.3 return code of 3 Can anyone point me to a list of what the various command line return values mean? =20 We are issuing a CALL command to run SQRP and it is failing. Debugging efforts have failed. Our last clue is the return value of '3' =20 Thanks Kyle =20 The information contained in this message and any attachments is intended o= nly for the use of the individual or entity to which it is addressed, and m= ay contain information that is PRIVILEGED, CONFIDENTIAL, and exempt from di= sclosure under applicable law. If you are not the intended recipient, you = are prohibited from copying, distributing, or using the information. Pleas= e contact the sender immediately by return e-mail and delete the original m= essage from your system. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 17:05:38 2007 From: "Peter Burton" Subject: RE: [sqr-users] SQR Tecnical Documentation Date: Wed, 10 Oct 2007 16:58:24 -0400 Incorrect, SQR was originally written as a replacement for Oracle RPT and = RPF tools many, many, years ago.=20 Peter -----Original Message----- From: sqr-users-bounces+peter.burton=3Doracle.com@sqrug.org [mailto:sqr-use= rs-bounces+peter.burton=3Doracle.com@sqrug.org] On Behalf Of the dragon Sent: Wednesday, October 10, 2007 2:18 PM To: This list is for discussion about the SQR database reporting language f= rom Hyperion Solutions. Subject: RE: [sqr-users] SQR Tecnical Documentation Actually, I believe SQR started as a Sybase tool, then was owned by MITI (v= 2 and 3) which became SQRibe. =20 peace, clark 'the dragon' willisPSA: Salary <> Slavery. If you earn a salary, your= employer is renting your services for 40 hours a week, not purchasing your= soul. Your time is the only real finite asset that you have, and once used= it can never be recovered, so don't waste it by giving it away. I work to = live; I don't live to work. "Time is the coin of your life. It is the only = coin you have, and only you can determine how it will be spent. Be careful = lest you let other people spend it for you." -- Carl Sandburg (1878 - 1967)= It is impossible to defeat an ignorant man in argument. -- William G. McAd= oo Religion is regarded by the common people as true, by the wise as false,= and by the rulers as useful. -- Seneca "I distrust those people who know s= o well what God wants them to do because I notice it always coincides with = their own desires." - Susan B. Anthony> > Brio is now owned by Oracle. The = last time a dug about the brio site,> there was printed documentation manua= ls for sale, but that was about 3-4> years ago, prior to purchase by Oracle= .> > FYI, Brio sqr started out as SQRIBE, by Sqribe Technologies where it w= as> known as "SQR Server". That was when it was verion 4.x. It then was> pu= rchased by Brio Technology and renamed "Brio Report" It was version> 6.x th= en and I believe also 7.x. Then Hyperion purchased it and tried> to rename = it something else, but users kept calling it "Brio" and SQR.> About a year = or so go Oracle bought it and re-instated the more familiar> names.> -Steve= Jones > > -----Original Message-----> > Contact whoever it is that now own= s SQR (Brio?). If they don't have> them, just Kinko them.> > - jej1216> > -= ---- Original Message -----> From: "Jean Myles" > To= : > Sent: Wednesday, October 10, 2007 10:50 AM> Subjec= t: [sqr-users] SQR Tecnical Documentation> > > We are trying to locate a ha= rd copy of the SQR Technical Documentation> > > (mostly the language refere= nce guide and designing reports with sqr> > developer) for the latest versi= on of SQR. We can download the PDF's. > > but would like to know if a hard = copy exists or if you would have any > > other documentation recommendation= s.> >> >> >> > Thanks in advance for the information.> >> >> >> > Jean Myle= s> >> > Information Management Specialist> >> > Fashion Institute of Techno= logy> >> > P: 212-217-3440> >> > F: 212-217-3452> >> > E: jean_myles@fitnyc.edu> >> > _________________________________= ______________> > sqr-users mailing list> > sqr-users@sqrug.org> > http://w= ww.sqrug.org/mailman/listinfo/sqr-users> > > > ____________________________= ___________________> sqr-users mailing list> sqr-users@sqrug.org> http://ww= w.sqrug.org/mailman/listinfo/sqr-users> > > > _____________________________= __________________> sqr-users mailing list> sqr-users@sqrug.org> http://www= .sqrug.org/mailman/listinfo/sqr-users _________________________________________________________________ Peek-a-boo FREE Tricks & Treats for You! http://www.reallivemoms.com?ocid=3DTXT_TAGHM&loc=3Dus _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 17:11:52 2007 Subject: RE: [sqr-users] SQRP v9.3 return code of 3 Date: Wed, 10 Oct 2007 16:09:01 -0500 From: "Bob Stone" it should be the return code for the command line for the System you're calling on. So check with you windows/unix admins about command line return codes for whatever machine you're running on. -----Original Message----- From: sqr-users-bounces+bstone=3Dfastenal.com@sqrug.org [mailto:sqr-users-bounces+bstone=3Dfastenal.com@sqrug.org] On Behalf Of Leonard, Kyle Sent: Wednesday, October 10, 2007 3:51 PM To: This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions. Subject: [sqr-users] SQRP v9.3 return code of 3 Can anyone point me to a list of what the various command line return values mean? =20 We are issuing a CALL command to run SQRP and it is failing. Debugging efforts have failed. Our last clue is the return value of '3' =20 Thanks Kyle =20 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL, and exempt from disclosure under applicable law. If you are not the intended recipient, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 17:19:01 2007 Date: Wed, 10 Oct 2007 15:15:09 -0600 From: jwillson@dssltd.com Subject: [sqr-users] SQR & BI Publisher &/OR XML Publisher Hi, has any one made a comparison among these tools or languages? How about SQR using JAVA in place of C under the wraps? Any input welcome. John Willson http://www.dssltd.com/ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 18:01:31 2007 Subject: RE: [sqr-users] SQR Tecnical Documentation Date: Wed, 10 Oct 2007 17:58:10 -0400 From: Go ahead, pls.=20 -----Original Message----- From: sqr-users-bounces+jones.steven=3Dups-scs.com@sqrug.org [mailto:sqr-users-bounces+jones.steven=3Dups-scs.com@sqrug.org] On Behalf Of Alexander, Steven Sent: Wednesday, October 10, 2007 11:36 AM To: 'This list is for discussion about the SQR database reportinglanguagefrom Hyperion Solutions.' Subject: RE: [sqr-users] SQR Tecnical Documentation We should add this history to the Wikipedia article about SQR. -----Original Message----- From: sqr-users-bounces+steven.alexander=3Dsanjoseca.gov@sqrug.org [mailto:sqr-users-bounces+steven.alexander=3Dsanjoseca.gov@sqrug.org] On Behalf Of Wes Williams Sent: Wednesday, October 10, 2007 11:29 AM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: RE: [sqr-users] SQR Tecnical Documentation Written by a guy Israel Stern...right?=20 Wes Williams Manager Facilities Mgt. Systems Princeton University 609-258-7027 609-468-6344 -----Original Message----- From: sqr-users-bounces+wes=3Dprinceton.edu@sqrug.org [mailto:sqr-users-bounces+wes=3Dprinceton.edu@sqrug.org] On Behalf Of Jones.Steven@ups-scs.com Sent: Wednesday, October 10, 2007 2:24 PM To: sqr-users@sqrug.org Subject: RE: [sqr-users] SQR Tecnical Documentation You go back farther than I. thx=20 -----Original Message----- From: sqr-users-bounces+jones.steven=3Dups-scs.com@sqrug.org [mailto:sqr-users-bounces+jones.steven=3Dups-scs.com@sqrug.org] On Behalf Of the dragon Sent: Wednesday, October 10, 2007 11:18 AM To: This list is for discussion about the SQR database reporting languagefrom Hyperion Solutions. Subject: RE: [sqr-users] SQR Tecnical Documentation Actually, I believe SQR started as a Sybase tool, then was owned by MITI (v2 and 3) which became SQRibe. =20 peace, clark 'the dragon' willisPSA: Salary <> Slavery. If you earn a salary, your employer is renting your services for 40 hours a week, not purchasing your soul. Your time is the only real finite asset that you have, and once used it can never be recovered, so don't waste it by giving it away. I work to live; I don't live to work. "Time is the coin of your life. It is the only coin you have, and only you can determine how it will be spent. Be careful lest you let other people spend it for you." -- Carl Sandburg (1878 - 1967) It is impossible to defeat an ignorant man in argument. -- William G. McAdoo Religion is regarded by the common people as true, by the wise as false, and by the rulers as useful. -- Seneca "I distrust those people who know so well what God wants them to do because I notice it always coincides with their own desires." - Susan B. Anthony> > Brio is now owned by Oracle. The last time a dug about the brio site,> there was printed documentation manuals for sale, but that was about 3-4> years ago, prior to purchase by Oracle.> > FYI, Brio sqr started out as SQRIBE, by Sqribe Technologies where it was> known as "SQR Server". That was when it was verion 4.x. It then was> purchased by Brio Technology and renamed "Brio Report" It was version> 6.x then and I believe also 7.x. Then Hyperion purchased it and tried> to rename it something else, but users kept calling it "Brio" and SQR.> About a year or so go Oracle bought it and re-instated the more familiar> names.> -Steve Jones > > -----Original Message-----> > Contact whoever it is that now owns SQR (Brio?). If they don't have> them, just Kinko them.> > - jej1216> > ----- Original Message -----> From: "Jean Myles" > To: > Sent: Wednesday, October 10, 2007 10:50 AM> Subject: [sqr-users] SQR Tecnical Documentation> > > We are trying to locate a hard copy of the SQR Technical Documentation> > > (mostly the language reference guide and designing reports with sqr> > developer) for the latest version of SQR. We can download the PDF's. > > but would like to know if a hard copy exists or if you would have any > > other documentation recommendations.> >> >> >> > Thanks in advance for the information.> >> >> >> > Jean Myles> >> > Information Management Specialist> >> > Fashion Institute of Technology> >> > P: 212-217-3440> >> > F: 212-217-3452> >> > E: jean_myles@fitnyc.edu> >> > _______________________________________________> > sqr-users mailing list> > sqr-users@sqrug.org> > http://www.sqrug.org/mailman/listinfo/sqr-users> > > > _______________________________________________> sqr-users mailing list> sqr-users@sqrug.org> http://www.sqrug.org/mailman/listinfo/sqr-users> > > > _______________________________________________> sqr-users mailing list> sqr-users@sqrug.org> http://www.sqrug.org/mailman/listinfo/sqr-users _________________________________________________________________ Peek-a-boo FREE Tricks & Treats for You! http://www.reallivemoms.com?ocid=3DTXT_TAGHM&loc=3Dus _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 18:13:25 2007 From: the dragon Subject: RE: [sqr-users] SQR Tecnical Documentation Date: Wed, 10 Oct 2007 17:08:01 -0500 It looks like the correct history is already there... =20 SQ Software created SQR in the mid 1980s. It had a marketing agreement with= D & N Systems, which changed its name to SQL Solutions and was later acqui= red by Sybase Inc. Sybase purchased SQ Software in the early 1990s. To avoi= d competing directly with Oracle Corporation, Sybase had a marketing and de= velopment agreement with MITI for the Oracle database versions of SQR. MITI= acquired the full rights to SQR in the mid 1990s. MITI changed its name to= SQRiBE Technologies in 1997. Brio Technology acquired SQRiBE in August, 19= 99. Brio Technology later changed its name to Brio Software. Brio licensed = the compiler source code to PeopleSoft Inc. sometime around 2000. Hyperion = Solutions Corporation acquired Brio Software in October, 2003. Oracle Corpo= ration acquired PeopleSoft in December, 2004. And as of March 2007 Oracle C= orporation has acquired Hyperion Solutions, thus reuniting SQR with PeopleS= oft. =20 http://en.wikipedia.org/wiki/SQR =20 peace, clarkPSA: Salary <> Slavery. If you earn a salary, your employer is renting= your services for 40 hours a week, not purchasing your soul. Your time is = the only real finite asset that you have, and once used it can never be rec= overed, so don't waste it by giving it away. I work to live; I don't live t= o work. "Time is the coin of your life. It is the only coin you have, and o= nly you can determine how it will be spent. Be careful lest you let other p= eople spend it for you." -- Carl Sandburg (1878 - 1967) It is impossible to= defeat an ignorant man in argument. -- William G. McAdoo Religion is regar= ded by the common people as true, by the wise as false, and by the rulers a= s useful. -- Seneca "I distrust those people who know so well what God want= s them to do because I notice it always coincides with their own desires." = - Susan B. Anthony> > Go ahead, pls. > > -----Original Message-----> > We s= hould add this history to the Wikipedia article about SQR.> > -----Original= Message-----> > Written by a guy Israel Stern...right? > > Wes Williams> M= anager Facilities Mgt. Systems> Princeton University> 609-258-7027> 609-468= -6344> > -----Original Message-----> > You go back farther than I. thx > > = -----Original Message-----> > > Actually, I believe SQR started as a Sybase= tool, then was owned by MITI> (v2 and 3) which became SQRibe.> > peace,> c= lark 'the dragon'=20 _________________________________________________________________ Windows Live Hotmail and Microsoft Office Outlook =96 together at last. =A0= Get it now. http://office.microsoft.com/en-us/outlook/HA102225181033.aspx?pid=3DCL10062= 6971033 _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Wed Oct 10 18:22:19 2007 Date: Wed, 10 Oct 2007 18:19:20 -0400 From: maddy Subject: Re: [sqr-users] Challenging issue with Brio SQR in UNIX I have tried adding commit statements before and after each query and still see the same issue. On 10/10/07, franck.masson2002@laposte.net wrote: > what happen if you add a commit statement after the Insert and before the= select statement ? > > > > > > > Message du 10/10/07 20:47 > > De : "maddy" > > A : "the dragon" > > Copie =E0 : "This list is for discussion about the SQR database reporti= ng language from Hyperion Solutions." > > Objet : Re: [sqr-users] Challenging issue with Brio SQR in UNIX > > > > Hi dragon, > > > > Thanks for your quick response.By mistake I had sent you the wrong > > file with Cursor information. Please take a look at the new file > > attached. > > > > > > Thanks, > > Maddy > > > > > > > > On 10/10/07, the dragon wrote: > > > The sqr failed to make it through, but the -s looks to me like it is = working > > > correctly - 354 rows are inserted, and 354 are selected afterwards. I= guess > > > my question is what makes you think it isn't working? > > > > > > peace, > > > clark 'the dragon' willis > > > > > > PSA: Salary <> Slavery. If you earn a salary, your employer is rentin= g your > > > services for 40 hours a week, not purchasing your soul. Your time is = the > > > only real finite asset that you have, and once used it can never be > > > recovered, so don't waste it by giving it away. > > > > > > I work to live; I don't live to work. > > > > > > "Time is the coin of your life. It is the only coin you have, and onl= y you > > > can determine how it will be spent. Be careful lest you let other peo= ple > > > spend it for you." -- Carl Sandburg (1878 - 1967) > > > > > > It is impossible to defeat an ignorant man in argument. -- William G.= McAdoo > > > > > > Religion is regarded by the common people as true, by the wise as fal= se, and > > > by the rulers as useful. -- Seneca > > > > > > "I distrust those people who know so well what God wants them to do b= ecause > > > I notice it always coincides with their own desires." - Susan B. Anth= ony > > > > > > > > > > > Hi, > > > > > > > > I have tried all the various things mentioned in the chain of emails > > > > but still have the same issue. The issue is with commit statement b= ut > > > > not sure why it is not working with ORDER BY clause in the SELECT > > > > statement. > > > > > > > > Please take a look at the attached SQR program and the cursor > > > > information when compiled with -S flag. > > > > > > > > > > > > Thanks!! > > > > Maddy > > > > > > > > > > > > Environment : Hyperion 8.5.0.0.0.566/IBM RS6000/AIX 5.2/ODBC DataDi= rect > > > 5.1 > > > > Database : Sybase 12.5 > > > > > > > > On 10/9/07, George Jansen wrote: > > > > > It strikes me that an ORDER BY clause means sorting, sorting mean= s the > > > use of temporary space, and this could be limited. > > > > > > > > > > As for the location, are you using Oracle? With Oracle you could = under > > > some circumstances be connecting through a shared server (sorting in = the > > > shared pool) and in others connecting through a dedicated server. > > > > > > > > > > >>> maddy 10/4/2007 6:01 PM >>> > > > > > Hi, > > > > > > > > > > We have a strange problem with all the Brio SQR Programs executin= g under > > > > > UNIX environment.All these programs are working fine and giving d= ata > > > when > > > > > executed in windows environment and giving no data in UNIX enviro= ment. > > > > > > > > > > We are creating a temp table and inserting data in the SQR progra= m but > > > > > unable to Select the data from the same table and print it on to = the > > > > > report.However when the ORDER BY clause in the select statement is > > > commented > > > > > out, data is pulled on to the report. > > > > > > > > > > If I run the same program again without droping and creating the = table > > > we > > > > > get the data from the table even with ORDER BY clause which is st= range. > > > > > How can a ORDER BY clause in the SELECT statement cause this kind= of > > > issue > > > > > ? I can send the skeleton program if any of the experts can look = into > > > this > > > > > issue. > > > > > > > > > > Environment: Hyperion 8.5 installed on UNIX (AIX) > > > > > > > > > > Thanks, > > > > > Maddy > > > > > > > > > > > > > > ________________________________ > > > Help yourself to FREE treats served up daily at the Messenger Caf=E9.= Stop by > > > today! > > > > > [ CID30_Cursor_Info.txt (4.3 Ko) ] > > [ (pas de nom de fichier) (0.1 Ko) ] > > Cr=E9ez votre adresse =E9lectronique pr=E9nom.nom@laposte.net > 1 Go d'espace de stockage, anti-spam et anti-virus int=E9gr=E9s. > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Oct 11 09:10:19 2007 Date: Thu, 11 Oct 2007 08:54:14 -0400 From: "Barilleaux, Rebecca" Subject: [sqr-users] RE: sqr-users Digest, Vol 44, Issue 5 This is just a shot in the dark, but I noticed that you are creating & inse= rting into CID30_JP and selecting from RPT..CID30_JP. Is it possible the t= able is being created in some other database besides RPT? Like maybe tempd= b? What happens if you leave off the RPT.. From the select statement, or a= dd it to your create table & insert statements? Thanks, Rebecca -----Original Message----- Date: Wed, 10 Oct 2007 14:44:20 -0400 From: maddy Subject: Re: [sqr-users] Challenging issue with Brio SQR in UNIX To: "the dragon" Cc: "This list is for discussion about the SQR database reporting language from Hyperion Solutions." Message-ID: Content-Type: text/plain; charset=3D"iso-8859-1" Hi dragon, Thanks for your quick response.By mistake I had sent you the wrong file with Cursor information. Please take a look at the new file attached. Thanks, Maddy On 10/10/07, the dragon wrote: > The sqr failed to make it through, but the -s looks to me like it is work= ing > correctly - 354 rows are inserted, and 354 are selected afterwards. I gu= ess > my question is what makes you think it isn't working? > > peace, > clark 'the dragon' willis > > PSA: Salary <> Slavery. If you earn a salary, your employer is renting yo= ur > services for 40 hours a week, not purchasing your soul. Your time is the > only real finite asset that you have, and once used it can never be > recovered, so don't waste it by giving it away. > > I work to live; I don't live to work. > > "Time is the coin of your life. It is the only coin you have, and only you > can determine how it will be spent. Be careful lest you let other people > spend it for you." -- Carl Sandburg (1878 - 1967) > > It is impossible to defeat an ignorant man in argument. -- William G. McA= doo > > Religion is regarded by the common people as true, by the wise as false, = and > by the rulers as useful. -- Seneca > > "I distrust those people who know so well what God wants them to do becau= se > I notice it always coincides with their own desires." - Susan B. Anthony > > > > > Hi, > > > > I have tried all the various things mentioned in the chain of emails > > but still have the same issue. The issue is with commit statement but > > not sure why it is not working with ORDER BY clause in the SELECT > > statement. > > > > Please take a look at the attached SQR program and the cursor > > information when compiled with -S flag. > > > > > > Thanks!! > > Maddy > > > > > > Environment : Hyperion 8.5.0.0.0.566/IBM RS6000/AIX 5.2/ODBC DataDirect > 5.1 > > Database : Sybase 12.5 > > > > On 10/9/07, George Jansen wrote: > > > It strikes me that an ORDER BY clause means sorting, sorting means the > use of temporary space, and this could be limited. > > > > > > As for the location, are you using Oracle? With Oracle you could under > some circumstances be connecting through a shared server (sorting in the > shared pool) and in others connecting through a dedicated server. > > > > > > >>> maddy 10/4/2007 6:01 PM >>> > > > Hi, > > > > > > We have a strange problem with all the Brio SQR Programs executing un= der > > > UNIX environment.All these programs are working fine and giving data > when > > > executed in windows environment and giving no data in UNIX enviroment. > > > > > > We are creating a temp table and inserting data in the SQR program but > > > unable to Select the data from the same table and print it on to the > > > report.However when the ORDER BY clause in the select statement is > commented > > > out, data is pulled on to the report. > > > > > > If I run the same program again without droping and creating the table > we > > > get the data from the table even with ORDER BY clause which is strang= e. > > > How can a ORDER BY clause in the SELECT statement cause this kind of > issue > > > ? I can send the skeleton program if any of the experts can look into > this > > > issue. > > > > > > Environment: Hyperion 8.5 installed on UNIX (AIX) > > > > > > Thanks, > > > Maddy > > > > > > ________________________________ > Help yourself to FREE treats served up daily at the Messenger Caf=E9. Sto= p by > today! -------------- next part -------------- Cursor Status: Cursor #1: SQL =3D commit transaction Compiles =3D 1 Executes =3D 1 Rows =3D 0 Cursor #2: SQL =3D if exists(select 1 from sysobjects where name =3D'CID30_JP'and type=3D'U') begin drop table CID30_JP end Compiles =3D 1 Executes =3D 1 Rows =3D 0 Cursor #3: SQL =3D create table CID30_JP ( BLEI_BILL_LEVEL char(1) null, BLEI_LST_TL_DUE_DT datetime null, BLEI_LAST_BILL_DTM datetime null, BLEI_LST_BL_END_DT datetime null, BLEI_SUSPND_BL_IND char(1) null, GRGR_ID char(8) null, SGSG_ID char(4) null, SBSB_ID char(9) null ) Compiles =3D 1 Executes =3D 1 Rows =3D 0 Cursor #4: SQL =3D commit transaction Compiles =3D 1 Executes =3D 1 Rows =3D 0 Cursor #5: SQL =3D {call RPT..BERSP_EVENT_STEP_INSERT(?,?,?,?)} Compiles =3D 0 Executes =3D 4 Rows =3D 0 Cursor #6: SQL =3D insert into CID30_JP ( BLEI_BILL_LEVEL, BLEI_LST_TL_DUE_DT, BLEI_LAST_BILL_DTM, BLEI_LST_BL_END_DT, BLEI_SUSPND_BL_IND, GRGR_ID, SGSG_ID, SBSB_ID ) select 'I', BLEI.BLEI_LST_TL_DUE_DT, BLEI.BLEI_LAST_BILL_DTM, BLEI.BLEI_LST_BL_END_DT, BLEI.BLEI_SUSPND_BL_IND, GRGR.GRGR_ID, null , SBSB.SBSB_ID from fadfyin1..CMC_BLEI_ENTY_INFO BLEI, fadfyin1..CMC_GRGR_GROUP GRGR, fadfyin1..CMC_SBSB_SUBSC SBSB where BLEI.BLEI_BILL_LEVEL_CK =3D SBSB.SBSB_CK and SBSB.GRGR_CK =3D GRGR.GRGR_CK and BLEI.BLEI_BILL_LEVEL =3D 'I' and BLEI.BLEI_SUSPND_BL_IND in ('B','D','S') union select 'G', BLEI.BLEI_LST_TL_DUE_DT, BLEI.BLEI_LAST_BILL_DTM, BLEI.BLEI_LST_BL_END_DT, BLEI.BLEI_SUSPND_BL_IND, GRGR.GRGR_ID, SGSG.SGSG_ID, null from fadfyin1..CMC_BLEI_ENTY_INFO BLEI, fadfyin1..CMC_GRGR_GROUP GRGR, fadfyin1..CMC_SGSG_SUB_GROUP SGSG where BLEI.BLEI_BILL_LEVEL_CK =3D SGSG.SGSG_CK and SGSG.GRGR_CK =3D GRGR.GRGR_CK and BLEI.BLEI_BILL_LEVEL =3D 'S' and BLEI.BLEI_SUSPND_BL_IND in ('B','D','S') union sele= ct 'G', BLEI.BLEI_LST_TL_DUE_DT, BLEI.BLEI_LAST_BILL_DTM, BLEI.BLEI_LST_BL_END_DT, BLEI.BLEI_SUSPND_BL_IND, GRGR.GRGR_ID, null, null from fadfyin1..CMC_BLEI_ENTY_INFO BLEI, fadfyin1..CMC_GRGR_GROUP GRGR where BLEI.BLEI_BILL_LEVEL_CK =3D GRGR.GRGR_CK and BLEI.BLEI_BILL_LEVEL =3D 'G' and BLEI.BLEI_SUSPND_BL_IND in ('B','D','S') Compiles =3D 1 Executes =3D 1 Rows =3D 354 Cursor #7: SQL =3D SELECT BLSU.BLEI_BILL_LEVEL, BLSU.BLEI_SUSPND_BL_IND, BLSU.GRGR_= ID, BLSU.SGSG_ID, BLSU.SBSB_ID, convert(char(10),BLSU.BLEI_LST_TL_DUE_DT,101), convert(char(10),BLSU.BLEI_LAST_BILL_DTM,101), convert(char(10),BLSU.BLEI_LST_BL_END_DT,101) from RPT..CID30_JP BLSU order by BLSU.BLEI_BILL_LEVEL, BLSU.BLEI_SUSPND_BL_IND, BLSU.GRGR_ID, BLSU.SGSG_ID, BLSU.SBSB_ID Compiles =3D 1 Executes =3D 1 Rows =3D 0 Cursor #8: SQL =3D drop table RPT..CID30_JP Compiles =3D 1 Executes =3D 1 Rows =3D 0 SQR: End of Run. ------------------------------ _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,=20 is for the sole use of the intended recipient(s) and may contain confidenti= al and privileged information or otherwise protected by law. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Oct 11 09:46:37 2007 Date: Thu, 11 Oct 2007 09:43:33 -0400 From: maddy Subject: Re: [sqr-users] RE: sqr-users Digest, Vol 44, Issue 5 Thanks Rebecca, there is nothing wrong in the program and we have tried everything. Actually 4 senior developers are working on this issue and also opened a ticket with Hyperion on this issue. Thanks, Maddy On 10/11/07, Barilleaux, Rebecca wrote: > This is just a shot in the dark, but I noticed that you are creating & in= serting into CID30_JP and selecting from RPT..CID30_JP. Is it possible the= table is being created in some other database besides RPT? Like maybe tem= pdb? What happens if you leave off the RPT.. From the select statement, or= add it to your create table & insert statements? > > Thanks, > Rebecca > > -----Original Message----- > Date: Wed, 10 Oct 2007 14:44:20 -0400 > From: maddy > Subject: Re: [sqr-users] Challenging issue with Brio SQR in UNIX > To: "the dragon" > Cc: "This list is for discussion about the SQR database reporting > language from Hyperion Solutions." > Message-ID: > > Content-Type: text/plain; charset=3D"iso-8859-1" > > Hi dragon, > > Thanks for your quick response.By mistake I had sent you the wrong > file with Cursor information. Please take a look at the new file > attached. > > > Thanks, > Maddy > > > > On 10/10/07, the dragon wrote: > > The sqr failed to make it through, but the -s looks to me like it is wo= rking > > correctly - 354 rows are inserted, and 354 are selected afterwards. I = guess > > my question is what makes you think it isn't working? > > > > peace, > > clark 'the dragon' willis > > > > PSA: Salary <> Slavery. If you earn a salary, your employer is renting = your > > services for 40 hours a week, not purchasing your soul. Your time is the > > only real finite asset that you have, and once used it can never be > > recovered, so don't waste it by giving it away. > > > > I work to live; I don't live to work. > > > > "Time is the coin of your life. It is the only coin you have, and only = you > > can determine how it will be spent. Be careful lest you let other people > > spend it for you." -- Carl Sandburg (1878 - 1967) > > > > It is impossible to defeat an ignorant man in argument. -- William G. M= cAdoo > > > > Religion is regarded by the common people as true, by the wise as false= , and > > by the rulers as useful. -- Seneca > > > > "I distrust those people who know so well what God wants them to do bec= ause > > I notice it always coincides with their own desires." - Susan B. Anthony > > > > > > > > Hi, > > > > > > I have tried all the various things mentioned in the chain of emails > > > but still have the same issue. The issue is with commit statement but > > > not sure why it is not working with ORDER BY clause in the SELECT > > > statement. > > > > > > Please take a look at the attached SQR program and the cursor > > > information when compiled with -S flag. > > > > > > > > > Thanks!! > > > Maddy > > > > > > > > > Environment : Hyperion 8.5.0.0.0.566/IBM RS6000/AIX 5.2/ODBC DataDire= ct > > 5.1 > > > Database : Sybase 12.5 > > > > > > On 10/9/07, George Jansen wrote: > > > > It strikes me that an ORDER BY clause means sorting, sorting means = the > > use of temporary space, and this could be limited. > > > > > > > > As for the location, are you using Oracle? With Oracle you could un= der > > some circumstances be connecting through a shared server (sorting in the > > shared pool) and in others connecting through a dedicated server. > > > > > > > > >>> maddy 10/4/2007 6:01 PM >>> > > > > Hi, > > > > > > > > We have a strange problem with all the Brio SQR Programs executing = under > > > > UNIX environment.All these programs are working fine and giving data > > when > > > > executed in windows environment and giving no data in UNIX envirome= nt. > > > > > > > > We are creating a temp table and inserting data in the SQR program = but > > > > unable to Select the data from the same table and print it on to the > > > > report.However when the ORDER BY clause in the select statement is > > commented > > > > out, data is pulled on to the report. > > > > > > > > If I run the same program again without droping and creating the ta= ble > > we > > > > get the data from the table even with ORDER BY clause which is stra= nge. > > > > How can a ORDER BY clause in the SELECT statement cause this kind of > > issue > > > > ? I can send the skeleton program if any of the experts can look in= to > > this > > > > issue. > > > > > > > > Environment: Hyperion 8.5 installed on UNIX (AIX) > > > > > > > > Thanks, > > > > Maddy > > > > > > > > > > ________________________________ > > Help yourself to FREE treats served up daily at the Messenger Caf=E9. S= top by > > today! > -------------- next part -------------- > Cursor Status: > > Cursor #1: > SQL =3D commit transaction > Compiles =3D 1 > Executes =3D 1 > Rows =3D 0 > > Cursor #2: > SQL =3D if exists(select 1 from sysobjects where name =3D'CID30_JP'and > type=3D'U') begin drop table CID30_JP end > Compiles =3D 1 > Executes =3D 1 > Rows =3D 0 > > Cursor #3: > SQL =3D create table CID30_JP ( BLEI_BILL_LEVEL char(1) null, > BLEI_LST_TL_DUE_DT datetime null, BLEI_LAST_BILL_DTM datetime > null, BLEI_LST_BL_END_DT datetime null, BLEI_SUSPND_BL_IND > char(1) null, GRGR_ID char(8) null, SGSG_ID > char(4) null, SBSB_ID char(9) null ) > Compiles =3D 1 > Executes =3D 1 > Rows =3D 0 > > Cursor #4: > SQL =3D commit transaction > Compiles =3D 1 > Executes =3D 1 > Rows =3D 0 > > Cursor #5: > SQL =3D {call RPT..BERSP_EVENT_STEP_INSERT(?,?,?,?)} > Compiles =3D 0 > Executes =3D 4 > Rows =3D 0 > > > Cursor #6: > SQL =3D insert into CID30_JP ( BLEI_BILL_LEVEL, BLEI_LST_TL_DUE_DT, > BLEI_LAST_BILL_DTM, BLEI_LST_BL_END_DT, BLEI_SUSPND_BL_IND, > GRGR_ID, SGSG_ID, SBSB_ID ) select 'I', BLEI.BLEI_LST_TL_DUE_DT, > BLEI.BLEI_LAST_BILL_DTM, BLEI.BLEI_LST_BL_END_DT, > BLEI.BLEI_SUSPND_BL_IND, GRGR.GRGR_ID, null , SBSB.SBSB_ID from > fadfyin1..CMC_BLEI_ENTY_INFO BLEI, fadfyin1..CMC_GRGR_GROUP > GRGR, fadfyin1..CMC_SBSB_SUBSC SBSB where > BLEI.BLEI_BILL_LEVEL_CK =3D SBSB.SBSB_CK and SBSB.GRGR_CK > =3D GRGR.GRGR_CK and BLEI.BLEI_BILL_LEVEL =3D 'I' and > BLEI.BLEI_SUSPND_BL_IND in ('B','D','S') union select 'G', > BLEI.BLEI_LST_TL_DUE_DT, BLEI.BLEI_LAST_BILL_DTM, > BLEI.BLEI_LST_BL_END_DT, BLEI.BLEI_SUSPND_BL_IND, GRGR.GRGR_ID, > SGSG.SGSG_ID, null from fadfyin1..CMC_BLEI_ENTY_INFO BLEI, > fadfyin1..CMC_GRGR_GROUP GRGR, fadfyin1..CMC_SGSG_SUB_GROUP > SGSG where BLEI.BLEI_BILL_LEVEL_CK =3D SGSG.SGSG_CK and > SGSG.GRGR_CK =3D GRGR.GRGR_CK and BLEI.BLEI_BILL_LEV= EL > =3D 'S' and BLEI.BLEI_SUSPND_BL_IND in ('B','D','S') union sel= ect > 'G', BLEI.BLEI_LST_TL_DUE_DT, BLEI.BLEI_LAST_BILL_DTM, > BLEI.BLEI_LST_BL_END_DT, BLEI.BLEI_SUSPND_BL_IND, GRGR.GRGR_ID, > null, null from fadfyin1..CMC_BLEI_ENTY_INFO BLEI, > fadfyin1..CMC_GRGR_GROUP GRGR where > BLEI.BLEI_BILL_LEVEL_CK =3D GRGR.GRGR_CK and BLEI.BLEI_BILL_LEV= EL > =3D 'G' and BLEI.BLEI_SUSPND_BL_IND in ('B','D','S') > Compiles =3D 1 > Executes =3D 1 > Rows =3D 354 > > Cursor #7: > SQL =3D SELECT BLSU.BLEI_BILL_LEVEL, BLSU.BLEI_SUSPND_BL_IND, BLSU.GRGR= _ID, > BLSU.SGSG_ID, BLSU.SBSB_ID, > convert(char(10),BLSU.BLEI_LST_TL_DUE_DT,101), > convert(char(10),BLSU.BLEI_LAST_BILL_DTM,101), > convert(char(10),BLSU.BLEI_LST_BL_END_DT,101) from RPT..CID30_JP > BLSU order by BLSU.BLEI_BILL_LEVEL, BLSU.BLEI_SUSPND_BL_IND, > BLSU.GRGR_ID, BLSU.SGSG_ID, BLSU.SBSB_ID > Compiles =3D 1 > Executes =3D 1 > Rows =3D 0 > > Cursor #8: > SQL =3D drop table RPT..CID30_JP > Compiles =3D 1 > Executes =3D 1 > Rows =3D 0 > > > SQR: End of Run. > > ------------------------------ > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > > > > CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, > is for the sole use of the intended recipient(s) and may contain confiden= tial > and privileged information or otherwise protected by law. Any unauthoriz= ed > review, use, disclosure or distribution is prohibited. If you are not the > intended recipient, please contact the sender by reply e-mail and destroy > all copies of the original message. > > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > _______________________________________________ sqr-users mailing list sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users From sqr-users-bounces@sqrug.org Thu Oct 11 09:52:39 2007 Subject: RE: [sqr-users] RE: sqr-users Digest, Vol 44, Issue 5 Date: Thu, 11 Oct 2007 08:49:38 -0500 From: "Bob Stone" have you considered that the problem isn't with the connect to the DB, but = rather with the printing/writing statements for the report? -----Original Message----- From: sqr-users-bounces+bstone=3Dfastenal.com@sqrug.org [mailto:sqr-users-b= ounces+bstone=3Dfastenal.com@sqrug.org] On Behalf Of maddy Sent: Thursday, October 11, 2007 8:44 AM To: This list is for discussion about the SQR database reporting language f= rom Hyperion Solutions. Subject: Re: [sqr-users] RE: sqr-users Digest, Vol 44, Issue 5 Thanks Rebecca, there is nothing wrong in the program and we have tried everything. Actually 4 senior developers are working on this issue and also opened a ticket with Hyperion on this issue. Thanks, Maddy On 10/11/07, Barilleaux, Rebecca wrote: > This is just a shot in the dark, but I noticed that you are creating & in= serting into CID30_JP and selecting from RPT..CID30_JP. Is it possible the= table is being created in some other database besides RPT? Like maybe tem= pdb? What happens if you leave off the RPT.. From the select statement, or= add it to your create table & insert statements? > > Thanks, > Rebecca > > -----Original Message----- > Date: Wed, 10 Oct 2007 14:44:20 -0400 > From: maddy > Subject: Re: [sqr-users] Challenging issue with Brio SQR in UNIX > To: "the dragon" > Cc: "This list is for discussion about the SQR database reporting > language from Hyperion Solutions." > Message-ID: > > Content-Type: text/plain; charset=3D"iso-8859-1" > > Hi dragon, > > Thanks for your quick response.By mistake I had sent you the wrong > file with Cursor information. Please take a look at the new file > attached. > > > Thanks, > Maddy > > > > On 10/10/07, the dragon wrote: > > The sqr failed to make it through, but the -s looks to me like it is wo= rking > > correctly - 354 rows are inserted, and 354 are selected afterwards. I = guess > > my question is what makes you think it isn't working? > > > > peace, > > clark 'the dragon' willis > > > > PSA: Salary <> Slavery. If you earn a salary, your employer is renting = your > > services for 40 hours a week, not purchasing your soul. Your time is the > > only real finite asset that you have, and once used it can never be > > recovered, so don't waste it by giving it away. > > > > I work to live; I don't live to work. > > > > "Time is the coin of your life. It is the only coin you have, and only = you > > can determine how it will be spent. Be careful lest you let other people > > spend it for you." -- Carl Sandburg (1878 - 1967) > > > > It is impossible to defeat an ignorant man in argument. -- William G. M= cAdoo > > > > Religion is regarded by the common people as true, by the wise as false= , and > > by the rulers as useful. -- Seneca > > > > "I distrust those people who know so well what God wants them to do bec= ause > > I notice it always coincides with their own desires." - Susan B. Anthony > > > > > > > > Hi, > > > > > > I have tried all the various things mentioned in the chain of emails > > > but still have the same issue. The issue is with commit statement but > > > not sure why it is not working with ORDER BY clause in the SELECT > > > statement. > > > > > > Please take a look at the attached SQR program and the cursor > > > information when compiled with -S flag. > > > > > > > > > Thanks!! > > > Maddy > > > > > > > > > Environment : Hyperion 8.5.0.0.0.566/IBM RS6000/AIX 5.2/ODBC DataDire= ct > > 5.1 > > > Database : Sybase 12.5 > > > > > > On 10/9/07, George Jansen wrote: > > > > It strikes me that an ORDER BY clause means sorting, sorting means = the > > use of temporary space, and this could be limited. > > > > > > > > As for the location, are you using Oracle? With Oracle you could un= der > > some circumstances be connecting through a shared server (sorting in the > > shared pool) and in others connecting through a dedicated server. > > > > > > > > >>> maddy 10/4/2007 6:01 PM >>> > > > > Hi, > > > > > > > > We have a strange problem with all the Brio SQR Programs executing = under > > > > UNIX environment.All these programs are working fine and giving data > > when > > > > executed in windows environment and giving no data in UNIX envirome= nt. > > > > > > > > We are creating a temp table and inserting data in the SQR program = but > > > > unable to Select the data from the same table and print it on to the > > > > report.However when the ORDER BY clause in the select statement is > > commented > > > > out, data is pulled on to the report. > > > > > > > > If I run the same program again without droping and creating the ta= ble > > we > > > > get the data from the table even with ORDER BY clause which is stra= nge. > > > > How can a ORDER BY clause in the SELECT statement cause this kind of > > issue > > > > ? I can send the skeleton program if any of the experts can look in= to > > this > > > > issue. > > > > > > > > Environment: Hyperion 8.5 installed on UNIX (AIX) > > > > > > > > Thanks, > > > > Maddy > > > > > > > > > > ________________________________ > > Help yourself to FREE treats served up daily at the Messenger Caf=E9. S= top by > > today! > -------------- next part -------------- > Cursor Status: > > Cursor #1: > SQL =3D commit transaction > Compiles =3D 1 > Executes =3D 1 > Rows =3D 0 > > Cursor #2: > SQL =3D if exists(select 1 from sysobjects where name =3D'CID30_JP'and > type=3D'U') begin drop table CID30_JP end > Compiles =3D 1 > Executes =3D 1 > Rows =3D 0 > > Cursor #3: > SQL =3D create table CID30_JP ( BLEI_BILL_LEVEL char(1) null, > BLEI_LST_TL_DUE_DT datetime null, BLEI_LAST_BILL_DTM datetime > null, BLEI_LST_BL_END_DT datetime null, BLEI_SUSPND_BL_IND > char(1) null, GRGR_ID char(8) null, SGSG_ID > char(4) null, SBSB_ID char(9) null ) > Compiles =3D 1 > Executes =3D 1 > Rows =3D 0 > > Cursor #4: > SQL =3D commit transaction > Compiles =3D 1 > Executes =3D 1 > Rows =3D 0 > > Cursor #5: > SQL =3D {call RPT..BERSP_EVENT_STEP_INSERT(?,?,?,?)} > Compiles =3D 0 > Executes =3D 4 > Rows =3D 0 > > > Cursor #6: > SQL =3D insert into CID30_JP ( BLEI_BILL_LEVEL, BLEI_LST_TL_DUE_DT, > BLEI_LAST_BILL_DTM, BLEI_LST_BL_END_DT, BLEI_SUSPND_BL_IND, > GRGR_ID, SGSG_ID, SBSB_ID ) select 'I', BLEI.BLEI_LST_TL_DUE_DT, > BLEI.BLEI_LAST_BILL_DTM, BLEI.BLEI_LST_BL_END_DT, > BLEI.BLEI_SUSPND_BL_IND, GRGR.GRGR_ID, null , SBSB.SBSB_ID from > fadfyin1..CMC_BLEI_ENTY_INFO BLEI, fadfyin1..CMC_GRGR_GROUP > GRGR, fadfyin1..CMC_SBSB_SUBSC SBSB where > BLEI.BLEI_BILL_LEVEL_CK =3D SBSB.SBSB_CK and SBSB.GRGR_CK > =3D GRGR.GRGR_CK and BLEI.BLEI_BILL_LEVEL =3D 'I' and > BLEI.BLEI_SUSPND_BL_IND in ('B','D','S') union select 'G', > BLEI.BLEI_LST_TL_DUE_DT, BLEI.BLEI_LAST_BILL_DTM, > BLEI.BLEI_LST_BL_END_DT, BLEI.BLEI_SUSPND_BL_IND, GRGR.GRGR_ID, > SGSG.SGSG_ID, null from fadfyin1..CMC_BLEI_ENTY_INFO BLEI, > fadfyin1..CMC_GRGR_GROUP GRGR, fadfyin1..CMC_SGSG_SUB_GROUP > SGSG where BLEI.BLEI_BILL_LEVEL_CK =3D SGSG.SGSG_CK and > SGSG.GRGR_CK =3D GRGR.GRGR_CK and BLEI.BLEI_BILL_LEV= EL > =3D 'S' and BLEI.BLEI_SUSPND_BL_IND in ('B','D','S') union sel= ect > 'G', BLEI.BLEI_LST_TL_DUE_DT, BLEI.BLEI_LAST_BILL_DTM, > BLEI.BLEI_LST_BL_END_DT, BLEI.BLEI_SUSPND_BL_IND, GRGR.GRGR_ID, > null, null from fadfyin1..CMC_BLEI_ENTY_INFO BLEI, > fadfyin1..CMC_GRGR_GROUP GRGR where > BLEI.BLEI_BILL_LEVEL_CK =3D GRGR.GRGR_CK and BLEI.BLEI_BILL_LEV= EL > =3D 'G' and BLEI.BLEI_SUSPND_BL_IND in ('B','D','S') > Compiles =3D 1 > Executes =3D 1 > Rows =3D 354 > > Cursor #7: > SQL =3D SELECT BLSU.BLEI_BILL_LEVEL, BLSU.BLEI_SUSPND_BL_IND, BLSU.GRGR= _ID, > BLSU.SGSG_ID, BLSU.SBSB_ID, > convert(char(10),BLSU.BLEI_LST_TL_DUE_DT,101), > convert(char(10),BLSU.BLEI_LAST_BILL_DTM,101), > convert(char(10),BLSU.BLEI_LST_BL_END_DT,101) from RPT..CID30_JP > BLSU order by BLSU.BLEI_BILL_LEVEL, BLSU.BLEI_SUSPND_BL_IND, > BLSU.GRGR_ID, BLSU.SGSG_ID, BLSU.SBSB_ID > Compiles =3D 1 > Executes =3D 1 > Rows =3D 0 > > Cursor #8: > SQL =3D drop table RPT..CID30_JP > Compiles =3D 1 > Executes =3D 1 > Rows =3D 0 > > > SQR: End of Run. > > ------------------------------ > _______________________________________________ > sqr-users mailing list > sqr-users@sqrug.org > http://www.sqrug.org/mailman/listinfo/sqr-users > > > > CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, > is for the sole use of the intended recipient(s) and may contain confiden= tial > and privileged information or otherwise protected