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

2005-12-09 Thread 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 o

RE: [U2] Deciphering Pick UniBasic statement

2005-12-08 Thread 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>

RE: [U2][UV] Aborted Shutdown

2005-12-05 Thread 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

Re: [U2] Resize

2005-12-02 Thread 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

Re: [U2] Resize

2005-11-30 Thread Lance Jahnke
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-

[U2] Resize

2005-11-30 Thread 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 H

[U2] Precompiler

2005-09-30 Thread 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] CLEARINPUT - Universe

2005-09-29 Thread 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 sugg

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

2005-09-27 Thread 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 appl

[U2] UniObjects

2005-09-21 Thread 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". T

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

2005-08-04 Thread 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: Thursd

RE: [U2] Extra character

2005-08-02 Thread 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 characte

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

2005-07-09 Thread 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) - ch

RE: [U2] Universe

2005-06-30 Thread 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 curr

RE: [U2] Barcode Label print software

2005-06-22 Thread 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 -

RE: [U2] Field Count from a Seq File

2005-06-21 Thread 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 C

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

2005-06-14 Thread 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 ca

RE: [U2] Access Violation

2005-05-16 Thread 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 attem

Re: [U2] [UD] Increasing TCL Stack

2005-05-12 Thread 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

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

2005-05-06 Thread 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

RE: [U2] UV on Linux

2005-04-29 Thread 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

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

2005-04-27 Thread 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 com

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

2005-04-14 Thread 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

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

2005-04-01 Thread 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 fro

Re: [U2] UV 10 para Suse 9.2

2005-03-20 Thread 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

RE: [U2] System Builder

2005-03-14 Thread Lance Jahnke
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

[U2] System Builder

2005-03-14 Thread 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.o

Re: [U2] Unidata vs SQL

2005-02-24 Thread 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

RE: [U2] Test

2005-02-21 Thread 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

Re: [U2] uv pe

2005-02-17 Thread 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 o

Re: [U2] UniBasic CRLF over NFS mount

2005-02-09 Thread 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 PROTECTE

RE: [U2] Universe to Web interface

2005-02-09 Thread 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'

RE: [U2] Universe to Web interface

2005-02-08 Thread 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

Re: [U2] Universe full screen editor

2005-02-07 Thread 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 s

Re: [U2] Universe account Name/ID

2005-01-20 Thread 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. Basicall

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

2005-01-17 Thread 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

RE: [U2] Passing parameters to a paragraph?

2005-01-13 Thread 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 pas

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

2005-01-10 Thread 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 PRO

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

2004-12-08 Thread 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

RE: [U2] quiet list - American holiday weekend

2004-11-27 Thread 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

RE: [U2] Stopping HP Laser Printer line creep

2004-11-20 Thread 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 BA

RE: [U2] UniVerse to Linux mySQL

2004-11-05 Thread 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: Fr

RE: [U2][UV]telnet

2004-10-28 Thread 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

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

2004-10-27 Thread 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 e

Re: [U2] RE: Memresize failed

2004-10-14 Thread 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