RE: The result of VARIABLE[1,3] + 0

2004-02-02 Thread Brian Leach
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 ManyevereS

Universe Stand-by System Licensing

2004-02-02 Thread Matti Lamprhey
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

RE: Universe Stand-by System Licensing

2004-02-02 Thread Anthony Youngman
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 origin

RE: Universe Stand-by System Licensing

2004-02-02 Thread Joseph Baker
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 o

[UD]LOGTO

2004-02-02 Thread Björn Eklund
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

Re: The result of VARIABLE[1,3] + 0

2004-02-02 Thread Mark Johnson
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 p

RE: [UD]LOGTO

2004-02-02 Thread alfkec
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 se

UDT SELECT optimization

2004-02-02 Thread Chuck Mongiovi
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 regardle

Re: [UD]LOGTO

2004-02-02 Thread Dianne Ackerman
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]

RE: UDT SELECT optimization

2004-02-02 Thread Brian Leach
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

Universe/Redhat & GCI

2004-02-02 Thread David Ward
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 th

RE: Universe/Redhat & GCI

2004-02-02 Thread Stu Glancy
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 tho

CallHTTP: Receiving an error

2004-02-02 Thread Laursen, Mark
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

Will Windows Application be able to use Universe ODBC?

2004-02-02 Thread Denny Watkins
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

RE: Universe/Redhat & GCI

2004-02-02 Thread Stu Glancy
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

RE: lost tcp/ip connections

2004-02-02 Thread JD
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

RE: lost tcp/ip connections

2004-02-02 Thread harman
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 L

SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread George Gallen
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 th

RE: lost tcp/ip connections

2004-02-02 Thread JD
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 thi

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread Jeff Schasny
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

Re: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread BNeylon
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 PROTECTE

Re: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread Martin Phillips
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 ap

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread George Gallen
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

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread George Gallen
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 WITHO

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread KBessel
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).

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread George Gallen
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 Discus

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread Piers Angliss
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 Georg

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread George Gallen
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:[E

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread harman
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]

2004-02-02 Thread Glenn W. Paschal
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 fiel

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread George Gallen
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

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread KBessel
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 [

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread Piers Angliss
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 Febr

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread George Gallen
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 L

RE: Universe/Redhat & GCI

2004-02-02 Thread John Jenkins
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. Ev

UCI Error

2004-02-02 Thread David Sidhu
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!! SQL

RE: UCI Error

2004-02-02 Thread Logan, David (SST - Adelaide)
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

RE: The result of VARIABLE[1,3] + 0

2004-02-02 Thread Stuart Boydell
-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 ex

[UD] Creating PDF from PCL output

2004-02-02 Thread Steve Kunzman
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

RE: UCI Error

2004-02-02 Thread David Sidhu
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

Re: [UD] Creating PDF from PCL output

2004-02-02 Thread Craig Bennett
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

2004-02-02 Thread Logan, David (SST - Adelaide)
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 Supple

Re: UDT SELECT optimization

2004-02-02 Thread Mark Johnson
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

Document scan and retrieval (looking for software)

2004-02-02 Thread Mitchell, Stewart
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:[EMAI

RE: Document scan and retrieval (looking for software)

2004-02-02 Thread Mark Eastwood
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

RE: Document scan and retrieval (looking for software)

2004-02-02 Thread Ian McGowan
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 qui

RE: Document scan and retrieval (looking for software)

2004-02-02 Thread kevin zollinger
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 ha

escaping "&temp&" in dos diectory

2004-02-02 Thread Stuart Boydell
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 p

using commas in a csv file output

2004-02-02 Thread Simon Adams
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.   ***

RE: using commas in a csv file output

2004-02-02 Thread Stuart Boydell
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 outp

RE: using commas in a csv file output

2004-02-02 Thread Kevin King
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

VARIABLE<-1> = '' Inconsistent behaviour

2004-02-02 Thread Marco Manyevere
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 toda

RE: escaping "&temp&" in dos diectory

2004-02-02 Thread Stuart Boydell
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? ***

RE: UCI Error

2004-02-02 Thread Hona, David S
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' S

RE: using commas in a csv file output

2004-02-02 Thread 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. -Original Message-From: Kevin King [mailto:[EMAIL PROTE

Re: VARIABLE<-1> = '' Inconsistent behaviour

2004-02-02 Thread Darren Percival
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 i

Re: VARIABLE<-1> = '' Inconsistent behaviour

2004-02-02 Thread Louis Windsor
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 bitte

Re: using commas in a csv file output

2004-02-02 Thread Mark Johnson
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

Re: VARIABLE<-1> = '' Inconsistent behaviour

2004-02-02 Thread Mark Johnson
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 inc

RE: using commas in a csv file output

2004-02-02 Thread Stuart Boydell
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:='"'