Re: [U2] [Universe] [Windows]
How big is the record (file actually) it's trying to read? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 06, 2014 1:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
File permissions? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 06, 2014 1:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sort Columns in GUI Screen
Are there input fields on the unsortable screen? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Friday, April 04, 2014 2:20 PM To: u2-users@listserver.u2ug.org Subject: [U2] Sort Columns in GUI Screen I have a screen, it reads in one record that has some MV fields. On the main screen my first 4 fields can not be sorted. (1,2,3,4) However, on a tabbed screen I have another set of 4 MV fields (15,16,17,18 in the same record) that lets me sort my fields. I would like to be able to sort the MV fields on my first screen. I've looked through everything hoping to find what is controlling this. So far no luck. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Sort-Columns-in-GUI-Screen-tp42926.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sort Columns in GUI Screen
That's why. In the Multivalue Grids section of the manual, it states grids that do not contain any input fields can be sorted at run time -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Friday, April 04, 2014 2:32 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Sort Columns in GUI Screen Yes, I was wondering if that was a factor or not. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Sort-Columns-in-GUI-Screen-tp42926p42928.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] unidata index
Don't know - I wouldn't index a field for that reason alone. And it probably wouldn't help if you had other fields you were sorting by, or other fields you were selecting, in the same select statement. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Thursday, March 13, 2014 2:15 PM To: U2 Users List Subject: [U2] unidata index Stupid index question: does indexing a field help performance when sorting BY that field but it's not otherwise involved in the query? -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
This isn't SQL, but uniquery has NSELECT that does this. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Monday, March 03, 2014 12:44 PM To: u2-users@listserver.u2ug.org Subject: [U2] Left Outer Join Question I have 2 files. File 2 is a black list of records (keys) I want to exclude in and active select list of File 1. I've been looking into this for a little while and am not sure what I'm doing wrong. Docs are not very helpful with any examples on the how to do with this. I know of ways to deal with this in code, but was hoping for an SQL way to deal with it. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Using a ( at the end of a Select statement
Well why didn't you say so? That makes a big difference. If you go into /pd.s to the Options prompt and hit F1 it will tell you what these all mean. S - means return a select list D - means data stack the results R - means return keys in selected format - no window -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Thursday, February 13, 2014 3:28 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Using a ( at the end of a Select statement I did forget one thing. The select in question was in an SB process. EXEC 'S:SELECT ACHPAY.TXT WITH CO = ':@PARMS(3)2:' (RSD' - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Using-a-at-the-end-of-a-Select-statement-tp42672p42676.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Using a ( at the end of a Select statement
S:SELECT is just the inline form of a /PD.S. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Thursday, February 13, 2014 5:01 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Using a ( at the end of a Select statement Funny I made an PD.S not long ago. Just didn't associate the SB process code with a PD.S. It's been years since I've done a raw select in an SB process. I guess I've been coding to long in Unibasic. Thanks Dave. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Using-a-at-the-end-of-a-Select-statement-tp42672p42679.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BASIC code - upper, lower, CamelCase, what say you?
Lowercase keywords - camelcase variables - lowercase comments - equates should be easy to differentiate from variables. Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mysterious Error Message
II is whatever SB+ system it is logging into. Whatever SB+ user is being used to log in doesn't have access to the account. The message is stored in the ERROR item of the DMCONT file - attribute 115 - so you won't find that using ESEARCH on a BP file. Haven't used redback so I don't know what that uses to log into SB. Have used remote processes though - and get these kinds of errors sometime if the user or group security tree doesn't allow us to get into where we are trying to go. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 1:28 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Yes - the LOGIN paragraphs are the same. Yes - the iConnect agents are essentially the same (paths are obviously different) and they are all enabled. The last change I made to iConnect was 3-4 weeks ago to map a new field and that worked (and is still working in LIVE). I have done an ESEARCH on all the BP files I can think of in Redback, iConnect the Avanté account itself. Even looking through source codes and object code, I cannot find RECORD CORRUPT anywhere. Maybe I missed something, maybe it is more cryptic than I would expect, maybe something else. Bottom line: I do not have a clue what program is causing this, what II record it thinks is corrupt, etc. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 1:17 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Hi John, ok, so let's think this through... RedBack is using an iConnect agent to login through SB+ and execute the screen. That message is an SB+ message. So...my first question would be - are the LOGIN paragraphs the same between accounts where it's working and where it's not? The 2nd would be - is the iconnect Agent, as defined the Site setup the same between sites? Is that agent enabled? (I'm assuming the backend iConnect accounts are shared per realm?) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 8:46 AM To: U2 Users List Subject: [U2] Mysterious Error Message We use UniData/HPUX w/ SB and Redback. We are running Epicor's Avanté which uses iConnect. For arguments sake, I have 3 UniData accounts: TEST, PILOT LIVE. I have 3 web sites (TEST, PILOT LIVE) that connect as you would expect. 3-4 weeks ago, a change was made in Sales Order Entry in SB. I had to make a minor tweak for this to work via the web sites. All was good with all three web sites. Due to unrelated issues, our TEST account has a temporary stand-alone copy of DMSECURITY. Other people on my team have made a few changes in SB Sales Order Entry and asked that I verify that the web site still worked. One change was in TEST and another (untested) one was in PILOT. Order Entry was now failing on both web sites, but LIVE was still working. The change in PILOT was unrolled, but we still had the problem. The actual error we are getting in the Redback log is II RECORD CORRUP! - CONTACT SYSTEM ADMINISTRATOR If the problem were only in TEST, I would blame my local copy of DMSECURITY. Since the problem is also in PILOT but NOT in LIVE (which share the standard DMSECURITY file), this tells me it is not the DMSECURITY file, but rather something that is local to each account. Has anyone seen this before? Any thoughts or suggestions? JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCNEp4zqbbPX5SnNO9KVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79IhGjxaAtYY58qmDm56RLzaIundEqmDm56RLzaIundFA63hOOqekT-LPatNPb9EVWZOW9EVhpVwsqemm3hOPORQr8FGTspVkffGhBrwqrhdFCXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jr3wVUS2_id41Fr2qpFtd40SmFfUOGTgQg3koRyq81LWkQzVKVKnZbpJhF-VsH ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCN8i6zqbbPX5SnNO9KVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79IhGjxaAtYY58qmDm56RLzaIundEqmDm56RLzaIundFA63hOOqekT-LPatNPb9EVWZOW9EVhpVwsqemm3hOPORQr8FGTspVkffGhBrwqrjdFCXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jr3wVUS2_id41Fr2qpFtd40SmFfUOGTgQg3koRyq81LWkQzVKVKYuT ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http
Re: [U2] Simple question - selecting and listing records
If this is unidata ECLTYPE U: LIST CREDITCARD.FILE PACKET STATUS TRACKING.ID PMT.DATE WHEN ASD(PMT.DATE EQ 11/19/2013) You may want to try lowercase list if your default ECLTYPE is P to force it to use the U parser. And your CREDITCARD.FILE dictionary should have PACKET STATUS TRACKING.ID PMT.DATE belonging to the same association. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hilk, Brandon Sent: Tuesday, November 19, 2013 11:29 AM To: U2 Users List Subject: [U2] Simple question - selecting and listing records Hello, I have a quick question regarding listing multivalued fields. I hope the formatting is retained on this email so my example doesn't get confusing. This file is structured for multiple credit card entries under one @id. How can I alter my LIST command to only show the entries for the date specified? I tried using when in both the LIST and SELECT statements but didn't get the results I was looking for. I feel like I'm missing something really basic. Thanks in advance. }SELECT CREDITCARD.FILE WITH PMT.DATE EQ 11/19/2013 303 record(s) selected to SELECT list #0. }}LIST CREDITCARD.FILE PACKET STATUS TRACKING.ID PMT.DATE CREDITCARD.FILE PACKET.. STATUS. TRACKING ID. PMT DATE.. 5215216252152162 APPROVED25D6TGCD 11/19/2013 52152162 12/31/2013 52152162 01/31/2014 52152162 02/28/2014 52152162 03/31/2014 52152162 04/30/2014 52152162 05/30/2014 52152162 06/30/2014 52152162 07/31/2014 52152162 08/29/2014 52152162 09/30/2014 52152162 10/31/2014 5643649556436495 APPROVED259l17j2 02/18/2013 56436495 APPROVED25a0hfg7 03/18/2013 56436495 APPROVED25adf4bt 04/18/2013 56436495 APPROVED25ar1ofv 05/20/2013 56436495 APPROVED25b7a92o 06/18/2013 56436495 APPROVED25bk0tpv 07/18/2013 56436495 APPROVED25c11rl1 08/19/2013 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Interesting... Unidata VLIST options
It's a *nix command that shows the displayable characters in a file. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, October 02, 2013 1:46 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Interesting... Unidata VLIST options What is !strings ? I have no such command in Universe -Original Message- From: McGowan, Ian james.mcgo...@bankofthewest.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Oct 2, 2013 10:42 am Subject: Re: [U2] Interesting... Unidata VLIST options Changing the subject to not hijack the other thread. Yes, I too have a program that basically does a strings command on the object code and either dumps all strings or for each one looks it up in the VOC to check if it's a file. https://github.com/ianmcgowan/PickCode/blob/master/CHECK.FILES -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, October 02, 2013 9:46 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Interesting I have to think (and I havent' yet checked) that the names of the files opened will appear within the object code, since they have to be represented as literal strings when they are named. Sure you could pass the name in, but then the program wouldn't know it either, so we're just talking about files where the project itself knows the name of what it's opening. So you can walk the object code, and reconstruct any literal strings within it. In fact I think I have a tool that does that -Original Message- From: McGowan, Ian james.mcgo...@bankofthewest.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Oct 2, 2013 9:42 am Subject: Re: [U2] Interesting The use of PORT.STATUS using the PID option and LAYER.STACK (PORT.STATUS PID 123456 LAYER.STACK) over and over again can show you what hex address in the program your process is at. I suggest calling this 50 or 100 times in a row and inspecting the output. Once you have the hex addresses, use VLIST to figure out what line in the program each address represents. Does anyone have tips for doing the equivalent in Unidata (when you don't have source code, obviously)? I end up using truss or strace to at least see which files are opened/written to, which can be instructive but really hard to follow. - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Tap-In
1. Copy the VOC entry for SB.PROCESS to a VOC entry named STANDARD.SB.PROCESS 2. Replace the VOC entry for SB.PROCESS with your own user-defined subroutine that takes the same parameters Then call the real SB.PROCESS process from inside your user-defined subroutine using the parameters you were passed. REPLACEMENT.SB.PROCESS(L.PROCESS) .. .. Your special code .. .. CALL STANDARD.SB.PROCESS(L.PROCESS) RETURN -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, September 09, 2013 11:55 AM To: U2 Users List Subject: [U2] SB Tap-In We are looking to somehow tap into the SB security to add our own logic that would always run when a process is fired off. Any thoughts? How do you control what logic gets run when the slash is typed? Any other great ideas? We know how we want to do it, but do not know where to tap into SB to have this take effect everywhere. JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Read and Writing binary files with UOJ
UniBasic provides NOCONVERT ON for that. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls Sent: Tuesday, September 03, 2013 1:12 AM To: U2 Users List Subject: Re: [U2] Read and Writing binary files with UOJ I am not a UniData user, but thought that I had found the answer with OSBREAD -- reading a block, then noticed the note about OSBREAD converting a char(0) to char(128). Ouch. If you are on on Unix, you might use uuencode to convert it to base64 and then read that in pass it in a subroutine, and then convert it back in Java. -Rick On Sep 2, 2013, at 4:51 PM, Doug Averch dave...@gmail.com wrote: Rick, It looks like you can do this with Universe UniBasic ReadBlk and we have working code. I have been unable to find any equivalent in Unidata. Thanks, Doug www.u2logic.com On Fri, Aug 30, 2013 at 6:15 PM, Rick Nuckolls r...@lynden.com wrote: Doug, Looking at my old code, I call a subroutine on the backend to do the readblk, and then use the default reverse conversion on the return argument's UniString. ( byte[] myBinary = myUnistring.toString().getBytes() ).. UOJ, in its wisdom, does not expose the raw byte array that it gets from the back end before it converts it to Java characters in a UniString, hence the code above. This might even work if you use the UniSequentialFile readBlk() function. Technically, it might be better to specify the character encoding, as in byte[] myBinary = myUnistring.toString().getBytes(ISO-8859_1), but this assumes that one are sure of what UOJ used to convert the bytes received from the server to characters, and that the conversion is 100% reversible. It is unclear that UOJ even defines an encoding, and if Localization is in use, UniStrings may not reverse to an equal byte array. Because of that uncertainty, it would be best to call a subroutine on the UDT server that did a block read of the file, a base64 encoding of it using ENCODE(...), and then, after passing it back to UOJ, use sun.misc.BASE64Decoder to convert the UniString return argument back to a byte[]. (After, of course, you convert the UniString to a String.) -- For a total of 4 conversions per source byte. Several years ago, I pointed out to Rocket (IBM?, Ardent?) that it might be more appropriate for the UniSequentialFile readBlk method to return a byte[] rather than a UniString. Obviously, it was too late for that, but it does not appear that U2 has added a readBytes() method, which is no surprise, as I recollect the conversation. (Obviously, there needs to be a writeBlk( byte[] ) or writeBytes( byte[] ) method too.) Good luck, Rick Nuckolls On Aug 30, 2013, at 2:30 PM, Doug Averch dave...@gmail.com wrote: I was at a U2U in 2010, I think, and somebody showed us how to read and write files such as tiffs using UniObjects. The example was storing them in Unidata and send them out to the web using UOJ. Does anybody know what lecture that was? Or how to do it? Regards, Doug www.u2logic.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UDT 7.1 Indexing question
It really depends on the percentage of records that contain the value you are looking for - multivalued or not I think if you include a criteria like: WITH mv_indexed_field = value it will be faster than without the index. However, if most of the records in the file have that value it won't make much difference. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Tuesday, August 27, 2013 1:46 PM To: U2 Users List Subject: Re: [U2] UDT 7.1 Indexing question That's what I was afraid of. I have a large file and I was looking for some way to speed up a report that I am creating with Uniquery. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, August 27, 2013 10:43 AM To: U2 Users List Subject: Re: [U2] UDT 7.1 Indexing question My guess is that it shouldn't matter. Each multivalue in a list gets a separate index entry. On Tue, Aug 27, 2013 at 10:46 AM, Lunt, Bruce bl...@shaklee.com wrote: Hi All, Will indexing a field that I retrieve with BY-EXP be faster than an un-indexed field? Thanks, Bruce ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] @RECORD VARIABLES
HELP CALCULATE You have to have your dictionary open to @DICT as well. I think you want to say RESULT = CALCULATE(ATTRIBUTE) Since {} is for a literal attribute name only. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Thursday, August 15, 2013 4:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] @RECORD VARIABLES I am attempting to pass a variable into a SUBROUTINE and use it to access the data through the dictionary name. SUBROUTINE fieldLookup(., ATTRIBUTE, ) . . . READ @RECORD FROM F.FILE, @ID THEN RESULT = {ATTRIBUTE} END ELSE RESULT = END The part that isn't working is the RESULT = {ATTRIBUTE} As written here it is looking for a dictionary attribute named ATTRIBUTE. I tried forcing it to evaluate the variable ATTRIBUTE to the value in ATTRIBUTE by putting it in parenthesis, but it complained that it was expecting a variable when it was compiling. Is there a way to use a variable in the curly braces so that I can make this a generic subroutine? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick flavor in U2 personal edition
If you loaded Unidata -the command is ECLTYPE P for the pick-flavored query parser. ECLTYPE U for the regular parser. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Eric Armstrong Sent: Friday, August 02, 2013 12:53 PM To: u2-users@listserver.u2ug.org Subject: [U2] Pick flavor in U2 personal edition I downloaded the U2 personal edition to my pc, and it is working, but how do I get it to use the Pick flavor? Eric Armstrong Programmer/Analyst Lobel Financial LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData Dynamic File Splitting Question
1 gmoore users 23552 Jun 25 06:15 over015 -rw-rw 1 plocklea users 21504 Jun 24 16:22 over016 -rw-rw 1 gmoore users 19456 Jan 31 11:31 over017 -rw-rw 1 gmoore users 22528 Jun 6 12:15 over018 -rw-rw 1 sbarnes users 19456 Jun 26 06:15 over019 -rw-rw 1 llowry users 21504 Jun 20 08:26 over020 -rw-rw 1 pperry users 21504 Jul 1 10:27 over021 -rw-rw 1 sbarnes users 19456 Jun 20 15:34 over022 -rw-rw 1 ebarton users 17408 Jun 20 08:26 over023 -rw-rw 1 pperry users 19456 May 26 06:09 over024 -rw-rw 1 mhester users 20480 Jun 12 15:07 over025 -rw-rw 1 pperry users 18432 May 20 12:20 over026 -rw-rw 1 pperry users 18432 May 6 13:24 over027 -rw-rw 1 jhickman users 19456 May 31 12:15 over028 -rw-rw 1 mhester users 18432 Jun 26 06:15 over029 -rw-rw 1 tbozeman users 19456 May 31 12:15 over030 -rw-rw 1 whardwic users 20480 Aug 8 2012 over031 -rw-rw 1 dbrooks users 21504 May 31 12:15 over032 -rw-rw 1 sbarnes users 21504 May 25 06:14 over033 -rw-rw 1 kconner users 20480 May 26 06:14 over034 -rw-rw 1 gmoore users 22528 May 26 06:14 over035 -rw-rw 1 whardwic users 19456 Jun 20 08:26 over036 -rw-rw 1 sbarnes users 23552 Jun 20 08:26 over037 -rw-rw 1 mchavis users 20480 Jun 12 15:06 over038 -rw-rw 1 sbarnes users 17408 Jun 20 16:28 over039 -rw-rw 1 suchavis users 20480 Jun 17 13:23 over040 -rw-rw 1 bj0663827 users 20480 Jun 27 06:15 over041 -rw-rw 1 bj0663827 users 17408 Apr 9 11:11 over042 -rw-rw 1 tsampson users 21504 Jun 3 15:54 over043 -rw-rw 1 whardwic users 19456 Jun 20 12:47 over044 -rw-rw 1 sbarnes users 21504 Jun 26 12:42 over045 sun2:/datatel/coll18/production/apphome/DATA/DATA_P/PERSON166-$ -- Cinda Goff N.C. Community College System Database Administrator 919 807-7060 vRoom Link: https://sas.elluminate.com/m.jnlp?password=M.BDCC127B096D131E11EAC16A0F9473sid=2008362 E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and shall be disclosed to third parties when required by the statutes. (NCGS.Ch.132) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData Dynamic File Splitting Question
19456 Jun 4 20:05 over012 -rw-rw 1 sbarnes users 19456 Jun 17 14:47 over013 -rw-rw 1 bsampson users 19456 May 26 06:11 over014 -rw-rw 1 gmoore users 23552 Jun 25 06:15 over015 -rw-rw 1 plocklea users 21504 Jun 24 16:22 over016 -rw-rw 1 gmoore users 19456 Jan 31 11:31 over017 -rw-rw 1 gmoore users 22528 Jun 6 12:15 over018 -rw-rw 1 sbarnes users 19456 Jun 26 06:15 over019 -rw-rw 1 llowry users 21504 Jun 20 08:26 over020 -rw-rw 1 pperry users 21504 Jul 1 10:27 over021 -rw-rw 1 sbarnes users 19456 Jun 20 15:34 over022 -rw-rw 1 ebarton users 17408 Jun 20 08:26 over023 -rw-rw 1 pperry users 19456 May 26 06:09 over024 -rw-rw 1 mhester users 20480 Jun 12 15:07 over025 -rw-rw 1 pperry users 18432 May 20 12:20 over026 -rw-rw 1 pperry users 18432 May 6 13:24 over027 -rw-rw 1 jhickman users 19456 May 31 12:15 over028 -rw-rw 1 mhester users 18432 Jun 26 06:15 over029 -rw-rw 1 tbozeman users 19456 May 31 12:15 over030 -rw-rw 1 whardwic users 20480 Aug 8 2012 over031 -rw-rw 1 dbrooks users 21504 May 31 12:15 over032 -rw-rw 1 sbarnes users 21504 May 25 06:14 over033 -rw-rw 1 kconner users 20480 May 26 06:14 over034 -rw-rw 1 gmoore users 22528 May 26 06:14 over035 -rw-rw 1 whardwic users 19456 Jun 20 08:26 over036 -rw-rw 1 sbarnes users 23552 Jun 20 08:26 over037 -rw-rw 1 mchavis users 20480 Jun 12 15:06 over038 -rw-rw 1 sbarnes users 17408 Jun 20 16:28 over039 -rw-rw 1 suchavis users 20480 Jun 17 13:23 over040 -rw-rw 1 bj0663827 users 20480 Jun 27 06:15 over041 -rw-rw 1 bj0663827 users 17408 Apr 9 11:11 over042 -rw-rw 1 tsampson users 21504 Jun 3 15:54 over043 -rw-rw 1 whardwic users 19456 Jun 20 12:47 over044 -rw-rw 1 sbarnes users 21504 Jun 26 12:42 over045 sun2:/datatel/coll18/production/apphome/DATA/DATA_P/PERSON166-$ -- Cinda Goff N.C. Community College System Database Administrator 919 807-7060 vRoom Link: https://sas.elluminate.com/m.jnlp?password=M.BDCC127B096D131E11EAC16A0F947 3sid=2008362 E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and shall be disclosed to third parties when required by the statutes. (NCGS.Ch.132) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData Dynamic File Splitting Question
over002 -rw-rw 1 ijackson users 18432 May 16 08:04 over003 -rw-rw 1 gmoore users 18432 May 14 12:09 over004 -rw-rw 1 sbarnes users 17408 Jun 4 19:03 over005 -rw-rw 1 llowry users 18432 Feb 1 13:01 over006 -rw-rw 1 dmiadmin users 17408 Jun 20 08:26 over007 -rw-rw 1 gmoore users 24576 Jun 28 07:31 over008 -rw-rw 1 gmoore users 18432 Mar 14 09:10 over009 -rw-rw 1 gmoore users 21504 May 25 06:15 over010 -rw-rw 1 gmoore users 18432 Jun 22 12:43 over011 -rw-rw 1 ijackson users 19456 Jun 4 20:05 over012 -rw-rw 1 sbarnes users 19456 Jun 17 14:47 over013 -rw-rw 1 bsampson users 19456 May 26 06:11 over014 -rw-rw 1 gmoore users 23552 Jun 25 06:15 over015 -rw-rw 1 plocklea users 21504 Jun 24 16:22 over016 -rw-rw 1 gmoore users 19456 Jan 31 11:31 over017 -rw-rw 1 gmoore users 22528 Jun 6 12:15 over018 -rw-rw 1 sbarnes users 19456 Jun 26 06:15 over019 -rw-rw 1 llowry users 21504 Jun 20 08:26 over020 -rw-rw 1 pperry users 21504 Jul 1 10:27 over021 -rw-rw 1 sbarnes users 19456 Jun 20 15:34 over022 -rw-rw 1 ebarton users 17408 Jun 20 08:26 over023 -rw-rw 1 pperry users 19456 May 26 06:09 over024 -rw-rw 1 mhester users 20480 Jun 12 15:07 over025 -rw-rw 1 pperry users 18432 May 20 12:20 over026 -rw-rw 1 pperry users 18432 May 6 13:24 over027 -rw-rw 1 jhickman users 19456 May 31 12:15 over028 -rw-rw 1 mhester users 18432 Jun 26 06:15 over029 -rw-rw 1 tbozeman users 19456 May 31 12:15 over030 -rw-rw 1 whardwic users 20480 Aug 8 2012 over031 -rw-rw 1 dbrooks users 21504 May 31 12:15 over032 -rw-rw 1 sbarnes users 21504 May 25 06:14 over033 -rw-rw 1 kconner users 20480 May 26 06:14 over034 -rw-rw 1 gmoore users 22528 May 26 06:14 over035 -rw-rw 1 whardwic users 19456 Jun 20 08:26 over036 -rw-rw 1 sbarnes users 23552 Jun 20 08:26 over037 -rw-rw 1 mchavis users 20480 Jun 12 15:06 over038 -rw-rw 1 sbarnes users 17408 Jun 20 16:28 over039 -rw-rw 1 suchavis users 20480 Jun 17 13:23 over040 -rw-rw 1 bj0663827 users 20480 Jun 27 06:15 over041 -rw-rw 1 bj0663827 users 17408 Apr 9 11:11 over042 -rw-rw 1 tsampson users 21504 Jun 3 15:54 over043 -rw-rw 1 whardwic users 19456 Jun 20 12:47 over044 -rw-rw 1 sbarnes users 21504 Jun 26 12:42 over045 sun2:/datatel/coll18/production/apphome/DATA/DATA_P/PERSON166-$ -- Cinda Goff N.C. Community College System Database Administrator 919 807-7060 vRoom Link: https://sas.elluminate.com/m.jnlp?password=M.BDCC127B096D131E11EAC16A0F947 3sid=2008362 E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and shall be disclosed to third parties when required by the statutes. (NCGS.Ch.132) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy
Re: [U2] Unidata Index question
For UniData - FOO LIKE 'ABC'... I think so - because the first part is literal. FOO LIKE ABC... I don't think so - because you aren't explicitly saying the first part is a literal. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Thursday, May 23, 2013 6:50 AM To: U2 Users List Subject: [U2] Unidata Index question I have two question about how indicies affect queries: 1) If I have an index built for a given field FOO, and perform a query with like such as FOO LIKE 'ABC...' does it benefit from the index? Or is it only queries with equality conditions that benefit from the index (eg: FOO EQ 'ABC' )? 2) If I have an index built with Empties=NO and then query with that indexed field =, how does it handle the query? Does it not use the index at all? TIA, Jeff -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
It doesn't do nothing - it rounds - if the input value is 55.5 you get 56 as output. It only does nothing if your input is a whole number.; -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Wednesday, May 08, 2013 9:37 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. George, After sending it I thought, Well,... that OCONV acomplishes nothing! Dale On 05/08/2013 08:32 AM, George Gallen wrote: What purpose will the OCONV(var,MD0) serve? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Tuesday, May 07, 2013 6:06 PM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. if var is XXX.XX ICONV(var,MD2) then OCONV(var,MD0) Dale On 05/07/2013 12:04 PM, Sathya wrote: Wjhonsonwjhonsonat aol.com writes: Satya the OSOPEN command.. what version of the system are you running? Hi,. Thanks everyone for the suggestions and I have sorted out the issue. Now I want to write some dollar values to a file. But the format in which it is in the file is XXX.XX, but I need to write it as X. Without the decimals the simple numbers. Can some help me in doing so. Thanks Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD - Display Current Terminal Type
!echo $TERM perhaps. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, April 23, 2013 5:12 PM To: U2 Mail List Subject: [U2] UD - Display Current Terminal Type I've had a brain-freeze and can't remember how to display the current terminal type at ECL. I know it's SYSTEM(7) but what ECL command do I need to display it? TERM doesn't work (although I can set it by entering TERM WYSE60). PTERM doesn't work (it gives me all kinds of other things). Any help would be appreciated. Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do you print a .pdf from inside a Unix Box
Uncomfortable with the portable part of pdf then? We just move the file over to the windows client and run: L:X -0START PDF Document /Dwindowsdirectory /WAIT filename.pdf And they print from that. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Conway - Bamac LTD Sent: Thursday, April 04, 2013 11:54 AM To: 'U2 Users List' Subject: [U2] How do you print a .pdf from inside a Unix Box I may have missed this discussion but if someone can help me that would be great. We have been executing a SB command to windows to open Adobe and print the PDF document. We would like to either not have to open Adobe and print the document or print the document from within our Unix box. We have a hp7640 11iv3 running on an Itanium processor. Here is the Unidata information: Module Name Version Licensed UniData RDBMS 7.2 Yes Connection Pooling... 7.2 No Device License... 7.2 No NFA.. 7.2 No RFS.. 7.2 No EDA.. 7.2 No 721 Oh, love this list, I have been using Pick since 1985 and still going strong. Bruce ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do you print a .pdf from inside a Unix Box
That's just the title that shows up at the top of the reader window. You don't need to specify the Adobe path and Reader - windows will figure out what program is associated with the .pdf extension and run that - this is not necessarily Acrobat Reader but most likely will be if that's all that is installed. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Conway - Bamac LTD Sent: Thursday, April 04, 2013 1:45 PM To: 'U2 Users List' Subject: Re: [U2] How do you print a .pdf from inside a Unix Box I like this - is the PDF Document portion of the command our Adobe path and Reader? Bruce -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis Sent: Thursday, April 04, 2013 12:24 PM To: U2 Users List Subject: Re: [U2] How do you print a .pdf from inside a Unix Box Uncomfortable with the portable part of pdf then? We just move the file over to the windows client and run: L:X -0START PDF Document /Dwindowsdirectory /WAIT filename.pdf And they print from that. -Original Message- From: mailto:u2-users-boun...@listserver.u2ug.org u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Conway - Bamac LTD Sent: Thursday, April 04, 2013 11:54 AM To: 'U2 Users List' Subject: [U2] How do you print a .pdf from inside a Unix Box I may have missed this discussion but if someone can help me that would be great. We have been executing a SB command to windows to open Adobe and print the PDF document. We would like to either not have to open Adobe and print the document or print the document from within our Unix box. We have a hp7640 11iv3 running on an Itanium processor. Here is the Unidata information: Module Name Version Licensed UniData RDBMS 7.2 Yes Connection Pooling... 7.2 No Device License... 7.2 No NFA.. 7.2 No RFS.. 7.2 No EDA.. 7.2 No 721 Oh, love this list, I have been using Pick since 1985 and still going strong. Bruce ___ U2-Users mailing list mailto:U2-Users@listserver.u2ug.org U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: mailto:dda...@harriscomputer.com dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] http://www.harriscomputer.com/ http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 http://www.harris-schoolsolutions.com%3chttp:/www.harris-schoolsolutions.co m www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list mailto:U2-Users@listserver.u2ug.org U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message
Re: [U2] How do you print a .pdf from inside a Unix Box
As long as the pdf extension has been linked to a reader program in windows, it should be opening up the document in the reader program automatically. I have used the acrobat reader switch to automatically print before (bringing up the Windows printer dialog, I mean to say), but not with the start command - never had a good reason to, most people want to preview what they print anyway. I did use it back when I called the acrobat reader program directly. I switched to start because that kept me from having to worry about where the reader program was located and what it was called - that gets changed a lot I've noticed. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Conway - Bamac LTD Sent: Thursday, April 04, 2013 2:15 PM To: 'U2 Users List' Subject: Re: [U2] How do you print a .pdf from inside a Unix Box Oh Dave, This just opens the window. I tried this and what it is doing is opening the windows folder and the user then double click on the document and print. I was looking for an automatic process to do the printing. Bruce -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis Sent: Thursday, April 04, 2013 12:24 PM To: U2 Users List Subject: Re: [U2] How do you print a .pdf from inside a Unix Box Uncomfortable with the portable part of pdf then? We just move the file over to the windows client and run: L:X -0START PDF Document /Dwindowsdirectory /WAIT filename.pdf And they print from that. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Conway - Bamac LTD Sent: Thursday, April 04, 2013 11:54 AM To: 'U2 Users List' Subject: [U2] How do you print a .pdf from inside a Unix Box I may have missed this discussion but if someone can help me that would be great. We have been executing a SB command to windows to open Adobe and print the PDF document. We would like to either not have to open Adobe and print the document or print the document from within our Unix box. We have a hp7640 11iv3 running on an Itanium processor. Here is the Unidata information: Module Name Version Licensed UniData RDBMS 7.2 Yes Connection Pooling... 7.2 No Device License... 7.2 No NFA.. 7.2 No RFS.. 7.2 No EDA.. 7.2 No 721 Oh, love this list, I have been using Pick since 1985 and still going strong. Bruce ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http: //www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users
Re: [U2] How do you print a .pdf from inside a Unix Box
Interesting. How long did it take to write a compliant reader? We handle the problem in #8 with a Catalog entry in the PDF file. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Rasmussen Sent: Thursday, April 04, 2013 4:32 PM To: U2 Users List Subject: Re: [U2] How do you print a .pdf from inside a Unix Box Sometimes the hardest information to find is that what you want to do isn't possible. So let me tell you what is and what isn't possible, in printing PDFs in Windows. 1) You can OPEN a PDF based on its file extension. From the command line, you can simply type type pathname of the PDF. From Windows Explorer, you can double-click. These use a system in Windows called file associations. Specifically here, you're using the OPEN verb. In the Windows registry there is a command associated with .PDF and open; typically it runs Adobe Reader. Once open, it is up to the user to print the file. 2) You can also execute the command string yourself, if you know what EXE to use. That is what you cited in a later email. 3) In Windows Explorer, you can also right-click on a PDF and select Print, to cause Windows to print the file on the default printer. This is using the print verb in the file association. Behind the scenes, this will run a command, typically running Adobe Reader with a /p parameter (for print). 4) There is NOT an equivalent way to do this from the command line. 5) You can create a shortcut to a specific printer on your desktop. Then you can drag a PDF to this shortcut, and it MAY print on this (non-default) printer. This uses the less-documented printto verb in the system of file associations. Support in Reader for printing in this way has varied by version. 6) There is NOT an equivalent way to do this from the command line. 7) You MIGHT be able to invoke Reader with some command line parameters to cause it to print on a specific printer. Results may vary by version. 8) NONE of these will let you control various output options in Reader, such as whether the report should be shrunk to fit the printable page. 9) All of these assume that the PDF file to be printed exists on the Windows PC, or is accessible to it, such as via Samba. None will pull the file from an HTTP or FTP server. Bottom line is that there is not a good and convenient way to do this using Windows commands. However, we offer a solution, in the form of our Print Wizard product. Consider the following command: printwiz.exe http://somehost.com/somefile.pdf /pMy laserjet printer This will bring up printwiz.exe, which will fetch the PDF from the http server into memory (never being stored on the local disk), and print it to the specified printer. Printwiz is doing the PDF interpretation itself, it is not using any Adobe or other products. There are a huge number of other options, such as shrink-to-fit, page range, multiple copies, password entry, preview, watermarking, form overlaying, and more. See www.anzio.com for more details and a free demo. On Thu, 4 Apr 2013, Bruce Conway - Bamac LTD wrote: I may have missed this discussion but if someone can help me that would be great. We have been executing a SB command to windows to open Adobe and print the PDF document. We would like to either not have to open Adobe and print the document or print the document from within our Unix box. We have a hp7640 11iv3 running on an Itanium processor. Here is the Unidata information: Module Name Version Licensed UniData RDBMS 7.2 Yes Connection Pooling... 7.2 No Device License... 7.2 No NFA.. 7.2 No RFS.. 7.2 No EDA.. 7.2 No 721 Oh, love this list, I have been using Pick since 1985 and still going strong. Bruce ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris
Re: [U2] How do you print a .pdf from inside a Unix Box
With us - the issue was to keep it from defaulting to shrink to fit. It wasn't important to make it always be one setting, just to get it defaulted the way I needed. The users wouldn't typically know to change this to the appropriate value for themselves. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Rasmussen Sent: Thursday, April 04, 2013 5:14 PM To: U2 Users List Subject: Re: [U2] How do you print a .pdf from inside a Unix Box On Thu, 4 Apr 2013, Dave Davis wrote: Interesting. How long did it take to write a compliant reader? It took YEARS. And I don't claim to be finished. We handle the problem in #8 with a Catalog entry in the PDF file. I assume you're referring to the fit-to-page setting. But my understanding is that you can set the printing preferences to a) edge-to-edge, or b) default, which means to behave according to the reader's default setting. There is NOT a way to set it to always shrink to fit. If I'm wrong, please provide specifics. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Rasmussen Sent: Thursday, April 04, 2013 4:32 PM To: U2 Users List Subject: Re: [U2] How do you print a .pdf from inside a Unix Box Sometimes the hardest information to find is that what you want to do isn't possible. So let me tell you what is and what isn't possible, in printing PDFs in Windows. 1) You can OPEN a PDF based on its file extension. From the command line, you can simply type type pathname of the PDF. From Windows Explorer, you can double-click. These use a system in Windows called file associations. Specifically here, you're using the OPEN verb. In the Windows registry there is a command associated with .PDF and open; typically it runs Adobe Reader. Once open, it is up to the user to print the file. 2) You can also execute the command string yourself, if you know what EXE to use. That is what you cited in a later email. 3) In Windows Explorer, you can also right-click on a PDF and select Print, to cause Windows to print the file on the default printer. This is using the print verb in the file association. Behind the scenes, this will run a command, typically running Adobe Reader with a /p parameter (for print). 4) There is NOT an equivalent way to do this from the command line. 5) You can create a shortcut to a specific printer on your desktop. Then you can drag a PDF to this shortcut, and it MAY print on this (non-default) printer. This uses the less-documented printto verb in the system of file associations. Support in Reader for printing in this way has varied by version. 6) There is NOT an equivalent way to do this from the command line. 7) You MIGHT be able to invoke Reader with some command line parameters to cause it to print on a specific printer. Results may vary by version. 8) NONE of these will let you control various output options in Reader, such as whether the report should be shrunk to fit the printable page. 9) All of these assume that the PDF file to be printed exists on the Windows PC, or is accessible to it, such as via Samba. None will pull the file from an HTTP or FTP server. Bottom line is that there is not a good and convenient way to do this using Windows commands. However, we offer a solution, in the form of our Print Wizard product. Consider the following command: printwiz.exe http://somehost.com/somefile.pdf /pMy laserjet printer This will bring up printwiz.exe, which will fetch the PDF from the http server into memory (never being stored on the local disk), and print it to the specified printer. Printwiz is doing the PDF interpretation itself, it is not using any Adobe or other products. There are a huge number of other options, such as shrink-to-fit, page range, multiple copies, password entry, preview, watermarking, form overlaying, and more. See www.anzio.com for more details and a free demo. On Thu, 4 Apr 2013, Bruce Conway - Bamac LTD wrote: I may have missed this discussion but if someone can help me that would be great. We have been executing a SB command to windows to open Adobe and print the PDF document. We would like to either not have to open Adobe and print the document or print the document from within our Unix box. We have a hp7640 11iv3 running on an Itanium processor. Here is the Unidata information: Module Name Version Licensed UniData RDBMS 7.2 Yes Connection Pooling... 7.2 No Device License... 7.2 No NFA.. 7.2 No RFS.. 7.2 No EDA.. 7.2 No 721 Oh, love this list, I have been using Pick since 1985 and still going strong. Bruce ___ U2-Users mailing list U2-Users@listserver.u2ug.org
Re: [U2] unidata env var
Uppercase has always worked for me. $VFIELDSIZE and $vfieldsize are distinct variables to the operating system, so I suspect you should stick with uppercase. 6000 - that's huge - what are you putting in these things? I've had to increase to 380 or so before. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Thursday, March 21, 2013 6:52 AM To: U2 Users List Subject: [U2] unidata env var We've had some issues with i-desc failing over years and the solution was to set the evironment variable VFIELDSIZE to some amount (6000 or more). My real question is does unidata care about case for this variable (on *nix, not windoze)? I've seen it documented both as VFIELDSIZE and vfieldsize and not sure unidata sees one or both of these. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] correlative syntax
I believe this means if result of last expression is not empty, where last expression is oconv(@,file;x;0;0) in this case. Written another way: OCONV(OCONV(@ID,G0*1),FILE;X;0;0) # -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Thursday, February 28, 2013 4:29 PM To: 'U2 Users List' Subject: [U2] [UD] correlative syntax A coworker just ran across the following in one of our DICTs. The name of the item indicates it was written by someone who is no longer with the organization and was well known for knowing wonderful arcane UniData tidbits. We can't find anything describing what exactly is going on. The end result is very useful. I'm wondering if anyone can explain the @# bit. OCONV(@ID,G*1); OCONV(@,FILE;X;0;0); @# The file the DICT is in has a compound key: ACCOUNT.NUMBER*sequential. What this item does is grab the account number, attempt to read from FILE and return a 0 if the account doesn't exist in FILE or a 1 if it does. Pretty nifty. UD7.1 AIX5.3 TIA, Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] : Evaluating DCOUNT
I think every time, since it's the second argument. If it doesn't matter, you can do for i = dcount(array,@fm) to 1 step -1 to have it evaluate once. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Monday, February 11, 2013 12:15 AM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] : Evaluating DCOUNT Hi Everyone, Does a DCOUNT get evaluated again for each iteration of a loop? Or is UniVerse these days intelligent enough to keep track of what's going on? e.g. for i = 1 to dcount(array,@fm) *commands here next i versus totalattributes = dcount(array,@fm) for i = 1 to totalattributes *commands here next i Apart from readability and perhaps easier debugging is there an actual internal difference? I know it was an issue on older pick releases but I cannot remember if it ever affected UV? Cheers Peter --- Note: 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 Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] {BDT] Commenting A Block Of Code
You could surround the lines with an IF statement that always evaluates to false. Not the same as commenting out of course. IF (0) THEN Code you don't want to run. END -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Wednesday, January 09, 2013 8:25 PM To: U2 Users List Subject: [U2] {BDT] Commenting A Block Of Code Rather than going line-by-line... is there a way... or a trick to highlighting several lines of code... And commenting out all of these lines in aggregate? I have a legacy program whose code is no longer compliant... that I am trying to isolate. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1.15 Oddity
Were you doing an OCONVS or just an OCONV? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, November 09, 2012 11:46 AM To: U2 Users List Subject: Re: [U2] Unidata 6.1.15 Oddity Thank you everyone for the feedback. I had some suspicion in the back of my mind that doing an OCONV MCU on a full mv'd string was a Somewhat Bad Idea, now I know why. :-) On Thu, Nov 8, 2012 at 10:56 AM, Woodward, Bob bob_woodw...@k2sports.comwrote: Hi Kevin, Two times in my Unidata career I've had a problem like this where something doesn't work in a subroutine. My work around, both times, was to add a simple line of code at the beginning of the program. Usually just assigning a value to a new, unused, variable like JUNK=JUNK is all it would take. With it, the program would work flawlessly but if I took it back out, or commented it out, the odd behavior returned. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, November 07, 2012 4:26 PM To: U2 Users List Subject: [U2] Unidata 6.1.15 Oddity We have a customer who has a system that was rebooted a couple days ago. Since then, and only in one certain subroutine, when doing an MCU conversion on a multivalued list, the ASCII 253 value marks are replaced with ASCII 221. Understanding that the difference between an lower and upper case A is 32 in the ASCII table (97 - 65), it seems like Unidata is treating the delimiters like normal characters. But again, this only happens in certain programs. If I extract the lines of code that exhibit this behavior into its own program, the problem does not occur. Any ideas what might be causing this and only in one subroutine? Both my test program and the real program with the problem are $BASICTYPE U. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe and data-stacking
Have you tried SB.LOGIN.RP instead? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Joslyn Sent: Wednesday, September 26, 2012 10:23 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe and data-stacking Hi geniuses! I know that in Unidata there is a udt options flag that allows data-stacking to work. I can't find anything similar in Universe. But even if I could, my problem seems to run a little deeper than that. I can write a test program that data stacks two pieces of info into another program that has two input commands. No problem, that works. But if I try to CHAIN or EXECUTE SB.LOGIN datastacking the user ID and password it fails. But get this - it succeeds in some of the accounts (universe directory accounts) but fails in others. Is there something about the accounts, the flavor, some setting that would prevent a datastack from making it -- maybe because it is a chained command? I tried it with EXECUTE, no difference. Anyone run into something like this? Anyone who is an SB+ user might suggest that I use the AUTOLOGIN option, but that doesn't change the behavior at all. It still makes me login, still won't take the data stack. I am not well-versed at administrative commands that might tell me things about the account settings and flavor and tunable parameters - so if there is something obvious I could look at, don't assume that I know it. Any and all help, as always, greatly appreciated! Susan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
'PASSLIST' or Misuse of Reserved Word 'RTNLIST'. I've tried UDTEXECUTE with no compilation errors but also no improvement on the problem. I've even tried MDPERFORM but I get the misuse errors with the RTNLIST and PASSLIST options. Oddly enough, removing $BASICTYPE U I don't get an error on MDPERFORM but I can't READNEXT from a numbered select without the $BASICTYPE U. How should I structure this SUBR(..) so that it does not consume list 0 when selecting to list 3? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== 04y!LlOoL8USVGrPZehFfPKcPPmbfFPdrr1lqOECv!Swg== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
What we do in situations like this is set up a subroutine that retrieves the list of record keys in B, given the value of the index I want to retrieve. This can then be called from an I-type in A, or from another subroutine. I do the sort the hard way (in basic) so that the keys are in the correct order, usually using LOCATE with AL or AR and INSERT. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, September 24, 2012 1:55 PM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Good thought on the index, but alas, no index on the file. We could probably add one, but then how do we control the order of the records being retrieved from the list? (The order is important to our process.) On Mon, Sep 24, 2012 at 11:49 AM, Dave Davis dda...@harriscomputer.comwrote: Aren't these nested selects kind of slow? If the field in file b is indexed, I would use the SETINDEX and READFWD statements in place of the SELECT statement. You are using Unidata, so unless you need to make this work for Universe as well that's what I would do. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, September 24, 2012 1:43 PM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Well, that success was short lived. While the READLIST and FORMLIST allow my SUBR(..) field to not consume the active select list zero, these two commands produce different results: LIST ORDER.LINE WITH fieldName fieldName ...this will show the lines that have this field set, and will show the field properly. However, this command returns no items: SELECT ORDER.LINE WITH fieldName Basically my program is doing this: READLIST ACTIVE.LIST FROM 0 ELSE NULL * CMD = select ... TO 2 EXECUTE CMD CAPTURING OUTPUT * EOF = @FALSE LOOP READNEXT ID FROM 2 ELSE EOF = @TRUE UNTIL EOF DO .. REPEAT * CLEARSELECT 2 * FORMLIST ACTIVE.LIST TO 0 All other input/ideas appreciated. On Mon, Sep 24, 2012 at 11:26 AM, Kevin King ke...@precisonline.com wrote: And we have a winner! Thank you everyone! The READLIST and FORMLIST will work; seems kinda kludgy, but hey, it's working. On Mon, Sep 24, 2012 at 11:21 AM, David A. Green dgr...@dagconsulting.com wrote: If you already have an active list then you'll have to save it, then restore it. See READLIST and FORMLIST. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, September 24, 2012 10:11 AM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists It's all fine if the program controls both lists, but in this case the SUBR(..) type field could be accessed in just about any context, from TCL, from a download, from MITS, from another BASIC routine, with or without a select list... The RTNLIST doesn't solve the problem of my select command consuming the active list 0. It seems that the PASSLIST extension to EXECUTE is designed specifically for this purpose, but it produces nothing but compilation errors: CMD = select ... EXECUTE CMD CAPTURING OUTPUT RTNLIST 2 PASSLIST 2 ...produces a compilation error about the misuse of RTNLIST, despite the documentation saying this should be possible. The point is that I want to leave select list 0 entirely alone, which is why I'm using $BASICTYPE U. BASICTYPE P - standard on these SB+ systems - does not allow one to READNEXT from anything but list 0, and I want to leave list zero untouched. Gotta be a way, right? -K On Mon, Sep 24, 2012 at 10:56 AM, Martin Braid mbr...@epicor.com wrote: Hi Kevin, Any reason why you are using type U ? This certainly works using P ... S='SELECT SOMEFILE WITH SOMETHING = OOJIT' EXECUTE S RTNLIST MYLIST CAPTURING ANYOUTPUT EOF=0 LOOP UNTIL EOF DO READNEXT MYID FROM MYLIST THEN GSOUB MYMESS END ELSE EOF=1 REPEAT Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: 24 September 2012 17:49 To: 'U2 Users List' Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Can you use SELECT yourfile WITH whatever TO 8 {specific list number} in the master process, and let your SUBR virtual field default to list 0 {zero}? The other option could be to do a READLIST within the SUBR function and reset the list when RETURNing, but this could be onerous in terms of processing speed. HTH -Baker -Original Message- From: u2-users-boun
Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
Well aware of all that, especially the negative numbers issue. I restrict use of AR, DR locates to non-negative integers. Otherwise I use comparisons inside of a loop. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Monday, September 24, 2012 3:44 PM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Dave, Be careful with that because LOCATE's sort BY AR or DR may be different from LIST's sort BY an R-justified field. Leading zeros, negative numbers, decimals with trailing zeros all come to mind. If I recall that inconsistency is consistent across several MV platforms. However, it might be more consistent of UD to be inconsistent with the MV-world (the MV-universe) on this point. cds On 9/24/2012 1:04 PM, Dave Davis wrote: What we do in situations like this is set up a subroutine that retrieves the list of record keys in B, given the value of the index I want to retrieve. This can then be called from an I-type in A, or from another subroutine. I do the sort the hard way (in basic) so that the keys are in the correct order, usually using LOCATE with AL or AR and INSERT ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB.SMART.QUERY
You need to go to AdminSB+ SetupSB+ Configuration PatternsF5-System Defaults and set the SB+ Subroutines in Dictionaries field to Y After that you would need to regenerate the dictionary entries so that the default ERROR i-type gets replaced with an i-type that uses the SB.SMART.QUERY function. Try re-saving one or two fields you are interested in after you set the flag above. What SB.SMART.QUERY does is use the executable expression of your SB+ expression to return a value that can be used in query statements. What the flag does is tell SB+ to generate the executable expression and create the i-type that uses it with SB.SMART.QUERY, after you save a field definition. I did a similar thing myself before they made SB.SMART.QUERY available. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dennis bartlett Sent: Sunday, August 19, 2012 8:00 PM To: U2 Users List Subject: [U2] SB.SMART.QUERY Hi Does anyone know how I can get SB.SMART.QUERY documentation? Alternatively (or maybe in addition) do you know how to call SB.SMART.QUERY to decifer DICT items much like ITYPE(xx) does in BASIC? The IBM release notes talk about SB.SMART.QUERY being IBM's response to people wanting to use SB reporting outside of the SB+ environment - now this is EXACTLY what I need, but I can't figure out how to do it. I've written my own half-blown version, but it would be oh-so-easy to simply use theirs.. Thanks Dennis Bartlett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Select Statement Invalid
Maybe your statement is too long. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: Wednesday, July 11, 2012 7:19 PM To: u2-users@listserver.u2ug.org Subject: [U2] Select Statement Invalid Unidata 7.1.20, pick flavor I have this quick paragraph to select records based on partial keys: 001: PA 002: SELECT WIPMTLRQ WITH @ID = 299486]302667]318583]337991]374396]376742]382767]385661] 398932]415256]445409]453821] 454353]478175]478845]502457] Bottom. However, this is what I get when I run it: No data retrieved from current (S)SELECT statement. Yet if I run SELECT WIPMTLRQ WITH @ID = 299486] I get records returned. What am I missing? Thanks. Albert DeWitt, CPIM ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Exiting UniData
Runs the globally cataloged program _SB_SH.OFF -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, July 03, 2012 10:31 AM To: 'U2 Users List' Subject: [U2] Exiting UniData Going back to my post about runaway processes: According to our UniData manuals, the official commands to terminate a UniData session are BYE, LO and QUIT. I have since found that LO and OFF (not sure where this came from) simply run the QUIT command. QUIT runs an SB command called SH.OFF (which we obviously do not have the source code to review). BYE still runs the verb BYE, so nothing different there. We are using Avanté which obviously is built with SB. My question is this: do ALL SB sites change the value of QUIT to run SH.OFF, or was this something that Epicor does? If anyone is using SB but NOT using an Epicor product, what does your QUIT command do? Thanks John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Regarding: Unidata dictionaries
Create a dialog definition and use an expression to contain your message. Put your text in @VALUE. Use the DIALOG process to display the definition. It should work fine. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Thursday, June 21, 2012 1:55 PM To: 'U2 Users List' Subject: Re: [U2] Regarding: Unidata dictionaries I have just come across a problem that is sort of related to the problem with UniQuery and single quotes noted in Dan's article. I thought that I would share what is happening to see if there is an answer. We are using Unidata 7.1 and SB+ 5.3. I have written a Basic program to extract a file and when it finishes I will either display the error message or if it was successful I want to print a message that tells them that they can find their file at C:\WINDOWS\TEMP\filename.xml. The method that I use for displaying the messages is CALL SB.DISP(4,message here). When I run the job it does not display the message but if I remove the '\' characters it works fine. Is there some way to get this message to display without removing the '\' characters? I find it very interesting that I have never seen this problem before and then the very next day after reading the article by Dan McGrath it happens to me. Thanks in advance, Bruce -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Wednesday, June 20, 2012 12:25 PM To: U2 Users List Subject: Re: [U2] Regarding: Unidata dictionaries Satya, I have a small write up I did a while ago that might help you: http://u2tech.wordpress.com/tips-hints/dictionary-tips-hints/ Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya Sent: Wednesday, June 20, 2012 10:18 AM To: U2 Users List Subject: [U2] Regarding: Unidata dictionaries Hi, Could you let,me know what is the difference between PH- type records, D-type records,V-type records,X-type records Thank you, Satya ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Monthly Multivalue Inserts and Speed
You are probably better off sizing the file correctly, or sizing it to the size it will be at the end of the year, than trying to do what you are proposing. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Friday, June 01, 2012 10:30 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Monthly Multivalue Inserts and Speed I have a file that is taking a very long time to update, seemingly longer and longer each month. Here is briefly how the attributes are organized, a relatively simple example: Attribute 1 is multivalued with our G/L Period, i.e. 12-01 vm 12-02 vm 12-03 etc. Attributes 2 through 30 are dependent on attribute 1 and contain a variety of dollar amounts that are accumulated for the respective period in attribute 1. At the end of each month, a new G/L Period is inserted into the multivalued position of attribute 1 as well as each of the respective multivalued positions in attributes 2 through 30. Nothing complicated. My question is this and is aimed largely at the technicians at Rocket ... If, at the beginning of the year, I were to insert each of the 12-periods into their respective multivalues in attribute 1 and insert respective null multivalues into attributes 2 through 30, thus performing all of the 'inserts' at once, will the processing each month run faster as numbers are simply accumulated into attributes 2 through 30 and no inserting of new multivalues will have to be performed? A couple nuggets of information: This is only an example. In the actual file, these records contain many other attributes and the records overall are relatively large, averaging lengths of about 3,000 according to FILE.STAT These are not my files so reorganizing them is not an option. The heart of this question is, as a (numeric) number is accumulated in an attribute, multivalue or subvalue, what causes the record to 'stretch' in length, thus presumably impacting performance? I would like to think that numeric information is stored in a more 'compact' method than strings, thus using less space within the database ... but what I 'like' and what 'is' are often quite different. Thanks! Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com http://www.hubbardsupply.com Delivering Products, Services and Innovative Solutions ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Excel Worksheets
That would be nice. I create separate CSV files and use macros to load each into a separate sheet. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jim Koca Sent: Saturday, June 02, 2012 3:17 AM To: u2-users@listserver.u2ug.org Subject: [U2] Excel Worksheets I am sending a CSV file to excel, and would like to divide it into separate worksheets. Is there a special value I can insert in the file which would cause the following data to create a separate work sheet ? Thanks, Jim Koca Cell Phone: 630.253.0007 Home Office: 630.629.5589 Email: jk...@comcast.net ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Report page counter
Is your Multiple Records Per Page set to N? Are your multi-valued fields set up with negative Max MV Lines? I've not encountered this problem in my forms. Make the entire report in the D section - you don't really need an actual heading section for a form-style report. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, April 13, 2012 2:38 PM To: SB Solutions; U2 Users List Subject: [U2] SB Report page counter Hi group, I'm having a problem with page breaks and page number counter in a SB Form report. I have a report that is set up with Headings, Column Headings, and a Detail line defined. I have a dict item defined, PAGE.OF with a derived field definition of: ('Page ':@RV.MV.PAGE:' of ':@RV.MV.PAGE.CNT) On the report, I am getting this value as: Page 1 of 1 Unfortunately, it's not changing for a more than one page listing. The format of the report is that it's a single record with multiple details from the AMV group of the record. It's like an invoice record where the structure is a single record with MV attributes for the detail lines. If there are enough values, the printout starts with the headings on page one, then the column headings, then a number of detail (MV) lines. It then reprints the headings and column headings then continues with the rest of the detail (MV) lines. If I send the report to the HOLD file then edit the output, I see the printer initialize escape sequences at the top, before the first heading, but at the point where the headings are printed a second time, I am not seeing a Form-Feed escape sequence. Anyone have thoughts on where I might look for what controls the page length and what triggers the update to the two @ variables? Hope I've explained this properly. TIA, BobW ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Indexing I-Desc
As long as all the data comes from the record and/or id itself, you should be fine. You can get into trouble if it comes from another record in the same file or another file entirely, although it can be done if the other file contains stable data - a word index for example, where you have a secondary file that contains words that are not included in the index, and the list is updated with all the dependent indices as part of a maintenance routine. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, March 06, 2012 1:41 PM To: 'U2 Users List' Subject: [U2] Indexing I-Desc I have a select that is taking too long. Many of the fields are I-Descs. Some are extracting a piece of info from the file, some are translates to other files, and some are running subroutines. I understand that danger of indexing a translate or subroutine (if the source data changes, the index is not updated). However, I am toying with the idea of building a new I-desc that in some way combines the data in the core file itself. For example, if I need F11 F20[4,1] and F40, make an I-desc that combines these and then index that I-desc. Just as a sanity check, does this sound like a reasonable thing to do so that I can at least grab a subset of the data I need prior to actually plowing through the translates and subroutines? John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Passing by Value
Use parentheses when you call: CALL MY.SUBR((firstval), (secondval), etc) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin Sent: Thursday, January 26, 2012 9:40 AM To: u2-users@listserver.u2ug.org Subject: [U2] Passing by Value Unidata 7.1 I think this has come up before (side question: how do you search the archives?)... I think it is possible to pass a parameter by value instead of by reference. This, of course, means that any changes to the parameter in the called subroutine are localized and its original value in the calling routine is unchanged there. Does anyone do this? If so, how?Cheers,Kebbon ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Passing by Value
By way of naming convention: FOR PROCESS_I = 1 TO 20 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, January 26, 2012 1:09 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Passing by Value On a related note, any clever ideas to localize a variable to a local subroutine? For I = 1 to 10 GOSUB PROCESS Next I Stop 3000 Lines of code later PROCESS: FOR I = 1 TO 20 PRINT I NEXT I RETURN ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Passing by Value - Found word(s) list error in the Text body
Before my time. I don't really do the PROCESS_I thing - but if necessary I do try to associate the name of the index variable with the thing being indexed. We use a lot of SB+ paragraph code so the subject of internal subroutines does not really present itself. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Garry Smith Sent: Thursday, January 26, 2012 2:35 PM To: U2 Users List Subject: Re: [U2] Passing by Value - Found word(s) list error in the Text body Is Mr Davis previously graduated from ASM in 1974? Garry L. Smith Director Info. Systems Charles McMurray Company T# 559-292-5782 F# 559-346-6169 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis Sent: Thursday, January 26, 2012 10:17 AM To: U2 Users List Subject: Re: [U2] Passing by Value - Found word(s) list error in the Text body By way of naming convention: FOR PROCESS_I = 1 TO 20 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, January 26, 2012 1:09 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Passing by Value On a related note, any clever ideas to localize a variable to a local subroutine? For I = 1 to 10 GOSUB PROCESS Next I Stop 3000 Lines of code later PROCESS: FOR I = 1 TO 20 PRINT I NEXT I RETURN ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]h ttp://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB print output question
@RV.OUT.DEVICE -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Monday, December 12, 2011 2:33 PM To: u2-users@listserver.u2ug.org Subject: [U2] SB print output question Hi All, This question is for the SB+ users out there. I would normally post it to their list but I forgot the password and I was hoping this could be answered here. :-) What I need to know is where the value is stored for the choice of printed output. The screen will prompt with: Output To Screen/Printer/auX/Diff/File (S/P/X/D/F) Where is the result stored? I want to check for whether the user has entered 'F' for sending it a file rather than to a printer but I don't see where it is kept by the system. Can anyone help me? Thanks, Bruce ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB print output question
In the PD.R process - F9-Additional - there is a Display Print Sel Screen that you can set to N to have it omit the prompting. The problem there is you only want it to do this for the F option. I've created a PD.R process where the stationery is calculated using an expression and the F option is preset in the report definition. The Display Print Sel Screen is set to N. The report itself doesn't do anything other than have the process at end slot execute the report that I actually want to run, the name of which has been loaded in a common variable. You pretty much need to prompt for output destination before you execute the actual report process. If the result is an F then do something like the above. Otherwise, run another report process where the output destination is still set to Ask, and the Display Print select screen is not N. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Monday, December 12, 2011 3:54 PM To: 'U2 Users List' Subject: Re: [U2] SB print output question I have another question: This one is about the output itself. What I am doing is creating the report with the Report Writer. When the report is finished the SB+ Print Manager prompts for the Printer Name, Stationary, Assign Options and No of Copies. Well, if I have chosen the 'F' option then I don't need the print manager to ask theses questions but it asks me anyway. Is there a way to stop it from prompting if 'F' was entered but prompt like normal, otherwise? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis Sent: Monday, December 12, 2011 11:35 AM To: U2 Users List Subject: Re: [U2] SB print output question @RV.OUT.DEVICE -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Monday, December 12, 2011 2:33 PM To: u2-users@listserver.u2ug.org Subject: [U2] SB print output question Hi All, This question is for the SB+ users out there. I would normally post it to their list but I forgot the password and I was hoping this could be answered here. :-) What I need to know is where the value is stored for the choice of printed output. The screen will prompt with: Output To Screen/Printer/auX/Diff/File (S/P/X/D/F) Where is the result stored? I want to check for whether the user has entered 'F' for sending it a file rather than to a printer but I don't see where it is kept by the system. Can anyone help me? Thanks, Bruce ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http: //www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2
Re: [U2] End of Month date routine
Month = Oconv(current.date,'DM') ;* find month Year = Oconv(current.date,'DY') ;* find year Month = Month + 1 ;* find next month If (Month 12) then Month = 1 Year = Year + 1 End FirstDayNextMonth = Iconv(Month:/01/:Year,'D') ;* assumes MM/DD/ format LastDayThisMonth = FirstDayNextMonth - 1 ;* self-explanatory. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, December 05, 2011 2:03 PM To: u2-users@listserver.u2ug.org Subject: [U2] End of Month date routine Does someone have a routine that, no matter what day you run it, returns the End of Month Date ? (Assume the end of month date, is the calendar end of month date not some screwy business date) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o explicit readu.
I don't know about UV but in UD, LIST.QUEUE shows waiters. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Monday, October 24, 2011 5:12 PM To: U2 Users List Subject: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o explicit readu. UV 10.2.10 on Windows is behaving differently from what I recall. Are my expectations out of line? Suppose Session A holds a readu lock; and Session B attempts a WRITE to same record withOUT!!! 1st explicitly getting the readu lock. Session B waits for Session A to release the lock before writing the record. While Session B is waiting, does it show up as a waiter in LIST.READU EVERY? I expected so, but it doesn't. Session A Session B _ ___ 1A. ED VOC DUMMY (this sets the readu lock.) 2A. (stay in editor)2B. run this: 01:OPEN 'VOC' TO F ELSE STOPM 'nope' 02: ***READU REC FROM F, 'DUMMY' ELSE NULL 03:WRITE '' TO F, 'DUMMY' 3A. Within ED: XEQ LIST.READU EVERY If I UN-comment line 2, LIST.READU EVERY shows something like this: Active Read Waiters: Owner Waiter Device Inode Userno Userno 746117947232860913 61163396 But when I comment out line 2, LIST.READU is silent. I have not yet explored what the deadlock daemon does. TIA, cds P.S. Yes, yes, Bad Form, Legacy Software, 20 min wait is configurable, . . . we can talk later. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata AIX commands for commands like LIST.READU and LIST.QUEUE?
Figured as much. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, October 20, 2011 8:15 PM To: U2 Users List Subject: Re: [U2] Unidata AIX commands for commands like LIST.READU and LIST.QUEUE? My apologies on the LLOCKS; Steve's right, that's a Prelude-ism. And while I could write a script to start up udt, the problem here is that if all of the udt licenses are in use, there's no way to get this kind of information in AIX to figure out what might be going on with the system (i.e. a deadlock). And PORT.STATUS is definitely not the same as ps; while both have their place, I'm not entirely certain how I would get the CALL.STACK option from PORT.STATUS out of ps. Jeff, if you have a solution for that one, I'm all ears. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata AIX commands for commands like LIST.READU and LIST.QUEUE?
LLOCKS? What is that? You could certainly write a batch script that would pass these commands to udt to get output. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, October 20, 2011 3:03 PM To: U2 Users List Subject: [U2] Unidata AIX commands for commands like LIST.READU and LIST.QUEUE? Are there AIX equivalent commands for the following Unidata TCL commands: PORT.STATUS LIST.READU LIST.QUEUE LLOCKS Also, is there any AIX command that will show that a particular telnet session is no longer active (i.e. user X'd out incorrectly or network dropped them)? -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Lock Status
I don't see anything in the LIST.QUEUE output, but I can see how that would be useful. If you have control of the source code for all of the file i/o operations you could write your own wrapper routines for the commands that set record locks, get the information from SYSTEM(49) (the program stack), and write it to a file somewhere, keyed by file name and record key. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, September 08, 2011 11:06 AM To: U2 Users List Subject: [U2] Lock Status Is there anything in Unidata that would report the line of code that set a particular record lock? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Lock Status
It's a shame there isn't a file trigger operation on locking reads, just updates and deletes. That way you could just add it to the file in question. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, September 08, 2011 11:16 AM To: U2 Users List Subject: Re: [U2] Lock Status Dave: Two Words: Vendor App. Good idea, but not possible in this case. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Lock Status
It would be useful, except that the problem is the locker causing the problem probably hasn't updated the record yet, which most likely would release the lock (this being an SB+ application) and end the problem. Retaining the lock after an update is something that would likely be coded in unibasic. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Thursday, September 08, 2011 11:28 AM To: U2 Users List Subject: Re: [U2] Lock Status On Thu, Sep 8, 2011 at 11:26 AM, Dave Davis dda...@harriscomputer.com wrote: It's a shame there isn't a file trigger operation on locking reads, just updates and deletes. That way you could just add it to the file in question. The update trigger might be useful. Most ppl would lock the record before updating it. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Lock Status
If only the lock table was an actual hashed file that you could place an update trigger on. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, September 08, 2011 11:15 AM To: U2 Users List Subject: Re: [U2] Lock Status That's useful for determining where that port is, but we have a process leaving rogue locks lying around. Anything that tells what updated the lock table? On Thu, Sep 8, 2011 at 9:10 AM, Daniel McGrath dmcgr...@rocketsoftware.comwrote: Once you know the pid of the program with the lock, you can use PORT.STATUS to determine this. You just need to use the CALL.STACK option. IIRC (It's been a few months) it would be like: PORT.STATUS PID the progs pid here CALL.STACK Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, September 08, 2011 9:06 AM To: U2 Users List Subject: [U2] Lock Status Is there anything in Unidata that would report the line of code that set a particular record lock? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Very Strange: Only first DICT entry using SUBR is LISTed
No real ideas for you on this - it's not really what I was going for. I use the SETINDEX and READFWD commands partly to avoid these select list id entanglements. I never really had a general purpose GET.KEYS subroutine (all are tied to a specific file) - but I might create one. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jonathanm Sent: Wednesday, June 22, 2011 5:35 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Very Strange: Only first DICT entry using SUBR is LISTed Thanks for your excellent suggestion. I took it and, with some modification got it going. Kind of. I did stick with the idea of sending GET.KEYS a SELECT statement, since there may be times in the future I want to qualify the SELECTion with multiple fields. Here's the result: $BASICTYPE U SUBROUTINE GET.KEYS(KEY_LIST, SELECT_COMMAND, OPTIONS) * LIST_NUMBER='' KEY_DELIMITER=@VM * process options OPT.CNT=DCOUNT(OPTIONS,@AM) FOR OPT.PTR=1 TO OPT.CNT OPTION=OPTIONSOPT.PTR OPT.NAME=FIELD(OPTION,'=',1) VALUE.START=COL2()+1 OPT.NAME=OCONV(TRIM(OPT.NAME),'MCU') OPT.VALUE=OPTION[VALUE.START,LEN(OPTION)-VALUE.START+1] BEGIN CASE CASE OPT.NAME='LIST_NUMBER' LIST_NUMBER=OPT.VALUE CASE OPT.NAME='DELIMITER' KEY_DELIMITER=OPT.VALUE END CASE NEXT OPT.PTR * * find an available select list number IF LIST_NUMBER='' THEN I=9 LOOP WHILE (I 0) AND (LIST_NUMBER='') DO IF SELECTINFO(I,1) 1 THEN LIST_NUMBER=I END I=I-1 REPEAT END * MY_SELECT_COMMAND=SELECT_COMMAND: TO :LIST_NUMBER EXECUTE MY_SELECT_COMMAND CAPTURING SCREEN_OUTPUT READLIST KEY_LIST FROM LIST_NUMBER ELSE KEY_LIST = IF KEY_DELIMITER@AM THEN KEY_LIST=CHANGE(KEY_LIST,@AM,KEY_DELIMITER) END RETURN ...and here's a sample of expect_total_qty: 001: I 002: 'SELECT core_cart_detail WITH cust_shipto_cart = ':@ID:''; SUBR('GET.KEYS',@1,''); TRANS('core_cart_detail',@2,'expect_qty','X'); SUM(@3) This all works great...except when I get to a field that sums a field in the detail file that, itself, is a summation of fields in a sub-detail file. I suspected that the problem was a result of the layered calls to GET.KEYS using the same select list number. That's why I included the above logic that finds an available select list number. But nonetheless, I'm getting 0's in these double-layered summation fields. *sigh* Any ideas? Dave Davis-3 wrote: Not quite - my GET.KEYS would instead look like this: 1: I 2: SUBR('GET.KEYS','core_cart_detail', 'cust_shipto_cart', cust_shipto_cart) Which tells the general purpose GET.KEYS routine which file you are looking for keys to (the detail file), which indexed field you want to use to retrieve those keys ('cust_shipto_cart'), and what expression holds the value you want to retrieve (the cust_shipto_cart field in the core_cart_head file). To get a total field you would have something like this: SUBR('GET.KEYS','core_cart_detail', 'cust_shipto_cart', cust_shipto_cart) ;TRANS('core_cart_detail',@1,'receive_qty','X') ;SUM(@2) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jonathanm Sent: Wednesday, June 22, 2011 3:13 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Very Strange: Only first DICT entry using SUBR is LISTed OK. I've had a chance to read this a bit more and have a question. When you talk about creating a multi-valued I-type that gets the keys, do you mean something like this? core_cart_detail_keys 1: I 2: SUBR('GET.KEYS','SELECT core_cart_detail') 3: 4: Detail Keys 5: 10L 6: M ...and then a subroutine like: SUBROUTINE GET.KEYS(KEY_LIST,COMMAND) COMMAND=COMMAND: TO 9 EXECUTE COMMAND RTNLIST 9 READLIST KEY_LIST FROM 9 RETURN Is this along the right idea? Dave Davis-3 wrote: You could create one multi-valued I-type in the master file that gets you the keys to the detail records for that master record's cust_shipto_cart. Then create V-types that sum expect_qty and receipt_qty. Something like: TRANS('core_cart_detail',core_cart_detail_keys,'expect_qty','X');SUM(@1) Really, how is the speed with what you've got now? I did something like what you did a long while ago and the speed was terrible. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jonathanm Sent: Wednesday, June 22, 2011 11:45 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Very Strange: Only first DICT entry using SUBR is LISTed Thanks, Dave. cust_shipto_cart is indeed indexed. The problem with reading the detail file records is that I'd have to build a unique subroutine for each type of DICT word like this. As it is, GET.LIST.TOTAL is used in multiple files of different shapes and sizes. Dave Davis-3 wrote: Do you do
Re: [U2] Very Strange: Only first DICT entry using SUBR is LISTed
Do you do a lot of this query statement within an I-type kind of thing? The performance must be atrocious. I would make an index on cust_shipto_cart in the detail file (if you don't already have one), and use the unibasic setindex and readfwd commands instead of having it parse a list. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jonathanm Sent: Wednesday, June 22, 2011 11:23 AM To: u2-users@listserver.u2ug.org Subject: [U2] Very Strange: Only first DICT entry using SUBR is LISTed Hi, all. I'm on UniData 6.0 on hpux. I have a couple of DICT entries, expect_total_qty and receipt_total_qty on a file called core_cart_head. They are listed below. When I use them in a LIST command like LIST core_cart_head expect_total_qty receipt_total_qty only the first field has an values, regardless of the order. For example, with the above LIST command I get: LIST core_cart_head expect_total_qty receipt_total_qty core_cart_head Expect Total Qty Receipt Total Qty 67094_436_14 67094_436_27 67094_436_37 67094_436_41 67094_436_53 5 records listed But if I reverse the order of fields and use LIST core_cart_head receipt_total_qty expect_total_qty I get: LIST core_cart_head receipt_total_qty expect_total_qty core_cart_head Receipt Total Qty Expect Total Qty 67094_436_12 67094_436_25 67094_436_36 67094_436_43 67094_436_58 5 records listed All of the data listed is correct; the only problem is only the first DICT word listed shows any values. Any ideas why this is happening and how I can get both DICT words to show values? Now here's the trick: Both DICT words use the SUBR function. They call a subroutine that EXECUTEs a different LIST command and parses the output, returning certain key information from the output. Here are the DICT entries: expect_total_qty 001: V The total number of cores expected in this cart. 002: SUBR(GET.LIST.TOTAL,'LIST core_cart_detail WITH cust_shipto_cart ':@ID:' TOTAL expect_qty',conversion=MR0) 003: MR0 004: Expect Total Qty 005: 10L 006: S receipt_total_qty 001: V The total number of cores received in this cart. 002: SUBR(GET.LIST.TOTAL,'LIST core_cart_detail WITH cust_shipto_cart ':@ID:' TOTAL receipt_qty',conversion=MR0) 003: MR0 004: Receipt Total Qty 005: 10L 006: S And here is the subroutine they're calling: GET.LIST.TOTAL 001: $BASICTYPE P 002: SUBROUTINE GET.LIST.TOTAL(RESULT,COMMAND,OPTIONS) 003: * 004: CONVERSION_CODE='' 005: * process options 006: OPT.CNT=DCOUNT(OPTIONS,@AM) 007: FOR OPT.PTR=1 TO OPT.CNT 008: OPTION=OPTIONSOPT.PTR 009: OPT.NAME=FIELD(OPTION,'=',1) 010: VALUE.START=COL2()+1 011: OPT.NAME=OCONV(TRIM(OPT.NAME),'MCU') 012: OPT.VALUE=OPTION[VALUE.START,LEN(OPTION)-VALUE.START+1] 013: BEGIN CASE 014: CASE OPT.NAME='CONVERSION' 015: CONVERSION_CODE=OPT.VALUE 016: END CASE 017: NEXT OPT.PTR 018: * 019: RESULT='' 020: PERFORM COMMAND CAPTURING SCREEN.OUTPUT 021: TOTAL.POS=INDEX(SCREEN.OUTPUT,@AM:'TOTAL ',1) 022: IF TOTAL.POS THEN 023: REMAINING.STR=SCREEN.OUTPUT[TOTAL.POS+8,LEN(SCREEN.OUTPUT)-TOTAL.POS-7] 024: RESULT=TRIM(REMAINING.STR1) 025: IF CONVERSION_CODE '' THEN 026: RESULT=ICONV(RESULT,CONVERSION_CODE) 027: END 028: END 029: RETURN Thanks for any help! Jonathan -- View this message in context: http://old.nabble.com/Very-Strange%3A-Only-first-DICT-entry-using-SUBR-is-LISTed-tp31904158p31904158.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Very Strange: Only first DICT entry using SUBR is LISTed
You could create one multi-valued I-type in the master file that gets you the keys to the detail records for that master record's cust_shipto_cart. Then create V-types that sum expect_qty and receipt_qty. Something like: TRANS('core_cart_detail',core_cart_detail_keys,'expect_qty','X');SUM(@1) Really, how is the speed with what you've got now? I did something like what you did a long while ago and the speed was terrible. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jonathanm Sent: Wednesday, June 22, 2011 11:45 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Very Strange: Only first DICT entry using SUBR is LISTed Thanks, Dave. cust_shipto_cart is indeed indexed. The problem with reading the detail file records is that I'd have to build a unique subroutine for each type of DICT word like this. As it is, GET.LIST.TOTAL is used in multiple files of different shapes and sizes. Dave Davis-3 wrote: Do you do a lot of this query statement within an I-type kind of thing? The performance must be atrocious. I would make an index on cust_shipto_cart in the detail file (if you don't already have one), and use the unibasic setindex and readfwd commands instead of having it parse a list. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jonathanm Sent: Wednesday, June 22, 2011 11:23 AM To: u2-users@listserver.u2ug.org Subject: [U2] Very Strange: Only first DICT entry using SUBR is LISTed Hi, all. I'm on UniData 6.0 on hpux. I have a couple of DICT entries, expect_total_qty and receipt_total_qty on a file called core_cart_head. They are listed below. When I use them in a LIST command like LIST core_cart_head expect_total_qty receipt_total_qty only the first field has an values, regardless of the order. For example, with the above LIST command I get: LIST core_cart_head expect_total_qty receipt_total_qty core_cart_head Expect Total Qty Receipt Total Qty 67094_436_14 67094_436_27 67094_436_37 67094_436_41 67094_436_53 5 records listed But if I reverse the order of fields and use LIST core_cart_head receipt_total_qty expect_total_qty I get: LIST core_cart_head receipt_total_qty expect_total_qty core_cart_head Receipt Total Qty Expect Total Qty 67094_436_12 67094_436_25 67094_436_36 67094_436_43 67094_436_58 5 records listed All of the data listed is correct; the only problem is only the first DICT word listed shows any values. Any ideas why this is happening and how I can get both DICT words to show values? Now here's the trick: Both DICT words use the SUBR function. They call a subroutine that EXECUTEs a different LIST command and parses the output, returning certain key information from the output. Here are the DICT entries: expect_total_qty 001: V The total number of cores expected in this cart. 002: SUBR(GET.LIST.TOTAL,'LIST core_cart_detail WITH cust_shipto_cart ':@ID:' TOTAL expect_qty',conversion=MR0) 003: MR0 004: Expect Total Qty 005: 10L 006: S receipt_total_qty 001: V The total number of cores received in this cart. 002: SUBR(GET.LIST.TOTAL,'LIST core_cart_detail WITH cust_shipto_cart ':@ID:' TOTAL receipt_qty',conversion=MR0) 003: MR0 004: Receipt Total Qty 005: 10L 006: S And here is the subroutine they're calling: GET.LIST.TOTAL 001: $BASICTYPE P 002: SUBROUTINE GET.LIST.TOTAL(RESULT,COMMAND,OPTIONS) 003: * 004: CONVERSION_CODE='' 005: * process options 006: OPT.CNT=DCOUNT(OPTIONS,@AM) 007: FOR OPT.PTR=1 TO OPT.CNT 008: OPTION=OPTIONSOPT.PTR 009: OPT.NAME=FIELD(OPTION,'=',1) 010: VALUE.START=COL2()+1 011: OPT.NAME=OCONV(TRIM(OPT.NAME),'MCU') 012: OPT.VALUE=OPTION[VALUE.START,LEN(OPTION)-VALUE.START+1] 013: BEGIN CASE 014: CASE OPT.NAME='CONVERSION' 015: CONVERSION_CODE=OPT.VALUE 016: END CASE 017: NEXT OPT.PTR 018: * 019: RESULT='' 020: PERFORM COMMAND CAPTURING SCREEN.OUTPUT 021: TOTAL.POS=INDEX(SCREEN.OUTPUT,@AM:'TOTAL ',1) 022: IF TOTAL.POS THEN 023: REMAINING.STR=SCREEN.OUTPUT[TOTAL.POS+8,LEN(SCREEN.OUTPUT)-TOTAL.POS-7] 024: RESULT=TRIM(REMAINING.STR1) 025: IF CONVERSION_CODE '' THEN 026: RESULT=ICONV(RESULT,CONVERSION_CODE) 027: END 028: END 029: RETURN Thanks for any help! Jonathan -- View this message in context: http://old.nabble.com/Very-Strange%3A-Only-first-DICT-entry-using-SUBR-is-LISTed-tp31904158p31904158.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088
Re: [U2] Very Strange: Only first DICT entry using SUBR is LISTed
Not quite - my GET.KEYS would instead look like this: 1: I 2: SUBR('GET.KEYS','core_cart_detail', 'cust_shipto_cart', cust_shipto_cart) Which tells the general purpose GET.KEYS routine which file you are looking for keys to (the detail file), which indexed field you want to use to retrieve those keys ('cust_shipto_cart'), and what expression holds the value you want to retrieve (the cust_shipto_cart field in the core_cart_head file). To get a total field you would have something like this: SUBR('GET.KEYS','core_cart_detail', 'cust_shipto_cart', cust_shipto_cart) ;TRANS('core_cart_detail',@1,'receive_qty','X') ;SUM(@2) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jonathanm Sent: Wednesday, June 22, 2011 3:13 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Very Strange: Only first DICT entry using SUBR is LISTed OK. I've had a chance to read this a bit more and have a question. When you talk about creating a multi-valued I-type that gets the keys, do you mean something like this? core_cart_detail_keys 1: I 2: SUBR('GET.KEYS','SELECT core_cart_detail') 3: 4: Detail Keys 5: 10L 6: M ...and then a subroutine like: SUBROUTINE GET.KEYS(KEY_LIST,COMMAND) COMMAND=COMMAND: TO 9 EXECUTE COMMAND RTNLIST 9 READLIST KEY_LIST FROM 9 RETURN Is this along the right idea? Dave Davis-3 wrote: You could create one multi-valued I-type in the master file that gets you the keys to the detail records for that master record's cust_shipto_cart. Then create V-types that sum expect_qty and receipt_qty. Something like: TRANS('core_cart_detail',core_cart_detail_keys,'expect_qty','X');SUM(@1) Really, how is the speed with what you've got now? I did something like what you did a long while ago and the speed was terrible. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jonathanm Sent: Wednesday, June 22, 2011 11:45 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Very Strange: Only first DICT entry using SUBR is LISTed Thanks, Dave. cust_shipto_cart is indeed indexed. The problem with reading the detail file records is that I'd have to build a unique subroutine for each type of DICT word like this. As it is, GET.LIST.TOTAL is used in multiple files of different shapes and sizes. Dave Davis-3 wrote: Do you do a lot of this query statement within an I-type kind of thing? The performance must be atrocious. I would make an index on cust_shipto_cart in the detail file (if you don't already have one), and use the unibasic setindex and readfwd commands instead of having it parse a list. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jonathanm Sent: Wednesday, June 22, 2011 11:23 AM To: u2-users@listserver.u2ug.org Subject: [U2] Very Strange: Only first DICT entry using SUBR is LISTed Hi, all. I'm on UniData 6.0 on hpux. I have a couple of DICT entries, expect_total_qty and receipt_total_qty on a file called core_cart_head. They are listed below. When I use them in a LIST command like LIST core_cart_head expect_total_qty receipt_total_qty only the first field has an values, regardless of the order. For example, with the above LIST command I get: LIST core_cart_head expect_total_qty receipt_total_qty core_cart_head Expect Total Qty Receipt Total Qty 67094_436_14 67094_436_27 67094_436_37 67094_436_41 67094_436_53 5 records listed But if I reverse the order of fields and use LIST core_cart_head receipt_total_qty expect_total_qty I get: LIST core_cart_head receipt_total_qty expect_total_qty core_cart_head Receipt Total Qty Expect Total Qty 67094_436_12 67094_436_25 67094_436_36 67094_436_43 67094_436_58 5 records listed All of the data listed is correct; the only problem is only the first DICT word listed shows any values. Any ideas why this is happening and how I can get both DICT words to show values? Now here's the trick: Both DICT words use the SUBR function. They call a subroutine that EXECUTEs a different LIST command and parses the output, returning certain key information from the output. Here are the DICT entries: expect_total_qty 001: V The total number of cores expected in this cart. 002: SUBR(GET.LIST.TOTAL,'LIST core_cart_detail WITH cust_shipto_cart ':@ID:' TOTAL expect_qty',conversion=MR0) 003: MR0 004: Expect Total Qty 005: 10L 006: S receipt_total_qty 001: V The total number of cores received in this cart. 002: SUBR(GET.LIST.TOTAL,'LIST core_cart_detail WITH cust_shipto_cart ':@ID:' TOTAL receipt_qty',conversion=MR0) 003: MR0 004: Receipt Total Qty 005: 10L 006: S And here is the subroutine they're calling: GET.LIST.TOTAL 001: $BASICTYPE P
Re: [U2] Strange Selection Behavior
What do the queried fields look like? Are they actual fields or calculated fields? SB+ defined? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Long Sent: Tuesday, June 14, 2011 4:38 PM To: U2-Users@listserver.u2ug.org Subject: [U2] Strange Selection Behavior Hi All - I am getting strange results with selections that I am hoping someone else has encountered and can help me resolve. We have SB+ running on UV. I don't have the same issues running on Unidata. I have a BASIC program I have written that constructs a select statement based on the criteria specified in a screen by the user, then executes the constructed selection statement. Something like (although the real one is more complex): SEL.CMD = 'SELECT CUSTOMER WITH CUST.NUM = ' : CUST.NUM : ' AND WITH CUST.TYPE = ' : CUST.TYPE : '' EXECUTE SEL.CMD CAPTURING OUTPUT Indexes are built on the dictionaries and are working properly. When we test the constructed select statement at TCL, the results are retuned under 2 seconds. When it executes inside the BASIC program, it takes approximately 24 seconds to return the same results. We tried adding a NO.INDEX to the statement, which adds 6 seconds to the select at TCL but just a couple of seconds within the BASIC program. Nothing else we have tried has had any effect. Has anyone encountered this type of behavior? Thanks, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Error
Does the web side make use of SB+ at all? Through a derived field or indexed field or trigger? If you can, I would step through all the files in the /FC table to make sure they can be opened. This may not be a complete list of the files the app opens but it would be a place to start. Is the web interface run through the same account as the SB+ side? If not, are all those files in the other account's VOC? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:03 AM To: 'U2 Users List' Subject: [U2] SB Error We are using Avanté w/ SB and a web interface for customers. On rare occasions, a web page is blowing up due to an error that is cleanly detected in Avanté/SB, but that the web side is clueless about. I am working on a pro-active program to detect these conditions, but after a while, it is blowing up with the following: In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Can not access unopened file. File variable not used in file operation In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Fatal error: READ error Obviously I do not have the source code for SB, so I can not see what file it trying to access. Does anyone have a clue as to what I need to open OUTSIDE of SB so that I can call SB.PROCESS? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Error
You're not hitting MAX_OPEN_FILE (default 500) are you? Other than that - the stand-alone program is truly a program and not a subroutine? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:30 AM To: 'U2 Users List' Subject: Re: [U2] SB Error Let me answer this way: my new stand-alone program selects all the parts, loops through them, and for each part, calls the same subroutines that the web site does (thus ensuring that I am running the same logic). One of these subroutines calls another subroutine that lives in an SB account. It obviously is not a common condition because we just recently encountered this problem for the first time. My new stand-alone program gets about 1500 records into the loop before hitting the error below (which is NOT the error I was actually trying to solve). John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis Sent: Tuesday, June 07, 2011 11:12 AM To: U2 Users List Subject: Re: [U2] SB Error Does the web side make use of SB+ at all? Through a derived field or indexed field or trigger? If you can, I would step through all the files in the /FC table to make sure they can be opened. This may not be a complete list of the files the app opens but it would be a place to start. Is the web interface run through the same account as the SB+ side? If not, are all those files in the other account's VOC? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:03 AM To: 'U2 Users List' Subject: [U2] SB Error We are using Avanté w/ SB and a web interface for customers. On rare occasions, a web page is blowing up due to an error that is cleanly detected in Avanté/SB, but that the web side is clueless about. I am working on a pro-active program to detect these conditions, but after a while, it is blowing up with the following: In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Can not access unopened file. File variable not used in file operation In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Fatal error: READ error Obviously I do not have the source code for SB, so I can not see what file it trying to access. Does anyone have a clue as to what I need to open OUTSIDE of SB so that I can call SB.PROCESS? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users
Re: [U2] SB Error
Do the following on each file to make sure it isn't trigger or index related: LIST.TRIGGER DATA filename LIST.INDEX filename The error doesn't have to be in your program to cause the problem. If for some reason a trigger or an index used a subroutine that relied on SB+ you could get these problems. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:56 AM To: 'U2 Users List' Subject: Re: [U2] SB Error The new stand-alone program is truly a program. It loops through the records, and for each record, populates the arguments as if it were called via the subroutine behind the web page, then calls the shared subroutine. I don't think it would be hitting the MAX_OPEN_FILE limit, though that is a thought. How would I actually capture the number of files that are open? I could throw a CRT into my stand-along program if I know that info. This thing is so obscure that I am not even sure what program is doing the calling to SB.PROCESS, though obviously it must be somewhere in the chain of subroutines called in the SB account. It works fine for 1500+ records before blowing up. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis Sent: Tuesday, June 07, 2011 11:42 AM To: U2 Users List Subject: Re: [U2] SB Error You're not hitting MAX_OPEN_FILE (default 500) are you? Other than that - the stand-alone program is truly a program and not a subroutine? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:30 AM To: 'U2 Users List' Subject: Re: [U2] SB Error Let me answer this way: my new stand-alone program selects all the parts, loops through them, and for each part, calls the same subroutines that the web site does (thus ensuring that I am running the same logic). One of these subroutines calls another subroutine that lives in an SB account. It obviously is not a common condition because we just recently encountered this problem for the first time. My new stand-alone program gets about 1500 records into the loop before hitting the error below (which is NOT the error I was actually trying to solve). John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis Sent: Tuesday, June 07, 2011 11:12 AM To: U2 Users List Subject: Re: [U2] SB Error Does the web side make use of SB+ at all? Through a derived field or indexed field or trigger? If you can, I would step through all the files in the /FC table to make sure they can be opened. This may not be a complete list of the files the app opens but it would be a place to start. Is the web interface run through the same account as the SB+ side? If not, are all those files in the other account's VOC? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:03 AM To: 'U2 Users List' Subject: [U2] SB Error We are using Avanté w/ SB and a web interface for customers. On rare occasions, a web page is blowing up due to an error that is cleanly detected in Avanté/SB, but that the web side is clueless about. I am working on a pro-active program to detect these conditions, but after a while, it is blowing up with the following: In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Can not access unopened file. File variable not used in file operation In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Fatal error: READ error Obviously I do not have the source code for SB, so I can not see what file it trying to access. Does anyone have a clue as to what I need to open OUTSIDE of SB so that I can call SB.PROCESS? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged
Re: [U2] SB Error
I'm betting it's trying to open the xxPROCESS file or other system file - and can't because the system hasn't been initialized. The subroutine that lives in the SB account probably uses the SB+ common block and would work fine from within an SB+ session. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:30 AM To: 'U2 Users List' Subject: Re: [U2] SB Error Let me answer this way: my new stand-alone program selects all the parts, loops through them, and for each part, calls the same subroutines that the web site does (thus ensuring that I am running the same logic). One of these subroutines calls another subroutine that lives in an SB account. It obviously is not a common condition because we just recently encountered this problem for the first time. My new stand-alone program gets about 1500 records into the loop before hitting the error below (which is NOT the error I was actually trying to solve). John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis Sent: Tuesday, June 07, 2011 11:12 AM To: U2 Users List Subject: Re: [U2] SB Error Does the web side make use of SB+ at all? Through a derived field or indexed field or trigger? If you can, I would step through all the files in the /FC table to make sure they can be opened. This may not be a complete list of the files the app opens but it would be a place to start. Is the web interface run through the same account as the SB+ side? If not, are all those files in the other account's VOC? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:03 AM To: 'U2 Users List' Subject: [U2] SB Error We are using Avanté w/ SB and a web interface for customers. On rare occasions, a web page is blowing up due to an error that is cleanly detected in Avanté/SB, but that the web side is clueless about. I am working on a pro-active program to detect these conditions, but after a while, it is blowing up with the following: In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Can not access unopened file. File variable not used in file operation In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Fatal error: READ error Obviously I do not have the source code for SB, so I can not see what file it trying to access. Does anyone have a clue as to what I need to open OUTSIDE of SB so that I can call SB.PROCESS? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately
Re: [U2] [UD] Extract a line with a CR and/or LF character in it.
Basically (though not exactly) what I've been doing - it works. Anyone ever successfully imported a CSV file into Excel that has these embedded characters? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ed Clark Sent: Thursday, May 26, 2011 9:49 AM To: U2 Users List Subject: Re: [U2] [UD] Extract a line with a CR and/or LF character in it. just an idea I haven't thought about too deeply: Use readseq to read a line, then use the COUNT() function to count the quotes. If there are an odd number of quotes (mod(2)=1) then add a value mark and read and append another line. Loop until you have an even number of quotes (because there might be more than one multivalued field in the record), at which point you have the entire line. On May 26, 2011, at 2:57 AM, Bill Haskett wrote: I figured out how to do this. I read each line and use a subroutine to go through each character. It sets a variable 'QuoteOn' if we're in a quoted string. Obviously if the line ends while in a quoted string, the next line belongs to the current line. Man, what a pain this was! :-) Thanks for your thoughts and help. Bill - Original Message - *From:* alfke...@hotmail.com *To:* u2-users@listserver.u2ug.org *Date:* 5/25/2011 10:13 PM *Subject:* Re: [U2] [UD] Extract a line with a CR and/or LF character in it. It's been a while - but I'm pretty sure that OSBREAD keeps the CR/LF as part of the block (you may need to put NO CONVERT ON in the code). READSEQ automatically ends at the CR/LF so you would have to put the lines together if you were short fields. In both cases it would mean going through the block/line a character at a time to parse out each field. Of course, to work with embedded quotes and commas you pretty much have to any way. With READSEQ you know the line ended on a CRLF - you just need to figure out if it's the end of the record or not. Does that make more sense? Hht Colin Alfke Calgary, Canada From: wphaskett I guess that's my problem. I can't use OSBREAD because the Cr/Lf appears in different columns in the line. I can't guarantee where it shows up (or what character position). Using READSEQ doesn't work either because the line read by the statement is only a part of the entire line in the file! e.g. 0,4300,1BEU,Robert,Smith,Julie,Smith,1 Lakewood Dr,,63031,1 Lakewood Dr San Diego, CA 92122,,,$150.00, 0,4300,1CYN,John Randolph,Bones,,,1 Round Ct,,63031,1 Round Ct San Diego, CA 92122,,,$150.00, ...when the lines should look like (only two lines): 0,4300,1BEU,Robert,Smith,Julie,Smith,1 Lakewood Dr,,63031,1 Lakewood Dr, San Diego, CA 92122,,,$150.00, 0,4300,1CYN,John Randolph,Bones,,,1 Round Ct,,63031,1 Round Ct, San Diego, CA 92122,,,$150.00, There's no guarantee the field causing the problem will even have any data in it, so I can't append every 2nd line to the end of every 1st line. :-( Once I get the line I can deal with each character at a time. Any other ideas? As always, thanks. Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Very Weird Trigger Behavior
Instead of using a SELECT statement build an index on TRADE_CODE in the TRADES file. Use the unibasic index command SETINDEX to tell you if a specified value has any entries in the TRADES file. I don't think a trigger subroutine is an appropriate place for a SELECT statement. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jonathanm Sent: Thursday, April 21, 2011 11:03 AM To: u2-users@listserver.u2ug.org Subject: [U2] Very Weird Trigger Behavior Hi, all. I'm new to this forum, but have been programming multivalue database apps for years. I ran across something here that really has me puzzled. I wonder if anyone has seen something like this and might be able to shed a bit of light as to what's happening. I'm running Unidata 6.0 on hpux. I have a trigger set up to run before deletions take place on a file called CODE_DEFS. The file just contains code numbers (ID) and their meaning/description. There's another file, TRADES, that contains a field, TRADE_CODE, that should have a many-to-one relationship with IDs in CODE_DEFS. That is, the content of TRADE_CODE should match a record ID in CODE_DEFS. Before a record is deleted from CODE_DEFS, I want to ensure its ID does not appear in any record in TRADES. That's where the trigger comes in. The trigger is passed the ID of the record to be deleted. This is done via parameter variable CODE_DEF_ID. The trigger program, CHECK_TRADES, has the following logic: --- . . . CMD='SELECT TRADES WITH TRADE_CODE = ':CODE_DEF_ID:'' EXECUTE CMD IF SYSTEM(11) THEN * there's a select list, so the code is still in use in TRADES. * Return 0 in EXECUTE_STATUS to disallow the deletion. EXECUTE_STATUS=0 END . . . --- The problem is when I try to delete a record from CODE_DEFS, using a TCL DELETE command, I get the following error message. '' is not a record in TRADES Of course, there are two problems with the error message. Not only has it lost the ID of the record to be deleted, it has also lost the name of the file. Notice that it is looking in the TRADES file instead of CODE_DEFS. I believe what's happening is when it EXECUTEs the CMD, the internal variables for ID and filename are being reset. To support this hunch, I changed the trigger routine so that CMD=DATE, causing it to execute the TCL DATE command. Here's the error message from that: '' is not a record in CODE_DEFS And if I make CMD=COUNT CUST, which makes the trigger deal with a completely unrelated file, I get this error message: '' is not a record in @7X% So, it appears that any EXECUTE is going to lose the ID, and if CMD deals with any file, the filename is reset also. I really need to have it perform the intended check before deletion. Any ideas? -- View this message in context: http://old.nabble.com/Very-Weird-Trigger-Behavior-tp31450305p31450305.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Very Weird Trigger Behavior
I think this was a check to prevent deletion of a CODE_DEFS record if in use in the TRADES file, so XLATE wouldn't help. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green Sent: Thursday, April 21, 2011 11:27 AM To: 'U2 Users List' Subject: Re: [U2] Very Weird Trigger Behavior I would change the SELECT to an XLATE command. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jonathanm Sent: Thursday, April 21, 2011 8:03 AM To: u2-users@listserver.u2ug.org Subject: [U2] Very Weird Trigger Behavior Hi, all. I'm new to this forum, but have been programming multivalue database apps for years. I ran across something here that really has me puzzled. I wonder if anyone has seen something like this and might be able to shed a bit of light as to what's happening. I'm running Unidata 6.0 on hpux. I have a trigger set up to run before deletions take place on a file called CODE_DEFS. The file just contains code numbers (ID) and their meaning/description. There's another file, TRADES, that contains a field, TRADE_CODE, that should have a many-to-one relationship with IDs in CODE_DEFS. That is, the content of TRADE_CODE should match a record ID in CODE_DEFS. Before a record is deleted from CODE_DEFS, I want to ensure its ID does not appear in any record in TRADES. That's where the trigger comes in. The trigger is passed the ID of the record to be deleted. This is done via parameter variable CODE_DEF_ID. The trigger program, CHECK_TRADES, has the following logic: --- . . . CMD='SELECT TRADES WITH TRADE_CODE = ':CODE_DEF_ID:'' EXECUTE CMD IF SYSTEM(11) THEN * there's a select list, so the code is still in use in TRADES. * Return 0 in EXECUTE_STATUS to disallow the deletion. EXECUTE_STATUS=0 END . . . --- The problem is when I try to delete a record from CODE_DEFS, using a TCL DELETE command, I get the following error message. '' is not a record in TRADES Of course, there are two problems with the error message. Not only has it lost the ID of the record to be deleted, it has also lost the name of the file. Notice that it is looking in the TRADES file instead of CODE_DEFS. I believe what's happening is when it EXECUTEs the CMD, the internal variables for ID and filename are being reset. To support this hunch, I changed the trigger routine so that CMD=DATE, causing it to execute the TCL DATE command. Here's the error message from that: '' is not a record in CODE_DEFS And if I make CMD=COUNT CUST, which makes the trigger deal with a completely unrelated file, I get this error message: '' is not a record in @7X% So, it appears that any EXECUTE is going to lose the ID, and if CMD deals with any file, the filename is reset also. I really need to have it perform the intended check before deletion. Any ideas? -- View this message in context: http://old.nabble.com/Very-Weird-Trigger-Behavior-tp31450305p31450305.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Very Weird Trigger Behavior
COUNT would give you the wrong result if a select list was active at the time you executed it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton Sent: Thursday, April 21, 2011 12:57 PM To: U2 Users List Subject: Re: [U2] Very Weird Trigger Behavior On 4/21/2011 11:03 AM, jonathanm wrote: Hi, all. I'm new to this forum, but have been programming multivalue database snip I really need to have it perform the intended check before deletion. Any ideas? Your execute of the SELECT will potentially result in an active select list that doesn't appear to be intentionally used. Since you don't want the ids, you just want to know if there are any, I'd do something like: CMD - 'COUNT TRADES WITH TRADE_CODE = ': CODE_DEF_ID: '' EXECUTE CMD CAPTURING CMD.CAP RETURNING CNT.SELECTED IF (CNT.SELECTED GT 0) THEN EXECUTE_STATUS = 0 END ELSE EXECUTE_STATUS = END I also don't know what you're doing with EXECUTE_STATUS, but if it's not set by the caller, it needs to be set here, otherwise its value is undetermined, (and in most cases will be set to null). Regards. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Case Sensitivity and Databasic conversion
an obvious position, but be prepared for some pragmatic requests for more compelling reasoning. I'd really like to understand why any site would want to migrate to U2 these days. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OCONVS for MV I-desc
I SUBR('-OCONVS',X.SOME.FIELD,'MCU') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Tuesday, March 08, 2011 8:01 PM To: U2 Users List Subject: [U2] OCONVS for MV I-desc On Unidata 7.2.x OCONVS is the MV equivalent for OCONV that works wonders in Unibasic. However, I have the need to create an I-descriptor which uppercases a MV field and OCONVS isn't allowed in an I-desc whereas OCONV is. However, OCONV uppercases the @VM and screws up the MV nature. To be clear, this is what I'm trying to do: OCONVS(X.SOME.FIELD,'MCU') -- Jeffrey Butera Manager of ERP Systems Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Purging and Indexing
Sounds like the purge should come first to me - your purge sounds like it will get rid of most of the records, so the date-based index isn't that helpful for selecting the old ones, and it will slow down the time it takes to delete each record. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Glorfield, Gordon Sent: Wednesday, February 16, 2011 10:08 AM To: 'U2 Users List' Subject: [U2] Purging and Indexing Good Morning, Looking for opinions and experiences here. We are trying to do some system cleanups. We found that our PO file has over 10 million records dating back some 7 years. We've decided that 2 years of PO history is plenty to keep on file. Currently there are no indices on this file. Our question is would it be quicker to do a select and delete of the older records before building an index on invoice date or would it be quicker to build the index first to use in the select for the purge? This index has been identified as being needed for some reporting. My thinking is that while the select for the purge may go quicker, if the index is in place prior to the purge then the delete process not only has to delete the selected records it also has to update the index on the fly. TIA, Gordon Gordon J Glorfield | Software Application Developer | Vertis Communications 250 W. Pratt Street, Suite 1800 | Baltimore, MD, 21201 T 410-361-8664 | M 443-280-7093 gglorfi...@vertisinc.com | http://www.vertisinc.com Vertis Communications is a results-driven marketing communications company that delivers inventive advertising, direct marketing and interactive solutions to prominent brands across North America. Our deep industry knowledge and extensive range of offerings-including integrated data solutions, digital program management systems, creative services, world-class print and mail production, logistics, out-of-home and business process outsourcing-are used to deliver superior program performance that drives bottom line results for our clients. With 100 strategically positioned locations and more than 5,000 dedicated professionals, we deliver impeccable quality and fast turn-around to any market. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB+ printer font changes
The printer class setting - the Set and Reset Sequences. You need to send it the PCL5 code (if you are using PCL that is) to switch to condensed print. We use (27)E(27)(s17H for the set sequence and (27)E for the reset sequence, for a stationery we set up for 132 columns on 8-1/2 x 11 inch paper. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Wednesday, January 12, 2011 6:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] SB+ printer font changes Hi All, I have a question about having the printer-font size switch to condensed when a SB+ report is sent to a laser printer (HP LaserJet) that is wider than 80 characters. I know that there is a SB+ user group but I cannot log into that from work and this is a work question. I was hoping that there would be a few people who are SB+ users to help me. Anyway, I created a report the same way as other reports that work just fine but this report refuses to switch from the large font. If I send the report to the screen it will switch to condensed print but not when I send it to the printer. Is there something in the printer setup? Printer Class definition? Stationary type? Or do I add something in the NETPROCESS Thanks for your help, Bruce Lunt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB+ printer font changes
Run it to a _HOLD_ file using the SH option under both stationeries to see what the difference is. Are the stationeries the same? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Thursday, January 13, 2011 1:36 PM To: 'U2 Users List' Subject: Re: [U2] SB+ printer font changes We have 2 different stationary types that I am dealing with: GREENBAR and GREENBAR.MEX. They are identical to each other for printer class definition HP5SI in the Set and Reset as well as all other settings. But I can print a report using GREENBAR and it condenses the text and the print the same report using GREENBAR.MEX and it does not condense the print. Is there anywhere else that the GREENBAR.MEX settings are stored? How does it get triggered to change the font size? Thanks, Bruce -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis Sent: Thursday, January 13, 2011 6:25 AM To: U2 Users List Subject: Re: [U2] SB+ printer font changes The printer class setting - the Set and Reset Sequences. You need to send it the PCL5 code (if you are using PCL that is) to switch to condensed print. We use (27)E(27)(s17H for the set sequence and (27)E for the reset sequence, for a stationery we set up for 132 columns on 8-1/2 x 11 inch paper. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Wednesday, January 12, 2011 6:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] SB+ printer font changes Hi All, I have a question about having the printer-font size switch to condensed when a SB+ report is sent to a laser printer (HP LaserJet) that is wider than 80 characters. I know that there is a SB+ user group but I cannot log into that from work and this is a work question. I was hoping that there would be a few people who are SB+ users to help me. Anyway, I created a report the same way as other reports that work just fine but this report refuses to switch from the large font. If I send the report to the screen it will switch to condensed print but not when I send it to the printer. Is there something in the printer setup? Printer Class definition? Stationary type? Or do I add something in the NETPROCESS Thanks for your help, Bruce Lunt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uppercasing in SELECT
Virtual attribute to upcase the data value. In unidata ecltype u you can do the following: SELECT filename WITH EVAL OCONV(NAME_FIELD,'MCU') = uppercase value Or you could create an actual I or V type field, which you could build an index on. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Friday, December 03, 2010 10:38 AM To: u2-users@listserver.u2ug.org Subject: [U2] Uppercasing in SELECT I need to SELECT on a name field that has mixed case and has never been enforced. John Smith might be entered as John Smith, JOHN SMITH, John, etc. I can UPCASE the user supplied search argument and do a partial string match, but I am not sure how to handle the SELECT. Is there an option in a SELECT to ignore case? Or alternatively, if I make a virtual attribute to upcase the data value, what is the best way? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uppercasing in SELECT
[arg] is ECL TYPE P ...arg... is ECL type U It's what parser flavor is being used that determines your syntax. Our SB+/UniData setup uses ECL type P and we either have to set it explicitly to U or type the command select in lower case to use U. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Friday, December 03, 2010 11:27 AM To: U2 Users List Subject: Re: [U2] Uppercasing in SELECT Thanks Dave and Mark. I was able to get my select working with the EVAL statement. The only thing odd was I had to use the LIKE ...ARG... instead of the =[ARG] Not sure what the difference is, but my immediate fire is put out and I am moving on. Thanks again. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Index based on an I desc of TRANS data
It will not get updated automatically. That would be magic. For that to happen the index must be based entirely on the contents of the record and/or record id. Things like that I would tend to build the index on the key to the TRANS'd data, and maybe have another index on the field in the secondary file. An invoice file with a field that shows the customer name for example. You could index the customer name in the customer file, the customer key in the invoice file. Find the list of customer keys for a customer name, and use that to get a list of invoice records using the customer keys. But if you've got, for example, an index based on the words in the record, and you have a list of words you want to ignore (not build an index for) stored in another file - that would be a case where the source doesn't change very often and you would want to bring the system down to rebuild the index. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, November 09, 2010 3:47 PM To: U2 Users List Subject: [U2] Index based on an I desc of TRANS data I just created an Index on a fairly large file based on an I Desc. The IDESC is combination of Concatenating 5 TRANS()'d fields. After the index was built, it works greatbut just curious, Will the index get updated automatically, when the source file's data changes? (remember, the index is based on TRANS'd data), Or will I need to periodically rebuild the index, which in itself wouldn't be an issue as the source file doesn't change very often. This is on UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1: dbpause/dbresume indicator
Examine the output of the system-level dbpause_status command: % dbpause_status DBpause is ON. Don't know how far back dbpause_status was introduced. I have it on 7.1 though. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, November 08, 2010 4:16 PM To: U2 Users List Subject: [U2] Unidata 6.1: dbpause/dbresume indicator Is there any way to tell - in a cron script - if Unidata is paused? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How many will be selected?
Do you have SYSTEM(11) like we do in UniData? It may do something else entirely or be slightly different. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, October 19, 2010 1:41 PM To: U2 Users List Subject: [U2] How many will be selected? UV here I open a file, then use SELECT filevarible then proceed to do a LOOP/READNEXT/REPEAT to scan through the file. OPEN ,SOMEFILE TO F.TEST ELSE STOP SELECT F.TEST LOOP READNEXT ID ELSE EXIT REPEAT Is there any way to know how many records WILL BE processed in that loop before scanning? @selected doesn't work, it only returns the number of items in the last group that was read I tried using SELECT filevariable TO list.variable but you can't do a DCOUNT on that variable you can only READNEXT FROM list.variable Aside from EXECUTE SELECT filename RTNLIST in place of the SELECT filevariable so that @selected would return with the actual number selected (which does do what I want) Any other methods? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CREATE.TRIGGER - Permission denied
HELP CREATE.TRIGGER explains the rules. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Monday, October 18, 2010 4:19 PM To: U2 Users List Subject: Re: [U2] CREATE.TRIGGER - Permission denied Sorry - I misread. However, even if it's Unidata, the same question still applies. There does appear to be some disagreement as to whether it requires root or just file ownership. What about group? If a user is in the same group as the file, would that be sufficient (AIX was the Unix I worked on most)? If so, I don't see a problem with that, since, depending on the file's permissions, a user probably shouldn't be able to do much of anything with the file unless he/she owns it or is in the same group. Charlie Noah Charles W. Noah Associates cwn...@comcast.net The views and opinions expressed herein are my own (Charlie Noah) and do not necessarily reflect the views, positions or policies of any of my former, current or future employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 10-18-2010 1:46 PM, phil walker wrote: Universe does not require root access to create a trigger. The article refers to Unidata. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Tuesday, 19 October 2010 7:30 a.m. To: U2 Users List Subject: Re: [U2] CREATE.TRIGGER - Permission denied I have used Jbase for 12 years, and used Universe for many before that. I was surprised to learn that Universe requires one to have root access to create a trigger. Jbase doesn't require that, so I guess I was spoiled. Does anyone know of any compelling reason why Universe would require it? Charlie Noah Charles W. Noah Associates cwn...@comcast.net The views and opinions expressed herein are my own (Charlie Noah) and do not necessarily reflect the views, positions or policies of any of my former, current or future employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 10-18-2010 12:10 PM, Colin Alfke wrote: As others have noted you need to login as root to create the trigger. We use a program that does the following for each of our triggers (UniData on Windows with SB+). DELETE.TRIGGER filename UPDATE DELETE.CATALOG triggerprogram BASIC programfile programname CATALOG programfile programname FORCE CREATE.TRIGGER programfile programname UPDATE Hth Colin Alfke Calgary, Canada -Original Message- From: Mecki Foerthmann Hi, Today I tried for the first time to create a trigger on Unidata (Version 5.2 on Solaris) and get this error. I have to add we are using SB+ and Avante 9.2 which includes PRC 3.9. First time I tried this I actually got an SB+ error (line 200 something) - and when I run it from true ECL I just get the message PERMISSION DENIED. I even changed the LOGIN VOC entry to bypass SB+ - no luck either. The file in question has 777 permissions on Solaris, so this couldn't be the problem. The subroutine is globally cataloged too and there are no triggers on the file already. It isn't a DIR file either. Well, I haven't checked that, but all our data files are hashed. I'll check it tomorrow morning. Any ideas? I know Avante uses triggers for its audit files, so why can't I create my own? Susan perhaps? Is it your application that stops me? Thanks Mecki ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete
Re: [U2] SB Client - Disable TAB
I think this is more of an issue with @WORK fields than @RECORD fields. In any case, perform a validation after screen accept if it's important. If it's important that the user not enter a field until other fields before it have been entered, bounce them out by using the process before field slot. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, September 24, 2010 3:04 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] SB Client - Disable TAB This may be old news to most folks, but we have found that if a user navigates through a GUI SB+ screen and uses their mouse to click on an input, none of the logic tied to the prior inputs are run. This includes being able to skip right past mandatory fields. For example, a screen has 5 required inputs followed by 5 non-required inputs. If the user is in input 2 and uses their mouse to click into input 8, SB allows this to happen and the required fields and any associated logic tied to inputs 2 through 7 are ignored. This appears to be a huge SB bug. Sure we could fix it for a specific screen, but that does nothing for the hundreds (or thousands) of other screens. Does anyone have a realistic solution to this condition? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.2.5 and Digest
How big is your input string? In the past, I've had to break down the input into smaller 100 byte chunks and concatenate to get the result. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Monday, September 20, 2010 3:44 PM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata 7.2.5 and Digest Unidata 7.2.5 on RedHat 5. I'm trying to SHA1 some data and get it back with some human readable output (hex is fine). This snippet works for other Unidata people (who have emailed me privately) but not me: X.DATA = '1234567' X.ERROR=DIGEST('SHA1',X.DATA,1,X.OUT) CRT 'DIGEST err=':X.ERROR X.RESULT = OCONV(X.OUT, MX) CRT 'OCONV res=':X.RESULT Instead of giving me a nice hash result, I get binary output: DIGEST err=0 OCONV res=ê¾]d°âynORÖз2ü I'm trying to determine why this would cause problems on my server but not for others. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Slow READ/WRITE with indexes (Nick Gettino)
Hundreds of characters. My example concatenates a bunch of attributes like name and address together to see if there are any matching records already on file, before creating a new record. I set the alternate key length to 160 for this one index, and nothing bad happened (so far). I use that with the setindex, readfwd, etc unibasic commands in a subroutine to return the matching record id, or nothing if not found. Haven't had a need to go any bigger than that. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Friday, September 10, 2010 4:04 PM To: U2 Users List Subject: Re: [U2] Slow READ/WRITE with indexes (Nick Gettino) How long of a data string to you want to index? This mostly has a bearing on the block-size of the index file (the key length setting) Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis Sent: Friday, September 10, 2010 1:24 PM To: U2 Users List Subject: Re: [U2] Slow READ/WRITE with indexes (Nick Gettino) Does building the biggest first really matter, or is it more important to just put the right value in the key size prompt you get asked for on the first index you create? Also, does anyone know in UniData how big a key size you can give on an index? I know it's bigger than the 120-something you are limited to for the file key, but I've never seen a documented limit. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nick Gettino Sent: Friday, September 10, 2010 3:19 PM To: u2-users@listserver.u2ug.org Subject: [U2] Slow READ/WRITE with indexes (Nick Gettino) On Unidata you can do a LIST.INDEX 'FILENAME' ALL STATS This will give you each index the number of keys how many are in overflow and a couple of other things. If you can't tell from that command use LIST.INDEX 'FILE.NAME' ALL DETAILS This will show you how many records per key and whether the index item is in overflow. As mentioned use the NO.NULLS and or NO.DUPS to build the index. And this has been a killer for us. You have to ALWAYS build the biggest index first. By biggest I mean the dictionary length being used. Example. If you have city, state zip, order# and date. 40L, 15R, 8R respectively that is how they should be built. Nicholas M Gettino - Director of Support Professional Services | EnRoute Emergency Systems an Infor Company, 401 E Jackson Street, Suite 1500, Tampa Florida 33602 | Office 813-207-6998 |Fax 678-393-5389 |nick.gett...@enroute911.com / www.enroute911.com Register Now- Early Bird Discount Available | enroute911.com/user-conference-2010 | EnRoute User Conference | Disney's Yacht Club Resort, Lake Buena Vista, FL | September 28- October 1, 2010 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2-users-requ...@listserver.u2ug.org Sent: 09/10/2010 3:00 PM To: u2-users@listserver.u2ug.org Subject: U2-Users Digest, Vol 17, Issue 8 Send U2-Users mailing list submissions to u2-users@listserver.u2ug.org To subscribe or unsubscribe via the World Wide Web, visit http://listserver.u2ug.org/mailman/listinfo/u2-users or, via email, send a message with subject or body 'help' to u2-users-requ...@listserver.u2ug.org You can reach the person managing the list at u2-users-ow...@listserver.u2ug.org When replying, please edit your Subject line so it is more specific than Re: Contents of U2-Users digest... Today's Topics: 1. Re: Sequential Files Question (Colin Alfke) 2. Re: Sequential Files Question (Bill Haskett) 3. Re: Slow READ/WRITE with indexes (Ryan M) 4. Re: Slow READ/WRITE with indexes (Ryan M) 5. Re: Slow READ/WRITE with indexes {Unclassified} (HENDERSON MIKE, MR) 6. Re: Slow READ/WRITE with indexes (Colin Alfke) 7. Re: Sequential Files Question (Colin Alfke) 8. Re: Sequential Files Question (Bill Haskett) 9. Re: Slow READ/WRITE with indexes {Unclassified} (Wols Lists) 10. Re: Slow READ/WRITE with indexes {Unclassified} (Dan McGrath) 11. Re: Slow READ/WRITE with indexes (Boydell, Stuart) 12. Re: Slow READ/WRITE with indexes (Ryan M) 13. Re: Slow READ/WRITE with indexes {Unclassified} (Ryan M) 14. Re: Slow READ/WRITE with indexes (Ryan M) 15. UD - XDOMLocate problem - solved (Edward Brown) 16. Re: Slow READ/WRITE with indexes {Unclassified} (Wols Lists) -- Message: 1 Date: Thu, 9 Sep 2010 13:02:10 -0600 From: Colin Alfke alfke...@hotmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Subject
Re: [U2] Slow READ/WRITE with indexes (Nick Gettino)
indexed. So if the index fields should always contain data of some sort, then the NO.NULLS option shouldn't make any difference. If the fields are often left blank, then yes it's a good idea to use the NO.NULLS option. Be aware, though, that one of the side effects is if you select for that field being blank, the index won't be used... If a blank entry is an error but sometimes happens and you want to fix them, then you don't want to use NO.NULLS because it makes finding the errors easier. Cheers, Wol Wols Lists wrote: On 09/09/10 21:29, HENDERSON MIKE, MR wrote: Ryan, You said you had indexes like 'ORDER.DATE', 'COUNTRY', 'MEMBER ID'. If those are really the full index data items, you could have thousands, tens of thousands, or even hundreds of thousands, of records with the identical index data item value in the SOH file. If that's the case, updates (inserts) may well be s-l-o-w as the system churns through many, many, many linked buffers of identical valued keys looking for an insert point. That was my thinking too. The other, related point. Does UD have NO.NULLS? And are you using it? If you haven't used it that's the most common performance-killer with indices out there ... Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users End of U2-Users Digest, Vol 17, Issue 8 *** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Slow READ/WRITE with indexes
I get your point though - it matches my result - 10K block size for 160 key size. It does what I need it to do though. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Friday, September 10, 2010 4:12 PM To: U2 Users List Subject: Re: [U2] Slow READ/WRITE with indexes Hmm - table didn't get handled well by MS mail Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Friday, September 10, 2010 2:09 PM To: U2 Users List Subject: Re: [U2] Slow READ/WRITE with indexes Key Size Block Size Key Size Block Size 1-13 2,048 137-177 10,240 14-54 4,096 178-218 12,288 55-95 6,144 219-259 14,336 96-136 8,192 260-300 16,384 Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Friday, September 10, 2010 2:04 PM To: U2 Users List Subject: Re: [U2] Slow READ/WRITE with indexes (Nick Gettino) How long of a data string to you want to index? This mostly has a bearing on the block-size of the index file (the key length setting) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] SOAP in Unidata 6.1
That shouldn't be too difficult. I did a test with a free zip code service. What tools/components do you need to write a service to send stuff OUT of unidata? $ cat ST.BASIC.ZIP.REQ2 SUBROUTINE ST.BASIC.ZIP.REQ2(L.ZIP.CODE, RespHeaders, RespData, SoapStatus, xmlString) ** * Description of subroutine * Used for documentation purposes (including auto documentation) ** * $INCLUDE INCLUDE XML.H * RespHeaders = '' RespData = '' SoapStatus = '' xfile = xmlString = XMLMap = _XML_/ZIPCODES.map ZIPX = '' ZIPX := '?xml version=1.0 encoding=UTF-8?' ZIPX := 'soap:Envelope' ZIPX := ' xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;' ZIPX := ' xmlns:xsd=http://www.w3.org/2001/XMLSchema;' ZIPX := ' xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/;' ZIPX := ' soap:Body' ZIPX := 'GetInfoByZIP xmlns=http://www.webserviceX.NET;' ZIPX := 'USZip':L.ZIP.CODE:'/USZip' ZIPX := '/GetInfoByZIP' ZIPX := ' /soap:Body' ZIPX := '/soap:Envelope' URL = 'http://www.webservicex.net/uszip.asmx?WSDL' SoapAction = 'http://www.webserviceX.NET/GetInfoByZIP' Timeout = 3 * create the request Ret = SoapCreateRequest(URL, SoapAction, SoapReq) if (Ret = 0) then SETREQUEST.STATUS = soapSetRequestContent(SoapReq, ZIPX, 1) Ret = SoapSubmitRequest(SoapReq, Timeout, RespHeaders, RespData, SoapStatus) RespData = RespData:CHAR(10) ;* add a line-feed at the end of the xml string Status = XDOMOpen(RespData, XML.FROM.STRING, DOMH) ;* domh is the document handle if (Status = XML.SUCCESS) then Status = XDOMLocate(DOMH,'//NewDataSet','',domHandle) if (Status = XML.SUCCESS) then Status = XDOMLocateNode(domHandle, XDOM.CHILD, XDOM.FIRST.CHILD, XDOM.ELEMENT.NODE, sibHandle) Status = XDOMWrite(domHandle, xmlString, XML.TO.STRING) end end end return _XML_/ZIPCODES.map ?xml version=1.0 ? !-- DOCTYPE U2XMAP SYSTEM U2XMAP.DTD -- U2XMAP version=1.0 Name=ZIPCODES.map XSD=ZIPCODES.xsd OPTIONS /OPTIONS !-- Table/Class map ZIPCODES_NewDataSet -- TABLECLASSMAP MapName=ZIPCODES_NewDataSet StartNode=/NewDataSet Table Name=ZIPCODES Action=Default ColumnMap Node=Table/AREA_CODE Column=AREA_CODE/ ColumnMap Node=Table/CITY Column=CITY/ ColumnMap Node=Table/STATE Column=STATE/ ColumnMap Node=Table/TIME_ZONE Column=TIME_ZONE/ ColumnMap Node=Table/ZIP Column=ZIP/ /TABLECLASSMAP /U2XMAP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Hiscock Sent: Wednesday, August 20, 2008 3:50 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] SOAP in Unidata 6.1 Hi Tony, Thanks for the response, but I'm trying to go the other way. I'm trying to write a web service CONSUMER in Unidata, not provide access to the MV database. I was looking at the SOAP functions in Basic (SOAPCreateRequest, SOAPSetParameters, SOAPSubmitRequest, etc) to connect to an outside web service to retrieve data. --Larry Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: Wednesday, August 20, 2008 10:07 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] SOAP in Unidata 6.1 Larry - have a look at the video on our website: removepleaseNebula-RnD.com/products/gallery.htm You can do this in less than 20 minutes. You said free so disregard references to mv.NET and use UO.NET. The point here is that the SOAP/webservice part is completely generated by Visual Studio. The only thing you need to do is connect to Unidata and exchange plain text. My general policy is to use the database as a database, not as an engine for XML, web services, ODBC, or many of the other non-portable things that get embedded into the engine. YMMV HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com From: Larry Hiscock Does anyone have a working SOAP example in Unidata (UD 6.1) that they'd be willing to share? Preferably one that works with a free (or demo) webservice that I can use to test. I've done webservices before in .NET, but not in Unidata. The example in the manuals looks pretty simple, but doesn't actually work. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Keys with @AM in them...
You could fix this by selecting all records EXCEPT those with keys containing @AM in the key, copying them to a temporary file, and then clearing the permanent file and copying from the temporary file back in. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Monday, April 07, 2008 3:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] Keys with @AM in them... How do I fix this? My program wrote items with @AM in the key. (oops) Now, I can 'select' the items, but I cannot get rid of them - they show as non-existent. Is there a way to remove/clean up these records, or will I have to clear the file and copy the good records back in? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] COMMON
Yes, but be sure to re-initialize to '' AFTER closing, if you close it, at least in UniData. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Friday, April 04, 2008 8:07 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] COMMON Following up on the common thread, can one OPENSEQ to a COMMON variable? -Original Message- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SBClient problems??
What does the process look like? What are the letter options you used? What fields are displayed? Sounds like the key works, otherwise it wouldn't call the process. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Parkinson Sent: Tuesday, March 18, 2008 11:40 AM To: u2-users@listserver.u2ug.org Subject: [U2] SBClient problems?? Hi I have a problem with what I think is a SBClient 5.0.4 installation. The problem is the intuitive help key (F3) seems to have stopped functioning, What happens is the process behind the F3 is called but the resulting select list is not displayed on screen. This is only in GUI mode, in character mode it's works as expected. The reason I think it's SBClient causing the problem, is that I can log onto the same system from a remote PC and the F3 key does function as expected in GUI mode. Has anyone else encountered this? If so any idea on how I can fix this problem. Kind regards Paul Parkinson -- I am using the free version of SPAMfighter for private users. It has removed 3211 spam emails to date. Paying users do not have this message in their emails. Get the free SPAMfighter here: http://www.spamfighter.com/len --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SB+ Report Writer Question
If you want to use unidata virtual fields (like you initially tried to) you need to wrap them in the I() syntax -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mecki Foerthmann Sent: Thursday, March 13, 2008 9:03 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] SB+ Report Writer Question Thank you Colin, you gave me back my sanity. Mecki Colin Jennings wrote: Hi Mecki. This really should be a question for the SB Solutions list ([EMAIL PROTECTED]) but fortunately there's a few of us that frequent both lists! You need to use the DUP function in your derived field - For example (BUD_MATL / DUP(10,BUD_MATL) - ACT_MATL). The DUP will duplicate the static value as many times as there are multi-values in BUD_MAIL. Best wishes Colin. I am trying to write a report using SB+ 5.2 on UniData. The problem is that I have 2 multi-valued fields - One with 3 decimal places and the other with only 2. To show the difference, I need to divide the first field by 10. Now, I have been trying this for days, but it just won't work. I created a new field with a derived value : (BUD_MATL / 10 - ACT_MATL), but it only does the calculation on the first value. For all others it returns -ACT_MATL If I use the generated V-Type dictionary with LIST, it works fine. It uses REUSE(10) as expected. If I try REUSE(10) in the Field Definition though, SB+ won't let me - Syntax Error. Anybody out there, who can help me solve this puzzle? Mecki Foerthmann --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Excel downloads
What if the data fields contain quotes or double-quotes themselves? Does this handle that situation? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Wednesday, February 13, 2008 4:00 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Excel downloads Laure Then it sounds like you could do the option described in these posts For those who are lazy to write fancy routines to create CSV files, I've created two dict items, namely COMMA and QUOTE, as follows: COMMA 001: I 002: , 003: 004: , 005: 1T QUOTE 001: I 002: '' 003: 004: 005:1T To create a CSV file of _ANY_ file data, these dict items either need to be in the DICT of every file, OR once off in the DICT.DICT (I think - correct me anyone?) csv imports don't mind excessive spaces... LIST DFQ COMMA DFQ.ID COMMA ACCOUNT COMMA DATEOP COMMA 21:47:38 07-02-08 DFQUOTE.FILE. , QUOTE NO. , ACCOUNT... , DATEOP , 208-015646-01 , 208-015646-01 , 208-015646 , 04/05/2007 , 205-011887-AH , 205-011887-AH , 205-011887 , 10/11/2000 , 202-012637-AH , 202-012637-AH , 202-012637 , 16/02/2005 , to handle numeric fields simply quote them LIST DFQ COMMA QUOTE DFQ.ID QUOTE COMMA QUOTE ACCOUNT QUOTE 21:50:36 07-02 DFQUOTE.FILE. ,'QUOTE NO.','ACCOUNT... ' '208-015646-01,'208-015646-01','208-015646 ' '205-011887-AH,'205-011887-AH','205-011887 ' '202-012637-AH,'202-012637-AH','202-012637 ' '202-014954-01,'202-014954-01','202-014954 ' And here is where I used it 0001: PA 0002: DISPLAY Saving output as AAQ 0003: SP-ASSIGN HS 0004: SETPTR 0,300,,0,0,3,BRIEF,NFMT, BANNER AAQ 0005: SORT DFQ _ 0006: WITH INVOICE _ 0007: BY ACCOUNT _ 0008: BY DATEOP _ 0009: COMMA DFQ.ID _ 0010: COMMA ACCOUNT _ 0011: COMMA DATEOP _ 0012: COMMA _ 0013: COMMA DFQ.HPHONE _ 0014: COMMA HPM.HOMEPHONE _ 0015: COMMA _ 0016: COMMA DFQ.WPHONE _ 0017: COMMA HPM.WORKPHONE _ 0018: COMMA _ 0019: COMMA DFQ.CELL _ 0020: COMMA HPM.CELLPHONE _ 0021: COMMA _ 0022: COMMA DFQ.SPWORKNO _ 0023: COMMA HPM.SPWORKPHONE _ 0024: COMMA _ 0025: COMMA DFQ.SPCELL _ 0026: COMMA HPM.SPCELLPHONE _ 0027: LPTR NOPAGE HDR.SUP ID.SUP And subsequently modified by Kevin For what it's worth, I do something similar, but I use TAB. My Dict item looks like: 0001: I 0002: 0003: 0004: TAB 0005: 1L 0006: S Line two is actually ^009, but it shows . Excel handles tab delimited well and I never worry about whether the field is numeric. My output line would be: VAL1 TAB VAL2 TAB VAL3 TAB VAL4 Works well for me. --Kevin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Excel downloads
If you have quotes in the data you prefix them with a quote - for example, the field value: In your free time Becomes In your free time The easiest way to see what the CSV should look like is to type some data in an excel spreadsheet and output it to a CSV file. Our current approach is to create a CSV file, a headings-only Excel spreadsheet with the columns typed correctly, and macros to import the CSV file (which uses a .txt extension instead of .csv in our case), auto-size the columns, and anything else. Would be interested in hearing about any different/better approaches. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen Sent: Wednesday, February 13, 2008 12:01 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Excel downloads Comma delimited fields are always a bit of an issue in this case. The correct way to program CSVs is to place quotes around the fields, to account for just this - but then: what if you have quotes in your fields? Tab is usually a safer delimiter for the simple reason that it is rarely stored as such in data files, but Excel does not handle a tab-delimited file quite as well as a CSV file. You can of course use I-descriptors that convert quotes to blanks first, or any other transformation. Thus my original question asking for help and tricks: I know what it takes to get me to where I want to be, but I am looking for the miracle tool that will work for all types of data extractions with minimal data massaging and scripting from me. Thanks, Laure Hansen, City of Redwood City Information Technology 1017 Middlefield Road Redwood City, CA 94063 Tel 650-780-7087 Cell 650-207-3235 Fax 650-556-9204 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Davis Sent: Wednesday, February 13, 2008 7:36 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Excel downloads What if the data fields contain quotes or double-quotes themselves? Does this handle that situation? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Wednesday, February 13, 2008 4:00 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Excel downloads Laure Then it sounds like you could do the option described in these posts For those who are lazy to write fancy routines to create CSV files, I've created two dict items, namely COMMA and QUOTE, as follows: COMMA 001: I 002: , 003: 004: , 005: 1T QUOTE 001: I 002: '' 003: 004: 005:1T To create a CSV file of _ANY_ file data, these dict items either need to be in the DICT of every file, OR once off in the DICT.DICT (I think - correct me anyone?) csv imports don't mind excessive spaces... LIST DFQ COMMA DFQ.ID COMMA ACCOUNT COMMA DATEOP COMMA 21:47:38 07-02-08 DFQUOTE.FILE. , QUOTE NO. , ACCOUNT... , DATEOP , 208-015646-01 , 208-015646-01 , 208-015646 , 04/05/2007 , 205-011887-AH , 205-011887-AH , 205-011887 , 10/11/2000 , 202-012637-AH , 202-012637-AH , 202-012637 , 16/02/2005 , to handle numeric fields simply quote them LIST DFQ COMMA QUOTE DFQ.ID QUOTE COMMA QUOTE ACCOUNT QUOTE 21:50:36 07-02 DFQUOTE.FILE. ,'QUOTE NO.','ACCOUNT... ' '208-015646-01,'208-015646-01','208-015646 ' '205-011887-AH,'205-011887-AH','205-011887 ' '202-012637-AH,'202-012637-AH','202-012637 ' '202-014954-01,'202-014954-01','202-014954 ' And here is where I used it 0001: PA 0002: DISPLAY Saving output as AAQ 0003: SP-ASSIGN HS 0004: SETPTR 0,300,,0,0,3,BRIEF,NFMT, BANNER AAQ 0005: SORT DFQ _ 0006: WITH INVOICE _ 0007: BY ACCOUNT _ 0008: BY DATEOP _ 0009: COMMA DFQ.ID _ 0010: COMMA ACCOUNT _ 0011: COMMA DATEOP _ 0012: COMMA _ 0013: COMMA DFQ.HPHONE _ 0014: COMMA HPM.HOMEPHONE _ 0015: COMMA _ 0016: COMMA DFQ.WPHONE _ 0017: COMMA HPM.WORKPHONE _ 0018: COMMA _ 0019: COMMA DFQ.CELL _ 0020: COMMA HPM.CELLPHONE _ 0021: COMMA _ 0022: COMMA DFQ.SPWORKNO _ 0023: COMMA HPM.SPWORKPHONE _ 0024: COMMA _ 0025: COMMA DFQ.SPCELL _ 0026: COMMA HPM.SPCELLPHONE _ 0027: LPTR NOPAGE HDR.SUP ID.SUP And subsequently modified by Kevin For what it's worth, I do something similar, but I use TAB. My Dict item looks like: 0001: I 0002: 0003: 0004: TAB 0005: 1L 0006: S Line two is actually ^009, but it shows . Excel handles tab delimited well and I never worry about whether the field is numeric. My output line would be: VAL1 TAB VAL2 TAB VAL3 TAB VAL4 Works well for me. --Kevin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe
RE: [U2] OCONV DATE ISSUE.
Subtracting 1 means you will get a mathematical result - leading digits are dropped. OCONV(OCONV(@DATE,'DM') - 1,'MR%2') will get you a result consistent with OCONV(@DATE,'DM') If you want to strip out leading zeros in the month regardless, add 0. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Friday, February 08, 2008 11:35 AM To: u2-users@listserver.u2ug.org Subject: [U2] OCONV DATE ISSUE. The question is when I do OCONV(@DATE, 'DM') I get 02 but when I do OCONV(@DATE, 'DM')-1 I get 1 not 01. Why? And how do I get these to match? The reason for this is I'm trying to do this as a i-desc But my dates don't equal because of the weird oconv issue. IF OCONV(@DATE, 'DM') - 1 '1' THEN OCONV(@DATE, 'DY') - 1 : '12' ELSE OCONV(@DATE, 'DY') : OCONV(@DATE, 'DM') - 1; (OCONV(Inv_So_Date,'DY'):OCONV(Inv_So_Date,'DM')); IF B$Record_Type = 'BK' THEN IF @1 = @2 THEN QTY ELSE '0' ELSE '0' I'll take a better solution if someone has it since I have to do this for 36 months making 36 i-desc to put it in columns for my output that will need to be grouped and summed. Jeffrey Lettau ERP Systems Manager polkaudio Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniSQL - virtual fields problem
Are you explicitly including the virtual fields in your select statement? Are they in the @SELECT dictionary item? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Chiang Sent: Tuesday, January 08, 2008 10:59 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniSQL - virtual fields problem Running UniData 7.1 and having difficulties of accessing virtual fields within UniSQL. We SQLized the UniData files using VSG. We then SELECT the table within UniSQL. There are good results returned from all the data fields, but, nothing returned from any of the virtual fields. Are there known issues with virtual fields within UniData 7.1? Thanks for your help. Larry - Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniSQL - virtual fields problem
Are you using sql just from the sql prompt, or from ODBC? Any problems with joins using ODBC? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Chiang Sent: Tuesday, January 08, 2008 1:55 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniSQL - virtual fields problem Yes. We started out by selecting a mixed of data and virtual fields. Once it became apparent that no values returned from any of the virtual fileds, we tried by selecting either just multiple or single virtual fields to no avail. I'm not familiar with @SELECT dictionary item, but, they are definitely are in the LISTDICT. Dave Davis [EMAIL PROTECTED] wrote: Are you explicitly including the virtual fields in your select statement? Are they in the @SELECT dictionary item? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Chiang Sent: Tuesday, January 08, 2008 10:59 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniSQL - virtual fields problem Running UniData 7.1 and having difficulties of accessing virtual fields within UniSQL. We SQLized the UniData files using VSG. We then SELECT the table within UniSQL. There are good results returned from all the data fields, but, nothing returned from any of the virtual fields. Are there known issues with virtual fields within UniData 7.1? Thanks for your help. Larry - Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - Never miss a thing. Make Yahoo your homepage. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] selection of multivalued field based on range
Because there are some that match the first criteria and some that match the second. You can LIST these out, like this: list filename WHEN ASD(QTY = 1000 AND QTY = 2000) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Russ Watson Sent: Wednesday, December 19, 2007 10:37 AM To: u2-users@listserver.u2ug.org Subject: [U2] selection of multivalued field based on range I want to select records to report if *one* of the multivalues falls within a range. For example: select with qty = 1000 and = 2000 If I use the example I get records where none of the values satisfies the range condition. @ID qty --- --- 11292,500.0 2,500.0 300.0 Russ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] selection of multivalued field based on range
You wouldn't get all records, just those that contained one or more quantity = 1000 and also one or more quantity = 2000. If the phase with qty = 1000 and = 2000 is actually interpreted as with qty = 1000 OR = 2000 when a multi-valued field is evaluated, then I would have expected to get all records - which does not happen. Russ --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Need to partially hide a file
One approach would be to set up separate accounts for privileged vs. non-privileged users. That would give you two VOC files, and the paths to the data could be different for some or all of the files. Another approach is the following: In UniData this could be done by using environment variables, and assigning the variable with different values for some users than for others. For example: F @ENVVAR/PRIVATEFILE D_PRIVATEFILE User A (privileged) could have it set to C:\private. User B could have it set to . I don't know how much trouble that is to set up for windows users though. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Augusto Alonso Sent: Wednesday, November 28, 2007 1:46 PM To: u2-users@listserver.u2ug.org Subject: [U2] Need to partially hide a file Hi all. Can someone tell me if it is possible? I'll explain the scenario: We need to hide some private data (customer personal data) in order to fit with our Private Data Protection Law. But only for some users, the others, they need to have full access. Our app is complex enough to modify the source code. So, our ideal sollution would be making a dynamic File Entry VOC, that will look like this: For Non-privileged users: CT VOC PRIVATEFILE PRIVATEFILE 0001 F 0002 PRIVATEFILE 0003 D_PRIVATEFILE And for privileged users: CT VOC PRIVATEFILE PRIVATEFILE 0001 F 0002 C:\private\PRIVATEFILE 0003 D_PRIVATEFILE so that, the rights could be defined at O.S. level, and the app will allways open a file (the private one or the public one) The problem is that I can't figure out how can I do a VOC entry dependig on the particular user. Or even, if it is possible... TIA. Regards, Augusto Alonso [EMAIL PROTECTED] www.quiter.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/