Task: Generate an RPC service based on travelling information by entering a start and end value. Then process the service on your PC via Excel.

This transaction uses dynamic input fields to enable you to view different ranges of data each time you run it. The RPC Generation is executed in Context mode.

Prerequisites

Your administrator has to set the Service Type of the Service Generation Options in you user profile to R.

If you Server is running under Natural Security, you have to set up your RPC example client to run this example correctly.

To set up the RPC sample client for Natural Security

1. Execute the Program USR1071P from the system library SYSEXT in your Natural for Windows.

2. Fill the following fields in the appearing screens as follows:

   • Set RPC Data field to X

   • Set Code field to T

   • Set User-ID field to the Logon-ID of Natural Mainframe

   • Set User ID's Password field to the Password of Natural Mainframe

Transaction Specification

Primary File	SAG-TOURS-E-PERSON
Display Fields	1: FIRST-NAME-1 2: SURNAME 4: STREET-NUMBER 6: ZIP-CODE 7: CITY 9: COUNTRY
Sort Fields	S1: COUNTRY S2: SURNAME
Dynamic Input Fields	NAME-START NAME-END
Selection Criteria	SURNAME = NAME-START THRU NAME-END

This section covers the following topics:

• Create the Transaction SAMPLE10

• Generate the RPC Service

• Proceed the data on your PC

---

Create the Transaction SAMPLE10

To Add a Transaction

1. Issue the ADD TRANSACTION SAMPLE10 command.

   The Add Transaction window appears with the transaction name already entered in the Transaction ID field.

2. Type the description "Dynamic Input Fields in the Description field" (optional).

To Choose File

The report requires data from the fileSAG-TOURS-E-PERSON.

1. Type the file name SAG-TOURS-E-PERSON in the File Name field. You can alternatively use the Asterisk (*) List function.

2. Press Enter.

   The Worksheet appears.

To Choose Fields

The report requires data stored in the fields SURNAME, FIRST-NAME-1, STREET-NUMBER, COUNTRY, ZIP-CODE and CITY.

• Choose the fields as described in Step 3 of Sample 1.

To Determine Display Sequence

1. Type " 1" in the Sequence column next to the field FIRST-NAME-1.

2. Type "2" in the Sequence column next to the field SURNAME.

3. Type "4" in the Sequence column next to the field STREET-NUMBER.

4. Type "6" in the Sequence column next to the field ZIP-CODE.

5. Type "7" in the Sequence column next to the field CITY.

6. Type "9" in the Sequence column next to the field COUNTRY.

To Define Sort Order

1. Type "S1" in the S/C column next to the field COUNTRY.

2. Type "S2" in the S/C column next to the field SURNAME.

To Define Dynamic Input Fields

1. Type NAME-START into the Field Name column and press Enter.

   The Define User Field window appears:

2. Fill in the required information as shown in the following screen:

   20:10 ***** SUPER NATURAL ***** 2000-10-17 SAMPLE10 - Worksheet - SN3011 !------------------------------------------------------! Ref DB Field Name ! Define User Field ! AE 1K 2 SURNAME ....... ! Field: NAME-START ! AF 1 2 FIRST-NAME-1 .. ! ! AL 1 2 STREET-NUMBER . ! Name or value .. NAME-START____________________ ! AM 1K 2 COUNTRY ....... ! Format ......... a ! AN 1K 2 ZIP-CODE ...... ! Length ......... 20_ ! AO 1K 2 CITY .......... ! Dec. places .... _ ! BI NAME-START .... ! Subfield of .... ________________________________ ! BJ _______________ ! Offset ......... ___ ! BK _______________ ! Dynamic input .. # ! BL _______________ !------------------------------------------------------! BM _______________ BN ________________________________ BO ________________________________ BP ________________________________ Command ===> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Exit Flip Canc

3. Press Enter.

   The Worksheet appears. The field NAME-START is inserted as a dynamic input field.

