bcp with syslogins

If you try to use bcp to copy data into syslogins from an earlier version of Adaptive Server, it may fail due to additional columns that were added in Adaptive Server 12.5.

To use bcp to copy data into a 12.5. version of syslogins, you can create a dummy table to hold the data, add two columns to this dummy table, and then copy the data into the 12.5 syslogins.

NoteThis issue may also occur with other system tables that have added columns. You might encounter the problem first with syslogins if you need to copy this data as part of the upgrade.

See What’s New in Adaptive Server Enterprise? for changes to system tables in Adaptive Server releases.