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
How to import a table definition from a sequential file
Moderators: chulett, rschirm, roy
How do you do that?
How do you point to an actual table instance from (where)?
-- john
-- john
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Using Plug-in Data Definitions worked.
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
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
Using Plug-in Data Definitions worked.
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
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