Search results for query: *

Iam trying to insert a record in a table using teradata sql assistant import option. This record in a file has date field in it and the number of columns values in the file match with the table structure.When i try to import iam running to issue .It says something about the invalid data in the...

-rw-rw-r-- 1 rvir etl 400443 Nov 17 10:16 test.dat -rw-rw-r-- 1 rvir etl 400443 Nov 14 18:29 X_000_TEST_8_ccout.dat I ran the etl job under my id. If you see rvir is my id and both the files are in same directory and i can open the first file where as when i open second it...

I've generated a file using ETL job on unix box by name A_000_TEST.dat. I see the file in the directory with a right file size but when i try to open it says could not open the file i tried removing it too but it doesnt seem to work. I know iam missing something but iam not able to figure it...

I've to assign values to a variable in a shell script from a file . The file looks like this V1 V2 V3 I've defined a loop in my shell script but i do not know how to assign v1 ,v2 and v3 one at time . Can any one suggest an approach

Iam wondering if there is any way to know decimal over flow for a column using awk or any script . Iam planning to do a sum on a single column and i feel there is something to do with decimal over flow

My mistake , this the code i use for calculating sum . BEGIN {FS = "\t"} { s1 += $2; } END {printf "COST AMT $%7.2f\n",s1 ; }

Iam doing a awk on a column in file to find its sum. I have a process which generates a file and then this script runs and determines the sum.The source data which is used to generate the file is same all the time .Everytime i re run this process with same data i get different sum for each...

Thank you all!

How can I find a number in a zip file. I cannot unzip the file since its huge on box .Please suggest me

when i do rm -rf on the file it doesnt show any error but it doesnt remove the file too. When i do ls -l it shows up the file.

One of my ETL process is creating a reject file on unix box with rw rw rw permissions. I tried to view the data but it doesnt show up anything on vi editor. I tried to remove the file but it doesnt work. Please advise me on this

Thank you !

I've to write a script which has to run as soon as a log file is generated from another script. Some body can tell me how do i proceed or is there any function with in unix which can help me do this.

Is it possible to change a file format eg: binary to csv or dsx to csv on unix ? if yes, suggest me some of the methodologies to be followed?

Thanks for your response. I do not see .profile under my home directory but there is one under root so i do not know if i can make changes to the root .profile.

I did check the man page .Could you explain me what am i suppose to do?

Iam in korn shell on Linux machine. Its default environment. Here iam trying to use up, down, left and right arrows to view command history and make changes to command line statements but whenever i try to use them iam printing these ^[ characters .Some body help me to use the arrow keys on the...

I've source file with 55907987 records .Iam writing it to a flat file. But when i count the number of records in the target like $ gunzip -c filename |wc -l i get 55908012 records .Iam using a ETL tool to write in to a flat file.In the ETL process iam doing nothing other than extracting and...