Need code for updating second record to first record in shell 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..
Result as follows
Above statement always displays 1 or 2 records.If the above query returns 2 rows then i need to update it to 1 row like below
And then i need to execute INSERT statements by using ID as a parameter.
whenever i use ${ID} it should be place with the updated value 1.
insert into <TABLE>values ();
For the above requirement, i need to implement it in shell scripting and i am using nzsql.
Thanks in advance.
Cheers,
Samah
Last edited by Don Cragun; 06-28-2016 at 09:13 PM..
Reason: Fix CODE tags inside CODE tags.
Hi,
I am new to UNIX scripting and woiuld appreicate your help...
Input file contains only one (but long) record:
aaaaabbbbbcccccddddd.....
Desired file:
NEW RECORD #new record (hardcoded) added as first record - its length is irrelevant#
aaaaa
bbbbb
ccccc
ddddd
...
...
... (1 Reply)
My input file like this
01,011600033,011600033,110516,0834,2,90,,2/
02,011600033,011103093,1,110317,0834,,2/
03,105581,,015,+00000416418,,,901,+00000000148,,,922,+00000000354,,/
49,+00000000000416920,00002/
03,113806,,015,+00000559618,,,901,+00000000096,,,922,+00000000621,,/... (1 Reply)
My input file like this
03,105581,,015,+00000416418,,,901,+00000000148,,,922,+00000000354,,/
03,113806,,015,+00000559618,,,901,+00000000096,,,922,+00000000621,,/
03,188986,,015,+00005211517,,,901,+00000002227,,,922,+00000005308,,/... (6 Replies)
Hi,
I have a input file with the following entries:
1one
2two
3three
1four
2five
3six
1seven
1eight
1nine
2ten
The output should be
1one
2two
3three
1four
2five
3six (2 Replies)
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)
find pattern, delete line with pattern and 3 lines above and 8 lines below the pattern. The pattern is "isup". The entire record with starting tag <record> and ending tag </record> containing the pattern is to be deleted and the rest to be retained.
<record>
... (4 Replies)
Hi! all
can any one tell me how to compare current record of column with next and previous record in awk without using array
my case is like this
input.txt
0 32
1 26
2 27
3 34
4 26
5 25
6 24
9 23
0 32
1 28
2 15
3 26
4 24 (7 Replies)
PX_PUT_RECORDN(3) Library Functions Manual PX_PUT_RECORDN(3)NAME
PX_put_recordn -- Stores record in Paradox file at certain position
SYNOPSIS
#include <paradox.h>
int PX_put_recordn(pxdoc_t *pxdoc, char *data, int recpos)
DESCRIPTION
Stores a record in the buffer data into a Paradox file at the given position recpos. The first position has number 0. The function will
determine the data block for this record. If the position is after the last data block, then as many as needed empty data blocks will be
added. If the position is in the middle of a data block and there is no record right before the position, then the position will be recal-
culated to make sure the new record will be stored in the first free slot of the datablock. For example, if a datablock contains H records
and the first call of PX_put_recordn wants to store a record at postion 11, then this will be corrected to position H. PX_put_recordn will
also add an empty data block and store the record as the first record of the second data block. Storing a second record at position 11
again, will be executed without any position change.
data must be constructed with PX_put_data_xxx(3) functions before. It is of the same structure as the record returned by PX_get_record(3)
and PX_get_record2(3).
RETURN VALUE
Returns the record position on success and -1 on failure. The first position has number 0.
SEE ALSO PX_get_record(3), PX_get_record2(3), PX_put_record(3), PX_put_data_byte(3), PX_put_data_short(3), PX_put_data_long(3), PX_put_data_dou-
ble(3), PX_put_data_alpha(3)AUTHOR
This manual page was written by Uwe Steinmann uwe@steinmann.cx.
PX_PUT_RECORDN(3)