How to delete the data in dataset?types of deleting the data
in dataset?
Answer Posted / 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 |
Post New Answer View All Answers
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is ibm datastage?
Describe link sort?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Enlist various types of routines in datastage.
What is the use of hoursfromtime() function in transformer stage in datastage?
What is the process of killing a job in datastage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
How many types of views are there in a datastage director?
how many rows sorted in sort stage by default in server jobs
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What are routines in datastage? Enlist various types of routines.
To see hidden files in LINIX?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How do you reject records in a transformer?