RE: [U2] UniObject SubKeys
The subkey only works if you are connecting to a Universe server that is running device licensing rather than server licensing. The subkey needs to be the same for each ten sessions otherwise each one will be treated as an individual session. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of UmFooFoo Murphy Sent: 07 December 2004 21:38 To: [EMAIL PROTECTED] Subject: [U2] UniObject SubKeys Hello All, I have an application that needs to be able to connect multiple times to a Universe Session. When I run this application on my local PC I am unable to connect to my local Universe while the application is running. Likewise, I am unable to run the application while connected to a local Universe session. I was told to use SubKeys to solve this problem and even though I read and obeyed the blurb about SubKeys in the UniObjects documentation, it still does not work. I have a TheSubKey as Long variable that I increment each time I connect to UniObjects, like this: TheSubKey = TheSubKey + 1: ObjSession.SubKey = Str(TheSubKey) ObjSession.Connect I used the Str() because results from a google search suggested that the subkey needs to be a string value. I have also tried it without using the Str() like this: TheSubKey = TheSubKey + 1: ObjSession.SubKey = TheSubKey ObjSession.Connect Can anyone point me in the right direction please? thanks --- 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] [ot] hpux11/uv10 validate user login
Gerry, RedBack uses a request/response model. Each RedBack request(e.g. setting or getting a property or actioning a method on a RedBack object) is considered to be a single atomic action and is picked up by the first available RedBack responder. There is no concept of a user or session in the way of a UNIX login user or session, and subsequent requests from the same 'user' may be handled by different responders. All of which provides for scalability through connection pooling, but also requires that any authentication has to be handled at the application level. Brian --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: U2 Users Digest V1 #403
I will be out of the office Wednesday 12/8 thru Friday 12/10. During this time I will have limited access to my email. Thanks, Russ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Pitch and Point
If they're talking about a fixed-pitch font (like Courier), when they say ten point they almost certainly mean ten pitch i.e. 10 c.p.i. - your bog-standard IBM golfball typewriter font (if you're old enough to remember the marvellous IBM golfball, of course!) Actually, they probably don't realise they are talking about fixed-pitch, and they may well really mean ten point. As pitch gets bigger, point gets smaller and vice versa. The more characters (increasing pitch) you cram into an inch, the smaller (decreasing point) those characters have to be. And it just works out that a 10-pitch and a 12-point font are roughly interchangeable, as are a 12-pitch and 10-point font. Cheers, Wol --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] UD file indexing
Hi all, Here's the scenario. Two machines both running Unidata/NT version 5.2, on one machine, running CREATE.INDEX filename dictionaryitem goes off and creates the index as per the book, after which BUILD.INDEX can be run. On the second machine, trying to run CREATE.INDEX filename dictionaryitem fails, giving me syntax error on line 202 of SB.EXECUTE. I've RTFM'd and can't find a reason why one is succeeding and the other falling over. Any hints? Simon [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD file indexing
Simon, Just to dismiss the obvious, does the dictionaryitem exist on the second machine and can it be recompiled there locally? (ie. Does not contain a reference to another dictionary that might be missing?) Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simon Carter Sent: 08 December 2004 11:28 To: [EMAIL PROTECTED] Subject: [U2] UD file indexing Hi all, Here's the scenario. Two machines both running Unidata/NT version 5.2, on one machine, running CREATE.INDEX filename dictionaryitem goes off and creates the index as per the book, after which BUILD.INDEX can be run. On the second machine, trying to run CREATE.INDEX filename dictionaryitem fails, giving me syntax error on line 202 of SB.EXECUTE. I've RTFM'd and can't find a reason why one is succeeding and the other falling over. Any hints? Simon [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- 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] help w/ print of barcode
I'm trying to print barcode ( code ucc128c ) using an okidata 395 printer from within a UniBasic program. I have tried sending the commands as stated in the okidata user manual. And I have searched the okidata site and found and tried sample code to print the barcode. Neither of these attempts has been successful. We run Unidata on AIX and the printer is connected via a serial line. The print queue was setup as a generic ascii printer without filtering. Non-barcode data has been printed to the printer so I know that the basic setup of the printer is correct. Please share any relevant experience. Thanks. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] help w/ print of barcode
you may want to check the printer's emulation. the escape sequences you need to send are different between ibm proprinter epson Rich Koser, Mike wrote: I'm trying to print barcode ( code ucc128c ) using an okidata 395 printer from within a UniBasic program. I have tried sending the commands as stated in the okidata user manual. And I have searched the okidata site and found and tried sample code to print the barcode. Neither of these attempts has been successful. We run Unidata on AIX and the printer is connected via a serial line. The print queue was setup as a generic ascii printer without filtering. Non-barcode data has been printed to the printer so I know that the basic setup of the printer is correct. Please share any relevant experience. Thanks. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -- Richard A. Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 [EMAIL PROTECTED] www.lakeside-systems.com --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD file indexing
Brian, Thanks for the reply. Looks like I was a bit too hasty: the dict item was called GROUP hence CREATE.INDEX fname GROUP was the command, however I've now found that GROUP is an entry in the MD with reference to English type commands. Bah, humbug. Clearly a gotcha relating back to the origin of the file and dictionary item (ie, pre-Unidata). Thanks again. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: 08 December 2004 12:24 To: [EMAIL PROTECTED] Subject: RE: [U2] UD file indexing Simon, Just to dismiss the obvious, does the dictionaryitem exist on the second machine and can it be recompiled there locally? (ie. Does not contain a reference to another dictionary that might be missing?) Brian --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Kimberly Bussie Levin is out of the office.
I will be out of the office starting 12/08/2004 and will not return until 12/09/2004. I will respond to your message when I return. This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObject SubKeys
From: [EMAIL PROTECTED] I was told to use SubKeys to solve this problem and even though I read and obeyed the blurb about SubKeys in the UniObjects documentation, it still does not work. This is Java code, but it might give you some ideas. The same device subkey is used for ten connections, then the subkey changes for ten more connections, and so on. http://www.pickwiki.com/cgi-bin/wiki.pl?UniSessionFactory -- Wendy Smoak Application Systems Analyst, Sr. ASU IA Information Resources Management --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UD] How to access a particular ID in a select list
Take off the FIRST.SELECTED.ID from the DELETE line. Add a DATA Y before the REPEAT and it should do what you want. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: 08 December 2004 14:54 To: [EMAIL PROTECTED] Subject: [U2][UD] How to access a particular ID in a select list Hi, Is there a way to access a particular ID in a select list? I want to write a para to do the following: Select a file with certain Ids and delete these selected records. I was thinking of writing something like the following (to delete all the records whose ID is greater than 5, say), but don't know what to replace FIRST.SELECTED.ID with in the following: LOOP SELECT XCF.SAV.TEST WITH @ID 5 IF @SYSTEM.RETURN.CODE = 0 THEN GO DONE DELETE XCF.SAV.TEST FIRST.SELECTED.ID REPEAT DONE: Is there a system variable that stores all the IDs in the select list? Thanks Savita. --- 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] How to access a particular ID in a select list
Thank you so much guys. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lance Jahnke Sent: Wednesday, December 08, 2004 9:52 AM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] How to access a particular ID in a select list SELECT XCF.SAV.TEST WITH @ID 5 IF @SYSTEM.RETURN.CODE LE 0 THEN GO DONE DELETE XCF.SAV.TEST DONE: You don't need a loop. The select statement will contain all the items selected and the delete will delete them. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Wednesday, December 08, 2004 8:54 AM To: [EMAIL PROTECTED] Subject: [U2][UD] How to access a particular ID in a select list Hi, Is there a way to access a particular ID in a select list? I want to write a para to do the following: Select a file with certain Ids and delete these selected records. I was thinking of writing something like the following (to delete all the records whose ID is greater than 5, say), but don't know what to replace FIRST.SELECTED.ID with in the following: LOOP SELECT XCF.SAV.TEST WITH @ID 5 IF @SYSTEM.RETURN.CODE = 0 THEN GO DONE DELETE XCF.SAV.TEST FIRST.SELECTED.ID REPEAT DONE: Is there a system variable that stores all the IDs in the select list? Thanks Savita. --- 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][UD] How to access a particular ID in a select list
Reading this Im confused. Are you looking to 'tweak' something already saved in SAVEDLISTS or are you trying to SELECT records in a file, delete them and then repeat the operation ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Wednesday, December 08, 2004 9:54 AM To: [EMAIL PROTECTED] Subject:[U2][UD] How to access a particular ID in a select list Hi, Is there a way to access a particular ID in a select list? I want to write a para to do the following: Select a file with certain Ids and delete these selected records. I was thinking of writing something like the following (to delete all the records whose ID is greater than 5, say), but don't know what to replace FIRST.SELECTED.ID with in the following: LOOP SELECT XCF.SAV.TEST WITH @ID 5 IF @SYSTEM.RETURN.CODE = 0 THEN GO DONE DELETE XCF.SAV.TEST FIRST.SELECTED.ID REPEAT DONE: I learned not to rely on @SYSTEM.RETURN.CODE for this. I remember getting burned by this. It had something to do with the record grouping - I really forget. I now write programs to do this kind of thing. I find it much easier. Is there a system variable that stores all the IDs in the select list? You could simply read the SAVEDLISTS file in a program and modify it that way. I don't think there is a system variable. The only thing that comes close is the default SAVEDLIST. Thanks Savita. --- 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] How to access a particular ID in a select list
Hey Anthony, I am trying to do the later. Thanks for asking, but someone on the list already clarified this for me. Thanks anyway. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Dzikiewicz Sent: Wednesday, December 08, 2004 10:06 AM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] How to access a particular ID in a select list Reading this Im confused. Are you looking to 'tweak' something already saved in SAVEDLISTS or are you trying to SELECT records in a file, delete them and then repeat the operation ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Wednesday, December 08, 2004 9:54 AM To: [EMAIL PROTECTED] Subject:[U2][UD] How to access a particular ID in a select list Hi, Is there a way to access a particular ID in a select list? I want to write a para to do the following: Select a file with certain Ids and delete these selected records. I was thinking of writing something like the following (to delete all the records whose ID is greater than 5, say), but don't know what to replace FIRST.SELECTED.ID with in the following: LOOP SELECT XCF.SAV.TEST WITH @ID 5 IF @SYSTEM.RETURN.CODE = 0 THEN GO DONE DELETE XCF.SAV.TEST FIRST.SELECTED.ID REPEAT DONE: I learned not to rely on @SYSTEM.RETURN.CODE for this. I remember getting burned by this. It had something to do with the record grouping - I really forget. I now write programs to do this kind of thing. I find it much easier. Is there a system variable that stores all the IDs in the select list? You could simply read the SAVEDLISTS file in a program and modify it that way. I don't think there is a system variable. The only thing that comes close is the default SAVEDLIST. Thanks Savita. --- 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] uvodbc truncating field
SQL statements are limited by the SQL definitions held at the end of the dictionary item. These fields contain both a type and a length. SQL standard requires that these be strongly applied so data that is acceptable to U2 will give a data type error if the wrong SQL type is used and the field will be truncated to the maximum length defined. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rod Hills Sent: Friday, December 03, 2004 11:47 AM To: [EMAIL PROTECTED] Subject: [U2] uvodbc truncating field I've wrote a small program to return a record set of part numbers and part descriptions. Then I wrote a data query under MS Excel and ran the SQL process as follows- { CALL TALKTOME (19) } I get 2 columns returned, the first being the part numbers, but for some reason the part descriptions are being chopped at 8 characters. Here is the subroutine- 0001 SUBROUTINE TALKTOME(CPN) 0002 OPEN ITMMST TO IM ELSE GOTO 99 0003 EXECUTE SELECT ITMMST = ':CPN:]' 0004 MOREDATA=1 0005 DARRAY= 0006 LOOP 0007 READNEXT ITMKEY ELSE MOREDATA=0 0008 WHILE MOREDATA 0009 READ IM.REC FROM IM,ITMKEY ELSE GOTO 99 0010 PNBR=IM.REC1 0011 DESC=IM.REC2 0012 IF DARRAY THEN DARRAY := @FM 0013 DARRAY := PNBR:@TM:DESC 0014 REPEAT 0015 SELECTN DARRAY TO 9 0016 ST=SQLExecDirect(@HSTMT, SELECT F1,F2 FROM @TMP SLIST 9 ORDER BY 1) 0017 RETURN 0018 99: 0019 PRINT ERROR IN OPEN OR READ FOR ITMMST 0020 RETURN 0021 END I am using the technique described in the UCI documentation for Universe 10.0.16. It is discussed in chapter 6. Anyone have any ideas what would cause this? Thanks in advance -- Rod Hills --- 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] [OT] XSL for associated multivalues
Instead of... numberxsl:value-of select=/COL[2]/DATA//number you need something like... xsl:variable name=row select=position()/ !-- just needed once per for-each DATA -- number xsl:value-of select=/COL[2]/DATA[position() =$row]/ /number Simon Karjala Koponen [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello, I am trying to write an XML transform (XSLT) that will take something of the form COL DATAa/DATA DATAb/DATA /COL COL DATA8/DATA DATA3/DATA /COL and transform it to another XML segment like element lettera/letter number8/number /element element letterb/letter number3/number /element My XSL file has code like xsl:for-each select=COL[1]/DATA element letterxsl:value-of select=.//letter !-- works fine -- numberxsl:value-of select=/COL[2]/DATA//number !-- this gets no data -- /element /xsl:for-each I've tried various xpath expressions with no better luck (as opposed to knowledge). Any ideas? On what to do or what to search for? As helpful as many of the XML/XSL sites are, I don't even know what to search for in this case. Thanks, Karjala --- 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] sql date/time conversion
May not be the most elegant solution to be suggested, but perhaps use an I-type to oconv your date and time fields and present them as a single -MM-DD HH:MM:SS string? OT - sure will be nice when sql server 2005 FINALLY supports separate date and time data types. Took 'em long enough to catch up to us grin. Jim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of gerry-u2ug Sent: Wednesday, December 08, 2004 8:01 AM To: U2-Users (E-mail) Subject:[U2] sql date/time conversion pulling data from universe 10 into sql server 2000 using uniOleDb and DTS , does anyone know of some way to take seperate DATE and TIME fields in universe and have SQL Server see them a single DATETIME field ? gerry --- 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] UV upgrade question
Hello, all! We are currently running universe 10.0.8 on Solaris. I am contemplating upgrading to uv 10.1.6. Right now one of the main attractions is the SSL-aware telnet support, but I'd also like to play with the WebSphere MQ stuff. Is 10.1.6 a fairly stable release? Is anyone using the SSL telnet feature? Any comments on the above or WebSphere would be appreciated. Mark Hennessey State of Connecticut DSS/MIS Child Support Systems Voice: 860-424-5261 Fax: 860-424-4956 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UD] How to access a particular ID in a select list
Are you after something of this nature: 0001: * PROGRAM : PT.TEST 0002: ** 0003: * 0004: STMT=\SELECT INV-TABLE\ 0005: EXECUTE STMT 0006: SELECT TO LIST1 0007: EOF=0 0008: LOOP 0009: READNEXT ID FROM LIST1 ELSE EOF=1 0010: UNTIL EOF DO 0011: PRINT ID 0012: REPEAT 0013: PRINT ' End of List ' 0014:END Have a Great Day! Paul Trebbien Kore Technologies, Senior Support Tech. Solutions that work. People who care. V 858.678.0030 F 858.300.2600 W www.koretech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Chauhan, Savita Sent: Wednesday, December 08, 2004 6:54 AM To: [EMAIL PROTECTED] Subject: [U2][UD] How to access a particular ID in a select list Hi, Is there a way to access a particular ID in a select list? I want to write a para to do the following: Select a file with certain Ids and delete these selected records. I was thinking of writing something like the following (to delete all the records whose ID is greater than 5, say), but don't know what to replace FIRST.SELECTED.ID with in the following: LOOP SELECT XCF.SAV.TEST WITH @ID 5 IF @SYSTEM.RETURN.CODE = 0 THEN GO DONE DELETE XCF.SAV.TEST FIRST.SELECTED.ID REPEAT DONE: Is there a system variable that stores all the IDs in the select list? Thanks Savita. --- 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] How to access a particular ID in a select list
Thanks Paul. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Trebbien Sent: Wednesday, December 08, 2004 1:05 PM To: '[EMAIL PROTECTED]' Subject: RE: [U2][UD] How to access a particular ID in a select list Are you after something of this nature: 0001: * PROGRAM : PT.TEST 0002: ** 0003: * 0004: STMT=\SELECT INV-TABLE\ 0005: EXECUTE STMT 0006: SELECT TO LIST1 0007: EOF=0 0008: LOOP 0009: READNEXT ID FROM LIST1 ELSE EOF=1 0010: UNTIL EOF DO 0011: PRINT ID 0012: REPEAT 0013: PRINT ' End of List ' 0014:END Have a Great Day! Paul Trebbien Kore Technologies, Senior Support Tech. Solutions that work. People who care. V 858.678.0030 F 858.300.2600 W www.koretech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Chauhan, Savita Sent: Wednesday, December 08, 2004 6:54 AM To: [EMAIL PROTECTED] Subject: [U2][UD] How to access a particular ID in a select list Hi, Is there a way to access a particular ID in a select list? I want to write a para to do the following: Select a file with certain Ids and delete these selected records. I was thinking of writing something like the following (to delete all the records whose ID is greater than 5, say), but don't know what to replace FIRST.SELECTED.ID with in the following: LOOP SELECT XCF.SAV.TEST WITH @ID 5 IF @SYSTEM.RETURN.CODE = 0 THEN GO DONE DELETE XCF.SAV.TEST FIRST.SELECTED.ID REPEAT DONE: Is there a system variable that stores all the IDs in the select list? Thanks Savita. --- 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] Another Problem with RPC calls to UniVerse
This is a new one for me; we have a NAT (network address translator) in the mix now, trying to isolate a lab for dev qa. So a uvrpc connection from inside that environment to a file on a server outside that environment will have the ip address in the packet header changed. I'm guessing that there's also an ip address getting sent in the packet data, which will not match by the time it arrives at the remote system. uvrpcservices permissions are promiscuous, an asterix for allowed hosts (and a bright red lipstick color on the file name...). So... questions include: would this hose uvnet (the error is unable to open uvrpcservices)? Is there a way to configure uvrpc to accomodate devices like this NAT? And, just out of curiosity, what is the mechanism that uvrpcservices uses to establish the connection? Does it look at the packet header? Is there in fact a return address in the packet data? Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them? - H.H. the Dalai Lama When buying selling are controlled by legislation, the first thing to be bought sold are the legislators - P.J. O'Rourke Dan Fitzgerald From: Bryan Shumsky [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [U2] Problem with RPC calls to UniVerse on Windows 2003? Date: Wed, 8 Dec 2004 08:05:20 -0700 Hi, David. I've been testing your suggestion for the past couple of days. Selecting allow this service to interact with the desktop does indeed somehow keep the service alive (and I suppose I can live with the DOS window that pops up whenever a connection is made...) Thanks for the information! Regards, -- Bryan Shumsky Director of Engineering Via Systems, Inc. - Original Message - From: David Jordan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 06, 2004 6:48 PM Subject: RE: [U2] Problem with RPC calls to UniVerse on Windows 2003? This seems to be common problem on windows 2003. One of the resolutions is to go to services menu under administration tools. Select the properties for universe RPC and under the login tab select to allow this service to interact with the desktop. Under windows 2003 there are a number of security features and I suspect that part of this is to close down unrecognised sockets that have not been active for a while. I believe there is somewhere where you can keep this active, but have not had time to explore. Hope this helps Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bryan Shumsky Sent: Tuesday, 7 December 2004 4:17 AM To: [EMAIL PROTECTED] Subject: [U2] Problem with RPC calls to UniVerse on Windows 2003? Hi, everyone. I've just been working on a project using the UniObjects for Java stuff, and it all works fine...for a little while. That is, I can make connections and do 'thinkgs' on the UniVerse system, connecting and disconnecting with no problem. But after a while of inactivity (exact duration unknown), I find I can no longer make the connection any more - the call returns with The RPC failed. Rebooting the Windows 2003 system makes things work again. Note that I'm not trying to reuse the connection, or the session, or anything; I've actually quit out of my program, and am trying to go back into it again. At first, I suspected that there was something awry in my Java code, but I've discovered that I can create the same problem just by using the UniVerse Admin tool; again, I connect, and do stuff with no problem, but after disconnecting and waiting a while, attempts to reconnect generate the dialog box Unable to open connection - Error 81002 - connection is broken. As the Admin tool is on the same box as UniVerse, this eliminates any questions (I think) of firewall issues, networking problems, etc. While this makes me feel better about my UOJ code :-) it means there's something else going on here. I don't know if it's related to being on Windows 2003 Server, or the fact that this is the Personal Edition of UniVerse (just downloaded from the IBM site; version is 10.0.10), or...? If it's just something unique to the PE, that's fine; I'm using this for testing and development, and if it works correctly in the real world, then that's OK, but it'd be nice to know what's going on. Thanks! -- Bryan Shumsky Director of Engineering Via Systems, Inc. --- 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-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniObjects for Java Unnamed Common Corruption
I have recently encountered a very strange UniObjects bug. I have an application that includes a file containing unnamed commons. The application calls a subroutine that also includes that same unnamed common. I also have a command that includes the unnamed comman and calls the same subroutine that includes the unnamed common. When I run the command and subroutine sequentially in a loop via UniObjects, the UniSession dies. If I only run the subroutine or the command in a loop, it works like a champ. Adding more unnamed commons to the include file only causes the problem to happen less often. Please look at my sample application to see if you have any insight into why this fails consistently. Attached are the sample applications. Thanks, Sean Ferguson [demime 1.01d removed an attachment of type application/octet-stream which had a name of asjava.jar] [demime 1.01d removed an attachment of type application/octet-stream which had a name of asjava_p.jar] COMMON POS INCLUDE RMS.BP INPUT.COMMON.POS CALL TEST.SHARED.SUB SUBROUTINE TEST.COMMON.SUB INCLUDE RMS.BP INPUT.COMMON.POS CALL TEST.SHARED.SUB RETURN SUBROUTINE TEST.SHARED.SUB INCLUDE RMS.BP INPUT.COMMON.POS POS = 1 RETURN [demime 1.01d removed an attachment of type application/octet-stream which had a name of TestCommons.jar] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: Unclassified RE: [U2] Sites using UniVerse
Hi Mike, just wanted to thank you for your information. I offered it upwards and I think it helped. Craig PS: Thanks to Martin too, but when is the opensource AIX port coming out :) --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV SQL NEXT.AVAILABLE from basic
Anyone know if there's a user exit or existing function to access/increment the NEXT.AVAILABLE SQL table accumulator from basic? Regards, Stuart Boydell ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Scrolling in the HELP list
Robert, you sent me in the right direction. The issue was the need to get the numeric 10-key pad working, by default, in Dynamic Connect so a couple of years ago they modified the vt100 terminal definition and recompiled it. The modification stopped the ability to use the Terminal Emulation Extensions in the Setup screen of Dynamic Connect. My work around is I switched to the vt220, which was still the original, and added the vtnumoff extension in the Setup/Terminal screen then saved my setup. I then closed the session, reopened it and I get cursor control in the HELP listing and the numbers 1, 2, 3, ... at TCL from the 10-key pad. Thanks for your pointer! BobW -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Robert Paterson Sent: Monday, December 06, 2004 9:16 AM To: '[EMAIL PROTECTED]' Subject: RE: [U2][UV] Scrolling in the HELP list Have you checked the decompiled versions of the terminal drivers? untic the vt100 definition on both servers and compare the two would be my best suggestion... Robert Paterson Technology Support Manager www.epicor.com Tel.: +44 (1344) 468231 Cell: +44 (7799) 348513 Fax: +44 (1344) 468050 E-Mail: [EMAIL PROTECTED] 1 The Arena, Downshire Way, Bracknell, Berks, UK, RG12 1PU 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. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: 06 December 2004 16:18 To: [EMAIL PROTECTED] Subject: RE: [U2][UV] Scrolling in the HELP list I've discovered that this problem seems to be server dependant. If I log into our main server, the problem is there. I can not use the cursor keys to move up and down the list. If I then go into SETUP/Communications/Windows Sockets/Setup and change the Host to an installation of Universe PE on another computer in our network, it then works. Can anyone venture a guess of what I should look at for differences between the two installations of Universe? Any guesses would be greatly appreciated. Bob Woodward Programmer/Analyst Harbor Wholesale Grocery -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Thursday, December 02, 2004 10:30 AM To: [EMAIL PROTECTED] Subject: [U2][UV] Scrolling in the HELP list Hopefully this is a simple question that I just haven't hit the right combination on. I'm trying to figure out how to make the cursor keys scroll up and down when I'm in the HELP listing. I know I had it working at one time but now I can't figure out what to do to get that ability back. Windows 2000 Server UV 10.1 Dynamic Connect v5.1.2 Term type is VT100 TIA for any help. Bob Woodward Programmer/Analyst Harbor Wholesale Grocery --- 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-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniObjects for Java Unnamed Common Corruption
/* * Created on Dec 6, 2004 */ package com.docmagic.rd; import asjava.uniobjects.*; /** * @author jay */ public class TestCommons { UniSession session = null; static String host, username, password, accountPath; public static void main(String[] args) { if(args.length 4) { System.out.println(Usage: host username password accountPath iterations); return; } try { host = args[0]; username = args[1]; password = args[2]; accountPath = args[3]; int iterations = 100; if(args.length == 5) { iterations = Integer.parseInt(args[4]); } TestCommons test = new TestCommons(); for (int index = 0; index iterations; index++) { System.out.println(Iteration : + index); test.run(); } System.out.println(Complete); } catch (Throwable t) { t.printStackTrace(); } } public TestCommons() throws UniSessionException { this.session = getSession(); } public UniSession getSession() throws UniSessionException { UniSession session = new UniSession(); session.setHostName(host); session.setUserName(username); session.setPassword(password); session.setAccountPath(accountPath); session.connect(); return session; } public void run() throws Throwable { runCMD(); runSub(); } private void runSub() throws UniSessionException, UniSubroutineException { System.out.println(Calling Subroutine); UniSubroutine sub = session.subroutine(TEST.COMMON.SUB, 0); sub.call(); System.out.println(Finished Subroutine); } private void runCMD() throws UniSessionException, UniCommandException { System.out.println(Calling Command); UniCommand command = session.command(TEST.COMMON.CMD); command.setBlockSize(1024); command.exec(); int responsecode = command.status();// command.getSystemReturnCode(); StringBuffer block = new StringBuffer(); if (responsecode == UniObjectsTokens.UVS_MORE || responsecode == UniObjectsTokens.UVS_REPLY) { String response = null; String prev_response = null; while (responsecode != UniObjectsTokens.UVS_COMPLETE) { response = command.response(); if (prev_response == null || !response.equals(prev_response)) { prev_response = response; block.append(response); command.nextBlock(); responsecode = command.status(); } else { break; } } } block.append(command.response()); System.out.println(block.toString()); System.out.println(Finished Command); } } Sean W Ferguson wrote: I have recently encountered a very strange UniObjects bug. I have an application that includes a file containing unnamed commons. The application calls a subroutine that also includes that same unnamed common. I also have a command that includes the unnamed comman and calls the same subroutine that includes the unnamed common. When I run the command and subroutine sequentially in a loop via UniObjects, the UniSession dies. If I only run the subroutine or the command in a loop, it works like a champ. Adding more unnamed commons to the include file only causes the problem to happen less often. Please look at my sample application to see if you have any insight into why this fails consistently. Attached are the sample applications. Thanks, Sean Ferguson [demime 1.01d removed an attachment of type application/octet-stream which had a name of asjava.jar] [demime 1.01d removed an attachment of type application/octet-stream which had a name of asjava_p.jar] COMMON POS INCLUDE RMS.BP INPUT.COMMON.POS CALL TEST.SHARED.SUB SUBROUTINE TEST.COMMON.SUB INCLUDE RMS.BP INPUT.COMMON.POS CALL TEST.SHARED.SUB RETURN SUBROUTINE TEST.SHARED.SUB INCLUDE RMS.BP INPUT.COMMON.POS POS = 1 RETURN [demime 1.01d removed an attachment of type application/octet-stream which had a name of TestCommons.jar] --- 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/