IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Character set conversion from IBM-500


IBM Mainframe Forums -> CLIST & REXX
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
haridossk81

New User


Joined: 22 Sep 2008
Posts: 5
Location: Chennai

PostPosted: Mon Apr 05, 2010 10:56 am
Reply with quote

Hi all,

I request you that I need a Rexx code to convert CHARSET from IBM-500 to IBM-1026 (Iso-turkish).

Actually we run a query through QMF and send the report to users through email. Before send the report, we need to convert them into Turkish code format (IBM-1026,ISO8859-9). This should be done only through REXX code.

Kindly provide me your suggestions.
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Mon Apr 05, 2010 11:09 am
Reply with quote

haridossk81 wrote:
This should be done only through REXX code.
Only?
Are you rejecting any other method, however simple or already available on your system or in your current process?
Back to top
View user's profile Send private message
haridossk81

New User


Joined: 22 Sep 2008
Posts: 5
Location: Chennai

PostPosted: Mon Apr 05, 2010 11:28 am
Reply with quote

Hi CICS Guy,

Please do not take it in wrong way. We need solution only through REXX code as per client request.
We have a solution through JCL with 3 steps, 1. run QMF query, 2. Code conversion thro EDCICONV Jcl, and 3. send converted report to users thro email.

As It will be hard to use Batch for users, we request for a solution only thro REXX code.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Mon Apr 05, 2010 12:53 pm
Reply with quote

QMF in Rexx :

publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.qmf.doc.intro/dsqa2mst38.htm

Convert character set :

publib.boulder.ibm.com/infocenter/zos/v1r9/index.jsp?topic=/com.ibm.zos.r9.cbcux01/cbcug160290.htm

Transfer files :

see this forum or google
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Mon Apr 05, 2010 1:26 pm
Reply with quote

Quote:
Please do not take it in wrong way. We need solution only through REXX code as per client request.


Your company before getting into the consulting business should have planned to acquire the proper skills to satisfy the client' s requests!

or better alternative have gained the client' s esteem/trust to have it' s ( Your company )
proposals and solutions accepted by the client as long as they support the requirements

or encore be the driving force in setting the the tools/practices to be used to satisfy the client' s requirements

unless, naturally, Your company is just doing the donkey' s work ( is not a partner in decision making )

many of us replying to question are consultants,
and ethics dictates that we acquire the skills we are selling on our own,
not ask anybody else to provide them at no charge
Back to top
View user's profile Send private message
haridossk81

New User


Joined: 22 Sep 2008
Posts: 5
Location: Chennai

PostPosted: Mon Apr 05, 2010 1:47 pm
Reply with quote

Hi all,

We already have solution with JCL utility. But users do not have option to use batch / JCL. They will just run query through QMF and sent report to users through QMF.
We have a request to convert the report into iso-turkish code charset before send them to users.
As per client request, we need this code conversion to be done through REXX code. Please provide your suggestions.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Mon Apr 05, 2010 1:52 pm
Reply with quote

Quote:
As per client request, we need this code conversion to be done through REXX code. Please provide your suggestions.


Just go ahead and satisfy Your customers desires by writing the proper rexx code icon_cool.gif
what other suggestion would You like icon_question.gif

the requirement is to...
run a query
translate to a different codepage
email the result

how to do it is not generally considered a requirement !
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Mon Apr 05, 2010 1:56 pm
Reply with quote

I am not an email expert, but isn't there a provision to do codepage conversion there?
Back to top
View user's profile Send private message
haridossk81

New User


Joined: 22 Sep 2008
Posts: 5
Location: Chennai

PostPosted: Mon Apr 05, 2010 2:45 pm
Reply with quote

Hi,

Thanks for your suggestions.
Before I send my topic, I searched for that and tried in all possibilities. Finally I Posted here to get to know from experts.

Could anyone help me,
1. Is it possible to make Rexx code for code conversion like what EDCICONV Jcl utility does ?
2. If yes, Please provide me Rexx code.

Thanks in advance.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Mon Apr 05, 2010 3:01 pm
Reply with quote

1) yes, if You know how
2) NO, why should we!?

this is a help forum,not a do it for me one!
unless naturally Your company is willing to pay the proper fees icon_cool.gif
Back to top
View user's profile Send private message
haridossk81

New User


Joined: 22 Sep 2008
Posts: 5
Location: Chennai

PostPosted: Mon Apr 05, 2010 3:18 pm
Reply with quote

Hi,

Could anyone help me out to find solution for this request.

Kindly help me to have any related links / documents.
Back to top
View user's profile Send private message
Ranjithkumar

New User


Joined: 10 Sep 2008
Posts: 93
Location: India

PostPosted: Mon Apr 05, 2010 3:55 pm
Reply with quote

All the three steps you've mentioned (1. run QMF query, 2. Code conversion thro EDCICONV Jcl, and 3. send converted report to users thro email. ) can be accomplished through Rexx. But no one is going to code that for you , free of cost. If you start with some code and you are struggling with an issue we can help. Otherwise it is better you ask help with someone at your organization wh knows Rexx.
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1353
Location: Israel

PostPosted: Tue Apr 06, 2010 4:13 am
Reply with quote

haridossk81 wrote:
Could anyone help me,
1. Is it possible to make Rexx code for code conversion like what EDCICONV Jcl utility does ?
2. If yes, Please provide me Rexx code.


1) Yes, learn what the EDCICONV procedure does, then use rexx to allocate the files and run the utility.
2) No, YOU provide the code, then we give more good advices!
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CLIST & REXX

 


Similar Topics
Topic Forum Replies
No new posts 10 byte RBA conversion DB2 2
No new posts 10 byte RBA conversion -non applicati... JCL & VSAM 1
No new posts file manager is doing string conversion IBM Tools 3
No new posts Panvalet - 9 Character name - Issue c... CA Products 6
No new posts SMF Record Date conversion failing CLIST & REXX 1
Search our Forums:

Back to Top