Search results for query: *

Hi Guys, I need to display the following information in a file. This file is going to contain only one record which is displayed by running query on another file(2nd file). DATE is the date 2nd file created, TIME: time 2nd file created, RECCNT : # of records in 2nd file. BLANK: 17 black...

Hi Guys, I am using a script to insert a record count on the top of a text file. But now the source file has changed and the new files are in a compressed format. So I will have to uncompress each file attach the record count as header and compress it back. I tried to do something like this...

I have to extract data from a table using a query as follows select * from table A where A.somecoulmn NOT IN(select anothercolumn from b) AND (..........); The problem I have is that, in table 'A' 50 % of the rows have Null values for column 'somecolumn'. So the above query pulls only the...

I have a table that I need to query based on a column. The column contains two types of values. First type has the first character as alphabet and then numerals. The second type has all numerals. I need to query the table based on this first character. I tried to use substr(column,1,2)not...

I have a job that runs everyday. It looks for a file in a particular directory and takes it as an input file. This file is generated by some previous job. Sometimes this previous job does not run depending on various conditions that are unable to predict. But then my job still looks for that...

Hi, I have 3 tables table1 a, table2 b and table3 c as follows a.ssn a.name1 a.name2 a.addr1 a.addr2 a.addr3 a.city a.state a.zip b.somenumber c.somecode I have to pull the data from above 3 tables. I have to match the records based on the column 'ssn' which is present in all tables. The...

I have a large table from which I need to delete all the data and reload it again. I do not have a truncate table right on this table. When I try to do a delete on the table, I run into rollback space errors. Somebody suggested me to use a pl/sql and do frequent commits. I have not used pl/sql...

I have a large data file. I need to find how many records in a particular column had a specific value. e.g. Its a third column in the file and the position of the column is 30 to 34. The values in the column is a combination of 1's and 0's like 10000 11010 11111 00000 01111 How can I find the...

I want to load data from dat files into a database. But before that I want to make sure that there is enough space in the DB to hold the data. How do I find the space in the database. Thanks, Navin

I have a large text file. The first line of this file is the record count of that file. What would be the command to delete this line from the file. It is a very large file. So I cannot open it in vi and delete the line. Thanks Navin

I need a script to pull yesterday's date each time when I run it. Right now I have mydate=`date '+%Y%m%d'`. But it pulls todays date. How can I pull the date of the day before. Thanks, Navin

Hi Guys, I am extracting data from a table and putting it into a number of text files. While doing this I am displaying the number of records in the file, on the top of the same file as a header record. I am using a modified version of the following script posted by Dickiebird to achieve this...

I am extracting data from a table and putting it into a number of text files. While doing this, I need to find out how may records are extracted into each file and display it on the top of the same file as a header record. Anybody has idea how to do this, Thanks, Navin

I have a job that needs to run daily. I need to write a shell script which will pick up a input file that is generated daily. The generated file is going to have the jobname with sysdate and some more characters appended to it. In this, jobname is going to remain same, the syadate will change...