Set of 2 records as one unit Post: 302558965

Sponsored Content

Top Forums Shell Programming and Scripting Set of 2 records as one unit Post 302558965 by PG3 on Monday 26th of September 2011 02:57:44 AM

09-26-2011

Registered User

Scrutinizer,

Thank you for the reply.

To make it a bit more clear, SETT is the final part of the puzzle & is an abbreviation for SETTLEMENT. These three records have to looked at together and if any of these three i.e., AUTH(AUTHORIZATION), PRES(PRESENTMENT) & SETT(SETTLEMENT) are not there then it is considered as INCOMPLETE record. We report only on COMPLETE SETS and only when you find all these three transactions then we would want to see that ACCOUNT NUMBER.

So, if you can just print only the account numbers that have all these three types of records, then we are good.

I hope Im clear now and in case of questions, please feel free to revert back to me and I shall respond back right away.

Thank you for the initiative & your BIG HELP.

regards,
PG.

PG3

View Public Profile for PG3

Find all posts by PG3

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Cutting a limited or given set of records in a datbase

I need to select "cut" a certain number of records in a database. ie. records 20 to 25. Help

2. Shell Programming and Scripting

Getting MAC from GPS unit

Never mind i got the answer thanks.,

3. UNIX for Dummies Questions & Answers

seperating records with numbers from a set of numbers

I have two files one (numbers file)contains the numbers(approximately 30000) and the other file(record file) contains the records(approximately 40000)which may or may not contain the numbers from that file. I want to seperate the records which has the field 1=(any of the number from numbers...

4. Shell Programming and Scripting

Based on num of records in file1 need to check records in file2 to set some condns

Hi All, I have two files say file1 and file2. I want to check the number of records in file1 and if its atleast 2 (i.e., 2 or greater than 2 ) then I have to check records in file2 .If records in file2 is atleast 1 (i.e. if its not empty ) i have to set some conditions . Could you pls...

5. Shell Programming and Scripting

extract set of matching records

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 record begins eg: X|Rec1| A|Rec1| Y|Rec1| X|Rec2| Y|Rec2| Z|Rec3| X|Rec4| M|Rec4| ...

6. Shell Programming and Scripting

Adding existing set of records in the same file

I have a file with 50,000 records in it, i have a requirement to use the same 50,000 records and add them 4 times to the same file to make a total of 200,000 records. I was wondering how to do this using ksh. Any help is greatly appreciated.

7. HP-UX

Load average unit

Hi, On load average graph, unit is 100m, 200m, 300...800m. I don't understand what it means. Thx for helping

8. Shell Programming and Scripting

Compare two files with different number of records and output only the Extra records from file1

Hi Freinds , I have 2 files . File 1 |nag|HYd|1|Che |esw|Gun|2|hyd |pra|bhe|3|hyd |omu|hei|4|bnsj |uer|oeri|5|uery File 2 |nag|HYd|1|Che |esw|Gun|2|hyd |uer|oi|3|uery output :

9. UNIX for Dummies Questions & Answers

Simple unit script

Hello guys this is my first post in this forum. Since now ive been passive an ive only been looking for existing information. Now I could use specific help on a UNIX script i want to make that would: 1. Take 1-3 arguments. 2. Display the contents of its arguments, formatted as follows:...

LEARN ABOUT DEBIAN

amtterm

amtterm(1)						      General Commands Manual							amtterm(1)

NAME

       amtterm - Intel AMT serial-over-lan (sol) client.

SYNOPSIS

       amtterm [ options ] host [ port ]

DESCRIPTION

       amtterm	provides access to the serial-over-lan port of Intel AMT managed machines.  host is the hostname or IP address of the machine amt-
       term should connect to.	port is the tcp port to use and defaults to 16994 (standard AMT redirection port) if unspecified.

       For more inforamtions on Intel AMT check amt-howto(7).

OPTIONS

       -h     Display help text.

       -v     Be verbose (default).

       -q     Be quiet.

       -u <user>
	      Specify username, defaults to "admin".

       -p <pass>
	      Specify password.  amtterm will prompt on the terminal if unspecified.

ENVIRONMENT

       AMT_PASSWORD
	      Default value for the password.

SEE ALSO

       gamt(1), amttool(1), amt-howto(7)

AUTHOR

       (c) 2007 Gerd Hoffmann <kraxel@redhat.com>

							      (c) 2007 Gerd Hoffmann							amtterm(1)