Search results for query: *

I need to write a script to run weekly jobs on particular days of the week. e.g., The schedule of Jobs could be as follows: 1. Job A needs to run every Monday at 10:00 AM 2. Job B needs to run every Monday at 3:00 PM 3. Job C needs to run every Tuesday at 12:00 PM 4. Job D needs to run every...

I need to update the value in a column for 50% of the records in the table. I need to use a single sql for this. I am using the following but it does not work. update a set column_name = 'xxxxx' where acct in ( sel acct from a sample .50 ) It fails with a message saying that I cannot use...

This is in continuation to the my previous post called 'create file with possible combinations of numbers from 3 files' I have a file with 10,000,000 numbers. Sample data(18 records) from this file1 is as follows: 100333505 100333606 100333707 100444505 100444606 100444707 100555505 100555606...

Suppose I have 2 numbers each in 3 files file1 contains 100 200 file2 contains 333 444 file3 contains 505 606 How can I create a new file which will have all possible combinations of numbers from the 3 files, pasted side by side? The new file will contain the following: 100-333-505...

I need to read the value of a parameter in a file. If the number of characters in this value is more than 10 then I need to take the first 10 characters of this value(something like a substring(value,1,10)) and substitute it as its value. e.g., TABLENAME=EMPLOYEE_RECORD - Here the value of...

Hi, I have a column defined as LONG which contains some XML code. Is it possible to find 'The maximum size of data in this column'?. The data in the column looks as below(I have pasted 3 rows of data from this column). <!-- MemberObjectGroups="#ID#XXXX:DIS:NAM" cost="11111"...

I need to pull data from some production tables and load into the tables on test region. But the tables have referential integrity among them. I am using Toad and I have to check each table details individually(so that I load the parent table before the child table). This is taking a long time...

I have some data in a file which looks like this. <Attribute name='mname' type='string' value='X.'/> <Attribute name='ssn id' type='string' value='111111111'/> <Attribute name='org' type='string' value='Top:XXXXXX:NAM:TBD'/> <Attribute name='origin' type='string' value='XXXX'/>...

I have the following two sql's. The first one is by me and the second one(supposed to be more efficient) is recommended by the DBA. SELECT COUNT(*) FROM TABLE1 WHERE ACCOUNT_NUMBER IN (SELECT ACCOUNT_NUMBER FROM TABLE2); COUNT(*) ---------- 259463 SELECT COUNT(a.*) FROM TABLE1 a, Table2 b...

While running multiload, some records are being rejected and go into the Error-1 table with the error code 2673. The explaination of the error code is as follows: The source parcel length does not match data that was defined. Explanation: This error occurs if the source parcel definition is...

I have number of files with '{' and '}' in it. I need to replace every '{' and '}' in this file to space. I am using the following in a script: sed 's/{/ /g;s/}/ /g' >temp mv temp $1 It is taking too long since the files are very huge and they have many of these characters to be replaced. Is...

I need to insert some values into a column defined as INTEGER. When I check the table after the load, I can see the numbers have changed and have been assigned a Negative sign by Teradata. The conversion is as follows 2150272280 is converted to -2144695016 2151317548 is converted to...

I have a large data file with millions of records. The record length of the data is 605 bytes. But some records in the file are shorter than 605 bytes. How can I find what are these error records. Is there any way to point out those particular records or the line number of those records...

I had an interview and was asked a question as follows: 'If you have a 100 MB file that u need to ftp to another unix server & process it, but the server has only 10 MB space left, how can you do it'. The interviewer was saying something about Piped files if I am not wrong. Can somebody please...

I have a file that is generated every week. Its name is going to be in the following format: ${businessname}${datecreated}7890. e.g. SCF2004010207890.dat SCF2004010907890.dat SCF2004011607890.dat SCF2004012307890.dat SCF2004013007890.dat The businessname &amp; last four digits are going to...

I have to select sample data from a large table containing millions of rows. I have to follow the following rule to select the sample data. First I have to select a number that is near to 100 as an interval e.g., suppose I select 99 as my interval. Then I have to decide a particular number of...

I have a large oracle table with 40 Million records. I need to pull out 100,000 records each time and put it into a temporary table and process it, due to space issue. After these records are processed, I need to pick up the next 100,000 records and do the same till the end. I need to do the...

Hi, I am getting a peculiar problem while trying to load data using fastload. I am trying using the Demo Version of Teradata and the fastscript is straight from the teradata demo documentation. Can anybody help me with what is the prolem here. When I run this script I get the error as: ****...