4. Proceed for the dynamic input field NAME-END just as NAME-START.

   Now your Worksheet looks as follows:

   20:18 ***** SUPER NATURAL ***** 2000-10-17 A-SMPL2 - Worksheet - SN3011 Ref DB Field Name Seq S/C Func Def Info Del AE 1K 2 SURNAME ........................ 2__ S2_ __ __ __ AF 1 2 FIRST-NAME-1 ................... 1__ ___ __ __ __ AL 1 2 STREET-NUMBER .................. 4__ ___ __ __ __ AM 1K 2 COUNTRY ........................ 9__ S1_ __ __ __ AN 1K 2 ZIP-CODE ....................... 6__ ___ __ __ __ AO 1K 2 CITY ........................... 7__ ___ __ __ __ BI # NAME-START ..................... ___ ___ __ __ __ BJ # NAME-END ....................... ___ ___ __ __ __ BK ________________________________ BL ________________________________ BM ________________________________ BN ________________________________ BO ________________________________ BP ________________________________ Fill in required definitions Command ===> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Next Exit Field Incl Flip - + Sel Run Canc

To Define Selection Criteria

The report requires information on the field SURNAME. You must use two dynamic input fields in which you can enter the first value of the field SURNAME you want to see and the last value you want to see when the transaction is run.

1. Press PF10.

   The SELECTION command is issued and the Selection Editor appears.

2. Enter "SURNAME = NAME-START THRU NAME-END" in the editor area.

   The Selection Editor has the following content:

   10:08 ***** SUPER NATURAL ***** 2000-10-04 SAMPLE10 - Selection Editor - SNZUL-S 1 < SURNAME = NAME-START THRU NAME-END > 1 2 < > 2 3 < > 3 4 < > 4 5 < > 5 6 < > 6 7 < > 7 8 < > 8 9 < > 9 10 < > 10 11 < > 11 12 < > 12 13 < > 13 14 < > 14 15 < > 15 Define selection lines or use CONTINUE Command ===> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Next Exit Field Check Flip - + Cont Run Canc

To Run the Transaction

1. Issue the RUN command. This command is allocated to PF11.

2. Press Enter

   The following dialog appears:

   10:08 ***** SUPER NATURAL ***** 2000-10-04 SAMPLE10 - Selection Editor - SNZUL-S !-------------------------------------! ! Dynamic Input Value ! 1 < SURNAME = NAME-START THRU NAM ! Transaction: SAMPLE10 ! 2 < ! ! 3 < ! NAME-START .. g___________________ ! 4 < ! NAME-END .... k___________________ ! 5 < ! ! 6 < !-------------------------------------! 7 < > 7 8 < > 8 9 < > 9 10 < > 10 11 < > 11 12 < > 12 13 < > 13 14 < > 14 15 < > 15 Define selection lines or use CONTINUE Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Print Exit Flip + Posi < > Canc

3. Enter the Start and End value and press Enter.

   The report is displayed:

   2000-10-04 SURNAME = NAME-START THRU NAME-END 1 10:13:20 SAMPLE10 FIRST-NAME-1 SURNAME STREET-NUMBER ZIP-CODE -------------------- -------------------- -------------------- ---------- ----- ANDREAS GASSNER KAERTNER STR. 9 7000 STUTT PETRA GOLDSTEIN WALDWEG 8 8190 WOLFR HEINZ GRAF SCHLOSSWEG 1 6100 GRIES MARGARETHE GROTH BEETHOVENSTR. 34 6000 FRANK JOPP GROTHE WIELANDSTR. 109 6000 FRANK FLORIAN GRUBER DIEBURGERSTR. 54 6100 DARMS ESTER GRUENBERG ROSENWEG 17 6103 GRIES MARTHA GUHLICH THERESE GIESE STR 89 6450 HANAU ROSWITHA HAIBACH POSTFACH 332 6450 HANAU YASMIN HASSEIN DOMWEG 8 6000 FRANK CORNELIA HECK MARIENSTRASSE 18 8000 MUENC CLEMENS HEILBROCK OPELSTRASSE 49 6000 FRANK GERHARD HEINZELMANN VIKTORIASTR. 43 6100 DARMS JOHANNA HELDMANN DARMSTAEDTERWEG 34 6104 SEEHE ANTON HESCHMANN MEERKATZSTR. 8 6000 FRANK Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Print Exit Flip + Posi < > Canc

   2000-10-04 SURNAME = NAME-START THRU NAME-END 13 10:14:11 SAMPLE10 FIRST-NAME-1 SURNAME STREET-NUMBER ZIP-CODE -------------------- -------------------- -------------------- ---------- ----- *** End of report *** Number of records processed: = 178

