10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,,
I have requirement that i need to get DISTINCT values from a table and if there are two records i need to update it to one record and then need to submit INSERT statements by using the updated value as a parameter. Here is the example follows..
SELECT DISTINCT ID FROM OFFER_GROUP WHERE... (1 Reply)
Discussion started by: Samah
1 Replies
2. Shell Programming and Scripting
Hello,
I have a sample file with the below contents :
Backup Oracle8_P112_PEGA_Archivedel Completed full 10/11/2015 03:50:06PM
Backup Oracle8_G567_PEGA_Archivedel Completed full 10/11/2015 01:15:56PM
Backup Oracle8_P112_PEGA_Archivedel Completed full ... (8 Replies)
Discussion started by: rahul2662
8 Replies
3. Shell Programming and Scripting
I have test.xml
<emp><id>101</id><name>AAA</name><date>06/06/14 1811</date></emp>
<Join><id>101</id><city>london</city><date>06/06/14 2011</date></join>
<Join><id>101</id><city>new york</city><date>06/06/14 1811</date></join>
<Join><id>101</id><city>sydney</city><date>06/06/14... (2 Replies)
Discussion started by: vsraju
2 Replies
4. Shell Programming and Scripting
Hi,
How to add trailer record at the end of the flat file in the unix ksh shell scripting
can you please let me know the procedure
Regards
Srikanth (3 Replies)
Discussion started by: srikanth_sagi
3 Replies
5. Shell Programming and Scripting
Hi,
I think this is the toughest prob :wall: I have ever come across and I thankfully owe all of u for helping me cross this.
cat 1.txt
cat 2.txt
K now. This is what I am looking for.
Output.txt
Here is how my output has been generated.
First, the column one of each file... (6 Replies)
Discussion started by: jacobs.smith
6 Replies
6. Shell Programming and Scripting
On a very new (11.31) hpux machine, I can no longer execute shell fragements like:
if ; then
. .profile.foo
fi
and get "ksh: test: argument expected"
if I convert this to -d or -f as appropriate (which I've not had to do on older versions of hpux (11.23) nor any other unix platform... (9 Replies)
Discussion started by: Peeter Joot
9 Replies
7. Shell Programming and Scripting
Hi Everyone,
Using shell script i am getting final file as attached below. In this 4th column value should be unique using any sequence.
for instance I've 1_13020_SSGM which is appearing 6 times in file and i should change it like 1_13020_SSGM_1,1_13020_SSGM_2,....1_13020_SSGM_6.
Can someone... (4 Replies)
Discussion started by: gehlnar
4 Replies
8. Shell Programming and Scripting
I found some posts describing how to completely clean out a mailbox in Unix/Linux. But I want to keep the 50 most recent messages. Any ideas out there?
Thanks! (3 Replies)
Discussion started by: OPTIMUS_prime
3 Replies
9. Shell Programming and Scripting
input
a 1
a 2
a -1
b 1
b 2
b 3
output
a -1
b 1
Thanx
---------- Post updated at 09:42 PM ---------- Previous update was at 09:10 PM ----------
Ok I managed it (7 Replies)
Discussion started by: repinementer
7 Replies
10. Shell Programming and Scripting
Using SCO 5, Ksh here
I am trying to automate some process that i am doing manually.
During some point of time, I will have to press enter to clear away some messages.
This is how I do manually.
*one command*
r
r
r
r
r
I enter the command once, then press enter key 1 more... (6 Replies)
Discussion started by: khaos83_2000
6 Replies