473,396 Members | 1,997 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

DB2/zOS: Recreate DBRMs from remote bounded packages

Hallo,

I need to recreate (lost) DBRM-sources from packages
to BIND them on another DB2 system
which is not accessible via DDF (for remote BIND).

I've written a REXX program to recreate DBRM-sources from the data in
SYSIBM.SYSPACKSTMT: reblock to FB(80) and some additional
informationen: 'DBRM'||X(16+LENGTH(Stmt))+X(SECTNO)+X(0)+X(QUERYN O)+X(20)+SUBSTR(Stmt,5).

It works fine for DBRMs bound from a DBRMLIB ( BIND PACKAGE/PLAN ...
LIBRARY() MEMBER() ... ) but not for remote bound packages.

Does anybody has an idea how to do or where to find information
between the differences in SYSIBM.SYSPACKSTMT between local and remote
bound packages?

So long, Rudi
Nov 12 '05 #1
0 1453

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Carmine | last post by:
I need to import a huge .ixf file from a pc to db2 v7 zos. Is there a way to stop archive logging while the data is being imported? If not, is it safe to delete archive logs that haven't...
1
by: Prem K Mehrotra | last post by:
Is there a way to see current settings of DSNZPARM using trace or some other command. If yes, what exactly is the command. I come from Oracle background. In Oracle there is show parameter all...
4
by: Mark | last post by:
I am running DB2 V8.1 ESE client running on Windows XP Professional configured to connect directly to DB2 V6.1.2 on OS/390. I can connect to the OS/390 DB2 database (DB2 subsystem). But when I try...
6
by: bikkaran | last post by:
how to create a exact replica of a database. I have a database . There must be some structure of it. I want to recreate the same structure of the database on some another new server . Please...
1
by: geoff | last post by:
Hi All, I am accessing db2 for zOS from a windows xp client and trying to find out how many times a select or update sql statement is executed. I am able to do this easily in db2 for windoze...
3
by: geoff | last post by:
I have a table called 'employee' with one column called 'name', a varchar. If I execute the following insert statements: insert into employee(name) values ('jones') insert into employee(name)...
2
by: pratcp | last post by:
I have a remote server (a shared hosting webserver) where I have few users ftp some flat files. I need to access these files using a windows app/windows service written using c# and run it on a...
3
by: karanbikash | last post by:
Hi , I would like to know : 1.how to find all the schema in my DB2 database on Main frame machine . 2. How to see all the tables for a given schema . 3. What are the default schema in Db2 on...
5
by: agarwasa2008 | last post by:
Hi, I have a linked table called tbltest and some bounded forms (which add, update, delete records) that were created using that linked table. For some necessary reasons I had to create another...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.