Re: Something in SQl that I assumed woulld work -- MIDRANGE-L

Subject: Re: Something in SQl that I assumed woulld work
From: Buck Calabro <kc2hiz@xxxxxxxxx>
Date: Mon, 8 May 2017 16:04:28 -0400
List-archive: <http://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

On 5/8/2017 3:41 PM, Alan Shore wrote:

It looks like it had to be - but surely '0049' is already cast as CHAR 4

Obviously not, but looking at what I had wrote (written?) it WAS char 4

Character literals are VARCHAR().
Unfortunately, DB2 doesn't promote CHAR to VARCHAR.
When DB2 tries to locate a function or procedure, it doesn't only use
the name to find it; it uses the name AND the parameters passed. So in
this case, you had the name right, but not the parameter, so DB2 said
'No function found'.

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.