Colin Alfke | 1 Jul 02:23 2012
Picon

Re: [U2] Problem running script from crontab


Perhaps. Anything that would have gone to the screen will go to the _PH_ record (note: if it's firing every 10
minutes you will want to automate a process to clean up the records).
You could put some CRT's in your LOGIN/program process to track it better. From a previous note it looked
like the crontab item wasn't going properly (you could also put output into your crontab script so you
could see when it runs.
It could also be as simple as surrounding the statement in quotes as per a previous suggestion - we do on Windows.
Good luck
Colin

> From: Charles_Shaffer
> Date: Thu, 28 Jun 2012 13:03:37 -0500
> Subject: Re: [U2] Problem running script from crontab
> 
> >>> The phantom command will run your login paragraph. Is it setup to 
> allow this
> >>> process to go through? There should be something in the _PH_ 
> file/folder for
> >>> when the cron fired off.
> 
> >>> hth
> >>> Colin
> 
> This is interesting.  There are files being created in the _PH_ directory 
> for each run (they are 10 minutes) apart.  But they are empty. This means 
> that something failed right off the bat right?
> 
> Charles Shaffer

 		 	   		  
(Continue reading)

John Thompson | 1 Jul 16:22 2012
Picon

Re: [U2] Problem running script from crontab

Coming late to the party...

I did not see you sourcing your shell profile or unidata linux
environment variables in your first example you posted.  You have to
do this with cron as it is not a "full" shell environment.

When you login as a regular user and get a shell prompt, several
scripts are automatically referenced before you get a shell prompt.
Probably /etc/profile and /home/user/profile.

This is not the case with cron.  You must load up all the normal linux
shell environment variables plus what is needed to run unidata in
every script you run in cron.

I also noticed you were using korn shell.  The default shell in redhat
is bash unless configured otherwise.
It might be worth giving bash scripts a shot if you have weird behavior still...
#/bin/bash
        source /home/user/.bash_profile

Then in .bash_profile call the script that loads the unidata
environment variables.

That way you are getting everything for the user and unidata loaded
for a background process to run.

I have some examples I could send you if its still misbehaving.  Hope
that helps.

On 6/30/12, Colin Alfke <alfke121 <at> hotmail.com> wrote:
(Continue reading)

Tony Gravagno | 2 Jul 01:31 2012
Picon

Re: [U2] Reasons to continue with Software vendor support

This discussion prompted me to complete another blog/article in my
series on Marketing in the Pick Industry:
http://nebula-rnd.com/blog/tech/mv/2012/07/vars1.html
I believe the services provided by resellers can be directly related
to perceptions of our industry as a whole.

Tony Gravagno
Nebula Research and Development
TG <at>  remove.pleaseNebula-RnD.com
Nebula-RnD.com/blog
Visit http://PickWiki.com! Contribute!
http://Twitter.com/TonyGravagno
http://groups.google.com/group/mvdbms/about

_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Kate Stanton | 2 Jul 05:32 2012

Re: [U2] Reasons to continue with Software vendor support

As a vendor, I have kept out of this, having a vested interest.

Nearly 30 years ago, we did an intellectual property swap with the then
owners of MANFACT, and have continued developing and supplying our product
since.  We call it Beacon for Business.

We believe the income we enjoy from our customers comes with responsibility
for supplying:

-        warranty (fixing any bugs)

-        answering questions

-        supply of continued enhancements

Enhancements include about 1,000 changes per year including:

-        VB .Net user interface
-        parameter-driven data entry, reports, forms and queries

-        upgrades driven from user wish-lists, eg barcodes

-        latest is integration with online shop floor machine monitoring
and management

If Epicor have taken over MANFACT, without taking on the responsibilities,
there is no advantage to be gained by staying with them.  Such a pity!

--

-- 
Kate Stanton
(Continue reading)

Hennessey, Mark F. | 2 Jul 15:53 2012

[U2] UniVerse LIST statement question [not-secure]

I need to do a UniVerse LIST statement that would only populate a column if the contents met certain criteria.

