[U2] Change SCHEMA name in UniVerse SQL

2008-02-02 Thread David Jordan
Does anyone know how to change the SQL schema name for an account in UniVerse. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] PI/Open on UNIX problem

2008-02-02 Thread Jeff Fitzgerald
Bingo! Changing permissions on /var/tmp solved the problem! Henry, as always, you were spot on. Thanks a million! Jeff Fitzgerald Fitzgerald & Long, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Henry Unger Sent: Saturday, February 02, 2008 11:4

RE: [U2] UniObjects error 30105 "Unable to load subroutine on server"

2008-02-02 Thread David Jordan
Hi Wol UniObjects does not like returning unassigned variables, it causes a fatal. In the unibasic subroutine, you could check if the parameter is unassigned and set it to "" before returning. Regards David Jordan Managing Consultant --- u2-users mailing list u2-users@listserver.u2ug.org To

RE: [U2] PI/Open on UNIX problem

2008-02-02 Thread Henry Unger
Check the permissions on /var/tmp. Programs such as trace, tusc, and truss are useful for tracking down such problems. On my system, this is what happens (edited for brevity): open("/var/tmp/aaa_8ai91", O_WRONLY|O_CREAT|O_TRUNC, 0666) = 12 write(12, " p w d ", 4)= 4 writ

Re: [U2] PI/Open on UNIX problem

2008-02-02 Thread Jeff Schasny
How about permissions on the command itself. I would imagine that PI/Open is somehow opening a shell to execute the command and who knows what user its using ('nobody' perhaps). I'd try changing permissions on 'ls' to 777. Jeff Fitzgerald wrote: > I hope there are some old-timers on the list wh

[U2] PI/Open on UNIX problem

2008-02-02 Thread Jeff Fitzgerald
I hope there are some old-timers on the list who will have some thoughts about a PI/Open problem one of my clients is having. In PI/Open you can define a verb to execute O/S level commands. Here's an example: LS 0001: V 0002: ls 0003: PR The "PR" in field 3 defines the verb as a "primit

RE: [U2] by.exp when

2008-02-02 Thread Kathleené M Hunter
Try sselect FILE BY.EXP CHARGE.CODE WHEN CHARGE.CODE EQ "01" LIST FILE CHARGE.CODE This display the record every time the CHARGE.CODE equals "01". -Original Message- From: Jerry Banker [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 30, 2008 9:03 AM To: u2-users@listserver.u2ug.org

RE: [U2] [UD] problem calling program from shell script

2008-02-02 Thread Kathleené M Hunter
In the UniData Command Reference you will find the following under PHANTOM. @USER.TYPE returns the type of process currently running. There are three types of processes: - Normal terminal processes (@USER.TYPE = 0). - Background (PHANTOM) processes (@USER.TYPE = 1). - Redirected standard input (@U

RE: [U2] [UV] Selection help

2008-02-02 Thread Kathleené M Hunter
Try select VENF16 "72988359" SAVING F21 -Original Message- From: Bill Haskett [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 23, 2008 1:46 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Selection help Thanks Andy. I didn't know about this added functionality of QSELECT,

[U2] UniObjects error 30105 "Unable to load subroutine on server"

2008-02-02 Thread Anthony W. Youngman
I'm getting this error (sometimes!) when calling a subroutine. It's reproducible, and puzzling me as to what on earth is the cause. In VB, I read a record, update it and save it. That bit is working fine. I then take part of the record, and pass it to this subroutine. The weird thing is, if I

RE: [U2] RE: Switching from D3 to U2

2008-02-02 Thread Tony G
From: MAJ > So what's the number one reason for switching from D3 to U2? > Not to create an onslaught of replies, but I've worked on > many MV platforms and have my opinions on each. Might be best to just wait for George to put his notes together and post for everyone later... --- u2-users ma