Migrate DDL from DB2 To ACCESS 2010

[RedGoldPhoenix]

Hi
I wish to migrate DDL from DB2 to ACCESS 2010

So I delete "CREATE DATABASE" , "CREATE TABLESPACE" change " FOR SBCS DATA NOT NULL," in " NOT NULL,"
Delete line which contains "SET CURRENT" etc. ...

My problem is with Label

I really want to load descriptions Columns

Cold you help me to modify the SQL syntax
For example I have this but that does not work

--
LABEL ON TABLE TABLENAME IS 'COBOL - CICS Access';
--
LABEL ON TABLENAME
(CB7MODULENAME IS 'Load Module ',
CB7VALUE IS 'Value ',
CB7VARIABLE IS 'Variable ',
CB7PARMNAME IS 'Parameter ',
CB7ACTION IS 'Action ',
CB7SRCLINE IS 'Line ',
CB7SOURCELIB IS 'Source Lib ',
CB7SOURCEMEM IS 'Source Member ',
CB7MAINLIB IS 'Main Lib ',
CB7MAINPGM IS 'Main Program ',
SYSTEMCOBOL IS 'System ',
XXRDATINFO IS 'DatAddInfo ',
XXRDATENV IS 'Environment ',
XXRDATCLIENT IS 'Client ');
--

Could you help me ?

[zmbd]

You might find the following link of some help:
How to use common Data Definition Language (DDL) SQL statements for the Jet database engine

The second link that may prove helpful is Data Definition Language: SQL This is part two of the series, you'll want to read part three as well.

What you are doing is not often done in Access so the best of luck.
-z

[RedGoldPhoenix]

Thanks a lot Z for your message
I'm going to read you link
If I got questions I'll be back ;)

See you

[zmbd]

>Forgot<
You might need this crossreference too:
Field type reference - names and values for DDL, DAO, and ADOX

[RedGoldPhoenix]

Hi

I found for labels ou must used the command COMMENT to add comments for Example:

on tables:

COMMENT Nom_de_la_table IS 'Commentaires';

For collums

COMMENT Nom_de_la_table.Nom_de_la_colonne IS 'Commentaires';