select rtrim(varchar_format( SU_CRGID, '999999999999999' )) as Chrg,
rtrim(varchar_format( SU_CUSID, '999999999999999' )) as CusI,
rtrim(varchar_format( SU_ACCT , '999999999999999' )) as Acct,
rtrim(varchar_format( SU_OWNID, '999999999999999' )) as OwnI
from charges
Each of the four fields is defined as 15,0 zoned decimal. Including the
implied leading sign, each of these should only take up 16 characters.
However, there's 240 blanks between each of these fields. Field 1 begins
in column 1, field 2 begins in column 257, field 3 begins in column 513,
and field 4 begins in column 769. The report is 1022 characters wide.
Frankly, I would have been happy to have a setting in STRSQL's Change
Session Attributes to set the thousands' separator to *NONE. We can set
the date and time format and separator, and the decimal point character,
but somehow no one figured we might also want suppress the thousands'
separator.
- Dan
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.
midrange.com
