Greetings!
I think you need to add a value to the db2cli.ini file on your new computer. Hopefully you can locate got a copy of the file from your old computer.
There's a configuration setting in the file that will address the data compatibility issue that's directly related to the datetime values that are stored as TEXT 26 values in IBM DB2 databases.
Hope that helps.
Best regards
Mike Ramsour
Sent: Tuesday, March 25, 2025 at 8:44 AM
From: "'Erin.Rausch' via RBASE-L" <[email protected]>
To: "RBASE-L" <[email protected]>
Subject: [RBASE-L] - Column Mismatch on SATTACH Command
From: "'Erin.Rausch' via RBASE-L" <[email protected]>
To: "RBASE-L" <[email protected]>
Subject: [RBASE-L] - Column Mismatch on SATTACH Command
Morning all,
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To view this discussion visit https://groups.google.com/d/msgid/rbase-l/4326ff68-91d7-4849-b903-bb2164d547a1n%40googlegroups.com.
Recently I had some upgrades to my computer (including going to Windows 11) and now I'm running into errors with data mismatches that I didn't have prior to that. I pull in the data using SCONNECT and use SATTACH to attach the table.
The column in the business database is a TIMESTAMP datatype and my copy of the data its TEXT(26).
Any thoughts on what to check or if there's an obscure setting I'm missing?
Thanks!
--
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To view this discussion visit https://groups.google.com/d/msgid/rbase-l/4326ff68-91d7-4849-b903-bb2164d547a1n%40googlegroups.com.
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To view this discussion visit https://groups.google.com/d/msgid/rbase-l/trinity-aecdd3fc-11fa-40d7-b1c6-319c0304512a-1742994967080%403c-app-mailcom-lxa02.
