problems with data types and creating an SQL Schema

[MANUEL RAMOS]

Hi im having problems creating a new SQL schema for my Progress DB

in the ds_upd.txt file progress gives me this error for several tables

ERROR: Table MyTable1 has unsupported data types.
Skipping this table...
ERROR: Table MyTable2 has unsupported data types.
Skipping this table...

only 1 table of the hole DB(About 35 SQL tables) its 100 % error FREE

Can you Help me???

 

[RealHeavyDude]

Not really. You should tell us more about your database, beginning with which Progress/OpenEdge version you are running on what operating system.
Furthermore it would be helpful if you posted an "erroneous" definition to be able to see what it is that offends the database.

In the meantime you might explore the following:
http://documentation.progress.com/o...ta Management/SQL Reference/01dmsrftitle.html ( SQL Reference for OpenEdge 11.3 )
http://documentation.progress.com/o... Management/SQL Development/01dmsdvtitle.html ( SQL Development for OpenEdge 11.3 )
Or start at the top level of the documentation for OpenEdge 11.3
https://community.progress.com/tech...1107.openedge-11-3-product-documentation.aspx

Heavy Regards, RealHeavyDude.

 

[MANUEL RAMOS]

Sorry for the short info.
Open EDGE its 10.1 A, running on WINDOWS 2003 SERVER
The SQL Server its running temporarly on a PC with Windows 7
The SQL its SQL SERVER 2008 R2

This is an example of my first table on my DB

ERROR: Table Alarms has unsupported data types.
Skipping this table...

dbo.Alarms
Fec(nvarchar(20), not null)
Alarm (nvarchar(100), not null)
Rec(bit, not null)
ID(PK,int,not null)

 

[MANUEL RAMOS]

I think that the problem its with the nvarchar fields

 

[RealHeavyDude]

OE 10.1A is pretty old. According to the OE 10 documentation you need to use VARCHAR instead.

The Progress OpenEdge database does not limit a field of type CHARACTER unless you exceed the maximum bytes you can store per record. The database only knows a default input/output format which is used unless specified otherwise. This way the database allows to store more bytes in a character field than which is defined as standard input/output format. Obviously this behavior causes problems with SQL. Therefore the Progress OpenEdge database knows another attribute - which is the SQL width. But this attribute is only set when the field is created in the database ( dertermined from the defaul input/output format ) or when it is adjusted to reflect the actually stored data by running the dbtool.

Heavy Regards, RealHeavyDude.