DSXchange

Your blog was awesome!
Really interesting stuff for Datastagers..

Thanks for posting..

Hiral

I think, from what it sounds like, you'll have to go with the ODBC Connector or the ODBC Enterprise stage. Secondly, you will have to be able to establish a connection between the Datastage server and the Database that you're using. For that, you'll have to configure the settings in the .odbc.ini fi...

Try disconnecting that user's connection by logging in through DS Admin Console. Typically it is http://<your server IP address>:<port number>

Ok. This was my mistake. I chose DBMS Type as DB2 and it was not working. I changed the DBMS type to ODBC and the orchdbutil lets me import table defs from the Database I connect to.

Sorry, I guess I did not provide all the information from my side.

Thanks,
Hiral

I'm not sure what you mean by syntax. In Datastage, I use Import - Table Definitions - Orchestrate Schema Definitions and fill in the dialog box with the appropriate values for: -Table name -(For Owner is grayed out) -DBMS type -Database name -Database server -Username -password -Charset/Map -Use ow...

For some reason, since this morning, I'm not able to import DB2 table definition using ODBC for a particular table. I was advised to used Plug-in meta data or Orchdbutil as a work around. Plug-in Metadata works just fine. But Orchdbutil does not work. I was hoping that there would be a way to find o...

Hello !! Alright, I'm trying to import table definitions using orchdbutil (Import - Orchestrate Schema Definitions ). I have entered the following details in the import Orchestrate Schema dialog box: Table name For Owner is grayed out DBMS type Database name Database server: Username password Charse...

Oh! Thats good to know!!

Thanks once again!

-Hiral

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 util...

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

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 Definitio...

Thanks for the tip ArndW

Hi mekrreddy,

A couple questions:

Is that a key field where you get nulls?

Do you actually want nulls in your field? What is the business rule for that?


You can put a condition saying "If input.field = '' then 'NONE' Else input.field"

Does that make sense?

hmmmm. Sorry about that.. I would probably analyze those two records on the source side then. I would try to find out what makes them different than the rest. We had that kind of issue once and it turned out that we had some hex characters in our incoming record that made the target field bigger tha...

I used in my target Oracle database and the target stage Float(25,5) Even if you define your column as a Float(25,5) in your target Oracle database stage, your database will reject out the rows. In order for these two rows to land in your database, you will have to change the properties (meaning ma...