Inconsistencies while inserting data into a Database -

["Sandquist, Ray" <raymond.sandquist@TRINCOLL.EDU>]

Hi All,

I have recently come across some data inconsistencies while performing
inserts into a SQL database using SQR and was hoping someone might have some
insight.

The Facts: We are currently using SQR Version 4.3.4 against SQL server 2000
running in 7.0 compatibility mode. (we've just upgraded from version 7.0 SQL
server) (The database is PeopleSoft HR Student Admin ver 7.6)

While inserting data into a table some of the data values are getting
truncated. A show statement in the SQR shows the correct value that should
be inserted.  For example:

If I insert 5 rows of data:                             The end results
might be:

row 1  value ABC                                ABC
row 2  value AB                                 A
row 3  value ABC                                A
row 4  value AB                                 AB
row 5  value AB                                 A

This problem is not unique to a specific program, and is inconsistent when
it does occur (if I truncate the data and reload, it is not the same set of
records that are getting truncated.) Has anyone ever experienced a similar
problem? Are there any compatibility issues with SQR 4.3.4 and SQL 2000? Or
with SQL 2000 running in a compatibility mode, that anyone is aware of?

I appreciate any and all responses.


Thanks

Ray Sandquist
Application/Programmer Analyst
Trinity College
Hartford,  CT 06106-3100