Re: [U2] SOX question (United States only, I believe)

[Lance Jahnke]

What happens when the programmer is the dba? One person developing and managing 
universe...

-Original Message-
From: [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Fri Dec 09 05:49:55 2005
Subject: Re: [U2] SOX question (United States only, I believe)

Good Morning Charlie,
No only a US issue, but also an issue for multinationals with US home 
offices. We are in Argentina and have clients that must comply and frankly 
we DO separate the DBA role from the programmer role and I am in favor of 
this although it is an administrative pain at times. Programmers on these 
sites do not get access to the production data-base and only get read-only 
to the user testing environment.
Regards,
Marc Hilbert
Pick Professional Center
Buenos Aires,
Argentina.

- Original Message - 
From: "Charlie Rubeor" <[EMAIL PROTECTED]>
To: 
Sent: Thursday, December 08, 2005 6:28 PM
Subject: [U2] SOX question (United States only, I believe)


> When we started implementing Sarbanes-Oxley, I knew the question of why we
> don't separate the Database Admin role from the Programmer role would come
> up.  Has anyone on this list been able to provide a satisfactory answer to
> the auditors, without spending a lot of time explaining the benefits of an
> MV database?
>
> Charlie Rubeor
> Unix/Database Administrator
> Wiremold/Legrand
> 60 Woodlawn Street
> West Hartford, CT 06110
> Tel: 860.233.6251 x3498
> Fax: 860.523.3690
> Email: [EMAIL PROTECTED]
> Internet: www.wiremold.com
>
> [demime 1.01d removed an attachment of type image/jpeg]
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Deciphering Pick UniBasic statement

[Lance Jahnke]

IF P(2)-AR(12)<=28 THEN  
   CC=CC+1   
   INS 0 BEFORE AR(14)<1,1>  
   DEL AR(14)<1,9>   
END ELSE 
   IF AR(13)=DATE() THEN 
  CC=CC ELSE INS 1 BEFORE AR(14)<1,1>
  DEL AR(14)<1,9>
   END   
END  


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Caleb Ng
Sent: Thursday, December 08, 2005 1:11 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Deciphering Pick UniBasic statement

I'm trying to decipher and break the following IF/THEN/ELSE statement
into multiple lines because I need to add some logic into it.   Being a
PICK newbie, I'm having difficulty understanding it.  I believe this
code was ported from an old MD Pick system but I want to make sure it
behaves in a similar fashion once I break it apart.  I'm sure this will
be no problem to gurus like yourselves.

IF P(2)-AR(12)<=28 THEN CC=CC+1; INS 0 BEFORE AR(14)<1,1>; DEL
AR(14)<1,9>; ELSE IF AR(13)=DATE() THEN CC=CC ELSE INS 1 BEFORE
AR(14)<1,1>; DEL AR(14)<1,9>

Thanks in advance,


Caleb Ng
Systems Analyst
Sweetwater Authority
[EMAIL PROTECTED]
(619) 409-6763
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2][UV] Aborted Shutdown

[Lance Jahnke]

Depending on your version of UV, you should be able to have a UNIX
script call SUSPEND.FILES ON (which suspends file IO), execute a "sync ;
sync" and then do your backup. When complete, SUSPEND.FILES OFF and away
you go. Check the books before using.

If intent on shutting UV down, maybe executing a UV paragraph (as root)
that does an UNLOCK ALL and MASTER OFF ALL prior to running "uv.rc stop"
would be helpful.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Doyle
Sent: Monday, December 05, 2005 1:51 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2][UV] Aborted Shutdown

Mr. Banker:

Not manually, no. We simply call /etc/rc.d/init.d/uv.rc stop

This problem has only happened twice recently. I don't believe we're
using too many seats or anything. What makes you think licenses?

Thanks,

Mike Doyle
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Resize

[Lance Jahnke]

Maybe I will just delete the file and use OPEN/WRITESEQ and create 
flatfiles. So many options, so little time.


Louie Bergsagel wrote:


Just write a program that loops until the resize matches the
recommendations.

See if it goes forever.

*":)*
-- Louie

*Oh, sometimes programmers just want to have fun.*



On 12/1/05, Kryka, Richard <[EMAIL PROTECTED]> wrote:
>
> Original Message:
> Just noticed something strange...I RESIZE to these specs and run
> HASH.HELP.
>
> My response:
> I have noticed that HASH.HELP is strange like this on UV W2K.  You can
> end up resizing the file over and over and over because the
> recommendations, including the file type, change as you resize the file.
> Best bet is to stop after one use of HASH.HELP.
>
> Dick Kryka
> Director of Applications
> CCCS of Greater Denver, Inc.
> Paragon Financial Services
> 303-632-2226
> [EMAIL PROTECTED]
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Resize

[Lance Jahnke]

I just wrote the app and am only doing a CLEARFILE. It must be HASH.HELP 
as you suggested. Thanks Dan.


Dan Fitzgerald wrote:

I would guess that there's something in your program doing that; maybe 
it's

doing something like creating a linux file, populating it, and moving it
over the new file?

Also, HASH.HELP sometimes gets the type right, but that's about it. A 
sep of

1 is almost never a good choice, and I'm tempted to remove "almost" from
this sentence.



"Our greatest duty in this life is to help others. And please, if you 
can't

help them, could you at least not hurt them?" - H.H. the Dalai Lama

"When buying & selling are controlled by legislation, the first thing 
to be

bought & sold are the legislators" - P.J. O'Rourke

Dan Fitzgerald





>From: Lance Jahnke <[EMAIL PROTECTED]>
>Reply-To: u2-users@listserver.u2ug.org
>To: u2-users@listserver.u2ug.org
>Subject: [U2] Resize
>Date: Wed, 30 Nov 2005 12:03:03 -0600
>
>Just noticed something strange. I have a type 18 file with 25K records in
>it. HASH.HELP suggests a MOD of 4241 with a SEP of 1 - So I RESIZE to 
these
>specs and run HASH.HELP. The file stats reflect my resize changes. I 
run a

>BASIC program that clears the file and reloads my 25K records. I run
>HASH.HELP and the MOD reported back is 1973. I have been running UniVerse
>10.1.1 on RH AS3 for about 2.5 years. I dont really consider this an 
issue

>but was wondering if this is a bug. Any insight into this? Thanks.
>---
>u2-users mailing list
>u2-users@listserver.u2ug.org
>To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Resize

[Lance Jahnke]

Just noticed something strange. I have a type 18 file with 25K records 
in it. HASH.HELP suggests a MOD of 4241 with a SEP of 1 - So I RESIZE to 
these specs and run HASH.HELP. The file stats reflect my resize changes. 
I run a BASIC program that clears the file and reloads my 25K records. I 
run HASH.HELP and the MOD reported back is 1973. I have been running 
UniVerse 10.1.1 on RH AS3 for about 2.5 years. I dont really consider 
this an issue but was wondering if this is a bug. Any insight into this? 
Thanks.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Precompiler

[Lance Jahnke]

Brian, can you expand on your use of a "pre-compiler" with UV? Did you
write it? What does it do? Etc... Thanks


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach
Sent: Friday, September 30, 2005 8:18 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Good Programming Practice Question.

Susan,

You make a good point, but the problem with that approach is that it
stifles
innovation and learning - though not in your case, of course :-) 

I have known programmers who took a 'lowest common demoninator' approach
that was based on systems that were obsolete 20+ years ago, ignoring
useful
constructs because possibly they weren't supported on McDonnell Douglas
Reality kit back when they were learning  - or more likely, because
their
first manager told them not to use them because (s)he had heard they
weren't
supported 10 years earlier still.

We accuse IBM of not doing enough in R&D, and then refuse to use the
tools
they do provide for lack of compatibility (just how many UV houses out
there
actually USE the SQL or transactional functionality?)

I would rather say, be aware of the differences and isolate them ...

(In my case, I code in UniVerse as the widest feature set and use a
precompiler to handle the differences)

Brian

 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn
> Sent: 30 September 2005 13:17
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Good Programming Practice Question.
> 
> One thing that has been over-looked in this conversation is 
> the notion of 'lowest common denominator programming'.
> 
> My software runs on all MV platforms. Therefore, whenever 
> possible, I stick with syntax that works on all platforms.  
> When that is not possible, I resort to calls and includes and 
> CASE statements.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] CLEARINPUT - Universe

