Search results for query: *

Hi Guys I want to find out how to get the following result? Table 1 col1 Col2 123 100 123 200 Table 2 c1 c2 123 189 123 190 The result I need is as following: 123 100 189 123 200 190 Can you help me with the query for this one. I tried to normal join it give...

Great Thanks allot for your reply. Solved the problem

How to find out if the FTP file is finished loading in unix. I am getting a file from different box. After I have received the file in full I want to move it to a different directory. How can I find out if ftp has finshed loading it to my box Thanks for your help

'FIRST_TABLE' is 08/04/2008 07:00:46 and 'SCE_TABLE' is 08/11/2008 02:10:26

HI Mufasa You are right that was a mistake it should be col1, col2 ... for your questions 'first_table.key' and 'sce_table.key' both have indexes along with bunch of other indexes. They both are non-unique indexes. I am not sure about the date when the statistics were gathered. Do we need to...

Hi I am selecting from one table which have more than 18M rows and joining it with table B which has about 1M rows. Query is like select a.row1, a.row2, a.row3, B.some_row, a.row4 from first_table a, sce_table b where a.key = b.key...

Hi all if I want to use vaiable? im try to do this but im can't get pass it file_name=data_file20080214 sed '1s/$/$file_name/1' $txt_file > new_data_file when I used this i got Firstlineofflatfile20080220$file_name how can i get; Firstlineofflatfile20080220data_file20080214 Thanks for all...

This was able to help me s=`echo $file2 | cut -c 4-7` print $file2$s.log

HI All I would like to cut a part of the file name I have a flat file lets say ABC12345.TXT and 2nd file name is DELL500.TXT file_name=$(echo ABC12345.TXT | sed/\.TXT//) file2=DELL500.TXT I would like to create a new name by joining some parts of both the names; I want the out put to be...

HI all Can any one please help me with this? I have a flat file. I just want to add something to its first line and not want to touch rest of the file. e.g Firstlineofflatfile20080220 010800650022000003190000000+000002ECLPSE BIG E SPEAR000022505 ^M...

Thanks allot Perfectly working!!!

Hi All I am trying to reformat a flat file but im facing a issue let me explain myself Orignal File: 010800650022000003190000000+000002ECLPSE BIG E SPEAR000022505 ^M 010800650034000003470000000+000006YORK MINT TIN 000012405 ^M...

HI All I have a fixed length flat file. I want the records in the flat file to be loaded to two different database tables based on a condition, before that I have to create two file out of one file. Let me give you an example; 01082008011300046coffee 46 02602008011987456phone 56...

Great Thanks allot PHV & SamBones Basename will do the first part and Thanks to Mike042& Annihilannic for helping me with the second part Best Regards DJLongs

Well I won't be the same file, actually I am trying to use the name only. I get the and then I have to send out the email and perform different things. I was able to create first name(testfile200803101_508400) from the files coming in testfile200803101_508400.ZIP.PGP...

Ok i think i wrote it wrong: I like to create a different name, shall i say make two different copies of that file. These are the files coming in testfile200803101_508400.ZIP.PGP testfile200703005_879850.ZIP.PGP I would to make one copy as testfile200803101_508400 (This I can do with sed...

Hello All, I would like to rename files. Let me example what I am trying to do. I have files coming in daily; testfile200803101_508400.ZIP.PGP testfile200703005_879850.ZIP.PGP These are example only. one thing is for sure that it will start with "testfile" and ends with ".ZIP.PGP" I would...

Hello All I got a question please allow me to explain my problem first. I have 5 files in a directory; a.dat b.dat c.dat d.dat e.dat I will like to write a script which will cp the files one by one to new file and then do some other work. so what will happen is; until file is found LOOP cp...

HI all I want to copy a file name. Please let me explain myself; filename20070824 cp filename20070824 test_filename20070824 The problem I have is that I want to use * instead of the date. I want to cp it in such a way that it keeps the name of the file and just adds "test_" at the start of...

HI Al How can I generate a track file? thanks