RE: using commas in a csv file output
FLAT.LINE:= quote(OCONV(PARTS.REC<8,W>,"MD03,")) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Simon Adams OK, I now get 10,000.00 but I would like to suppress the decimal places. This is my line of code : FLAT.LINE:='"':OCONV(PARTS.REC<8,W>,"MD3,"):'"' Any further advise, most appreciated. Cheers, Simon.Australia. ** 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
Re: VARIABLE<-1> = '' Inconsistent behaviour
Best approach when combining the <-1> function with values that may be null, especially when updating associated fields, is to not allow the null value (no null debates) rather to use a token '*' character to at least force the values (253 or 254) to grow properly. The <-1>="" is historically inconsistent across platforms. Using <-1>="*" then converting the '*' to '' leaves the elements intact. If i'm growing a bunch of associated attributes with some transaction, i look for one of the values that is always present and use a DCOUNT to count its elements and then add +1 to force the new syncronized mv's using REC<5,MV>=val. Thus if REC<8,MV>is assigned to null, at least that transaction will be in the mv'th multivalue. ALso, if using the INSERT or INS function to put it at the beginning MV, watch out for nulls as well. my 1 cent. - Original Message - From: "Darren Percival" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Tuesday, February 03, 2004 12:58 AM Subject: Re: VARIABLE<-1> = '' Inconsistent behaviour > At 04:55 AM 3/02/2004 +, you wrote: > >Hi All, > > > >Consider the program: > > > >A = '' > >A<-1> = '' > >A<-1> = '' > >A<-1> = 3 > >A<-1> = '' > >A<-1> = 4 > >PRINT A<3> > > > >I expect it output '3' but it outputs '4'. Whats the explanation? I'm on > >UV 9.6 [NT] running information flavour. > > > >Regards, > >Marco > > > > > Check what "A" really is just before your print. > I think that you will find it is "3" @FM '"" @FM "4" > and not ""@FM "" @FM "3" @FM "" @FM "4" > > So that A<3> gives the you 4 not the 3 you expect > > > IIRC I have seen this behavior before where > > A = "" and A<-1> = "" doesn't actually result in the marker being appended > to the array. > > Unfortunately I cant remember/don't know the reasoning or the why behind > it. I will try and find out the situation I saw it if nobody else can shed > any light. > > Cheers, > > .Darren. > > Law of Probable Dispersal: > Whatever it is that hits the fan will not be evenly distributed. > === > > > ___ > 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: using commas in a csv file output
The reason quotes are needed in CSV is because some brain surgeon long ago decided that commas aren't human characters and that they should become value delimiters. Thus, CSV elements containing commas need the surrounding quotes. We MV people are thankful that our delimiters are far away from the human characters, 254 etc. Early MS basic allowed INPUT A,B and your answer contained a comma and their INPUT put it into the 2 variables. If your single answer to INPUT A was "Perth,SW", you got an 'extra ignored' and lost the SW. It's a shame that we must live within the poor judgement of these early designs. But they're out there. I have 2 utilities that i use extensively when building CSV's (rows & columns) from within Databasic when export/importing to a PC system. The first is called LINE.CSV and it converts LINE<1>, LINE<2> LINE<3> (a built variable representing one row) into a CSV row for appending to your eventual text file (OPENSEQ or emulator export). I have its opposite called CSV.LINE which will convert an invoming CSV row into LINE<1> etc paying attention to the commas. If anyone would like a copy email me off line. I'm probably going to publish them in Spectrum anyway. BTW, to answer the second question, to remove the pennies from an ICONV'd value you would use MD03. That's Zero Three , not Oh. The Zero indicates the displayed decimals and the 3 is the converted. Thus, MD3 is the same as MD33. Also, check to see if the comma contained in a number offends the numerical format of that cell. I don't think the comma contained is numeric, ie PRINT NUM("123,456") returns false and PRINT NUM(123,456) implies a second argument to the NUM function. you can't say X=123,456 and if you put quotes around it, it's not numeric. my 1 cent. - Original Message - From: Simon Adams To: U2 Users Discussion List Sent: Tuesday, February 03, 2004 12:45 AM Subject: RE: using commas in a csv file output OK, I now get 10,000.00 but I would like to suppress the decimal places. This is my line of code : FLAT.LINE:='"':OCONV(PARTS.REC<8,W>,"MD3,"):'"' Any further advise, most appreciated. Cheers, Simon.Australia. -Original Message-From: Kevin King [mailto:[EMAIL PROTECTED]Sent: Tuesday, 3 February 2004 15:51To: U2 Users Discussion ListSubject: RE: using commas in a csv file output quote the entire data value. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Simon AdamsSent: Monday, February 02, 2004 9:44 PMTo: [EMAIL PROTECTED]Subject: 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 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: VARIABLE<-1> = '' Inconsistent behaviour
I think this is a "feature". Universe does NOT insert non-significant nulls. In other words your first two (A<-1> = '') do not do anything! It is consistent in its' behaviour as you can count on it to do the above. It has done this as long as I remember. I found this out through bitter experience. Louis - Original Message - From: Marco Manyevere To: [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 12:55 PM Subject: VARIABLE<-1> = '' Inconsistent behaviour Hi All, Consider the program: A = '' A<-1> = '' A<-1> = '' A<-1> = 3 A<-1> = '' A<-1> = 4 PRINT A<3> I expect it output '3' but it outputs '4'. Whats the explanation? I'm on UV 9.6 [NT] running information flavour. 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
Re: VARIABLE<-1> = '' Inconsistent behaviour
At 04:55 AM 3/02/2004 +, you wrote: Hi All, Consider the program: A = '' A<-1> = '' A<-1> = '' A<-1> = 3 A<-1> = '' A<-1> = 4 PRINT A<3> I expect it output '3' but it outputs '4'. Whats the explanation? I'm on UV 9.6 [NT] running information flavour. Regards, Marco Check what "A" really is just before your print. I think that you will find it is "3" @FM '"" @FM "4" and not ""@FM "" @FM "3" @FM "" @FM "4" So that A<3> gives the you 4 not the 3 you expect IIRC I have seen this behavior before where A = "" and A<-1> = "" doesn't actually result in the marker being appended to the array. Unfortunately I cant remember/don't know the reasoning or the why behind it. I will try and find out the situation I saw it if nobody else can shed any light. Cheers, .Darren. Law of Probable Dispersal: Whatever it is that hits the fan will not be evenly distributed. === ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: using commas in a csv file output
OK, I now get 10,000.00 but I would like to suppress the decimal places. This is my line of code : FLAT.LINE:='"':OCONV(PARTS.REC<8,W>,"MD3,"):'"' Any further advise, most appreciated. Cheers, Simon.Australia. -Original Message-From: Kevin King [mailto:[EMAIL PROTECTED]Sent: Tuesday, 3 February 2004 15:51To: U2 Users Discussion ListSubject: RE: using commas in a csv file output quote the entire data value. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Simon AdamsSent: Monday, February 02, 2004 9:44 PMTo: [EMAIL PROTECTED]Subject: 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
RE: escaping "&temp&" in dos diectory
don't worry - I found it thanks. ^ execute 'dos /c cscript ^&temp^&/myscript.vbs' capturing cap -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] The ampersands are causing me grief, does anyone know how to escape them? ** 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
VARIABLE<-1> = '' Inconsistent behaviour
Hi All, Consider the program: A = '' A<-1> = '' A<-1> = '' A<-1> = 3 A<-1> = '' A<-1> = 4 PRINT A<3> I expect it output '3' but it outputs '4'. Whats the explanation? I'm on UV 9.6 [NT] running information flavour. 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
RE: using commas in a csv file output
quote the entire data value. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Simon AdamsSent: Monday, February 02, 2004 9:44 PMTo: [EMAIL PROTECTED]Subject: 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: using commas in a csv file output
enclose the number in quotes like "10,000" -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Simon AdamsSent: Tuesday, 3 February 2004 15:44To: [EMAIL PROTECTED]Subject: 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.* ** 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
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
escaping "&temp&" in dos diectory
Just a quick curly one, UV 10 Windows. I need to run a script in a &temp& directory because that's the only one that is generally going to be a type 1/19 in any given account. The ampersands are causing me grief, does anyone know how to escape them? If it's not possible, I'll just write it to a path but I would prefer it to be there for houskeeping. execute 'dos /c cscript &temp&/myscript.vbs' capturing cap 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] 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
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)
www.1mage.com Never used it, but they've been around a long time. > -Original Message- > From: Mitchell, Stewart > [mailto:[EMAIL PROTECTED] > Sent: Monday, February 02, 2004 8: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: ATT222951.txt >> __ This e-mail, including any attachments, may contain information that is protected by law as privileged and confidential, and is transmitted for the sole use of the intended recipient. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying or retention of this e-mail or the information contained herein is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender by telephone or reply e-mail, and permanently delete this e-mail from your computer system. Thank you. ___ 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] <>___ 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 by issuing 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
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 :\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: [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
Title: Message 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 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 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
[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 predefined template (Transform) and data from the application to create the PCL 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: 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 use the string 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
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 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
UCI Error
Title: RE: SELECT NOT WORKING [uv 10 - unix] 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: 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: SELECT NOT WORKING [uv 10 - unix]
Title: RE: SELECT NOT WORKING [uv 10 - unix] it's that step 2 part, that always gets me. hey..is that like 1. stop 2. drop 3. roll George -Original Message-From: Piers Angliss [mailto:[EMAIL PROTECTED]Sent: Monday, February 02, 2004 5:11 PMTo: U2 Users Discussion ListSubject: RE: SELECT NOT WORKING [uv 10 - unix] Work-around : Stop Think Rtfm Note 2 and 3 are interchangeable Try 'WITH EVERY TYPE # "CREDIT" ' as Martin suggests -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of George GallenSent: 02 February 2004 21:56To: 'U2 Users Discussion List'Subject: RE: SELECT NOT WORKING [uv 10 - unix] At least this makes sense. But is there a work around, rather than two selects and a merge.list? George >-Original Message- >From: Martin Phillips [mailto:[EMAIL PROTECTED]] >Sent: Monday, February 02, 2004 4:51 PM >To: U2 Users Discussion List >Subject: Re: SELECT NOT WORKING [uv 10 - unix] > > >I suspect that since TYPE is a mutlivalued field, some records >have CREDIT >in one value and something else in another value. Given that >every record >meets the TYPE # "CREDIT" condition, I would take a careful >look at the data >to see if there is a stray value mark in every record resulting in an >apparent extra value. > >The WITH clause says at least one element must meet the >condition. The WITH >EVERY clause may help depending on what you are trying to do. > >Martin Phillips >Ladybridge Systems >17b Coldstream Lane, Hardingstone, Northampton NN4 6DB >+44-(0)1604-709200 > >- Original Message - >From: "George Gallen" <[EMAIL PROTECTED]> >To: "'Ardent List'" <[EMAIL PROTECTED]> >Sent: Monday, February 02, 2004 9:41 PM >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 > >___ >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]
Title: RE: SELECT NOT WORKING [uv 10 - unix] Work-around : Stop Think Rtfm Note 2 and 3 are interchangeable Try 'WITH EVERY TYPE # "CREDIT" ' as Martin suggests -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of George GallenSent: 02 February 2004 21:56To: 'U2 Users Discussion List'Subject: RE: SELECT NOT WORKING [uv 10 - unix] At least this makes sense. But is there a work around, rather than two selects and a merge.list? George >-Original Message- >From: Martin Phillips [mailto:[EMAIL PROTECTED]] >Sent: Monday, February 02, 2004 4:51 PM >To: U2 Users Discussion List >Subject: Re: SELECT NOT WORKING [uv 10 - unix] > > >I suspect that since TYPE is a mutlivalued field, some records >have CREDIT >in one value and something else in another value. Given that >every record >meets the TYPE # "CREDIT" condition, I would take a careful >look at the data >to see if there is a stray value mark in every record resulting in an >apparent extra value. > >The WITH clause says at least one element must meet the >condition. The WITH >EVERY clause may help depending on what you are trying to do. > >Martin Phillips >Ladybridge Systems >17b Coldstream Lane, Hardingstone, Northampton NN4 6DB >+44-(0)1604-709200 > >- Original Message - >From: "George Gallen" <[EMAIL PROTECTED]> >To: "'Ardent List'" <[EMAIL PROTECTED]> >Sent: Monday, February 02, 2004 9:41 PM >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 > >___ >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]
Title: RE: SELECT NOT WORKING [uv 10 - unix] Use WITH EVERY TYPE # CREDIT -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of George GallenSent: Monday, February 02, 2004 4:56 PMTo: 'U2 Users Discussion List'Subject: RE: SELECT NOT WORKING [uv 10 - unix] At least this makes sense. But is there a work around, rather than two selects and a merge.list? George >-Original Message- >From: Martin Phillips [mailto:[EMAIL PROTECTED]] >Sent: Monday, February 02, 2004 4:51 PM >To: U2 Users Discussion List >Subject: Re: SELECT NOT WORKING [uv 10 - unix] > > >I suspect that since TYPE is a mutlivalued field, some records >have CREDIT >in one value and something else in another value. Given that >every record >meets the TYPE # "CREDIT" condition, I would take a careful >look at the data >to see if there is a stray value mark in every record resulting in an >apparent extra value. > >The WITH clause says at least one element must meet the >condition. The WITH >EVERY clause may help depending on what you are trying to do. > >Martin Phillips >Ladybridge Systems >17b Coldstream Lane, Hardingstone, Northampton NN4 6DB >+44-(0)1604-709200 > >- Original Message - >From: "George Gallen" <[EMAIL PROTECTED]> >To: "'Ardent List'" <[EMAIL PROTECTED]> >Sent: Monday, February 02, 2004 9:41 PM >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 > >___ >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]
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: SELECT NOT WORKING [uv 10 - unix]
There are 2 problems I have seen in the past (with all versions). 1st, (the simple one)... check the dictionary item to make sure it is set as multivalue (for D/I types, this is an "M" in field 6) --- 2nd... Rec-a credit}nocredit Rec-b credit Rec-c nocredit Select file with field = "credit" 2 records selected. (rec-a, rec-b) Select file with field = "nocredit" 2 records selected. (rec-b, rec-a) This is due to the way Universe interprets "=" when it comes to multivalues. If no multivalue select phrase is used, "ANY" is assumed. If you wish to control that, use EVERY or ANY depending on what you want. Select file with every field = "credit" 1 record selected. (rec-a) Select file with every field ne "credit" 1 record selected. (rec-c) Select file with any field = "credit" 2 records selected. (rec-a, rec-b) Select file with any field ne "credit" 2 records selected. (rec-b, rec-c) Perhaps what you want is: >SELECT FILE WITH EVERY TYPE # "CREDIT". Also, look at the data. Try the following... >GET-LIST MYLIST 253 ITEMS SELECTED >SELECT FILE WITH TYPE # "CREDIT" 253 ITEMS SELECTED >SELECT FILE WITH TYPE = "CREDIT" 10 ITEMS SELECTED >LIST FILE TYPE This should show you what values are causing you problems. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Monday, February 02, 2004 3: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]
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
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]
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 SELECTED>SELECT FILE WITH TYPE # "CREDIT"253 ITEMS SELECTED>BUTGET-LIST MYLIST253 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 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]
Title: RE: SELECT NOT WORKING [uv 10 - unix] At least this makes sense. But is there a work around, rather than two selects and a merge.list? George >-Original Message- >From: Martin Phillips [mailto:[EMAIL PROTECTED]] >Sent: Monday, February 02, 2004 4:51 PM >To: U2 Users Discussion List >Subject: Re: SELECT NOT WORKING [uv 10 - unix] > > >I suspect that since TYPE is a mutlivalued field, some records >have CREDIT >in one value and something else in another value. Given that >every record >meets the TYPE # "CREDIT" condition, I would take a careful >look at the data >to see if there is a stray value mark in every record resulting in an >apparent extra value. > >The WITH clause says at least one element must meet the >condition. The WITH >EVERY clause may help depending on what you are trying to do. > >Martin Phillips >Ladybridge Systems >17b Coldstream Lane, Hardingstone, Northampton NN4 6DB >+44-(0)1604-709200 > >- Original Message - >From: "George Gallen" <[EMAIL PROTECTED]> >To: "'Ardent List'" <[EMAIL PROTECTED]> >Sent: Monday, February 02, 2004 9:41 PM >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 > >___ >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]
There are 253 items in the list that have something in the type field other than CREDIT. There are also 10 items that have CREDIT in that field. Since it is a multi-valued field, there are items in the list that meet both sets of criteria (Type not equal to CREDIT and type equal to CREDIT). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of George Gallen Sent: Monday, February 02, 2004 4: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]
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] WHEN Doesn't help. Same thing >-Original Message- >From: Jeff Schasny [mailto:[EMAIL PROTECTED]] >Sent: Monday, February 02, 2004 4:43 PM >To: U2 Users Discussion List >Subject: 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 > ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: SELECT NOT WORKING [uv 10 - unix]
I suspect that since TYPE is a mutlivalued field, some records have CREDIT in one value and something else in another value. Given that every record meets the TYPE # "CREDIT" condition, I would take a careful look at the data to see if there is a stray value mark in every record resulting in an apparent extra value. The WITH clause says at least one element must meet the condition. The WITH EVERY clause may help depending on what you are trying to do. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 - Original Message - From: "George Gallen" <[EMAIL PROTECTED]> To: "'Ardent List'" <[EMAIL PROTECTED]> Sent: Monday, February 02, 2004 9:41 PM 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 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: SELECT NOT WORKING [uv 10 - unix]
Just curious, does >SELECT FILE WITHOUT TYPE = "CREDIT" Work? Bruce M Neylon Health Care Management Group George Gallen <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/02/2004 04:41 PM Please respond to U2 Users Discussion List To: 'Ardent List' <[EMAIL PROTECTED]> cc: 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]
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: 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 > > > > > ___ > 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
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 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
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
RE: Universe/Redhat & GCI
I should have mentioned that it works with root privileges but doesn't work with non-root privileges. -Original Message-From: Stu Glancy [mailto:[EMAIL PROTECTED]Sent: Monday, February 02, 2004 12:21 PMTo: 'U2 Users Discussion List'Subject: RE: Universe/Redhat & GCI Try "PHANTOM SLEEP 60" and then "ps -ef|grep phant". I suspect you won't find it. It works on HPUX and linux 8. We tried RH 9 and UV 10.1.0 and it doesn't work. IBM's response was linux changed, not Universe. If they certify then it should work. You may more problems. I suggest a thorough testing of application dependent shell commands. We are in the process of doing just that and found the phantom problem. Good luck. -Original Message-From: David Ward [mailto:[EMAIL PROTECTED]Sent: Monday, February 02, 2004 12:19 PMTo: [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
Will Windows Application be able to use Universe ODBC?
Platform: uniVerse 9.6.2.5 & IBM AIX 4.3.3 If a WINDOWS Application says the following concerning ODBC and Supported Databases, will the Universe ODBC work? 8. Database Support Supported databases The vendor has tested the following databases using the listed providers: Database OLE DB Provider Name(s) Microsoft Access 2000 & 2002 . . Microsoft Jet 4.0 OLE DB Provider Microsoft SQL Server 7.0 & 2000 1) Microsoft OLE DB Provider for ODBC with the SQL Server ODBC driver ± 2) Microsoft OLE DB Provider for SQL Server ! Oracle® 8i & 9i . . . . . . . . 1) Microsoft OLE DB Provider for ODBC with the Oracle 9i ODBC driver ± 2) Oracle 9i Provider for OLE DB ! 3) Microsoft OLE DB Provider for Oracle ! IBM® DB2® Universal Server 6.1 & 7.1 Microsoft OLE DB Provider for ODBC with the IBM DB2 ODBC driver ± Unify DataServer" 6 . . . . . Microsoft OLE DB Provider for ODBC Microsoft Visual FoxPro® 6.0 . . Microsoft OLE DB Provider for ODBC Thanks, Denny Watkins Director Computer Services Morningside College 1501 Morningside Ave Sioux City, Ia 51106-1717 Phone: 1-712-274-5250 E-Mail: watkins@morningside.edu ___ 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 1.0" encoding="utf-8" ?>lpar11.vacationclub.com00527lpar11.vacationclub.comlpar11.vacationclub.comSalesmanService.publishSalesmanLJ0352155421426PONCELADISLAOA 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. ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Universe/Redhat & GCI
Try "PHANTOM SLEEP 60" and then "ps -ef|grep phant". I suspect you won't find it. It works on HPUX and linux 8. We tried RH 9 and UV 10.1.0 and it doesn't work. IBM's response was linux changed, not Universe. If they certify then it should work. You may more problems. I suggest a thorough testing of application dependent shell commands. We are in the process of doing just that and found the phantom problem. Good luck. -Original Message-From: David Ward [mailto:[EMAIL PROTECTED]Sent: Monday, February 02, 2004 12:19 PMTo: [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
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: UDT SELECT optimization
Title: RE: [UD]LOGTO Chuck, The order should be immaterial ( it is on every other database I can think of ). Just be aware that if you test it by issuing 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, 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
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: Björn 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 Björn 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
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
Title: 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: Björn 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 Björn 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
Re: The result of VARIABLE[1,3] + 0
I tried this on a MCD spirit, D3 W2k and 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
[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 = 1 CMD = 'LOGTO ':$UDT52 EXECUTE CMD IF BLA THEN CREATE.FILE 'A.FILE' DYNAMIC END ELSE LOGTO ACCOUNT.NAME END REPEAT Björn Eklund ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Universe Stand-by System Licensing
There are some new policies with how you deploy U2 licenses on a back up server as of October 1, 2003. You should contact your local IBM U2 sales specialist for the most accurate information. You may contact me if you are not sure who your local IBM U2 sales specialist is. I can help you find out who your sales specialist is. Joe Baker IBM Business Partner Representative (614) 659-7457 office and fax, T/L 657-7457 [EMAIL PROTECTED] (IBM U2 web site) http://www-3.ibm.com/software/data/u2 (U2 Tech Connect) http://www-927.ibm.com/software/data/u2/support/u2techconnect/ (U2 Business Connect Questions) [EMAIL PROTECTED] (U2 general questions) [EMAIL PROTECTED] ">"Anthony Youngman" <[EMAIL PROTECTED]> "Anthony Youngman" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/02/2004 06:36 AM Please respond to U2 Users Discussion List To: "U2 Users Discussion List" <[EMAIL PROTECTED]> cc: Subject: RE: Universe Stand-by System Licensing We've got standby licences ... Basically, if you have a live system running UV, it needs to be licenced. But if it is not used, and merely sits there in "hot standby" mode, you only pay a quarter of normal maintenance. Who, where and how you sort this out with IBM, I don't know. I think we originally set it up with VMark, and have just carried on paying the bills... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Matti Lamprhey Sent: 02 February 2004 11:29 To: u2-users Subject: 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 *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** ___ 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 Stand-by System Licensing
We've got standby licences ... Basically, if you have a live system running UV, it needs to be licenced. But if it is not used, and merely sits there in "hot standby" mode, you only pay a quarter of normal maintenance. Who, where and how you sort this out with IBM, I don't know. I think we originally set it up with VMark, and have just carried on paying the bills... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matti Lamprhey Sent: 02 February 2004 11:29 To: u2-users Subject: 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 *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** ___ 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
Marco, Sounds like a bug in whatever point release you are running. What happens if you say B = A[1,3] * 1 ? I would be very worried about a runtime error from '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