Odbc connector and enterprise stage
Moderators: chulett, rschirm, roy
Odbc connector and enterprise stage
In my job I am using odbc connector stage ,and my target is a odbc connector stage via transformer.In my source d/b there is a column of datatype number which is imported in the datastage metadata as decimal(38,10).After compilation when I run this job the job is aborted showing a log of many NOTFOUND columns.
This job is run successfully if I use a odbc enterprise stage instead of connector stage.Seems that the problem is for that specific column only as if I remove that column the job is run successfully using odbc connector stage
Can anyone please explain the reason
Appreciate any kind of help.[/img]
This job is run successfully if I use a odbc enterprise stage instead of connector stage.Seems that the problem is for that specific column only as if I remove that column the job is run successfully using odbc connector stage
Can anyone please explain the reason
Appreciate any kind of help.[/img]
Probal
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Are you sure it runs correctly when you remove those fields? Are you getting anything as output?
when ever it fails using ODBC connector stage look at the entry in log containing IIS-CONN-ODBC and check whether the connection was successful.
I only get not found warnings for key columns when the connection is not successful.
when ever it fails using ODBC connector stage look at the entry in log containing IIS-CONN-ODBC and check whether the connection was successful.
I only get not found warnings for key columns when the connection is not successful.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
For what you're describing, I would assume it's a bug in the connector stage, they are new and thus still can have some issues. Check with your official support provider to see if this is a known issue and if there is a patch available.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
Re: Odbc connector and enterprise stage
- What is your source database?probal wrote:In my source d/b there is a column of datatype number which is imported in the datastage metadata as decimal(38,10).
- Is there another column of datatype decimal?