Xpediter for Stored Procedure Testing
Xpediter for Stored Procedure Testing
Initial Setups. IMS setup. DB2/IMS setups
Launching XPEDITER for testing
Looking for the XPEDITER source (DDIO)
1) =n:xp
-------------------------- PROGRAMMER'S TOOLBOX -----------------------------
SELECT OPTION ===> =n;xp
More: +
For Application Specific panels enter: A
General Tools: Data Manipulation Tools:
BO BookManager CC CICS C.A.T.S.
DM Dumpmaster DA Datavantage
DS DSPRINT DB DB2
JS Job/Scan FD File-Aid/DB2 6.0.1 TEST DB2S ONLY
PD PDS86 FM FileMarvel
SD SDSF FT FATS (Tape Handling)
VM Version Merger IA IOA/Control-M
XT XACT MQ MQSeries Message Queueing
XU XACT UAT OS Online Syncsort
Performance and Debugging Tools: Language Tools:
TRI Tritune MH MHTRAN2
VS VSUMune SA SAS
XP XPEDITER
DASD Tools:
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
2) Initial Set-up for IMS Stored Procs . Enter 1 for Prepare.
---------------------- XPEDITER/TSO 7.5 - PRIMARY MENU ----------------------
OPTION ===> 1
0 DEFAULTS - Specify defaults
1 PREPARE - Prepare programs for debugging
2 TSO - Debug programs interactively under TSO
3 BATCH - Debug programs interactively under batch
4 STORED PROC - Debug DB2 Stored Procedures interactively
5 UTILITIES - Perform utility functions
F FADB2 - Invoke File-AID for DB2
C CODE COVERAGE - Code Coverage NOT INSTALLED
T TUTORIAL - Display information about XPEDITER/TSO
X EXIT - Exit primary menu
Profile ===> DEFAULT - *** NO DESCRIPTION ***
For Online Technical Support Reference:
COPYRIGHT (C) 2006, Compuware Corporation. All rights reserved.
(800) 538-7822
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
Enter 4 for File Allocation List
------------------ XPEDITER/TSO - PROGRAM PREPARATION MENU ---------------
OPTION ===> 4
1 CONVERT COMPILE JCL - Convert compile JCL for XPEDITER
2 COMPILE FACILITY - Compile programs for XPEDITER
3 BIND FACILITY MENU - Bind application plans or packages
4 EDIT ALLOCATION LIST - Edit or Create file allocation lists
For the COMPILE FACILITY, you may use the Compile Profile field
below as a method of selecting a specific profile that contains
or will contain the desired compile parameters. If an existing
name is entered, the compile parameters previously saved under
that name will be used. If a new name is entered, a new profile
will be created to hold the newly entered compile parameters.
A '?' in the Compile Profile field will display a member list of
existing names permitting profiles to be selected, displayed or
maintained (i.e., COPY, RENAME, DELETE, etc.).
Compile Profile ===> DEFAULT DEFAULT COMPILE PROFILE
Press ENTER to process or enter END command to terminate
Enter for Following Files (DDNAME, DSN, and Disposition). Don’t forget the quotes.
---------------------- XPEDITER/TSO - EDIT FILE LIST 1 ---------- Row 1 Of 4
COMMAND ===> SCROLL ===> CSR
Line Commands: Primary Commands: ...MORE ===>
D (Delete) S (Select detail) CANcel (Quit without saving)
I (Insert) BR (Browse dataset) COPY (Copy JCL or File List)
R (Repeat) ED (Edit dataset) ALLOCate (Allocate and continue)
FB (File-AID Browse) END (Save and End)
FE (File-AID Edit)
File Allocation List: 'MSB6.JCL.LIB(IMS2)'
----------------------- DSNAME ----------------------- DISP
DDNAME DUMMY, HFS, TEMP, TERM, SYSOUT, *, OR A DATASET NAME STAT
-------------------------------------------------------------------------------
''''' IMS ‘IMS.TEST.PSBLIB’ SHR
''''' ‘IMS.TEST.DBDLIB’ SHR
''''' SYSOUT * NEW
''''' DFSRESLB ‘IMS.TEST.RESLIB’ SHR
'''''
Type ALLOCATE and enter. You should see Files Allocated in the top right corner of the screen. Press PF3.
---------------------- XPEDITER/TSO - EDIT FILE LIST 1 ---------- Row 1 Of 4
COMMAND ===> ALLOCATE SCROLL ===> CSR
Line Commands: Primary Commands: ...MORE ===>
D (Delete) S (Select detail) CANcel (Quit without saving)
I (Insert) BR (Browse dataset) COPY (Copy JCL or File List)
R (Repeat) ED (Edit dataset) ALLOCate (Allocate and continue)
FB (File-AID Browse) END (Save and End)
FE (File-AID Edit)
File Allocation List: 'MSB6.JCL.LIB(IMS2)'
----------------------- DSNAME ----------------------- DISP
DDNAME DUMMY, HFS, TEMP, TERM, SYSOUT, *, OR A DATASET NAME STAT
-------------------------------------------------------------------------------
''''' IMS ‘IMS.TEST.PSBLIB’ SHR
''''' ‘IMS.TEST.DBDLIB’ SHR
''''' SYSOUT * NEW
''''' DFSRESLB ‘IMS.TEST.RESLIB’ SHR
'''''
3) Initial Set-up for all Stored Procs .
---------------------- XPEDITER/TSO 7.5 - PRIMARY MENU ----------------------
OPTION ===> 2
0 DEFAULTS - Specify defaults
1 PREPARE - Prepare programs for debugging
2 TSO - Debug programs interactively under TSO
3 BATCH - Debug programs interactively under batch
4 STORED PROC - Debug DB2 Stored Procedures interactively
5 UTILITIES - Perform utility functions
F FADB2 - Invoke File-AID for DB2
C CODE COVERAGE - Code Coverage NOT INSTALLED
T TUTORIAL - Display information about XPEDITER/TSO
X EXIT - Exit primary menu
Profile ===> DEFAULT - *** NO DESCRIPTION ***
For Online Technical Support Reference:
COPYRIGHT (C) 2006, Compuware Corporation. All rights reserved.
(800) 538-7822
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
Enter SE for Set-up. Depending on previous use of XPEDITER, your underlying screen may not look like this. All that is important is that you get to the XPEDITER Set-up screen.
Profile: DEFAULT ------ XPEDITER/TSO - STANDARD (2.1) -----------------------
COMMAND ===> se
COMMANDS: SEtup (Display Setup Menu)
PROFile (Display Profile List)
TEST SELECTION CRITERIA:
Program ===>
Entry Point ===>
Load Module ===>
Initial Script ===>
Post Script ===>
PARM ( Caps = YES ) ===>
File List/JCL Member ===>
Preview Files? ===> NO
Is This a DB2 Test? ===> NO Plan ===> System ===>
Press ENTER to process or enter END command to terminate
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
Enter 0 (zero) for Environment
Profile: DEFAULT ------- XPEDITER/TSO - SETUP MENU --------------------------
OPTION ===> 0
0 ENVIRONMENT - Execution environments menu
1 LOADLIBS - Application load module libraries
2 DDIO - DDIO files
3 INCLUDES - Test script libraries
4 LOG - Session log dataset disposition
5 SCRIPT - Test script dataset disposition
6 DSNLOAD - DB2 system names and DSNLOAD libraries
D DOCUMENT - Document dataset disposition
E EXTENDED - Extended Setup Menu
A ALL - Display all of the above in succession (except 0)
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
Enter 12 for Testing DB2 Stored Procedures interactively
Profile: DEFAULT ------ XPEDITER/TSO - ENVIRONMENTS MENU --------------------
OPTION ===> 12
XPEDITER/TSO
==> 1 STANDARD - Test a program with no special environment services
2 DIALOG - Test programs that make ISPF dialog manager calls
3 IMS - Test a program that makes IMS/DB calls
4 BTS - Test programs using BTS
DB2 STORED PROCEDURES
12 DB2SP - Test DB2 Stored Procedure interactively
Note: The environment highlighted is currently selected.
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
Press PF3 to return to the Setup Main Menu
Enter an A to walkthrough/review all Setup screens
Profile: DEFAULT ------- XPEDITER/TSO - SETUP MENU -------------------------
OPTION ===> a
0 ENVIRONMENT - Execution environments menu
1 LOADLIBS - Application load module libraries
2 DDIO - DDIO files
3 INCLUDES - Test script libraries
4 LOG - Session log dataset disposition
5 SCRIPT - Test script dataset disposition
6 DSNLOAD - DB2 system names and DSNLOAD libraries
D DOCUMENT - Document dataset disposition
E EXTENDED - Extended Setup Menu
A ALL - Display all of the above in succession (except 0)
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
Copy and paste the following screens where necessary. Press enter after each screen
Profile: DEFAULT ---------- LOAD MODULE LIBRARIES ---------------------------
COMMAND ===>
COMMANDS: DOWN (for additional User Libraries)
User Libraries: --->>> Include any libraries your program requires 'SCLMTFS.FREEZE.LOADSP'
(4) ===> 'SCLMTFS.PRD.LOADSP'
(5) ===> 'DSNC.MODLIB'
(6) ===> 'DSNC.DSNLOAD'
(7) ===> 'IMS.TEST.RESLIB'
(8) ===> 'IMS.TEST.TST1NUC.MDALIB'
Installation Libraries: (This list contains overrides to installed defaults)
(9) ===> 'SYS1.SCEELPA'
(10) ===> 'SYS1.SCEERUN'
(11) ===> 'SYS1.SCSQANLE'
(12) ===> 'SYS1.SCSQAUTH'
(13) ===>
(14) ===>
(15) ===>
(16) ===>
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
Profile: DEFAULT -------- XPEDITER/TSO - DDIO FILES ------------------------
COMMAND ===>
User Libraries:
(1) ===> 'XPEDITER.TFSDEVA.DDIO'
(2) ===> 'XPEDITER.TFSFREEZ.DDIO'
(3) ===> 'XPEDITER.TFSPRD.DDIO'
(4) ===>
(5) ===>
(6) ===>
Installation Libraries: (Changes made here will override installed defaults)
(7) ===>
(8) ===>
(9) ===>
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
Profile: DEFAULT --- XPEDITER/TSO - TEST SCRIPT LIBRARIES ----------------
COMMAND ===>
User Libraries:
(1) ===>
(2) ===>
(3) ===>
Installation Libraries: (Changes made here will override installed defaults)
(4) ===>
(5) ===>
(6) ===>
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
------------------------- XPEDITER/TSO - LOG DATASET ------------------------
COMMAND ===>
Log Dataset Name: (DSNAME will be generated if blank)
DSNAME ===>
Allocation Parameters: Process Options: A (Append)
Data Class ===> D (Delete)
Space Units ===> TRK K (Keep)
Primary ===> 5 PD (Print-Delete)
Secondary ===> 2 PK (Print-Keep)
Storage Class ===> ? (Prompt)
Unit ===>
Volume ===>
Disposition After the Test:
Process Option ===> D (D, K, PD, PK, or ?)
Disposition Before the Test:
Process Option ===> D (A, D, or ? Used only if DSNAME is specified)
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
----------------------- XPEDITER/TSO - SCRIPT DATASET -----------------------
COMMAND ===>
Script Dataset Name: (DSNAME will be generated if blank)
DSNAME ===>
Allocation Parameters: Process Options: A (Append)
Data Class ===> D (Delete)
Space Units ===> TRK K (Keep)
Primary ===> 5 PD (Print-Delete)
Secondary ===> 2 PK (Print-Keep)
Storage Class ===> ? (Prompt)
Unit ===>
Volume ===>
Disposition After the Test:
Process Option ===> D (D, K, PD, PK, or ?)
Disposition Before the Test:
Process Option ===> D (A, D, or ? Used only if DSNAME is specified)
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
Profile: DEFAULT ----- XPEDITER/TSO - DSNLOAD LIBRARIES ---------------
COMMAND ===>
NAME DSNLOAD DSNAME
(1) ===> DSNC ===> 'DSNC.DSNLOAD'
(2) ===> DSNB ===> 'DSNB.DSNLOAD'
(3) ===> DSNA ===> 'DSNA.DSNLOAD'
(4) ===> ===>
(5) ===> ===>
(6) ===> ===>
(7) ===> ===>
(8) ===> ===>
Note: Changes made to this screen override installed defaults
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
---------------------- XPEDITER/TSO - DOCUMENT DATASET ----------------------
COMMAND ===>
More: +
Document Dataset Name: (DSNAME will be generated if blank)
DSNAME ===>
Allocation Parameters: Process Options: A (Append)
Data Class ===> D (Delete)
Space Units ===> TRK K (Keep)
Primary ===> 5 PD (Print-Delete)
Secondary ===> 2 PK (Print-Keep)
Storage Class ===> ? (Prompt)
Unit ===>
Volume ===>
Disposition After the Test:
Process Option ===> D (D, K, PD, PK, or ?)
Disposition Before the Test:
Process Option ===> D (A, D, or ? Used only if DSNAME is specified)
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
The following screen is the last Set-up screen. Press PF3 to return to the Main Setup Menu.
Profile: DEFAULT ------- XPEDITER/TSO - SETUP MENU -----------------------
OPTION ===>
Extended Setup Menu
N NEW - NEW dataset Allocations for this TEST Profile
W WORK - WORK dataset Allocations for this TEST Profile
D Difference - Display Difference from Installation Defaults
I Inquire - Display Test Settings for this TEST PROFILE
Press ENTER to process or enter END command to terminate
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
Press PF3 again to get out of the Main Setup Menu (below)
Profile: DEFAULT ------- XPEDITER/TSO - SETUP MENU ------------------------
OPTION ===>
0 ENVIRONMENT - Execution environments menu
1 LOADLIBS - Application load module libraries
2 DDIO - DDIO files
3 INCLUDES - Test script libraries
4 LOG - Session log dataset disposition
5 SCRIPT - Test script dataset disposition
6 DSNLOAD - DB2 system names and DSNLOAD libraries
D DOCUMENT - Document dataset disposition
E EXTENDED - Extended Setup Menu
A ALL - Display all of the above in succession (except 0)
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
4) Executing a Store Proc using XPEDITER
Now you are ready to test a Stored Procedure. In this case, I want to test TSTDA.ASMPC205.
PROFILE: DEFAULT- XPEDITER/TSO - DB2 Stored Procedure (2.12) ----------------
COMMAND ===>
COMMANDS: SEtup (Display Setup Menu)
PROFile (Display Profile List)
Schema Name ===> TSTDA
Stored Procedure Name
or UDF ===> ASMPC205
Client End UserID
or PC Account Code
or IP Address ===> MSB6
DB2 Subsystem Name ===> DSNC (DSNC,DSNB,DSNA)
aximum Number of Tests ===> 1 (1 - 9999)
Initial Script ===>
Post Script ===>
File List/JCL Member ===> 'MSB6.JCL.LIB(IMS2)'
Preview Files? ===> NO
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
Pressing enter starts XPEDITER testing but if you get this, there is no XPEDITER Source file. You’ll need to recompile ASMPC205 to DEVA
------------------------- XPEDITER/TSO - LOG ---------------------------------
COMMAND ===> SCROLL ===> CSR
NO SOURCE LISTING DATA SET MEMBER FOR ASMPC205
----------------------------------------------------------- Before ASMPC205 ->
: DATE: 01/24/2010 :
: NORTHERN TRUST COMPANY TIME: 22.50.23 :
: SYSTEM: SYSA :
+-----------------------------------------------------------------------------+
XPED DSP SPF
DB2SP DBSYS DSNC
DBNM1 ASMPC205
DBMOD ASMPC205
DBUID MSB6
DBMAX 1
DBSC1 TSTDA
TEST ASMPC205
PARM 'DSNC,1,XPAE0001'
*** ASMPC205 FROM SCLMTFS.PRD.LOADSP LINK 09/30/09
XPD2214 ADSRA221 LE ENVIRONMENT RECOGNIZED
NO SOURCE LISTING INFORMATION FOUND FOR MODULE
******************************** BOTTOM OF DATA ********************************
PF 1=HELP 2=PEEK CSR 3=END 4=EXIT 5=FIND 6=LOCATE *
PF 7=UP 8=DOWN 9=GO 1 10=LEFT 11=RIGHT 12=G
5) How to determine if XPEDITER has source for your module
From XPEDITER’s Main Menu, Enter 5 for Utilities.
---------------------- XPEDITER/TSO 7.5 - PRIMARY MENU ----------------
OPTION ===> 5
0 DEFAULTS - Specify defaults
1 PREPARE - Prepare programs for debugging
2 TSO - Debug programs interactively under TSO
3 BATCH - Debug programs interactively under batch
4 STORED PROC - Debug DB2 Stored Procedures interactively
5 UTILITIES - Perform utility functions
F FADB2 - Invoke File-AID for DB2
C CODE COVERAGE - Code Coverage NOT INSTALLED
T TUTORIAL - Display information about XPEDITER/TSO
X EXIT - Exit primary menu
Profile ===> DEFAULT - *** NO DESCRIPTION ***
For Online Technical Support Reference:
COPYRIGHT (C) 2006, Compuware Corporation. All rights reserved.
(800) 538-7822
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
Enter 3 for DDIO File Facilities.
----------------------- XPEDITER/TSO - UTILITIES MENU -----------------------
OPTION ===> 3
1 REGION SIZE - Display memory available for testing
2 LIST ALLOCATES - Display files allocated to your test session
3 DDIO FILE FACILITY - Create/Format/Copy/Export and list DDIO file(s)
5 CONVERT PROFILE - Convert XPEDITER/TSO release 5.1 user profiles
6 CONVERT INCLUDE - Convert include scripts to new qualification rules
7 MERGE - Merge profiles from alternate users
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
Select the DEVA DDIO PDS (Enter the PDS name is applicable).
---------- CSS UTILITIES - Source Listing File Facility -------- CSS V8.3.0
COMMAND ===>
Commands: SEtup DDIOCALC (DDIO calculator)
DD (DDIO tutorial) SD (SD/DB tutorial) LP (LP tutorial)
Processing Options for S/Member List: Source Browsing Options:
Confirm Delete ===> YES (Yes or No) Unit ===> VIO
Show print setup ===> YES (Yes or No) Blocking ===> 10
Language ===> ENGLISH (ENGLISH/JAPANESE/USAMIX/USAUC)
SEL Options: C (Create) I (Info) S (Member List) A (Adv Function)
M (Move/Copy/Export/Import)
SEL ---- Source Listing Shared Directories/Databases/DDIO files ----
_ ______________________________________________
s (1) 'XPEDITER.TFSDEVA.DDIO'
_ (2) 'XPEDITER.TFSPRD.DDIO'
(3)
(4)
(5)
(6)
(7)
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
Do a (L)ocate for the stored proc you wish to test. There should be at least one version in the DDIO PDS.
COMPUWARE/VF -- Source Listing File Member List ---------------- Row 1 of 5889
COMMAND INPUT ===> l ASMPC205 SCROLL ===> PAGE
Source DDIO File: XPEDITER.TFSDEVA.DDIO
SELECT S - Select P - Print D - Delete L - Lock U - Unlock
CODE PROGRAM LIST NUMBER COMP DATE TIME RC LANGUAGE SIZE(K)
______ GDSSTUB (L) 322956 24 JAN 2010 23:15:11 04 COB/Z V4R1 468
______ APRB235E (L) 322955 24 JAN 2010 23:10:22 04 COB/Z V4R1 468
______ OITB041E (L) 322951 24 JAN 2010 22:00:42 00 COB/Z V4R1 468
______ GDAB920U (L) 322950 24 JAN 2010 21:55:52 04 COB/Z V4R1 3977
______ FNDB620F (L) 322948 24 JAN 2010 20:18:07 04 COB/Z V4R1 1404
______ AIPB865F (L) 322947 24 JAN 2010 18:34:57 04 COB/Z V4R1 234
______ TAXC350 (L) 322945 24 JAN 2010 17:00:10 04 PL1EN V3R7 702
______ AIPBAD2E (L) 322944 24 JAN 2010 16:53:04 04 COB/Z V4R1 468
______ AIPBAD2M (L) 322942 24 JAN 2010 16:37:49 04 COB/Z V4R1 468
______ TIARNMCH (L) 322938 24 JAN 2010 15:10:35 04 COB/Z V4R1 468
______ CSTB240E (L) 322935 24 JAN 2010 12:36:22 04 COB/Z V4R1 1872
______ HR28DB2 (L) 322934 24 JAN 2010 12:22:11 00 COB/Z V4R1 234
______ PRXP915 (L) 322933 24 JAN 2010 12:06:33 08 PL1EN V3R7 468
______ AIPB837F (L) 322931 24 JAN 2010 11:48:19 04 COB/Z V4R1 234
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
To build the module for XPEDITER, turn on the XPEDITER switch prior to doing a Build
SCLM Main Menu z/OS 1.9
Option ===>
More:
Enter one of the following options:
1 View ISPF View or Browse data
2 Edit Create or change source data in SCLM databases
3 Utilities Perform SCLM database utility/reporting functions
4 Build Construct SCLM-controlled components
5 Promote Move components into SCLM hierarchy
6 Command Enter TSO or SCLM commands
6A Easy Cmds Easy SCLM commands via prompts
X Exit Terminate SCLM
SCLM Project Control Information:
Project . . . . SCLMTFS (Project high-level qualifier)
Alternate . . . (Project definition: defaults to project)
Group . . . . . DEVA (Defaults to TSO prefix)
Xpediter => Y (Y/N) Package => N (Y/N) Firecall => N (Y/N)
After a successful SCLM build, back go to =N;XP;5;3. The XPEDITER source is now available.
COMPUWARE/VF -- Source Listing File Member List ---------------- Row 2 of 5891
COMMAND INPUT ===> SCROLL ===> PAGE
Source DDIO File: XPEDITER.TFSDEVA.DDIO
SELECT S - Select P - Print D - Delete L - Lock U - Unlock
CODE PROGRAM LIST NUMBER COMP DATE TIME RC LANGUAGE SIZE(K)
______ ASMPC205 (L) 322964 25 JAN 2010 01:39:59 04 COB/Z V4R1 1404
______ GLACI05 (L) 322963 25 JAN 2010 01:23:53 04 COB/Z V3R4 2807
______ PRXP310 (L) 322961 25 JAN 2010 00:24:51 08 PL1EN V3R7 468
______ GDAB941 (L) 322960 25 JAN 2010 00:11:13 00 COB/Z V4R1 1404
______ PTTB003F (L) 322958 24 JAN 2010 23:40:43 00 COB/Z V4R1 234
______ APRB235E (L) 322957 24 JAN 2010 23:24:40 04 COB/Z V4R1 468
______ GDSSTUB (L) 322956 24 JAN 2010 23:15:11 04 COB/Z V4R1 468
______ OITB041E (L) 322951 24 JAN 2010 22:00:42 00 COB/Z V4R1 468
______ FNDB620F (L) 322948 24 JAN 2010 20:18:07 04 COB/Z V4R1 1404
______ AIPB865F (L) 322947 24 JAN 2010 18:34:57 04 COB/Z V4R1 234
______ TAXC350 (L) 322945 24 JAN 2010 17:00:10 04 PL1EN V3R7 702
______ AIPBAD2E (L) 322944 24 JAN 2010 16:53:04 04 COB/Z V4R1 468
______ AIPBAD2M (L) 322942 24 JAN 2010 16:37:49 04 COB/Z V4R1 468
______ TIARNMCH (L) 322938 24 JAN 2010 15:10:35 04 COB/Z V4R1 468
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
Starting a XPEDITER testing session (=n;xp;2), XPEDITER waits for the stored procedure to start executing
PROFILE: DEFAULT- XPEDITER/TSO - DB2 Stored Procedure (2.12) ----------------
COMMAND ===>
COMMANDS: SEtup (Display Setup Menu)
PROFile (Display Profile List)
Schema Name ===> TSTDA
Stored Procedure Name
or UDF ===> ASMPC205
Client End UserID
or PC Account Code
or IP Address ===> MSB6
DB2 Subsystem Name ===> DSNC (DSNC,DSNB,DSNA)
aximum Number of Tests ===> 1 (1 - 9999)
Initial Script ===>
Post Script ===>
File List/JCL Member ===> 'MSB6.JCL.LIB(IMS2)'
Preview Files? ===> NO
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
PROFILE: DEFAULT-------------------- TEST ------------------ Files Allocated
COMMAND ===>
************************************************
* *
* Entering XPEDITER/TSO Test Environment *
* *
************************************************
* TYPE OF TEST: STORED PROCEDURES *
* PROFILE: DEFAULT *
* STORED PROCEDURE: ASMPC205 *
* DB2 SUBSYSTEM: DSNC *
* USERID: MSB6 *
************************************************
PF 1=HELP 2=SPLIT 3=END 4=RETURN 5=RFIND 6=RCHANGE
PF 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RETRIEVE
Go to RapidSQL and execute a call to stored procedure TSTDA.ASMPC205.
[pic]
The next screen comes up in XPEDITER. Press Enter to begin your testing session.
CEE3740I The following messages pertain to the system default run-time options
CEE3615I The installation default for the run-time option DEBUG could not be o
erridden.
CEE3615I The installation default for the run-time option TEST could not be ov
rridden.
***
Beginning of the test. PF9 – single step. PF12 for next breakpoint.
Entering B on on a line sets a breakpoint
COMMAND ===> SCROLL ===> CSR
BEFORE BREAKPOINT ENCOUNTERED
----+----1----+----2----+----3
MORE-> 01 DB2IO-XML-PARM-1 > .. 01 DB2IO-XML-PARM-2 > .. ...........................
----+----1----+----2----+----3
------ ----------------------------------------- Before ASMPC205/AMODE 31
=====> B PROCEDURE DIVISION USING DB2IO-XML-PARM-1 2233
005109 , DB2IO-XML-PARM-2 2234
005110 , DB2IO-PROXY-NARR 2235
005111 , DB2IO-COMMENT-NARR 2236
005112 , ASMLPARM-USER-ID 2237
005113 , ASMLPARM-MESSAGE-FLAG 2238
005114 , ASMLPARM-TRAN-NAME 2239
005115 , ASMLPARM-TRAN-ID 2240
005116 , ASMLPARM-TRAN-DATE 2241
005117 , ASMLPARM-TRAN-TIME 2242
005118 , ASMLPARM-UNUSED-IN 2243
005119 , ASMLPARM-RETURN-CODE 2244
005120 , ASMLPARM-RETURN-MSG 2245
PF 1=HELP 2=PEEK CSR 3=END 4=EXIT 5=FIND 6=LOCATE *
PF 7=UP 8=DOWN 9=GO 1 10=LEFT 11=RIGHT 12=GO
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- cisb314 database 2
- the oracle database commonly referred to as oracle rdbms
- xpediter for stored procedure testing
- db2 database 2 srinimf
- sql is a standard computer language for accessing and
- university of wisconsin madison
- course module document sam m walton college of business
- relational database rdbms via odbc interface to the pi
Related searches
- free calculator stored on desktop
- procedure for cataract surgery from beginning
- state testing practice testing for 3rd grade
- where are screenshots stored in windows 10
- procedure code for outpatient surgery
- procedure for cleaning up vomit
- procedure code for septal myomectomy
- procedure for back pain
- where is print screen stored windows 10
- where are screenshots stored windows 10
- where are screenshots stored on windows 10
- find stored passwords windows 7