Hi,
Any one clarify me, which is the best method to import meta data i.e. Orchestrate method or Plug-in method. Because I am unable to import the table using Orchestrate schema definitions, but the same table imported using plug-in meta data schema definitions method. I am getting the following error while importing the table using Orchestrate method:
"Could not obtain a schema because prepare failed; the query was: SELECT * FROM Table name".
Thanks in Advance
Suresh
Orchestrate table import
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 21
- Joined: Thu Oct 04, 2007 4:34 am
- Location: India
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Orchestrate (via orchdbutil) is usually to be preferred, as it is more accurate.
Can you execute the same SELECT statement via any other client (not DataStage)?
Can you execute the same SELECT statement via any other client (not DataStage)?
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.