DB2 z/OS V8 – DBRM conversion form Unicode to EBCDIC

Basivi Inaganti

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

Walter Janißen

Re: DB2 z/OS V8 – DBRM conversion form Unicode to EBCDIC
(in response to Basivi Inaganti)
Hello

I don't know, what you exactly mean. Do you want do browse UNICODE-DBRM,
stored in a library?. If so, then there is an ISPF-macro DIS CCSID 273 (or
your EBCDIC-CCSID).

If you want to query SYSPACKSTMT for statements stored in UNICODE, things
get more complex. Most ofthe the time the following expression works:

CAST(CAST(STMT AS
VARCHAR(3500) CCSID 1208) AS
VARCHAR(3500) CCSID EBCDIC)

I am not sure, if that answered your questions.

---------------------------------------------------------------------------------
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

Basivi Inaganti

Re: DB2 z/OS V8 – DBRM conversion form Unicode to EBCDIC
(in response to Walter Janißen)
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

Basivi Inaganti

Re: DB2 z/OS V8 – DBRM conversion form Uni code to EBCDIC
(in response to Basivi Inaganti)
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