How to import a table definition from a sequential file

[jherr22]

I'm trying to build a table definition.
My input is from an Oracle DDL file:
create table abc ( field1 varchar(10), field2 varchar(10) );

If I convert this to a sequential file, how would it look?
And do I use a ".TXT" suffix on the file name?
Does the input file get read from the server or the client?

My client is on Windows XP Professional.
My server is on Unix Solaris.
DS is 7.5.1

Thanks
-- john herr
john.f.herr@lmco.com
720-922-5903

[chulett]

You really should be pointing to a instance of the table itself, not any exported DDL. Can you not create it somewhere you have access to, at least temporarily?

[jherr22]

How do you point to an actual table instance from (where)?

-- john

[kcbland]

If you have the data file you can manually create the sequential file metadata using the Import Table Definitions --> Sequential File wizard from DS Manager. If the file is a straight dump of a table, you should use Import Table Definitions --> PlugIn Metadata wizard and choose the appropriate Oracle OCI stage. Go thru the wizard and get to the original table and import those definitions, they should suffice for giving you column definitions. You'll have to manually configure your Sequential file stage in your job with the appropriate delimiter, quote character, etc.

[ray.wurlod]

When importing an Oracle table definition prefer the Orchestrate (orchdbutil) method. This is known to import the metadata, particularly for decimal numbers, more accurately than other methods.

There is no published tool, either IBM or third party, for importing a table definition from DDL. This is mainly because there is no agreed standard for DDL, either for the language or for the format.

[jherr22]

It worked.
Thanks.
Incidently, the documention Designer Manual, page 9-13 is wrong. It does explain to use Plug-in Data Defintions.

Thanks
-- john herr
Lockheed Martin

[jherr22]

It worked.
Thanks.
Incidently, the documention Designer Manual, page 9-13 is wrong. It does not explain to use Plug-in Data Defintions.

Thanks
-- john herr
Lockheed Martin