data conversion error

[Joe Boyle]

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.