I am able to write a REXX code that generates FREE PACKAGE statements. After generation I use that file in a JCL to execute the FREE PACKAGE statements. Is there a way to execute the FREE PACKAGE statements directly via rexx? I tried executing it like a normal query in REXX, but it throws -104 error. I believe I should not try executing it like a query. Any help would be appreciated.
Is there a way to execute free Package statements using REXX?
386 views Asked by Sudarsan Rajagopalan At
1
There are 1 answers
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in MAINFRAME
- Where can I download ECI resource adapter (cicseci.rar). Unable to find out it in IBM portal
- Mainframe Programming Sorting, OUTFIL REMOVECC,NODETAIL
- Z/OS Cobol 6.3 copy: how to include only a chunk?
- SHA256 Checksum of a File transmitted from Mainframe to Azure
- open fetch and close cursor DB2
- How to "stack" an ISPF command?
- DB2 contention issues
- IBM z/OS TSO ISPF Editor Cancel command - how to add "Are You Sure?" query dialog
- FIlling a zone with S9(5)V9(8) COMP-3
- Mainframe monitoring using Zabbix
- How to programmatically overwrite DCI 2.0 policy via REXX or JCL?
- SEARCH ALL with a key PIC XX
- Why is this COBOL code failing to compile?
- Use MVS Dsname conventions. Mainframe name convention while downloading ftp using python
- COBOL issue (Compiling and executing)
Related Questions in JCL
- Mainframe Programming Sorting, OUTFIL REMOVECC,NODETAIL
- What are JCL Alternitives for Embeded Applications?
- Do I need delimiters on Dataset names for IDCAMS ALTER?
- How do i automate the JCL
- How to process non formatted numeric variable from SYSIN DD from JCL in COBOL
- How to programmatically overwrite DCI 2.0 policy via REXX or JCL?
- Sorting in JCL or COBOL
- How do I write current date and time to a sequential dataset using JCL?
- Replace using Sort in JCL
- I have a VB file of varying record length. I want to convert it in FB file
- Hi there, I am very new to mainframe and JCL, and I need some help understanding what this means/what I have to do
- Is a RECFM=VB dataset required to have a BDW?
- Update the trailer counts using JCL
- MVS ALLOCATE DDNAME to apply to multiple jobs
- Execute multiple JCL job with same name simultaneously
Related Questions in REXX
- Validation of data entry in REXX
- How to "stack" an ISPF command?
- How to use LISTDSI under OMVS
- How to programmatically overwrite DCI 2.0 policy via REXX or JCL?
- REXX Trace and SAY not displaying on the screen
- Getting BPXWUNIX to use the users .profile along with the /etc/profile?
- I need to add a /*XEQ ddcard to a PDS of jobs
- Using BPXWUNIX to invoke sftp with a batch file - host not authenticating
- FSUM7332 - expecting new line when using bpxwunix under z/OS
- Detecting a change on a webpage under Gateway z/OS?
- How to use REXX OUTTRAP external function in TSO
- REXX program that will show a task from DA with the highest CPU usage
- Is it possible to initialize a REXX environment in an IMS BMP region using IRXINIT?
- How to pull console input with non-empty stack in REXX?
- Rexx sleep command
Related Questions in DB2-ZOS
- Problem with Flyway - cannot access to SYSCAT.TABLES
- How to output DB table update count report without accessing Db2 BSDS in BMC Log Master
- Connect to Db2 on z/OS from Windows. Connection failed due to a license error
- How do you get db2 clidriver license db2consv_t.lic?
- How to solve sql error -904 in inserting data
- Replacing the 113th position in a string with 'X' in DB2 SQL
- Cannot get the describe information for the calling stored procedure
- Db2 SQL - how to switch among different where conditions
- Insert/update Hex value to DB2 Z/OS PreparedStatement
- Running SQL PL on DB2 z/OS directly without stored procedures
- Can I index / insert keys to a DB2 large table to speed up selects?
- How do I set "for fetch only" when querying ibm db2 using the jdbc driver from spark?
- Exception "Unknown PrimitiveTypeKind DateTimeOffset" when save model in .Net Framework 4.8 in DB2
- db2 sql query on 4 tables not running? (taking too long?)
- Need suggestion with Procedure code error in DB12 Z/OS
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Since it appears you have SQL working with REXX, you could use SYSPROC.ADMIN_COMMAND_DSN to perform BIND/REBIND/FREE operations. You could call this from REXX.
Here is an example CALL I used via Db2 Command Line Processor to rebind all the packages in a collection: CALL SYSPROC.ADMIN_COMMAND_DSN ('REBIND PACKAGE (DSNESPCS..())',?) #
So you would replace the 'REBIND PACKAGE...' with your BIND/REBIND/FREE commands.
There are administrative procedures delivered with Db2 for z/OS enable you to run commands, and many other administrative operations: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/sqlref/src/tpc/db2z_suppliedstoredprocedures.html
It's mentioned above not running on the same LPAR could be a challenge. An alternate approach if you need to run commands remotely would be to create Db2 for z/OS Native Rest Services for Db2 stored procedures. So another viable option would be creating a rest service on SYSPROC.ADMIN_COMMAND_DSN, pass in the bind parameter, and execute BIND/REBIND/FREE via REST API. Then you could run the commands remotely using Java, Python, Node, etc.