Re: SQL Question

tom wrote:
Thank you
How do I run in debug mode in sql?

Tom
"Knut Berg" <knutb@xxxxxxxxxxxxxxx> wrote in message news:442ce2c7@xxxxxxxxxxxxxxxxxxxx
tom wrote:

Hi
Can you explain to me why I am getting this error messge in my joblog

Select/Omit error on member OPPODTHS
Data conversion or data mapping error
Hi Tom,
double check that all your host variables are compatible with the sql
variables - including the "where" clause. If you run in debug mode it might
even tell you which column is in error.


Before calling the program containing the SQL that gets the error, do:
strdbg updprod(*yes)

--
Karl Hanson
.

Relevant Pages

  • Re: SQL Question
    ... Karl Hanson wrote: ... How do I run in debug mode in sql? ... double check that all your host variables are compatible with the sql ...
    (comp.sys.ibm.as400.misc)
  • Re: SQL Question
    ... How do I run in debug mode in sql? ... Data conversion or data mapping error ... double check that all your host variables are compatible with the sql ...
    (comp.sys.ibm.as400.misc)
  • Re: Newby - needing Help
    ... Thanks Tom - looks like i am barking up the wrong tree, ... What i have is a form with several unbound text boxes and want to copy data ... "Tom Ellison" wrote: ... The SQL code, when concatenated, reads: ...
    (microsoft.public.access.adp.sqlserver)
  • Re: mmsql - transact
    ... tom and jerry ... and apply upper if the current character ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Searching a ASP database
    ... >> Searching a database is always done in SQL. ... >> You can add more fields to your search form, like dates and one by one ... >Tom. ... Tony Jones is actually closer ...
    (microsoft.public.inetserver.asp.general)