Search Results

PERFECT . Thanks Pravin :)
however, I am not able to understand how UPDATE is returning Count of updated rows.. In forums I read, one has to do specifically "SQL%rowcount" to do this..

Pravin, this is not working because there is no SELECT Statement.
It has only UPDATE and there is no display inside sql command block.

I know that we can use sql%rowcount to know number of rows...

shell script has a command inside back quotes in method update_TABLE
I need to store the count of number of Rows updated and store it in shell script variable "num"



num = 0;
Update_TABLE
...

thanks Chris. this will surely help. But, if different records are not separated by one or more blank lines, how to isolate records?
like then what will i put in RS?

eg:-
X|Rec1|
Y|Rec1|...

i have a pipe delimited file with records spread in many lines.
i need to extract those records
1)having X in beginning of that record

2)and having at least one Y in beginning before other...

to be more clear,
I first do
cat file | od -Ad -x
Now, after this I do cuts using dd command
Now, output of
cat file | od -Ad -x
actually becomes twice the size. I dont know if there is any...

Actually I tried the code for smaller files, and I found its getting big.
I have not yet tried it on big one. I dont know how long its gonna take

Moreso, is it possible to overwrite the same...

Hi,

I am using following command to convert from ebcdic to ascii :-

dd if=input_file of=out_file conv=ascii

but, since input_ile itself is 10 GB big, out_file becomes around 2 to 3 times...

yeah , I just figured out the way ...

Using sed, I am able to do it ...

sed -n '
/f8f8/{
N
s/f8f8 *\n*f5f0 *\n*f0f0 *\n*f1f7 *\n*f4f6 *\n*f7c1//
p
}' file | tail -1


Thx..

Hi,

I have to look for the full string below in a large file(>5GB) , but that string may be spread in two lines.

string :-- "f8f8 f5f0 f0f0 f1f7 f4f7 f7c1"

By grep "f8f8 f5f0 f0f0 f1f7 f4f7...

Hi,

I have to search for first occurenceof string str1 in a file(>5GB).

Now, after I have that , I have to search backwards from that offset till I get another string str2. I should also be...