DB2 z/OS V8 – DBRM conversion form Uni code to EBCDIC

Mike Bell

DB2 z/OS V8 – DBRM conversion form Uni code to EBCDIC
It isn't just the unicode that is different in V8 NFM. There are version
identifiers in the DBRM, The generated plist for the compiled program is
different also and that requires V8 to understand it.

REPEAT testing until you fully understand the differences. Once you
precompile a program with V8 NFM YES, you are commited to running on V8.
Changing the precompile to NFM YES is the last thing you do after everything
is all the way converted.

If you absolutely have to move a DBRM from V8 to a V7 system, BIND COPY does
work but that requires connections between the subsystems and there are
additional issues. The biggest one is that the package is only usable for
distributed work because V7 does NOT understand the new Plist.

Mike
HLS Technologies

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Basivi Inaganti
Sent: Friday, January 13, 2006 9:48 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 z/OS V8 – DBRM conversion form Unicode to EBCDIC


Hello,

If I would say that I am want to develop an utility/program to convert
Unicode DBRM to EBCDIC assuming there were no new V8 functions in the DBRM.
What you think? Do you see any business justification?

I know that we do have a concern on migration and binding of DBRMs from V8
NFM (development subsystem) to V8 CM/ENFM (production subsystem).

Thanks,
Basivi Inaganti
Database Administration
Office: 614-213-5324
Pager: 888-354-5236
Pager email: [login to unmask email]
email: [login to unmask email]
----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mike Bell

Re: DB2 z/OS V8 – DBRM conversion form Uni code to EBCDIC
(in response to Mike Bell)
One more time, it is difficult but possible to convert a V8 NFM DBRM to
where it would successfully bind on V7. It wouldn't do any good because V7
won't understand the new format of the plist and you still can't run the
program that matches the DBRM.

Mike
HLS Technologies

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Basivi Inaganti
Sent: Friday, January 13, 2006 12:03 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS V8 – DBRM conversion form Uni code to EBCDIC


Mae/Walter,
I am not looking for browse function. I am thinking of converting all SQL
statements form Unicode to EBCDIC in a DBRM such that I can bind the
converted DBRM to V7 or V8 CM/ENFM (if there is a such need in real time,
and looking for what our DB2 gurus think about this idea (may be stupid, I
don't know yet)).

Mike,
Yes, I am partly aware of what you mentioned about other dependences in
DBRM. I am still learning to understand the whole DBRM structure such as
DBRMPDRM (DBRM DEPENDENCY MARKER), DBRMMRIC (CURRENT RELEASE MARKER) etc. I
am still exploring DSNXDBRM, DSNXNBRM and
DSNXPOPT Macros. Mike, I know that you guys already developed some tools on
DBRM, it might be easy for you to come up with new tool for this conversion.
Off course the DB2 world need to see the real use of it, in real time
situation. I do have basic idea how we can develop a tool and need to put
all the parts together that I gather so far.

Thanks,
Basivi Inaganti
Database Administration
Office: 614-213-5324
Pager: 888-354-5236
Pager email: [login to unmask email]
email: [login to unmask email]
----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm