http://blog.gmane.org/gmane.comp.db.u2.general hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://comments.gmane.org/gmane.comp.db.u2.general/69701 <pre>Drop a line to u2askus&lt; at &gt;rs.com or your support partner if you want in. Spots are limited. Dan McGrath Managing Director, U2 Servers Lab Rocket Software _______________________________________________ U2-Users mailing list U2-Users&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> Daniel McGrath 2013-05-20T13:40:07 http://comments.gmane.org/gmane.comp.db.u2.general/69685 <pre>Ok. I'm trying to find all the ID's in a file that contain the character ^160 I tried : SELECT filename WITH &lt; at &gt;ID LIKE "...^160..." But that didn't work. Aside from writing a program to scan the file, is there a way from TCL? George _______________________________________________ U2-Users mailing list U2-Users&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> George Gallen 2013-05-16T13:41:17 http://comments.gmane.org/gmane.comp.db.u2.general/69670 <pre>Does anyone have a way to calculate the disk space required to move data from a UniData Server to a Microsoft SQL server. _______________________________________________ U2-Users mailing list U2-Users&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> Kathleené M Hunter 2013-05-15T16:25:47 http://comments.gmane.org/gmane.comp.db.u2.general/69659 <pre>Hi Experts.. I have one issue here with fetching data from the file. EXECLINE = "SELECT FILE.NAME WITH &lt; at &gt;ID = \":KEYVALUE:"\" DISPLAY EXECLINE EXECUTE EXECLINE RTNLIST LIST1 EXECUTE 'SAVE-LIST SOME.LIST' PASSLIST LIST1 LIST.NAME = "GET-LIST SOME.LIST" sellist = '' EXECUTE LIST.NAME RTNLIST sellist CAPTURING junk Here Im running a loop for a set of "KEYVALUE"s and for each run the SSELECT statement is taking around 30 seconds. When I want to run 1000 loops, ideally the run time will be much. Is there any easier way to do this with less time consumption. Thanks &amp; Regards, Sathya V. _______________________________________________ U2-Users mailing list U2-Users&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> Sathya 2013-05-15T09:44:33 http://comments.gmane.org/gmane.comp.db.u2.general/69594 <pre>Hi all,.. Im getting the below error while running my code,..Can someone please help me with this issue? Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX ,MQS, SOAP or database variable. Code snippet : OSOPEN TEMP.FILE1 TO temp_file1 ELSE STOP "CAN Not find file" READ DATA FROM temp_file1 ELSE STOP "Can not find temp filename" Where TEMP.FILE1 is something like "Filepath/filename.txt". Its a text file in the server and I want to read the contents and do some comparison. TIA, Sathya V. _______________________________________________ U2-Users mailing list U2-Users&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> Sathya 2013-05-07T06:37:02 http://comments.gmane.org/gmane.comp.db.u2.general/69547 <pre>OK. I'm trying to use a Raspberry pi to push a button, but only want to use one GPIO port. Basically, I'm trying to get the pi to turn a device on or off - and can't easily get to Where the button on the device's board is at to have the pi trigger with a relay, So I plan to mount the device, and have something just push the button directly. Do they make a device that when energized, will push a rod out then back? Right now, my only option (maybe not only), would be to create a Scotch Yoke http://en.wikipedia.org/wiki/Scotch_yoke But for space contraints, and ease, I'd rather put in something that would do That as it's primary function. George _______________________________________________ U2-Users mailing list U2-Users&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> George Gallen 2013-05-03T15:24:35 http://comments.gmane.org/gmane.comp.db.u2.general/69540 <pre>I have a customer who just got a Canon ir-4025 copier/printer/everythingelse. Unable to find a linux driver I downloaded a product called BrightQPro which allowed me to install the printer on the redhat system. I can print using lp or lpr, I can print web pages and from Office, but UniVerse cannot see the printer: "Requested printer does not exist". Has anybody used these products, I have done everything I could think of about 7 times. Thanks -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/canon-ir4025-printer-on-redhat-tp40657.html Sent from the U2 - Users mailing list archive at Nabble.com. _______________________________________________ U2-Users mailing list U2-Users&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> Dale Kelley 2013-05-02T22:00:55 http://comments.gmane.org/gmane.comp.db.u2.general/69528 <pre>Does anyone have documentation on Batch Strings and/or the B/ADD function used on older systems? _______________________________________________ U2-Users mailing list U2-Users&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> Peter S. Goldberger 2013-05-01T16:08:05 http://comments.gmane.org/gmane.comp.db.u2.general/69526 <pre>I have come across a few people recently who use this site to look at DB popularity - should U2 (and other MV systems be on there) http://db-engines.com/en/ranking/multivalue+dbms _______________________________________________ U2-Users mailing list U2-Users&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> Symeon Breen 2013-05-01T10:49:32 http://comments.gmane.org/gmane.comp.db.u2.general/69525 <pre>I am trying to get Rocket to improve the behaviour of *HS.UPDFINFO to support active select lists so that only the files I want built into the ".hs_fileinfo" cache item (rather than have EVERY SINGLE F/Q-type item from the VOC included). Support inform me that I seem to be the only person interested in such a change, so I thought I would at least ask the question of the U2 community. Would anyone else find it useful to have the *HS.UPDFINFO command enhanced to support select lists, or have a new command created that deals with select lists? Thanks Gregor ________________________________ This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. _______________________________________________ U2-Users mailing list U2-Users&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> Gregor Scott 2013-05-01T05:28:34 http://comments.gmane.org/gmane.comp.db.u2.general/69508 <pre>Hi all,.. I have a requirement here. Need guidance in doing that. Any help will be useful. TIA. I have a flat file with tab delimited records and the file looks like below: abcd 1234 cdef 3478 ghae 6284 ... I have to fetch the data 'abcd' and 'cdef' from this flat file and fetch some corresponding attributes from a file which has 'abcd' and 'cdef' as the key values. Please let me know if this could be done. If yes any kinda basic suggestions in doing that will be helpful. Thanks again, Sathya V. _______________________________________________ U2-Users mailing list U2-Users&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> Sathya 2013-04-30T15:21:28 http://comments.gmane.org/gmane.comp.db.u2.general/69505 <pre>I am curious to know if *Aaron Titus* Senior Software Engineer F.W. Davison &amp; Company, Inc. 508-747-7261 x245 atitus&lt; at &gt;fwdco.com _______________________________________________ U2-Users mailing list U2-Users&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> Aaron Titus 2013-04-30T14:12:02 http://comments.gmane.org/gmane.comp.db.u2.general/69482 <pre>You might be able to do something creative using the remote voc like someone said earlier. Have a look at the following paragraph. It's in the UV documentation in the admin.pdf. Security Subroutines VOC entries that point to remote items provide a mechanism for controlling access to certain commands. You can specify a user-supplied subroutine in field 4 of remote-type VOC entries. Such a subroutine sets a flag that permits or restricts access to the remote item. The UniVerse command processor checks the flag returned by the subroutine accessing the remote item. A security subroutine must be set up for seven arguments. SUBROUTINE security ( remote, sentence, level, port, acct,log, flag) security is the name of the subroutine. The first six arguments are passed to the subroutine by the command processor, and the last argument is a return argument. These arguments are briefly described in the following table. &lt;&lt;For PCI compliance, we are tasked to log/capture all TCL entries and responses. I am familiar with COMO, which is one possible solution. 1) What other TCL logging methods are available in UniVerse besides COMO? 2) What AIX Unix tools are available to capture keyboard input and responses at TCL?&gt;&gt; Rudy Cooper Lead Applications Developer Sage Publications Inc. 2455 Teller Road Thousand Oaks, Ca. 91320 USA T:805.410.7724 www.sagepub.com Los Angeles | London | New Delhi Singapore | Washington DC The natural home for authors, editors &amp; societies Please consider the environment before printing this email _______________________________________________ U2-Users mailing list U2-Users&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> Cooper, Rudy 2013-04-26T21:18:01 http://comments.gmane.org/gmane.comp.db.u2.general/69460 <pre>Hi, I was wondering what tools you use to export data to an SQL data warehouse from UniVerse. This export could occur on multiple flavors of Unix. What we would need to do is extract the UV data and perform some data "translations" before importing the data into the SQL table. I know at one point DataStage was a powerful but expensive tool that would accomplish this task. All suggestions are greatly appreciated! Tom Whitmore RATEX Business Solutions _______________________________________________ U2-Users mailing list U2-Users&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> Tom Whitmore 2013-04-26T17:50:14 http://comments.gmane.org/gmane.comp.db.u2.general/69454 <pre>Notice: This e-mail is intended solely for use of the individual or entity to which it is addressed and may contain information that is proprietary, privileged, company confidential and/or exempt from disclosure under applicable law. If the reader is not the intended recipient or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If this communication has been transmitted from a U.S. location it may also contain data subject to the International Traffic in Arms Regulations or U.S. Export Administration Regulations and cannot be disseminated, distributed or copied to foreign nationals, residing in the U.S. or abroad, without the prior approval of the U.S. Department of State or appropriate export licensing authority. If you have received this communication in error, please notify the sender by reply e-mail or collect telephone call and delete or destroy all copies of this email message, any physical copies made of this e-mail message and/or any file attachment(s)._______________________________________________ U2-Users mailing list U2-Users&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> Ferrara, Mike 2013-04-26T14:18:11 http://comments.gmane.org/gmane.comp.db.u2.general/69444 <pre>Good afternoon, I was wondering if anyone has seen "pc = FB8" WRITE FAILURE errors on universe. I am running a module which updates the account numbers in G/L file. The program does a readseq, removes, control characters, and attempts to write 10 digit G/L numbers into G/L file. It runs properly in development and test accounts, however in production platform it fails on different account numbers and give "write failure" error msg. I have added display command to display the account numbers as program runs..and the final run crashed with the WRITE FAILURE pc FB8 error. Any idea/comments will be appreciated! Ara Baghdasraian _______________________________________________ U2-Users mailing list U2-Users&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> Aramaies Baghdasraian 2013-04-25T21:55:45 http://comments.gmane.org/gmane.comp.db.u2.general/69432 <pre>Before I go and resize a 144GB file has anyone had any experiences with the INPLACE option of RESIZE in UniVerse? Good, bad, ugly??? Thanks. Perry Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.com&lt;http://www.zirmed.com/&gt; CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. _______________________________________________ U2-Users mailing list U2-Users&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> Perry Taylor 2013-04-25T20:09:47 http://comments.gmane.org/gmane.comp.db.u2.general/69420 <pre>For PCI compliance, we are tasked to log/capture all TCL entries and responses. I am familiar with COMO, which is one possible solution. 1) What other TCL logging methods are available in UniVerse besides COMO? 2) What AIX Unix tools are available to capture keyboard input and responses at TCL? -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/TCL-input-and-response-logging-such-as-COMO-tp40528.html Sent from the U2 - Users mailing list archive at Nabble.com. _______________________________________________ U2-Users mailing list U2-Users&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> Scott Zachary 2013-04-24T20:34:47 http://comments.gmane.org/gmane.comp.db.u2.general/69404 <pre>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&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> Bill Haskett 2013-04-23T21:12:17 http://comments.gmane.org/gmane.comp.db.u2.general/69402 <pre>Hello, I have a unidata database running on an IBM AIX... I want to do a live replication, but to a CentOS server. Is that possible? I am running version 7.2... does it require me to purchase another product? Or is this feature built in to unidata similarly to to something like mysql. Can I replicate to a the PE? Thanks, _______________________________________________ U2-Users mailing list U2-Users&lt; at &gt;listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users </pre> Kevin Le 2013-04-23T17:28:35 http://comments.gmane.org/gmane.comp.db.u2.general/69399 <pre>I'm attempting some experiments with RESIZE CONCURRENT on Unidata 7.3.3 (RedHat) but failing miserably. I didn't think there was any configuration I needed to enable before using CONCURRENT, perhaps I'm misunderstanding the error message: :RESIZE H08.FACULTY.WL.SNAP 3593,8 CONCURRENT RESTORE H08.FACULTY.WL.SNAP is a synonym, real name is H08.DATA/DATA_F/H08.FACULTY.WL.SNAP. Resize Concurrent Continue/Restore failed because the RESIZE_CONCURRENT bit was not set on the file. I've read all the manuals and cannot find anything referencing the "RESIZE_CONCURRENT bit". Any insight appreciated... </pre> Jeffrey Butera 2013-04-23T01:49:15 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.db.u2.general