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 |
Tell me the syntax of Configuration file?
what is diff b/w datastage 8.1,8.5,8.7?
how to export or import the jobs in .ISX file
how CAN we remove duplicates in dataset?
What is the project in datastage?
What is the difference between passive stage and active stage?
What is the use of datastage designer?
What are constraints and derivations?
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..........
How do you import and export data into datastage?
What is the difference between hashfile and sequential file?
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)