RE: [U2] writeseq
Dave, You didn't say you were on UniData. WriteBlk is a UniVerse statement. How about OSBWrite? Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: 14 October 2004 17:12 To: [EMAIL PROTECTED] Subject: RE: [U2] writeseq WriteBlk? What version of Unidata is that supported in? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Thursday, October 14, 2004 3:21 AM To: [EMAIL PROTECTED] Subject: RE: [U2] writeseq Dave, Use WriteBlk rather than WriteSeq. Brian. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Raven Sent: 13 October 2004 23:17 To: [EMAIL PROTECTED] Subject: [U2] writeseq I am using a writeseq to build a record for flat file, I have 5 to 15000 records I am build into one item, after each record I append it to the flat file item however there is a blank line appended each time it writes ? Is there a way to omit the blank line when it writes? Thanks D Raven e Fax (815)4259364 P.O. Box 17811, Irvine CA 92623-7811 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ __ This email was checked by MessageLabs SkyScan before entering Microgen. __ __ This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2][UV]Device Licensing
Hi, We have a problem where by we have activated device licensing on UV system, but device licensing does not seem to work on all our PC's effectively. Let me explain we use wIntegrate, Dynamic Connect, Viaduct as terminal emulators, in the vast majority of cases these connections are happy to share a license regardless of which emulator we use. We also have some API's developed using UniObjects, now this is where the crux is whenever we use these API's they take a new license rather than sharing with the one already in use, we have been advised that UniObjects is device license aware!! My question is are we missing a setting somewhere or a dll that is required, any help would be greatly appreciated. We are using UV 10.1.4 running on AIX 5.2 Thanks Sunny Matharoo Development Team Leader Tristar Worldwide Chauffeur Services Tel:+44 (0)1753 771317 Fax:+44 (0)1753 790301 E-mail: [EMAIL PROTECTED] www.tristarworldwide.com --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV]Device Licensing
You have to specify the SubKey property as the same for each group of connections. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sunny Matharoo Sent: 15 October 2004 09:57 To: [EMAIL PROTECTED] Subject: [U2][UV]Device Licensing Hi, We have a problem where by we have activated device licensing on UV system, but device licensing does not seem to work on all our PC's effectively. Let me explain we use wIntegrate, Dynamic Connect, Viaduct as terminal emulators, in the vast majority of cases these connections are happy to share a license regardless of which emulator we use. We also have some API's developed using UniObjects, now this is where the crux is whenever we use these API's they take a new license rather than sharing with the one already in use, we have been advised that UniObjects is device license aware!! My question is are we missing a setting somewhere or a dll that is required, any help would be greatly appreciated. We are using UV 10.1.4 running on AIX 5.2 Thanks Sunny Matharoo Development Team Leader Tristar Worldwide Chauffeur Services Tel:+44 (0)1753 771317 Fax:+44 (0)1753 790301 E-mail: [EMAIL PROTECTED] www.tristarworldwide.com --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Strange Select Results?
Bjorn - What is the HFSA error? Could that be resetting it? AFAIK, the SETTING clause copies the result of @SYSTEM.RETURN.CODE. That is set to the return value of the last command processed: for a SELECT, this happens to be the same as the number of records selected, but for any other statement it is the statement return status. If you are executing several statements together, it will be the return value of the last statement. The @SELECTED retains the last number of records selected. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bjorn Behr Sent: 15 October 2004 12:52 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Strange Select Results? If I did it corrently - this is what I get: Tcl Statement = SELECT PU.SHIP.TIMES WITH ITEM = 111622 AND STATUS = 4 Select Y = -1 Select X = ~1 record(s) selected to SELECT list #0.~Verb HFSA is not in your VOC.~ @SELECTED = 1 @SYSTEM.RETURN.CODE = 0 Does this help? Bjorn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: 15 October 2004 01:11 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Strange Select Results? Bjorn, 1. Is there anything that your ITEM or STATUS dictionaries might be doing that could reset @SYSTEM.RETURN.CODE? 2. What does @SELECTED read after the select? Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bjorn Behr Sent: 15 October 2004 11:47 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Strange Select Results? If I run the select from TCL - It returns 1 (which is correct) Does not give any error messages. Bjorn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mats Carlid Sent: 14 October 2004 04:09 To: [EMAIL PROTECTED] Subject: Re: [U2] [UV] Strange Select Results? I've never seen select reuturn status -1 except when there is a syntax error in the select command - so try rerunning without hush or run the select from the tcl to capture the error messages - if any. HTH -- mats Bjorn Behr wrote: Why when I execute this: EXECUTE Tcl CAPTURING SelectX Returning SelectY do I get this? :: Tcl/ STRING: T r L=64 `SELECT PU.SHIP.TIMES WITH ITEM = 336DB-1.1/2 AND STATUS = 4' :: SelectX/ STRING: T r L=73 `~1 record(s) selected to SELECT list #0.' :: SelectY/ NUMBER: -1 Should SelectY not equal 1? PS: It should select 1! System Information: O/S: Windows 2003 UV : UniVerse 10.1 ___ _ Regards Bjvrn Behr Programmer HYFLO Southern Africa (Pty) Ltd Tel : +27 11 386 5800 Fax : +27 11 444 5391 Mail: [EMAIL PROTECTED] WWW : http://www.hyflo.co.za ___ _ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk --- u2-users mailing list [EMAIL PROTECTED] To
RE: [U2] [UV] Cannot establish a Universe session
It happens for all users, including root. It doesn't happen all the time though. When it is occurring no one can log into universe. The errlog file has the proper permissions. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Snyder Sent: Thursday, October 14, 2004 8:58 PM To: [EMAIL PROTECTED] Subject: Re: [U2] [UV] Cannot establish a Universe session Nick Cipollina [EMAIL PROTECTED] wrote on 10/14/2004 04:08:19 PM: Cannot open log file. It repeats over and over again. Is there a file called errlog in your uvhome directory? (ls -l `cat /.uvhome`/errlog) If so, it should have its permissions set at -rw-rw-rw-. Is this happening for all users or just some? All accounts or just some? Is it possible - as somebody else alluded to - that there's something being executed in the LOGIN or UV.LOGIN paragraph that could be causing this message? Tim Snyder IBM Information Management Consulting I/T Specialist , U2 Professional Services --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Strange Select Results?
Thanks - A CLEARDATA took it away returned the correct result. Thanks all hwo helped Bjorn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: 15 October 2004 02:14 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Strange Select Results? This bit isn't right. Is the data stack clear before you do the execute? ~1 record(s) selected to SELECT list #0.~Verb HFSA is not in your VOC.~ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bjorn Behr Sent: 15 October 2004 12:52 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Strange Select Results? If I did it corrently - this is what I get: Tcl Statement = SELECT PU.SHIP.TIMES WITH ITEM = 111622 AND STATUS = 4 Select Y = -1 Select X = ~1 record(s) selected to SELECT list #0.~Verb HFSA is not in your VOC.~ @SELECTED = 1 @SYSTEM.RETURN.CODE = 0 Does this help? Bjorn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: 15 October 2004 01:11 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Strange Select Results? Bjorn, 1. Is there anything that your ITEM or STATUS dictionaries might be doing that could reset @SYSTEM.RETURN.CODE? 2. What does @SELECTED read after the select? Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bjorn Behr Sent: 15 October 2004 11:47 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Strange Select Results? If I run the select from TCL - It returns 1 (which is correct) Does not give any error messages. Bjorn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mats Carlid Sent: 14 October 2004 04:09 To: [EMAIL PROTECTED] Subject: Re: [U2] [UV] Strange Select Results? I've never seen select reuturn status -1 except when there is a syntax error in the select command - so try rerunning without hush or run the select from the tcl to capture the error messages - if any. HTH -- mats Bjorn Behr wrote: Why when I execute this: EXECUTE Tcl CAPTURING SelectX Returning SelectY do I get this? :: Tcl/ STRING: T r L=64 `SELECT PU.SHIP.TIMES WITH ITEM = 336DB-1.1/2 AND STATUS = 4' :: SelectX/ STRING: T r L=73 `~1 record(s) selected to SELECT list #0.' :: SelectY/ NUMBER: -1 Should SelectY not equal 1? PS: It should select 1! System Information: O/S: Windows 2003 UV : UniVerse 10.1 ___ _ Regards Bjvrn Behr Programmer HYFLO Southern Africa (Pty) Ltd Tel : +27 11 386 5800 Fax : +27 11 444 5391 Mail: [EMAIL PROTECTED] WWW : http://www.hyflo.co.za ___ _ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit
[U2] UV licencing - Machine hangs
We have a problem... UniVerse 10.1.2 AIX 5.2 IBM p615 184 user licence Today we had 174 users working. There was a power dip at one of our remote sites (WAN), and the users there attempted to log in again. Naturally the user licences were fully used up (the pre-dip users were still logged in). This resulted in the machine no longer responding to any shell level commands. Is there any way one can set UniVerse to prevent user licence issues hanging the machine? Is there any way to get the machine to monitor when licences are approaching the maximum, and it warning someone? - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Triggers
We did use them extensively in our applications for updating audit files, referential integrity checks etc etc. All fairly normal things. Performance was terrible and got worse (obviously) the more transactions we did. However nearly all our software is real-time and there is very rarely a user on the front of it. A trigger in a normal data entry program would be fine, the user wouldn't even notice. Personally I would avoid them for time-critical batch updates or milli-second dependent real-time updates. They are very useful for more traditional programs though. Now that we run Universe replication we can't run triggers at all as they are not supported on replicated files. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rex Gozar Sent: 15 October 2004 14:15 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Triggers Some thoughts in regards to Dennis' observation that triggers are slow. I would kinda expect them to be slow. After all, they are (essentially) little programs that get run each time a record is changed. Even if the trigger did nothing, some overhead is expected for processing each record. I'm curious about performance differences between traditional update programs and triggers. Writing 500 000 records with and without a trigger only tells us that triggers have overhead, but how would you measure the performance difference of moving actual functionality from a traditional program to a trigger? For example, let's say I have a data-mangling function implemented in a subroutine that's called from various programs during record updates. If I were to rip the data-mangling subroutine out of the entry programs and move it to a trigger, what kind of performance would I gain/lose? This would be a more meaningful metric to me -- if the trigger was significantly slower, I would probably avoid triggers. Has anyone out there performed any trigger benchmarks like this? I'm guessing no. Another consideration is maintenance programming. Triggers can simplify both the initial design and maintenance of software systems, which is why they are popular in other databases. Like a lot of things in technology, they can be misunderstood and abused. Used wisely, triggers can help in managing software complexity. REX --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV licencing - Machine hangs
When on UV I had a scheduled phantom that would run the license cleanup once an hour. Seemed kinda silly to have to do it, but it helped prevent user hassles. As for monitoring, you could always add something to LOGIN to check the user count (EXECUTE the license count tool and parse the CAPTURE) and send an email when it exceeds a given value. HTH, David Beahm Dennis Bartlett wrote: We have a problem... UniVerse 10.1.2 AIX 5.2 IBM p615 184 user licence Today we had 174 users working. There was a power dip at one of our remote sites (WAN), and the users there attempted to log in again. Naturally the user licences were fully used up (the pre-dip users were still logged in). This resulted in the machine no longer responding to any shell level commands. Is there any way one can set UniVerse to prevent user licence issues hanging the machine? Is there any way to get the machine to monitor when licences are approaching the maximum, and it warning someone? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV licencing - Machine hangs
Dennis, You may want to take a look at the max number of processes for the unix kernal. If this is configured low to handle your normal level of users, this may have maxed out, preventing shell commands from responding in anything remotely close to a timely manner. Drew Dennis Bartlett wrote: We have a problem... UniVerse 10.1.2 AIX 5.2 IBM p615 184 user licence Today we had 174 users working. There was a power dip at one of our remote sites (WAN), and the users there attempted to log in again. Naturally the user licences were fully used up (the pre-dip users were still logged in). This resulted in the machine no longer responding to any shell level commands. Is there any way one can set UniVerse to prevent user licence issues hanging the machine? Is there any way to get the machine to monitor when licences are approaching the maximum, and it warning someone? -- -- Drew Henderson There are two types of people - Dir. for Computer Center Operations those who do the work and those [EMAIL PROTECTED] who take the credit. Try to be in the first group, there is 110 Ginger Hall less competition. Morehead State University Indira Ghandi Morehead, KY 40351 Phone: 606/783-2445 Fax: 606/783-5078 -- --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV licencing - Machine hangs
If you were not aware of it, there is a known bug in AIX 5.2 that keeps AIX from properly cleaning up utmp for badly terminated telnet sessions. We are running utmpd until IBM comes up with the fix. I suggest you call AIX support and tell them your problem. Dennis Bartlett [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2004 08:49 AM Please respond to u2-users To: [EMAIL PROTECTED] cc: Subject:[U2] UV licencing - Machine hangs We have a problem... UniVerse 10.1.2 AIX 5.2 IBM p615 184 user licence Today we had 174 users working. There was a power dip at one of our remote sites (WAN), and the users there attempted to log in again. Naturally the user licences were fully used up (the pre-dip users were still logged in). This resulted in the machine no longer responding to any shell level commands. Is there any way one can set UniVerse to prevent user licence issues hanging the machine? Is there any way to get the machine to monitor when licences are approaching the maximum, and it warning someone? - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] UD PE is available
UniData personal editions are now available for both Linux and Windows. I was able to download the linux version this morning. Lee Bacall http://www.binarystar.com Phone: +1 (954) 791-8575 Cell: +1 (954) 655-6581 Is there any news on the availability of the 6.1PE download? Thanks, Noah Hart --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD PE is available
Did you download version 6 or version 6.1? What is the link to the download? I can only find version 6... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lee Bacall Sent: Friday, October 15, 2004 8:55 AM To: [EMAIL PROTECTED] Subject: [U2] UD PE is available UniData personal editions are now available for both Linux and Windows. I was able to download the linux version this morning. Lee Bacall http://www.binarystar.com Phone: +1 (954) 791-8575 Cell: +1 (954) 655-6581 Is there any news on the availability of the 6.1PE download? Thanks, Noah Hart --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.777 / Virus Database: 524 - Release Date: 10/14/2004 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD PE is available
What is the URL? I just checked and it was still clients 6.0b Noah Hart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lee Bacall Sent: Friday, October 15, 2004 8:55 AM To: [EMAIL PROTECTED] Subject: [U2] UD PE is available UniData personal editions are now available for both Linux and Windows. I was able to download the linux version this morning. Lee Bacall http://www.binarystar.com Phone: +1 (954) 791-8575 Cell: +1 (954) 655-6581 Is there any news on the availability of the 6.1PE download? Thanks, Noah Hart --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] -- Out of BUF_TYPE space [AD] - JScript for U2
I don't think that is it Allan, Rerunning the exact same process gives no error. Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Thursday, October 14, 2004 11:20 AM To: [EMAIL PROTECTED] Subject: RE: [U2] -- Out of BUF_TYPE space [AD] - JScript for U2 Perhaps if your COL-1 evaluated to 0 or a negative number, it may have done a simple math test (expecting a positive column) and come out with a number it knew was larger than the buffer space. (?) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Noah Hart Sent: Thursday, October 14, 2004 10:26 To: [EMAIL PROTECTED] Subject: [U2] -- Out of BUF_TYPE space [AD] - JScript for U2 We run a number of scheduled jobs each night. They have run successfully for several years. Last night we received this error in the log file. In /home/LIPMAN/CTLG/S.INPUT at line 64 out of BUF_TYPE space. The source for this line is a simple print statement CRT @(COL-1,ROW):VR:STR(_,LON):VO: Any idea what this error might mean? Noah --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Triggers
Adrian, You say you used to use triggers for updating audit files and referential integrity checks, so how are you implementing this functionality now (without triggers?) What is the performance difference between using triggers and the new way? REX --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Triggers
We put the functionality into the programs instead. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rex Gozar Sent: 15 October 2004 19:13 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Triggers Adrian, You say you used to use triggers for updating audit files and referential integrity checks, so how are you implementing this functionality now (without triggers?) What is the performance difference between using triggers and the new way? REX --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UD PE is available
Yes, the client is 6.0 Lee - Original Message - From: Noah Hart [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 15, 2004 1:35 PM Subject: RE: [U2] UD PE is available What is the URL? I just checked and it was still clients 6.0b Noah Hart -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lee Bacall Sent: Friday, October 15, 2004 8:55 AM To: [EMAIL PROTECTED] Subject: [U2] UD PE is available UniData personal editions are now available for both Linux and Windows. I was able to download the linux version this morning. Lee Bacall http://www.binarystar.com Phone: +1 (954) 791-8575 Cell: +1 (954) 655-6581 Is there any news on the availability of the 6.1PE download? Thanks, Noah Hart --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] running a subroutine
Wondering if there is a way to execute a subroutine from the colon prompt. Let's say I have a subroutine that is defined as having 2 input args like: SUBROUTINE subr.name(arg1,arg2). I would like to test it from the colon prompt without having to hard-code the values of arg1/arg2...something like: :RUN BP subr.name value.of.arg1 value.of.arg2 Is something like this possible? What I've tried so far hasn't worked. * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * * * * HP-UX 11.11 UniData 6.0.4Colleague R17 * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] running a subroutine
You could make a dict item that would call it and then just list it from tcl, but I'm pretty sure a subroutine cannot be called from tcl. Why not just: * ZZZ - TEST PROGRAM PRINT 'enter arg one : ':;INPUT ARG1 PRINT 'enter arg two : ':;INPUT ARG2 CALL SUB.WHATEVER.YOU.CALLED.IT(ARG1,ARG2) STOP compile ZZZ and you're there! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Shawn Waldie Sent: Friday, October 15, 2004 15:59 To: [EMAIL PROTECTED] Subject: [U2] [UD] running a subroutine Wondering if there is a way to execute a subroutine from the colon prompt. Let's say I have a subroutine that is defined as having 2 input args like: SUBROUTINE subr.name(arg1,arg2). I would like to test it from the colon prompt without having to hard-code the values of arg1/arg2...something like: :RUN BP subr.name value.of.arg1 value.of.arg2 Is something like this possible? What I've tried so far hasn't worked. * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * * * * HP-UX 11.11 UniData 6.0.4Colleague R17 * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] running a subroutine
Idea: Create a little stub program that does something like this: Program Sub.tester Gosub parse.sentence Subr.name = parsed.sentence2 Gosub get.arguments Arg.count = dcount(arguments, @am) Begin case case arg.count = 0 ; call subr.name case arg.count = 1 ; call subr.name(arguments1) case arg.count = 2 ; call subr.name(arguments1, arguments2) case arg.count = 3 ; call subr.name(arguments1, arguments2, arguments3) ... Etc ... End case Catalog sub.tester Then run like this: :sub.tester subr.name value.of.arg1 value.of.arg2 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Waldie Sent: Friday, October 15, 2004 3:59 PM To: [EMAIL PROTECTED] Subject: [U2] [UD] running a subroutine Wondering if there is a way to execute a subroutine from the colon prompt. Let's say I have a subroutine that is defined as having 2 input args like: SUBROUTINE subr.name(arg1,arg2). I would like to test it from the colon prompt without having to hard-code the values of arg1/arg2...something like: :RUN BP subr.name value.of.arg1 value.of.arg2 Is something like this possible? What I've tried so far hasn't worked. * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * * * * HP-UX 11.11 UniData 6.0.4Colleague R17 * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] running a subroutine
Goo'day, Other than: A small program to loop and prompt for var1 and var2 until, say, var1 = '', CALLing subr.name(var1,var2), DEBUG, or whatever to see what comes back from the subroutine and REPEAT No... At 08:59 16/10/04, you wrote: Wondering if there is a way to execute a subroutine from the colon prompt. Let's say I have a subroutine that is defined as having 2 input args like: SUBROUTINE subr.name(arg1,arg2). I would like to test it from the colon prompt without having to hard-code the values of arg1/arg2...something like: :RUN BP subr.name value.of.arg1 value.of.arg2 Is something like this possible? What I've tried so far hasn't worked. * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * * * * HP-UX 11.11 UniData 6.0.4Colleague R17 * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 264.11.0 - Release Date: 14/10/04 -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 264.11.0 - Release Date: 14/10/04 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 264.11.1 - Release Date: 15/10/04 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 264.11.1 - Release Date: 15/10/04 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] running a subroutine
I don't think there's a way to do that with a subroutine. What we regularly do here is use input statements and pass the answers in DATA statements. I know that's not the answer you want, so consider this: get(arg.,1)VAR if VAR = '' then input VAR end To pass more than one commandline variable, increment the 1 by 1 for each additional commandline variable passed. Your commandline for the above example would like like: RUN BP PRG VARDATA where VARDATA would fill the VARiable. Just a bit of for-what-it's-worth and hopefully it'll help. Karl Wondering if there is a way to execute a subroutine from the colon prompt. Let's say I have a subroutine that is defined as having 2 input args like: SUBROUTINE subr.name(arg1,arg2). I would like to test it from the colon prompt without having to hard-code the values of arg1/arg2...something like: :RUN BP subr.name value.of.arg1 value.of.arg2 Is something like this possible? What I've tried so far hasn't worked. * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * * * * HP-UX 11.11 UniData 6.0.4Colleague R17 * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] running a subroutine
Coming from D3 I have a subroutine that lets me input the routine and any arguments so I haven't actually tried it. I do know that you can run a subroutine directly (unlike D3). You could try updating the subroutine to check the variables (if not(assigned(arg1)) and do a tclread Colin Currently in Sunny LA - soon to head to Albuquerque!?! -Original Message- From: Shawn Waldie [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 3:59 PM To: [EMAIL PROTECTED] Subject: [U2] [UD] running a subroutine Wondering if there is a way to execute a subroutine from the colon prompt. Let's say I have a subroutine that is defined as having 2 input args like: SUBROUTINE subr.name(arg1,arg2). I would like to test it from the colon prompt without having to hard-code the values of arg1/arg2...something like: :RUN BP subr.name value.of.arg1 value.of.arg2 Is something like this possible? What I've tried so far hasn't worked. * Shawn WaldieSan Juan College * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] running a subroutine
Wouldn't be too hard to write a wrapper program that could call a subroutine with 1-n dynamic parameters, would it? Setup a big case statement that says if I get one parameter, call @subname(p1), if 2 parameters call @subname(p1,p2), etc. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Waldie Sent: Friday, October 15, 2004 4:59 PM To: [EMAIL PROTECTED] Subject: [U2] [UD] running a subroutine Wondering if there is a way to execute a subroutine from the colon prompt. Let's say I have a subroutine that is defined as having 2 input args like: SUBROUTINE subr.name(arg1,arg2). I would like to test it from the colon prompt without having to hard-code the values of arg1/arg2...something like: :RUN BP subr.name value.of.arg1 value.of.arg2 Is something like this possible? What I've tried so far hasn't worked. * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * * * * HP-UX 11.11 UniData 6.0.4Colleague R17 * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] running a subroutine
Why not write a short stub program to setup the args and then a CALL statement to execute your subroutine? That's what we do very often. You can either put in DEBUG statements in the stub program before/after the subroutine call. 8-) Andy Pflueger Ivy Hill Corporation Louisville, KY On Fri, 15 Oct 2004 16:59:04 -0600, Shawn Waldie [EMAIL PROTECTED] wrote: Wondering if there is a way to execute a subroutine from the colon prompt. Let's say I have a subroutine that is defined as having 2 input args like: SUBROUTINE subr.name(arg1,arg2). I would like to test it from the colon prompt without having to hard-code the values of arg1/arg2...something like: :RUN BP subr.name value.of.arg1 value.of.arg2 Is something like this possible? What I've tried so far hasn't worked. * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * * * * HP-UX 11.11 UniData 6.0.4Colleague R17 * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] running a subroutine
Gosub parse.sentence Subr.name = parsed.sentence2 Gosub get.arguments Arg.count = dcount(arguments, @am) Begin case case arg.count = 0 ; call subr.name case arg.count = 1 ; call subr.name(arguments1) case arg.count = 2 ; call subr.name(arguments1, arguments2) case arg.count = 3 ; call subr.name(arguments1, arguments2, arguments3) Wait wait! I will see your bet and raise you. How about OPEN BP ... parse sentence build program on-the-fly with correct number of arguments compile it and CHAIN to it ;) Do I win the stuffed dog? Will --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] running a subroutine
Shawn: There's a program on the wiki that allows you to execute BASIC code from a tcl line. http://www.pickwiki.com/cgi-bin/wiki.pl?BPTest This is an extremely useful program and will do exactly what you want, and a bunch of other things as well. It was originally written for UniData, then for UniVerse, then for D3. So an example would be: :BPTEST Value1 = Hello ; Value2 = There. ; CALL subr.name (Value1, Value2) ; END Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Waldie Sent: Friday, October 15, 2004 4:59 PM To: [EMAIL PROTECTED] Subject: [U2] [UD] running a subroutine Wondering if there is a way to execute a subroutine from the colon prompt. Let's say I have a subroutine that is defined as having 2 input args like: SUBROUTINE subr.name(arg1,arg2). I would like to test it from the colon prompt without having to hard-code the values of arg1/arg2...something like: :RUN BP subr.name value.of.arg1 value.of.arg2 Is something like this possible? What I've tried so far hasn't worked. * Shawn WaldieSan Juan College * * Programmer/Analyst 4601 College Blvd * * Phone: (505)566-3072 Farmington, NM 87402 * * email: [EMAIL PROTECTED] * * * * HP-UX 11.11 UniData 6.0.4Colleague R17 * --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/