4. Press PF3.

   The Worksheet appears:

   10:15 ***** SUPER NATURAL ***** 2000-10-04 SAMPLE10 - Worksheet - SN3011 Ref DB Field Name Seq S/C Func Def Info Del AE 1K 2 SURNAME ........................ 2__ S2_ __ __ __ AF 1 2 FIRST-NAME-1 ................... 1__ ___ __ __ __ AL 1 2 STREET-NUMBER .................. 4__ ___ __ __ __ AM 1K 2 COUNTRY ........................ 9__ S1_ __ __ __ AN 1K 2 ZIP-CODE ....................... 6__ ___ __ __ __ AO 1K 2 CITY ........................... 7__ ___ __ __ __ BI # NAME-START ..................... ___ ___ __ __ __ BJ # NAME-END ....................... ___ ___ __ __ __ BK ________________________________ BL ________________________________ BM ________________________________ BN ________________________________ BO ________________________________ BP ________________________________ SELECTION successfully terminated Command ===> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Help Next Exit Field Incl Flip - + Sel Run Canc

Generate the RPC Service

To generate the RPC Service for the transaction SAMPLE10

1. Issue the command GENERATE RPC in the Worksheet of the transaction SAMPLE10 and press Enter.

   The following window appears:

   10:15 ***** SUPER NATURAL ***** 2000-10-04 SAMPLE10 - Worksheet - SN3011 !------------------------------------------! Ref DB Field Name ! RPC-Service Generation ! AE 1K 2 SURNAME ................. ! ! AF 1 2 FIRST-NAME-1 ............ ! The RPC Service will be stored with ! AL 1 2 STREET-NUMBER ........... ! Object Name .............. ! AM 1K 2 COUNTRY ................. ! in Library ............... ! AN 1K 2 ZIP-CODE ................ ! with Generation Mode ..... Context ! AO 1K 2 CITY .................... ! and Result Record Limit .. 1638 ! BI # NAME-START .............. ! ! BJ # NAME-END ................ ! _ Generate with these options ! BK _________________________ ! X Change options before generation ! BL _________________________ ! _ Modify Transaction ! BM _________________________ !------------------------------------------! BN _________________________ BO ________________________________ BP ________________________________ Command ===> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Flip Canc

2. Mark the option Change options before generation and press Enter.

   The following window appears:

   20:18 ***** SUPER NATURAL ***** 2000-10-17 A-SMPL2 - Worksheet - SN3011 !----------------------------------------------! Ref DB Field Name ! RPC-Service - Modify Generation Options ! AE 1K 2 SURNAME ............ ! ! AF 1 2 FIRST-NAME-1 ....... ! RPC Service Object Name ........ ________ ! AL 1 2 STREET-NUMBER ...... ! Library ............ ________ ! AM 1K 2 COUNTRY ............ ! ! AN 1K 2 ZIP-CODE ........... ! Generation Mode ................ C Context ! AO 1K 2 CITY ............... ! Limit of Result Records ........ 1638___ ! BI # NAME-START ......... ! (Max. possible Result Records .. 1638 ) ! BJ # NAME-END ........... !----------------------------------------------! BK ____________________ ! ! BL _________________________ ! _ Modify Transaction ! BM _________________________ !-------------------------! BN _________________________ BO ________________________________ BP ________________________________ Command ===> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12--- Flip Canc

3. Specify the RPC Service Object Name "RPCSMPL2" and the Library NSNSAMPL to generate the RPC Service.

4. Select Generation Mode Context.

5. Delete the Record Limit and press Enter to receive the recommended record limit for the generation.

6. Press Enter.

   The RPC Service is generated. You can view it by logging on to the respective library and choosing the RPC Service Object. You will find the description of the source in the Administration documentation.

Proceed the data on your PC

To proceed the data on your PC

Before you can work with the generated RPC Service, you have to set up your Natural environment and load the example data from the Documentation CD to your Natural for Windows environment. You will find the description how to set up your environment for the RPC Service in Setting up Super Natural.

1. Open your Natural for Windows.

2. Execute User Libraries > NSNSAMPL > Dialogs > Menu by using the Execute button in the symbol list.

   The following dialog appears:

   

3. Select Sample 2 (Dynamic Input) in the Data Retrieval field.

4. Choose Get Data to load the sample data.

   The following dialog appears:

   

5. Enter the start and end value as dynamic input.

6. Select OK.

   The data is loaded from your mainframe environment and displayed on your PC where you can browse the data.

7. In order to proceed with this data on your PC, send it to Excel by selecting the Send to Excel button.

   The selected data is sent to Excel and inserted into a table.