how to delete one row in target dataset



how to delete one row in target dataset..

Answer / Neha Shrivastava

The method for deleting a single row from a dataset depends on the database management system (DBMS) you are using. Here's an example using SQL (Structured Query Language):n```sqlnDELETE FROM table_name WHERE condition;n``` Replace `table_name` with the name of your table and `condition` with a specific condition that uniquely identifies the row to be deleted.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

Tell me the syntax of Configuration file?

1 Answers  


what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,


how to export or import the jobs in .ISX file

1 Answers  


how CAN we remove duplicates in dataset?

2 Answers   IBM,


What is the project in datastage?

1 Answers  


What is the difference between passive stage and active stage?

1 Answers  


What is the use of datastage designer?

1 Answers  


What are constraints and derivations?

1 Answers  


source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

3 Answers   Patni,


How do you import and export data into datastage?

1 Answers  


What is the difference between hashfile and sequential file?

1 Answers  


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

1 Answers   IBM,


Categories