DB2 Join Query Error: DECFLOAT

5 pts.
Tags:
IBM DB2
com.ibm.db2.jcc.a.in: Invalid character found in a character string argument of the function "DECFLOAT".. SQLCODE=-420, SQLSTATE=22018, DRIVER=3.52.95 While executing the join query in DB2 'm getting above error, how can i identify or resolve this issue, kindly help on this.

Software/Hardware used:
IBM DB2

Answer Wiki

Thanks. We'll let you know when a new response is added.

SQL Code -420 means,
A string argument did not conform to the requirements of the function. For example, a character string passed to the DECIMAL function did not conform to the rules for forming an SQL integer or decimal constant.

Verify whether you are receiving the data to correct variable.

Pradeep.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    how can i identify or resolve this issue Most likely you'll have to look at the data you are passing into a DECFLOAT function and fix the value that doesn't contain valid data. If the data space is large, you might use some binary logic. Run a query over half of the rows. If you get a failure, run again over a quarter of the rows. If you don't a failure, then run a query over a quarter from the over half. Run as many queries as needed, narrowing the rows by half each time. Tom
    125,585 pointsBadges:
    report
  • bhuvanasaairaam
    i'd experienced the same err for(if grosswt is zero then return value should be none ,else the grosswt. where the grosswt is a decimal column in the table) DECODE(BOOKING.GROSSWT,0,' ',BOOKING.GROSSWT) AS GROSSWT then i changed into DECODE(BOOKING.GROSSWT,0,NULL,BOOKING.GROSSWT) AS GROSSWT it s working for me Hope this will help to some body(i dont know the correct explanation :-) )
    10 pointsBadges:
    report
  • TomLiotta
    If the OP had shown the function the way you did, we might have been able to help. But we couldn't suggest any changes since we couldn't see what was being done. Yours is a good example of one kind of fix. -- Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following