Re: SQL Question

Karl Hanson wrote:

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

And then you must check your job log (dspjoblog, enter, f10) to see all the
goodies debug mode has provided.
Knut

.

Relevant Pages

  • Re: SQL Question
    ... How do I run in debug mode in sql? ... Hi Tom, ... 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: C/C++ SQL CLI UPDATE problem
    ... On Aug 12, 8:21 pm, Karl Hanson wrote: ... If you are coding CLI then you're likely not also using embedded SQL, ... Also fyi - in the job where you test your program, if you can first get the job into debug mode, more detailed info may exist in job log messages. ... where in this case reason code 3 explains the journaling requirement. ...
    (comp.sys.ibm.as400.misc)
  • RE: Application.ThreadException Doesnt Work Right. Why?
    ... > Our application in debug mode doesn't link in Application.ThreadException, ... periodically I get errors (mostly SQL Server errors ... > get thrown in release mode don't get caught by Application.ThreadException ... > errors are SQL typos, ...
    (microsoft.public.dotnet.framework.windowsforms)
  • sql server not responding after building asp .net project
    ... I'm working on asp .net project,when trying to work in debug mode ... When I debuged it I saw it stuck when trying to connect to the sql ... I tried to reinstall the sql server, reinstall visual studio and .net ...
    (microsoft.public.sqlserver)