Re: ./ ADD - which utility? (RANT)

[Brian Westerman]

Bluezone FTP lets you copy the entire PDS to a directory on your PC and change 
from EBCDIC to ASCII.  I have been using it for years.

Brian

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: ./ ADD - which utility? (RANT)

[Seymour J Metz]

The same is true for, e.g., InfoConnect Reflection.

--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3
עַם יִשְׂרָאֵל חַי
נֵ֣צַח יִשְׂרָאֵ֔ל לֹ֥א יְשַׁקֵּ֖ר


From: IBM Mainframe Discussion List  on behalf of 
Charles Mills 
Sent: Saturday, May 18, 2024 8:18 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: ./ ADD - which utility? (RANT)

I'm late to the party here so I'm not sure if what I quote below is the 
original query but unless I am missing something, most or all of the Windows 
graphical FTP clients will do that. FileZilla is free. WS_FTP may be free for 
individual use. There may be others. They will graphically expand a z/OS PDS(E) 
(a la Windows File Explorer or ISPF, more or less) and you can drag one, 
several or all members from the PDS(E) to a Windows folder, or vice versa, with 
or without ASCII translation. WS_FTP will also (but FileZilla will not) do 
extension generation or conversion. So you can copy all of the members of a 
PDS(E) and have them end up on Windows as *.asm, or copy from Windows to a 
PDS(E) and not have it complain that WHATEVER.ASM is not a valid member name. I 
also copy between Windows and OMVS folders, and have WS_FTP convert *.cpp to 
*.C and vice versa (following the different naming conventions for C++ source 
on the two platforms).

Or am I missing something (not the first time )?

Charles

>W dniu 14.04.2024 o 03:01, Michael Oujesky pisze:
>> I really miss WSA and it's ability to take a text PDS and transfer all
>> the members to Windows creating individual members in the target
>> directory and doing the EBCDIC to ASCII translation for each member in
>> the PDS.

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN


--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: ./ ADD - which utility? (RANT)

[Charles Mills]

I'm late to the party here so I'm not sure if what I quote below is the 
original query but unless I am missing something, most or all of the Windows 
graphical FTP clients will do that. FileZilla is free. WS_FTP may be free for 
individual use. There may be others. They will graphically expand a z/OS PDS(E) 
(a la Windows File Explorer or ISPF, more or less) and you can drag one, 
several or all members from the PDS(E) to a Windows folder, or vice versa, with 
or without ASCII translation. WS_FTP will also (but FileZilla will not) do 
extension generation or conversion. So you can copy all of the members of a 
PDS(E) and have them end up on Windows as *.asm, or copy from Windows to a 
PDS(E) and not have it complain that WHATEVER.ASM is not a valid member name. I 
also copy between Windows and OMVS folders, and have WS_FTP convert *.cpp to 
*.C and vice versa (following the different naming conventions for C++ source 
on the two platforms).

Or am I missing something (not the first time )?

Charles

>W dniu 14.04.2024 o 03:01, Michael Oujesky pisze:
>> I really miss WSA and it's ability to take a text PDS and transfer all
>> the members to Windows creating individual members in the target
>> directory and doing the EBCDIC to ASCII translation for each member in
>> the PDS.

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: ./ ADD - which utility? (RANT)

[Robert Prins]

https://github.com/dmolony/Xmit by Dennis Molony, written in Java, so
Windoze, Linux and Mac are supported, as are user-defined code-pages.

Robert

On Sat, 18 May 2024 at 21:37, Mike Schwab <
05962a42dc49-dmarc-requ...@listserv.ua.edu> wrote:

