From owner-sqr-users@list.iex.net Tue Jun 30 19:37:39 1998 Date: Tue, 30 Jun 1998 17:29:04 -0700 From: Murray Leckie Subject: Re: Problem starting PS/nVision from PS 6 Single user under Windo ws95 Hi Pramod, Which version of Excel are you currently using? I had a problem running the Financials single user license (PeopleSoft version 6) when upgrading to Office 97 (I required a patch) - Office 95 worked okay. I wonder if you are having the same problem with the HR version. Murray > -----Original Message----- > From: Pramod Bhavanam [SMTP:pramod_ps@HOTMAIL.COM] > Sent: Tuesday, June 30, 1998 9:05 PM > To: Multiple recipients of list SQR-USERS > Subject: Problem starting PS/nVision from PS 6 Single user under > Windows95 > > Hi, > > I am working on Peoplesoft 6 HR Single User version with SQLBase as > the database under Windows'95. > I am getting an error when starting PS/nVision from Peopletools menu > with the following message displayed. > > "PS/nVision was unable to load the DLL, PSNAM.DLL. (28,145)" > > Can anyone give / suggest a possible solution for the above problem. > > I will appreciate your help in this regard. > > Thank you. > Pramod. > > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com From owner-sqr-users@list.iex.net Wed Apr 1 08:24:51 1998 Date: Wed, 1 Apr 1998 08:08:04 -0500 From: John Walker Subject: Printing Bar Codes on an HP Hi, About a week ago I posted a fairly detailed problem I've been having regarding printing bar codes on an HP printer. I didn't get any responses so I'd like to repost it in a more generic form. Basically, I can't get bar codes to print on an HP. The SQR LIS file is sent to the printer via a UNIX print queue. Any tips or recommendations that people have would be appreciated. Thanks. From owner-sqr-users@list.iex.net Wed Apr 1 11:02:02 1998 Date: Wed, 1 Apr 1998 09:44:38 -0500 From: Eric Gentz Subject: Packed Fields Hi, I need to write an interface to one of our state agencies. Their format requires packed fields. I am wondering if this is possible to do within SQR. Thank you in advance. Eric Eric Gentz Interested in a real operating system? UW Hospital & Clinics 610 N. Whitney Way Because HAL doesn't run Windows 95. Madison, WI 53705 Join the Mac Evangelist. 608-263-9345 ej.gentz@hosp.wisc.edu -------------------------------------- "You can twist perceptions, but reality won't budge." -- Neal Peart "Good morning, doctors. I have taken the liberty of removing Windows 95 from my hard drive." - Hal From owner-sqr-users@list.iex.net Wed Apr 1 11:20:57 1998 Date: Wed, 1 Apr 1998 11:12:57 -0500 From: David Harper Subject: Re: Packed Fields It is possible Eric. You just have to convert the numbers(last digit) to EBCDIC. I have the routine to do that, would just have to find it. Can probably e-mail it to you tomorrow. Dave Harper -- ClientTech Online Solutions, Inc. "Peoplesoft Implementation Specialists" www.clienttech.com 800-404-2560 fax: 407-888-4841 Eric Gentz wrote: > > Hi, > > I need to write an interface to one of our state agencies. Their format > requires packed fields. I am wondering if this is possible to do within SQR. > > Thank you in advance. > > Eric > > Eric Gentz Interested in a real operating system? > UW Hospital & Clinics > 610 N. Whitney Way Because HAL doesn't run Windows 95. > Madison, WI 53705 Join the Mac Evangelist. > 608-263-9345 > ej.gentz@hosp.wisc.edu > -------------------------------------- > "You can twist perceptions, but reality won't budge." -- Neal Peart > "Good morning, doctors. I have taken the liberty of removing Windows 95 > from my hard drive." - Hal -- ClientTech Online Solutions, Inc. "Peoplesoft Implementation Specialists" www.clienttech.com 800-404-2560 fax: 407-888-4841 From owner-sqr-users@list.iex.net Wed Apr 1 11:55:23 1998 Date: Wed, 1 Apr 1998 11:49:20 -0500 From: David Harper Subject: Re: Packed Fields It is possible Eric. You just have to convert the numbers(last digit) to EBCDIC. I have the routine to do that, would just have to find it. Can probably e-mail it to you tomorrow. Dave Harper -- ClientTech Online Solutions, Inc. "Peoplesoft Implementation Specialists" www.clienttech.com 800-404-2560 fax: 407-888-4841 Eric Gentz wrote: > > Hi, > > I need to write an interface to one of our state agencies. Their format > requires packed fields. I am wondering if this is possible to do within SQR. > > Thank you in advance. > > Eric > > Eric Gentz Interested in a real operating system? > UW Hospital & Clinics > 610 N. Whitney Way Because HAL doesn't run Windows 95. > Madison, WI 53705 Join the Mac Evangelist. > 608-263-9345 > ej.gentz@hosp.wisc.edu > -------------------------------------- > "You can twist perceptions, but reality won't budge." -- Neal Peart > "Good morning, doctors. I have taken the liberty of removing Windows 95 > from my hard drive." - Hal Eric Gentz wrote: > > Hi, > > I need to write an interface to one of our state agencies. Their format > requires packed fields. I am wondering if this is possible to do within SQR. > > Thank you in advance. > > Eric > > Eric Gentz Interested in a real operating system? > UW Hospital & Clinics > 610 N. Whitney Way Because HAL doesn't run Windows 95. > Madison, WI 53705 Join the Mac Evangelist. > 608-263-9345 > ej.gentz@hosp.wisc.edu > -------------------------------------- > "You can twist perceptions, but reality won't budge." -- Neal Peart > "Good morning, doctors. I have taken the liberty of removing Windows 95 > from my hard drive." - Hal -- ClientTech Online Solutions, Inc. "Peoplesoft Implementation Specialists" www.clienttech.com 800-404-2560 fax: 407-888-4841 From owner-sqr-users@list.iex.net Wed Apr 1 11:58:05 1998 Date: Wed, 1 Apr 1998 08:44:30 -0800 From: Michael Lee Subject: Re: Packed Fields Eric, It seems that it may not be possible to do this using SQR. We developed an SQC that would create packed fields by doing a character by character translation. This part worked, but the SQR itself would interpret on the individual values as an end of record indicator and would write the record short. My organization contacted the software vendor (then MITI) and they admitted the bug but said that it wasn't high on their list to be fixed. The incorrect character that SQR incorrectly interprets as an end of record indicator in a packed field is a binary "15". So a dollar packed field with $1.50 in it or a whole number field with 150, etc. would cause this condition. The easiest way for us was to develop a program on the mainframe to do the conversion. There MAY be a way to do this however... If you run the SQR on the client, that would take care of the EOR problem I believe. But, it would produce a new problem, which is that you would have to send the file to the mainframe in binary mode, which would mean that all of the character fields would be garbage on the mainframe. However, you may be able to get around that by creating a couple of routines that would translate from ASCII to EBCDIC. If anyone else has any input on this subject, please add to it. I would like to know if ASCII to EBCDIC/Packed Comp-3 is possible for the mainframe using SQR. Michael K. Lee The Application Group, Inc. mlee@appgroup.com ej.gentz@HOSP.WISC.EDU on 04/01/98 06:44:38 AM Please respond to SQR-USERS@USA.NET To: SQR-USERS@list.iex.net cc: (bcc: Michael Lee/Application Group) Subject: Packed Fields Hi, I need to write an interface to one of our state agencies. Their format requires packed fields. I am wondering if this is possible to do within SQR. Thank you in advance. Eric Eric Gentz Interested in a real operating system? UW Hospital & Clinics 610 N. Whitney Way Because HAL doesn't run Windows 95. Madison, WI 53705 Join the Mac Evangelist. 608-263-9345 ej.gentz@hosp.wisc.edu -------------------------------------- "You can twist perceptions, but reality won't budge." -- Neal Peart "Good morning, doctors. I have taken the liberty of removing Windows 95 from my hard drive." - Hal From owner-sqr-users@list.iex.net Wed Apr 1 12:19:04 1998 Date: Wed, 1 Apr 1998 09:08:30 -0800 From: Michael Lee Subject: Re: Packed Fields #2 Forgot to add that my response is for Packed Comp-3. Packed Comp-3 poses a problem. If you just convert the last digit, I believe you are just handling the signed part. The rest of the number is still in question. Michael K. Lee The Application Group, Inc. mlee@appgroup.com davidh@CLIENTTECH.COM on 04/01/98 08:12:57 AM Please respond to SQR-USERS@USA.NET To: SQR-USERS@list.iex.net cc: (bcc: Michael Lee/Application Group) Subject: Re: Packed Fields It is possible Eric. You just have to convert the numbers(last digit) to EBCDIC. I have the routine to do that, would just have to find it. Can probably e-mail it to you tomorrow. Dave Harper -- ClientTech Online Solutions, Inc. "Peoplesoft Implementation Specialists" www.clienttech.com 800-404-2560 fax: 407-888-4841 Eric Gentz wrote: > > Hi, > > I need to write an interface to one of our state agencies. Their format > requires packed fields. I am wondering if this is possible to do within SQR. > > Thank you in advance. > > Eric > > Eric Gentz Interested in a real operating system? > UW Hospital & Clinics > 610 N. Whitney Way Because HAL doesn't run Windows 95. > Madison, WI 53705 Join the Mac Evangelist. > 608-263-9345 > ej.gentz@hosp.wisc.edu > -------------------------------------- > "You can twist perceptions, but reality won't budge." -- Neal Peart > "Good morning, doctors. I have taken the liberty of removing Windows 95 > from my hard drive." - Hal -- ClientTech Online Solutions, Inc. "Peoplesoft Implementation Specialists" www.clienttech.com 800-404-2560 fax: 407-888-4841 From owner-sqr-users@list.iex.net Wed Apr 1 12:32:28 1998 Date: Wed, 1 Apr 1998 11:22:47 -0500 From: Schiff Fred Subject: Re: Packed Fields From owner-sqr-users@list.iex.net Wed Apr 1 12:40:27 1998 Date: Wed, 1 Apr 1998 09:29:14 -0800 From: Michael Lee Subject: Forgot to add something concerning my last post on packed... Re-sending this message. Left a few things out. It may be easier to just write the COBOL program. I forgot to add that my response is for Packed Comp-3. Packed Comp-3 poses a problem. If you just convert the last digit, I believe you are just handling the signed part. The rest of the number is still in question. Michael K. Lee The Application Group, Inc. mlee@appgroup.com davidh@CLIENTTECH.COM on 04/01/98 08:12:57 AM Please respond to SQR-USERS@USA.NET To: SQR-USERS@list.iex.net cc: (bcc: Michael Lee/Application Group) Subject: Re: Packed Fields It is possible Eric. You just have to convert the numbers(last digit) to EBCDIC. I have the routine to do that, would just have to find it. Can probably e-mail it to you tomorrow. Dave Harper -- ClientTech Online Solutions, Inc. "Peoplesoft Implementation Specialists" www.clienttech.com 800-404-2560 fax: 407-888-4841 Eric Gentz wrote: > > Hi, > > I need to write an interface to one of our state agencies. Their format > requires packed fields. I am wondering if this is possible to do within SQR. > > Thank you in advance. > > Eric > > Eric Gentz Interested in a real operating system? > UW Hospital & Clinics > 610 N. Whitney Way Because HAL doesn't run Windows 95. > Madison, WI 53705 Join the Mac Evangelist. > 608-263-9345 > ej.gentz@hosp.wisc.edu > -------------------------------------- > "You can twist perceptions, but reality won't budge." -- Neal Peart > "Good morning, doctors. I have taken the liberty of removing Windows 95 > from my hard drive." - Hal -- ClientTech Online Solutions, Inc. "Peoplesoft Implementation Specialists" www.clienttech.com 800-404-2560 fax: 407-888-4841 From owner-sqr-users@list.iex.net Wed Apr 1 13:22:34 1998 Date: Wed, 1 Apr 1998 13:10:32 -0500 From: "Wanko, Christopher" Subject: Re: Packed Fields > I need to write an interface to one of our state agencies. Their format > requires packed fields. I am wondering if this is possible to do within SQR. Why do you believe this to be easier using SQR? Where does your data reside? -Chris From owner-sqr-users@list.iex.net Wed Apr 1 15:03:47 1998 Date: Wed, 1 Apr 1998 11:54:42 -0800 From: Barbara Wood Subject: XREF Command line Hi, Can anyone tell me what the command line looks like to execute XREF.SQT in Unix, and what the options might be? Thanks much, Barb From owner-sqr-users@list.iex.net Wed Apr 1 15:18:35 1998 Date: Thu, 2 Apr 1998 00:04:44 -0800 From: Barbara Wood Subject: Re: XREF Command line Barbara Wood wrote: > > Hi, > > Can anyone tell me what the command line looks like to execute > XREF.SQT in Unix, and what the options might be? > > Thanks much, > Barb Command line is "Heel! Sit! Stay!" Welcome... RWW From owner-sqr-users@list.iex.net Wed Apr 1 15:37:41 1998 Date: Wed, 1 Apr 1998 15:26:18 -0500 From: Terry Sexmith Subject: Re[2]: XREF Command line This is the second request for this information. Everytime we only get some rude response. Is there a polite, friendly, informed individual out there that can provide the answer. ______________________________ Reply Separator _________________________________ Subject: Re: XREF Command line Author: SQR-USERS@USA.NET at Internet Date: 4/2/98 12:04 AM Barbara Wood wrote: > > Hi, > > Can anyone tell me what the command line looks like to execute > XREF.SQT in Unix, and what the options might be? > > Thanks much, > Barb Command line is "Heel! Sit! Stay!" Welcome... RWW From owner-sqr-users@list.iex.net Wed Apr 1 15:55:24 1998 Date: Wed, 1 Apr 1998 15:44:34 -0500 From: Steve Krim Subject: Re: XREF Command line Barb, Change to where ever you have sqr installed, find the bin directory and go there. Now type in: sqr xref user/password -RT Follow the prompts and it should work. HTH, Steve At 11:54 AM 4/1/98 -0800, you wrote: > Hi, > > Can anyone tell me what the command line looks like to execute > XREF.SQT in Unix, and what the options might be? > > Thanks much, > Barb > From owner-sqr-users@list.iex.net Wed Apr 1 17:53:23 1998 Date: Wed, 1 Apr 1998 14:51:19 -0800 From: Barbara Wood Subject: Re: XREF Command line Thanks Steve -- that did the trick. I executed this in interactive mode, but I would like to use the batch mode. Does anyone know of or have information on the default file options' format (syntax)? -Barb ______________________________ Reply Separator _________________________________ Subject: Re: XREF Command line Author: Non-HP-SMKrim (SMKrim@TELEWEB.NET) at HP-PaloAlto,mimegw9 Date: 4/1/98 12:44 PM Barb, Change to where ever you have sqr installed, find the bin directory and go there. Now type in: sqr xref user/password -RT Follow the prompts and it should work. HTH, Steve At 11:54 AM 4/1/98 -0800, you wrote: > Hi, > > Can anyone tell me what the command line looks like to execute > XREF.SQT in Unix, and what the options might be? > > Thanks much, > Barb > From owner-sqr-users@list.iex.net Wed Apr 1 18:42:36 1998 Date: Wed, 1 Apr 1998 15:50:43 -0500 From: Fredrik S=84fstr=94m Subject: Re: Re[2]: XREF Command line Hi Terry, I don't know if there is anything special with Unix, but to run a precompiled report, specify the -RT flag on the command line. For example: SQR XREF.SQT [Connectivity] -RT -KEEP [Args ...] The connectivity differs depending on database platform, for Oracle this is '[Username]/[Password]@[Database]'... The -RT is to run a precompiled report and the -KEEP is to generate both XREF.LIS and XREF.SPF files. See the section about the command line in the manual for more information. /Bamse Terry Sexmith on 98-04-01 15:26:18 Please respond to SQR-USERS@USA.NET To: Multiple recipients of list SQR-USERS cc: (bcc: Fredrik Safstrom/PSDI) Subject: Re[2]: XREF Command line This is the second request for this information. Everytime we only get some rude response. Is there a polite, friendly, informed individual out there that can provide the answer. ______________________________ Reply Separator _________________________________ Subject: Re: XREF Command line Author: SQR-USERS@USA.NET at Internet Date: 4/2/98 12:04 AM Barbara Wood wrote: > > Hi, > > Can anyone tell me what the command line looks like to execute > XREF.SQT in Unix, and what the options might be? > > Thanks much, > Barb Command line is "Heel! Sit! Stay!" Welcome... RWW From owner-sqr-users@list.iex.net Wed Apr 1 21:11:29 1998 Date: Wed, 1 Apr 1998 19:34:02 -0500 From: Ray Ontko Subject: Re: Problem Printing Bar-codes on a HP Laserjet 5 John, > I am writing a maintenance work order document in SQR ver. 3 and trying to > print a bar-code of the work order number on the top of the cover page. > However, I am having problems getting it to print on a HP laserjet 5 > printer. In the report I declare and use a report layout that specifies > PRINTER-TYPE=HP. The report is compiled and run on a solaris UNIX box > which generates an LIS file which is routed to the HP through a UNIX > printer queue. Not only does the bar code not print it wipes out text > near it. My guess is that the problem is due to the printer control > characters being sent but I'm not sure how to solve the problem. Any > suggestions that anyone might have would be appreciated. Eventually, this > report will have to print on different HP printer models. > > Incidentally, I know the problem is not code related because if I compile > and run the report on a PC and print the output through Windows from an SPF > file the bar-code prints fine. Hmm. I have been able to use the bar-code feature on HP printers in the past. Are you able to use a simple program to print a sample bar code anywhere on a page? Are you using -printer:hp when you generate the .lis file? Ray ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Time for a new signature line." rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@list.iex.net Wed Apr 1 21:15:34 1998 Date: Thu, 2 Apr 1998 08:31:58 +0800 From: Wayne Ivory Subject: Re: XREF Command line This intrigued me because until the recent mention of xref I was unaware = of it=27s existence, and then I didn=27t know how to run an sqt. I = followed Steve=27s instructions and got it to run (on my Unix/Informix = platform you don=27t specify the user/password bit). I selected all = cross-reference types, but whichever sqr I ran it against it would chug = away for awhile, then get: 2503 - Internal array size not large enough. = Please refer to the manual under this error number. I presumed it was referring to the SQR manual, but 2503 is =22Unknown = qualifier for INPUT=22 so I guess it was referring to some other manual. Am I doomed to a life of never knowing true xref? Wayne Ivory Information Services Westralian Sands Limited >>> Steve Krim 2/4/98 4:44:34 am >>> Barb, Change to where ever you have sqr installed, find the bin directory and go there. Now type in: sqr xref user/password -RT Follow the prompts and it should work. HTH, Steve At 11:54 AM 4/1/98 -0800, you wrote: > Hi, > > Can anyone tell me what the command line looks like to execute > XREF.SQT in Unix, and what the options might be? > > Thanks much, > Barb > From owner-sqr-users@list.iex.net Wed Apr 1 21:29:09 1998 Date: Thu, 2 Apr 1998 11:02:18 +0730 From: Hee Kok Hwa Subject: What is QUERYARGS means ? Hello, I need help urgently. I am running SQR with the following environment 1. SQR: Structured Query Report Writer V2.27a 2. HP Unix 3. Oracle version 7 I have a program which has been running fine for more than more than one year. Now I have received the following error when I try to run the program (abc.sqr) to process data in Oracle Database as below : << ===== Start : execution log ===== >> $> more setting.para QUERYARGS = 65535 $> $> sqr abc / -msetting.para SQR: Structured Query Report Writer V2.27a Copyright (C) 1986-89 SQ Software All Rights Reserved Out of query arguments; use -Mfile to increase QUERYARGS $> << ===== End : execution log ===== >> When I tried to increase the value of QUERYARGS to any number greater than 65535 I received the following error : Maximum dimension for 'queryargs' in -Mfile is 65535. Is anyone know what is the QUERYARGS means? Where can I find the list of all parameter setting and what each of these means? How can I rectify this issue? Any hints or help is really appreciated. Anyway, thank for you time to finish this mail. Regards, KH Hee. CWT Distribution Ltd. TEL : (65) 2626-888 DID : (65) 2626-847 Fax : (65) 2622-116 Email : khhee@cwt.com.sg Web : http://www.cwt.com.sg From owner-sqr-users@list.iex.net Wed Apr 1 22:34:51 1998 Date: Wed, 1 Apr 1998 22:26:55 -0500 From: Ed Crotty Subject: Re: FoxPro to oracle I re-worked a perl library for reading .dbf's into a one-pass table creat= e = and sql-loader routine via a unix named pipe. I'm not sure if the pipe is available on all platforms, if not, you can cut out the pipe part (the= n = you have 2 copies of the data) but the perl part should work. Let me = know and I can post it to htttp://www.sqrug.com Ed Crotty BALR Corporation Oak Brook IL ecrotty@balr.com From owner-sqr-users@list.iex.net Wed Apr 1 22:50:15 1998 Date: Wed, 1 Apr 1998 15:57:00 PST From: "TORRES, JENNIFER" Subject: Re: Signatures Ray, Don't know if this will help. But... we are printing signatures on checks we are also running on a unix machine and using a HP Laserjet 5si. The only difference is we are using an EPS file for our signature file, rather than a HPGL file. We use EPS because all our output files are created in postscript format. NOTE: make sure to set FORMFEED=YES in declare-layout This is the code we use to print the signature: Print-image (70,#pos) type = eps-file source = $eps_file ! this is the full path where the eps file is located on the unix machine image-size = (19,8) J Torres Univeristy of Southern Colorado torres@uscolo.edu ---------- Your wrote: I posted a note a few weeks ago looking for some direction on how to print signatures on checks. I had a few responses but I am still struggling. We are tring to print the signature as an hpgl file on an HP5 printer. Also, our check printing program will be running in batch on a unix server. So far I have heard that sqr does not accept hpgl files but will accept hpgl2 files. Can anyone tell be were I can get an hpgl2 file to test? Does the image need to be stored on the printer? If anyone has had success with this or can suggest something please let me know. What has to be in place for this to work ? Thanks ************************* Ray Brunner rabrunne@syr.edu 443-9262 Syracuse University ************************* From owner-sqr-users@list.iex.net Wed Apr 1 23:07:58 1998 Date: Wed, 1 Apr 1998 21:39:43 -0500 From: Steve Krim Subject: Re: XREF Command line Barb, What I would do is run it in interactive mode first, and while you are running it, copy down the param's that you are entering. Then, use the same command line and append the params to the end of your command line. Additionally, you can put the param's in a file and refernce it using the @file notation(I believe, check the manual to be sure). Good luck, ---------------------------------------------------------------------- Steve Krim | SK Professional Services Inc. smkrim@teleweb.net | At 02:51 PM 4/1/98 -0800, you wrote: > Thanks Steve -- that did the trick. > > I executed this in interactive mode, but I would like to use the batch > mode. Does anyone know of or have information on the default file > options' format (syntax)? > > -Barb > > >______________________________ Reply Separator _________________________________ >Subject: Re: XREF Command line >Author: Non-HP-SMKrim (SMKrim@TELEWEB.NET) at HP-PaloAlto,mimegw9 >Date: 4/1/98 12:44 PM > > >Barb, > >Change to where ever you have sqr installed, find the bin directory and go >there. Now type in: >sqr xref user/password -RT > >Follow the prompts and it should work. > >HTH, > >Steve >At 11:54 AM 4/1/98 -0800, you wrote: >> Hi, >> >> Can anyone tell me what the command line looks like to execute >> XREF.SQT in Unix, and what the options might be? >> >> Thanks much, >> Barb >> > From owner-sqr-users@list.iex.net Wed Apr 1 23:54:47 1998 Date: Wed, 1 Apr 1998 23:43:17 -0500 From: David Anderson Subject: Re: What is QUERYARGS means ? This may be elementary, but is the allmax.max up to date? Have you made any changes to your environment since the last running of ABC.sqr? ---------- From: Hee Kok Hwa[SMTP:KOK-HWA_HEE/CWT_SYSTEMS@CWT.COM.SG] Sent: Wednesday, April 01, 1998 10:32 PM To: Multiple recipients of list SQR-USERS Subject: What is QUERYARGS means ? Hello, I need help urgently. I am running SQR with the following environment 1. SQR: Structured Query Report Writer V2.27a 2. HP Unix 3. Oracle version 7 I have a program which has been running fine for more than more than one year. Now I have received the following error when I try to run the program (abc.sqr) to process data in Oracle Database as below : << ===== Start : execution log ===== >> $> more setting.para QUERYARGS = 65535 $> $> sqr abc / -msetting.para SQR: Structured Query Report Writer V2.27a Copyright (C) 1986-89 SQ Software All Rights Reserved Out of query arguments; use -Mfile to increase QUERYARGS $> << ===== End : execution log ===== >> When I tried to increase the value of QUERYARGS to any number greater than 65535 I received the following error : Maximum dimension for 'queryargs' in -Mfile is 65535. Is anyone know what is the QUERYARGS means? Where can I find the list of all parameter setting and what each of these means? How can I rectify this issue? Any hints or help is really appreciated. Anyway, thank for you time to finish this mail. Regards, KH Hee. CWT Distribution Ltd. TEL : (65) 2626-888 DID : (65) 2626-847 Fax : (65) 2622-116 Email : khhee@cwt.com.sg Web : http://www.cwt.com.sg From owner-sqr-users@list.iex.net Thu Apr 2 00:03:00 1998 Date: Wed, 1 Apr 1998 23:43:17 -0500 From: David Anderson Subject: Re: What is QUERYARGS means ? This may be elementary, but is the allmax.max up to date? Have you made any changes to your environment since the last running of ABC.sqr? ---------- From: Hee Kok Hwa[SMTP:KOK-HWA_HEE/CWT_SYSTEMS@CWT.COM.SG] Sent: Wednesday, April 01, 1998 10:32 PM To: Multiple recipients of list SQR-USERS Subject: What is QUERYARGS means ? Hello, I need help urgently. I am running SQR with the following environment 1. SQR: Structured Query Report Writer V2.27a 2. HP Unix 3. Oracle version 7 I have a program which has been running fine for more than more than one year. Now I have received the following error when I try to run the program (abc.sqr) to process data in Oracle Database as below : << ===== Start : execution log ===== >> $> more setting.para QUERYARGS = 65535 $> $> sqr abc / -msetting.para SQR: Structured Query Report Writer V2.27a Copyright (C) 1986-89 SQ Software All Rights Reserved Out of query arguments; use -Mfile to increase QUERYARGS $> << ===== End : execution log ===== >> When I tried to increase the value of QUERYARGS to any number greater than 65535 I received the following error : Maximum dimension for 'queryargs' in -Mfile is 65535. Is anyone know what is the QUERYARGS means? Where can I find the list of all parameter setting and what each of these means? How can I rectify this issue? Any hints or help is really appreciated. Anyway, thank for you time to finish this mail. Regards, KH Hee. CWT Distribution Ltd. TEL : (65) 2626-888 DID : (65) 2626-847 Fax : (65) 2622-116 Email : khhee@cwt.com.sg Web : http://www.cwt.com.sg begin 600 WINMAIL.DAT M>)\^(AD$`0:0" `$```````!``$``0>0!@`(````Y 0```````#H``$(@ <` M& ```$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`0V ! `"`````@`"``$$ MD 8`4 (```(````,`````P``, ,````+``\.`0````(!_P\!````6@`````` M``"!*Q^DOJ,0&9UN`-T!#U0"```!`$UU;'1I<&QE(')E8VEP:65N=',@;V8@ M;&ES="!345(M55-%4E,`4TU44 !345(M55-%4E- ;&ES="YI97@N;F5T```` M'@`", $````%````4TU44 `````>``,P`0```!<```!345(M55-%4E- ;&ES M="YI97@N;F5T```#`!4,`0````,`_@\&````'@`!, $````F````375L=&EP M;&4@``(P`0````4```!33510```` M`!X``S !````$@```%-14BU54T524T!54T$N3D54`````P`5# $````#`/X/ M!@```!X``3 !````% ```"=345(M55-%4E- 55-!+DY%5"<``@$+, $````7 M````4TU44#I345(M55-%4E- 55-!+DY%5 ```P``.0`````+`$ Z`0````(! M]@\!````! ````````1[: $$@ $`'@```%)%.B!7:&%T(&ES(%%515)905)' M4R!M96%N M````4D4Z(%=H870@:7,@455%4EE!4D=3(&UE86YS(#\````"`7$``0```!8` M```!O5WQVG^2J_SNR;H1T9;M)&(*P0`````>`!X,`0````4```!33510```` M`!X`'PP!````& ```'-H96QB>38W0&-O;F-E;G1R:6,N;F5T``,`!A IBE4B M`P`'$.($```>``@0`0```&4```!42$E334%90D5%3$5-14Y405)9+$)55$E3 M5$A%04Q,34%834%855!43T1!5$4_2$%615E/54U!1$5!3EE#2$%.1T535$]9 M3U5214Y625)/3DU%3E1324Y#151(14Q!4U1254Y.``````(!"1 !````@04` M`'T%``"^"0``3%I&=;?&H*S_``H!#P(5`J0#Y 7K`H,`4!,#5 (`8V@*P'-E M=.XR!@`&PP*#,@/&!Q,"@[HS$PU]"H (SPG9.Q7_>#(U-0* "H$-L0M@;O!G M,3 S%" +"A+R# &B8P! (%1H! `@`, `>2!B92!E;&6G!X ", K >2P;8'4% M0%D;`71H&X '0&P`P'@B+AU!('5P',!O( !D871E/R @2/1A=AN >0A@&R$- ML!T`_FX;4!&Q&0`'D1WQ'N$%P*D)\'9I`V!N&](@`)!<;F,;@!S2"V!S!4!R MC'5N`P`9`"!O9A-P@$)#+G-Q0&,%0"U?)Y<*AR9+## G%D8#83H?*)XG%@R"'H )X"!+;P)K M'H!W85M3350`4#I+3TLM2%<`05](144O0U> 5%]365-4107@`D N(2Y#3TTN M4_Q'72@_*4T&8 (P*G\KB[I7"8!N!Y >(!PQ02<0"0,1,#$<0#$Y.3B1-/ P M.C,2(%!-+Y\9*4U4;S'?*XM-=6S^= 4@&[ B4 60!2 (D (P#P0@(N$DT"(Q M4U%2+6!54T524S7?,*YU?&)J)U$W_S+L$< <@U'"53OP64%21P7P!X#G!B(C MCR24,S8F%Q0B# $G)Q8L4!T@;RP*A4D@ZS/@"8 @'.!L'= (=")@)V ( M<$8140I0'"#Y!_!EL!'@\FD"(" W0@Q%T!' 'K'<82 G$0G 1U%W&O 1L/]1 M(00@&W )\")7)4 SX$C!_P7 !& 6`!S!`Y%4)PJ%`B#K'L%!H')'$$Y)$%$& M.F'<96D>L$8@2)UR`V %P/]2(%+A1=!+,!M0'?$B81S"JPJ%4:8H`:!C(T(I M'>)_)Q$AH 01'B%1@ N 3R9$/5R!8B(@'/%2HDD!(#KA0@P\/" ]7Z)+$0K M\P5 /I!E> 60''!/XA60DR+ 7Z0^/@J%)#Y4%/<1\3H`&0`N"K%-=D#X7^#R M-AA ,S5AYV'H(U$=`.E;0" O)X!M8M\%P$K/)TO?3.\(4'!Y!1!G:!D%0"A# M6Z U`#@V+;0X.6AQ408`(N!T+.#_5$$37W=%;D8@ M8&]A?'\*A4!P604(D%>!ADT=4 =P<+#?'A '<0"!3_%3XB=P(W"!O',G7+)Q M=1L!9,,N4#WG!" ?<57":VY6<5(@0)3?'-) _1Y@=V%406,#D470_U.1?60[ M0E56(O =$5&08V'_!X!J0F<%'V%&((1C0:!24>\BX1S17<&%Q4A6<8:3"H7[ M.F$Z`&99<1KR! $*4$']_D$?@1KP.M,%P$9#&P%R0;L=('!A<"<0.G$>,61' M$/^.L2S@'#%4XCH`_P> '>$*A5.1! !(BT/^>\)[70Y\G M-$(/0QX:-:2M!14A`*C0`````P`0$ `````#`!$0`````$ `!S# 0CFK\5V] K`4 `"## 0CFK\5V]`1X`/0`!````!0```%)%.B ``````P`--/TW``#)-%V] ` end From owner-sqr-users@list.iex.net Thu Apr 2 07:18:24 1998 Date: Thu, 2 Apr 1998 09:03:41 -0800 From: TUHINAROY Subject: Multiple Reports in SQRW Ver 2.5.7 ??? Hi, I'm working on SQR Version 2.5.7. This version does not support commands like Use-report, Declare-report, new-report etc. Is there any way I can generate more than 1 report from a single program using this version? TIA, Tuhina. From owner-sqr-users@list.iex.net Thu Apr 2 08:29:17 1998 Date: Thu, 2 Apr 1998 08:17:22 -0500 From: Ray Ontko Subject: Re: Multiple Reports in SQRW Ver 2.5.7 ??? Tuhina, > I'm working on SQR Version 2.5.7. This version does not support > commands like Use-report, Declare-report, new-report etc. > > Is there any way I can generate more than 1 report from a single > program using this version? I vaguely recall that although 2.5.7 does not support USE-REPORT, I thought that it did allow NEW-REPORT. If not, the only work-around that I can think of is to use OPEN and WRITE to format an output file of your own. Ray ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Time for a new signature line." rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@list.iex.net Thu Apr 2 09:43:18 1998 Date: Thu, 2 Apr 1998 06:29:14 -0800 From: Michael Lee Subject: Re: Multiple Reports in SQRW Ver 2.5.7 ??? If you are using versions below V3, you should open up multiple files and write to them. Unfortunately, if you have standard headers, similar to PeopleSoft's stdhdg1.sqc, etc..., you will not be able to use those. You will have to write your own headers. Furthermore, using the write function will not produce your printer tags on the top of the report. It is technically NOT a report, but a text file. Michael K. Lee The Application Group, Inc. mlee@appgroup.com TUHINAROY@INF.COM on 04/02/98 09:03:41 AM Please respond to SQR-USERS@USA.NET To: SQR-USERS@list.iex.net cc: (bcc: Michael Lee/Application Group) Subject: Multiple Reports in SQRW Ver 2.5.7 ??? Hi, I'm working on SQR Version 2.5.7. This version does not support commands like Use-report, Declare-report, new-report etc. Is there any way I can generate more than 1 report from a single program using this version? TIA, Tuhina. From owner-sqr-users@list.iex.net Thu Apr 2 09:47:45 1998 Date: Thu, 2 Apr 1998 08:31:08 -0500 From: Ray Ontko Subject: Re: What is QUERYARGS means ? KH Hee, It is true; QUERYARGS cannot be increased beyond 65535. QUERYARGS is an SQR initialization parameter which tells SQR how much space to reserve for arguments (bind variables) which appear in your BEGIN-SQL or BEGIN-SELECT statements. I'd be surprised if you have more than 65000 arguments to the SQL in your report program. Is it possible that you have a lot of SQL in #include files but your program only uses a few of the SQL statements? If so, I can suggest a work-around. Ray > Hello, > I need help urgently. I am running SQR with the following environment > 1. SQR: Structured Query Report Writer V2.27a > 2. HP Unix > 3. Oracle version 7 > > I have a program which has been running fine for more than more than > one year. Now I have received the following error when I try to run the > program (abc.sqr) to process data in Oracle Database as below : > > << ===== Start : execution log ===== >> > $> more setting.para > QUERYARGS = 65535 > $> > $> sqr abc / -msetting.para > SQR: Structured Query Report Writer V2.27a > Copyright (C) 1986-89 SQ Software All Rights Reserved > > Out of query arguments; use -Mfile to increase QUERYARGS > $> > << ===== End : execution log ===== >> > > When I tried to increase the value of QUERYARGS to any number greater > than 65535 I received the following error : > Maximum dimension for 'queryargs' in -Mfile is 65535. > > Is anyone know what is the QUERYARGS means? Where can I find the list > of all parameter setting and what each of these means? How can I > rectify this issue? > > Any hints or help is really appreciated. Anyway, thank for you time to > finish this mail. > > Regards, > KH Hee. > CWT Distribution Ltd. > TEL : (65) 2626-888 > DID : (65) 2626-847 > Fax : (65) 2622-116 > Email : khhee@cwt.com.sg > Web : http://www.cwt.com.sg > ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Time for a new signature line." rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@list.iex.net Thu Apr 2 12:28:47 1998 Date: Thu, 2 Apr 1998 11:45:13 -0500 From: Lee Subject: sqr3 version 4 Hi Gang, Anyone got a good lead on training classes on the eastern seaboard for SQR3 version4 ? I'm a DBA out here at the University of Virginia, so as much as I'd love to take a class in Hawaii, as an employee of the state, I gotta stay a bit closer to home. Thanks, Lee Pielemeier From owner-sqr-users@list.iex.net Thu Apr 2 12:40:24 1998 Date: Thu, 2 Apr 1998 12:08:46 -0800 From: Ken Gartman Subject: Re: sqr3 version 4 Lee wrote: > > Hi Gang, > Anyone got a good lead on training classes on the eastern seaboard for SQR3 > version4 ? I'm a DBA out here at the University of Virginia, so as much as > I'd love to take a class in Hawaii, as an employee of the state, I gotta > stay a bit closer to home. Thanks, Lee Pielemeier Hi, Lee! If there is a group of people that want to learn SQR, it might be cheaper to have a trainer come to your place. What is your current level of proficiency? Are there any experts at your place available for mentoring? What version of SQR do you have? What RDBMS? What operating system? Client/Server, or traditional (single node) configuration? Do you have the SQR documentation? It's amazing how much you can teach yourself by a little practice, and following the examples in the book! Happy computing, Ken Gartman From owner-sqr-users@list.iex.net Thu Apr 2 12:44:46 1998 Date: Thu, 2 Apr 1998 09:48:59 -0500 From: "Weaver, Judith R" Subject: Re: XREF Command line When I run this is interactive mode, all I get is garbage on screen. When I run it in batch mode, it works fine with the following workarounds: 1. I have to execute from my home directory, since it wants to write the reports where you run it and that's the only place I have write privileges. 2. I have to copy all the sqcs to my personal directory, since it cannot find them otherwise. 3. Even if I put the fully qualified name in the default file (xref.xdf), which is also in my home directory, it still asks me for the target file name. Any suggestions or comments? >---------- >From: Steve Krim[SMTP:SMKrim@TELEWEB.NET] >Reply To: SQR-USERS@USA.NET >Sent: Wednesday, April 01, 1998 9:39 PM >To: Multiple recipients of list SQR-USERS >Subject: Re: XREF Command line > >Barb, > >What I would do is run it in interactive mode first, and while you are >running it, copy down the param's that you are entering. Then, use the >same command line and append the params to the end of your command line. >Additionally, you can put the param's in a file and refernce it using the >@file notation(I believe, check the manual to be sure). > >Good luck, > >---------------------------------------------------------------------- >Steve Krim | SK Professional Services Inc. >smkrim@teleweb.net | > >At 02:51 PM 4/1/98 -0800, you wrote: >> Thanks Steve -- that did the trick. >> >> I executed this in interactive mode, but I would like to use the batch >> mode. Does anyone know of or have information on the default file >> options' format (syntax)? >> >> -Barb >> >> >>______________________________ Reply Separator >_________________________________ >>Subject: Re: XREF Command line >>Author: Non-HP-SMKrim (SMKrim@TELEWEB.NET) at HP-PaloAlto,mimegw9 >>Date: 4/1/98 12:44 PM >> >> >>Barb, >> >>Change to where ever you have sqr installed, find the bin directory and go >>there. Now type in: >>sqr xref user/password -RT >> >>Follow the prompts and it should work. >> >>HTH, >> >>Steve >>At 11:54 AM 4/1/98 -0800, you wrote: >>> Hi, >>> >>> Can anyone tell me what the command line looks like to execute >>> XREF.SQT in Unix, and what the options might be? >>> >>> Thanks much, >>> Barb >>> >> > From owner-sqr-users@list.iex.net Thu Apr 2 13:18:49 1998 Date: Thu, 2 Apr 1998 12:56:03 -0500 From: John Walker Subject: Re: Problem Printing Bar-codes on a HP Laserjet 5 Ray, What I forgot to include was that the SQT file was executed through an application called EMPAC. Based on yesterdays input from another reader of the SQR-USERS list I was able to isolate the problem back to the application. The problem is nothing to do with SQR. It seems like something in the way the application is executing/processing the SQT file is conflicting with the bar code printing. I am currently working with the vendor to understand what is going on. Thanks for everyone's help. On a side note is it always necessary to use -printer:hp when generating the .lis file as well as declaring PRINTER-TYPE=HP? Ray Ontko on 04/01/98 07:34:02 PM Please respond to SQR-USERS@USA.NET To: Multiple recipients of list SQR-USERS cc: (bcc: John A. Walker/CEI/FirstEnergy) Subject: Re: Problem Printing Bar-codes on a HP Laserjet 5 John, > I am writing a maintenance work order document in SQR ver. 3 and trying to > print a bar-code of the work order number on the top of the cover page. > However, I am having problems getting it to print on a HP laserjet 5 > printer. In the report I declare and use a report layout that specifies > PRINTER-TYPE=HP. The report is compiled and run on a solaris UNIX box > which generates an LIS file which is routed to the HP through a UNIX > printer queue. Not only does the bar code not print it wipes out text > near it. My guess is that the problem is due to the printer control > characters being sent but I'm not sure how to solve the problem. Any > suggestions that anyone might have would be appreciated. Eventually, this > report will have to print on different HP printer models. > > Incidentally, I know the problem is not code related because if I compile > and run the report on a PC and print the output through Windows from an SPF > file the bar-code prints fine. Hmm. I have been able to use the bar-code feature on HP printers in the past. Are you able to use a simple program to print a sample bar code anywhere on a page? Are you using -printer:hp when you generate the .lis file? Ray ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Time for a new signature line." rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@list.iex.net Thu Apr 2 14:07:17 1998 Date: Thu, 2 Apr 1998 12:32:38 -0500 From: "Gottdenker, Jay S" Subject: Multiple SQL Servers? Is it possible to write a SQR to query multiple SQL servers, or is there a library of some kind that provides this functionality? Both servers would be Sybase. OmniConnect may be an option, but I'd like to know if this can be accomplished with what is currently in place in my organization. Thanks, Jay Gottdenker jgottden@indiana.edu From owner-sqr-users@list.iex.net Thu Apr 2 15:01:25 1998 Date: Thu, 2 Apr 1998 12:23:14 -0500 From: Sam Spritzer Subject: Re: sqr3 version 4 -Reply Have you been to the SQRibe web site? There is a list of training partners, locations and dates there. http://www.SQRibe.com Sam From owner-sqr-users@list.iex.net Thu Apr 2 15:10:37 1998 Date: Thu, 2 Apr 1998 11:49:10 -0800 From: Barbara Wood Subject: Re: XREF Command line JR, Yes, I also got garbage when I was in interactive mode. But then I realized I was using Reflection 1 software for my connection to Unix. So.. I did a Start from windows, typed in 'telnet {your_server_address]', logged in, and was able to use interactive mode successfully. It is true about not be able to identify where the sqc directory resides -- bummer. And if you do copy over all your sqcs to your library, you get SQR error "2503 - Internal array size not large enough" when you run it with option 1. The only way to get around that one, is to remove the include modules from your directory, and try it again - but then your missing the include variable references. Still working on the batch mode myself. -Barb ______________________________ Reply Separator _________________________________ Subject: Re: XREF Command line Author: Non-HP-WeaverJR (WeaverJR@USAFOO.UNITEDSPACEALLIANCE.COM) at HP-PaloAlto,mimegw9 Date: 4/2/98 6:48 AM When I run this is interactive mode, all I get is garbage on screen. When I run it in batch mode, it works fine with the following workarounds: 1. I have to execute from my home directory, since it wants to write the reports where you run it and that's the only place I have write privileges. 2. I have to copy all the sqcs to my personal directory, since it cannot find them otherwise. 3. Even if I put the fully qualified name in the default file (xref.xdf), which is also in my home directory, it still asks me for the target file name. Any suggestions or comments? >---------- >From: Steve Krim[SMTP:SMKrim@TELEWEB.NET] >Reply To: SQR-USERS@USA.NET >Sent: Wednesday, April 01, 1998 9:39 PM >To: Multiple recipients of list SQR-USERS >Subject: Re: XREF Command line > >Barb, > >What I would do is run it in interactive mode first, and while you are >running it, copy down the param's that you are entering. Then, use the >same command line and append the params to the end of your command line. >Additionally, you can put the param's in a file and refernce it using the >@file notation(I believe, check the manual to be sure). > >Good luck, > >---------------------------------------------------------------------- >Steve Krim | SK Professional Services Inc. >smkrim@teleweb.net | > >At 02:51 PM 4/1/98 -0800, you wrote: >> Thanks Steve -- that did the trick. >> >> I executed this in interactive mode, but I would like to use the batch >> mode. Does anyone know of or have information on the default file >> options' format (syntax)? >> >> -Barb >> >> >>______________________________ Reply Separator >_________________________________ >>Subject: Re: XREF Command line >>Author: Non-HP-SMKrim (SMKrim@TELEWEB.NET) at HP-PaloAlto,mimegw9 >>Date: 4/1/98 12:44 PM >> >> >>Barb, >> >>Change to where ever you have sqr installed, find the bin directory and go >>there. Now type in: >>sqr xref user/password -RT >> >>Follow the prompts and it should work. >> >>HTH, >> >>Steve >>At 11:54 AM 4/1/98 -0800, you wrote: >>> Hi, >>> >>> Can anyone tell me what the command line looks like to execute >>> XREF.SQT in Unix, and what the options might be? >>> >>> Thanks much, >>> Barb >>> >> > From owner-sqr-users@list.iex.net Thu Apr 2 15:13:51 1998 Date: Thu, 2 Apr 1998 10:37:04 -0500 From: "Weaver, Judith R" Subject: Re: XREF Command line The batch file is called 'xref.xdf' and looks like this on our system: NAME = /opt/psofthr/sqr/npay6191.sqr ! Name of target file. VARIABLE = y ! (Y/N) Produce Variable Xref ? TABLE = y ! (Y/N) Produce Table Xref ? SIMPLE LIST = y ! (Y/N) Produce Variable List ? CREATE LINE NUM LISTING = y ! (Y/N) Produce Generate Original Listing File ? CASE SENSITIVITY = n ! (Y/N) Produce Include Case Sensitivity? WIDTH = 80 ! (132/80) Set Report Width to 132 or 80. ORDER BY = a ! (T/A) Order Report by Type or Alphabetically. >---------- >From: Barbara Wood[SMTP:BARBARA_WOOD@NON-HP-PALOALTO-OM13.OM.HP.COM] >Reply To: SQR-USERS@USA.NET >Sent: Wednesday, April 01, 1998 5:51 PM >To: Multiple recipients of list SQR-USERS >Subject: Re: XREF Command line > > Thanks Steve -- that did the trick. > > I executed this in interactive mode, but I would like to use the batch > mode. Does anyone know of or have information on the default file > options' format (syntax)? > > -Barb > > >______________________________ Reply Separator >_________________________________ >Subject: Re: XREF Command line >Author: Non-HP-SMKrim (SMKrim@TELEWEB.NET) at HP-PaloAlto,mimegw9 >Date: 4/1/98 12:44 PM > > >Barb, > >Change to where ever you have sqr installed, find the bin directory and go >there. Now type in: >sqr xref user/password -RT > >Follow the prompts and it should work. > >HTH, > >Steve >At 11:54 AM 4/1/98 -0800, you wrote: >> Hi, >> >> Can anyone tell me what the command line looks like to execute >> XREF.SQT in Unix, and what the options might be? >> >> Thanks much, >> Barb >> > From owner-sqr-users@list.iex.net Thu Apr 2 15:27:23 1998 Date: Thu, 2 Apr 1998 15:15:50 -0600 From: Jeff Smith Subject: printing superscript characters What is the best way to print characters in super-script in sqr. I'm thinking I probably need to do a print-direct with postscript commands or use printer codes. Does anyone know the proper postscript commands or HP printer codes ? From owner-sqr-users@list.iex.net Thu Apr 2 15:43:31 1998 Date: Thu, 2 Apr 1998 15:07:19 -0500 From: Greg Holliday Subject: Re: sqr3 version 4 I took a "Basic SQR" and "Advanced SQR" class from TUSC in Lombard, IL. They were good classes and the instructor was excellent. The address is: TUSC 377 E. Butterfield Road Suite 100 Lombard, IL 60148 Sorry, I couldn't find the phone number. Greg Holliday Programmer/Analyst Dodge/Rockwell Automation ggholliday@dodge.ra.rockwell.com From owner-sqr-users@list.iex.net Fri Apr 3 00:40:33 1998 Date: Thu, 2 Apr 1998 15:03:36 -0500 From: "Weaver, Judith R" Subject: Re: XREF Command line Thanks for the tip, I'll try it. (I'm also using Reflection1). As to the batch file, it works fine for me. It came as a sample (xref.xdf), see below. VARIABLE = y ! (Y/N) Produce Variable Xref ? TABLE = y ! (Y/N) Produce Table Xref ? SIMPLE LIST = y ! (Y/N) Produce Variable List ? CREATE LINE NUM LISTING = y ! (Y/N) Produce Generate Original Listing File ? CASE SENSITIVITY = n ! (Y/N) Produce Include Case Sensitivity? WIDTH = 80 ! (132/80) Set Report Width to 132 or 80. ORDER BY = t ! (T/A) Order Report by Type or Alphabetically. >---------- >From: Barbara Wood[SMTP:BARBARA_WOOD@NON-HP-PALOALTO-OM13.OM.HP.COM] >Reply To: SQR-USERS@USA.NET >Sent: Thursday, April 02, 1998 2:49 PM >To: Multiple recipients of list SQR-USERS >Subject: Re: XREF Command line > > JR, > > Yes, I also got garbage when I was in interactive mode. But then I > realized I was using Reflection 1 software for my connection to Unix. >So.. > I did a Start from windows, typed in 'telnet {your_server_address]', > logged in, and was able to use interactive mode successfully. > > It is true about not be able to identify where the sqc directory >resides > -- bummer. > > And if you do copy over all your sqcs to your library, you get SQR >error > "2503 - Internal array size not large enough" when you run it with >option > 1. The only way to get around that one, is to remove the include >modules > from your directory, and try it again - but then your missing the >include > variable references. > > Still working on the batch mode myself. > > -Barb > > >______________________________ Reply Separator >_________________________________ >Subject: Re: XREF Command line >Author: Non-HP-WeaverJR (WeaverJR@USAFOO.UNITEDSPACEALLIANCE.COM) at >HP-PaloAlto,mimegw9 >Date: 4/2/98 6:48 AM > > >When I run this is interactive mode, all I get is garbage on screen. >When I run it in batch mode, it works fine with the following >workarounds: >1. I have to execute from my home directory, since it wants to write the >reports where you run it and that's the only place I have write >privileges. >2. I have to copy all the sqcs to my personal directory, since it cannot >find them otherwise. >3. Even if I put the fully qualified name in the default file >(xref.xdf), which is also in my home directory, it still asks me for the >target file name. > >Any suggestions or comments? > >>---------- >>From: Steve Krim[SMTP:SMKrim@TELEWEB.NET] >>Reply To: SQR-USERS@USA.NET >>Sent: Wednesday, April 01, 1998 9:39 PM >>To: Multiple recipients of list SQR-USERS >>Subject: Re: XREF Command line >> >>Barb, >> >>What I would do is run it in interactive mode first, and while you are >>running it, copy down the param's that you are entering. Then, use the >>same command line and append the params to the end of your command line. >>Additionally, you can put the param's in a file and refernce it using the >>@file notation(I believe, check the manual to be sure). >> >>Good luck, >> >>---------------------------------------------------------------------- >>Steve Krim | SK Professional Services Inc. >>smkrim@teleweb.net | >> >>At 02:51 PM 4/1/98 -0800, you wrote: >>> Thanks Steve -- that did the trick. >>> >>> I executed this in interactive mode, but I would like to use the batch >>> mode. Does anyone know of or have information on the default file >>> options' format (syntax)? >>> >>> -Barb >>> >>> >>>______________________________ Reply Separator >>_________________________________ >>>Subject: Re: XREF Command line >>>Author: Non-HP-SMKrim (SMKrim@TELEWEB.NET) at HP-PaloAlto,mimegw9 >>>Date: 4/1/98 12:44 PM >>> >>> >>>Barb, >>> >>>Change to where ever you have sqr installed, find the bin directory and go >>>there. Now type in: >>>sqr xref user/password -RT >>> >>>Follow the prompts and it should work. >>> >>>HTH, >>> >>>Steve >>>At 11:54 AM 4/1/98 -0800, you wrote: >>>> Hi, >>>> >>>> Can anyone tell me what the command line looks like to execute >>>> XREF.SQT in Unix, and what the options might be? >>>> >>>> Thanks much, >>>> Barb >>>> >>> >> > From owner-sqr-users@list.iex.net Fri Apr 3 01:26:38 1998 Date: Thu, 2 Apr 1998 13:34:50 -0500 From: Ray Ontko Subject: Re: Problem Printing Bar-codes on a HP Laserjet 5 John, Yes, if you want to use PRINTER-TYPE=HP, you'll have to use -printer:hp to generate the proper lis file. I'm familiar with E-MPAC. In the case of E-MPAC, I believe it only produces a plain-text file so that you can view it on-line using their built-in viewer. Ray > Ray, > > What I forgot to include was that the SQT file was executed through an > application called EMPAC. > Based on yesterdays input from another reader of the SQR-USERS list I was > able to isolate the > problem back to the application. The problem is nothing to do with SQR. It > seems like something in the > way the application is executing/processing the SQT file is conflicting > with the bar code printing. I am > currently working with the vendor to understand what is going on. > > Thanks for everyone's help. > > On a side note is it always necessary to use -printer:hp when generating > the .lis file as well as > declaring PRINTER-TYPE=HP? > > > > > > > Ray Ontko on 04/01/98 07:34:02 PM > > Please respond to SQR-USERS@USA.NET > > To: Multiple recipients of list SQR-USERS > cc: (bcc: John A. Walker/CEI/FirstEnergy) > Subject: Re: Problem Printing Bar-codes on a HP Laserjet 5 > > > > > John, > > I am writing a maintenance work order document in SQR ver. 3 and trying > to > > print a bar-code of the work order number on the top of the cover page. > > However, I am having problems getting it to print on a HP laserjet 5 > > printer. In the report I declare and use a report layout that specifies > > PRINTER-TYPE=HP. The report is compiled and run on a solaris UNIX box > > which generates an LIS file which is routed to the HP through a UNIX > > printer queue. Not only does the bar code not print it wipes out text > > near it. My guess is that the problem is due to the printer control > > characters being sent but I'm not sure how to solve the problem. Any > > suggestions that anyone might have would be appreciated. Eventually, > this > > report will have to print on different HP printer models. > > > > Incidentally, I know the problem is not code related because if I compile > > and run the report on a PC and print the output through Windows from an > SPF > > file the bar-code prints fine. > Hmm. I have been able to use the bar-code feature on HP > printers in the past. Are you able to use a simple > program to print a sample bar code anywhere on a page? > Are you using -printer:hp when you generate the .lis file? > Ray > ---------------------------------------------------------------------- > Ray Ontko | Ray Ontko & Co | "Time for a new signature line." > rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ > ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Time for a new signature line." rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@list.iex.net Fri Apr 3 01:41:34 1998 Date: Fri, 3 Apr 1998 11:16:10 -0800 From: TUHINAROY Subject: sort file contents Thanx..U R right. It does support New-Report. I had got the syntax wrong. The only problem is I cant have different headers in begin-headng section when I use New-Report. ______________________________ Reply Separator _________________________________ Subject: Re: Multiple Reports in SQRW Ver 2.5.7 ??? Author: Ray Ontko at smtp_gw Date: 4/2/98 8:17 AM Tuhina, > I'm working on SQR Version 2.5.7. This version does not support > commands like Use-report, Declare-report, new-report etc. > > Is there any way I can generate more than 1 report from a single > program using this version? I vaguely recall that although 2.5.7 does not support USE-REPORT, I thought that it did allow NEW-REPORT. If not, the only work-around that I can think of is to use OPEN and WRITE to format an output file of your own. Ray ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Time for a new signature line." rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@list.iex.net Fri Apr 3 01:41:34 1998 Date: Fri, 3 Apr 1998 11:15:28 -0800 From: TUHINAROY Subject: sort file contents Hi, I need to read a file and sort its contents based on one of the fields and print them. I dont think there's any command in SQR which would help me do this(like we have internal sort in Cobol). Can anyone tell me how it can be done? TIA Tuhina. ______________________________ Reply Separator _________________________________ Subject: Re: Multiple Reports in SQRW Ver 2.5.7 ??? Author: Ray Ontko at smtp_gw Date: 4/2/98 8:17 AM Tuhina, > I'm working on SQR Version 2.5.7. This version does not support > commands like Use-report, Declare-report, new-report etc. > > Is there any way I can generate more than 1 report from a single > program using this version? I vaguely recall that although 2.5.7 does not support USE-REPORT, I thought that it did allow NEW-REPORT. If not, the only work-around that I can think of is to use OPEN and WRITE to format an output file of your own. Ray ---------------------------------------------------------------------- Ray Ontko | Ray Ontko & Co | "Time for a new signature line." rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ From owner-sqr-users@list.iex.net Fri Apr 3 08:37:47 1998 Date: Fri, 3 Apr 1998 08:32:03 -0500 From: Ray Brunner Subject: Signature update I have recieved several responses to my request for information on printing signatures. I appreciate the input. I have not been able as of yet to get the hpgl signature graphic to print on our HP5 printer. I have been able to get a signature to print using an eps file and postscript, but then the micr doesn't print. We are going to try and download the signature to the printers memory before printing the checks to see if that works. Have not been able as of yet to find a program that will do it for us. Does anyone know how to do this? Also, does sqr require an hpgl2 file and not hpgl? Thanks again, ************************* Ray Brunner rabrunne@syr.edu 443-9262 Syracuse University ************************* From owner-sqr-users@list.iex.net Fri Apr 3 09:16:28 1998 Date: Fri, 3 Apr 1998 09:13:56 -0500 From: Eli Collier Subject: SQR Viewer in a PeopleSoft Environment Does anyone have any knowledge of using SQR Viewer in a Peoplesoft Environment with Windows NT? We cannot get it to print landscape correctly without cutting off a 1/3 of the document. Eli _________________________________________________________ Eli Collier < 0000,0000,ffffPeopleffff,0000,0000Soft Implementation Team ph 703.645.5110 From owner-sqr-users@list.iex.net Fri Apr 3 09:56:07 1998 Date: Fri, 3 Apr 1998 09:44:57 -0500 From: YMCKINNE Subject: Evaluate Hi, I was wondering if anyone could help me. I was wondering what is the logic behind the break command in an EVALUATE statement. Within the evaluate statement, I issue a break command. Does the break command take you back out to the begin-program section or does it let you continue within the local procedure? For example, I have this in my local procedure: move '' to $product_line do cust_line do grand_dig_fin_tot In my evaluate statement I have: when = 'OT' do select_unearned_rev do earned_rev do deal_pass when-other break Since '' != $product_line, does the break take me back to my local procedure or back to the begin-program section? Any help is appreciated. Thanks Yolanda From owner-sqr-users@list.iex.net Fri Apr 3 09:59:22 1998 Date: Fri, 3 Apr 1998 09:48:45 -0500 From: Nathan Treadway Subject: Re: Multiple Reports in SQRW Ver 2.5.7 ??? > Thanx..U R right. It does support New-Report. I had got the syntax > wrong. The only problem is I cant have different headers in > begin-headng section when I use New-Report. You can't have differently-sized headers on the different reports (both will reserve the same number of lines at the top of the page, since you have only one "begin-heading NN" line). However, you can set a flag in your program to indicate which report you are printing, and then check that flag with an IF statement in the begin-heading section. This will let you put completely different data, formatting, etc. in the headings of the two reports. Nathan ---------------------------------------------------------------------------- Nathan Treadway | Ray Ontko & Co. | Software consulting services nathant@ontko.com | Richmond, IN | http://www.ontko.com/ From owner-sqr-users@list.iex.net Fri Apr 3 10:17:03 1998 Date: Fri, 3 Apr 1998 10:14:32 -0500 From: David Harper Subject: Re: Evaluate The break takes you to the end-evaluate statement. YMCKINNE wrote: > > Hi, > > I was wondering if anyone could help me. > > I was wondering what is the logic behind the break command in an > EVALUATE statement. Within the evaluate statement, I issue a break > command. Does the break command take you back out to the > begin-program section or does it let you continue within the local > procedure? > > For example, I have this in my local procedure: > > move '' to $product_line > do cust_line > do grand_dig_fin_tot > > In my evaluate statement I have: > > when = 'OT' > do select_unearned_rev > do earned_rev > do deal_pass > when-other > break > > Since '' != $product_line, does the break take me back to my local > procedure or back to the begin-program section? > > Any help is appreciated. > > Thanks > > Yolanda -- ClientTech Online Solutions, Inc. "Peoplesoft Implementation Specialists" www.clienttech.com 800-404-2560 fax: 407-888-4841 From owner-sqr-users@list.iex.net Fri Apr 3 10:26:03 1998 Date: Fri, 3 Apr 1998 10:22:59 -0500 From: "Simonian, Guy" Subject: Begin-Select performance using 4 table Join Am running SQR V3.0.18.1 in a Sybase 11 environment. The SQR client is on SunOS 5.5.1 and also on WinNT. Sybase is under SunOS 5.5.1 It takes over a minute for my query to find 1 join from the database, yet if I take the exact same SQL and run it from ISQL or RapidSQL, it takes about 3 seconds! I've tried the -rs and -rt SQR options to run the compiled report, but the results are the same. ISQL: ------------------------------------------------------------------------ ---------------- select HRUTEST..PS_PDS_TRX_FACT.TRX_KEY, PLAN_YR, GROUP_INDIV_CODE from HRUTEST..PS_PDS_TRX_FACT,HRUTEST..PS_PDS_PRODUCT, HRUTEST..PS_PDS_POL_CASE, HRUTEST..PS_PDS_PAYROLL where HRUTEST..PS_PDS_TRX_FACT.AA_KEY = 4000 and HRUTEST..PS_PDS_TRX_FACT.PAYEE_PARTY_KEY = HRUTEST..PS_PDS_TRX_FACT.PRODUCER_PARTY_KEY and HRUTEST..PS_PDS_PRODUCT.PRODUCT_KEY = HRUTEST..PS_PDS_TRX_FACT.PRODUCT_KEY and HRUTEST..PS_PDS_POL_CASE.POLICY_CASE_KEY = HRUTEST..PS_PDS_TRX_FACT.POLICY_KEY and HRUTEST..PS_PDS_TRX_FACT.PAYROLL_KEY = HRUTEST..PS_PDS_PAYROLL.PAYROLL_KEY and 4000 = HRUTEST..PS_PDS_PAYROLL.DISBURSEMENT_KEY returns 3 rows in 2 seconds SQR SOURCE: ------------------------------------------------------------------------ ------------------------- !------------------------------------------------------------/ ! P R O C E D U R E xfer.grp.ind / !------------------------------------------------------------/ begin-procedure xfer.grp.ind #debug show '@xfer.grp.ind, key, aa codes ' &AGY_AGT_KEY #debug show '@xfer.grp.ind, DISB key, ' #DISBURSEMENT_KEY begin-select on-error=stmnt-bad-exec {FACT}.TRX_KEY &TRX_KEY PLAN_YR &PLAN_YR GROUP_INDIV_CODE &GROUP_INDIV_CODE let $detail.PLAN_YR = &PLAN_YR let #TRX_KEY = &TRX_KEY if &PLAN_YR = '1' if &GROUP_INDIV_CODE= 'I' let $sub_section='' else let $sub_section='' end-if else if &GROUP_INDIV_CODE= 'I' let $sub_section='' else let $sub_section='' end-if end-if #debug show '@xfer.grp.ind FOUND ONE XXXXXXXXXXXXXXXX' &TRX_KEY let #event.type = #event.type + 1 do xfer.policy.comp.type from {FACT},{PRODUCT}, {POL_CASE}, {PAYROLL} where {FACT}.AA_KEY = &AGY_AGT_KEY and {FACT}.PAYEE_PARTY_KEY = {FACT}.PRODUCER_PARTY_KEY and {PRODUCT}.PRODUCT_KEY = {FACT}.PRODUCT_KEY and {POL_CASE}.POLICY_CASE_KEY = {FACT}.POLICY_KEY and {FACT}.PAYROLL_KEY = {PAYROLL}.PAYROLL_KEY and #DISBURSEMENT_KEY = {PAYROLL}.DISBURSEMENT_KEY end-select end-procedure ------------------------------------------------------------------------ ----------------------- This procedure takes over a minute to find the first record. From owner-sqr-users@list.iex.net Fri Apr 3 10:31:39 1998 Date: Fri, 3 Apr 1998 10:25:28 -0500 From: Scott Self Subject: Re: Evaluate Yolanda, The "break" statement in an EVALUATE causes an immediate exit from the EVALUATE only. So you will continue on the first line after the END-EVALUTE statement. Example: -------- let $foo = 'bar' evaluate $foo when = 'bar' move 1 to #count break when = 'rab' move 2 to #count break end-evaluate show #count ! program continues here and #count = 1 -------- Hope this helps, Scott Hi, I was wondering if anyone could help me. I was wondering what is the logic behind the break command in an EVALUATE statement. Within the evaluate statement, I issue a break command. Does the break command take you back out to the begin-program section or does it let you continue within the local procedure? For example, I have this in my local procedure: move '' to $product_line do cust_line do grand_dig_fin_tot In my evaluate statement I have: when = 'OT' do select_unearned_rev do earned_rev do deal_pass when-other break Since '' != $product_line, does the break take me back to my local procedure or back to the begin-program section? Any help is appreciated. Thanks Yolanda From owner-sqr-users@list.iex.net Fri Apr 3 10:34:16 1998 Date: Fri, 3 Apr 1998 13:29:54 -0800 From: TUHINAROY Subject: How to sort file contents ? Hi, I need to read a file and sort its contents based on one of the fields and print them. I dont think there's any command in SQR which would help me do this(like we have internal sort in Cobol). Can anyone tell me how it can be done? TIA Tuhina. From owner-sqr-users@list.iex.net Fri Apr 3 10:40:52 1998 Date: Fri, 3 Apr 1998 10:27:58 -0500 From: Don Mellen Subject: Re: sort file contents There are a few ways it can be done. You could read the lines into an array and write a procedure to sort the array. An example of an array sort procedure was posted by Rob Goshko not too long ago (Hi, Rob). You can find it in the archives at: http://www.sqrug.com/~sqrusers/hypermail/ Or you could use a series of OS commands (such as Unix's sort command) to create a presorted file that you can them simply read in. HTH, Don On Fri, 3 Apr 1998, TUHINAROY wrote: > Hi, > > I need to read a file and sort its contents based on one of the fields and > print them. I dont think there's any command in SQR which would help me do > this(like we have internal sort in Cobol). Can anyone tell me how it can be > done? > > TIA > Tuhina. > ______________________________ Reply Separator _________________________________ > Subject: Re: Multiple Reports in SQRW Ver 2.5.7 ??? > Author: Ray Ontko at smtp_gw > Date: 4/2/98 8:17 AM > > > Tuhina, > > > I'm working on SQR Version 2.5.7. This version does not support > > commands like Use-report, Declare-report, new-report etc. > > > > Is there any way I can generate more than 1 report from a single > > program using this version? > > I vaguely recall that although 2.5.7 does not support USE-REPORT, > I thought that it did allow NEW-REPORT. If not, the only work-around > that I can think of is to use OPEN and WRITE to format an output > file of your own. > > Ray > ---------------------------------------------------------------------- > Ray Ontko | Ray Ontko & Co | "Time for a new signature line." > rayo@ontko.com | Richmond, In | See us at http://www.ontko.com/ > ----------------------------------------------------------------------- Donald Mellen | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/ donm@ontko.com | "In the beginning, there was nothing, which exploded" From owner-sqr-users@list.iex.net Fri Apr 3 11:05:37 1998 Date: Fri, 3 Apr 1998 10:59:39 -0500 From: Nathan Treadway Subject: Re: Evaluate > command. Does the break command take you back out to the > begin-program section or does it let you continue within the local > procedure? The BREAK command breaks out of the inner-most EVALUATE or BEGIN-WHILE loop. It will never cause you to exit all the way out of a procedure (unless, of course, there's nothing between the end of the EVALUATE or WHILE loop and the END-PROCEDURE). Note that you don't actually NEED the break in the EVALUATE ... WHEN section, but it's usually a good idea to have it. If you leave it out, SQR will spend time evaluating all the other WHEN conditions, and in most cases EVALUTES are designed so that only one condition ever matches. Here's an example where more than one condition may match: move 3 to #n evaluate #n when = 3 when = 1 show '#n is odd' when = 4 when = 2 show '#n is even' when > 4 show '#n > 4' when > 3 show '#n > 3' when > 2 show '#n > 2' when > 1 show '#n > 1' end-evaluate will print #n is odd #n > 2 #n > 1 Nathan ---------------------------------------------------------------------------- Nathan Treadway | Ray Ontko & Co. | Software consulting services nathant@ontko.com | Richmond, IN | http://www.ontko.com/ From owner-sqr-users@list.iex.net Fri Apr 3 13:09:15 1998 Date: Fri, 3 Apr 1998 09:26:29 -0500 From: "Weaver, Judith R" Subject: Re: SQR Viewer in a PeopleSoft Environment It does the same thing in Windows 95 and I havn't figured out how to fix it. >---------- >From: Eli Collier[SMTP:ecollier@WINSTAR.COM] >Reply To: SQR-USERS@USA.NET >Sent: Friday, April 03, 1998 9:13 AM >To: Multiple recipients of list SQR-USERS >Subject: SQR Viewer in a PeopleSoft Environment > >Does anyone have any knowledge of using SQR Viewer in a Peoplesoft >Environment with Windows NT? > > >We cannot get it to print landscape correctly without cutting off a 1/3 of >the document. > > > >Eli > >_________________________________________________________ > >Eli Collier < > >0000,0000,ffffPeopleffff,0000,000 >0Soft >Implementation Team > >ph 703.645.5110 > From owner-sqr-users@list.iex.net Fri Apr 3 13:48:24 1998 Date: Fri, 3 Apr 1998 13:44:16 -0500 From: "Simonian, Guy" Subject: Use of Sybase text datatype is recognized as char datatype! Am trying to write to a Sybase "text" datatype which is supposed to hold up to 2 gig of ascii data, yet the errors I get indicate that Sybase thinks its getting char data; begin-setup begin-sql on-error=SKIP create table {DETAILDB} (out_line text null) end-sql end-setup begin-procedure main let $abc = '1234567...300 characters of data....' begin-sql insert into {DETAILDB} (out_line) values ($abc) end-sql end-procedure -------When I run this, I get the following bind errors. It looks like SQR is passing char data, even though the field is defined as type text.: -------------------------- (SQR 5528) Sybase dbbind: ct_param error in cursor 119: (138) ct_param(): user api layer: external error: A data length of 300 exceeds the maximum length allowed for CHAR data. (SQR 5528) Sybase ct_send error in cursor 119: (138) ct_param(): user api layer: external error: A data length of 300 exceeds the maximum length allowed for CHAR data. SQL: insert into tempdb..detail (out_line) values (@__p1) Error on line 155: (SQR 3734) Couldn't compile SQL. SQRW: Program Aborting. Am running SQR V3.0.18.1 in a Sybase 11 environment. The SQR client is on SunOS 5.5.1 and also on WinNT. Sybase is under SunOS 5.5.1 From owner-sqr-users@list.iex.net Fri Apr 3 14:05:17 1998 Date: Fri, 3 Apr 1998 10:05:47 -0600 From: Jeff Smith Subject: Re: Evaluate YMCKINNE wrote: > > Hi, > > I was wondering if anyone could help me. > > I was wondering what is the logic behind the break command in an > EVALUATE statement. Within the evaluate statement, I issue a break > command. Does the break command take you back out to the > begin-program section or does it let you continue within the local > procedure? > > For example, I have this in my local procedure: > > move '' to $product_line > do cust_line > do grand_dig_fin_tot > > In my evaluate statement I have: > > when = 'OT' > do select_unearned_rev > do earned_rev > do deal_pass > when-other > break > > Since '' != $product_line, does the break take me back to my local > procedure or back to the begin-program section? > > Any help is appreciated. > > Thanks > > Yolanda You should put a break statement at the end of each condition of the evaluate statement. When the break statement is reached the program will continue to the next line after the end-evaluate statement. From owner-sqr-users@list.iex.net Fri Apr 3 15:21:27 1998 Date: Fri, 3 Apr 1998 15:02:18 -0800 From: Ken Gartman Subject: Re: Use of Sybase text datatype is recognized as char datatype! Simonian, Guy wrote: > > Am trying to write to a Sybase "text" datatype which is supposed to hold > up > to 2 gig of ascii data, yet the errors I get indicate that Sybase thinks > its getting char data; > > begin-setup > begin-sql on-error=SKIP > create table {DETAILDB} (out_line text null) > end-sql > end-setup > > begin-procedure main > let $abc = '1234567...300 characters of data....' > begin-sql > insert into {DETAILDB} (out_line) values ($abc) > end-sql > end-procedure > > -------When I run this, I get the following bind errors. It looks like > SQR is passing char data, even though the field is defined as type > text.: > -------------------------- > (SQR 5528) Sybase dbbind: ct_param error in cursor 119: > (138) ct_param(): user api layer: external error: A data length of > 300 exceeds the maximum length allowed for CHAR data. > (SQR 5528) Sybase ct_send error in cursor 119: > (138) ct_param(): user api layer: external error: A data length of > 300 exceeds the maximum length allowed for CHAR data. > > SQL: insert into tempdb..detail (out_line) values (@__p1) > > Error on line 155: > (SQR 3734) Couldn't compile SQL. > > SQRW: Program Aborting. > > Am running SQR V3.0.18.1 in a Sybase 11 environment. The SQR client is > on SunOS 5.5.1 and also on WinNT. Sybase is under SunOS 5.5.1 Hi, Guy! Let's use a multi-step approach to debug this one. Thus we can isolate the problem into a smaller area of confusion. 1. Create your table outside of SQR. After you create it, verify its structure. Are the table name, column name, and column data type correct? 2. Directly at the data base level, insert a constant into the table, with a SQL statement such as: INSERT INTO GUY_TEMP_1 (OUT_LINE) VALUES ('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIJJJJJJJJJJJJJJJJJJ') ; 4. Do you get the expected results? COMMIT ; SELECT * FROM GUY_TEMP_1 ; Do you once again get the expected results? insert into {DETAILDB} (out_line) values ($abc) 5. If all is well, code a small, simple SQR: BEGIN-PROGRAM DO INSERTS END-PROGRAM BEGIN-PROCEDURE INSERTS BEGIN-SQL INSERT INTO GUY_TEMP_1 (OUT_LINE) VALUES ('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIJJJJJJJJJJJJJJJJJJ') ; COMMIT ; END-SQL END-PROCEDURE INSERTS 6. Execute your program with the -E and -S flags: SQR INSERT-PROGRAM.SQR -E -S Do you get any errors now? I doubt that you will, but if so, the file INSERT-PROGRAM.ERR should have the details. 7. Code up a program that uses variables: BEGIN-PROGRAM DO INSERTS END-PROGRAM BEGIN-PROCEDURE INSERTS LET $long-string = 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIJJJJJJJJJJJJJJJJJJ' BEGIN-SQL INSERT INTO GUY_TEMP_1 (OUT_LINE) VALUES ( $long-string ) ; COMMIT ; END-SQL END-PROCEDURE INSERTS 8. Execute as before. Any errors? I guess this the step most likely to have errors. Look up any errors in the SQR documentation. 9. At the database level, once again check the results: SELECT * FROM GUY_TEMP_1 ; Good luck, and happy computing Ken Gartman From owner-sqr-users@list.iex.net Fri Apr 3 15:21:27 1998 Date: Fri, 3 Apr 1998 14:56:44 -0500 From: Ignacio Lulli Subject: Re: Evaluate --0__=TT5DhAZGtPHiWSiZCR0Dy8sptrVc79DcZub4d3T2ddmTwB1lE93dy0w7 Content-type: text/plain; charset=us-ascii The break command merely takes you out of the evaluate statement. Processing continues after the end-evaluate statement. -Ignacio (Embedded image moved YMCKINNE to file: 04/03/98 06:44 AM PIC14134.PCX) Please respond to SQR-USERS@USA.NET To: Multiple recipients of list SQR-USERS cc: (bcc: Ignacio Lulli) Subject: Evaluate Hi, I was wondering if anyone could help me. I was wondering what is the logic behind the break command in an EVALUATE statement. Within the evaluate statement, I issue a break command. Does the break command take you back out to the begin-program section or does it let you continue within the local procedure? For example, I have this in my local procedure: move '' to $product_line do cust_line do grand_dig_fin_tot In my evaluate statement I have: when = 'OT' do select_unearned_rev do earned_rev do deal_pass when-other break Since '' != $product_line, does the break take me back to my local procedure or back to the begin-program section? Any help is appreciated. Thanks Yolanda --0__=TT5DhAZGtPHiWSiZCR0Dy8sptrVc79DcZub4d3T2ddmTwB1lE93dy0w7 Content-type: application/octet-stream; name="PIC14134.PCX" Content-transfer-encoding: base64 CgUBCAAAAABoACwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAABaQABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAD1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPH E8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sT zRPHE8MTwhPwEwzIBgzYE8wTxhPDE8IT7hPOBtcTzBPGE8MTE+wTwgbCBwbCEgbCEgbCEsUG1hPL E8YTwxMT6hMMwgYHwgLCAwISwgfEEsMCwwbVE8sTxRPDExPpE8MGAwcCBwMCwhLDB8ISwgISwgLD BtUTyhPFE8MTE+gTwgIHA8ICEw4DDgLDE8USwwLCEMIG1BPKE8UTwxMT5xMCAwcDAg4TDgITwgIS D8ISD8ISBRICEcICwwbUE8oTxRPCExPmEwYCBwMCDgIOwgLDExITEhPCEg8GxgLDBtMMDAfJE8QT whMT5hMGwwITBgMCDhLFEw8SE8ISBgIDwhIDEsMGB9MDxwwHxRPDExPlEwYHAhESAg8CwhMPwhMP xBMPxRIQwgIDAgMCBtMDxwPEDAfDE8IT4RMHwwzCBgLCEhMCDxLIE8MSD8MSwwIQAwIDBgfSDMkD wgPCDAfCExPbEwfGDMIDDAIHERITEhMSwxMPwxMPwxPDEgIDAgMCwwMCBgzREwfHDMYDDMITE9YT B8UMyAMGB8ICBhLDAsYTEhMSExIPwhIHAgcCAwUQAgYRBgfSE8UTB8QMwgMMwhMT0hMHxAzLA8IM BsISDxESExITAw4DxBMSExITwxICBwPCAsMDDMIGB9ITyRMHwwzCExPPEwfDDMkDxQwHwhMGBxIT AhECEwMOAg7DExITDxMPwxIDAgMCBwMCDAYRBgfSE8kTwhPCDMITE8wTB8MMxwPEDMIHxxMGxBLD Ag4DDgIGwg/IEgIDwgIDAgwCEMIGB9ITyRMHDAcMwhMTyhMHwgzGA8MMwgfMEwYHwhLCEAIOAg4C DhDDAhIPxhIFAgXDAgUCEQYH0hPHEwfCDAcPDMITE8gTB8IMxQPDDAfQEwbDEhDEAhAOEA4QwgLG EgcSBhIGBcMCBcIGB9ATB8UMEwfCDA8HDwwHwhMTxhMHwgzEA8MMB9MTBgfCEhADEMICDhAOEMIC EQIDxxIGBwbCAgUCEQYHyxMHxAwHwhMHEwzCEwcPBw8MB8MTE8UTBwzEA8IMB9YTBsQSEAMCA8UC EQIDAgPDEgcSBgfCBgUQAhDCBgfGEwfEDAfGE8INEwzCEw8HwgwHwxPCE8QTBwzDA8IMB9gTBgfE EhACEMYCEQIDAsQSBhLDBsICEALCBgfCEwfDDAfKEwfCDRMHwhPCDAfEE8ITE8MTBwzCA8IMB9oT DBIHwxLDDBEDxQIDAgPDEgYSBgfCBgIQAhAGDAfCEwzDE8MHyRMHwhPCBxMHxRPDExPDEwzCAwwH 3RMGxxICEQPDAgMCA8MSBhIGBwYMBhACEAIGDMMTDBPCB8YTwwfHEwfGE8MTwhPDEwwDDAfeEwYH xxICEQPDAgMCwhIGEgYHBgwGEAIQAsIGB8MTDMYTwwfKEwzGE8MTwhPDE8IMB98TDBLCB8USAgMR xAISB8ISBgcGDAYQBhAGEAYMB8MMB8kTwwfHEwzGE8MTwhPDEwwPwgzfEwYSB8ISB8ISAhECAwID EgcSBwYHBgwGEAYQxgzDD8IHxRPDB8kTBwzGE8MTwhPDEwzDD8QM3BPCBhIGwxIGAhECAwIHBgcG yAzJDxMHzRMHwwwHxxPDE8ITwxMHDMYPxwwH1BMGEgYSBhLLDM4PwwwTDMcTwgfEDAfJE8QTwhMT xBMHwgzLD9sM0w/GDAfDEwzDEwfEDAfLE8YTwxMTxhMHxAztD8gMBgfIE8QMB84TxxPDE8ITyhMH xwzbD8sMEAUMBcIMwgYH1RPKE8UTwxMT0RMH2wwGEAYQBhACBQwFDAUMBgwHBgfWE8sTxRPDExPu EwYMBhAGEAIGDAYMwwYH1xPLE8YTwxMT8BPKBgfYE8wTxhPDExP1E9sTzRPHE8MTwhP1E9sTzRPH E8MTwhMMAAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD/ /wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8A AAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A //8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAA AP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA /wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCk gICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vw oKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw //vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzA psrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDA wNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICA wMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACA AICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACA gACA//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP////// --0__=TT5DhAZGtPHiWSiZCR0Dy8sptrVc79DcZub4d3T2ddmTwB1lE93dy0w7-- From owner-sqr-users@list.iex.net Fri Apr 3 16:06:17 1998 Date: Fri, 3 Apr 1998 11:41:35 -0500 From: Marlon Corrales Subject: Re: How to sort file contents ? Yeah. I think there's no sort in SQR. What we did was to sort the file first (VAX/VMS Sort, yes our OS is VAX/VMS), store this in a temp file and pass this to the SQR program. All of this can be done in a simple script file. :) --------------------------------------------------------------- Hi, I need to read a file and sort its contents based on one of the fields and print them. I dont think there's any command in SQR which would help me do this(like we have internal sort in Cobol). Can anyone tell me how it can be done? TIA Tuhina. From owner-sqr-users@list.iex.net Fri Apr 3 16:52:19 1998 Date: Fri, 3 Apr 1998 16:15:15 -0500 From: "Simonian, Guy" Subject: FW: Use of Sybase text datatype is recognized as char datatype! 1) - 7) of your example work fine (I shortened the table name though) 8) Errors out exactly as in my original note. It seems that SQR wants to pass $abc as char, even though SQL denotes TEXT datatypes. Arrays don't work inside the INSERT line either. > ---------- > From: Ken Gartman[SMTP:osmium@EROLS.COM] > Sent: Friday, April 03, 1998 6:02 PM > To: Multiple recipients of list SQR-USERS > Subject: Re: Use of Sybase text datatype is recognized as char > datatype! > > Simonian, Guy wrote: > > > > Am trying to write to a Sybase "text" datatype which is supposed to > hold > > up > > to 2 gig of ascii data, yet the errors I get indicate that Sybase > thinks > > its getting char data; > > > > begin-setup > > begin-sql on-error=SKIP > > create table {DETAILDB} (out_line text null) > > end-sql > > end-setup > > > > begin-procedure main > > let $abc = '1234567...300 characters of data....' > > begin-sql > > insert into {DETAILDB} (out_line) values ($abc) > > end-sql > > end-procedure > > > > -------When I run this, I get the following bind errors. It looks > like > > SQR is passing char data, even though the field is defined as type > > text.: > > -------------------------- > > (SQR 5528) Sybase dbbind: ct_param error in cursor 119: > > (138) ct_param(): user api layer: external error: A data length > of > > 300 exceeds the maximum length allowed for CHAR data. > > (SQR 5528) Sybase ct_send error in cursor 119: > > (138) ct_param(): user api layer: external error: A data length > of > > 300 exceeds the maximum length allowed for CHAR data. > > > > SQL: insert into tempdb..detail (out_line) values (@__p1) > > > > Error on line 155: > > (SQR 3734) Couldn't compile SQL. > > > > SQRW: Program Aborting. > > > > Am running SQR V3.0.18.1 in a Sybase 11 environment. The SQR client > is > > on SunOS 5.5.1 and also on WinNT. Sybase is under SunOS 5.5.1 > > > Hi, Guy! > Let's use a multi-step approach to debug this one. Thus we > can > isolate the problem into a smaller area of confusion. > > 1. Create your table outside of SQR. After you create it, verify its > structure. Are the table name, column name, and column data > type correct? > > 2. Directly at the data base level, insert a constant into the table, > with a SQL statement such as: > CREATE TABLE GUY_TEMP_1 (OUT_LINE TEXT) > INSERT INTO GUY_TEMP_1 (OUT_LINE) VALUES > ('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABBBBBBBBBB > BBBBBBBBBBBBBBBBBBBBBBBBBBBCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCDDDD > DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDEEEEEE > EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEFFFFFFFFF > FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF > GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG > GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH > HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH > HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIJJ > JJJJJJJJJJJJJJJJ') > ; > > 4. Do you get the expected results? COMMIT ; SELECT * FROM > GUY_TEMP_1 > ; > Do you once again get the expected results? > insert into {DETAILDB} (out_line) values ($abc) > > 5. If all is well, code a small, simple SQR: > > BEGIN-PROGRAM > DO INSERTS > END-PROGRAM > BEGIN-PROCEDURE INSERTS > BEGIN-SQL > INSERT INTO GUY_TEMP_1 (OUT_LINE) VALUES > ('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABBBBBBBBBB > BBBBBBBBBBBBBBBBBBBBBBBBBBBCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCDDDD > DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDEEEEEE > EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEFFFFFFFFF > FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF > GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG > GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH > HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH > HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIJJ > JJJJJJJJJJJJJJJJ') > ; > COMMIT ; > END-SQL > END-PROCEDURE INSERTS > > > 6. Execute your program with the -E and -S flags: > > SQR INSERT-PROGRAM.SQR -E -S > > Do you get any errors now? I doubt that you will, but if so, the > file > INSERT-PROGRAM.ERR should have the details. > > 7. Code up a program that uses variables: > > > BEGIN-PROGRAM > DO INSERTS > END-PROGRAM > BEGIN-PROCEDURE INSERTS > LET $long-string = > 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABBBBBBBBBBB > BBBBBBBBBBBBBBBBBBBBBBBBBBCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCDDDDD > DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDEEEEEEE > EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEFFFFFFFFFF > FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFG > GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG > GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH > HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH > HHHHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIJJJ > JJJJJJJJJJJJJJJ' > > BEGIN-SQL > INSERT INTO GUY_TEMP_1 (OUT_LINE) VALUES ( $long-string ) ; > COMMIT ; > END-SQL > END-PROCEDURE INSERTS > > 8. Execute as before. Any errors? I guess this the step most likely > to have errors. Look up any errors in the SQR documentation. > > 9. At the database level, once again check the results: > > SELECT * FROM GUY_TEMP_1 ; > > > > Good luck, and happy computing > Ken Gartman > From owner-sqr-users@list.iex.net Sat Apr 4 12:42:38 1998 Date: Sat, 4 Apr 1998 12:33:24 -0800 From: "Chester J. Craig" Subject: Re: How to sort file contents ? If you are reading in a flat file the following may help. Using the "Call System" command in SQR you can execute system sorts(UNIX, DOS, ETC.) Below is an example of a sort I have used in UNIX. Let $sort_order = 'sort -n +1 -b -n +3 -r -b data-filein.dat {Anydirectory}p-250.dat -o {Anydirectory}data-fileout.dat' Call System Using $sort_order #status if #status <> 0 show ' Error executing Sort command ' #status else show 'Sort Complete Successfully ' end-if For tables you can use the "order by" option on the "Begin-Select" statement. Chester J. Craig cjcraig@sprynet.com -----Original Message----- From: TUHINAROY To: Multiple recipients of list SQR-USERS Date: Friday, April 03, 1998 7:44 AM Subject: How to sort file contents ? > Hi, > > I need to read a file and sort its contents based on one of the fields and > print them. I dont think there's any command in SQR which would help me do > this(like we have internal sort in Cobol). Can anyone tell me how it can be > done? > > TIA > Tuhina. From owner-sqr-users@list.iex.net Mon Apr 6 01:36:14 1998 Date: Mon, 6 Apr 1998 11:55:13 +1000 From: Steve Cavill Subject: Re: Begin-Select performance using 4 table Join This is a multi-part message in MIME format. --------------0A81762D1D539631DB853C9B Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi Guy, It may be related to SQR buffering rows. Try -b1 option on the begin-select. This will ensure that SQR only retrieves one row at a time. The default is -b10. Note that in production it is better to increase the -b option to a large number to improve performance. Also the time taken to retrieve the first row includes the time taken to establish the connection with the database. You should try the -XP option to prevent SQR from creating temporary stored procedures. Does the whole report take 20 times longer or 57 seconds longer? To really measure the comparitive performance your SQR report should do nothing other than the select. You can use the -S option to check the exact SQL that SQR is passing to Sybase. Cheers, Steve. Simonian, Guy wrote: > Am running SQR V3.0.18.1 in a Sybase 11 environment. The SQR client is > on SunOS 5.5.1 and also on WinNT. Sybase is under SunOS 5.5.1 > > It takes over a minute for my query to find 1 join from the database, > yet if I take the exact same SQL and run it from ISQL or RapidSQL, it > takes about 3 seconds! I've tried the -rs and -rt SQR options to run > the compiled report, but the results are the same. > > ISQL: > ------------------------------------------------------------------------ > ---------------- > > select HRUTEST..PS_PDS_TRX_FACT.TRX_KEY, PLAN_YR, GROUP_INDIV_CODE > from HRUTEST..PS_PDS_TRX_FACT,HRUTEST..PS_PDS_PRODUCT, > HRUTEST..PS_PDS_POL_CASE, HRUTEST..PS_PDS_PAYROLL where > HRUTEST..PS_PDS_TRX_FACT.AA_KEY = 4000 and > > HRUTEST..PS_PDS_TRX_FACT.PAYEE_PARTY_KEY = > HRUTEST..PS_PDS_TRX_FACT.PRODUCER_PARTY_KEY and > HRUTEST..PS_PDS_PRODUCT.PRODUCT_KEY = > HRUTEST..PS_PDS_TRX_FACT.PRODUCT_KEY and > HRUTEST..PS_PDS_POL_CASE.POLICY_CASE_KEY = > HRUTEST..PS_PDS_TRX_FACT.POLICY_KEY and > HRUTEST..PS_PDS_TRX_FACT.PAYROLL_KEY = > HRUTEST..PS_PDS_PAYROLL.PAYROLL_KEY and 4000 = > HRUTEST..PS_PDS_PAYROLL.DISBURSEMENT_KEY > > returns 3 rows in 2 seconds > SQR SOURCE: > ------------------------------------------------------------------------ > ------------------------- > > !------------------------------------------------------------/ > ! P R O C E D U R E xfer.grp.ind / > !------------------------------------------------------------/ > begin-procedure xfer.grp.ind > #debug show '@xfer.grp.ind, key, aa codes ' &AGY_AGT_KEY > #debug show '@xfer.grp.ind, DISB key, ' #DISBURSEMENT_KEY > > begin-select on-error=stmnt-bad-exec > {FACT}.TRX_KEY &TRX_KEY > PLAN_YR &PLAN_YR > GROUP_INDIV_CODE &GROUP_INDIV_CODE > let $detail.PLAN_YR = &PLAN_YR > let #TRX_KEY = &TRX_KEY > if &PLAN_YR = '1' > if &GROUP_INDIV_CODE= 'I' > let $sub_section='' > else > let $sub_section='' > end-if > else > if &GROUP_INDIV_CODE= 'I' > let $sub_section='' > else > let $sub_section='' > end-if > end-if > #debug show '@xfer.grp.ind FOUND ONE XXXXXXXXXXXXXXXX' &TRX_KEY > let #event.type = #event.type + 1 > do xfer.policy.comp.type > from {FACT},{PRODUCT}, {POL_CASE}, {PAYROLL} > where {FACT}.AA_KEY = &AGY_AGT_KEY > and {FACT}.PAYEE_PARTY_KEY = {FACT}.PRODUCER_PARTY_KEY > and {PRODUCT}.PRODUCT_KEY = {FACT}.PRODUCT_KEY > and {POL_CASE}.POLICY_CASE_KEY = {FACT}.POLICY_KEY > and {FACT}.PAYROLL_KEY = {PAYROLL}.PAYROLL_KEY > > and #DISBURSEMENT_KEY = > {PAYROLL}.DISBURSEMENT_KEY > end-select > end-procedure > > ------------------------------------------------------------------------ > ----------------------- > This procedure takes over a minute to find the first record. --------------0A81762D1D539631DB853C9B Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Steve Cavill Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Steve Cavill n: Cavill;Steve org: SQRIBE Technologies adr;dom: 1/14 Aquatic Drive;;;Frenchs Forest;;; email;internet: steve.cavill@sqribe.com.au title: Technical Services Manager x-mozilla-cpt: ;0 x-mozilla-html: TRUE version: 2.1 end: vcard --------------0A81762D1D539631DB853C9B-- From owner-sqr-users@list.iex.net Mon Apr 6 14:14:48 1998 Date: Mon, 6 Apr 1998 20:17:30 +0300 From: SEMECH Subject: SAS & SQR This is a multi-part message in MIME format. ------=_NextPart_000_0025_01BD6199.068DF8A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable We have been approached by a large FOCUS/Oracle user to help them = migrate their reports to either SAS or SQR. As we are much better versed in SQR than SAS, we would appreciate the = assistance of those with SAS experience to help us direct the user. Please note that currently they have many reports which combine flat = files with DB which they claim SAS will accomplish in an easier fashion = than SQR. Regards, Arnon Oppenheimer ------------------------------------------------------------------- SEMECH SOFTWARE MARKETING LTD. TEL : (972) - 3 - 5333144 FAX : (972) - 3 - 5333132 Email: ------------------------------------------------------------------ ------=_NextPart_000_0025_01BD6199.068DF8A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
We have been approached by a large FOCUS/Oracle user = to help=20 them migrate their reports to either SAS or SQR.
 
