RE: [U2] RE: Switching from D3 to U2
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 mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniObjects error 30105 Unable to load subroutine on server
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 update in VB any of the data that I pass to the subroutine, the call works fine. If I don't update it, the call fails. So, basically, what I'm doing is getting a UvDynArray from UV, updating it in a form, recreating the array and writing it back. All fine. I then create a new UvDynArray and pass it to this subroutine. If any of the data in this new array has changed from what was originally read the call works fine. If it hasn't changed, the call fails! Has anybody got any ideas what the problem could be (or how to diagnose it?) Is there any way to find out why the call failed? Cheers, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Selection help
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, as SELECT has always worked in D3 and other PICK flavors. I understand UniData syntax would be: :QSELECT VENF16 72988359 (21 Consequently, I figured SELECT was a much more portable verb. But then, I never use PI/OPEN flavor. Thanks again, Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Lakeland Sent: Wednesday, January 23, 2008 6:13 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Selection help Hi Bill, BSELECT does not exist on UV. (which was your original question) QSELECT does select all attributes UNLESS you specify the field. Check the example I sent Bill, SAVING !!! Example LIST VENF16 72988359 F21 VENF16F21... 72988359 T13219224 T13219226 T13219227 QSELECT VENF16 72988359 SAVING 21 3 record(s) selected to SELECT list #0. Only the 3 MV value are selected. Regards Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: 23 January 2008 13:38 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Selection help Andrew: I believe I meant BSELECT. QSELECT is used to build a list of all attributes in a record. In UniData, to get a select list of the contents of an attribute you would: :BSELECT LOOKUP.TABLE XYZ CODE In D3 you'd simply: :SELECT LOOKUP.TABLE 'XYZ' CODE Then you'd have to mess around with saving a list then getting a list with the (u option to remove redundant codes. According to the UV documentation, and a couple of tests, you can: :SELECT LOOKUP.TABLE 'XYZ' CODE {n} record(s) selected to SELECT list #0. :SELECT SomeFile SAVING UNIQUE @ID An example looks like: 3260 Dtademo (0)- LIST PAYSAL 04:21:07am 23 Jan 2008 PAGE1 PAYSAL.. EMPLOYEE NAME. %HRS ACCT. AMOUNT.. CLNT TYP CY AK*115 SMITH, THOMAS J 90 2010 1,525.00 770 REG M 10 2030 1,525.00 770 REG 1 records listed. 3260 Dtademo (0)- SELECT PAYSAL 'AK*115' CLIENTNO 2 record(s) selected to SELECT list #0. 3260 Dtademo (0) SELECT MASTER SAVING UNIQUE CLIENTNO 1 record(s) selected to SELECT list #0. 3260 Dtademo (0) LIST MASTER LIST MASTER 04:24:43am 23 Jan 2008 PAGE1 MASTER NAME.. #UNITS 770308 114 1 records listed. Sorry that this won't do any good if the codes (or a I-descriptor contatenation of them) don't exist as @IDs in another file. I don't know what to do then. Hope this helps. Bill --- 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] problem calling program from shell script
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 (@USER.TYPE = 2). Kathleene M Hunter Resolution Provider -Original Message- From: Kevin King [mailto:[EMAIL PROTECTED] Sent: Saturday, January 26, 2008 7:49 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UD] problem calling program from shell script @USER.TYPE = 2 is new to me. The documentation describes it as Redirected Standard Input which makes me think that yes, that could definitely change the mechanics of starting a phantom. On Jan 25, 2008 11:00 AM, [EMAIL PROTECTED] wrote: How is MT.PROC starting MT.WATCH? I wish I knew. That's part of my problem since both MT.PROC and MT.WATCH are 3rd party software. One more clue that may make your question irrelevant: in a successful, non-scripted run, the phantoms start up before MT.WATCH starts displaying status. This might mean that the issue lies in MT.PROC instead. I've started looking at @USER.TYPE. Is there any UniData reason @USER.TYPE = 2 would cause a phantom not to start? My tests suggest No, but would like confirmation. Brad U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- -Kevin 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] by.exp when
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 Subject: RE: [U2] by.exp when Try selecting without the BY.EXP. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 30, 2008 8:48 AM To: u2-users@listserver.u2ug.org Subject: [U2] by.exp when Yes, sorry make that 001 D 002 1 003, 004 blank 005 10R 006 M And it still doesn't work. - Original Message - From: DAWES, Ray Date: Wednesday, January 30, 2008 9:07 am Subject: RE: [U2] by.exp when To: u2-users@listserver.u2ug.org Surely field 2 of the dictionary should have the location in the file - a number. Ray Dawes -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Roger GlenfieldSent: 30 January 2008 12:29 To: u2 Subject: [U2] by.exp when Universe version 9.5 Prime Flavor Dictionary CHARGE.CODE 001 D 002, 003, 004 blank 005 10R 006 M SORT FILE BY.EXP CHARGE.CODE WHEN CHARGE.CODE EQ 01 finds zero recordsand there are lots of records where one of the multi- values = 01 I've also tried the old Pick flavor SORT FILE BY.EXP CHARGE.CODE EQ 01 without any luck. Any other thoughts or does Prime flavor Retrieve just not deal with by.exp like the Pick Ideal versions? Thanks all. Roger --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the confidential use of the above named recipient. If you are not the intended recipient or person responsible for delivering it to the intended recipient, you have received this communication in error and must not distribute or copy it. Please accept the sender's apologies, notify the sender immediately by return e-mail and delete this communication. Thank you. --- 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/
[U2] PI/Open on UNIX problem
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 primitive; i.e. an O/S level command. Problem is that when any user other than root executes the command (or any other primitive) it fails and puts this sort of warning into the PILOG file: # cat WARN.26835 [PI/open Rev. 3.7.6] [Copyright (c) 1992 Prime Computer, Inc.] [Copyright (c) 1994 VMark Software, Inc.] User name : jaftest PI User number : 12 Process ID : 10934 Hostname : dtcc271 ISYS pathname : /u/isys VOC pathname : ./VOC ACCOUNT path : /u/isys WARN.26835 logged at Thu Jan 31 17:01:38 2008 *** Status 13 (OS: Permission denied), severity WARNING Detected by the DISKIO subsystem in fds_os_open at location 3. Called from fds_open at location 4. *** Status 13 (OS: Permission denied), severity WARNING Detected by the DISKIO subsystem in fds_os_open at location 3. Called from fds_open at location 4. The warning implies a permissions problem; but all the components to the user account, including the VOC, have permissions of 777 (read/write/execute) for everyone. At the UNIX level there is no problem executing the command, so this is a PI/Open issue. The problem occurs across the board, in all accounts. I've set 777 permissions on everything in the isys directory as well. Feels like some sort of PI/Open security thing... If anyone has thoughts I'd sure appreciate it! Jeff Fitzgerald Fitzgerald Long, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PI/Open on UNIX problem
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 write(12, \n e c h o $ ?/ v.., 28) = 28 close(12) = 0 fork() open(/var/tmp/baaa9ai91, O_RDONLY)= 12 read(12, 0\n, 2048) = 2 close(12) = 0 unlink(/var/tmp/aaa_8ai91)= 0 unlink(/var/tmp/baaa9ai91)= 0 Henry Henry P. Unger Hitech Systems, Inc. [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Fitzgerald Sent: Saturday, February 02, 2008 09:41 To: u2-users@listserver.u2ug.org Subject: [U2] PI/Open on UNIX problem 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 primitive; i.e. an O/S level command. Problem is that when any user other than root executes the command (or any other primitive) it fails and puts this sort of warning into the PILOG file: # cat WARN.26835 [PI/open Rev. 3.7.6] [Copyright (c) 1992 Prime Computer, Inc.] [Copyright (c) 1994 VMark Software, Inc.] User name : jaftest PI User number : 12 Process ID : 10934 Hostname : dtcc271 ISYS pathname : /u/isys VOC pathname : ./VOC ACCOUNT path : /u/isys WARN.26835 logged at Thu Jan 31 17:01:38 2008 *** Status 13 (OS: Permission denied), severity WARNING Detected by the DISKIO subsystem in fds_os_open at location 3. Called from fds_open at location 4. *** Status 13 (OS: Permission denied), severity WARNING Detected by the DISKIO subsystem in fds_os_open at location 3. Called from fds_open at location 4. The warning implies a permissions problem; but all the components to the user account, including the VOC, have permissions of 777 (read/write/execute) for everyone. At the UNIX level there is no problem executing the command, so this is a PI/Open issue. The problem occurs across the board, in all accounts. I've set 777 permissions on everything in the isys directory as well. Feels like some sort of PI/Open security thing... If anyone has thoughts I'd sure appreciate it! Jeff Fitzgerald Fitzgerald Long, 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] PI/Open on UNIX problem
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 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: [snip] Jeff Schasny - Denver, Co, USA IT Wrangler jschasny at gmail dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects error 30105 Unable to load subroutine on server
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 unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PI/Open on UNIX problem
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:48 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] PI/Open on UNIX problem 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 write(12, \n e c h o $ ?/ v.., 28) = 28 close(12) = 0 fork() open(/var/tmp/baaa9ai91, O_RDONLY)= 12 read(12, 0\n, 2048) = 2 close(12) = 0 unlink(/var/tmp/aaa_8ai91)= 0 unlink(/var/tmp/baaa9ai91)= 0 Henry Henry P. Unger Hitech Systems, Inc. [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Fitzgerald Sent: Saturday, February 02, 2008 09:41 To: u2-users@listserver.u2ug.org Subject: [U2] PI/Open on UNIX problem 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 primitive; i.e. an O/S level command. Problem is that when any user other than root executes the command (or any other primitive) it fails and puts this sort of warning into the PILOG file: # cat WARN.26835 [PI/open Rev. 3.7.6] [Copyright (c) 1992 Prime Computer, Inc.] [Copyright (c) 1994 VMark Software, Inc.] User name : jaftest PI User number : 12 Process ID : 10934 Hostname : dtcc271 ISYS pathname : /u/isys VOC pathname : ./VOC ACCOUNT path : /u/isys WARN.26835 logged at Thu Jan 31 17:01:38 2008 *** Status 13 (OS: Permission denied), severity WARNING Detected by the DISKIO subsystem in fds_os_open at location 3. Called from fds_open at location 4. *** Status 13 (OS: Permission denied), severity WARNING Detected by the DISKIO subsystem in fds_os_open at location 3. Called from fds_open at location 4. The warning implies a permissions problem; but all the components to the user account, including the VOC, have permissions of 777 (read/write/execute) for everyone. At the UNIX level there is no problem executing the command, so this is a PI/Open issue. The problem occurs across the board, in all accounts. I've set 777 permissions on everything in the isys directory as well. Feels like some sort of PI/Open security thing... If anyone has thoughts I'd sure appreciate it! Jeff Fitzgerald Fitzgerald Long, 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Change SCHEMA name in UniVerse SQL
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/