sysdate questions
Deskin, Bob
Bob.Deskin@Cognos.COM
Tue, 1 Feb 2005 14:50:17 -0500
You can't simply subtract 1 and assume it's subtracting one day. If you
do, PowerHouse treats the value as a number and literally subtracts 1.
What you need to do is to convert the date to a number of days, subtract
1 (day), and then convert back to a date as in:
date((days(sysdate) - 1)
Bob Deskin
Senior Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Viet Nguyen
Sent: February 1, 2005 2: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.