sysdate questions
Fyfield, Derek
DEREK.FYFIELD@orbit.net
Wed, 2 Feb 2005 09:09:26 +0300
Viet,
You can get PH to manipulate the DATE variables within the date functions.
I would use ...
Define xdate date century included = date(-1,sysdate)
The function DATE adds "-1" days to the value of sysdate with due regard for
the calendar.
Regards,
Derek in Bahrain
-----Original Message-----
From: Viet Nguyen [mailto:VNguyen@wsboces.org]
Sent: Tuesday, February 01, 2005 10:35 PM
To: powerh-l@lists.sowder.com
Subject: sysdate questions
Hello - please help me with this
I am assigning sysdate - 1 to a variable and it's returning 0
today (2/1/2005)
define xdate date century included = sysdate - 1
*** xdate returned 0
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Knox, Dave
(Dallas, CSC)
Sent: Wednesday, January 26, 2005 10:03 AM
To: powerh-l@lists.sowder.com
Subject: RE: data conversion error
Unfortunately "11A" (for example) would still be valid in this select,
but
still produce a Data Conversion Error using NCONVERT. (Of course
assuming
you have non-numeric data in one of your fields - my guess anyway).
Ultimately you'd need to select out with a matchpattern.
select if matchpattern(distr_ref[9:3],"###")
Or use "not matchpattern" logic to hunt down the bad data.
Regards
Dave Knox
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Joe Boyle
Sent: Tuesday, January 25, 2005 5:44 PM
To: 'Viet Nguyen'; powerh-l@lists.sowder.com
Subject: RE: data conversion error
Oops, the syntax would have to be something like that below, or you will
simply get more of the same error :-)
select if ("000" le distr_ref[9:3] ) &
and ("999" ge distr_ref[9:3])
and I had my gt's and lt's the wrong way round.
Regards, Joe.
-----Original Message-----
From: Joe Boyle [mailto:atla38@dsl.pipex.com]
Sent: 25 January 2005 23:38
To: 'Viet Nguyen'; 'powerh-l@lists.sowder.com'
Subject: RE: data conversion error
from where you are now the simplest would be to use the code below,
access *xbanks &
link bank of xbanks &
viaindex bank_checknum to tbbankcheck &
link (bank of tbbankcheck, checknum of tbbankcheck, &
checkcode of tbbankcheck, "B") &
viaindex check_ref to tbbankcdistr
select if (0 ge nconvert(distr_ref[9:3]) ) &
and (999 le nconvert(distr_ref[9:3]))
set sub name xbanks_2
rep summ 'list of key items required by quiz below',
access *xbanks_2 &
link (nconvert(distr_ref[9:3])) &
viaindex object to tbobject &
link check_payee of tbbankcdistr &
viaindex vendor to vendor optional
Otherwise you can use qtp edit verbs to identify problem records, or you
can
use code like that in quiz1 above but with select below,
select if not ((0 ge nconvert(distr_ref[9:3]) ) &
and (999 le nconvert(distr_ref[9:3])) )
report 'record identifiers'
you can also use matchpattern, but I can't recall the syntax off hand.
There
is also the qtp trace syntax.
Regards, Joe.
This e-mail and all information contained in it is confidential and may
be
legally privileged. If you are not the intended recipient, your access
to
this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the
sender
promptly by e-mail that you have done so. The content of this e-mail and
any
attachments sent with it may have been altered without the consent or
knowledge of the author.
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Viet Nguyen
Sent: 25 January 2005 22:39
To: powerh-l@lists.sowder.com
Subject: data conversion error
Hi I need some help with debugging (powerhouse 8.13 on AIX)
Here is the code:
> access *xbanks &
> link bank of xbanks &
> viaindex bank_checknum to tbbankcheck &
> link (bank of tbbankcheck, checknum of tbbankcheck, &
> checkcode of tbbankcheck, "B") &
> viaindex check_ref to tbbankcdistr &
> link (nconvert(distr_ref[9:3])) &
> viaindex object to tbobject &
> link check_payee of tbbankcdistr &
> viaindex vendor to vendor optional
I am getting error with the last link (Data conversion Error) how do I
determine which records is causing the error???? Any tracer settings?
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Hasse, Christina
Sent: Monday, January 24, 2005 5:02 PM
To: powerh-l@lists.sowder.com
Subject: [HP3000-L] Business Analyst opportunity
Job opportunity that includes PowerHouse knowledge........
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:HP3000-L@RAVEN.UTC.EDU] On
Behalf Of Simpkins, Terry
Sent: Monday, January 24, 2005 3:44 PM
To: HP3000-L@RAVEN.UTC.EDU
Subject: [HP3000-L] Business Analyst opportunity
Measurement Specialties, Inc, has an immediate opening for a senior
business analyst.
The ideal candidate will have at least 4 years experience working with
and supporting MANMAN-HP in a discrete manufacturing
environment. They will also have a solid grasp of the Cognos POWERHOUSE
tool set.
The successful candidate will join our ISIT department and help provide
systems support for all aspects of our
MANMAN-HP system, as well as play a major role in various implementation
and process improvement projects at
our sites around the world. Besides the USA, we have locations in
China, France and Germany. Current projects include ground-up
implementations in France and Germany, as well as automating numerous
business processes and implementing several "bolt-on" products from
third-parties. The individual selected will be a fast learner who is
self motivated and able to work both independantly and as a part of a
multi-discipline team.
The ability to travel internationally is a requirement.
Measurement Specialties is a growing supplier of sensor technology to a
wide variety of business segments. We are a world leader in pressure,
displacement, inclination and load cell sensors. We are actively
expanding through both organic growth and acquisition. We offer a
competitive compensation package that includes a 401-K program and
a performance based bonus program.
If you are interested in joining a growing, prospering team, forward
your resume with salary requirements to:
Terry W. Simpkins
Director ISIT
Measurement Specialties
757-766-4278
terry.simpkins@msiusa.com
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
This message may contain privileged and/or confidential
information. If you have received this e-mail in error or are not the
intended recipient, you may not use, copy, disseminate or distribute it;
do not open any attachments, delete it immediately from your system and
notify the sender promptly by e-mail that you have done so. Thank you.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
This message and any attachments (the 'message') is intended solely for the
addressees and is confidential. If you receive this message in error, please
delete it and immediately notify the sender. Any use not in accord with its
purpose, any dissemination or disclosure, either whole or partial, is
prohibited, except with formal approval. The Internet cannot guarantee the
integrity of this message. Orbit (and its subsidiaries) shall therefore not
be liable for the message, if modified. Orbit accepts no liability for any
damage caused by any error or virus transmitted by this email.