OpenEdge SQL ODBC shows different column size than native ABL does
I'm using the Progress OpenEdge ODBC driver (peoe27.dll v07.16.0175) to push data into an OpenEdge database. I had a situation where a user put in a string value that was 54 characters long, which got rejected during the update because it exceeded the defined column size of 50, as visible in the second image below.
The legacy system admin then sent me a screen shot showing that, as far as ABL was concerned, the width on that same column in that same table was 200 characters. (see the first image)
Anyone have an explanation? (Other than that ABL and OpenEdge ODBC are a terrible platform... :P )
Legacy DB admin found the answer. Seems there are ways to change the schema of an OpenEdge table that does not get "published" in such a way that external requesters can see it.
Apparently there is a "dbtool utility in dlc" that can scan and fix this. He researched it and did just that.
If you're reading this with similar issues and the above isn't enough to get you past, PM and I'll get more details.
- Query to find position in a string before keyword and extract data before that position
- SQL: get next relative day of week. (Next Monday, Tuesday, Wed.....)
- #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
- java.sql.SQLException: Column Index out of range, 2 > 1
- Should LIKE 'searchstr%' use an index?
- Multiple STRING_AGG in one query
- Postgres: Add constraint if it doesn't already exist
- UPDATE Statement ignores INNER JOIN
- Execute Stored Procedure Minimal API .Net
- Change default schema for user
- Oracle SQL - Select oldest of 3 dates, but ignore NULLs
- Housing Society management system database structure
- Keep getting error: PLS-00103: Encountered the symbol "CREATE"
- How to use an UPDATE Query with an INNER JOIN to update fields within a table
- Extract 4 million rows from database in chunks of 1 million rows each
- Aggregate into custom groups
- SQL query for chat application
- SQL basic problem when trying to SELECT 4 atributes and use GROUP BY with only 2
- How to modify query converting DATEDIFF to Oracle accepted syntax?
- Sales data analysis: calculate percentage of each product as per total sales
- Calculate the sum of values for the columns that meet the criteria
- Insert missing rows in time series consumption history
- Oracle database dependencies in PL/SQL
- How to autofill a field with data from another field in the same table?
- In Oracle: How to sort by group/cluster by a column value
- oracle SQL query - add date rows using different date
- How to fix products without cover image in PrestaShop
- IF ROW_COUNT() return error
- Select with like is not returning the correct results
- I am trying to get the start date ONLY from the column below using a SUBSTRING. Can someone tell me what I'm doing wrong?