03-16-2011
Append data 1 table to other
Hi.
I have 2 create 2 temporary tables.the data will be same with same cols..but after creating 2 tables..i have to merge data in file and send..however the query is after merging data no duplicates shud be present..and only 1 record for a entity must be present..
for eg:
table1 has foll cols and data:
cols:-->
R_ID || L_DATE|| XXX
data:-->
101|| 01/02/2009 || order1
102|| 02/02/2010 || order2
table2 has foll cols and data:
R_ID || L_DATE|| XXX
data:-->
101|| 05/02/2010 || order1
106|| 02/02/2010 || order5
so i need that when i merge data from 1 table to another or into a file,, then
for order 1 record i shud get only 1 entry in table or file and that shud be d latest one i.e:based on L_DATE column va;ue fr this record
plz help me..
its urgent...plz reply
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
i want to develop a script newdata that writes new data to a file called items
the file items has the following headings columns separated by tabs:
channel date time programe
if i type executable file newdata on the command line with parameters, it should append it to the items files
the... (1 Reply)
Discussion started by: fletcher
1 Replies
2. Shell Programming and Scripting
hi again :$
i am creating a script to be able to monitor a machine's performance.
the code in the file is:
================q==============
sar 2 3 |awk '{print $3}'
vmstat 2 3 |awk '{print $19 " " $21}'
iostat -cx 2 3 |awk '{print $8 " " $10 " " $13}'
================uq=============
the... (4 Replies)
Discussion started by: mohamedh_14
4 Replies
3. Shell Programming and Scripting
Hi there,
I get a list of data set by means a script with many echo command that looks like this:
CASE 1
A= 4
B= 4
CASE 2
A= 3
B= 5
Is... (3 Replies)
Discussion started by: Giordano Bruno
3 Replies
4. Shell Programming and Scripting
Hi,
The below is the content of the file.
008.03.50.21|ID4|0015a3f01cf3
008.04.20.16|ID3|0015a3f02337
008.04.20.17|ID4_1xVoice|00131180d80e
008.04.20.03|ID3_1xVoice|0015a3694125
008.04.30.05|ID3_1xVoice|0015a3f038af
008.06.30.17|ID3_1xVoice|00159660d454... (2 Replies)
Discussion started by: ravi_rn
2 Replies
5. Shell Programming and Scripting
Hi guys,
I need to investigate a memory leak on a solaris server, so what I have done is pmap'd each process on the system with a script which tar'd the directory every hour in cron. Now I need to write a script to process the pmap data.
So what I have is about 100 directories
# ll... (2 Replies)
Discussion started by: borderblaster
2 Replies
6. Shell Programming and Scripting
Hi ,
i have two log files, i need to combine this as a one log file.
i need to do this by SED ,
test1.log
sadadadaadfsaf
test2.log
adadadadadada
i need this in a single file from test 1 to test2.log
test2.log(expected result)
adadadadadada (7 Replies)
Discussion started by: mhdmehraj
7 Replies
7. Programming
Hi,
I have an smallint variable, say "a", i would like to prefix it with "0" in certain conditions. Is it possible to achieve that with this datatype?
For instance,
a=9 --> a=09
Many thanks (1 Reply)
Discussion started by: dvah
1 Replies
8. Shell Programming and Scripting
Hi all ,
am using unix aix ..
Actually i have a table called table 1
in that table
year period startdate enddate
2013 1 26/03/2012 29/04/2012
2013 2 30/04/2012 27/05/2012
2013 3 28/05/2012 28/06/2012
2013 4 25/06/2012 ... (10 Replies)
Discussion started by: Venkatesh1
10 Replies
9. Programming
Hello everybody I'am trying to open a File with an Filedeskriptor. After Opening the file I want to append Data to the File!
I have the following code now, but I only overwrite the data from the file and did not append it!
void Buffer::writeIntoFile(std::string name, int length, std::string... (2 Replies)
Discussion started by: pk543450
2 Replies
10. Shell Programming and Scripting
Hi,
I have a csv file from which i am fetching few columns as below:
IFILE=/home/home1/Report1.csv
OFILE=/home/home1/`date +"%m%d%y%H%M%S"`.dat
if #Checks if file exists and readable
then
awk -F "," '(NR>4) {print $1,$6,$2,$3,$4,$5,$6}' ${IFILE} >> ${OFILE}
fi
cat $OFILE | mail... (7 Replies)
Discussion started by: Vivekit82
7 Replies
DTIF(5) File Formats Manual DTIF(5)
Name
DTIF - Digital Table Interchange Format
Description
Digital Table Interchange Format (DTIF) is the standard format for the storage and interchange of documents that contain data tables, for-
mulas, and spreadsheets. You can use DTIF to store and retrieve database information, interchange spreadsheets, and reference table data in
compound documents.
DTIF defines the logical structure and physical layout of a data table, the values within the table (absolute data and/or expressions), and
presentation attributes (formatting) to be used when displaying or printing the table. DTIF works with Digital Document Interchange Format
(DDIF) so that you can store or reference DTIF tables in DDIF-encoded compound documents.
A DTIF document can contain a sequence of one or more tables and is uniquely identified by a product name, a version number, and other
descriptive information such as the document's title and creation date. Each DTIF table is a 2-dimensional display of data values orga-
nized in columns and rows that has its own structure and table data stored in cells.
In DTIF documents, attributes specify the type and format of information pertaining to the data stored in a table. Column attributes
describe information for all the cells in a particular column, whereas generic column attributes can be applied to any column in any table
that references them. Format attributes define the printed and displayed presentation of data stored in the table. Format attributes can
also be redefined at the window, column, or cell level.
See Also
CDA(5), DDIF(5), DTIF(5)
Compound Document Architecture Manual
DTIF(5)