RE: VARIABLE-1 = '' Inconsistent behaviour
One easy way I sometimes use is to just concatenate a field mark along with the new value and then remove the first field mark at the end... eg. A = LOOP INPUT B A := @FM:B UNTIL condition REPEAT A = A[2,LEN(A)-1] AdrianW -Original Message- From: Marco Manyevere [mailto:[EMAIL PROTECTED] Sent: Tuesday, 3 February 2004 15:00 To: U2 Users Discussion List Subject: Re: VARIABLE-1 = '' Inconsistent behaviour OK the documentation for REPLACE says something about inserting empty strings. For information flavour it does say the @FM will be added for empty strings without making a distinction between adding to an empty or non empty array. If this is a feature then it implies major code revisions for me whereever I use the -1 construct. What would be the shortest/smartest way of adding strings including non significant nulls? I hate to do: A = '' INPUT B; * May be empty IF LEN(B) THEN A-1 = B END ELSE IF LEN(A) THEN A-1 = B END ELSE A = @FM END END I have also tested A1 = '' A2 = '' A3 = 3 A4 = '' A5 = 5 and it inserts the @FM as expected but this involves maintaining a counter for the dynamic array. Louis Windsor [EMAIL PROTECTED] wrote: 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 mailto:[EMAIL PROTECTED] Manyevere To: [EMAIL PROTECTED] mailto:[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 A3 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 http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk 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 _ http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.co m Yahoo! Messenger - Communicate instantly...Ping your friends today! http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.co m/download/index.html Download Messenger Now Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] escaping temp in dos diectory
TEMP can't be guaranteed to exist. It's created if, during an upgrade, items are found in VOC that are different in type to the replacement that's to be installed in VOC as part of the upgrade. If an account has never been upgraded, there won't be a TEMP file. You'd be better off choosing SAVEDLISTS, which does always exist, but which doesn't help you get over your escaping problem. You *should* be able to use double quotes around the pathname. For example: execute 'dos /c cscript temp/myscript.vbs' capturing cap But this has two pieces of grief. One is that the entire command must also be quoted (for the DOS /C command) if the command contains white space. For example: execute 'dos /C cscript temp/myscript.vbs' capturing cap You can probably fiddle around with the third quote character, for example: execute \dos /C 'cscript temp/myscript.vbs'\ capturing cap The other is that EXECUTE - under what circumstances I can't quite remember - has a tendency to strip a level of quotes. Anyway, try some of those variations. If that doesn't work, create a Type 19 file as part of the command. For example: execute 'DOS /C mkdir mytmp; cscript mytmp/myscript.vbs' capturing cap or even execute 'DOS /C mkdir mytmp; cscript mytmp/myscript.vbs; del /S mytmp' capturing cap - Original Message - From: Stuart Boydell [EMAIL PROTECTED] Date: Tue, 3 Feb 2004 15:25:33 +1100 To: U2-Users [EMAIL PROTECTED] Subject: 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 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] escaping temp in dos diectory
Try a ^ in front of the . This works when doing redirects in a batch file, ie and become ^ and ^ The fails as this is the seperator in dos for a new command, so echo 1 echo 2 would do Echo 1 Echo 2 Andy -Original Message- 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 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: CallHTTP: Receiving an error
Mark I'm no expert (trial and error on this myself) but try increasing the depth on setAuthenticationDepth. Ithink 1 would work in this case with no certificate chain. Simon "Laursen, Mark" [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... 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:55 setAuthenticationDepth ... depth=0,s_or_c=2 ... 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 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
SV: [UD]LOGTO
Ok, I've solved the menu problem you mention by setting @USER.RETURN.CODE in the calling program and then I fixed the LOGIN voc entry so that I skip the menu if the @USER.RETURN.CODE is equal to what I used in the calling program. Björn Eklund Anknytning 2088 -Ursprungligt meddelande-Från: Dianne Ackerman [mailto:[EMAIL PROTECTED]Skickat: den 2 februari 2004 17:31Till: U2 Users Discussion ListÄmne: Re: [UD]LOGTOI'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: 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
RE: SELECT NOT WORKING [uv 10 - unix]
Title: RE: SELECT NOT WORKING [uv 10 - unix] I was about to ask if TYPE was indexed? That's also an obvious one ... if the index has somehow gotten out of sync. Cheers, Wol From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George GallenSent: 02 February 2004 22:08To: 'U2 Users Discussion List'Subject: 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 *** 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
RE: VARIABLE-1 = '' Inconsistent behaviour
It was this way on PI as well. Bear in mind that the-1 syntax was an "accident" - as originally implemented the search mechanism simply decremented to zero or the end of the string, and some bright spark realised that if you started with a negative number then it would always hit the end of the string rather than zero. So the counter-intuitive result that appending null to null gives null isn't so strange. This behaviour isprobably copied from "original Pick". We get round it by initialising the variable to "*", and then doing a DEL 1 when we've finished. Cheers, Wol From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louis WindsorSent: 03 February 2004 06:17To: U2 Users Discussion ListSubject: 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 A3 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 *** 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
Re: [UV] VARIABLE-1 = and Basic Compile $OPTIONS EXTRA.DELIM work consistently
The same documentation goes on to say:
In INFORMATION and IN2 flavor accounts, if _expression_ is an empty string
and the new element is appended to the end of the dynamic array, the end of
a field, or the end of a value, a delimiter is appended to the dynamic array,
field, or value. Use the -EXTRA.DELIM option of the $OPTIONS statement
to make the REPLACE function work as it does in IDEAL, PICK, and
REALITY flavor accounts.
In my opinion this behaviour is still unexpectedand here is why I say so:
If Information behaves the same as PICK as you say, then the behaviour is still contrary to documentation because in the example I gave below, a @FM was still appended even if the string to be added was empty: i.e.
A = 'abc'
A-1 = ''
A-1 = 'def'
will result in 3 fields. According to the REPLACEextract you quoted,A-1 = '' should not add a field mark regardless of whether A is empty or not for PICK flavour.
Marco
Marco,As some previous replies were saying, the behaviour you describe is normaland documented. The explanation for this is found in the "REPLACE" Basicfunction, which is the equivalent for the angle brackets notation at theleft of an assignment operator ("=") for dynamic arrays handling.For more information, please refer to the Basic documentation manual (File"BASIC.pdf" in the CDROM library)Here is an excerpt of the documentation :REPLACE functionSyntaxREPLACE (_expression_, field#, value#, subvalue# { , | ; } replacement)REPLACE (_expression_ [ ,field# [ ,value#] ] ; replacement)variable field# [ ,value# [ ,subvalue#] ] .../...In IDEAL, PICK, PIOPEN, and REALITY flavor accounts, if replacement is anempty string and an attempt is made to append the new element to the endof the dynamic array,
field, or value, the dynamic array, field, or valueis leftunchanged; additional delimiters are not appended. Use the EXTRA.DELIMoption of the $OPTIONS statement to make the REPLACE function appenda delimiter to the dynamic array, field, or value/...The fact is that "UniVerse" is mainly designed to reproduce the behaviourof legacy products in the "Pick" family. In this case, the implementationof the "INFORMATION" and "IDEAL" flavour followed the default behaviour in"Pick" native products.I hope this answered your question.Regards,Hervé BALESTRIERISupport Technique Avancé - IBM Data Management - Produits "U2"- Forwarded by Herve Balestrieri/France/IBM on 03/02/2004 09:35 -Marco Manyevere <[EMAIL PROTECTED] .com cc: Sent by: Subject: VARIABLE-1 = '' Inconsistent behaviour u2-users-bounces@ oliver.com 03/02/2004
05:55 Please respond to U2 Users Discussion List Hi All,Consider the program:A = ''A-1 = ''A-1 = ''A-1 = 3A-1 = ''A-1 = 4PRINT A3I expect it output '3' but it outputs '4'. Whats the explanation? I'm on UV9.6 [NT] running information flavour.Regards,MarcoBT 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
Yahoo! Messenger - Communicate instantly..."Ping" your friends
today! Download Messenger Now___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Creating PDF from PCL output
We wanted to do the same thing. Someone in this group recommended Pcl2pdf by Visual Software. We tried their demo and it worked great. Only two minor problems - one, it does not support color and some of the GL commands rendered slightly displaced but this is easily fixed. We ended up buying the product with no regrets. www.visual.co.uk HTH, Ted -Original Message-From: Steve Kunzman [mailto:[EMAIL PROTECTED]Sent: Monday, February 02, 2004 5:08 PMTo: U2-Users (E-mail)Subject: [UD] Creating PDF from PCL output We are running an old electronic forms package from Epicor Dataflo on Unidata 6.0/ HP-UX 11i. The application builds a form from a predefinedtemplate (Transform) and data from the application to create thePCL for the printer. The users would like to be able to create PDF documents. Is there a way to use Adobe Acrobat to do this? Thank you. Steve Kunzman ASI DataMyte 2800 Campus Drive, Suite 60 Plymouth, MN 5544 (763)746-4179 office (612)750-3899 cellular ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] VARIABLE-1 = and Basic Compile $OPTIONSEXTRA.DELIMwork consistently
this is not exactly correct
while you are correct that the 3 statements result
in 2 attributes,
the 2nd state does indeed have
aneffect
A='abc'
;* A=abc , len(A)=3
A-1=''
;* A=abc:@FM , len(A)=4
A-1='def'
;* A=abc:@FM:def , len(A)=7
when EXTRA.DELIM is used the results are
:
A='abc'
;* A=abc , len(A)=3
A-1=''
;* A=abc:@FM , len(A)=4
A-1='def'
;* A=abc:@FM:@FM:def , len(A)=8
- Original Message -
From:
Louis
Windsor
To: U2 Users Discussion List
Sent: Tuesday, February 03, 2004 6:42
AM
Subject: Re: [UV] VARIABLE-1 = ""
and Basic Compile "$OPTIONSEXTRA.DELIM"work "consistently"
Sorry for jumping in without checking my facts
first.
You are right the sequence
A = 'abc'
A-1 = ''
A-1 = 'def'
results in A having TWO attributes NOT
three. The second
statement has no effect. This is as it
works on Windows XP Prof
and the Personnel version of UniVerse. If
my memory serves me
this is also how it works on UV9.6 on Unix
(HPUX). Again I think
the statement A-1='' is always
ineffective. UV without over-
riding options etc will never insert a null at
the end of a string variable.
My experience is mainly with Pick
flavour.
Louis
- Original Message -
From:
Marco
Manyevere
To: [EMAIL PROTECTED]
Sent: Tuesday, February 03, 2004 5:34
PM
Subject: Re: [UV] VARIABLE-1 =
"" and Basic Compile "$OPTIONS EXTRA.DELIM"work "consistently"
The same documentation goes on to say:
In INFORMATION and IN2 flavor accounts, if _expression_ is an empty string
and the new element is appended to the end of the dynamic
array, the end of
a field, or the end of a value, a delimiter is appended to the
dynamic array,
field, or value. Use the -EXTRA.DELIM option of the
$OPTIONS
statement
to make the REPLACE function work as it does in IDEAL, PICK,
and
REALITY flavor accounts.
In my opinion this behaviour is still unexpectedand here
is why I say so:
If Information behaves the same as PICK as you say, then the
behaviour is still contrary to documentation because in the example I gave
below, a @FM was still appended even if the string to be added was empty:
i.e.
A = 'abc'
A-1 = ''
A-1 = 'def'
will result in 3 fields. According to the REPLACEextract
you quoted,A-1 = '' should not add a field mark regardless of
whether A is empty or not for PICK flavour.
Marco
Marco,As
some previous replies were saying, the behaviour you describe is
normaland documented. The explanation for this is found in the
"REPLACE" Basicfunction, which is the equivalent for the angle
brackets notation at theleft of an assignment operator ("=") for
dynamic arrays handling.For more information, please refer to the
Basic documentation manual (File"BASIC.pdf" in the CDROM
library)Here is an excerpt of the documentation
:REPLACE functionSyntaxREPLACE (_expression_,
field#, value#, subvalue# { , | ; } replacement)REPLACE (_expression_ [
,field# [ ,value#] ] ; replacement)variable field# [ ,value# [
,subvalue#] ] .../...In IDEAL, PICK, PIOPEN, and REALITY
flavor accounts, if replacement is anempty string and an attempt is
made to append the new element to the endof the dynamic ar ray, field,
or value, the dynamic array, field, or valueis leftunchanged;
additional delimiters are not appended. Use the EXTRA.DELIMoption of
the $OPTIONS statement to make the REPLACE function appenda delimiter
to the dynamic array, field, or value/...The fact
is that "UniVerse" is mainly designed to reproduce the behaviourof
legacy products in the "Pick" family. In this case, the
implementationof the "INFORMATION" and "IDEAL" flavour followed the
default behaviour in"Pick" native products.I hope this
answered your question.Regards,Hervé
BALESTRIERISupport Technique Avancé - IBM Data Management -
Produits "U2"- Forwarded by Herve Balestrieri/France/IBM on
03/02/2004 09:35 -Marco Manyevere <[EMAIL PROTECTED] .com cc: Sent by: Subject:
VARIABLE-1 = '' Inconsistent behaviour u2-users-bounces@
oliver.com 03/02 /2004 05:55 Please respond to U2
Users Discussion List Hi
All,Consider the program:A = ''A-1 =
''A-1 = ''A-1 = 3A-1 =
''A-1 = 4PRINT A3I expect it output '3'
but it outputs '4'. Whats the explanation? I'm on UV9.6 [NT] running
information flavour.Regards,MarcoBT 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
Yahoo!
Messenger - Communicate instantly..."Ping" your friends
RE: CallHTTP: Receiving an error
Simon; Tried changing the depth to 1. Same results. I going to try change the Use As, Format, and Algorithm and talk to the person that run the server. 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. -Original Message- From: u2[EMAIL PROTECTED] [mailto:u2[EMAIL PROTECTED] On Behalf Of Simon Lewington Sent: Tuesday, February 03, 2004 4:04 AM To: u2[EMAIL PROTECTED] Subject: Re: CallHTTP: Receiving an error Mark I'm no expert (trial and error on this myself) but try increasing the depth on setAuthenticationDepth. Ithink 1 would work in this case with no certificate chain. Simon Laursen, Mark [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... 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:55 setAuthenticationDepth ... depth=0,s_or_c=2 ... 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 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: VARIABLE-1 = '' Inconsistent behaviour
At least with maintaining a variable you are in control. - Original Message - From: Marco Manyevere To: U2 Users Discussion List Sent: Tuesday, February 03, 2004 2:00 AM Subject: Re: VARIABLE-1 = '' Inconsistent behaviour OK the documentation for REPLACEsays something about inserting empty strings. For information flavour it does say the @FM will be added for empty strings without making a distinction between adding to an empty or non empty array. If this is a feature then it implies major code revisions for me whereever I use the -1 construct. What would be the shortest/smartest way of adding strings including non significant nulls? I hate to do: A = '' INPUT B; *Maybe empty IF LEN(B) THEN A-1 = B END ELSE IF LEN(A) THEN A-1 = B END ELSE A = @FM END END I have also tested A1 = '' A2 = '' A3 = 3 A4 = '' A5 = 5 and it inserts the @FM as expected but thisinvolves maintaining a counter forthe dynamic array. Louis Windsor [EMAIL PROTECTED] wrote: 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 A3 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 Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now ___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 worked on an application that had: A=INSERT(A,1,-1;NEWVAL:@VM) and it was tricky. You should develop your own best approach to this concept of managing manual delimiters. BTW, is the -1 necessary with A=A[2,LEN(A)-1]. For that matter, could you use A=A[2,1000]. My question is if the second value in [] exceeds the length of A are there any surprising trailing characters? I've used A=A[2,10] (or some knowingly high number) with no consequences over the years. my 1 cent. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 2:09 AM Subject: RE: VARIABLE-1 = '' Inconsistent behaviour One easy way I sometimes use is to just concatenate a field mark along with the new value and then remove the first field mark at the end... eg. A = LOOP INPUT B A := @FM:B UNTIL condition REPEAT A = A[2,LEN(A)-1] AdrianW -Original Message- From: Marco Manyevere [mailto:[EMAIL PROTECTED] Sent: Tuesday, 3 February 2004 15:00 To: U2 Users Discussion List Subject: Re: VARIABLE-1 = '' Inconsistent behaviour OK the documentation for REPLACE says something about inserting empty strings. For information flavour it does say the @FM will be added for empty strings without making a distinction between adding to an empty or non empty array. If this is a feature then it implies major code revisions for me whereever I use the -1 construct. What would be the shortest/smartest way of adding strings including non significant nulls? I hate to do: A = '' INPUT B; * May be empty IF LEN(B) THEN A-1 = B END ELSE IF LEN(A) THEN A-1 = B END ELSE A = @FM END END I have also tested A1 = '' A2 = '' A3 = 3 A4 = '' A5 = 5 and it inserts the @FM as expected but this involves maintaining a counter for the dynamic array. Louis Windsor [EMAIL PROTECTED] wrote: 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 mailto:[EMAIL PROTECTED] Manyevere To: [EMAIL PROTECTED] mailto:[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 A3 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 http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk 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 _ http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.co m Yahoo! Messenger - Communicate instantly...Ping your friends today! http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.co m/download/index.html Download Messenger Now Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ 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: Document scan and retrieval (looking for software)
Title: RE: Document scan and retrieval (looking for software) FWIW this is an integral component of our Visage product simply drop a scanner element on a form you are in business (provided you have a PC with a scanner or Camera or other TWAIN device that is!). Simple matter to then have your indexing inside UV, and store the actual image in web space can also drop a file element to allow arbitrary capture/loading of any file. Ross Ferris Stamina Software Visage an Evolution in Software Development _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Mitchell, Stewart Sent: Tuesday, 3 February 2004 12: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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004 File: ATT23548.txt --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Recent issues
I take the blame for announcing that MV doesn't have typed variables (file handles and arrays excluded here). My contention is that we're not burdened by too many choices that may sometimes get in our way (integer vs long vs floating point etc) especially for numbers. There is a brain set, particularily with integers, that saving some precious byte or bit in memory is worth pursuing, or that FOR I%=1 TO 10 is any easier on the processor than FOR I=1 to 10 MV concludes a type (numeric or text) when it's needed and i believe this freeform, undisciplined approach has made us MV programmers that more productive instead of worrying about all that syntax. OPTION BASE 1 anyone? my 1 cent - Original Message - From: Martin Phillips [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 4:39 AM Subject: Re: Recent issues Just to add my few cents worth to a couple of recent issues... X-1 = '' works exactly as it has been defined to work for the last 35 years! One of the things about not (originally) having the concept of an SQL style null item is that you cannot tell the difference between an empty list and a list with one null entry. It is trivial to program around this once you recognise the problem. X = '123' + '456' performs an arithmetic calculation. This is absolutely fundamental to how UV/Udt work. I have lost the original mail that started this thread but I recall it was being blamed on a particular release of UV. If this didn't work, nothing would work so it must be more subtle than that. Although we think of UV Basic as being a typeless language, it isn't. There are actually around a dozen data types inside the product. All operators look at the data they are working on and, where appropriate, transform it to the correct type. The addition operator (and all other arithmetic operators) will try to convert character string data to numeric form. If the conversion is successful, the addition takes place. If not, you get the non-numeric data where numeric required message. The entire product relies on this translation taking place. For example, if you ask a user to type in a number it will actually be stored as a character string. Each use of the data as a number will transform it. Whilst this is no problem if we only use the data infrequently, a loop that does the conversion hundreds of thousands of times will do the conversion each time: INPUT CT (user types 100) FOR I = 1 TO CT NEXT CT This will convert CT for every iteration of the loop. It gets worse if you use CT many times in the loop too. For this reason, programmers sometimes force a data conversion with the apparently pointless add zero statement: INPUT CT (user types 100) CT = CT + 0 FOR I = 1 TO CT NEXT CT The extra statement takes CT as a string, adds 0 to it forcing a conversion and stores it as a number. The loop then goes faster. I once worked on an application where getting the data types optimised in this way made the program go over 1 times faster! In my work I encounter many UV/Udt users and get to see many different applications. I find it amazing how little some programmers understand about the product they are using. The questions raised on this list are sometimes so simple that it makes me wonder if the users concerned have actually ever looked at the documentation or been on a training course. By way of a quick advert, my company (Ladybridge Systems) offer UV/Udt training in the UK and parts of Europe. IBM have courses that are delivered worldwide (by us in the UK). I know I have plugged it before but I strongly recommend the UniVerse Internals course for those who really want to get a deep understanding of how this system works. Sadly, there is no equivalent for Unidata. The programming courses are great fun and address many issues like the ones discussed above. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 ___ 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
Redback Properties
Is it possible to send an entire record in a single Redback Property? When I attempt to send the entire record, the RedPage only returns the first attribute. I could not find anything in the documentation short of allowing multivalues and subvalues. In a nutshell what I am really trying to accomplish is to pass a print image back in a Redback Property but only the first line is returned. Any ideas? Vance ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] VARIABLE-1 = and Basic Compile$OPTIONSEXTRA.DELIMwork consistently
I think that the amount of diverse replies on this
topic indicates an inconsistency across platforms and that the use of a MV
counter either derived or managed is clearly the best solution that a programmer
can take to any MV environment, new or old. It would remove any suspicion to
wonder if it's working or not. I've never been let down by a real
counter.
If you were managing an array in another form of
Basic then you would have to use a counter.
my 1 cent.
- Original Message -
From:
gerry simpson
To: U2 Users Discussion List
Sent: Tuesday, February 03, 2004 7:25
AM
Subject: Re: [UV] VARIABLE-1 = ""
and Basic Compile"$OPTIONSEXTRA.DELIM"work "consistently"
this is not exactly correct
while you are correct that the 3 statements
result in 2 attributes,
the 2nd state does indeed have
aneffect
A='abc'
;* A=abc , len(A)=3
A-1=''
;* A=abc:@FM , len(A)=4
A-1='def'
;* A=abc:@FM:def , len(A)=7
when EXTRA.DELIM is used the results are
:
A='abc'
;* A=abc , len(A)=3
A-1=''
;* A=abc:@FM , len(A)=4
A-1='def'
;* A=abc:@FM:@FM:def , len(A)=8
- Original Message -
From:
Louis
Windsor
To: U2 Users Discussion List
Sent: Tuesday, February 03, 2004 6:42
AM
Subject: Re: [UV] VARIABLE-1 =
"" and Basic Compile "$OPTIONSEXTRA.DELIM"work "consistently"
Sorry for jumping in without checking my facts
first.
You are right the sequence
A = 'abc'
A-1 = ''
A-1 = 'def'
results in A having TWO attributes NOT
three. The second
statement has no effect. This is as it
works on Windows XP Prof
and the Personnel version of UniVerse.
If my memory serves me
this is also how it works on UV9.6 on Unix
(HPUX). Again I think
the statement A-1='' is always
ineffective. UV without over-
riding options etc will never insert a null
at the end of a string variable.
My experience is mainly with Pick
flavour.
Louis
- Original Message -
From:
Marco
Manyevere
To: [EMAIL PROTECTED]
Sent: Tuesday, February 03, 2004 5:34
PM
Subject: Re: [UV] VARIABLE-1
= "" and Basic Compile "$OPTIONS EXTRA.DELIM"work "consistently"
The same documentation goes on to say:
In INFORMATION and IN2 flavor accounts, if _expression_ is an empty string
and the new element is appended to the end of the dynamic
array, the end of
a field, or the end of a value, a delimiter is appended to
the dynamic array,
field, or value. Use the -EXTRA.DELIM option of
the $OPTIONS
statement
to make the REPLACE function work as it does in IDEAL, PICK,
and
REALITY flavor accounts.
In my opinion this behaviour is still unexpectedand
here is why I say so:
If Information behaves the same as PICK as you say, then the
behaviour is still contrary to documentation because in the example I gave
below, a @FM was still appended even if the string to be added was empty:
i.e.
A = 'abc'
A-1 = ''
A-1 = 'def'
will result in 3 fields. According to the
REPLACEextract you quoted,A-1 = '' should not add a
field mark regardless of whether A is empty or not for PICK flavour.
Marco
Marco,As
some previous replies were saying, the behaviour you describe is
normaland documented. The explanation for this is found in the
"REPLACE" Basicfunction, which is the equivalent for the angle
brackets notation at theleft of an assignment operator ("=") for
dynamic arrays handling.For more information, please refer to the
Basic documentation manual (File"BASIC.pdf" in the CDROM
library)Here is an excerpt of the documentation
:REPLACE functionSyntaxREPLACE (_expression_,
field#, value#, subvalue# { , | ; } replacement)REPLACE (_expression_
[ ,field# [ ,value#] ] ; replacement)variable field# [ ,value#
[ ,subvalue#] ] .../...In IDEAL, PICK, PIOPEN, and REALITY
flavor accounts, if replacement is anempty string and an attempt is
made to append the new element to the endof the dynamic ar ray,
field, or value, the dynamic array, field, or valueis
leftunchanged; additional delimiters are not appended. Use the
EXTRA.DELIMoption of the $OPTIONS statement to make the REPLACE
function appenda delimiter to the dynamic array, field, or
value/...The fact is that "UniVerse" is mainly
designed to reproduce the behaviourof legacy products in the "Pick"
family. In this case, the implementationof the "INFORMATION" and
"IDEAL" flavour followed the default behaviour in"Pick" native
products.I hope this
Re: VARIABLE-1 = '' Inconsistent behaviour
we use the A[x,] as well as A[*,x,] constructs a lot - no trailing characters/fields - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 8:14 AM Subject: Re: VARIABLE-1 = '' Inconsistent behaviour I worked on an application that had: A=INSERT(A,1,-1;NEWVAL:@VM) and it was tricky. You should develop your own best approach to this concept of managing manual delimiters. BTW, is the -1 necessary with A=A[2,LEN(A)-1]. For that matter, could you use A=A[2,1000]. My question is if the second value in [] exceeds the length of A are there any surprising trailing characters? I've used A=A[2,10] (or some knowingly high number) with no consequences over the years. my 1 cent. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 2:09 AM Subject: RE: VARIABLE-1 = '' Inconsistent behaviour One easy way I sometimes use is to just concatenate a field mark along with the new value and then remove the first field mark at the end... eg. A = LOOP INPUT B A := @FM:B UNTIL condition REPEAT A = A[2,LEN(A)-1] AdrianW -Original Message- From: Marco Manyevere [mailto:[EMAIL PROTECTED] Sent: Tuesday, 3 February 2004 15:00 To: U2 Users Discussion List Subject: Re: VARIABLE-1 = '' Inconsistent behaviour OK the documentation for REPLACE says something about inserting empty strings. For information flavour it does say the @FM will be added for empty strings without making a distinction between adding to an empty or non empty array. If this is a feature then it implies major code revisions for me whereever I use the -1 construct. What would be the shortest/smartest way of adding strings including non significant nulls? I hate to do: A = '' INPUT B; * May be empty IF LEN(B) THEN A-1 = B END ELSE IF LEN(A) THEN A-1 = B END ELSE A = @FM END END I have also tested A1 = '' A2 = '' A3 = 3 A4 = '' A5 = 5 and it inserts the @FM as expected but this involves maintaining a counter for the dynamic array. Louis Windsor [EMAIL PROTECTED] wrote: 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 mailto:[EMAIL PROTECTED] Manyevere To: [EMAIL PROTECTED] mailto:[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 A3 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 http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk 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 _ http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.co m Yahoo! Messenger - Communicate instantly...Ping your friends today! http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.co m/download/index.html Download Messenger Now Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ 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
[UD] Determining if list exists
Title: [UD] Determining if list exists Is there a Unidata or Uniquery command that tells you if a select list exists? In UniBasic I can use a SelectInfo function to determine if a list exists, but I can't find a way to do it at the TCL prompt. I have the following PQN PROC. The PROC itself works fine if there is something to return from the selection criteria. However, if nothing is selected in the SELECT statement (like the one below would if we ran it today), the PROC does what it is told and lists the whole file, since it is never given a list, resulting in a huge printout of every AR transaction. HSSELECT AR WITH PAYMENT.DATE GE 2-9-04 STON P HSAVE-LIST ARLIST P HGET-LIST ARLIST STON H PH HLIST AR PAYMENT.DATE LPTR P Thanks for any suggestions you can give. Chris ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Redback Properties
Pretty sure Redback will parse on field marks. I'd suggest converting them 1st and reconverting them back in your app. Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 8:44 AM To: [EMAIL PROTECTED] Subject: Redback Properties Is it possible to send an entire record in a single Redback Property? When I attempt to send the entire record, the RedPage only returns the first attribute. I could not find anything in the documentation short of allowing multivalues and subvalues. In a nutshell what I am really trying to accomplish is to pass a print image back in a Redback Property but only the first line is returned. Any ideas? Vance ___ 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
error
Hello: I have unidata, before when processed or to send heavy reports the System of thee Windows is arrived at 10% of the processor, but now arrives until a 40%. and that affects him performancia of the system, something knows on that. thanks. ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Redback Properties
Mike, That is what I thought and we are currently converting field marks to pipe characters. It seems to work well but since I could not find any supporting information regarding sending entire records in a given property, I thought that I would pose the question to the list. Thanks for your response. Vance Mike Randall [EMAIL PROTECTED]To: 'U2 Users Discussion List' [EMAIL PROTECTED] cast.netcc: Sent by: Subject: RE: Redback Properties u2-users-bounces@ oliver.com 02/03/2004 08:54 AM Please respond to U2 Users Discussion List Pretty sure Redback will parse on field marks. I'd suggest converting them 1st and reconverting them back in your app. Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 8:44 AM To: [EMAIL PROTECTED] Subject: Redback Properties Is it possible to send an entire record in a single Redback Property? When I attempt to send the entire record, the RedPage only returns the first attribute. I could not find anything in the documentation short of allowing multivalues and subvalues. In a nutshell what I am really trying to accomplish is to pass a print image back in a Redback Property but only the first line is returned. Any ideas? Vance ___ 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: using commas in a csv file output
that doesn't work if you are reading the data into a Word Table. It doesn't recognize quotes as ignore comma switch. Excel, however, respects it without a problem. George -Original Message-From: Kevin King [mailto:[EMAIL PROTECTED]Sent: Monday, February 02, 2004 11:51 PMTo: 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: [UV] VARIABLE-1 = and BasicCompile$OPTIONSEXTRA.DELIMwork consistently
Mark, ...the use of a MV counter either derived or managed is clearly the best solution... Some interesting performance figures... X has 100 fields (I cannot remember how big they were for this test) X-1 = 'A' takes 100 time units X := @FM : 'A'takes 150 time units X101 = 'A' takes 9320 time units X = X : @FM : 'A' takes 9010 time units Perhaps, sometimes, X-1 is a winner! Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Creating PDF from PCL output
There are two packages (for windows only I believe) that have PCL manipulation programs http://www.lincolnco.com http://www.swiftview.com They are not free however. George -Original Message-From: Steve Kunzman [mailto:[EMAIL PROTECTED]Sent: Monday, February 02, 2004 6:08 PMTo: U2-Users (E-mail)Subject: [UD] Creating PDF from PCL output We are running an old electronic forms package from Epicor Dataflo on Unidata 6.0/ HP-UX 11i. The application builds a form from a predefinedtemplate (Transform) and data from the application to create thePCL for the printer. The users would like to be able to create PDF documents. Is there a way to use Adobe Acrobat to do this? Thank you. Steve Kunzman ASI DataMyte 2800 Campus Drive, Suite 60 Plymouth, MN 5544 (763)746-4179 office (612)750-3899 cellular ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Redback Properties
In the conf directory you can change the delimiter in the rgwresp.ini. Below is what is looks like now: [Default] delim=254 startbackend=1 nresponders=2 backend=c:\ibm\ud60\bin\udt.exe perfstats=0 - Original Message - From: [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 7:02 AM Subject: RE: Redback Properties Mike, That is what I thought and we are currently converting field marks to pipe characters. It seems to work well but since I could not find any supporting information regarding sending entire records in a given property, I thought that I would pose the question to the list. Thanks for your response. Vance Mike Randall [EMAIL PROTECTED]To: 'U2 Users Discussion List' [EMAIL PROTECTED] cast.netcc: Sent by: Subject: RE: Redback Properties u2-users-bounces@ oliver.com 02/03/2004 08:54 AM Please respond to U2 Users Discussion List Pretty sure Redback will parse on field marks. I'd suggest converting them 1st and reconverting them back in your app. Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 8:44 AM To: [EMAIL PROTECTED] Subject: Redback Properties Is it possible to send an entire record in a single Redback Property? When I attempt to send the entire record, the RedPage only returns the first attribute. I could not find anything in the documentation short of allowing multivalues and subvalues. In a nutshell what I am really trying to accomplish is to pass a print image back in a Redback Property but only the first line is returned. Any ideas? Vance ___ 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 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: VARIABLE-1 = '' Inconsistent behaviour
In universe, the -1 is specifically tested for appending, not an accident as indicated (in scd.c) Maybe that is how it worked in Pick, but not in PI or UV. At 04:21 AM 02/03/2004, you wrote: Content-class: urn:content-classes:message Content-Type: multipart/alternative; boundary=_=_NextPart_001_01C3EA37.1386B4A2 It was this way on PI as well. Bear in mind that the -1 syntax was an accident - as originally implemented the search mechanism simply decremented to zero or the end of the string, and some bright spark realised that if you started with a negative number then it would always hit the end of the string rather than zero. So the counter-intuitive result that appending null to null gives null isn't so strange. This behaviour is probably copied from original Pick. We get round it by initialising the variable to *, and then doing a DEL 1 when we've finished. Cheers, Wol -- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louis Windsor Sent: 03 February 2004 06:17 To: U2 Users Discussion List Subject: 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: mailto:[EMAIL PROTECTED]Marco Manyevere To: mailto:[EMAIL PROTECTED][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 A3 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, http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uksign up online today and save £80 -- ___ 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: Redback Properties
Mike, I do as Vance does. As far as I know Redback properties are similiar to an attribute in a record in MV, and as such can only contain VM and SVM (2-dimensions) for REDBACK to handle it through Redback.RedFields. But as Vance suggests there is a way around it, you just need to create your own array/string handling. I hardly even use Redback.Redfields any more in ASP and just SPILT the Redback property into an VB (Script) Array. Example: myASPArray = Split(myRedbackObject(MyMVField),chr(253)) Verus Set MyRedField = Server.CreateObject(Redback.Redfield) MyRedField.StringValue = myRedbackObject(MyMVField) Thanks, Donald Verhagen 1690 S Congress Avenue, Suite 210 [EMAIL PROTECTED] Delray Beach, FL 33445 USA Tandem Staffing Solutions, Inc. Voice Phone: 561.454.3592 Senior Programmer Fax Phone: 561.454.3640 --- [EMAIL PROTECTED] 9:02:23 AM 02/03/2004 Mike, That is what I thought and we are currently converting field marks to pipe characters. It seems to work well but since I could not find any supporting information regarding sending entire records in a given property, I thought that I would pose the question to the list. Thanks for your response. Vance Mike Randall [EMAIL PROTECTED]To: 'U2 Users Discussion List' [EMAIL PROTECTED] cast.netcc: Sent by: Subject: RE: Redback Properties u2-users-bounces@ oliver.com 02/03/2004 08:54 AM Please respond to U2 Users Discussion List Pretty sure Redback will parse on field marks. I'd suggest converting them 1st and reconverting them back in your app. Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 8:44 AM To: [EMAIL PROTECTED] Subject: Redback Properties Is it possible to send an entire record in a single Redback Property? When I attempt to send the entire record, the RedPage only returns the first attribute. I could not find anything in the documentation short of allowing multivalues and subvalues. In a nutshell what I am really trying to accomplish is to pass a print image back in a Redback Property but only the first line is returned. Any ideas? Vance ___ 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 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Memo: Re: [UD] Determining if list exists
Thanks. I couldn't get the IF S or IF #S to work, so I used Anthony Youngman's advice and used the REQUIRE.SELECT which worked fine. Also, Greenpeace will be glad to know that no trees were harmed in the creation of these reports. All printouts were held. Disk space however was used quite extensively since, when the criteria is met, this report is usually 191K but when it lists the whole file, it grows to 161MB. Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 9:02 AM To: U2 Users Discussion List Subject: Memo: Re: [UD] Determining if list exists Hi Chris, I believe there is the IF S or the IF #S construct that you can use in a proc to test the existence or otherwise of a select list. So if you modify your proc: HSSELECT AR WITH PAYMENT.DATE GE 2-9-04 STON P HSAVE-LIST ARLIST P HGET-LIST ARLIST STON H PH IF #S G 10 HLIST AR PAYMENT.DATE LPTR P 10 O No items Selected that should save a few trees. cheers, asvin Chris Bugosh [EMAIL PROTECTED] on 03 Feb 2004 13:51 Please respond to U2 Users Discussion List [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:[EMAIL PROTECTED] cc: bcc: Subject:[UD]Determining if list exists Is there a Unidata or Uniquery command that tells you if a select list exists? In UniBasic I can use a SelectInfo function to determine if a list exists, but I can't find a way to do it at the TCL prompt. I have the following PQN PROC. The PROC itself works fine if there is something to return from the selection criteria. However, if nothing is selected in the SELECT statement (like the one below would if we ran it today), the PROC does what it is told and lists the whole file, since it is never given a list, resulting in a huge printout of every AR transaction. HSSELECT AR WITH PAYMENT.DATE GE 2-9-04 STON P HSAVE-LIST ARLIST P HGET-LIST ARLIST STON H PH HLIST AR PAYMENT.DATE LPTR P Thanks for any suggestions you can give. Chris ** This message originated from the Internet. Its originator may or may not be who they claim to be and the information contained in the message and any attachments may or may not be accurate. ** (See attached file: C.htm) ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ Registered in England - Number 14259 Authorised and Regulated by the Financial Services Authority Member of the HSBC Bank marketing group. We sell life assurance, pensions and collective investment schemes and advise only on our own range of these products. _ This transmission has been issued by a member of the HSBC Group HSBC for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: error
Yimi, The first place I'd look would be file performance. I am unfamiliar with Unidata on windows, but we use Unidata on AIX-unix. I'd run guide on the file and see what it recommends as far as sizing. You may have alot of overflow1 or even overflow2. Also, you may want to utilize indexing as well. Of course there could always be a hardware problem, lack of memory, etc. I'd rule out the obvious first. Thanks. Yimi López [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/02/2004 08:49 AM Please respond to U2 Users Discussion List To: U2 Users Discussion List [EMAIL PROTECTED] cc: Subject: error Hello: I have unidata, before when processed or to send heavy reports the System of thee Windows is arrived at 10% of the processor, but now arrives until a 40%. and that affects him performancia of the system, something knows on that. thanks. ___ 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
Perhaps Universe 9.6.1.14 is not certified to run on RH 9. Its not in the product matrix. -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
Re: [UV] VARIABLE-1 = and Basic Compile $OPTIONS EXTRA.DELIMwork consistently
As I recall, the INSERT function with a -1 parameter always added the
relevant field mark until one of the Microdata releases around 1979, when some
bright soul in their engineering department decided that the extra null value at
the end was 'irrelevant' and should not be added. This change in behavior
provoked a storm of protest at the next national conference, as all of us had
incorporated code that used the -1 in sets of multi-valued attributes that
needed to stay in sync.
PO #
Item (mv'd)
Qty on order (mv'd)
Qty in stock (mv'd)
If there was nothing in stock for the third item on the Purchase Order, but
there was stock for the fourth item on the Purchase Order, we all wanted the
data to look like this
001 P001 @VM P002 @VM P003 @VM P004
00250 @VM 20 @VM 40 @VM 30
003 10 @VM 20 @VM @VM 15
But instead, suddenly we were seeing 15 units onhand for P003 and no onhand
for P004. The 'irrelevant' data was very relevant in our applications, and
the result of the change in behavior was significant (as in, what a nightmare,
reprogramming every update routine that included that syntax!).
Microdata management understood ourfrustration and the subsequent
release set the behavior back to always inserting the field mark. However,
most of us who lived through that Microdata release have steered clear of the -1
except for lists which are never going to have to synchronize with any other
list. It is safer not to assume that an engineer who does not understand
how you are using the product is not going to change the behavior out from under
you.
Susan M. LynchF.W. Davison Company, Inc.(781) 340-9255
- Original Message -
From:
Marco
Manyevere
To: [EMAIL PROTECTED]
Sent: Tuesday, February 03, 2004 4:34
AM
Subject: Re: [UV] VARIABLE-1 = ""
and Basic Compile "$OPTIONS EXTRA.DELIM"work "consistently"
The same documentation goes on to say:
In INFORMATION and IN2 flavor accounts, if _expression_ is an empty string
and the new element is appended to the end of the dynamic array,
the end of
a field, or the end of a value, a delimiter is appended to the
dynamic array,
field, or value. Use the -EXTRA.DELIM option of the
$OPTIONS
statement
to make the REPLACE function work as it does in IDEAL, PICK,
and
REALITY flavor accounts.
In my opinion this behaviour is still unexpectedand here
is why I say so:
If Information behaves the same as PICK as you say, then the
behaviour is still contrary to documentation because in the example I gave
below, a @FM was still appended even if the string to be added was empty:
i.e.
A = 'abc'
A-1 = ''
A-1 = 'def'
will result in 3 fields. According to the REPLACEextract
you quoted,A-1 = '' should not add a field mark regardless of
whether A is empty or not for PICK flavour.
Marco
Marco,As
some previous replies were saying, the behaviour you describe is
normaland documented. The explanation for this is found in the "REPLACE"
Basicfunction, which is the equivalent for the angle brackets notation
at theleft of an assignment operator ("=") for dynamic arrays
handling.For more information, please refer to the Basic documentation
manual (File"BASIC.pdf" in the CDROM library)Here is an excerpt
of the documentation :REPLACE functionSyntaxREPLACE
(_expression_, field#, value#, subvalue# { , | ; } replacement)REPLACE
(_expression_ [ ,field# [ ,value#] ] ; replacement)variable field# [
,value# [ ,subvalue#] ] .../...In IDEAL, PICK, PIOPEN, and
REALITY flavor accounts, if replacement is anempty string and an attempt
is made to append the new element to the endof the dynamic ar ray,
field, or value, the dynamic array, field, or valueis leftunchanged;
additional delimiters are not appended. Use the EXTRA.DELIMoption of the
$OPTIONS statement to make the REPLACE function appenda delimiter to the
dynamic array, field, or value/...The fact is that
"UniVerse" is mainly designed to reproduce the behaviourof legacy
products in the "Pick" family. In this case, the implementationof the
"INFORMATION" and "IDEAL" flavour followed the default behaviour
in"Pick" native products.I hope this answered your
question.Regards,Hervé BALESTRIERISupport Technique
Avancé - IBM Data Management - Produits "U2"- Forwarded by Herve
Balestrieri/France/IBM on 03/02/2004 09:35 -Marco Manyevere
<[EMAIL PROTECTED] To: [EMAIL PROTECTED] .com cc: Sent by:
Subject: VARIABLE-1 = '' Inconsistent behaviour
u2-users-bounces@ oliver.com 03/02 /2004 05:55
Please respond to U2 Users Discussion List
Hi All,Consider the program:A =
''A-1 = ''A-1 = ''A-1 = 3A-1
= ''A-1 = 4PRINT A3I expect it output '3'
but it outputs '4'. Whats the explanation? I'm on UV9.6 [NT] running
information flavour.Regards,MarcoBT Yahoo!
Broadband - Free modem offer,
Avante Job Scheduler
I am looking for the Avante Job Scheduler Manual or instructions on how to use it or ... if it works at all. Haas Automation Inc. Dave Raven Mobile(949) 228 2224 e Fax (815)4259364 P.O. Box 17811, Irvine CA 92623-7811 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Universe training
Hello, I'm new to the list and looking for basic Universe training. It appears the only options are Raining Data and IBM. Does anyone have any recommendations? Thanks, George Nitsos I.S. Dept. UC Davis Bookstore (530)752-6515 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Document scan and retrieval (looking for software)
Title: RE: Document scan and retrieval (looking for software) TRY COMPASSCS.COM. I USE THEM AND THEY HAVE A GREAT PRODUCT. INTEGRATED IN UNIVERSE ALSO From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross FerrisSent: Tuesday, February 03, 2004 6:28 AMTo: U2 Users Discussion ListSubject: RE: Document scan and retrieval (looking for software) FWIW this is an integral component of our Visage product simply drop a scanner element on a form you are in business (provided you have a PC with a scanner or Camera or other TWAIN device that is!). Simple matter to then have your indexing inside UV, and store the actual image in web space can also drop a file element to allow arbitrary capture/loading of any file. Ross Ferris Stamina Software Visage an Evolution in Software Development _From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Mitchell, StewartSent: Tuesday, 3 February 2004 12:39 PMTo: 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] ---Incoming mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004 File: ATT23548.txt ---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Document scan and retrieval (looking for software)
Title: RE: Document scan and retrieval (looking for software) We use 1Mage (www.1mage.com) and amass for the optical jukebox -Original Message- From: Lloyd Cottrell [mailto:[EMAIL PROTECTED] Sent: 03 February 2004 17:54 To: 'U2 Users Discussion List' Subject: RE: Document scan and retrieval (looking for software) TRY COMPASSCS.COM. I USE THEM AND THEY HAVE A GREAT PRODUCT. INTEGRATED IN UNIVERSE ALSO From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Tuesday, February 03, 2004 6:28 AM To: U2 Users Discussion List Subject: RE: Document scan and retrieval (looking for software) FWIW this is an integral component of our Visage product simply drop a scanner element on a form you are in business (provided you have a PC with a scanner or Camera or other TWAIN device that is!). Simple matter to then have your indexing inside UV, and store the actual image in web space can also drop a file element to allow arbitrary capture/loading of any file. Ross Ferris Stamina Software Visage an Evolution in Software Development _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Mitchell, Stewart Sent: Tuesday, 3 February 2004 12: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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004 File: ATT23548.txt --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004 This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UCI Error
UV version? UniVerse version - 10.0.6 OS version? UniVerse Box OS - HP/UX 11.0 What is the different server? Oracle Box OS - HP/UX 11.0 Does this query complete from the TCL prompt on the UV server? YES -Original Message- From: Hona, David S [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 9:32 PM To: 'U2 Users Discussion List' Subject: 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 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Universe training
Check out http://www.discoverycomputersystems.com/ Marcie Gebauer Miller is a great instructor! (she usually holds basic Universe training workshops at our OSDA meetings) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Nitsos Sent: Tuesday, February 03, 2004 12:51 PM To: [EMAIL PROTECTED] Subject: Universe training Hello, I'm new to the list and looking for basic Universe training. It appears the only options are Raining Data and IBM. Does anyone have any recommendations? Thanks, George Nitsos I.S. Dept. UC Davis Bookstore (530)752-6515 ___ 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: Document scan and retrieval (looking for software)
Title: RE: Document scan and retrieval (looking for software) another less integrated option (sorry if it was said before, I didn't catch the beginning of the thread). Use whatever method to scan/import as a bmp/jpg. Base64 encode the file, and store it in UV. Then Uncode the file, save it's original extension, and launch IE with that filename for display If this is running under windows, you could pull from UV encoded, decode, save to \Temporary_files and Execute IE, all from a program. I don't know if PCpaint can import an image from a source other than a file, I know one of my image manipulation software packages that came with an old digital camera (I think's it's by Adobe) will allow me to import from my scanner, or camera, or file. George -Original Message-From: Keith Upton [mailto:[EMAIL PROTECTED]Sent: Tuesday, February 03, 2004 1:03 PMTo: U2 Users Discussion ListSubject: RE: Document scan and retrieval (looking for software) We use 1Mage (www.1mage.com) and amass for the optical jukebox -Original Message-From: Lloyd Cottrell [mailto:[EMAIL PROTECTED] Sent: 03 February 2004 17:54To: 'U2 Users Discussion List'Subject: RE: Document scan and retrieval (looking for software) TRY COMPASSCS.COM. I USE THEM AND THEY HAVE A GREAT PRODUCT. INTEGRATED IN UNIVERSE ALSO From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross FerrisSent: Tuesday, February 03, 2004 6:28 AMTo: U2 Users Discussion ListSubject: RE: Document scan and retrieval (looking for software) FWIW this is an integral component of our Visage product - simply drop a scanner element on a form you are in business (provided you have a PC with a scanner or Camera or other TWAIN device that is!). Simple matter to then have your indexing inside UV, and store the actual image in "web space" - can also drop a file element to allow arbitrary capture/loading of any file. Ross Ferris Stamina Software Visage - an Evolution in Software Development _From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Mitchell, StewartSent: Tuesday, 3 February 2004 12:39 PMTo: 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] ---Incoming mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004 File: ATT23548.txt ---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004 This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message.This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication.E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments.Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Universe training
George, I believe that Modular Information Systems (MIS) in San Ramon, CA offers the training that you're looking for. R. Bruce Lunt 408.832.1900 cell From: George Nitsos [EMAIL PROTECTED] Reply-To: U2 Users Discussion List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Universe training Date: Tue, 3 Feb 2004 09:50:32 -0800 Hello, I'm new to the list and looking for basic Universe training. It appears the only options are Raining Data and IBM. Does anyone have any recommendations? Thanks, George Nitsos I.S. Dept. UC Davis Bookstore (530)752-6515 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users _ High-speed usersbe more efficient online with the new MSN Premium Internet Software. http://join.msn.com/?pgmarket=en-uspage=byoa/premST=1 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Document scan and retrieval (looking for software)
Title: RE: Document scan and retrieval (looking for software) You could of course simply save the file into a directory that is also a type 1/19 file to UV I suppose it depends on the number of images involved, as a directory search will slow down, and yet .. Might be interesting to find out WHERE in the business process Stewart was looking at deploying this ? Obviously HOW you approach the problem will vary depending on volumes. If this was for a Proof of Delivery System (PODS), or maybe for incoming invoices/documents the volumes would be quite high, and the process would need to be as efficient as possible. There may be other areas where the volumes are very low (though the value of the image to the business is high), and the relatively small overhead of using PCPaint as you suggest then doing a Save As may not be too great an impost. Ross FerrisStamina SoftwareVisage an Evolution in Software Development From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Wednesday, 4 February 2004 5:22 AM To: 'U2 Users Discussion List' Subject: RE: Document scan and retrieval (looking for software) another less integrated option (sorry if it was said before, I didn't catch the beginning of the thread). Use whatever method to scan/import as a bmp/jpg. Base64 encode the file, and store it in UV. Then Uncode the file, save it's original extension, and launch IE with that filename for display If this is running under windows, you could pull from UV encoded, decode, save to \Temporary_files and Execute IE, all from a program. I don't know if PCpaint can import an image from a source other than a file, I know one of my image manipulation software packages that came with an old digital camera (I think's it's by Adobe) will allow me to import from my scanner, or camera, or file. George -Original Message- From: Keith Upton [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 1:03 PM To: U2 Users Discussion List Subject: RE: Document scan and retrieval (looking for software) We use 1Mage (www.1mage.com) and amass for the optical jukebox -Original Message- From: Lloyd Cottrell [mailto:[EMAIL PROTECTED] Sent: 03 February 2004 17:54 To: 'U2 Users Discussion List' Subject: RE: Document scan and retrieval (looking for software) TRY COMPASSCS.COM. I USE THEM AND THEY HAVE A GREAT PRODUCT. INTEGRATED IN UNIVERSE ALSO From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Tuesday, February 03, 2004 6:28 AM To: U2 Users Discussion List Subject: RE: Document scan and retrieval (looking for software) FWIW this is an integral component of our Visage product - simply drop a scanner element on a form you are in business (provided you have a PC with a scanner or Camera or other TWAIN device that is!). Simple matter to then have your indexing inside UV, and store the actual image in web space - can also drop a file element to allow arbitrary capture/loading of any file. Ross Ferris Stamina Software Visage - an Evolution in Software Development _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Mitchell, Stewart Sent: Tuesday, 3 February 2004 12: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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004 File: ATT23548.txt --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004 This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House,
RE: using commas in a csv file output
Once again you're looking at the problem like a nail because you're swinging at it with a CSV hammer. First import Tab-delimited text into your document. Then go to menu Table Convert Text to Table. All of this can be automated. George, what kind of import are you suggesting for a Word table? Tony From: George Gallen that doesn't work if you are reading the data into a Word Table. It doesn't recognize quotes as ignore comma switch. Excel, however, respects it without a problem. From: Kevin King quote the entire data value. From: Simon Adams How can I force a comma in an outputted csv file ? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Document scan and retrieval (looking for software)
Title: RE: Document scan and retrieval (looking for software) Could also have the PC that is scanning save to a specific directory. then have a program monitor that directory for new entries, read them, encode them and save them somehow then the saved filename would have be linked into the system. I'm just using pcpaint as an example of a program that might be able to read directly from a scanner and save in .jpg/.bmp format. If volume is high, and a number of scanners are being used, then have one central PC share it's directory and each scanner saves to that directory. Since the directory is shared, you could even have unix system running SAMBA monitor the directory (thus bringing unix into the picture). The only drawback to having unix in the setup is that it is more difficult to have unix bring up IE on a PC. But that could be gotten around if you run a lpr/lpd daemon on the PC which can then take a print job and pass it to a program (ie. RPM www.brooksnet.com). or use a PC with rsh daemon that would allow the unix system to send the launch command to the PC. or even a small custom PERL socketed program on the PC which could listen for a command and launch IE. Depending on the $$ wanted to be spent. I don't think a having the image be a type 1/19 file would be good, unless it's base64 or mimeencoded, as you could have char(255)'s imbedded in the image. George -Original Message-From: Ross Ferris [mailto:[EMAIL PROTECTED]Sent: Tuesday, February 03, 2004 4:34 PMTo: U2 Users Discussion ListSubject: RE: Document scan and retrieval (looking for software) You could of course simply save the file into a directory that is also a type 1/19 file to UV - I suppose it depends on the number of images involved, as a directory search will slow down, and yet . Might be interesting to find out WHERE in the business process Stewart was looking at deploying this ? Obviously HOW you approach the problem will vary depending on volumes. If this was for a Proof of Delivery System (PODS), or maybe for incoming invoices/documents the volumes would be quite high, and the process would need to be as efficient as possible. There may be other areas where the volumes are very low (though the value of the image to the business is high), and the relatively small overhead of using PCPaint as you suggest then doing a Save As may not be too great an impost. Ross FerrisStamina SoftwareVisage - an Evolution in Software Development From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George GallenSent: Wednesday, 4 February 2004 5:22 AMTo: 'U2 Users Discussion List'Subject: RE: Document scan and retrieval (looking for software) another less integrated option (sorry if it was said before, I didn't catch the beginning of the thread). Use whatever method to scan/import as a bmp/jpg. Base64 encode the file, and store it in UV. Then Uncode the file, save it's original extension, and launch IE with that filename for display If this is running under windows, you could pull from UV encoded, decode, save to \Temporary_files and Execute IE, all from a program. I don't know if PCpaint can import an image from a source other than a file, I know one of my image manipulation software packages that came with an old digital camera (I think's it's by Adobe) will allow me to import from my scanner, or camera, or file. George -Original Message-From: Keith Upton [mailto:[EMAIL PROTECTED]Sent: Tuesday, February 03, 2004 1:03 PMTo: U2 Users Discussion ListSubject: RE: Document scan and retrieval (looking for software) We use 1Mage (www.1mage.com) and amass for the optical jukebox -Original Message-From: Lloyd Cottrell [mailto:[EMAIL PROTECTED] Sent: 03 February 2004 17:54To: 'U2 Users Discussion List'Subject: RE: Document scan and retrieval (looking for software) TRY COMPASSCS.COM. I USE THEM AND THEY HAVE A GREAT PRODUCT. INTEGRATED IN UNIVERSE ALSO From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross FerrisSent: Tuesday, February 03, 2004 6:28 AMTo: U2 Users Discussion ListSubject: RE: Document scan and retrieval (looking for software) FWIW this is an integral component of our Visage product - simply drop a scanner element on a form you are in business (provided you have a PC with a scanner or Camera or other TWAIN device that is!). Simple matter to then have your indexing inside UV, and store the actual image in "web space" - can also drop a file element to allow arbitrary capture/loading of any file. Ross Ferris Stamina Software Visage - an Evolution in Software Development
Confprod running with 99.9% cpu
Hi, I am supporting an Unidata 5.2 system running on Tru64 UNIX V5.1A with two CPU. When I look at the processes running in the system I find a process with command confprod is taking 99.9% CPU. Can anybody please tell me what is it and why is it happening? Collect -S -s p -n 4 # Process Statistics (RSS VSZ in Decimal units, i.e 1K = 1000 bytes) # PID User %CPU RSS VSZ UsrTim SysTim IBk OBk Maj Min Command 21467 root 99.9 475K 4.9M 0.516 0.483 0 0 0 0 confprod 45766 CSAMGR1 3.3 3.8M 25M 0.008 0.007 0 0 0 1 udt 58765 VICCO01 1.7 5.2M 30M 0.023 0.017 0 6 0 34 udt 105494 VICCSA23 0.7 5.8M 30M 0.001 0.001 0 1 0 12 udt Have a lovely day. Regards, Kafsat Taiyus Network Administrator Retail Decisions Pty Ltd Incorporating Motorpass, Motorcharge Ltd T: 61 3 9274 9163 F: 61 3 9274 9130 E: [EMAIL PROTECTED] W: www.retaildecisions.com.au This email and any attachments are confidential and intended solely for the use of the person or entity to whom they are addressed. If you are not the intended recipient, please do not disclose, store, copy or take any action in reliance on it or them. If you have received this message in error, please tell us by reply email (or telephone + 61 (0) 3 9274 9100) and delete all copies on your system. Any opinion, advice or information in this email is not necessarily that of the owners or officers of this company. Please advise us immediately if you or your employer do not consent to email for messages of this type. Retail Decisions has taken reasonable precautions to ensure that any attachment to this email has been swept for viruses. However, we cannot accept any liability for any damage sustained as a result of software viruses, and would advise that you carry out your own virus checks before opening any attachment. Please note that communications sent by or to any person through our computer system may be viewed by other Retail Decisions employees or officers strictly in accordance with law. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UV SELECT Info Display
Brain FreezeWhat's the Keyword you enter at end of SELECT statement to display the Index info it's using? TIA __ 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
RE: using commas in a csv file output
Title: RE: using commas in a csv file output I'm thinking the opposite on this one. It's exporting that's the problem. If you try to save a word table as a csv file, it won't quote any fields that have a comma, so your importing program gets all screwed up. We had a few people that kept their databases as a Word File in a Table, and would export the table. This was on Word 97, so possibly this has been addressed since then. Don't ask why they were using Word for a database. I'd rather not go there again :) Tabs sometimes will be expanded by the importing program (not excel) which might be a reason why commas would need to be used, and of course there is also the reason because whoever wrote the importing program that this csv file needs to go to didn't think about having tabs a possible delimiter. George -Original Message- From: Tony Gravagno [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 03, 2004 4:48 PM To: 'U2 Users Discussion List' Subject: RE: using commas in a csv file output Once again you're looking at the problem like a nail because you're swinging at it with a CSV hammer. First import Tab-delimited text into your document. Then go to menu Table Convert Text to Table. All of this can be automated. George, what kind of import are you suggesting for a Word table? Tony From: George Gallen that doesn't work if you are reading the data into a Word Table. It doesn't recognize quotes as ignore comma switch. Excel, however, respects it without a problem. From: Kevin King quote the entire data value. From: Simon Adams How can I force a comma in an outputted csv file ? -- 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: Confprod running with 99.9% cpu
confprod is a tool to configure UniData licenses and generate config code, enter auth code. Sounds like someone disconnected somehow. Go ahead and kill it from the Unix shell. Wally Terhune Manager - U2 Advanced Technical Support IBM Data Management Solutions Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! kafsat taiyus [EMAIL PROTECTED] kafsat taiyus [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/03/2004 03:52 PM Please respond to U2 Users Discussion List To '[EMAIL PROTECTED]' [EMAIL PROTECTED] cc Subject Confprod running with 99.9% cpu Hi, I am supporting an Unidata 5.2 system running on Tru64 UNIX V5.1A with two CPU. When I look at the processes running in the system I find a process with command confprod is taking 99.9% CPU. Can anybody please tell me what is it and why is it happening? Collect -S -s p -n 4 # Process Statistics (RSS VSZ in Decimal units, i.e 1K = 1000 bytes) # PID User %CPU RSS VSZ UsrTim SysTim IBk OBk Maj Min Command 21467 root 99.9 475K 4.9M 0.516 0.483 0 0 0 0 confprod 45766 CSAMGR1 3.3 3.8M 25M 0.008 0.007 0 0 0 1 udt 58765 VICCO01 1.7 5.2M 30M 0.023 0.017 0 6 0 34 udt 105494 VICCSA23 0.7 5.8M 30M 0.001 0.001 0 1 0 12 udt Have a lovely day. Regards, Kafsat Taiyus Network Administrator Retail Decisions Pty Ltd Incorporating Motorpass, Motorcharge Ltd T: 61 3 9274 9163 F: 61 3 9274 9130 E: [EMAIL PROTECTED] W: www.retaildecisions.com.au This email and any attachments are confidential and intended solely for the use of the person or entity to whom they are addressed. If you are not the intended recipient, please do not disclose, store, copy or take any action in reliance on it or them. If you have received this message in error, please tell us by reply email (or telephone + 61 (0) 3 9274 9100) and delete all copies on your system. Any opinion, advice or information in this email is not necessarily that of the owners or officers of this company. Please advise us immediately if you or your employer do not consent to email for messages of this type. Retail Decisions has taken reasonable precautions to ensure that any attachment to this email has been swept for viruses. However, we cannot accept any liability for any damage sustained as a result of software viruses, and would advise that you carry out your own virus checks before opening any attachment. Please note that communications sent by or to any person through our computer system may be viewed by other Retail Decisions employees or officers strictly in accordance with law.-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users inline: graycol.gifinline: pic29421.gifinline: ecblank.gif-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: using commas in a csv file output
Thankyou Stuart, This is the output I was looking for : "MD03," Cheers, Simon.Australia -Original Message-From: Stuart Boydell [mailto:[EMAIL PROTECTED]Sent: Tuesday, 3 February 2004 17:57To: U2 Users Discussion ListSubject: RE: using commas in a csv file output FLAT.LINE:= quote(OCONV(PARTS.REC8,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.REC8,W,"MD3,"):'"' Any further advise, most appreciated. Cheers, Simon.Australia. **This email message and any files transmitted with it are confidentialand 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 scannedfor the presence of computer viruses.** * 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
UV command failing mystery
We are having a very strange intermittent problem with the UV command not working from Unix. Occasionally, after a user logs into Unix (without noticing anything unusual) typing UV simply returns the user to the UNIX shell almost instantly. When the problem occurs it seems to affect everyone who logins in and attempts to go into Universe for a period of time and then the problem seems to resolve itself. Any users who logged into Unix during that period of time still can not go into Universe but new logins work fine. The problem seems to be with Universe. Unix commands work fine and when we have tried executing other Universe commands which normally can be run from Unix they fail also. The Unix login script seems to run fine. When the problem occurs users already in Universe notice no problems. No unusual locks or performance problems have been noticed. The problem does not seem to be load related since it happens at apparently random times including times when very few users are logged in. We have been running 9.6.2.2 on DG/UX for several years and have never had the problem until the last couple of months. The only thing that may be suspicious is some changes we made to some kernel and UV config settings a few weeks prior to the first reported problem. The following changes were made: (KERNEL) SDELSIM 2048 TO 256 SEMOPM 100 TO 64 SEMUME 1024 TO 64 SHMMNI 4096 TO 2048 SEMMNI 4096 TO 2048 (UV CONFIG) MFILES 56 TO 200 T30FILE 8000 TO 200 (we have no dynamic files) FSEMNUM 101 TO 50 GSEMNUM 211 TO 97 GLTABSZ 150 TO 75 RLTABSZ 150 TO 75 MAXRLOCK 100 TO 74 Any help solving this puzzle would be greatly appreciated. Thanks, Vance Dailey -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Re: [UD] Determining if list exists
Likewise if you're using new proc you may use the original ERRMSG file indicator as HSELECT FILE WHATEVER STON HSAVE-LIST LISTNAME P IF E = 401 GO somewhere as there were no items selected. - Original Message - From: [EMAIL PROTECTED] To: U2 Users Discussion List Sent: Tuesday, February 03, 2004 9:02 AM Subject: Memo: Re: [UD] Determining if list exists Hi Chris,I believe there is the IF S or the IF #S construct that you can use in aproc to test the existence or otherwise of a select list.So if you modify your proc:HSSELECT AR WITH PAYMENT.DATE GE "2-9-04"STONPHSAVE-LIST ARLISTPHGET-LIST ARLISTSTONHPHIF #S G 10HLIST AR PAYMENT.DATE LPTRP10 O No items Selectedthat should save a few trees.cheers,asvin"Chris Bugosh" [EMAIL PROTECTED] on 03 Feb 2004 13:51Please respond to U2 Users Discussion List [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]To: [EMAIL PROTECTED]cc:bcc:Subject: [UD]Determining if list existsIs there a Unidata or Uniquery command that tells you if a select listexists? In UniBasic I can use a SelectInfo function to determine if alist exists, but I can't find a way to do it at the TCL prompt.I have the following PQN PROC. The PROC itself works fine if there issomething to return from the selection criteria. However, if nothing isselected in the SELECT statement (like the one below would if we ran ittoday), the PROC does what it is told and lists the whole file, since itis never given a list, resulting in a huge printout of every ARtransaction.HSSELECT AR WITH PAYMENT.DATE GE "2-9-04"STONPHSAVE-LIST ARLISTPHGET-LIST ARLISTSTONHPHHLIST AR PAYMENT.DATE LPTRPThanks for any suggestions you can give.Chris**This message originated from the Internet. Its originator may ormay not be who they claim to be and the information contained inthe message and any attachments may or may not be accurate.**(See attached file: C.htm)___u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ Registered in England - Number 14259 Authorised and Regulated by the Financial Services Authority Member of the HSBC Bank marketing group. We sell life assurance, pensions and collective investment schemes and advise only on our own range of these products. _This transmission has been issued by a member of the HSBC Group "HSBC" for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable butHSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. ___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: Memo: Re: [UD] Determining if list exists
In a proc you would have: PQ HSELECT SOMEFILE SAMPLE 3 P IF E = 401 G 99 HLIST SOMEFILE P 99 O No Items Selected __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] VARIABLE-1 = andBasicCompile$OPTIONSEXTRA.DELIMwork consistently
My issue was the possibility of -1ing a null value. I use -1 plenty of times if i absolutely know that the value is not null or i'm creating a log file. If i'm appending a set of associated mv'd attributes, i still DCOUNT the controlling one (one with never a null) add 1 and directly replace from there. Just my preference that hasn't hurt me. thanks. - Original Message - From: Martin Phillips [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 9:55 AM Subject: Re: [UV] VARIABLE-1 = andBasicCompile$OPTIONSEXTRA.DELIMwork consistently Mark, ...the use of a MV counter either derived or managed is clearly the best solution... Some interesting performance figures... X has 100 fields (I cannot remember how big they were for this test) X-1 = 'A' takes 100 time units X := @FM : 'A'takes 150 time units X101 = 'A' takes 9320 time units X = X : @FM : 'A' takes 9010 time units Perhaps, sometimes, X-1 is a winner! Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 ___ 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: Memo: Re: [UD] Determining if list exists
Goo'day, Are you sure the IF E = 401 bit works in UV? AFAIK, in UV, E = 0 if there are no items SELECTed, at least in Pick flavo*u*r. The 401 bit is vanilla Pick, which I remember we had to change on conversion to UV back in 9.3???. Dunno about UD, though At 10:06 04/02/04, you wrote: In a proc you would have: PQ HSELECT SOMEFILE SAMPLE 3 P IF E = 401 G 99 HLIST SOMEFILE P 99 O No Items Selected __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.211 / Virus Database: 261.8.1 - Release Date: 30/01/04 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.211 / Virus Database: 261.8.1 - Release Date: 30/01/04 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Memo: Re: [UD] Determining if list exists
The E=401 is a test to see if a process generated an ERRMSG record, item-id of 401. The ERRMSG file had its own syntax of displaying the messages with the parameters, but i'm sure it's a long lost art. Sort of like RUNOFF and BATCH. GFE (Gone ForEver). - Original Message - From: Bruce Nichol [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 6:34 PM Subject: RE: Memo: Re: [UD] Determining if list exists Goo'day, Are you sure the IF E = 401 bit works in UV? AFAIK, in UV, E = 0 if there are no items SELECTed, at least in Pick flavo*u*r. The 401 bit is vanilla Pick, which I remember we had to change on conversion to UV back in 9.3???. Dunno about UD, though At 10:06 04/02/04, you wrote: In a proc you would have: PQ HSELECT SOMEFILE SAMPLE 3 P IF E = 401 G 99 HLIST SOMEFILE P 99 O No Items Selected __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.211 / Virus Database: 261.8.1 - Release Date: 30/01/04 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.211 / Virus Database: 261.8.1 - Release Date: 30/01/04 -- 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 must admit that I usually use A[x,9] BUT a couple of times over the years it has come back and bitten me. One case was a dynamic array of item descriptions - each description was a variable length string (average of less than 100 characters) and each array would have (on average) say 10 or 20 items. So using ITEM.LIST[2,] worked fine. But then you get the user who creates a list of well over 100 longer than average descriptions and the program starts losing the last few when filing. AdrianW -Original Message- From: gerry simpson [mailto:[EMAIL PROTECTED] Sent: Tuesday, 3 February 2004 21:48 To: U2 Users Discussion List Subject: Re: VARIABLE-1 = '' Inconsistent behaviour we use the A[x,] as well as A[*,x,] constructs a lot - no trailing characters/fields - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 8:14 AM Subject: Re: VARIABLE-1 = '' Inconsistent behaviour I worked on an application that had: A=INSERT(A,1,-1;NEWVAL:@VM) and it was tricky. You should develop your own best approach to this concept of managing manual delimiters. BTW, is the -1 necessary with A=A[2,LEN(A)-1]. For that matter, could you use A=A[2,1000]. My question is if the second value in [] exceeds the length of A are there any surprising trailing characters? I've used A=A[2,10] (or some knowingly high number) with no consequences over the years. my 1 cent. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 2:09 AM Subject: RE: VARIABLE-1 = '' Inconsistent behaviour One easy way I sometimes use is to just concatenate a field mark along with the new value and then remove the first field mark at the end... eg. A = LOOP INPUT B A := @FM:B UNTIL condition REPEAT A = A[2,LEN(A)-1] AdrianW -Original Message- From: Marco Manyevere [mailto:[EMAIL PROTECTED] Sent: Tuesday, 3 February 2004 15:00 To: U2 Users Discussion List Subject: Re: VARIABLE-1 = '' Inconsistent behaviour OK the documentation for REPLACE says something about inserting empty strings. For information flavour it does say the @FM will be added for empty strings without making a distinction between adding to an empty or non empty array. If this is a feature then it implies major code revisions for me whereever I use the -1 construct. What would be the shortest/smartest way of adding strings including non significant nulls? I hate to do: A = '' INPUT B; * May be empty IF LEN(B) THEN A-1 = B END ELSE IF LEN(A) THEN A-1 = B END ELSE A = @FM END END I have also tested A1 = '' A2 = '' A3 = 3 A4 = '' A5 = 5 and it inserts the @FM as expected but this involves maintaining a counter for the dynamic array. Louis Windsor [EMAIL PROTECTED] wrote: 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 mailto:[EMAIL PROTECTED] Manyevere To: [EMAIL PROTECTED] mailto:[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 A3 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 http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk 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 _ http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.co m Yahoo! Messenger - Communicate instantly...Ping your friends today! http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.co m/download/index.html Download Messenger Now Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any
RE: Unidebugger question
In case this helps anyone else, here is what I found: I had an older version of Wintegrate installed on my workstation. When I read the system requirements for unidebugger, I noted that I had an old version, so I also installed the Dynamic Connect program which comes on the Universe Client CD. Everything worked fine. The old version of Wintegrate and Dynamic Connect seemed to co-exist, and I could run either. However, with unidebugger, it was not correctly detecting that Dynamic Connect was installed. The result was that I got a terminal window that didn't really work. I un-installed both Dynamic Connect and my old version of Wintegrate and installed a newer version of Wintegrate - and all worked well after that. Thanks for you help, ... Brad -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: January 19, 2004 9:11 AM To: [EMAIL PROTECTED] Subject: RE: Unidebugger question Brad; What type of system are you connecting to? What emulation are you using when you connect? What emulation does your host sytem think it is? Does the login script work? Does Dynamic Connect work? (You need this installed for UniDebugger to work). I recently had a client with a similar problem with SBClient. It looks like a complete uninstall (ie. uninstall, delete folders, delete registry keys) and reinstall corrected... 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: Brad Bell [mailto:[EMAIL PROTECTED] Sent: Sunday, January 18, 2004 7:31 PM To: [EMAIL PROTECTED] Subject: RE: Unidebugger question Yes, I had tried this. When the window gets focus, I can see the cursor. Also, the function keys works, but nothing else. When I do type, the keyboard make an error sound for each key pressed. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] escaping temp in dos diectory
Thanks Ray others who answered, I did in fact end up using SAVEDLISTS. ;-) The reason for using a generic file and not creating one is that 1. I don't know which account it will run in. 2. i don't want the time factor of creating a file and 3. if it can't open the file then it doesn't need to run the script. However, executing the cscript.exe command required the ampersands to be escaped. Quoting all or any part of the string in a myriad of different permutations didn't work. Whereas using the circumflex worked just fine (and it is documented at msdn - I just didn't put in the right search for combination the first time i searched :-S. execute 'dos /c cscript ^savedlists^/myscript.vbs' capturing cap Cheers, Stuart ps. the script reads some stuff from the windows registry, I don't think there's another easier way to do it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ray Wurlod Sent: Tuesday, 3 February 2004 19:31 To: U2 Users Discussion List Subject: Re: [UV] escaping temp in dos diectory TEMP can't be guaranteed to exist. It's created if, during an upgrade, items are found in VOC that are different in type to the replacement that's to be installed in VOC as part of the upgrade. If an account has never been upgraded, there won't be a TEMP file. You'd be better off choosing SAVEDLISTS, which does always exist, but which doesn't help you get over your escaping problem. You *should* be able to use double quotes around the pathname. For example: execute 'dos /c cscript temp/myscript.vbs' capturing cap But this has two pieces of grief. One is that the entire command must also be quoted (for the DOS /C command) if the command contains white space. For example: execute 'dos /C cscript temp/myscript.vbs' capturing cap You can probably fiddle around with the third quote character, for example: execute \dos /C 'cscript temp/myscript.vbs'\ capturing cap The other is that EXECUTE - under what circumstances I can't quite remember - has a tendency to strip a level of quotes. Anyway, try some of those variations. If that doesn't work, create a Type 19 file as part of the command. For example: execute 'DOS /C mkdir mytmp; cscript mytmp/myscript.vbs' capturing cap or even execute 'DOS /C mkdir mytmp; cscript mytmp/myscript.vbs; del /S mytmp' capturing cap - Original Message - From: Stuart Boydell [EMAIL PROTECTED] Date: Tue, 3 Feb 2004 15:25:33 +1100 To: U2-Users [EMAIL PROTECTED] Subject: 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 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ** 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