> Here's what is available.  Please submit any additions you may know.
>
> https://www.cbttape.org/xmitview.htm
>
> On Sat, May 18, 2024 at 4:32 PM Paul Gilmartin
> <042bfe9c879d-dmarc-requ...@listserv.ua.edu> wrote:
> >
> > On Sat, 18 May 2024 23:15:26 +0200, Radoslaw Skorupka  wrote:
> > >...
> > >Yes, we have some freeware XMIT viewers, we have some homegrown REXX
> > >scripts, etc.
> > >
> > for which desktop target platforms?
> >
> > >But it is continuous reinventing the wheel.
> > >IMHO it is up to IBM to assign few folks for few weeks to prepare such
> > >tools. It need not to be officially supported.
> > >IBM invest a lot of effort in z/OSMF and other "modernization", but such
> > >simple things like PDS to directory are still left.
> > >
> > for which desktop target platforms?
> >
> > But if it's  Java, it might be nonpartisan.
> >
> > --
> > gil
> >
> > --
> > For IBM-MAIN subscribe / signoff / archive access instructions,
> > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>
>
>
> --
> Mike A Schwab, Springfield IL USA
> Where do Forest Rangers go to get away from it all?
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>


-- 
Robert AH Prins
robert(a)prino(d)org
The hitchhiking grandfather 
Some REXX code for use on z/OS


--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: ./ ADD - which utility? (RANT)

[Mike Schwab]

Here's what is available.  Please submit any additions you may know.

https://www.cbttape.org/xmitview.htm

On Sat, May 18, 2024 at 4:32 PM Paul Gilmartin
<042bfe9c879d-dmarc-requ...@listserv.ua.edu> wrote:
>
> On Sat, 18 May 2024 23:15:26 +0200, Radoslaw Skorupka  wrote:
> >...
> >Yes, we have some freeware XMIT viewers, we have some homegrown REXX
> >scripts, etc.
> >
> for which desktop target platforms?
>
> >But it is continuous reinventing the wheel.
> >IMHO it is up to IBM to assign few folks for few weeks to prepare such
> >tools. It need not to be officially supported.
> >IBM invest a lot of effort in z/OSMF and other "modernization", but such
> >simple things like PDS to directory are still left.
> >
> for which desktop target platforms?
>
> But if it's  Java, it might be nonpartisan.
>
> --
> gil
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN



-- 
Mike A Schwab, Springfield IL USA
Where do Forest Rangers go to get away from it all?

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: ./ ADD - which utility? (RANT)

[Paul Gilmartin]

On Sat, 18 May 2024 23:15:26 +0200, Radoslaw Skorupka  wrote:
>...
>Yes, we have some freeware XMIT viewers, we have some homegrown REXX
>scripts, etc.
>
for which desktop target platforms?

>But it is continuous reinventing the wheel.
>IMHO it is up to IBM to assign few folks for few weeks to prepare such
>tools. It need not to be officially supported.
>IBM invest a lot of effort in z/OSMF and other "modernization", but such
>simple things like PDS to directory are still left.
>
for which desktop target platforms?

But if it's  Java, it might be nonpartisan.

-- 
gil

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: ./ ADD - which utility? (RANT)

[Radoslaw Skorupka]

W dniu 14.04.2024 o 03:01, Michael Oujesky pisze:
I really miss WSA and it's ability to take a text PDS and transfer all 
the members to Windows creating individual members in the target 
directory and doing the EBCDIC to ASCII translation for each member in 
the PDS.


I'm really upset and I really miss the set of simple tools for such 
simple things like PDS<->PC directory. With XMIT support.
Yes, we have some freeware XMIT viewers, we have some homegrown REXX 
scripts, etc.

But it is continuous reinventing the wheel.
IMHO it is up to IBM to assign few folks for few weeks to prepare such 
tools. It need not to be officially supported.
IBM invest a lot of effort in z/OSMF and other "modernization", but such 
simple things like PDS to directory are still left.


--

Radoslaw Skorupka
Lodz, Poland

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Refresh RMFGAT collection settings

[Michael Oujesky]

Correct syntax:
F RMF,F III,MEMBER(04)
Michael

At 09:15 PM 5/15/2024, Michael Oujesky wrote:


Off the top of my head:

F RMF,F III,M=04

At 08:27 PM 5/15/2024, Mark Jacobs wrote:
Content-Transfer-Encoding: base64If I make changes to ERBRMF04 is 
there any way to refresh what's being collected without restarting RMFGAT?


Mark Jacobs