[Lance Jahnke]

I think you are looking for CLEARDATA


-Original Message-
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: u2-users@listserver.u2ug.org 
Sent: Thu Sep 29 11:22:26 2005
Subject: [U2] CLEARINPUT - Universe

I don't know why I cant find the CLEARINPUT statement documented.  Maybe
it was a suggestion from the group way back when.  We are working on a
program that pops up error messages.  I want to be sure that the users
see this message.  What happens a lot, is that our 'speed typers' are
about 10 strokes ahead of the program.  A lot of what they do is
redundant and they arent always in the habit of paying attention to what
is on the screen.  So, I asked the programmer working on this to put a
CLEARINPUT before the pop up messages.  This way, the error message will
have a better chance of being seen.

I have used CLEARINPUT in the past and this statement is in a handful of
existing programs.  The programmer said she had never heard of this and
when she looked in the manual and HELP BASIC CLEARINPUT.  She didn't
find anything.  So, now Im wondering - how did I find out about this ?
I looked in an old (real printed and bound) BASIC manual and I didn't
find it.  I looked in the PDF BASIC manual and I didn't find it.
Actually, it is in the reserved word list.

I would assume this is still a valid command - it does compile.

Can anyone enlighten me ?  My concern is that this could be an old
command that was replaced by something new ?  I don't want to continue
to use something that might not be supported.

Anthony
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Good Programming Practice Question.........

[Lance Jahnke]

In addition to using subroutines, when developing with UniVerse and SB+
I often have one application handle many, if not all of the screen and
report processing. This helps keep things in one place. For this I use
the ON GOSUB construct of the BASIC language. It's worth noting
depending on its application or relevance.


>I've been teaching UniBasic for over 10 years and here are some of the
>methods I teach:
>
>* Subroutines should only have one job.
>* Subroutines should be short. (less than 10 lines)
>* Subroutines should have one entrance and one exit.
>* Use meaningful variable names and subroutine names.
>* Be consistent in your naming conventions.
>* Don't hard code Numbers, Strings, or Attributes.
>* Use CASE over IF...THEN when there are more than two options.
>* Use LOOP...WHILE/UNTIL...REPEAT over FOR...NEXT with IF Conditions.
>* Use REMOVE to traverse a dynamic array.
>* Use a Simple Variable on Conditional Statements.
>* Use UniData Internal Variables whenever possible; i.e. @AM, @VM,
@DATE.
>
>Thank you,
>David A. Green
>DAG Consulting
>(480) 813-1725
>www.dagconsulting.com
>
>
>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] On Behalf Of Fawaz Ashraff
>Sent: Tuesday, September 27, 2005 8:23 AM
>To: u2-users@listserver.u2ug.org
>Subject: [U2] Good Programming Practice Question.
>
>Hi All,
>
>We are planning to train some of our new programmers
>to use good programming practices when using U2 Basic.
>I can remember in Unidata days us having some tech
>support documents that talked about this. Example such
>as when is the best time to use CASE instead IF & ELSE
>or not to use GOTO statments.
>
>I am sure some of you may have some input in this
>topic. If you have some documents, notes or thoughts
>on this, can you please share with us?
>
>When I get all the technical tips, I can compile this
>to a document and share with our new programmers as
>well as U2 listserver community.
>
>Thanks
>
>Mohamed
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] UniObjects

[Lance Jahnke]

Hello group. I have UniObjects from the 10.1a client installed on a
Winblows 2003 server running IIS version 6. I have a single ASP page
that basically connects to my UV 10.1.1 Linux (Redhat AS3) server, calls
a UV BASIC subroutine with parameters, returns to ASP and does a
"response.write html". This has been working fine for almost a year now.

I have just started to experiment with html frames where I can basically
have multiple reports on a single WEB page. Currently I have 3 panes on
a page with a report running in each pane (http call back to UniVerse
via UniObjects). * Sometimes * I will receive an ASP script error in one
of the 3 frames. Other-times this process works just fine. Considering
ASP is an industrial strength platform, I am wondering if UniObjects is
having a problem firing 3 http requests simultaneously to populate the 3
frames. Any thoughts on this?

Thanks.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] File name of the RECORDS which are listed in LIST.READU output

[Lance Jahnke]

LIST.READU EVERY will show you what you should need regarding locks.
Note the INODE number then shell to Unix/Linux and do "ls -li | grep
[inode]" this will give you a file name. 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Roberts
Sent: Thursday, August 04, 2005 8:07 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] File name of the RECORDS which are listed in
LIST.READU output

Doesn't LIST.READU DETAIL give you the file name?

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Pankaj Gupta04
Sent: Thursday, August 04, 2005 2:03 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] File name of the RECORDS which are listed in LIST.READU
output


Hi All,
I have some records which are locked. The Item ID is same. Can I get the
database filename to which the records belong?
I am using Universe at unix platform.
The output of LIST.READU is given below:

>LIST.READU

Active Record Locks:

Device Inode  Netnode Userno  Lmode   Pid Login Id
Item-ID.
  34485434  99680  55990   9 RU  9546 appsadm  GGB101031
  34485434  99640  37921  12 RU 27615 appsadm  CCB1011300764
  344854334784380  60553  17 RU  4983 appsadm  HHB1010300083
  344854334784230  36137  31 RU 29399 appsadm  GGB101031
  34485434  99690  52754  63 RU 12782 appsadm  FFB1010300015
  34485434  99910  53543 102 RU 11993 appsadm  GGB101031
  34485434  99640  50360 107 RU 15176 appsadm  GGB101031
  34485434 103910  47313 121 RU 18223 appsadm  GGB101031



Regards,

Pankaj Gupta



 CAUTION - Disclaimer *
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely
for the use of the addressee(s). If you are not the intended recipient,
please
notify the sender by e-mail and delete the original message. Further,
you are
not to copy, disclose, or distribute this e-mail or its contents to any
other
person and any such actions are unlawful. This e-mail may contain
viruses.
Infosys has taken every reasonable precaution to minimize this risk, but
is
not liable for any damage you may sustain as a result of any virus in
this
e-mail. You should carry out your own virus checks before opening the
e-mail
or attachment. Infosys reserves the right to monitor and review the
content of
all messages sent to or from this e-mail address. Messages sent to or
from
this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS End of Disclaimer INFOSYS***
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
###

This message has been scanned by F-Secure Anti-Virus.
###

This message has been scanned by F-Secure Anti-Virus.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Extra character

[Lance Jahnke]

Drew is probably correct (CR or LF). I send all my print jobs directly
to my printers using IP address and Port - I have to get rid of the
trailing CHAR(032) in the print job. Using a Linux command I can
accomplish this. "tr -d '\032'"

You can use "od -c myfile.txt" to take a look at what character is being
appended to your file and at the end of your BASIC program use tr to
strip it out. 


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Drew Henderson
Sent: Tuesday, August 02, 2005 7:58 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Extra character

Marc,

It is most likely a carriage return or newline character at the end of 
each line (don't recall which one it is.)

HTH
Drew

Caminiti, Marc wrote:

>U2 Gang
>
>I am having a problem of universe (or linux) adding an extra character
when I
>write a file out.  I have tried creating a file two different ways,
using
>WRITESEQ and WRITE to a type 19 file.
>
>Here is the code...
>
>   WRITE DEPOSIT.REQUEST ON SWITCH.FILE,'nashbar.deposit.4'
>
>or
>
>   OPENSEQ "/usr1/BN.TEST/SWITCH-FILE/nashbar.deposit.4" TO
DATA.FILE
>  WEOFSEQ DATA.FILE
>   END ELSE
>  CREATE DATA.FILE ELSE
> CRT "CAN'T CREATE"
>  END
>   END
>   WRITESEQ DEPOSIT.REQUEST ON DATA.FILE ELSE CRT "DIDN'T WRITE"
>
>Before the write, I do a CRT "A LENGTH = ":LEN(DEPOSIT.REQUEST) and the
length
>is coming out at 616.  When I look at it in Linux, it is showing a size
of
>617.
>
>[EMAIL PROTECTED] SWITCH-FILE]$ ls -l nashbar.deposit.4
>-rw-rw1 mc   users 617 Aug  1 16:24
nashbar.deposit.4
>
>[EMAIL PROTECTED] SWITCH-FILE]$ wc nashbar.deposit.4
>  1  14 617 nashbar.deposit.4
>
>Any ideas if the culprit is Linux or Universe adding the extra
character, what
>the extra character could be, and/or how to stop it from writing out,
if
>possible.  When I try to edit the filename within universe, I do not
see any
>hidden or control characters.
>
>We are running Universe 10.0.9 and Linux 7.3
>
>Thanks in advance
>Marc
>---
>u2-users mailing list
>u2-users@listserver.u2ug.org
>To unsubscribe please visit http://listserver.u2ug.org/
>  
>


