[U2] Job scheduling in UniVerse

2011-09-13 Thread Martin Hlasensky
Hello, I need help with UniVerse and job scheduling. Now we have UniVerse 9.5 and System Builder 3.3.2 (SB) and I want to run process every 15 minutes. I am able schedule job once only in SB. How can I schedule periodically recurring job in UniVerse or SB? Thanks for answer Martin Hlasensky

Re: [U2] I-type Subvalue question

2011-09-13 Thread Mecki Foerthmann
That may be right but most of the examples are for single value attributes and most of the problems we face are with multi-valued ones. On 13/09/2011 02:13, Boydell, Stuart wrote: For future reference, the doc set comes with a full-text index (the .pdx file) that allows you to search (words,

Re: [U2] Job scheduling in UniVerse

2011-09-13 Thread Glenn Sallis
Hi Martin, In this situation I would create a phantom process, presuming you have enough free user licences available, as a phantom process will consume one user licence. This is a UniVerse Basic program which runs in the background and perform the actions or processes that you need to take

Re: [U2] Job scheduling in UniVerse

2011-09-13 Thread Bob Witney
Nonsense Use the unix crontab that's what its for Script it like this: ## # Invoke program EW5MINSQ in /PROD ## # echo Start of Script cd /PROD echo PHANTOM EW5MINSQ |

Re: [U2] Job scheduling in UniVerse

2011-09-13 Thread Symeon Breen
If you are on *nix use the cron, if on windows use the scheduler. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Hlasensky Sent: 13 September 2011 07:26 To: u2-users@listserver.u2ug.org Subject: [U2] Job

Re: [U2] Job scheduling in UniVerse

2011-09-13 Thread Manu Fernandes
Hi, If you start a uv from os scheduller and want to run a SBprocess ; you go to trouble ... because before running your process you must start a SBenvironment Release 5.2 introduce the SB.REMOTE.PROCESS which give ability to start a process from uv shell (then from os shell) without

Re: [U2] [UV] Adding a multi-vaue using SQL UPDATE

2011-09-13 Thread Perry Taylor
Hrm... no bites?? Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Thursday, September 08, 2011 10:11 AM To: U2 Users List Subject: [U2] [UV] Adding a multi-vaue using SQL UPDATE I have a

Re: [U2] [UV] Adding a multi-value using SQL UPDATE

2011-09-13 Thread Baker Hughes
Perry, Using the AE editor, you could create a pre-stored command that will execute in a loop. This assumes that you will append a specific string constant or same numeric value to the same field, in every record. If you need help loading a prestore, then executing in a loop, feel free to tap

Re: [U2] [UV] Adding a multi-value using SQL UPDATE

2011-09-13 Thread Perry Taylor
Yeah I figured I could do it with a prestore in the editor... I was just hoping there was away to do it using SQL. Thanks. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: Tuesday, September 13,

Re: [U2] Job scheduling in UniVerse

2011-09-13 Thread Charles Stevenson
Phantoms do not consume a UV license. Otherwise everything Glen says is right. What the others say about cron windows scheduler is fine, too. There are a couple fancy commercial scheduling products built to run under UV, too, depending on how elaborate your needs are (multiple queues,

Re: [U2] [UV] Adding a multi-vaue using SQL UPDATE

2011-09-13 Thread Charles Stevenson
None here. I've been lurking to hear the answer. Seems a reasonable request. Ask Rocket. On 9/13/2011 8:26 AM, Perry Taylor wrote: Hrm... no bites?? Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry

[U2] SkyBot Scheduler. Was: Job scheduling in UniVerse

2011-09-13 Thread Charles Stevenson
Has anyone used SkyBot Scheduler? It's a commercial non-MV-based product we're considering for non-UV reasons. If we go that route, I will also schedule UV jobs under it, too, scripting as for cron or windows scheduler as others have written. On 9/13/2011 3:52 AM, Symeon Breen wrote: If you

Re: [U2] Job scheduling in UniVerse

2011-09-13 Thread Mark Eastwood
They do in a round-about way - someone suggested using cron to start uv session every 15 minutes and launch the phantom...but to do this there must be a free uv session available to login (be it for only a second). So if all licenses are in use, is there a way to start a phantom via cron? Mark

Re: [U2] Job scheduling in UniVerse

2011-09-13 Thread Colin Alfke
We've done this for years - as long as you don't care that a program contains the login credentials for a SB user. In the login process (prior to the SB.LOGIN) we check various parameters (we run under UniData so they're a little different) and then simply data in the user and password to the

Re: [U2] Job scheduling in UniVerse

2011-09-13 Thread George Gallen
Although... If you use cron to login and run the phantom, The cron process consumes a license (for a very short time) - although the phantom does not. Also if you use cron, don't forget to check your login paragraph to handle that login Uniquely, and not try to send it to a menu or some

Re: [U2] SkyBot Scheduler. Was: Job scheduling in UniVerse

2011-09-13 Thread Steve Romanow
On Tue, Sep 13, 2011 at 10:01 AM, Charles Stevenson stevenson.c...@gmail.com wrote: Has anyone used SkyBot Scheduler? It's a commercial non-MV-based product we're considering for non-UV reasons. If we go that route, I will also schedule UV jobs under it, too, scripting as for cron or windows

Re: [U2] [UV] Adding a multi-value using SQL UPDATE

2011-09-13 Thread andy baum
Perry, You need to do this by using the Dynamic Normalisation and INSERT. INSERT INTO FILE_MVFIELD (@ID, MVFIELD) VALUES ('KEY', 'THE.NEW.VALUE') More details can be found in the SQL User Guide Chapter 5. HTH, Andy From: Perry Taylor

[U2] Start job on Universe boot under Windows

2011-09-13 Thread Wjhonson
Back in the olden times, we used to stuff things into WarmStart to make them start at boot time. Where do I stick them in Universe to make them start when Universe starts? I'd *prefer* a place that is Universe generic (will work the same under *nix or Windows).

Re: [U2] Job scheduling in UniVerse

2011-09-13 Thread Bill Haskett
I have a simple BASIC program I phantom off when Windows starts (and UD has been started). This does __NOT__ use a UD license. This program reads a UD services file for information and will logto then phantom a specific program. This is simple and home-grown and might be something you're

Re: [U2] I-type Subvalue question

2011-09-13 Thread Wols Lists
On 13/09/11 02:13, Boydell, Stuart wrote: For future reference, the doc set comes with a full-text index (the .pdx file) that allows you to search (words, phrases, etc) across all the docs in the set.

Re: [U2] Start job on Universe boot under Windows

2011-09-13 Thread Bill Haskett
I have no idea why the U2 products don't have this capability; then these things would run every time U2 starts! Instead, we have to futz around with the O/S and if we restart U2, without restarting the O/S, then these things have to be manually started. I've gotten used to the idea that if

Re: [U2] Ardent programmers

2011-09-13 Thread Wols Lists
On 09/09/11 20:53, Wjhonson wrote: By the way, I today, for the first time in my career, encountered a seasoned Pick BASIC programmer, conversant with Paragraphs, but who did not know what Proc was. Never heard of it. That could easily be true of any BASIC programmer who learnt on

Re: [U2] [UV] Adding a multi-value using SQL UPDATE

2011-09-13 Thread Perry Taylor
Wow! Thank you Andy. I was focused in on UPDATE and never thought to look into INSERT for updating an existing record. Thank you so much! Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of andy baum Sent:

Re: [U2] Ardent programmers

2011-09-13 Thread Ed Clark
could be someone who learned on unidata too. unidata supports proc, but there doesn't appear to be a manual for it (If anyone has one, can I get a copy?). If you were doing new development on unidata, you may easily never have seen a proc. On Sep 13, 2011, at 12:56 PM, Wols Lists wrote: On

Re: [U2] Start job on Universe boot under Windows

2011-09-13 Thread Symeon Breen
Not sure if it is the same with uv, but with ud - the startup script is 'startud', this is just a script and you can add commands to the bottom. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: 13

Re: [U2] Start job on Universe boot under Windows

2011-09-13 Thread Bill Haskett
Really? I could only find a startud.exe in our UDT bin directory on our Windows 2008 R2 machine, but no script. I seem to remember, in Pick, there was the user-coldstart item that always ran just after the system-coldstart, which ran just as the dbms came up. Consequently, all start

Re: [U2] Start job on Universe boot under Windows

2011-09-13 Thread John Thompson
Symeon might have been referring to the *nix world. Windows is probably a different animal. In the *nix world, you could add some additional functionality to the script that actually starts U2, which is an operating system shell script. I remember the coldstart stuff on our old Ultimate System.

[U2] 64-bit ODBC driver for win 7

2011-09-13 Thread Chris Austin
I'm running a 64-bit version of Windows 7 and trying to install the ODBC driver that came with the UniVerse 10.1 client disk but I keep getting a message when I run the INSTALL application. The error states: 'The version of this file is not compatible with the version of windows you're

Re: [U2] 64-bit ODBC driver for win 7

2011-09-13 Thread Steve Romanow
On Tue, Sep 13, 2011 at 5:17 PM, Chris Austin cjausti...@hotmail.com wrote: I'm running a 64-bit version of Windows 7 and trying to install the ODBC driver that came with the UniVerse 10.1 client disk but I keep getting a message when I run the INSTALL application. The error states: 'The

Re: [U2] 64-bit ODBC driver for win 7

2011-09-13 Thread Glenn Sallis
Hi Chris, I suggest you download the latest client software package from the Rocket site. The latest release is 11.1A which should be 64 bit windows compatible. https://u2tc.rocketsoftware.com/u2bcesdinternal.asp?pid=10037293product=UVCLIENT

Re: [U2] 64-bit ODBC driver for win 7

2011-09-13 Thread Chris Austin
Thanks Glenn, I will give this a try in the morning! Chris Date: Tue, 13 Sep 2011 23:48:26 +0200 From: u...@glennsallis.de To: u2-users@listserver.u2ug.org Subject: Re: [U2] 64-bit ODBC driver for win 7 Hi Chris, I suggest you download the latest client software package from the

Re: [U2] 64-bit ODBC driver for win 7

2011-09-13 Thread John Thompson
If you are running Universe 10, I doubt the version 11 driver will work. Let me know as I am in the same boat. I have not had time to try it. On 9/13/11, Chris Austin cjausti...@hotmail.com wrote: Thanks Glenn, I will give this a try in the morning! Chris Date: Tue, 13 Sep 2011 23:48:26

Re: [U2] I-type Subvalue question

2011-09-13 Thread Boydell, Stuart
I use the documentation search features regularly. The main document (bkshelf.pdf) and index rely on relative structure. So, if you were to scatter the documents about your system at random, then it probably wouldn't work. Keep the basic structure intact and you can move them anywhere you like.

[U2] UV 9.6.2.1/uvbackup questions

2011-09-13 Thread Bob Wyatt
I ran into a client with UniVerse 9.6.2.1 on Windows 2000 Server with SP4. It looks like uvbackup does some strange things on this system, and I'm wondering if someone may have seen this or know how to change it. The uvbackup command is essentially uvbackup -f -limit 1 -v -s logfile -t