RE: The result of VARIABLE[1,3] + 0
Marco, Sounds like a bug inwhatever pointrelease you are running. What happens if you say B = A[1,3] * 1 ? I would be very worried about a runtime errorfrom '123' + '456'. Not good. Brian Leach From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco ManyevereSent: 02 February 2004 04:14To: [EMAIL PROTECTED]Subject: The result of VARIABLE[1,3] + 0 Hi All, What is the correct interpratation of A = '001' B = A[1,3] + 0 PRINT B On UV 9.6 I get 0010 contrary to my expectation of 1. What is the logical explanation of this. Does UV use '+' for string concatenation as well? Then why doesnt '123' + '456' result in '123456' (I get a runtime error)? Regards, Marco BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 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] http://www.oliver.com/mailman/listinfo/u2-users
Universe Stand-by System Licensing
I believe I saw a thread here in the last few weeks concerning the licensing of Universe on emergency stand-by systems. But I'm danged if I can find it! If someone could either let me know the subject-line or dates of these postings, or else provide a link to where this stuff is documented by IBM, I'd be very grateful. Matti ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: The result of VARIABLE[1,3] + 0
I tried this on a MCD spirit, D3 W2kand AP-Pro as well and got the '1' and 567 that we're all getting. It's been affirmed here and other places that MV considers everything as a text variable (keep file handles and arrays out of this discussion) and its numerological properties come into play only when we expect it to behave as a number. Thus X="ABCDEF123IKIJIJ" ; Y="456ABCDEFG" PRINT (X[7,3])+(Y[5,3]) would produce the 579 as well. This brings up another aspect of the text/string situation: Consider this A="00"[1,3] ;*zeros for both lines B="00"[1,2] PRINT (A=B) and you would expect to get false as textually speaking 000 is not 00. But left alone, these 2 variables can be concluded to be numbers and thus equal even though their lengths are different. my 1 cent. - Original Message - From: Marco Manyevere To: [EMAIL PROTECTED] Sent: Sunday, February 01, 2004 11:13 PM Subject: The result of VARIABLE[1,3] + 0 Hi All, What is the correct interpratation of A = '001' B = A[1,3] + 0 PRINT B On UV 9.6 I get 0010 contrary to my expectation of 1. What is the logical explanation of this. Does UV use '+' for string concatenation as well? Then why doesnt '123' + '456' result in '123456' (I get a runtime error)? Regards, Marco BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 ___u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UDT SELECT optimization
Title: RE: [UD]LOGTO Does anyone know whether one of these two statements is faster? SELECT FILE BY SOME.DATE WITH SOME.FIELD = "XXX" -or- SELECT FILE WITH SOME.FIELD = "XXX" BY SOME.DATE Does the parser / optimizer (if there is one) do the filter portion of the statement first regardless of the order that you build it in or does it do things EXACTLY in the order that you enter them on the command line? -Chuck ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UD]LOGTO
I've had this work in Universe lots of times; the only problem I've had occur has to do with any menu system or security in the account I'm logging to. For example, if the other account has no access to the LOGTO verb or there is a menu in the way of getting to TCL. -Dianne [EMAIL PROTECTED] wrote: RE: [UD]LOGTO Not sure about the logto problem; However, if you are trying to create a file in a different account create.file will work with the full path. Caveat, it will not create a VOC entry in the other account. Other possible work-arounds: Use a named select list. Don't use a select list, put it in an array. hth -- Colin Alfke Calgary, Alberta Canada "Just because something isn't broken doesn't mean that you can't fix it" Stu Pickles -Original Message- From: Bjrn Eklund [mailto:[EMAIL PROTECTED]] Sent: Monday, February 02, 2004 6:44 AM To: '[EMAIL PROTECTED]' Subject: [UD]LOGTO Hi there, does anyone know if it's possible to do a select followed by a logto another account and then back again with logto without loosing my (religion) selectlist? The select statement returns 816 records but it only loops one time. SELECT REGISTER.REG LOOP READNEXT ID ELSE EXIT READV DATA FROM REGISTER.REG, ID,1 ELSE DATA = ""> CMD = 'LOGTO ':$UDT52 EXECUTE CMD IF BLA THEN CREATE.FILE 'A.FILE' DYNAMIC END ELSE LOGTO ACCOUNT.NAME END REPEAT Bjrn Eklund ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
CallHTTP: Receiving an error
Hi List; Still working on the CALLHTTP, I have made it to the point where I think I am being to talk to the other server. I am getting the error : error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed:s3_clnt.c:832: I captured the log from this: 02/02/2004 10:47:47 protocolLogging ... name=HTTP.LOG,action=""> 02/02/2004 10:47:49 createSecurityContext ... version= 02/02/2004 10:47:49 security context 201d2e08 allocated 02/02/2004 10:47:54 addCertificate ... certPath=/tables/certpath/lalfidevnx1.mv.marrcorp.marriott.com_lalfidevnx1A.crt,usedAs=2,format=2,algorithm=1 02/02/2004 10:47:55 setAuthenticationDepth ... depth=0,s_or_c=2 02/02/2004 10:47:56 showSecurityContext ... 02/02/2004 10:47:56 createSecureRequest ... 201d50d8: URL="" charset=utf-8 02/02/2004 10:47:56 setRequestHeader: standard header Content-Type=text/xml; charset=utf-8 02/02/2004 10:47:56 new header Content-Type added with value text/xml; charset=utf-8 02/02/2004 10:47:56 current Request date: Mon, 02 Feb 2004 15:47:56 GMT 02/02/2004 10:47:58 setRequestHeader ...host=nexussecure,header=SOAPAction:http://tempuri.org/postPublish 02/02/2004 10:47:58 setRequestHeader: extended header SOAPAction= 02/02/2004 10:47:58 new header SOAPAction added with value http://tempuri.org/postPublish 02/02/2004 10:47:59 submitRequest ... Var 201d50d8: host=nexussecure,timeout=1 02/02/2004 10:47:59 Assembled Request: POST /SalesmanService.asmx HTTP/1.0 Date: Mon, 02 Feb 2004 15:47:56 GMT SOAPAction: http://tempuri.org/postPublish User-Agent: IBM UniVerse 10.x Content-Type: text/xml; charset=utf-8 Content-Length: 796 ?xml version=1.0 encoding=utf-8 ?soap:Envelope xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance xmlns:xsd=http://www.w3.org/2001/XMLSchema xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/soap:HeaderNEXUSHeader xmlns=http://tempuri.org/RequestSystemIDlpar11.vacationclub.com/RequestSystemIDRequestMessageID00527/RequestMessageIDResponseURLlpar11.vacationclub.com/ResponseURLErrorURLlpar11.vacationclub.com/ErrorURLRequestMethodSalesmanService.publishSalesman/RequestMethod/NEXUSHeader/soap:Headersoap:BodypostPublish xmlns=http://tempuri.org/SALESMANRESPIdLJ0352/IdSSN155421426/SSNLastNamePONCE/LastNameFirstNameLADISLAO/FirstNameMiddle/MiddleActiveA/Active/SALESMANRESP/postPublish/soap:Body/soap:Envelope 02/02/2004 10:47:59 HTTP_START 02/02/2004 10:47:59 HTTP_CONNECT 02/02/2004 10:47:59 new host 201d57a8:nexussecure:443 allocated (proxy:no) 02/02/2004 10:47:59 host nexussecure:443 not found in hostList 02/02/2004 10:47:59 socket 201d5828 allocated 02/02/2004 10:48:08 enter SSLbinding 02/02/2004 10:48:08 loading SSL client method 02/02/2004 10:48:08 loading cert file ...02/02/2004 10:48:08 No cert file set in context! 02/02/2004 10:48:08 loading private key ...02/02/2004 10:48:08 No private key availble, OK for client 02/02/2004 10:48:08 loading CA file ...02/02/2004 10:48:08 CA cert loaded! 02/02/2004 10:48:08 loading random data ...02/02/2004 10:48:08 random data loaded! 02/02/2004 10:48:08 begin SSL negotiation ...02/02/2004 10:48:08 SSL trace:: Handshake: start 02/02/2004 10:48:08 SSL trace:: Loop: before/connect initialization 02/02/2004 10:48:08 SSL trace:: Loop: SSLv2/v3 write client hello A 02/02/2004 10:48:08 SSL trace:: Loop: SSLv3 read server hello A 02/02/2004 10:48:08 Verification strength: strict 02/02/2004 10:48:08 SSL Certificate Verification: depth: 0 subject: /C=US/ST=Florida/L=Lakeland/O=MVCI/OU=IR/CN=lalfidevnx1 issuer: /DC=com/DC=marriott/DC=marrcorp/DC=mv/CN=mvci-dev 02/02/2004 10:48:08 Peer certifictae not verified. Reason: 20, unable to get local issuer certificate 02/02/2004 10:48:08 SSL trace:: Write: SSLv3 read server certificate B 02/02/2004 10:48:08 SSL trace:: Exit: error in SSLv3 read server certificate B 02/02/2004 10:48:08 SSL trace:: Exit: error in SSLv3 read server certificate B 02/02/2004 10:48:08 SSL connect error: -1! 02/02/2004 10:48:08 exiting SSLbinding with failure! 02/02/2004 10:48:08 Socket 201d5828 closed and freed 02/02/2004 10:48:08 Secure Socket (nexussecure:443) not opened 02/02/2004 10:48:08 HTTP_ERROR 02/02/2004 10:48:08 Host 201d57a8 freed 02/02/2004 10:48:14 security context 201d2e08 freed I am not sure where I have gone wrong. Thanks Mark Laursen Marriott Vacation Club International (863) 688-7700 Ext. 4339 [EMAIL PROTECTED] This communication contains information from Marriott International, Inc. that may be confidential. Except for personal use by the intended recipient or as expressly authorized by the sender, any person who receives this information is prohibited from disclosing, copying, distributing, and/or using it. If you have received this communication in error, please immediately delete it and all copies, and promptly notify the sender. Nothing in this communication is intended to operate as an electronic signature under applicable law.
RE: lost tcp/ip connections
Donnie, You are probably aware of this, but still... To avoid loosing sessions due to network problems, I screen them. I added exec screen -xRR -T vt100 to my .profile script. Of course you should change the options to suit your needs. Now whenever I get disconnected, and then reconnect - I do not loose anything. It works for me, and helped me run some lengthy reports remotely. BTW, I use ssh instead of telnet. JD On Fri, 30 Jan 2004, Donnie Jacobs wrote: Hi Robert, Thanks for the information...I've tried what you suggested. I modified the tcp_keepalive_time, tcp_keepalive_intvl, and tcp_keepalive_probe settings. Below is how they're currently set [EMAIL PROTECTED] /root]# more /proc/sys/net/ipv4/tcp_keepalive_* :: /proc/sys/net/ipv4/tcp_keepalive_intvl :: 30 :: /proc/sys/net/ipv4/tcp_keepalive_probes :: 5 :: /proc/sys/net/ipv4/tcp_keepalive_time :: 60 I set these up in the init script and rebooted the machine, verified that they were still in place and then did the whole connect / unplug cable / reconnect cable bit. Based on these settings, I would have thought that after 60 seconds of inactivity, that I would get a max of 5 probes at 30 second intervals, and if no response was received, the connection would die. That should be a total of...60 seconds + (30 seconds * 5 tries = 150) = 210 seconds or just under 4 minutes... However, I've been back in for about 15 minutes now, and still see both logins when I do the who Did I miss something? Thanks, Donnie Jacobs Sr Developer GC Services LP 713-776-6503 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Porter Sent: Friday, January 30, 2004 1:19 PM To: [EMAIL PROTECTED] Subject: Re: lost tcp/ip connections That's a TCP/IP keepalive timeout... The setting is viewable and changable - It should be found at /proc/sys/net/ipv4/tcp_keepalive_time Changing it won't survive a reboot though. You'll either need to change it every time or do so in a script at init. rfp [EMAIL PROTECTED] 01/30/04 01:12PM Hello all, I'm wondering if there's a way within Linux to detect when a tcp/ip connection is lost. Here's the scenario... I telnet to my linux machine from my PC. I then disconnect my Ethernet cable (simulating a network failure, loss of broadband service, etc..) Then I reconnect my Ethernet cable and telnet into the linux machine again. If I do a who command, I see the old connection as well as my current connection. Running RedHat Linux 8, universe 10.0.13 I've tried several variations of netstat, who, etc...to try and identify these stranded connections, with no luck. Any ideas? Thanks, Donnie Jacobs Sr Developer GC Services LP 713-776-6503 [EMAIL PROTECTED] ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
SELECT NOT WORKING [uv 10 - unix]
OKWhat gives. GET-LIST MYLIST 253 ITEMS SELECTED SELECT FILE WITH TYPE # CREDIT 253 ITEMS SELECTED BUT GET-LIST MYLIST 253 ITEMS SELECTED SELECT FILE WITH TYPE = CREDIT 10 ITEMS SELECTED Why Do I have to search the = , save the list, then merge.list DIFF to do the same thing as select # ? The ONLY thing is that TYPE is multivalued field. It is defined in the DICT as multivalued. There is NO entry in VOC called TYPE What gives.. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - An innovative information, education and management company http://www.slackinc.com ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: lost tcp/ip connections
It's available for aix. Please check: http://www-1.ibm.com/servers/aix/products/aixos/linux/rpmgroups.html JD On Mon, 2 Feb 2004 [EMAIL PROTECTED] wrote: What is 'screen'? I don't find it on AIX. Is it a Linux thing? If it does what I think you are implying, it would be a wonderful thing. Thanks Harman Armstrong [EMAIL PROTECTED] JD [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/02/2004 01:22 PM Please respond to U2 Users Discussion List To: U2 Users Discussion List [EMAIL PROTECTED] cc: Subject:RE: lost tcp/ip connections Donnie, You are probably aware of this, but still... To avoid loosing sessions due to network problems, I screen them. I added exec screen -xRR -T vt100 to my .profile script snip ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: SELECT NOT WORKING [uv 10 - unix]
Try WHEN insted of WITH -Original Message- From: George Gallen [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 2:41 PM To: 'Ardent List' Subject: SELECT NOT WORKING [uv 10 - unix] OKWhat gives. GET-LIST MYLIST 253 ITEMS SELECTED SELECT FILE WITH TYPE # CREDIT 253 ITEMS SELECTED BUT GET-LIST MYLIST 253 ITEMS SELECTED SELECT FILE WITH TYPE = CREDIT 10 ITEMS SELECTED Why Do I have to search the = , save the list, then merge.list DIFF to do the same thing as select # ? The ONLY thing is that TYPE is multivalued field. It is defined in the DICT as multivalued. There is NO entry in VOC called TYPE What gives.. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - An innovative information, education and management company http://www.slackinc.com ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: SELECT NOT WORKING [uv 10 - unix]
Is it possible that of the 253 records in MYLIST : 10 have a value of "CREDIT" somewhere in the m/v list in field "TYPE" all 253 have a value other than "CREDIT" somewhere in the same m/v list -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]OnBehalf Of George GallenSent: 02 February 2004 21:41To: 'Ardent List'Subject: SELECT NOT WORKING [uv 10 - unix]OKWhat gives.GET-LIST MYLIST253 ITEMS SELECTEDSELECT FILE WITH TYPE # "CREDIT"253 ITEMS SELECTEDBUTGET-LIST MYLIST253 ITEMS SELECTEDSELECT FILE WITH TYPE = "CREDIT"10 ITEMS SELECTEDWhy Do I have to search the = , save the list, then merge.list DIFF to dothe same thing as select # ?The ONLY thing is that TYPE is multivalued field.It is defined in the DICT as multivalued.There is NO entry in VOC called TYPEWhat gives..GeorgeGeorge GallenSenior Programmer/AnalystAccounting/Data Division[EMAIL PROTECTED]ph:856.848.1000 Ext 220SLACK Incorporated - An innovative information, education and managementcompanyhttp://www.slackinc.com___u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: SELECT NOT WORKING [uv 10 - unix]
actually I typed it wrong :( SELECT FILE WITHOUT TYPE # "CREDIT" gives the same as SELECT FILE WITH TYPE = "CREDIT" and SELECT FILE WITHOUT TYPE = "CREDIT" gives the same as SELECT FILE WITH TYPE # "CREDIT" Sorry.. George -Original Message-From: George Gallen [mailto:[EMAIL PROTECTED]Sent: Monday, February 02, 2004 4:55 PMTo: 'U2 Users Discussion List'Subject: RE: SELECT NOT WORKING [uv 10 - unix] Gives the same result as SELECT FILE WITH TYPE = "CREDIT" -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Monday, February 02, 2004 4:57 PMTo: U2 Users Discussion ListSubject: Re: SELECT NOT WORKING [uv 10 - unix]Just curious, does SELECT FILE WITHOUT TYPE = "CREDIT" Work?Bruce M NeylonHealth Care Management Group ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: SELECT NOT WORKING [uv 10 - unix]
Title: RE: SELECT NOT WORKING [uv 10 - unix] YES. That worked. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, February 02, 2004 5:06 PM To: U2 Users Discussion List Subject: RE: SELECT NOT WORKING [uv 10 - unix] Try SELECT FILE WITH EVERY TYPE # CREDIT Harman Armstrong [EMAIL PROTECTED] ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Universe/Redhat GCI
Wrong Compiler version (most likely)... Regards JayJay From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David WardSent: 02 February 2004 17:19To: [EMAIL PROTECTED]Subject: Universe/Redhat GCI Hello, We loaded version 9.6.1.14 of Universe on Redhat release 9. Everything seems to run fine, but we are unable to complie GCI programs into the shell. We removed all of the items in GCI and attempted a rebuild and this fails as well. Has anyone successfully compiled GCI under this configuration? If so, could you provide some pointers? Thanks, -dew ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UCI Error
Title: Message Hi David, The docs say IM985 Error in RPC interface I think I would be checking the network and/or ensuring your rpc daemon is still running. The error 81002 is a universe system error ED SYS.MESSAGE 081002The file "SYS.MESSAGE" is read-only and cannot be updated.2 lines long. : P0001: unirpc: No Connection0002:Bottom at line 2.: EX Hope this helps Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David SidhuSent: Tuesday, 3 February 2004 9:23 AMTo: 'U2 Users Discussion List'Subject: UCI Error Anyone know what this error is when using UCI? I got it after running a query numerous times with different id's. I checked the sql statementand the ID both are correct. Just after afour thousand iterations I get this error. ERROR!! SQLExecDirect Died in SQLExecDirect with SQLSTATE IM985 Native error: 81002 [IBM][SQL Client][RPC] error code = 81002 The Query is simply: SELECT A.MEM.ID, A.REG.BEG.DT, A.REG.END.DT, A.GROUPFROM MEM.REG.HIST AWHERE A.MEM.ID = 'X*01'; Where the X'sis the id number. Thanks, Dave ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: The result of VARIABLE[1,3] + 0
-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Mark Johnson... This brings up another aspect of the text/string situation: Consider this A="00"[1,3] ;*zeros for both lines B="00"[1,2] PRINT (A=B) and you would expect to get false as textually speaking 000 is not 00. But left alone, these 2 variables can be concluded to be numbers and thus equal even though their lengths are different. In this case, you would probably want to usethestring compare function. PRINT COMPARE(A,B) ** 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] http://www.oliver.com/mailman/listinfo/u2-users
[UD] Creating PDF from PCL output
We are running an old electronic forms package from Epicor Dataflo on Unidata 6.0/ HP-UX 11i. The application builds a form from a predefinedtemplate (Transform) and data from the application to create thePCL for the printer. The users would like to be able to create PDF documents. Is there a way to use Adobe Acrobat to do this? Thank you. Steve Kunzman ASI DataMyte 2800 Campus Drive, Suite 60 Plymouth, MN 5544 (763)746-4179 office (612)750-3899 cellular ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UCI Error
Title: Message Does anyoneknow if there is some time out variable in Universe that would cause this or maybe something that kicks my connection after a certain time (only a couple minutes) or kicks me due to memory faults? I'm connecting from a different Server to the Universe Server. I've never worked with Universe before so anything would help, Thanks, Dave -Original Message-From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]Sent: Monday, February 02, 2004 3:03 PMTo: U2 Users Discussion ListSubject: RE: UCI Error Hi David, The docs say IM985 Error in RPC interface I think I would be checking the network and/or ensuring your rpc daemon is still running. The error 81002 is a universe system error ED SYS.MESSAGE 081002The file "SYS.MESSAGE" is read-only and cannot be updated.2 lines long. : P0001: unirpc: No Connection0002:Bottom at line 2.: EX Hope this helps Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David SidhuSent: Tuesday, 3 February 2004 9:23 AMTo: 'U2 Users Discussion List'Subject: UCI Error Anyone know what this error is when using UCI? I got it after running a query numerous times with different id's. I checked the sql statementand the ID both are correct. Just after afour thousand iterations I get this error. ERROR!! SQLExecDirect Died in SQLExecDirect with SQLSTATE IM985 Native error: 81002 [IBM][SQL Client][RPC] error code = 81002 The Query is simply: SELECT A.MEM.ID, A.REG.BEG.DT, A.REG.END.DT, A.GROUPFROM MEM.REG.HIST AWHERE A.MEM.ID = 'X*01'; Where the X'sis the id number. Thanks, Dave ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UD] Creating PDF from PCL output
I believe Ghostscript will convert PCL to PDF. See http://www.ghostscript.com/ HTH, Craig ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UCI Error
Hi David, I would be checking the timeout value (field 6) in the unirpcservices file. I have cut and pasted the appropriate bits out of the manual. This is available at http://www-306.ibm.com/software/data/u2/pubs/library/100univ/univ_100.ht ml the manual that you need is the Administrative Supplement for Client APIs Hope this is of assistance. Regards About the unirpcservices File Each process that uses the UniRPC automatically configures the unirpcservices file when it first starts up. If no unirpcservices file exists, it is created in the unishared directory. On UNIX systems the default location of this file is /usr/ibm/unishared/unirpc. On Windows NT systems the default location is drive:\ibm\unishared\unirpc. To determine the location of the unirpcservices file on your system, do the following: On UNIX systems, execute the command: $ cat /.unishared On Windows NT systems, find the registry entry under the subkey \HKEY_LOCAL_MACHINE\SOFTWARE\ibm\unishared. When a client system requests a connection to a service on a server system, the UniRPC daemon (unirpcd) on the server uses the unirpcservices file to verify that the client system can start the requested service. The UniRPC software uses field 3 of the unirpcservices file to verify that a machine making a request for a service is allowed to do so. The following table lists the fields in the unirpcservices file: UniVerse Systems On UniVerse systems the unirpcservices file might contain entries such as the following: uvnet /usr/ibm/uv/bin/uvnetd host1,host2,host3 TCP/IP 3 3600 uvdrsrv /usr/ibm/uv/bin/uvdrsrvd * TCP/IP 0 3600 uvcs /usr/ibm/uv/bin/uvapi_server * TCP/IP 0 3600 uvfilefix /usr/ibm/uv/bin/uvfilefix_server * TCP/IP 0 3600 uvserver /usr/ibm/uv/bin/uvsrvd * TCP/IP 0 3600 The version of uv.rc shipped with UniVerse systems (/usr/ibm/uv/sample/uv.rc) contains commands that: Check for the existence of the unirpcservices file Verify that services are defined in it Start the UniRPC daemon if the file contains services The UniRPC daemon is executed as part of the UniVerse reboot procedure Field Contents 1 The name of the UniRPC service (for example, uvserver). 2 The full pathname of the service engine executed by the UniRPC daemon. 3 The names of nodes allowed to execute this service. This field is multivalued, with values separated by commas (no spaces). If the field contains * (asterisk), all hosts defined in /etc/hosts can execute this service 4 The network transport mechanism for the service (TCP/IP). 5 Reserved for future use. 6 The value (in tenths of a second) specifying how long an open connection can be idle before automatic closure from the remote connection. The default is 3600, or 6 minutes. David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Sidhu Sent: Tuesday, 3 February 2004 9:41 AM To: 'U2 Users Discussion List' Subject: RE: UCI Error Does anyone know if there is some time out variable in Universe that would cause this or maybe something that kicks my connection after a certain time (only a couple minutes) or kicks me due to memory faults? I'm connecting from a different Server to the Universe Server. I've never worked with Universe before so anything would help, Thanks, Dave -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 3:03 PM To: U2 Users Discussion List Subject: RE: UCI Error Hi David, The docs say IM985 Error in RPC interface I think I would be checking the network and/or ensuring your rpc daemon is still running. The error 81002 is a universe system error ED SYS.MESSAGE 081002 The file SYS.MESSAGE is read-only and cannot be updated. 2 lines long. : P 0001: unirpc: No Connection 0002: Bottom at line 2. : EX Hope this helps Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Sidhu Sent: Tuesday, 3 February 2004 9:23 AM To: 'U2 Users Discussion List' Subject: UCI Error Anyone know what this error is when using UCI? I got it after running a query numerous times with different id's. I checked the sql statement and the ID both are correct. Just after a four thousand iterations I get this error. ERROR!! SQLExecDirect Died in SQLExecDirect with SQLSTATE IM985 Native error: 81002 [IBM][SQL Client][RPC] error code = 81002 The Query is simply: SELECT A.MEM.ID, A.REG.BEG.DT, A.REG.END.DT, A.GROUP FROM MEM.REG.HIST A WHERE A.MEM.ID = 'X*01'; Where the X's is the id number. Thanks, Dave ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UDT SELECT optimization
Title: RE: [UD]LOGTO Cached in memory is correct as well as the second statement will only have to process fewer records if the WITH was done in the first. Breaking up a SELECT statement into 2 parts may be advantageous, regardless of caching, if there are multiple ANDed WITH clauses and one or more of them involve translates. For example: SSELECT HUGE.ARCHIVE.FILE WITH CUST.ZIP = "12345" AND WITH PERIOD = "199910" would be faster as SELECT HUGE.ARCHIVE.FILE WITH PERIOD = "199910" then SSELECT HUGE.ARCHIVE.FILE WITH CUST.ZIP = "12345" assuming that CUST.ZIP is translated and the PERIOD is a local field. Note the SSELECT in the second statement as well. I've often wondered if, when using consecutive ANDs the filter processor skips the record if the first WITH is false. Why bother testing the second field if both are ANDed. my 1 cent. - Original Message - From: Brian Leach To: 'U2 Users Discussion List' Sent: Monday, February 02, 2004 11:24 AM Subject: RE: UDT SELECT optimization Chuck, The order should be immaterial ( it is on every other database I can think of ). Just be aware that if you test it byissuing the commands one after the other, the second may may complete quicker, simply because the file may be cached in memory. Brian Leach From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chuck MongioviSent: 02 February 2004 16:16To: U2 Users Discussion ListSubject: UDT SELECT optimization Does anyone know whether one of these two statements is faster? SELECT FILE BY SOME.DATE WITH SOME.FIELD = "XXX" -or- SELECT FILE WITH SOME.FIELD = "XXX" BY SOME.DATE Does the parser / optimizer (if there is one) do the filter portion of the statement first regardless of the order that you build it in or does it do things EXACTLY in the order that you enter them on the command line? -ChuckThis email was checked by MessageLabs SkyScan before entering Microgen.This email was checked on leaving Microgen for viruses, similarmalicious code and inappropriate content by MessageLabs SkyScan.DISCLAIMERThis email and any attachments are confidential and may also beprivileged.If you are not the named recipient, please notify the senderimmediately and do not disclose the contents to any otherperson, use it for any purpose, or store or copy the information.In the event of any technical difficulty with this email, pleasecontact the sender or [EMAIL PROTECTED]Microgen Information Management Solutionshttp://www.microgen.co.uk ___u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Document scan and retrieval (looking for software)
Hi All, Does anyone know of any products available for document scanning and retrieval with interfaces for Universe. Or any products that have a reasonable API so we can create our own interface. Regards, Stewart Mitchell Manager, Core Distribution Systems Mayne Pharmacy Services IT mailto:[EMAIL PROTECTED] application/ms-tnef___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Document scan and retrieval (looking for software)
we use hp digital senders - they drop a pdf into a designated area on a pc, where we have a java program polling the directory. an operator puts in an account id, the program sets some information (oracle not ud for us, but you could use UOJ) and then copies the doc to a samba share. it works quite well, and cost tens of thousands of dollars less than a full blown imaging system. it works so well, that we have five of these devices all over the place :-) our web system already has a place to show documents, so the retrieval part was already taken care of... http://tinyurl.com/r4wd -Original Message- From: Mitchell, Stewart [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 5:39 PM To: U2 Users Discussion List (E-mail) Subject: Document scan and retrieval (looking for software) Hi All, Does anyone know of any products available for document scanning and retrieval with interfaces for Universe. Or any products that have a reasonable API so we can create our own interface. Regards, Stewart Mitchell Manager, Core Distribution Systems Mayne Pharmacy Services IT mailto:[EMAIL PROTECTED] File: ATT14077.txt ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Document scan and retrieval (looking for software)
Mark Eastwood [EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]: www.1mage.com Never used it, but they've been around a long time. Used them. Liked them. It's been a few years but it was dead easy to integrate their stuff into MasterPack and other apps. I would reccomend them. As has been mentioned you'll pay more than you would if you were to roll your own, but it will get done a lot sooner ~ kevin zollinger [EMAIL PROTECTED] ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
using commas in a csv file output
How can I force a comma in an outputted csv file ? I want to put commas in numbers eg: 10,000 but as the delimiter is a comma, it puts 10 in one column and then the 000 in the next column. How can I OCONV the output but keeping the number together ? Cheers, Simon.Australia. * This e-mail, including any attachments to it, may contain confidential and/or personal information. If you have received this e-mail in error, you must not copy, distribute, or disclose it, use or take any action based on the information contained within it. Please notify the sender immediately by return e-mail of the error and then delete the original e-mail. The information contained within this e-mail may be solely the opinion of the sender and may not necessarily reflect the position, beliefs or opinions of Salmat on any issue. This email has been swept for the presence of computer viruses known to Salmat's anti-virus systems. For more information, visit our website at www.salmat.com.au. * ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UCI Error
UV version? OS version? What is the different server? Does this query complete from the TCL prompt on the UV server? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Sidhu Sent: Tuesday, February 03, 2004 10:11 AM To: 'U2 Users Discussion List' Subject: RE: UCI Error Does anyone know if there is some time out variable in Universe that would cause this or maybe something that kicks my connection after a certain time (only a couple minutes) or kicks me due to memory faults? I'm connecting from a different Server to the Universe Server. I've never worked with Universe before so anything would help, Thanks, Dave -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 3:03 PM To: U2 Users Discussion List Subject: RE: UCI Error Hi David, The docs say IM985 Error in RPC interface I think I would be checking the network and/or ensuring your rpc daemon is still running. The error 81002 is a universe system error ED SYS.MESSAGE 081002 The file SYS.MESSAGE is read-only and cannot be updated. 2 lines long. : P 0001: unirpc: No Connection 0002: Bottom at line 2. : EX Hope this helps Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Sidhu Sent: Tuesday, 3 February 2004 9:23 AM To: 'U2 Users Discussion List' Subject: UCI Error Anyone know what this error is when using UCI? I got it after running a query numerous times with different id's. I checked the sql statement and the ID both are correct. Just after a four thousand iterations I get this error. ERROR!! SQLExecDirect Died in SQLExecDirect with SQLSTATE IM985 Native error: 81002 [IBM][SQL Client][RPC] error code = 81002 The Query is simply: SELECT A.MEM.ID, A.REG.BEG.DT, A.REG.END.DT, A.GROUP FROM MEM.REG.HIST A WHERE A.MEM.ID = 'X*01'; Where the X's is the id number. Thanks, Dave ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users