Kbase P135893: MS SQL Server delta sql utility creates a bad sql and the length of the field is miscalculated in bo
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/16/2009 |
|
Status: Unverified
SYMPTOM(s):
MS SQL Server delta sql utility creates a bad sql and the length of the field is miscalculated in both .sql and the .df files when sql width is checked for extent field
FACT(s) (Environment):
The sql file created for the extent field does not append "##1" through "##n" on field name.
The filed length is also wrong for each extent field
The .df created to apply on the schema holder also has the wrong format
Windows NT 32 Intel/Windows 2000
MS SQL DataServer
OpenEdge 10.1C01
CAUSE:
Bug# OE00176198
FIX:
Upgrade to OE10.1C.
If upgrading is not possible, use the following workaround:
The workaround is to manually modify the .sql file and the .df file. Add ##1...##n and change the length of each of the extent on the sql file and the field format on the .df file.
Example:
if the ABL has extent of 5 with filed length x(10), the .sql file generated using the MS SQL Server delta sql utility look like the following when sql width is check:
ALTER TABLE dbo.t1 ADD
f3 VARCHAR(110) ,
f3 VARCHAR(110) ,
f3 VARCHAR(110) ,
f3 VARCHAR(110) ,
f3 VARCHAR(110)
go
The changed sql file should look like the following:
ALTER TABLE dbo.t1 ADD
f3##1 VARCHAR(20) ,
f3##2 VARCHAR(20) ,
f3##3 VARCHAR(20) ,
f3##4 VARCHAR(20) ,
f3##5 VARCHAR(20)
go
The .df file generated by the MS SQL Server delta sql utility look like the following when sql width is check:
UPDATE DATABASE "sh"
ADD FIELD "f3" OF "t1" AS character
FOREIGN-NAME "f3"
QUOTED-NAME """F3"""
FORMAT "x(110)"
...
The changed .df file should look like the following:
UPDATE DATABASE "sh"
ADD FIELD "f3" OF "t1" AS character
FOREIGN-NAME "f3"
QUOTED-NAME """F3"""
FORMAT "x(10)"
...