Kbase 20720: Error 6202, 6204 displayed when using GUI dictionary to change datatype from timestamp (date) to tim
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/03/2010 |
|
Status: Verified
SYMPTOM(s):
PROGRESS timestamp string has the wrong format for SQL timestamp. (6202)
The format should be: YYYY-MM-DD HH:MM:SS.[FFFFFF] . (6205)
Data types "datetime" or "smalldatetime" present within MS SQL Server Database
Erorrs 6202 followed by 6205 are encountered when GUI Data Dictionary is used to change data type from Timestamp (Date) to Timestamp (character)
User is not able to change the data type to 'Timestamp (character)' using GUI Data Dictionary.
FACT(s) (Environment):
MS SQL Server DataServer
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
User can dump the data definition and make appropriate changes e.g. in the df file :
Here are the following changes:
ADD FIELD "somedate" OF "dtproperties" AS date
FORMAT "99/99/99"
INITIAL ?
POSITION 6
ORDER 5070
FOREIGN-POS 7
FOREIGN-NAME "somedate"
FOREIGN-TYPE "TIMESTAMP"
DSRVR-PRECISION 23
DSRVR-SCALE 3
DSRVR-LENGTH 16
DSRVR-FLDMISC 0
FIELD-MISC22 "Y"
QUOTED-NAME """somedate"""
MISC-PROPERTIES ""
Change to:
ADD FIELD "somedate-1" OF "dtproperties" AS character
FORMAT "x(26)"
INITIAL ?
POSITION 6
ORDER 5070
FOREIGN-POS 7
FOREIGN-NAME "somedate"
FOREIGN-TYPE "TIMESTAMP"
DSRVR-PRECISION 23
DSRVR-SCALE 3
DSRVR-LENGTH 16
DSRVR-FLDMISC 0
FIELD-MISC22 "Y"
QUOTED-NAME """somedate"""
MISC-PROPERTIES ""
Reload the df into the schema holder