SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 10922: When exporting to database, field widths are not honored for blank text fields

DetailsHotfixAboutRate It
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

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Campaign ManagementMicrosoft Windows NT Workstation7.5
Microsoft Windows XP Professional7.5
Microsoft Windows 2000 Professional7.5
Microsoft Windows 2000 Advanced Server7.5
Microsoft Windows 2000 Server7.5
Microsoft Windows 2000 Datacenter Server7.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.