-- 
--
Drew Henderson "There are two types of people -
Dir. for Computer Center Operations those who do the work and those
[EMAIL PROTECTED] who take the credit. Try to be
in the first group, there is
110 Ginger Hall less competition."
Morehead State University   Indira Ghandi
Morehead, KY  40351   
Phone: 606/783-2445   Fax: 606/783-5078
--
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Strange phenomena using EXECUTE QSELECT and DATA statements in subroutine

[Lance Jahnke]

With multi selects, you need to bail out if the first select returns zero 
records. In universe, check @SYSTEM.RETURN.CODE - if LE to zero you need to 
account for this otherwise secondary selects will run. The SYSTEM() function 
also has info related to active select info - I think SYSTEM(11) - check manual 
to be sure.

-Original Message-
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: u2-users@listserver.u2ug.org 
Sent: Sat Jul 09 17:01:57 2005
Subject: [U2] Strange phenomena using EXECUTE QSELECT and DATA statements in  
subroutine

I'm having a problem I just can't figure out a solution to.

Got a 'home made' index file with record key being a purchase order 'group
reference#' and the 2nd attribute contains an mv array of all purchase order
numbers

Am working on writing a 'lookup' subroutine that will utilize this index file.

Using commands like:

QUERY = \SELECT PO.GROUP = 'Group Reference'\
DATA \QSELECT PO.GROUP (2)\
DATA \SSELECT POF BY GROUP BY-DSND PO.DATE\

EXECUTE QUERY

Well, this works absolutely fine as long as the user enters in a group
reference# that exists.

BUT, from the first subroutine call where a user enters a group reference# that
does not exist the lookup subroutine fails from that point on to return any
results even if the user subsequently enters an existing group reference#.

I hope I explained this properly. Bottom line is - the subroutine fails forever
to return any results after the first instance where a user keys in a ref# that
does not exist even when they retry with a valid ref#.

I just don't get it. I would expect that if a user keys in a ref# that doesn't
exist the query in the subroutine merely returns no records keys - of course -
but if it is called again with a ref# that does exist I would fully expect it to
return results as it does 'the first time' it is called and an existing ref# is
entered.

joe

Joe Walter

"Live dangerously - Communicate!"

 8..7 4(())  -:&:-
