Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

When using PROC DBLOAD APPEND with BULKCOPY=Y, along with having
different column names in SAS than in Sybase, your data may be inserted
into the wrong column.

When a different column name is seen, the data for that column is
skipped and the data for each column name after that is shifted to the
left by one column.  Here are some scenarios illustrating problems
that can occur when the names don't match:

   1) If there is a BULKCOPY=Y statement, and if the column type
matches, SAS simply skips the non-matched column, shifts the rest of the
columns left by one and leaves the last column null.  SAS doesn't issue
any error or warning messages.

   2) If there is not a BULKCOPY=Y statement, and if column types match,
SAS simply puts null values to the non-matched column and the rest of
the columns are fine. SAS doesn't issue any error or warning messages.

   3) If the column type doesn't match (for example, char vs. numeric),
SAS will issue an error message.



A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#006335

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at: