Recent content by Rvir

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.