View previous topic :: View next topic
|
Author |
Message |
er.manishawasthii
New User
Joined: 24 Oct 2008 Posts: 6 Location: Pune
|
|
|
|
Suppose this is the DB structure
Code: |
-----------
| Airport |
-----------
|
v
-----------
| Airline |
-----------
|
v
---------------
| |
v v
----------- -----------
| ARRIVAL | | DEPART |
----------- -----------
|
I need to insert a call for the insertion of arrival and departs of flight
under corresponding airline and airport.
What can be pseudocode for it?
Thank You ! |
|
Back to top |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007 Posts: 295 Location: Singapore
|
|
|
|
Use qualified SSAs for Airport and Airline segments and unqualified ssa for Arrival or Depart segments. |
|
Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
Lucky for me that I checked this forum - I responded in the other forum. The first thing you need to do is to tell us whether this is DLI, BMP, or MPP. You have said - in the other forum - that it is BMP. This means that you most likely have an input file. We need to see the layout for that file. |
|
Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
This can be very easy - all you need to do is to give us ALL of your info. If you give us your input file layout and it includes the airport and airline keys - great! It would also need to include the key values for the arrival and depart segments. The input file would also need to be sorted in that sequence. That is the most simple and easily resolved scenario. |
|
Back to top |
|
|
|