I am trying to use the functionality of the user defined SQL update action in the DRS stage for writing. While doing this I see that providing a table name is compulsory and the table name should have a table name even though it becomes readable field after I switch the update action to User defined SQL. If I leave the field blank then job runs to error.
I want to dynamically define the column name and hence dont want to give the table name.
Any help??
User defines Update action
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
Re: User defines Update action
Why does dynamically wanting to define the column give you problems with having to name the table?DeepakCorning wrote: I want to dynamically define the column name and hence dont want to give the table name.
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Re: User defines Update action
Because the column which I want to update is dynamic so I have to use a variable to define it in job's drs stage. When I use that and don't give any table name in the table field it says invalid table name (I assumed that when I check on uder defined update the table name should not matter but that does not work) , so it forces me to give a table name.
When I give the table name but ofcourse the column is not there in the table as it is a stage variable and gets a value dynamically in the USER define query.
When I give the table name but ofcourse the column is not there in the table as it is a stage variable and gets a value dynamically in the USER define query.
Deepak
Which version of DRS you are using. In 7.5 it works without any error. I completly removed the table name and used user-defined-sql it works. I also used a stage variable as table name in user-defined-sql which too worked without any problem. I don't see any problem with using this stage.
Which version of DRS you are using. In 7.5 it works without any error. I completly removed the table name and used user-defined-sql it works. I also used a stage variable as table name in user-defined-sql which too worked without any problem. I don't see any problem with using this stage.
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
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am