Sent from [ProtonMail](https://protonmail.com), Swiss-based encrypted email.

GPG Public Key - 
https://api.protonmail.ch/pks/lookup?op=get=markjac...@protonmail.com


--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN


--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: ./ ADD - which utility?

[Don Leahy]

I agree with you.None of the alternatives that I have tried are as fit
for purpose as WSA.

On Fri, May 17, 2024 at 16:13 Michael Oujesky 
wrote:

> I really miss WSA and it's ability to take a text
> PDS and transfer all the members to Windows
> creating individual members in the target
> directory and doing the EBCDIC to ASCII translation for each member in the
> PDS.
>
> Michael
>
> At 05:34 PM 4/13/2024, Wayne Bickerdike wrote:
> >I have some REXX code that extracts all members of a PDS and writes it to
> a
> >sequential file. Each member extracted is prefixed with the ./ADD card
> with
> >the original member name. Handy for moving a PDS to another system.
> >IEBUPDTE was the utility of choice when all we had was a card punch and
> >card reader. (1975).
> >
> >On Sun, Apr 14, 2024 at 8:08 AM Mike Schwab <
> >05962a42dc49-dmarc-requ...@listserv.ua.edu> wrote:
> >
> > > No relation to the ditty bops band.
> > > https://www.youtube.com/watch?v=iu7289s7l64
> > >
> > > On Sat, Apr 13, 2024 at 4:56 PM Rupert Reynolds  >
> > > wrote:
> > > >
> > > > Affectionately known in UK as I-E-B-up-ditty :-)
> > > >
> > > > On Sat, 13 Apr 2024, 15:39 ITschak Mugzach, <
> > > > 05a7ced721d8-dmarc-requ...@listserv.ua.edu> wrote:
> > > >
> > > > > IEBUPDTE. JCL can be found in google
> > > > >
> > > > > ITschak Mugzach
> > > > > *|** IronSphere Platform* *|* *Information Security Continuous
> > > Monitoring
> > > > > for z/OS, x/Linux & IBM I **| z/VM coming soon  *
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > On Sat, Apr 13, 2024 at 5:30 PM   <
> > > > > 0619bfe39560-dmarc-requ...@listserv.ua.edu> wrote:
> > > > >
> > > > > > Which utility do you use for control statement/input:
> > > > > > ./ ADD
> > > > > >
> > > > > > A jcl for that would be nice too.
> > > > > >
> > > > > > ...Embarassed by my lack of memory after 8 years out of this
> > > > > > envirinment...
> > > > > >
> > > > > >
> > > --
> > > > > > For IBM-MAIN subscribe / signoff / archive access instructions,
> > > > > > send email to lists...@listserv.ua.edu with the message: INFO
> > > IBM-MAIN
> > > > > >
> > > > >
> > > > >
> --
> > > > > For IBM-MAIN subscribe / signoff / archive access instructions,
> > > > > send email to lists...@listserv.ua.edu with the message: INFO
> IBM-MAIN
> > > > >
> > > >
> > > >
> --
> > > > For IBM-MAIN subscribe / signoff / archive access instructions,
> > > > send email to lists...@listserv.ua.edu with the message: INFO
> IBM-MAIN
> > >
> > >
> > >
> > > --
> > > Mike A Schwab, Springfield IL USA
> > > Where do Forest Rangers go to get away from it all?
> > >
> > > --
> > > For IBM-MAIN subscribe / signoff / archive access instructions,
> > > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
> > >
> >
> >
> >--
> >Wayne V. Bickerdike
> >
> >--
> >For IBM-MAIN subscribe / signoff / archive access instructions,
> >send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Assistance with Converting IMS DB to MySQL DB

[Rupert Reynolds]

One point which might seem obvious, and if it's been discussed I apologise
for repeating, but IMS DB supports a hierarchical structure, so in a
typical DB a root segment may have zero, one or many child segments.

Exhoing others, you really will need an IMS expert.

Roops

On Fri, 17 May 2024, 03:42 Jason Cai,  wrote:

