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 o
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>
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
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
p 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-
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 H
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:
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 sugg
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 appl
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". T
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: Thursd
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 characte
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) - ch
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 curr
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 -
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 C
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 ca
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 attem
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
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
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
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 com
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
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 fro
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
m: [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 h
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.o
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
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
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 o
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 PROTECTE
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'
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
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 s
@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. Basicall
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
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 pas
-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 PRO
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
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
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 BA
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: Fr
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
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 e
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
45 matches
Mail list logo