Re: [U2] save quot; break-onquot; query result as data file records
If you supply REFORMAT with its first field that is your group field, then it will generate multi values for you in records keyed on the group. If you are after break sub-totals these can then be achieved using a correlative or I descriptor on the destination file. HTH Brett Danila danila.bezme...@gmail.com wrote in message news:loom.20100716t222842-...@post.gmane.org... Boydell, Stuart Stuart.Boydell at spotless.com.au writes: If you're familiar with SQL you can use SQL. INSERT INTO NEWFILE SELECT COL1,COL2,SUM(COL3) FROM OLDFILE GROUP BY COL1,COL2; Etc See the SQL User Guide for UV specific extensions and syntax Otherwise, if you want to use Revise, you can use the REFORMAT verb. HTH, Stuart Thanks Stuart, I think I have no choice as to use BASIC, because Insert SQL statement does not allow field modifiers in a subquery, and REFORMAT syntax does not allow break-on values, but original records instead. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This message contains information that may be privileged or confidential and is the property of GPM Development Ltd. It is intended only for the person to whom it is addressed. If you are not the intended recipient ,you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. This e-mail was sent to you by GPM Development Ltd. We are incorporated under the laws of England and Wales (company no. 2292156 and VAT registration no. 523 5622 63). Our registered office is 6th Floor, AMP House, Croydon, Surrey CR0 2LX. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] center justification in PCL printing
Catching up on some older emails during lunch FYI, there is a little trick for printing 'center' justification of variable width text without knowing specific character by character widths in HP PCL. From a PCL starting cursor point, you print transparent white text at 180 degrees rotation at half the point size. Then flip back to normal rotation and print black text at regular point size.The text will be centered at the starting cursor point. Similar trick for right justified except you don't have to change the point size. You can google the specifics, it works quite well. -Troy -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Rasmussen Sent: Friday, April 30, 2010 11:45 AM To: U2 Users List Subject: Re: [U2] AccuTerm File Transfer On Fri, 30 Apr 2010, Glen Batchelor wrote: I'd opt for print wizard unless you want to hard code the PCL and avoid middleware. You can code the PCL font and spacing escape codes directly in your app and just print the code to the slave printer like normal. It's a little more design time, but it'll be a fairly static setup. If you want PCL example code to use print the label from Word to a Laserjet 4 driver set to print to file. Or, Google it. There are lots of PCL references on the web. I can help as well. That works up to a point. But Kevin said he wanted to CENTER variable-pitch text, which would require knowing and using the width of every possible character. Regards, Bob Rasmussen, President, Rasmussen Software, Inc. _ Scanned by IBM Email Security Management Services powered by MessageLabs. For more information please visit http://www.ers.ibm.com This email is intended only for the use of the party to which it is addressed and may contain information that is privileged, confidential, or protected by law. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of the email or its contents is strictly prohibited. If you have received this message in error, please notify us immediately, by replying to the message and deleting it from your computer. WARNING: Internet communications are not assured to be secure or clear of inaccuracies as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, we do not accept responsibility for any errors or omissions that are present in this email, or any attachment, that have arisen as a result of e-mail transmission. _ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Tracing ODBC requests
Hello List Members. Can anyone suggest a way to log the SQL requests sent via ODBC to the Universe DB (from a MS Windows client to a AIX based Universe DB). I suppose I want the commands processed by the uvapi_slave process. I have tried capturing them via the LOGIN paragraph to no avail. Any help would be appreciated. The manuals, as is often the case, were unhelpful. Regards, Ken Ford Software Engineer - Universe Phone: 07 3013 8605 Fax: 07 3002 8400 Email: ken.f...@firstmac.com.au Web: www.firstmac.com.au # This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. FirstMac Limited (ABN 59 094 145 963) (AFSL 290600) # ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Tracing ODBC requests
Hello Ken, Check out the API Supplement PDF (apisupp.pdf) Try this... haven't used it for a long time...I believe ODBC connections go via uvserver. Last time I used was for uvcs though, I can't recall it actually works for ODBC connections. You can also get your remote system to invoke a stored procedure to your UV Regards David Extracted out of the PDF: Logging Client Connections Beginning at UniVerse 10.0, a server-side debugging log is available for tracking client connections. The debugging log is located in the /tmp/ directory on UNIX, or C:\tmp on Windows platforms, by default. Complete the following steps to set up the debugging log: 1.Edit the serverdebug file in the UVHOME directory. 2.In the first column, enter uvcs, indicating that you want to log the connection progress for both uvapi_server and uvapi_slave. 3.In the next column, enter an integer indicating the level of logging information you want to maintain. The valid integers are: 0 - No debugging. 1 - Captures information about the startup connection only. 9 - Captures information about every call. 4.In the third column, enter the full path for the log file location. If this value does not exist, the logs are written to /tmp/uvapiserver_###.log as the default on UNIX systems, or C:\tmp\uvapiserver.log as the default on Windows systems. is the uvapi_server process ID. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Tuesday, 20 July 2010 1:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] Tracing ODBC requests Hello List Members. Can anyone suggest a way to log the SQL requests sent via ODBC to the Universe DB (from a MS Windows client to a AIX based Universe DB). I suppose I want the commands processed by the uvapi_slave process. I have tried capturing them via the LOGIN paragraph to no avail. Any help would be appreciated. The manuals, as is often the case, were unhelpful. Regards, Ken Ford Software Engineer - Universe Phone: 07 3013 8605 Fax: 07 3002 8400 Email: ken.f...@firstmac.com.au Web: www.firstmac.com.au ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users