RE: SQL Error

Subject: Re: SQL Error

On 18 Apr 2013 08:37, Lewis, Doug wrote:

<<SNIP>> Anyone have any ideas on why it would cast into a 31 decimal
field with no significant digits? Is there a work around to force it
not to do this?

Search past messages in which I have posted with "precision rules"
for SQL. In a recent message I believe I gave newer search tokens than those for use with the newer release InfoCenter docs; I recall in old releases, the above given tokens were helpful, but they are no longer.

And FWiW, the error is unlikely any relationship to the RPG; i.e. the request should fail irrespective of language from which the SQL is requested.

--
Regards, Chuck

--
Thanks Chuck!

I ended up compiling with decresult set to a non-default value. I haven't checked but the other two methods that I could run this on were probably also set to something other than default.


Thanks Again.

Sincerely,


Doug