For example, suppose we have a file with details of telephone usage and that 3 associated mulitvalued
fields contain date call was made, duration and if the call was a toll call. Is it possible to limit the
output of the "date call made" and associated columns to a date range without that being a select criteria?
If I were to do something like:

LIST CALLS EMP.NAME EMP.LOCATION WITH DATE.CALL GE "2012-06-01" AND WITH DATE.CALL LE "2012-06-30" 
DURATION TOLL WITH  <at> ID EQ '123456'

I would get zero record if employee 123456 did not make any calls in June. What I would like to see is the
employer name and location returned with the date, duration and toll columns empty. I'm trying to do this
in a LIST statement as it will be run by U2 Web Services (and for the time being a subroutine is off the table...)

Any advice, or an authoritative "NO, It can not be done" would be greatly appreciated.

Mark Hennessey
State of Connecticut
Department of Social Services
Information Technology Services
Child Support Systems
Voice: 860-424-5261
Fax: 860-424-4813

CONFIDENTIAL INFORMATION: The information contained in this e-mail may be confidential and protected
from general disclosure. If the recipient or reader of this e-mail is not the intended recipient or a
person responsible to receive this e-mail for the intended recipient, please do not disseminate,
distribute or copy it. If you received this e-mail in error, please notify the sender by replying to this
message and delete this e-mail immediately. We will take immediate and appropriate action to see to it
that this mistake is corrected.[*LD*]
(Continue reading)

Larry Hiscock | 2 Jul 16:53 2012

Re: [U2] UniVerse LIST statement question [not-secure]

WITH will limit the selection of records based on your criteria.  WHEN will
limit the output, e.g.:

LIST CALLS EMP.NAME EMP.LOCATION DURATION TOLL '123456' WHEN DATE.CALL
BETWEEN "2012-06-01" "2012-06-30"

Larry Hiscock
Western Computer Services