-:&:-8.74 .74(())
  ((88.74  ..74  -:&:-
 ((88.74   * 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Universe

[Lance Jahnke]

Logto to uv account and type "config" without quotes.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony
Caufield
Sent: Thursday, June 30, 2005 10:36 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Universe

What is the TCL command for showing current Universe config. I cant seem
to recall I don't do it all the time. Thanks in advance.

Tony
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Barcode Label print software

[Lance Jahnke]

Take a look at Star Business Systems http://www.sbsmail.com/ - Many
years ago we used their technology to accomplish some automation in our
warehouse using RF with UniVerse and SB+ - We interfaced with UPS and
USPS and at times were shipping about 4000 packages a day. My contact
was Art Waganheim - Not sure if he is still there. If I remember
correctly, they had a server based product that ran on Winblows and the
client machines would make TCP calls to the server and utilize some form
of screen-scrape technology to complete some of the tasks for printing
barcode labels on our zebra printers. They may have what you are looking
for.



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward
Sent: Wednesday, June 22, 2005 9:56 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] Barcode Label print software

Hello,

We are doing some research on label print software.  I would love to
hear
some real-life testimonies from real users.  I've seen TL Ashford's
product,
but it has to live on an as/400.  I'm looking for something that will
live
either on our rs/6000 or a windows server.  I am envisioning a
"print-engine" that will live out on our network (or on our Unix box),
that
we can send a message to (CSV, XML, whatever), and it will take our
message,
map out the fields to the appropriate label format and print the label
or
labels to the appropriate printer (DATAMAX, Zebra, Printronix, etc).  

Some Requirements:

1. Generates an RFID encoded tag
2. Provides Vendor-Compliant label formats for major customers
(Wal-Mart,
Target, etc)
3. WYSIWYG label design
4. Supports UPS Maxicode

Nice to have:

1. Web interface

Would love to hear your experiences.  Thanks.

Ed Burwell
973-361-5400 ext. 1512
[EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Field Count from a Seq File

[Lance Jahnke]

How about :

CMD='SH -c "cat foo.txt|wc -l"'
EXECUTE CMD CAPTURING MYCOUNT
MYCOUNT=TRIM(MYCOUNT)



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, June 21, 2005 2:38 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Field Count from a Seq File

I hope someone can show me an easy way to get the number of lines from a
sequential file - without looping through the file.

I am running UV 10.x on a AIX box.

I open the file using an OPENSEQ command and I am looping through the
record using a READSEQ  command.

Either immediately after the OPENSEQ or after the first READSEQ, I would
like to know if there is more then 1 line in the file.

I know that prior to doing the OPENSEQ, I could open the file, read the
record and then DCOUNT(RECORD,@FM) to get the number of fields, close
the
file and then do a sequential open and read.  I am hoping that there is
a
system variable or something that I can use after the OPENSEQ.  Looping
through the record is not a viable option.

Thanks

Jim
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [uv]CREATE.FILE syntax for remote directories

[Lance Jahnke]

Susan, just an FYI, UniVerse does have a "mkdbfile" binary in the
$uvhome/bin directory. I execute this to create sub-files from within my
basic programs. I created a VOC entry for the binary: @ID = MKDBFILE
@RECORD = V:@FM:mkdbfile:@FM:E:@FM:VF:@FM:@FM:PICK.FORMAT then

>From my BASIC program I can EXECUTE "MKDBFILE
/mp/MPLIVE/SY.WEBWORK/":@USERNO:" 3 1301 4"



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn
Sent: Tuesday, June 14, 2005 7:20 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [uv]CREATE.FILE syntax for remote directories

You can do a full-path CREATE.FILE with Unidata, but not with Universe.
I
have been hoping that might make it to the "compatibility list".

I didn't know you could do a UNIX command and get a uv-typed (perhaps
hashed) file -- as Martin's suggestion.  What I do is create it locally
by
EXECUTING CREATE.FILE, then EXECUTE a UNIX 'mv' to push it to the
correct
location and then write down the Fpointer.

Susan Joslyn
SJ+ Systems Associates, Inc.

--

Date: Mon, 13 Jun 2005 10:41:58 +0200
From: "Manu Fernandes" <[EMAIL PROTECTED]>
Subject: [U2] [uv]CREATE.FILE syntax for remote directories

Hi all,

Question : Is there a way to specify a full path+filename  instead a 
filename in the CREATE.FILE command ?

To have files created  into other directory like the current.

Thanks for any suggestions.


Manu Fernandes
Infodata S.`r.l. 

--

Date: Mon, 13 Jun 2005 10:51:51 +0100
From: "Martin Phillips" <[EMAIL PROTECTED]>
Subject: Re: [U2] [uv]CREATE.FILE syntax for remote directories

> Question : Is there a way to specify a full path+filename  instead a
> filename in the CREATE.FILE command ?

No but the underlying operating system level program that does the
CREATE.FILE can do this.

  /usr/uv/bin/mkdbfile pathname type modulo separation
(with the appropriate path on the mkdbfile program)

It is relatively easy to wrap a bit of Basic around this and build your
own
CREATE.PATH verb.


Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
+44-(0)1604-709200
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Access Violation

[Lance Jahnke]

In the past I was told to do the following from TCL:

LIST [file_name] F1 DET.SUP (i.e. LIST VOC F1 DET.SUP)

This essentially opens and reads every record in your file and if there
is an issue with the file, it will blow-up on the screen for you to see.
In the past, for corrupt files I would attempt to copy the data from the
BAD file to a newly created file using both a TCL SELECT/COPY and
UVBASIC program READ/WRITE then rename the file from Unix etc... I have
never had good luck using the repair tools. 


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews
Sent: Monday, May 16, 2005 9:42 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Access Violation

I use fixtool rather than uvfixfile on Windows as that seems to find
more errors.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andy Moore
Sent: 16 May 2005 14:36
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Access Violation

DISCLAIMER:
This email and any files transmitted with it are confidential and
intended
solely for the use of the individual or entity to whom they are
addressed.
If you have received this email in error, please delete it and notify
the sender immediately.  Please note that there is no guarantee that
this email or any attachment is virus free or has not been intercepted
or amended.

I ran UVFIXFILE on the files used, but it didn't state that any had an
error.

Is there anything else I should try with this to check for it being
corrupt?

Thanks


Andy Moore
Selima Software Ltd.

-Original Message-
From: Adrian Matthews [mailto:[EMAIL PROTECTED] 
Sent: 16 May 2005 13:13
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Access Violation

We tend to get that error when there is a corrupted file. 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andy Moore
Sent: 16 May 2005 11:40
To: u2-users@listserver.u2ug.org
Subject: [U2] Access Violation

DISCLAIMER:
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed.
If you have received this email in error, please delete it and notify
the sender immediately.  Please note that there is no guarantee that
this email or any attachment is virus free or has not been intercepted
or amended.

Hi,

We have an application running on a Windows machine that telnets to a
Universe server (running on Windows), calls a Universe program that
changes a flag value in one of our files and then logs off. It does this
about 900 times in one night, once a month.

This worked fine until recently where the Universe program appears to
fall over and cause the whole thing to stop.

The only error we are getting is in the Windows event manager and is as
follows:


Unhandled Exception raised at address 0x00405455 : Access violation.
Attempted to read from address 0x009BF000.  Binary data is processor
CONTEXT structure

Unfortunately support say this is a general error and could be caused by
many problems.

Anyone here seen this before or have any ideas on how we could fix this?

Thanks



Andy Moore
Selima Software Ltd
Tel: 0114 2815000
Fax: 0114 281
email: [EMAIL PROTECTED]
Support: http://tracker.selima.co.uk 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


The information contained in this email is strictly confidential and for
the use of the addressee only, unless otherwise indicated. If you are
not the intended recipient, please do not read, copy, use or disclose to
others this message or any attachment. Please also notify the sender by
replying to this email or by telephone +44 (0)20 7896 0011 and then
delete the email and any copies of it. Opinions, conclusions (etc.) that
do not relate to the official business of this company shall be
understood as neither given nor endorsed by it.  IG Markets Limited and
IG Index Plc are authorised and regulated by the Financial Services
Authority and, in Australia, by the Australian Securities and
Investments Commission.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


The information contained in this email is strictly confidential and for
the use of the addressee only, unless otherwise indicated. If you are
not the intended recipient, please do not read, copy, use or disclose to
others this message or any attachment. Please also notify the sender by
replying to this email or by telephone +44 (0)20 7896 0011 and then
delete the email and any copies of it. Opinions, conclusions (etc.) that
do not relate to the official business of this company shall be
understood as neither given nor endorsed by it.  IG Markets Limited and
IG Index Plc are authorised 

Re: [U2] [UD] Increasing TCL Stack

[Lance Jahnke]

In universe its a tunable param. Maybe ud has a setting.

-Original Message-
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: 'u2-users@listserver.u2ug.org' 
Sent: Thu May 12 17:04:28 2005
Subject: [U2] [UD] Increasing TCL Stack

Greetings,
Is there anyway to increase the user stack from 49 lines when a user exits
the system?  I think I remember UniVerse was 99.  I'd like to increase this
to whatever I can if possible since there are only a few users at the TCL
level.

thanks in advance,
Paul

Paul Hruby
Police Database Coordinator
Scottsdale Police Department
*** Information sent from & received by this email address may be considered
public information ***
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] Detecting Command-line Arguments to uv

[Lance Jahnke]

As others have mentioned, you can check @SENTENCE or @COMMAND from BASIC. When
starting your APPS from Linux/Unix you can do the following:
/usr/ibm/uv/bin/uv 'RUN BP MY.PROGRAM -UX' and in your LOGIN app you can do ::
IF INDEX(@SENTENCE,'-UX',1) THEN PRINT "RUNNING FROM SHELL" ELSE PRINT BANNER






From: [EMAIL PROTECTED] on behalf of Perry Taylor
Sent: Fri 5/6/2005 17:21
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV] Detecting Command-line Arguments to uv



Is anyone aware of a way to detect if uv (uvsh) was started with any
arguments?  I want "interactive" sessions to run specific programs in
the LOGIN paragraph but suppress then if we are running some UniVerse
command from outside of the UniVerse shell.

For example

If a user runs

/usr/ibm/uv/bin/uv

I want to run a login banner program displaying information about the
account.  However, if the command is...

/usr/ibm/uv/bin/uv 'RUN BP MY.PROGRAM'

... I do *not* want to run the login banner.

I know you can detect this when the process is a phantom with IF @TTY =
phantom... but cannot find a way to detect if any arguments were
specified.

Any suggestions?

Perry Taylor
Zirmed, Inc.
502-473-7709 ext 392



CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
for
the sole use of the intended recipient(s) and may contain confidential and
privileged information.  Any unauthorized review, use, disclosure or
distribution is prohibited. ZirMed, Inc. has strict policies regarding the
content of e-mail communications, specifically Protected Health Information,
any communications containing such material will be returned to the
originating party with such advisement noted. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all copies
of
the original message.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UV on Linux

[Lance Jahnke]

I went from uv 9.4 on HPUX to 10.x.x on Red Hat AS3 in May of 2004. Had
no issues. Manually updated my uvconfig to match the one on the HP and
took a look at the newer uvconfig options. Linux kernel params were all
OK out of the box. I had to manually create my SB+ users because they
didn't want to migrate for me. I use netcat for all my printing so I
didn't have to deal with the Linux spooler either.

Things to watch for:
1.  For some reason, I had to run fnuxi many times to get all the uv
files to convert. I wrote a BASIC program to open all the files in my
VOC to make sure none were missed
2.  I had to address HPUX commands I used in uv that didn't exist in
Linux. There were only a couple

Good luck.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker
Sent: Friday, April 29, 2005 1:49 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] UV on Linux

We are finally moving our UV off our Sun Solaris 8 System and moving to
Redhat
on a Dell system. Many of you have been on Linux for awhile so tell me,
how
was your conversion? Did you have to tweak any configuration parameters?
Any
pitfalls we should know about? We usually run around 100 user sessions.

Jerry Banker
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Run a program in "Silent" mode

[Lance Jahnke]

HUSH ON / HUSH OFF in universe


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward
Sent: Wednesday, April 27, 2005 12:22 PM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] Run a program in "Silent" mode

Hello,

Is there a simple UniBasic command (kinda like ECHO OFF) that would
cause
all PRINT @(x,y) statements to be suppressed?

I have a program that prints to the screen that I want to run in an
"automatic" mode and I want it to not print to the screen.  We are on
UniData 6 - aix.  Thanks.

Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Locks, releases and STATU() (oh my)

[Lance Jahnke]

On Universe LIST.LOCKS shows task locks (i.e. LOCK 5 in UVBASIC )- I
have to use LIST.READU EVERY to get readu locks. Does UniData have a
LIST.READU command?


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn
Sent: Thursday, April 14, 2005 10:33 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Locks, releases and STATU() (oh my)

Hello wizards,

I've read what I can find on the subject, but I'm not finding what I
need.
As usual, anyone who knows where the info is, I would not be the least
bit
offended if you just point.  Or if you know off-hand ...

(Presently grappling with Unidata):

When I hit a lock with a:
READU this FROM that,ID LOCKED locked clause ELSE whatever 

LIST.LOCKS from TCL has always been worse than useless for me.  For
example
at this exact moment I'm holding locks on 3 sessions, yet if I run
LIST.LOCKS on a 4th session it displays ABSOLUTELY NOTHING.  

I don't see much on offer in the LOCKED clause, although the online help
suggests that STATUS() will return the user number of the lock it ran
into.
Can't understand its output... I have a very short program that displays
STATUS(), opens the file and displays STATUS() then does a READU against
an
item I purposefully have locked on another session and I display
STATUS()  a
third time.  What do you suppose its giving me, and what can I do with
it?

1 STATUS = 0 <-- beginning of program
2 STATUS = 1 <-- after the open
3 STATUS = 197613 <-- this is what it gives me after the READU against a
locked item

What I want to do is determine who/what has the lock, tell the user, I
also
want to be able to carry on under my own conditions when ud 46 flag is
set
which will by default allow edits to items I've locked against my own
session.  Which is too loose -- I want to check to make sure I'm in the
exact right condition to do that and I'm not sure how I can (by seeing
what
is holding the lock) but ... does anyone know how to get ANY information
out
of a lock?

Susan
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [UV] send data to IP address?

[Lance Jahnke]

All my printing is raw ASCII data as well so I use a utility called
NetCat that comes with Linux for all my printers (HP LaserJet). I don't
even bother setting the printers up in the OS (Linux). It's a small "C"
program that can be compiled on Windows or other UNIX systems. NetCat
makes reading from and writing to TCPIP ports easy.
http://netcat.sourceforge.net/ - My UniVerse printer driver looks like
this:

"cat - | unix2dos | tr -d '\032' | nc -w5 accounting 9100" (excluding
the double quotes). You should be able to use netcat (nc) in a shell
script or on the command line to accomplish what you want.

Here is the sourceforge description:

Netcat is a featured networking utility which reads and writes data
across network connections, using the TCP/IP protocol.
It is designed to be a reliable "back-end" tool that can be used
directly or easily driven by other programs and scripts. At the same
time, it is a feature-rich network debugging and exploration tool, since
it can create almost any kind of connection you would need and has
several interesting built-in capabilities.

It provides access to the following main features: 
Outbound and inbound connections, TCP or UDP, to or from any ports. 
Featured tunneling mode which allows also special tunneling such as UDP
to TCP, with the possibility of specifying all network parameters
(source port/interface, listening port/interface, and the remote host
allowed to connect to the tunnel. 
Built-in port-scanning capabilities, with randomizer. 
Advanced usage options, such as buffered send-mode (one line every N
seconds), and hexdump (to stderr or to a specified file) of trasmitted
and received data. 
Optional RFC854 telnet codes parser and responder. 

The GNU Netcat is distributed freely under the GNU General Public
License (GPL).

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of George Gallen
Sent: Friday, April 01, 2005 2:10 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] send data to IP address?

As long as the printer and system are on the same physical network, if
you
wanted to be a little safer, you could always hook up a USB ethernet
plug, give it it's own subnet, with a tight submask, and set the
zebra's server to the same subnet. This would drastically limit those
that can send to the printer, whichever method you use.

Does UV 9.6 have callhttp? If the print server is a jetdirect workalike
you can just open port 9100, send your data and close port 9100 at the
IP address, and it should print just fine.

George

Since your running windows, hooking up a single use ethernet is a snap
with USB (just something to think about).

>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] Behalf Of Barry Brevik
>Sent: Friday, April 01, 2005 2:42 PM
>To: U2-users (E-mail)
>Subject: [U2] [UV] send data to IP address?
>
>
>Running UV 9.6.1.3 on Windows 2000.
>
>Situation: We have a Zebra/Eltron barcode printer attached to
>a ZebraLink
>print server, so it appears as an IP address on our network. I
>don't really
>need a driver for this printer because I can easily send raw
>data to the
>printer and get it to do what I want.
>
>Problem: I'd like to send data to this printer directly from
>UV Basic. I
>would rather not set it up as a UV printer because I don't
>want users to see
>it and accidentally send data to it.
>
>In a CMD window, I was able to NET USE the printer (on a
>remote machine),
>and then just copy the data to my local PRN, and it works perfectly.
>
>Anybody know if there is a way to make this connection in UV
>Basic? I tried
>creating a VOC entry and doing an OPENSEQ on it but it fails.
>I've tried a
>few other things as well.
>
>TIA,
>
>Barry Brevik
>---
>u2-users mailing list
>u2-users@listserver.u2ug.org
>To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] UV 10 para Suse 9.2

[Lance Jahnke]

Don't forget the file size limitations in the PE version.


-Original Message-
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: u2-users@listserver.u2ug.org 
Sent: Sun Mar 20 13:11:42 2005
Subject: RE: [U2] UV 10 para Suse 9.2

Heh - Clif - You wandered a bit off the question by replying to a response
to the original question! No one said they *were* going to use PE
commercially! 

Short answer:
While you could probably compile PE to run under SuSE as a Proof of Concept
that it *would* run, IBM does not offer any of their commercial versions
under this version of Linux except for SuSE 7.0 for the S/390 - zSeries...

But, as you said this was a 20 user site doesn't sound like an S/390 site to
me!! And you want 9.2 to boot!!  While you MIGHT be able to get a RH-Linux
version to run under SuSE, or even the SuSE 7.0 for S/390-zSeries version to
run, you'd likely be on your own from a support stand point - totally - not
a sweet place to be if there were ever changes along the way in the
underlying Kernel or utilized components. Or the first time you had a kernel
panic and needed help, you'd be turned away.

It would be a 'never say never' issue, but I don't see IBM adding more SUSE
support without prodding since RedHat is doing so well everywhere.  But I
could be wrong! I thought New Coke was a good idea. (kidding).  I would take
your issue to IBM - if the market you are reviewing is strong, and the
changes are limited, they may be willing to take the time to certify SuSE -
right now, SuSE is **the** Linux outside the U.S. - so it's worth asking
them. Worst case, they say 'Get Lost' - you're no worse off!

DW

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver
Sent: Sunday, March 20, 2005 12:11 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UV 10 para Suse 9.2

Using the PE version commercially is a violation of the license, ie. 
against the law.

IBM might choose to have quite a bit to do with it--via their Legal
Department.


-- 

Regards,

Clif

~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER & ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
~~~


Adrian Matthews wrote:
> Universe (PE version) works on just about every distro of Linux I've
> tried seemingly without problems.
> 
> However I would never dream of using it commercially unless it was on a
> certified platform. Just imagine if it looks ok in testing and then
> starts having major problems under "Live" load. IBM would probably
> (quite rightly) have nothing to do with it.
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Marc Hilbert
> Sent: 19 March 2005 22:10
> To: u2-users@listserver.u2ug.org
> Subject: [U2] UV 10 para Suse 9.2
> 
> Good afternoon to all. My client wishes to use Suse Linux 9.2. IBM does
> not
> officially support this (perhaps will be certified during the second
> half of
> this year). Can anybody out there attest one way or another as to if
> there
> would be problems. I've seen some comments on this list of users using
> Suse
> with the UV-PE but as this would be a 20 user installation I wouldn't
> want to
> lead them down the wrong road.
> Thanks in advance,
> Marc Hilbert
> Tech. Manager
> Pick Professional Center
> Buenos Aires
> Argentina
> [EMAIL PROTECTED]
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> 
> 
> The information contained in this email is strictly confidential and for
the use of the addressee only, unless otherwise indicated. If you are not
the intended recipient, please do not read, copy, use or disclose to others
this message or any attachment. Please also notify the sender by replying to
this email or by telephone +44 (0)20 7896 0011 and then delete the email and
any copies of it. Opinions, conclusions (etc.) that do not relate to the
official business of this company shall be understood as neither given nor
endorsed by it.  IG Markets Limited and IG Index Plc are authorised and
regulated by the Financial Services Authority and, in Australia, by the
Australian Securities and Investments Commission.
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] System Builder

[Lance Jahnke]

Just SB Process and SB Process description e.g. "I*AR.MASTER*REPORT123"
and "My AR Balance Report". 

I re-posted to sbsolutions. Thanks Kevin.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
Sent: Monday, March 14, 2005 2:34 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] System Builder

Out of the box, no, there is not.  We've had discussions about this
kind of thing in months past over on SBSolutions.  When you say "what
users have access to", what does this include?  Processes?  Menu
options?  Files?  Fields?  Tools?

You might post over on the SBSolutions list, I seem to recall that
others might have done this kind of thing already, though possibly not
in the same way as your auditors may be needing.

-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Lance Jahnke
Sent: Monday, March 14, 2005 12:17 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] System Builder

Before I write my own, is there a report in SB+ that will print what
users have access to based on their group assignment? I have looked
and I don't see anything useful.

My Sarbox auditors are looking for this information. Thanks in
advance.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] System Builder

[Lance Jahnke]

Before I write my own, is there a report in SB+ that will print what
users have access to based on their group assignment? I have looked and
I don't see anything useful.

My Sarbox auditors are looking for this information. Thanks in advance.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Unidata vs SQL

[Lance Jahnke]

Traditional Sql (rdbms) doesn't support multi valies. You have to create tables 
and relationships in sql to handle what a mv database can do in one record. I 
have seen benchmarks where a mv db out performs oracle and other relational 
databases simply because you don't have the "cost of joins" in a mv db.


-Original Message-
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: u2-users@listserver.u2ug.org 
Sent: Thu Feb 24 18:27:49 2005
Subject: RE: [U2] Unidata vs SQL

We use both Unidata and SQL. I wanted to see if SQL has the equivalent
of multivalues in Unidata. Or how does SQL handle mv's for instance.

David Jordan <[EMAIL PROTECTED]> wrote:
Do you want something to justify UniData to management or for evaluation for
development purposes.

Regards
David Jordan

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave S
Sent: Friday, 25 February 2005 9:30 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Unidata vs SQL

Does anyone know where I can get a document that explains the key
differences between the Unidata and SQL database ?

__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


-
Do you Yahoo!?
 Yahoo! Mail - Find what you need with new enhanced search. Learn more.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Test

[Lance Jahnke]

Works for me


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood
Sent: Thursday, February 21, 2002 4:07 PM
To: U2-Users
Subject: [U2] Test

Hey, is this thing working today?  Seems awfully quite after for a list
that
normally gets at least 50 messages a day...

Allen
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] uv pe

[Lance Jahnke]

John, if you are using universe and have universe BASIC or TCL questions, you 
can email me offline. I would be happy to help you.


-Original Message-
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: u2-users@listserver.u2ug.org 
Sent: Thu Feb 17 17:55:34 2005
Subject: RE: [U2] uv pe

All of the manuals are available, and I have, and am pouring through
them, but there seems to be a huge amount of code examples that are
locked down. And that is only for the one thing I have looked up on
their site (ODBC). It's really frustrating when you are stuck on
something, and you see a title to a document that answers all your
questions, but can't get at it. And yes, I have read all the freely
availble info on ODBC, which got me started in the right direction, but
didn't get me all the way. 

Personally, I find the best way of learning something is to see how it
should be done. I realise these lists are a great way to finding out a
lot of that, but I would rather be able to do as much as I can, before
asking you guys to take your time to help me.  

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin P Lynch
Sent: Thursday, February 17, 2005 1:32 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] uv pe

I'm not sure what docs you are referring to , but ALL of the
documentation for UD and UV is available either online or via pdf
download on IBMs website. 
I agree that the knowledgebase should be open, but it doesn't hold tech
docs, it only holds support call information and it's generally not as
useful as the U2 and MV forums/lists.

If there's some specific documentation that you don't have, let me know
and I'll be glad to send you the link.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] UniBasic CRLF over NFS mount

[Lance Jahnke]

There should be a ux2dos or unix2dos program in the operating system you can 
use to convert cr to crlf. Example: cat foo.txt| ux2dos > new.txt ; mv new.txt 
foo.txt

You can execute this statement from your basic program etc...



-Original Message-
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: u2-users@listserver.u2ug.org 
Sent: Wed Feb 09 16:33:13 2005
Subject: [U2] UniBasic CRLF over NFS mount

I'm building a flat file in UniBasic on a unix system, then writing it
to an NFS mount point.

The file attributes are interpreted as CRLF's when I ftp the file over
to the windows system, but when I write or move the file over to the NFS
mount, the attributes are only separated by unrecognizable characters
(to notepad).

The problem is, the version of the (BarTender) application I'm upgrading
to, requires a CRLF before/after one of the attributes.

Any suggestions/thoughts?

TIA,
Amy
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Universe to Web interface

[Lance Jahnke]

I had requested this (php hooks) from IBM support. They opened
engineering Ecase 6922 - Maybe we will get it some day.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave Walker
Sent: Wednesday, February 09, 2005 2:53 PM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] Universe to Web interface

Wouldn't a php interface to U2 be nice? Then we could have LAUP instead
of
LAMP. Or some such. 

Python would be gravy too.

--
Dave Walker
8..7 4(())  -:&:-
  -:&:-8.74 .74(())
 ((88.74  ..74  -:&:-
((88.74   * Peace

 

> -Original Message-
> From: CDMI [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 09, 2005 2:27 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Universe to Web interface
> 
> 
> Will - this is what 'web servers' do.
> Good ones that are integrated with multivalue (that I know 
> of) are typically
> not free.
> 
> Steve T
> [EMAIL PROTECTED] 
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> [EMAIL PROTECTED]
> Sent: Wednesday, February 09, 2005 12:30 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Universe to Web interface
> 
> In a message dated 2/9/2005 5:34:48 AM Pacific Standard Time,
> [EMAIL PROTECTED] writes:
> 
> > I still don't get why you want to use a BAT file to do this at all.
> > IF you're using IIS, you should really be using ASP.
> 
> I don't.
> Here is what I want "From a web page, click on something, which in ANY
> fashion reaches into Universe and displays the results on 
> that web page."
> 
> Focusing on the ANY fashion, any way, any how, any method,  
> with example
> code please so I don't go insane trying to follow the 
> hand-waving.  And
> preferable I'm looking for the absolutely simplest manner of 
> doing this.
> And the free way too ... btw.
> 
> PS thanks for those of you who sent various examples of doing this.
> Will
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Universe to Web interface

[Lance Jahnke]

Will,
There seems to be two topics here. One is running UV programs from a DOS
batch file and the other is interfacing UV to IIS.

I have UniVerse PE installed on my laptop but run production on Linux. I
can open a DOS/Command prompt window and "cd \ibm\uv" then type
"bin\uvsh" and get a TCL prompt in my UV account without being prompted
for user ID or password. I can also create a directory and "uvsh" while
in the directory and setup a new UV account. In addition, I can run,
from the DOS prompt, "bin\uvsh COUNT VOC" and it works fine. For testing
purposes on your UV account or some other account you have, maybe you
should temporarily grant full control to "everyone" to eliminate Windows
security as an issue. In addition, in your UniVerse account where you
will be doing batch stuff from the command line, you will need to edit
your LOGIN VOC item and bypass all programs that require interaction
with a human. In my environment I run SB+ and so the first line of my
LOGIN VOC looks like this, "IF @LOGNAME = "uvcron" THEN GO SKIPALL". The
user "uvcron" is the account I have assigned to run all my batch jobs
(obviously through cron in Linux but the same would apply to the batch
scheduler in Windows).

I just recently interfaced IIS 6 with UniVerse 10.1.1 and the 10.1a
client using UniObjects. As someone else suggested, the Windows user
that is assigned to run the IIS services will need privileges to access
your UniVerse files and directories and you must bypass interactive
routines that exist in your LOGIN VOC as described above. I have a
single ASP page that continuously posts to itself with different
parameters. I have UniVerse generating ALL my XHTML. All my UniVerse
data is placed in XHTML tables. All processing happens in UniVerse on
the UniVerse server. Here are the processing steps:

1.  The WEB client hits the WEB site and the default ASP page that
gets called loads the user login ID into a session variable using LDAP
then calls "uvpost.asp".
2.  "uvpost.asp" is the only ASP page I have talking to UniVerse.
This page retrieves the HTTP values for these variables: "docid",
"trxtype", "imposter", "action", "key", "param", "line", "cnt",
"username" then calls my UniVerse subroutine UVWEB.SUBS passing the
appropriate variables
3.  In my UniVerse subroutine, I check TRXTYPE and if it's NULL,
which it would be initially, I default it to "MENU". Because the
uvpost.asp page passed me the LDAP user login ID, I can open and read
user and group information from my SB+ files etc... and process
accordingly. In UVWEB.SUBS I use CASE statements on TRXTYPE and branch
accordingly. I populate a dynamic array called HTML which gets passed
back to uvpost.asp and the ASP page does a response.write(html) which
presents the WEB user with a menu or report or input screen. I also use
UVWEB.SUBS for non-human processes like moving Siebel opportunity data
into UniVerse. This is accomplished with VBScript and a TRXTYPE of
"OPTYIFACE" for example
4.  The HTML that is generated by UniVerse and sent back to
uvpost.asp is imbedded with hyperlinks that call other routines in
UVWEB.SUBS by populating DOCID, TRXTYPE and the other variables as
needed.

As part of this initiative to extend UniVerse functionality to the WEB,
I have had to create utilities for keeping stuff in COMMON and managing
open files efficiently etc... With UniObjects, the UniVerse is yours.

 Here is your "Hello World" written in VBScript.
-- START --
Option Explicit
' This is a VBS (visual basic script) file
' assuming you have UniObjects loaded on your machine and
' have tested connectivity, this script will call the
' UniVerse BASIC program "UVTEST" and require 2 parameters.
' in parameter one will return "HELLO" and parameter two
' will return "WORLD" and present this text in a Windows message box.
' -  Same concept applies to ASP
'
' The UniVerse subroutine looks like this:
' SUBROUTINE TEST(P1,P2)
' P1='HELLO'
' P2='WORLD'
' RETURN
' END

public uvSession' object
public uvStatus
public uvMsg
public uvBroker

public sub uvConnect()
uvMsg=""
uvStatus=0
set uvSession=CreateObject("Uniobjects.Unioaifctrl")
if (uvSession) is nothing then
uvStatus=1
uvMsg="unable to create object for uvSession"
exit sub
end if
uvSession.UserName="uvodbc"
uvSession.Password="uvodbc"
uvSession.HostName="however.datalink.com"
uvSession.AccountPath="/mp/uvodbc"
uvSession.DataBaseType="1" ' universe
uvStatus = uvSession.Connect()
if not False then
if (uvSession.Error) <> 0 then
uvStatus=1
uvMsg="Error connecting to Server (" & uvSession.Error &
")"
set uvSession=Nothing
exit sub
end if
else
uvStatus=1
uvMsg="Error connecting to Server (" & uvSession.Error & ")"
set uvSession=Nothing

Re: [U2] Universe full screen editor

[Lance Jahnke]

C/fred^253smith/fred^253jones


-Original Message-
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: u2-users@listserver.u2ug.org 
Sent: Mon Feb 07 11:49:29 2005
Subject: [U2] Universe full screen editor

I am working on a client's Universe server with no documentation. The 
client is using software they purchased. I need to update a few records 
that have multivalues and the ED help doesn't say how I can insert or 
replace values.

Does a full screen editor come with Universe? Or is there some way to 
call a full screen editor from the operating system?

Typing listu gets me a user named "NT AUTHORITY\system". While logging 
off and back on I get the following text "Vmark Universe" and "Universe 
Command Language 9.4".

I am normally a Unidata programmer so this is a bit of a struggle.

Thank you for your assistance,
Scott Land
Senior Programmer
USA 800, Inc.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Universe account Name/ID

[Lance Jahnke]

@WHO


-Original Message-
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: U2-Users List 
Sent: Thu Jan 20 12:20:06 2005
Subject: [U2] Universe account Name/ID

Hi Folks.



I'm trying to find the simplest way to figure out which account a
program is running in, within the program.  Basically, between a
development/testing account and the live account. I've got a number of
ways to extrapolate where I am but I'm hoping that there is some system
variable that has the current account info that I can directly access
either at a TCL command or via a BASIC variable.  Also, I need to be
able to do this from both, an interactive session and from a phantom.



Environment: Win2k, Universe 10.0.15



Bob Woodward

Programmer/Analyst

Harbor Wholesale Grocery

[EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Screen to add a universe printer has too small input field to specify interface driver script

[Lance Jahnke]

ED &DEVICE& [printername]

Add the device file path to @RECORD<6> i.e. /var/spool/uv/report.drv



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rod Hills
Sent: Monday, January 17, 2005 11:46 AM
To: U2org
Subject: [U2] Screen to add a universe printer has too small input field
to specify interface driver script

I'm running a character mode terminal and when I add a new universe
printer under "SYSTEM.ADMIN", I don't have enough room to type the full
path name of the interface driver.

How can I get the full path name in.

I am running a HPUX system and a typical path might be-
/usr/spool/uv/if/shiplj4000

With SB+ you can type as much as you want in an input field and it will
scroll within the field, but I don't seem to have the ability within
universe administration.

-- Rod Hills
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Passing parameters to a paragraph?

[Lance Jahnke]

PA
SELECT AR.MASTER WITH DATE GE "<>" AND WITH DATE LE
"<>"

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak
Sent: Thursday, January 13, 2005 10:24 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Passing parameters to a paragraph?

Can you pass parameters to a paragraph the way you can with a UniBasic
program (on the command line)?  

Which manual discusses prompting for input within paragraphs with
<>?  I can't find it anywhere, and you can't search for
punctuation. :/

I usually just construct the SELECT or DOWNLOAD statement within
UniBasic and then EXECUTE it, but this one is going to be long and
complicated, and would be easier to edit as a paragraph.

Thanks,
Wendy Smoak
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] How to "exit" out mulitple loops?

[Lance Jahnke]

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
Sent: Monday, January 10, 2005 12:46 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] How to "exit" out mulitple loops?

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of George Gallen
>So the point being if a condition occurs, I want to stop
>   the x and q loops entirely, and continue on with the
>   next t iteration.

How about:

TRUE = (1 EQ 1)   ;* If not otherwise defined
FALSE = NOT(TRUE) ;* If not otherwise defined
*
DONE = FALSE
FOR T=1 TO 10
FOR Q=1 TO 6 UNTIL DONE
FOR X=1 TO 9 UNTIL DONE 
IF CONDITION THEN DONE = TRUE
NEXT X
NEXT Q
NEXT T

No extra lines (with the exception of TRUE and FALSE); just a couple
of UNTILs.

-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2][UD] How to access a particular ID in a select list

[Lance Jahnke]

SELECT XCF.SAV.TEST WITH @ID > 5
IF @SYSTEM.RETURN.CODE LE "0" THEN GO DONE
DELETE XCF.SAV.TEST
DONE:

You don't need a loop. The select statement will contain all the items
selected and the delete will delete them.



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita
Sent: Wednesday, December 08, 2004 8:54 AM
To: [EMAIL PROTECTED]
Subject: [U2][UD] How to access a particular ID in a select list

Hi,
Is there a way to access a particular ID in a select list?

I want to write a para to do the following:
Select a file with certain Ids and delete these selected records.

I was thinking of writing something like the following (to delete all
the records whose ID is greater than 5, say), but don't know what to
replace <> with in the following:

LOOP
SELECT XCF.SAV.TEST WITH @ID > 5
IF @SYSTEM.RETURN.CODE = 0 THEN GO DONE
DELETE XCF.SAV.TEST <>
REPEAT
DONE:

Is there a system variable that stores all the IDs in the select list?

Thanks
Savita.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] quiet list - American holiday weekend

[Lance Jahnke]

I chose to skip all that this year. Have any MasterPack or UniVerse questions
for me? ;-)




From: [EMAIL PROTECTED] on behalf of Susan Joslyn
Sent: Sat 11/27/2004 07:15
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [U2] quiet list - American holiday weekend



The Americans cook and stuff them selves and argue with family on Thursday
and every red-blooded American goes shopping on "black Friday".  :)

Things will be back to normal on Monday, I'm sure.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

[demime 1.01d removed an attachment of type application/ms-tnef which had a 
name of winmail.dat]
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Stopping HP Laser Printer line creep

[Lance Jahnke]

Al,

I had similar issues when moving from line printers to laser. I have UV 10.1.1
and SB+3.4 running MasterPack on Linux AS3. In my environment, I use SB to do
the printing of my shipping dockets so I don't have any BASIC programs using
PRINTER ON etc... (either SB needs to control printing or BASIC; can't be
both). So, playing with form feed settings and number of lines on the report
itself in SB+ got it working.



If you are using BASIC to do your printing (sounds like you might be), the
line creep issue I have seen in the past was either UniVerse and the BASIC
program both trying to control paging OR when I were to force a form feed I
would forget to suppress the line feed on my print statement (PRINTER ON ;
PRINT CHAR(012): ; PRINTER OFF ;PRINTER CLOSE ;*/ note colon after (012) ). If
your BASIC program is running the show, make sure the UV SETPTR issues a NO
FORMAT (i.e. SETPTR 0,80,59,0,0,1,AT PKLIST,NHEAD,NFMT,EJECT,BRIEF).



If you are seeing the output from the SETPTR command on your form, you are
probably forgetting the ",BRIEF" option which suppresses output of the command
and the prompt asking if its OK to set these parameters.



Another trick for getting rid of my line printers that were used for reports
and not forms was to change the report so that it wrote to the &HOLD& file.
When the report was done I would use BASIC to read the report and wrap it with
HTML tags:



HTML='@REPORT@'

READ REPORT FROM HOLD,'RPT':@USERNO THEN

HTML=CHANGE(HTML,'@REPORT@',REPORT)

END



If your users are using SBClient (mine are) I used the TU.DOWNLOAD and
TU.EXECUTE.SHELL to move the html to the clients PC and open the report
automatically for the user in Internet Explorer. They loved this because now
they could copy and paste report data or email the report or print to laser
using windows.



I hope some of these suggestions help.




From: [EMAIL PROTECTED] on behalf of Al DeWitt
Sent: Fri 11/19/2004 17:59
To: [EMAIL PROTECTED]
Subject: [U2] Stopping HP Laser Printer line creep



UniData 6.0.12
SB+ 5.2.4

I have a basic program that originally ran on a line printer to print
preprinted forms.  I am converting it to print on a laser.  I'm having
problem with line creep.  Each succeeding page will begin printing one
line lower than the preceding one.  I originally had a set-up string set
up in the Printer Class in SB+.  This didn't help and actually hurt
because it was cutting off the first lines of information on the second
and succeeding pages.

I tried Executing a SETPTR statement in the code, but the SETPTR
Verbiage displayed on the page if I placed it after the PRINTER ON stmt
and didn't seem to do anything when I placed it before.

I have spend way too much time on this little project.  Anybody have any
suggestions?  Going to Optio or Universe is not an option.

Al DeWitt
Stylmark, Inc.
763-574-8705
[EMAIL PROTECTED]
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

[demime 1.01d removed an attachment of type application/ms-tnef which had a 
name of winmail.dat]
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] UniVerse to Linux mySQL

[Lance Jahnke]

You could batch export (UniVerse)/import (MySQL) items nightly or use
vbscript or another scripting language that will give you access to the
uniObject components to do real-time lookups. 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of DAREN LORD
Sent: Friday, November 05, 2004 10:09 AM
To: [EMAIL PROTECTED]
Subject: [U2] UniVerse to Linux mySQL

I am a bit of novice when it comes to the UniVerse database but I am
trying to dive into it and learn as much as I can.  I am also new to the
mailing list, so my apologizes if I have gone about this the wrong way.

My problem is this:  I am running an AIX 4.3.3 with UniVerse database
10.1 installed.  I am hosting my companies website from Linux running
the osCommerce shopping cart that backends all the information in a
mySQL database.

Instead of having to type in all 250,000 items into the mySQL database,
I want to real time the lookups with our own database.  Is there a way
for mySQL to look up the tables in UniVerse, or is there a better way?

Thanks for the help
Daren Lord
[EMAIL PROTECTED]
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2][UV]telnet

[Lance Jahnke]

CMD='SH -c "telnet myserver"'
EXECUTE CMD
END
* UniVerse


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stu Glancy
Sent: Thursday, October 28, 2004 1:54 PM
To: [EMAIL PROTECTED]
Subject: [U2][UV]telnet

I want to create a telnet script from a program and execute it.  Can it 
be done?  If it can, what would the EXECUTE look like?  What would the 
script look like?  I'm looking for concept and a little detail.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Universe 9.6.2.4 and Redhat Linux Enterprise ES3

[Lance Jahnke]

I moved my company from HPUX to RH ES3 in May. I am running the same
Kernel (2.4.21-20). If I recall, the RH setting were already set so high
I didn't have to change them and therefore was able to run with the same
uvconfig file settings. There are UniVerse tunable file parameters that
should not exceed the RH OS settings but as mentioned, the RH settings
were already set so high it was a non-issue.

I am running UniVerse 10.1.1 with the MasterPack application for 70
users. Here are my uvconfig settings if you would like a guide, however,
you may not have to make any changes.

MFILES 190
T30FILE 200
OPENCHK 1
WIDE0 3e20
UVSPOOL /var/spool/uv
UVTEMP /mp/tmp
SCRMIN 3
SCRMAX 5
SCRSIZE 512
QDEPTH 16
HISTSTK 99
QSRUNSZ 2000
QSBRNCH 4
QSDEPTH 8
QSMXKEY 32
TXMODE 0
LOGBLSZ 512
LOGBLNUM 8
LOGSYCNT 0
LOGSYINT 0
TXMEM 32
OPTMEM 64
SELBUF 4
ULIMIT 128000
FSEMNUM 23
GSEMNUM 97
PSEMNUM 64
FLTABSZ 11
GLTABSZ 300
RLTABSZ 300
RLOWNER 300
PAKTIME 300
NETTIME 5
QBREAK 1
VDIVDEF 1
UVSYNC 1
BLKMAX 8192
PICKNULL 0
SYNCALOC 1
MAXRLOCK 100
ISOMODE 1
PKRJUST 0
PROCACMD 0
PROCRCMD 0
PROCPRMT 0
ALLOWNFS 1
CSHDISPATCH /bin/csh
SHDISPATCH /bin/sh
DOSDISPATCH NOT_SUPPORTED
LAYERSEL 0
OCVDATE 0
MODFPTRS 1
THDR512 0
UDRMODE 0
UDRBLKS 10
MAXERRLOGENT 100
JOINBUF 4095
64BIT_FILES 0
TSTIMEOUT 60
PIOPENDEFAULT 0
MAXKEYSIZE 255
SMISDATA 0
EXACTNUMERIC 15
MALLOCTRACING 0
CENTURYPIVOT 1930
SPINTRIES 10
SPINSLEEP 1
CONVERT_EURO 0
TERM_EURO164
SYSTEM_EURO  164
SQLNULL  128
UVNET_CONNECT   0
ALLOWMARKS   0
PICKDATE   0
PICK_MT   0
UVTSORT   1
PHANTOMSAMEUV 0
CPLOGRLS   0
BGINPUTTIMEOUT 0
TXNEXTHOLD 1
TIMEACCURACY   1

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Universe IBM
Sent: Wednesday, October 27, 2004 3:07 AM
To: [EMAIL PROTECTED]
Subject: [U2] Universe 9.6.2.4 and Redhat Linux Enterprise ES3

Hi all,

We have just recently upgraded from Redhat Linux 7.3 to Redhat Linux 
Enterprise ES3. We are still running the same version of Universe as
before 
9.6.2.4. My problem is I need to setup the uvconfig parameters to
suitable 
settings for the new operating system.

I was wondering if anyone has any advice as what to set the values for 
MFILES etc within the uvconfig file. I would also like to know what are
the 
deciding factors when setting these values?

Just incase this information is relevant...

The operating system is Redhat Linux Enterprise ES3 running the
2.4.21-20 
Kernel in SMP.

Any advice would be appreciated thxs.

_
It's fast, it's easy and it's free. Get MSN Messenger today! 
http://www.msn.co.uk/messenger
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] RE: Memresize failed

[Lance Jahnke]

Do you have the disk space for the swap/temp file that the resize command
creates?


-Original Message-
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: '[EMAIL PROTECTED]' <[EMAIL PROTECTED]>
Sent: Thu Oct 14 05:06:33 2004
Subject: [U2] RE: Memresize failed

I found it does not like the mod 181061, sep 16.  It works for a smaller
file. But don't know why.


Regards
Kafsat



-Original Message-
From: kafsat taiyus
Sent: Thursday, 14 October 2004 7:36 PM
To: '[EMAIL PROTECTED]'
Subject: Memresize failed

Hi,

We are running Unidata 5.1 on Tru64 UNIX.  We are trying to resize a 1.7GB
static file to dynamic and getting following error.

memresize TRANSACTION.DETAILS 181061,1>
Resize   TRANSACTION.DETAILS  mod(,sep) = 181061(,16)  type = -1  memory =
26214 (k)  restore
errno=27: File too large
CREATE.FILE failed.
Cannot create temp file, RESIZE failed.
memresize failed.

I have tried with different memory parameter it got the same error.  I tried
this command on a different machine it works on that machine.  Does anyone
know what the problem is and how to fix it?

Thanking you in anticipation.

Regards
Kafsat


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]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/