> Dear all,
>
>   We are currently undertaking a project to convert some 15-year-old IMS
> database, for which we have some full image copy on tape, to a MySQL
> database on a Linux platform.
>
> To ensure the success of this migration, we would greatly appreciate your
> expertise and guidance on the following matters:
>
> Is it feasible to recover the IMS full image copy without an IMS DB
> system, or is the presence of an IMS DB system an absolute necessity for
> this migration process?
>
> Once we have successfully restored the IMS database files to disk, we are
> considering two potential approaches:
> a) Utilizing the IMS unload utility to convert the database files into a
> PS format, followed by developing a program to read the PS file and import
> the data into MySQL.
>
> b) Directly reading the IMS database files and writing the data into DB2,
> and then subsequently converting the data from DB2 to MySQL.
>
> Are there any specific constraints or limitations that we should be aware
> of, such as the mandatory requirement of an IMS DB system for this
> migration?
>
> Are there any relevant tools or utilities available that could assist us
> in this process and help streamline the migration?
>
>   We would be immensely grateful if you could provide your insights on
> which of the two approaches mentioned above would be more feasible, given
> our current situation. Additionally, if there are any alternative methods
> or strategies that you believe might be suitable for our specific case, we
> would greatly appreciate your suggestions.
>
> Your expertise and knowledge in this area are highly valued, and any
> advice or recommendations you can offer to help us navigate this complex
> migration process effectively would be sincerely appreciated.
>
> Thank you in advance for your time and consideration. We eagerly await
> your response and look forward to benefiting from your guidance.
>
> Best regards,
>
> Jason Cai
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Assistance with Converting IMS DB to MySQL DB

[Massimo Biancucci]

Jason,

in addition to all the previous comment, keep attention to the fact that
it's not so unusual that programmers redefine fields into a DLI segment (or
the entire segment itself) so fields can or can not be what they appear.

You should have ALL the old programs accessing DLI data and double check.

Good luck.
Max


Privo
di virus.www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Il giorno ven 17 mag 2024 alle ore 20:46 ITschak Mugzach <
05a7ced721d8-dmarc-requ...@listserv.ua.edu> ha scritto:

> If you have IMS installed, you can use rexx to read the database and create
> sql statements.
>
> ITschak
>
> *| **Itschak Mugzach | Director | SecuriTeam Software **|** IronSphere
> Platform* *|* *Information Security Continuous Monitoring for Z/OS, zLinux
> and IBM I **|  *
>
> *|* *Email**: i_mugz...@securiteam.co.il **|* *Mob**: +972 522 986404 **|*
> *Skype**: ItschakMugzach **|* *Web**: www.Securiteam.co.il  **|*
>
>
>
>
>
> בתאריך יום ו׳, 17 במאי 2024 ב-19:53 מאת Andrew Wilkinson <
> 04f504c2b946-dmarc-requ...@listserv.ua.edu>:
>
> > Jason,Please excuse the terrible formatting from my phone.Does the DBD
> > describe every byte of every segment?If so, you won't need the
> > copybooks.Also you will need to reformat the IMS unload file before
> > reloading into DB2, at the very least because of keys cascading from
> parent
> > segment(s).You do need an IMS expert to do this cleanly.Cheers,Andrew
> >  Original message From: Jason Cai 
> > Date: 17/05/2024  09:21  (GMT+00:00) To: IBM-MAIN@LISTSERV.UA.EDU,
> Andrew
> > Wilkinson  Cc: Jason Cai <
> > ibmm...@foxmail.com> Subject: Re: Assistance with Converting IMS DB to
> > MySQL DB Dear Andrew,Thank you for your suggestion. I have some thoughts
> on
> > the IMS segment layout and defining SQL columns, and I’d like to confirm
> > with you:If I have the DBD (Database Description), is it sufficient to
> > correctly define the SQL columns? Or do I need the application copybook
> in
> > addition to the DBD?If the SQL columns are defined correctly, is it
> > possible to do the following:a. Unload Data from IMS using PGM=DFSURGU0b.
> > Define DB2 Tablesc. Load Data into DB2 using PGM=DSNUTILBThe above are
> some
> > of my ideas, and I’m not sure if they are correct. I hope to get your
> > guidance. Thank you very much for your help!Best regards,Jason Cai
> >
> > --
> > For IBM-MAIN subscribe / signoff / archive access instructions,
> > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
> >
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN