on 09-13-2016 3:42 PM
Hi All,
I would like to add a column to an existing table without the database.
Here my scenario is I have source having 25 columns at the same time my target having 24 columns, I have to add the new column in the target table. I do not have database access, my superior saying can do it through BODS designer. anybody help on this?
Thanks
Murali.
Use a template table.
All details are in section 2.3.28 of the SAP Data Services Reference Guide.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Murali,
Double click the permanent table and do a right click on an existing column and select New Column and then above or below the existing column. I think you should know the database structure and put the columns in the right order.
I am running SAP Data Services 4.2 SP7 and the datastore is pointing to SQL Server db.
Best Regards,
Bogdan
Hi Murali,
Take a script before and write sql function like below
sql('KFTDS_DS_STG','ALTER TABLE ST_SHIPS_BEARING1 ADD FLAG varchar(4) NULL');
now add a column in target table in bods as suggested by Bogdan.
and map the source column to target column,
I tried this and it worked for me.
Thanks,
Ravi kiran.
Hello Murali,
Only Template table object can create table structures in the underlying database. Permanent tables don't create table structures. What Ravi suggest might work, but I would follow a better approach by asking the database owner to create the additional column for you in the database and tell you the name and datatype. And the same you create in BODS how I suggested first.
Regards,
Bogdan
Hi Ravi,
The way you suggested might work, but I think it is not better approach what Bogdan suggest, why means, suppose in our job if we have lot of dataflows(for ex:10), for change target structure in one target table, we have to run whole job.
another way is create a sample job and run the script only. but it will best when we are working development but in Production do we have any other alternative option?
Thanks
Murali
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.