How to delete the data in dataset?types of deleting the data
in dataset?
Answers were Sorted based on User's Feedback
Answer / shilpasagar
We can delete the data in the dataset in 2 ways
1) Use Orchadmin command (orchadmin rm abc.ds)
2) Through Dataset Management option that is available in
the Director Client
Is This Answer Correct ? | 16 Yes | 0 No |
Answer / venkat
We have two types of ways is there,
first one, we have to go dataset management in delete option
is there, and second one is via unix command
$orchadmin truncate[-f or -x] descriptor file name
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / arjun
if we want to delete the dataset file completely we have to delete the 3 dataset files
1.Descriptor file
2.Data file
3.Control File
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / chandrakant swain (hara)
suppose we have one file HSBC.ds ,having 5 fields or
columns,and
20 records,for deleting the all record
then
>$head -1 HSBC.ds > NEW_HSBC.ds
then rename the new file use mv command ,like this mannaer
>$mv NEW_HSBC.ds HSBC.ds
Is This Answer Correct ? | 3 Yes | 18 No |
What are the unit test cases you used in your project?
hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
how to call routines in stages?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What are the functionalities of link partitioner and link collector?
What is quality stage?
How do u set a default value to a column if the column value is NULL?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
Where do you see different stages in the designer?
What is a merge in datastage?