-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org
[mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Hennessey, Mark
F.
Sent: Monday, July 02, 2012 6:53 AM
To: 'U2 Users List'
Subject: [U2] UniVerse LIST statement question [not-secure]

I need to do a UniVerse LIST statement that would only populate a column if
the contents met certain criteria.

For example, suppose we have a file with details of telephone usage and that
3 associated mulitvalued fields contain date call was made, duration and if
the call was a toll call. Is it possible to limit the output of the "date
call made" and associated columns to a date range without that being a
select criteria? If I were to do something like:

LIST CALLS EMP.NAME EMP.LOCATION WITH DATE.CALL GE "2012-06-01" AND WITH
DATE.CALL LE "2012-06-30"  DURATION TOLL WITH  <at> ID EQ '123456'

I would get zero record if employee 123456 did not make any calls in June.
(Continue reading)

Brian Leach | 2 Jul 17:03 2012
Picon

Re: [U2] UniVerse LIST statement question [not-secure]

Mark

Took me a couple of times reading through the post to understand the issue
.. 

I think you're going to have to call a subroutine rather than use a LIST.

Brian

-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org
[mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Hennessey, Mark
F.
Sent: 02 July 2012 14:53
To: 'U2 Users List'
Subject: [U2] UniVerse LIST statement question [not-secure]

I need to do a UniVerse LIST statement that would only populate a column if
the contents met certain criteria.

For example, suppose we have a file with details of telephone usage and that
3 associated mulitvalued fields contain date call was made, duration and if
the call was a toll call. Is it possible to limit the output of the "date
call made" and associated columns to a date range without that being a
select criteria? If I were to do something like:

LIST CALLS EMP.NAME EMP.LOCATION WITH DATE.CALL GE "2012-06-01" AND WITH
DATE.CALL LE "2012-06-30"  DURATION TOLL WITH  <at> ID EQ '123456'

I would get zero record if employee 123456 did not make any calls in June.
(Continue reading)

George Gallen | 2 Jul 17:00 2012

Re: [U2] UniVerse LIST statement question [not-secure]

How about LIST CALLS EAMP.NAME EMP.LOCATION WHEN DATE.CALL GE "2012-06-01" AND DATE.CALL LE
"2012-06-30" DURATION TOLL WITH  <at> ID EQ '123456'

In order for the When to work, it must be declared as Multivalued in the DICT of DATE.CALL, DURATION and TOLL
and most likely, need to
have the same associated link (attribute <7>) in the DICT as well.

George Gallen
Senior Programmer/Analyst
Accounting/Data Division
ggallen <at> wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com
________________________________________
From: u2-users-bounces <at> listserver.u2ug.org [u2-users-bounces <at> listserver.u2ug.org] On Behalf Of
Hennessey, Mark F. [mark.hennessey <at> ct.gov]
Sent: Monday, July 02, 2012 9:53 AM
To: 'U2 Users List'
Subject: [U2] UniVerse LIST statement question [not-secure]

I need to do a UniVerse LIST statement that would only populate a column if the contents met certain criteria.

For example, suppose we have a file with details of telephone usage and that 3 associated mulitvalued
fields contain date call was made, duration and if the call was a toll call. Is it possible to limit the
output of the "date call made" and associated columns to a date range without that being a select criteria?
If I were to do something like:

LIST CALLS EMP.NAME EMP.LOCATION WITH DATE.CALL GE "2012-06-01" AND WITH DATE.CALL LE "2012-06-30" 
DURATION TOLL WITH  <at> ID EQ '123456'
(Continue reading)

Tony Gravagno | 2 Jul 17:10 2012
Picon

Re: [U2] UniVerse LIST statement question [not-secure]

LIST CALLS '123456'
   EMP.NAME EMP.LOCATION
   DATE.CALL GE "2012-06-01" AND LE "2012-06-30"
   DURATION TOLL

?

> From mark.hennessey
> 
> I need to do a UniVerse LIST statement that would only populate a
> column if the contents met certain criteria.
> 
> For example, suppose we have a file with details of telephone usage
> and that 3 associated mulitvalued fields contain date call was made,
> duration and if the call was a toll call. Is it possible to limit
the output of
> the "date call made" and associated columns to a date range without
> that being a select criteria? If I were to do something like:
> 
> LIST CALLS EMP.NAME EMP.LOCATION WITH DATE.CALL GE "2012-06-
> 01" AND WITH DATE.CALL LE "2012-06-30"  DURATION TOLL WITH  <at> ID
> EQ '123456'
> 
> I would get zero record if employee 123456 did not make any calls in
> June. What I would like to see is the employer name and location
> returned with the date, duration and toll columns empty. I'm trying
to
> do this in a LIST statement as it will be run by U2 Web Services
(and for
> the time being a subroutine is off the table...)
(Continue reading)

Richard Wilson | 2 Jul 17:11 2012

Re: [U2] UniVerse LIST statement question [not-secure]

could you setup an index based on employee number.?

then possibly use that index against employees active for June

Rich

Hennessey, Mark F. wrote:
> I need to do a UniVerse LIST statement that would only populate a column if the contents met certain criteria.
>
> For example, suppose we have a file with details of telephone usage and that 3 associated mulitvalued
fields contain date call was made, duration and if the call was a toll call. Is it possible to limit the
output of the "date call made" and associated columns to a date range without that being a select criteria?
If I were to do something like:
>
> LIST CALLS EMP.NAME EMP.LOCATION WITH DATE.CALL GE "2012-06-01" AND WITH DATE.CALL LE "2012-06-30" 
DURATION TOLL WITH  <at> ID EQ '123456'
>
> I would get zero record if employee 123456 did not make any calls in June. What I would like to see is the
employer name and location returned with the date, duration and toll columns empty. I'm trying to do this
in a LIST statement as it will be run by U2 Web Services (and for the time being a subroutine is off the table...)
>
> Any advice, or an authoritative "NO, It can not be done" would be greatly appreciated.
>
> Mark Hennessey
> State of Connecticut
> Department of Social Services
> Information Technology Services
> Child Support Systems
> Voice: 860-424-5261
> Fax: 860-424-4813
(Continue reading)


Gmane