|
On 11/08/2006, at 8:08 PM, simontcy wrote:
How can i know if the field is packed decimal (13,2) or DBCS
Read the SQL Reference--especially Appendix C. SQL Descriptor Area (SQLDA). It has the answers you seek.
midrange.com
a. packed decimal - IF LENGTH(13,2)
system only return SQLTYPE 484=Packed Decimal
SQLLEN BINARY(4) , how to
translate to integer
484/485 Packed decimal Precision in byte 1; scale in byte 2 488/489 Zoned decimal Precision in byte 1; scale in byte 2SQLLEN is a SMALLINT therefore 2 bytes. Simple division will separate the precision and scale.
b. fixed lenght - IF DBCS
system only return SQLTYPE 452=Fixed character
SQLLEN 5 how to
distinguish DBCS and SBCS
The SQLDATA field will contain the CCSID of the data. Use this to determine whether SBCS, DBCS, Mixed, or Hex.
Regards, Simon Coulter. -------------------------------------------------------------------- FlyByNight Software AS/400 Technical Specialists http://www.flybynight.com.au/ Phone: +61 3 9419 0175 Mobile: +61 0411 091 400 /"\ Fax: +61 3 9419 0175 \ / X ASCII Ribbon campaign against HTML E-Mail / \ --------------------------------------------------------------------
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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.
