Problem Note 10922: When exporting to database, field widths are not honored for blank text
fields
In the SAS Campaign Management component, the width of a text field
exported to a database table may not match the width specified in the
interface definition.
For example, if you add a field of type TEXT to an interface
definition and set the width of the field to be 20, then only enter 10
characters (including blank spaces) as the value of the TEXT field,
when the Export to database runs, the field in the resulting table
has a length of 10, not 20. Also, if you enter a value longer than 20
characters, the width column does not expand to accomodate the longer
value.
If you create a field with only 1 blank, this will be created as a null
rather than a blank. This will always be the case, even after the fix.
A Technical Support hot fix for this issue is available at:
http://ftp.sas.com/techsup/download/hotfix/cam75.html
If you are running Campaign Management with data in a DB2 database, and
you apply the hotfix, any TEXT fields added to the interface definition
with a value consisting of a single blank value are exported to the
database table as a NULL.
Even though a hotfix is available, there is still an issue where if the
text width is assigned a width of 1 character, it gets exported as a
numeric, any width over 1 character is fine.
Operating System and Release Information
| SAS System | SAS Campaign Management | Microsoft Windows NT Workstation | 7.5 | | | |
| Microsoft Windows XP Professional | 7.5 | | | |
| Microsoft Windows 2000 Professional | 7.5 | | | |
| Microsoft Windows 2000 Advanced Server | 7.5 | | | |
| Microsoft Windows 2000 Server | 7.5 | | | |
| Microsoft Windows 2000 Datacenter Server | 7.5 | | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2004-01-08 16:27:32 |
| Date Created: | 2003-09-24 15:19:33 |
