Invalid column name
Moderators: chulett, rschirm, roy
Invalid column name
I have an odbc going to a transformer and the transformer going to an odbc. In the transformer i'm doing a derivation on a column. My logic works, but i get an invalid column name, my table that i'm pulling the information from doesn't have this column, is that why i'm getting this error? thanks for the help
hello dj352001,
There is very high likelihood that the error message and your missing column are related. You can get rid of your error message in DataStage by going to your database and entering "ALTER TABLE {tablename} ADD COLUMN {the invalid columname} VARCHAR(32);"
There is very high likelihood that the error message and your missing column are related. You can get rid of your error message in DataStage by going to your database and entering "ALTER TABLE {tablename} ADD COLUMN {the invalid columname} VARCHAR(32);"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
dj,
please re-read your post and mine. You are getting the error message because the column doesn't exist - my response was intentionally facetious in that it only solved the symptom and not your problem and I did not intend you to follow it. Creating an unused column doesn't fix anything - you need to remove the unused column from your DataStage job.
please re-read your post and mine. You are getting the error message because the column doesn't exist - my response was intentionally facetious in that it only solved the symptom and not your problem and I did not intend you to follow it. Creating an unused column doesn't fix anything - you need to remove the unused column from your DataStage job.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Of course you can do this. Add the column in a transform stage and fill it with values according to your logic. It isn't declared in the source (since it doesn't exist there) but created as part of your job design.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Import table definitions for source and target and load into their respective stages. Press VIEW DATA and make sure it works. Now correct your mapping.
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
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
No. It is not making any sense. Could you frame your question in a different way?
Just tell us this! How many columns does your source ODBC stage contain? And how many columns does your actual source table in the database contain?
Thanks,
Naveen.
Just tell us this! How many columns does your source ODBC stage contain? And how many columns does your actual source table in the database contain?
Thanks,
Naveen.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Try this:dj352001 wrote:When i click on view data everything works fine. I go back an import a new column and click view and thats when i get an invalid column name. I don't understand why i'm getting this error, the column name is there for me to import it. does this make any sense?
Open your source odbc stage and goto the columns tab and see if anything written in the derivation column. If there some data (usally you will get when you import the column) then delete that and try.
Hope it works and am not sure why we have to delete that from the derivation.
Thanks,
RCil
RCil
Hi dj
In your ODBC stage you have three option in General tab for "Select using"
You would normally use Generated query or User-defined SQL query to do a select from database table.
If you use Generated query you have to make sure that the column you type in your Column tab matches the Column name in the table. If you want to use additional column which doesn't exist in your table then you type the new column name and in the derivation box type the sql derivation value.
If you are using user-defined SQL then have all the columns you want to view from ODBC and type the Select SQL matching the columns you defined.
In your ODBC stage you have three option in General tab for "Select using"
You would normally use Generated query or User-defined SQL query to do a select from database table.
If you use Generated query you have to make sure that the column you type in your Column tab matches the Column name in the table. If you want to use additional column which doesn't exist in your table then you type the new column name and in the derivation box type the sql derivation value.
If you are using user-defined SQL then have all the columns you want to view from ODBC and type the Select SQL matching the columns you defined.
Regards
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
Your metadata for the table in the Manager does not match your actual table. reload the table's metadata from the database and use that.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>