As we are much  better versed = in SQR than=20 SAS, we would appreciate the assistance of those with SAS experience to = help us=20 direct the user.
 
Please note that currently = they have many=20 reports which combine flat files with DB which they claim SAS will = accomplish in=20 an easier fashion than SQR.
 
Regards,
Arnon=20 Oppenheimer
 
----------------------------------------------------------------= ---
SEMECH=20 SOFTWARE MARKETING LTD.
TEL : (972) - 3 - 5333144
FAX : (972) - 3 = -=20 5333132
Email: <semech@pobox.com>
------------= ------------------------------------------------------
------=_NextPart_000_0025_01BD6199.068DF8A0-- From owner-sqr-users@list.iex.net Mon Apr 6 15:03:18 1998 Date: Mon, 6 Apr 1998 15:56:46 -0400 From: "Simonian, Guy" Subject: Followup to Sybase text datatype being recognized as char datatyp e > 1) - 7) of Ken's example work fine (I shortened the table name though) > 8) Errors out exactly as in my original note. > > It seems that SQR wants to pass $abc as char, even though SQL denotes > TEXT datatypes. > > Arrays don't work inside the INSERT line either. > > > > > > ---------- > > From: Ken Gartman[SMTP:osmium@EROLS.COM] > > Sent: Friday, April 03, 1998 6:02 PM > > To: Multiple recipients of list SQR-USERS > > Subject: Re: Use of Sybase text datatype is recognized as char > > datatype! > > > > Simonian, Guy wrote: > > > > > > Am trying to write to a Sybase "text" datatype which is supposed > to > > hold > > > up > > > to 2 gig of ascii data, yet the errors I get indicate that Sybase > > thinks > > > its getting char data; > > > > > > begin-setup > > > begin-sql on-error=SKIP > > > create table {DETAILDB} (out_line text null) > > > end-sql > > > end-setup > > > > > > begin-procedure main > > > let $abc = '1234567...300 characters of data....' > > > begin-sql > > > insert into {DETAILDB} (out_line) values ($abc) > > > end-sql > > > end-procedure > > > > > > -------When I run this, I get the following bind errors. It looks > > like > > > SQR is passing char data, even though the field is defined as type > > > text.: > > > -------------------------- > > > (SQR 5528) Sybase dbbind: ct_param error in cursor 119: > > > (138) ct_param(): user api layer: external error: A data length > > of > > > 300 exceeds the maximum length allowed for CHAR data. > > > (SQR 5528) Sybase ct_send error in cursor 119: > > > (138) ct_param(): user api layer: external error: A data length > > of > > > 300 exceeds the maximum length allowed for CHAR data. > > > > > > SQL: insert into tempdb..detail (out_line) values (@__p1) > > > > > > Error on line 155: > > > (SQR 3734) Couldn't compile SQL. > > > > > > SQRW: Program Aborting. > > > > > > Am running SQR V3.0.18.1 in a Sybase 11 environment. The SQR > client > > is > > > on SunOS 5.5.1 and also on WinNT. Sybase is under SunOS 5.5.1 > > > > > > Hi, Guy! > > Let's use a multi-step approach to debug this one. Thus we > > can > > isolate the problem into a smaller area of confusion. > > > > 1. Create your table outside of SQR. After you create it, verify > its > > structure. Are the table name, column name, and column data > > type correct? > > > > 2. Directly at the data base level, insert a constant into the > table, > > with a SQL statement such as: > > CREATE TABLE GUY_TEMP_1 (OUT_LINE TEXT) > > INSERT INTO GUY_TEMP_1 (OUT_LINE) VALUES > > > ('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABBBBBBBBBB > > > BBBBBBBBBBBBBBBBBBBBBBBBBBBCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCDDDD > > > DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDEEEEEE > > > EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEFFFFFFFFF > > > FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF > > > GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG > > > GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH > > > HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH > > > HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIJJ > > JJJJJJJJJJJJJJJJ') > > ; > > > > 4. Do you get the expected results? COMMIT ; SELECT * FROM > > GUY_TEMP_1 > > ; > > Do you once again get the expected results? > > insert into {DETAILDB} (out_line) values ($abc) > > > > 5. If all is well, code a small, simple SQR: > > > > BEGIN-PROGRAM > > DO INSERTS > > END-PROGRAM > > BEGIN-PROCEDURE INSERTS > > BEGIN-SQL > > INSERT INTO GUY_TEMP_1 (OUT_LINE) VALUES > > > ('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABBBBBBBBBB > > > BBBBBBBBBBBBBBBBBBBBBBBBBBBCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCDDDD > > > DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDEEEEEE > > > EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEFFFFFFFFF > > > FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF > > > GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG > > > GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH > > > HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH > > > HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIJJ > > JJJJJJJJJJJJJJJJ') > > ; > > COMMIT ; > > END-SQL > > END-PROCEDURE INSERTS > > > > > > 6. Execute your program with the -E and -S flags: > > > > SQR INSERT-PROGRAM.SQR -E -S > > > > Do you get any errors now? I doubt that you will, but if so, the > > file > > INSERT-PROGRAM.ERR should have the details. > > > > 7. Code up a program that uses variables: > > > > > > BEGIN-PROGRAM > > DO INSERTS > > END-PROGRAM > > BEGIN-PROCEDURE INSERTS > > LET $long-string = > > > 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABBBBBBBBBBB > > > BBBBBBBBBBBBBBBBBBBBBBBBBBCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCDDDDD > > > DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDEEEEEEE > > > EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEFFFFFFFFFF > > > FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFG > > > GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG > > > GGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH > > > HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH > > > HHHHHHHHHHHHHHHHHHHHHHHHHHHHHIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIJJJ > > JJJJJJJJJJJJJJJ' > > > > BEGIN-SQL > > INSERT INTO GUY_TEMP_1 (OUT_LINE) VALUES ( $long-string ) ; > > COMMIT ; > > END-SQL > > END-PROCEDURE INSERTS > > > > 8. Execute as before. Any errors? I guess this the step most > likely > > to have errors. Look up any errors in the SQR > documentation. > > > > 9. At the database level, once again check the results: > > > > SELECT * FROM GUY_TEMP_1 ; > > > > > > > > Good luck, and happy computing > > Ken Gartman > > > From owner-sqr-users@list.iex.net Mon Apr 6 15:59:50 1998 Date: Mon, 6 Apr 1998 13:38:33 -0700 From: Colin McCauley Subject: Parsing PeopleSoft PayCheck Output Has anyone written or seen a tool to parse the PAY003.lis file written by PeopleSoft as the Paycheck output file? I would like to input it into another application. ____________________________________ Colin McCauley - Northern Arizona University Support Systems Analyst - Payroll/HRIS 520.523.8146phn ----- 520.523.5239fx From owner-sqr-users@list.iex.net Mon Apr 6 16:33:23 1998 Date: Mon, 6 Apr 1998 17:09:09 -0400 From: Ignacio Lulli Subject: Re: Parsing PeopleSoft PayCheck Output --0__=wOPoFc0PriFLs4PwEvQChjdEERX0QVzgQhPahSnvqDDwOz3AtB04pc3R Content-type: text/plain; charset=us-ascii No, I haven't written anything like this, but if I needed to, I would use the UNSTRING command to accomplish what you are looking to do. Good luck! -Ignacio (Embedded image moved Colin McCauley to file: 04/06/98 01:38 PM PIC06379.PCX) Please respond to SQR-USERS@USA.NET To: Multiple recipients of list SQR-USERS cc: (bcc: Ignacio Lulli) Subject: Parsing PeopleSoft PayCheck Output Has anyone written or seen a tool to parse the PAY003.lis file written by PeopleSoft as the Paycheck output file? I would like to input it into another application. ____________________________________ Colin McCauley - Northern Arizona University Support Systems Analyst - Payroll/HRIS 520.523.8146phn ----- 520.523.5239fx --0__=wOPoFc0PriFLs4PwEvQChjdEERX0QVzgQhPahSnvqDDwOz3AtB04pc3R Content-type: application/octet-stream; name="PIC06379.PCX" Content-transfer-encoding: base64 CgUBCAAAAABoACwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAABaQABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAD1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPH E8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sT zRPHE8MTwhPwEwzIBgzYE8wTxhPDE8IT7hPOBtcTzBPGE8MTE+wTwgbCBwbCEgbCEgbCEsUG1hPL E8YTwxMT6hMMwgYHwgLCAwISwgfEEsMCwwbVE8sTxRPDExPpE8MGAwcCBwMCwhLDB8ISwgISwgLD BtUTyhPFE8MTE+gTwgIHA8ICEw4DDgLDE8USwwLCEMIG1BPKE8UTwxMT5xMCAwcDAg4TDgITwgIS D8ISD8ISBRICEcICwwbUE8oTxRPCExPmEwYCBwMCDgIOwgLDExITEhPCEg8GxgLDBtMMDAfJE8QT whMT5hMGwwITBgMCDhLFEw8SE8ISBgIDwhIDEsMGB9MDxwwHxRPDExPlEwYHAhESAg8CwhMPwhMP xBMPxRIQwgIDAgMCBtMDxwPEDAfDE8IT4RMHwwzCBgLCEhMCDxLIE8MSD8MSwwIQAwIDBgfSDMkD wgPCDAfCExPbEwfGDMIDDAIHERITEhMSwxMPwxMPwxPDEgIDAgMCwwMCBgzREwfHDMYDDMITE9YT B8UMyAMGB8ICBhLDAsYTEhMSExIPwhIHAgcCAwUQAgYRBgfSE8UTB8QMwgMMwhMT0hMHxAzLA8IM BsISDxESExITAw4DxBMSExITwxICBwPCAsMDDMIGB9ITyRMHwwzCExPPEwfDDMkDxQwHwhMGBxIT AhECEwMOAg7DExITDxMPwxIDAgMCBwMCDAYRBgfSE8kTwhPCDMITE8wTB8MMxwPEDMIHxxMGxBLD Ag4DDgIGwg/IEgIDwgIDAgwCEMIGB9ITyRMHDAcMwhMTyhMHwgzGA8MMwgfMEwYHwhLCEAIOAg4C DhDDAhIPxhIFAgXDAgUCEQYH0hPHEwfCDAcPDMITE8gTB8IMxQPDDAfQEwbDEhDEAhAOEA4QwgLG EgcSBhIGBcMCBcIGB9ATB8UMEwfCDA8HDwwHwhMTxhMHwgzEA8MMB9MTBgfCEhADEMICDhAOEMIC EQIDxxIGBwbCAgUCEQYHyxMHxAwHwhMHEwzCEwcPBw8MB8MTE8UTBwzEA8IMB9YTBsQSEAMCA8UC EQIDAgPDEgcSBgfCBgUQAhDCBgfGEwfEDAfGE8INEwzCEw8HwgwHwxPCE8QTBwzDA8IMB9gTBgfE EhACEMYCEQIDAsQSBhLDBsICEALCBgfCEwfDDAfKEwfCDRMHwhPCDAfEE8ITE8MTBwzCA8IMB9oT DBIHwxLDDBEDxQIDAgPDEgYSBgfCBgIQAhAGDAfCEwzDE8MHyRMHwhPCBxMHxRPDExPDEwzCAwwH 3RMGxxICEQPDAgMCA8MSBhIGBwYMBhACEAIGDMMTDBPCB8YTwwfHEwfGE8MTwhPDEwwDDAfeEwYH xxICEQPDAgMCwhIGEgYHBgwGEAIQAsIGB8MTDMYTwwfKEwzGE8MTwhPDE8IMB98TDBLCB8USAgMR xAISB8ISBgcGDAYQBhAGEAYMB8MMB8kTwwfHEwzGE8MTwhPDEwwPwgzfEwYSB8ISB8ISAhECAwID EgcSBwYHBgwGEAYQxgzDD8IHxRPDB8kTBwzGE8MTwhPDEwzDD8QM3BPCBhIGwxIGAhECAwIHBgcG yAzJDxMHzRMHwwwHxxPDE8ITwxMHDMYPxwwH1BMGEgYSBhLLDM4PwwwTDMcTwgfEDAfJE8QTwhMT xBMHwgzLD9sM0w/GDAfDEwzDEwfEDAfLE8YTwxMTxhMHxAztD8gMBgfIE8QMB84TxxPDE8ITyhMH xwzbD8sMEAUMBcIMwgYH1RPKE8UTwxMT0RMH2wwGEAYQBhACBQwFDAUMBgwHBgfWE8sTxRPDExPu EwYMBhAGEAIGDAYMwwYH1xPLE8YTwxMT8BPKBgfYE8wTxhPDExP1E9sTzRPHE8MTwhP1E9sTzRPH E8MTwhMMAAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD/ /wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8A AAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A //8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA/wAA AP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCkgICA /wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vwoKCk gICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw//vw oKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzApsrw //vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDAwNzA psrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICAwMDA wNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACAAICA wMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACAgACA AICAwMDAwNzApsrw//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP//////AAAAgAAAAIAAgIAAAACA gACA//vwoKCkgICA/wAAAP8A//8AAAD//wD/AP////// --0__=wOPoFc0PriFLs4PwEvQChjdEERX0QVzgQhPahSnvqDDwOz3AtB04pc3R-- From owner-sqr-users@list.iex.net Mon Apr 6 16:52:10 1998 Date: Mon, 6 Apr 1998 15:43:05 -0600 From: "Duckworth, Jerry" Subject: Re: Parsing PeopleSoft PayCheck Output I don't know about parsing the PAY003.lis file but you could modify = PAY003.sqr to generate one or more flat files in addition to PAY003.lis. = Don't know if that would work for your application or not. ---------- From: SQR-USERS=5BSMTP:SQR-USERS=40USA.NET=5D Sent: Monday, April 06, 1998 1:39 PM To: Multiple recipients of list SQR Subject: Parsing PeopleSoft PayCheck Output Subject: Parsing PeopleSoft PayCheck Output To: Multiple recipients of list SQR-USERS Has anyone written or seen a tool to parse the PAY003.lis file written by PeopleSoft as the Paycheck output file? I would like to input it into another application. ____________________________________ Colin McCauley - Northern Arizona University Support Systems Analyst - Payroll/HRIS 520.523.8146phn ----- 520.523.5239fx From owner-sqr-users@list.iex.net Mon Apr 6 17:38:08 1998 Date: Mon, 6 Apr 1998 16:34:13 -0500 From: John Niedziela Subject: Re: Parsing PeopleSoft PayCheck Output Here are a couple of tools that will parse out txt data and convert to a dbf or xls or whatever. Monarch by Personics - any software or pc store should have it. Data junction by data junction - www.datajunction.com - more sophisticated. costs about a grand?? if you have any questions contact via e-mail or voice at 630-572-1831 Regards At 01:38 PM 4/6/98 -0700, you wrote: >Has anyone written or seen a tool to parse the PAY003.lis file written by >PeopleSoft as the Paycheck output file? >I would like to input it into another application. >____________________________________ >Colin McCauley - Northern Arizona University >Support Systems Analyst - Payroll/HRIS >520.523.8146phn ----- 520.523.5239fx > From owner-sqr-users@list.iex.net Mon Apr 6 17:53:57 1998 Date: Mon, 6 Apr 1998 16:17:11 -0600 From: Robert Goshko Subject: Re: Parsing PeopleSoft PayCheck Output ------ =_NextPart_000_01BD6177.EEE8AB30 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I have in the past just changed the output of the pay003 program to give = me a flat file that is used by a cheque printing program. Do you still = need the original file? If so why not add a procedure to write a second = flat file? ......Rob -------------------------------------------------------------------------= --- Robert Goshko | Axis Developments | System Consulting = Services robert.goshko@axis-dev.com | Sherwood Park, AB | (403) 417-AXIS -----Original Message----- From: Colin McCauley [SMTP:Colin.McCauley@NAU.EDU] Sent: Monday, April 06, 1998 2:39 PM To: Multiple recipients of list SQR-USERS Subject: Parsing PeopleSoft PayCheck Output Has anyone written or seen a tool to parse the PAY003.lis file written = by PeopleSoft as the Paycheck output file? I would like to input it into another application. ____________________________________ Colin McCauley - Northern Arizona University Support Systems Analyst - Payroll/HRIS 520.523.8146phn ----- 520.523.5239fx ------ =_NextPart_000_01BD6177.EEE8AB30 Content-Type: application/ms-tnef Content-Transfer-Encoding: base64 eJ8+IiUWAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYAkAEAAAEAAAAQAAAAAwAAMAIAAAAL AA8OAAAAAAIB/w8BAAAAQQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAFNRUi1VU0VSU0BVU0Eu TkVUAFNNVFAAU1FSLVVTRVJTQFVTQS5ORVQAAAAAHgACMAEAAAAFAAAAU01UUAAAAAAeAAMwAQAA ABIAAABTUVItVVNFUlNAVVNBLk5FVAAAAAMAFQwBAAAAAwD+DwYAAAAeAAEwAQAAABQAAAAnU1FS LVVTRVJTQFVTQS5ORVQnAAIBCzABAAAAFwAAAFNNVFA6U1FSLVVTRVJTQFVTQS5ORVQAAAMAADkA AAAACwBAOgEAAAAeAPZfAQAAABIAAABTUVItVVNFUlNAVVNBLk5FVAAAAAIB918BAAAAQQAAAAAA AACBKx+kvqMQGZ1uAN0BD1QCAAAAAFNRUi1VU0VSU0BVU0EuTkVUAFNNVFAAU1FSLVVTRVJTQFVT QS5ORVQAAAAAAwD9XwEAAAADAP9fAAAAAAIB9g8BAAAABAAAAAAAAALhQwEEgAEAJwAAAFJFOiBQ YXJzaW5nIFBlb3BsZVNvZnQgUGF5Q2hlY2sgT3V0cHV0AL8NAQWAAwAOAAAAzgcEAAYAEAARAAsA AQAMAQEggAMADgAAAM4HBAAGABAADgASAAEAEAEBCYABACEAAAAxQkJFN0NBNDlCQ0REMTExQjMy RjAwNjAwODhDNjg2NAAwBwEDkAYACAcAACEAAAALAAIAAQAAAAsAIwAAAAAAAwAmAAAAAAALACkA AAAAAAMALgAAAAAAAwA2AAAAAABAADkAoNcXv6lhvQEeAHAAAQAAACcAAABSRTogUGFyc2luZyBQ ZW9wbGVTb2Z0IFBheUNoZWNrIE91dHB1dAAAAgFxAAEAAAAWAAAAAb1hqb8KpHy+Hc2bEdGzLwBg CIxoZAAAHgAeDAEAAAAFAAAAU01UUAAAAAAeAB8MAQAAABsAAAByb2JlcnQuZ29zaGtvQGF4aXMt ZGV2LmNvbQAAAwAGEOqJuTcDAAcQBAMAAB4ACBABAAAAZQAAAElIQVZFSU5USEVQQVNUSlVTVENI QU5HRURUSEVPVVRQVVRPRlRIRVBBWTAwM1BST0dSQU1UT0dJVkVNRUFGTEFURklMRVRIQVRJU1VT RURCWUFDSEVRVUVQUklOVElOR1BST0cAAAAAAgEJEAEAAADVAwAA0QMAAOgFAABMWkZ1bKPPQwMA CgByY3BnMTI1FjIA+Atgbg4QMDMznQH3IAKkA+MCAGNoCsDgc2V0MCAHEwKDAFDjAvIQ2VRhaANx AoMOUF8EVRDZCFUHsgKDMxBncGhycTIRdn0KgAjIIDY7CW8OMDUCgAqBdWMbAFALA2MSEgvEIEkg EREAdmUgC4AgdGjLG6AKsHMFQGp1HFEQ8c8PIAmAG+MIYHRwHaAdgPJmG+V5MA9QHCADYAnAhGFt G+BvIGdpG5GxB4AgYSAO8QVAZgMQbxugG/AgUQQAIByQHSFi5nkgARDwZXEKUB7RC4AKdAuAZx7W LiAgRHUfcHkIYCAcUAMQAyBubwngHTUFEB+QbgdAIHM/lSNwSR4Qcx9wd2ghsORubwVAYWQdMCAQ HuG+YwmACHAgsSYxBRB0H/LbETAFoG4dMCA3PwqiCoQPCoQacgLREiFzMTcgPi4rcggADDApqhPQ IC3/LP8uDy8fMC8wpSmUI3AyEgcrwQSQBUBHb3NoaysfcDNFfBFweCEhRGX7G5AJAHAHgAIwBCAz wAawnRxQZR9ACFAAgHVsIqN9BmF2DeAHkCmUA2Ayki5SZzLzQGEz8S0BAHYeLgWgH0A1ARwAcndv SQRwIFAKwGssEXBCEzOxMhQoNA9QKSA0wStALUFYSVMSAioJCRYTMTYp+mxpMza3AUAe4SgwYwVA MKNPJQbyTQeQc2EdEDFpPeY90YcLEz4EAgBpLTE0OqA5PYExOB6gDMFCE2Ig6kYDYToMg2IVAj2Q A6BQTWNDYTXQZSGwW6BTTVRQOkQzLkSWAEBOQVUuRURVvl0plUNABmACMEOnTSixTx6AOcEiYQMg MDY5wDEAOTk4IDI6MznlOXBNRvdUb0fINdILUPsboAlwYwUgCJA0wh4BPZABHFFTUVItVVNFxlI7 YEcHdWJqPjFDp2c5gQCQIsFQZTSAIKBTJx4ABUA5gHlDHABja/wgTx2jQB9BKj2UC7Ypo/ZIHEAg AG4jwCRgJ/MoMP8DoAWxETBVcSAQH2AG8B9SRwqxETAb41BBWR6hLv9M4SB0VSYhoCmUT9lUgVcj /x6AIfFQ4R2VKUkbUDkwNdD7HTA9kGsnswuAHcIoIBux3x9hAHAmoDkBIABwC1AN4NUgUGkCIC4p lF9fv2DP9l8plEQ9LQewCRE5AQOg7QcRegIgIBBVAwAbkE9xfnRY9U5QXqAJETUVBCBBPyVBNTFj MVCBA2AkMC9IzlI7USmjDkAwLg5AV7BiOEIQNnBoA6AwoyBjaDZocTlmeCmaF4EAAWtwAAAAAwAQ EAAAAAADABEQAAAAAAMAgBD/////QAAHMCARgFepYb0BQAAIMCARgFepYb0BCwAAgAggBgAAAAAA wAAAAAAAAEYAAAAAA4UAAAAAAAADADqACCAGAAAAAADAAAAAAAAARgAAAABShQAAtw0AAB4AO4AI IAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABAAAADguMAADADyACCAGAAAAAADAAAAAAAAARgAA AAABhQAAAAAAAAsARYAIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwBGgAggBgAAAAAAwAAA AAAAAEYAAAAAEIUAAAAAAAADAEeACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMASoAIIAYA AAAAAMAAAAAAAABGAAAAABiFAAAAAAAAHgBagAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAAB AAAAAAAAAB4AW4AIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAeAFyACCAGAAAA AADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAAHgA9AAEAAAAFAAAAUkU6IAAAAAADAA00/TcA AM+k ------ =_NextPart_000_01BD6177.EEE8AB30-- From owner-sqr-users@list.iex.net Mon Apr 6 19:12:32 1998 Date: Mon, 6 Apr 1998 17:14:52 -0400 From: Ignacio Lulli Subject: Need help getting a bmp logo to print out properly Hi everyone, I am trying to print a logo on an HP printer, but I only get a shaded box where the logo would go. Any ideas?? I have listed some code below. Thanks. -Ignacio [some code...] #include 'setenv.sqc' #include 'setup02.sqc' #include 'poylaser.sqc' [some code...] !---------------------------------------- begin-setup declare printer ! Declare printer characteristics. type={Laser} ! Types are POSTSCRIPT, HPLASERJET, left-margin=.25 top-margin=.25 ! or LINEPRINTER font=4 ! Font number. ! font-style=fixed ! symbol-set=0U lines-inch=6 ! 6lines per inch point-size=8 char-size=7.2 orientation=portrait ! Or Landscape. end-setup !---------------------------------------- Begin-Heading 8 [some code...] graphic () font 4 8 !USM/JIL - 4/1/98 added USMINT logo to header print-image (2,35) type = bmp-file source = 'M:\psoft\fs700dv1\sqr\USMint.bmp' image-size = (10,5) End-Heading !---------------------------------------- begin-report [some code...] end-report From owner-sqr-users@list.iex.net Mon Apr 6 20:11:56 1998 Date: Mon, 6 Apr 1998 21:09:06 -0400 From: Ignacio Lulli Subject: Re: Need help getting a bmp logo to print out properly --0__=k2JOeq5gdaAjHoXeCyVZwvFxPLOL3aG2H1dPQku2w8H4gyG16aKNCGJW Content-type: text/plain; charset=us-ascii I would like to add to my earlier email. I just went through the SQR Users library and found some great information. Apparently: 1) the -printer:wp flag is required to print BMP files on HP printers (using SQR v3.0.18.1.1) 2) or I can use use the -printer:hp flag but would need to convert the BMP file to HPGL/2 format beforehand. My questions: 1) is the above information totally correct? 2) how can I convert my BMP file into HPGL/2? 3) has anyone else printed logos using PeopleSoft, Win95 and HP printers? Thanks for your help. -Ignacio (Embedded image moved Ignacio Lulli to file: 04/06/98 02:14 PM PIC02646.PCX) Please respond to SQR-USERS@USA.NET To: Multiple recipients of list SQR-USERS cc: (bcc: Ignacio Lulli) Subject: Need help getting a bmp logo to print out properly Hi everyone, I am trying to print a logo on an HP printer, but I only get a shaded box where the logo would go. Any ideas?? I have listed some code below. Thanks. -Ignacio [some code...] #include 'setenv.sqc' #include 'setup02.sqc' #include 'poylaser.sqc' [some code...] !---------------------------------------- begin-setup declare printer ! Declare printer characteristics. type={Laser} ! Types are POSTSCRIPT, HPLASERJET, left-margin=.25 top-margin=.25 ! or LINEPRINTER font=4 ! Font number. ! font-style=fixed ! symbol-set=0U lines-inch=6 ! 6lines per inch point-size=8 char-size=7.2 orientation=portrait ! Or Landscape. end-setup !---------------------------------------- Begin-Heading 8 [some code...] graphic () font 4 8 !USM/JIL - 4/1/98 added USMINT logo to header print-image (2,35) type = bmp-file source = 'M:\psoft\fs700dv1\sqr\USMint.bmp' image-size = (10,5) End-Heading !---------------------------------------- begin-report [some code...] end-report --0__=k2JOeq5gdaAjHoXeCyVZwvFxPLOL3aG2H1dPQku2w8H4gyG16aKNCGJW Content-type: application/octet-stream; name="PIC02646.PCX" Content-transfer-encoding: base64 CgUBCAAAAABoACwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAABaQABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAD1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPH E8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sTzRPHE8MTwhP1E9sT zRPHE8MTwhPwEwzIBgzYE8wTxhPDE8IT7hPOBtcTzBPGE8MTE+wTwgbCBwbCEgbCEgbCEsUG1hPL E8YTwxMT6hMMwgYHwgLCAwISwgfEEsMCwwbVE8sTxRPDExPpE8MGAwcCBwMCwhLDB8ISwgISwgLD BtUTyhPFE8MTE+gTwgIHA8ICEw4DDgLDE8USwwLCEMIG1BPKE8UTwxMT5xMCAwcDAg4TDgITwgIS D8ISD8ISBRICEcICwwbUE8oTxRPCExPmEwYCBwMCDgIOwgLDExITEhPCEg8GxgLDBtMMDAfJE8QT whMT5hMGwwITBgMCDhLFEw8SE8ISBgIDwhIDEsMGB9MDxwwHxRPDExPlEwYHAhESAg8CwhMPwhMP xBMPxRIQwgIDAgMCBtMDxwPEDAfDE8IT4RMHwwzCBgLCEhMCDxLIE8MSD8MSwwIQAwIDBgfSDMkD wgPCDAfCExPbEwfGDMIDDAIHERITEhMSwxMPwxMPwxPDEgIDAgMCwwMCBgzREwfHDMYDDMITE9YT B8UMyAMGB8ICBhLDAsYTEhMSExIPwhIHAgcCAwUQAgYRBgfSE8UTB8QMwgMMwhMT0hMHxAzLA8IM BsISDxESExITAw4DxBMSExITwxICBwPCAsMDDMIGB9ITyRMHwwzCExPPEwfDDMkDxQwHwhMGBxIT AhECEwMOAg7DExITDxMPwxIDAgMCBwMCDAYRBgfSE8kTwhPCDMITE8wTB8MMxwPEDMIHxxMGxBLD Ag4DDgIGwg/IEgIDwgIDAgwCEMIGB9ITyRMHDAcMwhMTyhMHwgzGA8MMwgfMEwYHwhLCEAIOAg4C DhDDAhIPxhIFAgXDAgUCEQYH0hPHEwfCDAcPDMITE8gTB8IMxQPDDAfQEwbDEhDEAhAOEA4QwgLG EgcSBhIGBcMCBcIGB9ATB8UMEwfCDA8HDwwHwhMTxhMHwgzEA8MMB9MTBgfCEhADEMICDhAOEMIC EQIDxxIGBwbCAgUCEQYHyxMHxAwHwhMHEwzCEwcPBw8MB8MTE8UTBwzEA8IMB9YTBsQSEAMCA8UC EQIDAgPDEgcSBgfCBgUQAhDCBgfGEwfEDAfGE8INEwzCEw8HwgwHwxPCE8QTBwzDA8IMB9gTBgfE EhACEMYCEQIDAsQSBhLDBsIC