Hello Datastagers,
I have spent a considerable amount of time researching about this and could not figure out what is going on. And so I need your help!!
I'm trying to import table definitions of a DB2 table in Datastage. My usual course of action is Import - Table Definitions - ODBC Table Definitions. But when I try to import table definitions for this particular table, the Import Manager hangs. I finally kill the import table definitions dialog box and there is no table def imported.
We have been successful in importing table definitions for other tables with about 110 columns. This table has 160 columns. Not sure if this a column limit issue with DB2 or Datastage.
Oddly enough, we can access the table in DB2 without any problems.
I do not see any obvious problems with the definitions of any of the columns in the table. If anyone can point out where the issue is, then that will be great!!!
Thanks much,
Hiral Chauhan
Unable to Import Table Definition
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 45
- Joined: Fri Nov 07, 2008 12:22 pm
Unable to Import Table Definition
Thanks,
Hiral Chauhan
Hiral Chauhan
-
- Premium Member
- Posts: 45
- Joined: Fri Nov 07, 2008 12:22 pm
I do not think so..
So the original name of the table was DEPOSIT in the DEV schema. We tried changing it to DEV.DEPOSIT2, DEV.DEP2, DEV.DEPOSITS, DEV.DEV and it still behaves the same way.
We even changed the name of the columns to generic names like COL_1 , COL_2 .... COL_159. And no luck![Sad :(](./images/smilies/icon_sad.gif)
So the original name of the table was DEPOSIT in the DEV schema. We tried changing it to DEV.DEPOSIT2, DEV.DEP2, DEV.DEPOSITS, DEV.DEV and it still behaves the same way.
We even changed the name of the columns to generic names like COL_1 , COL_2 .... COL_159. And no luck
![Sad :(](./images/smilies/icon_sad.gif)
Thanks,
Hiral Chauhan
Hiral Chauhan
-
- Premium Member
- Posts: 45
- Joined: Fri Nov 07, 2008 12:22 pm
Hi Craig,
I tried using the Plug-in Metadata utility and it did let me import the table defs for that table. Thats awesome!!!
I cannot help but wonder, why I cannot ODBC into that table to import its defs? How is plug-in metadata different than ODBC?
My other concern is, I assume the orchdbutil utility can be used only if you have Enterprise Server configured. Is that true? (Actually, we do not have an Enterprise Server configuration at our place).
Thanks,
Hiral
I tried using the Plug-in Metadata utility and it did let me import the table defs for that table. Thats awesome!!!
I cannot help but wonder, why I cannot ODBC into that table to import its defs? How is plug-in metadata different than ODBC?
My other concern is, I assume the orchdbutil utility can be used only if you have Enterprise Server configured. Is that true? (Actually, we do not have an Enterprise Server configuration at our place).
Thanks,
Hiral
Thanks,
Hiral Chauhan
Hiral Chauhan
-
- Premium Member
- Posts: 45
- Joined: Fri Nov 07, 2008 12:22 pm