MVSFORUMS.com

Great - Thanks Kolusu / IEFBR14

Other relationships in my shop also reported no issues with the 9-11 upgrade. So, I assume everthing should be ok after the upgrade.

thanks a lot
Phantom

Dear All,

Its been quite a long time since I posted in this site...H r u all ?

In my shop, we are looking to upgrade IMS from v9 to v11 and as an initial step we are performing a compatibility s ...

After several years of running a shop with unsupported versions of software, Our shop management has finally decided to upgrade everything.

This includes CICS, DB2 v 7 to v9, Powerbuilder v 7 to v ...

Thanks for your feedback on this Alissa.

Regards
Phantom

This might be a regular question, but I can't think of a way to handle all scenarios in 1 step. Looking out for expert's help...

Input File: RECFM=VB,LRECL=4355

Command ===> ...

Hi,

Its been quite a while since I posted a message in MVSFORUMS. I got a bit out of date on several topics.

I am using SYNCSORT for z/OS 1.2.3.1R. Can someone let me know if syncsort has any ...

I apologize for not being clear on my requirement.

It seems DB2 V8 can hold these symbols in the database, but when these are moved to Host / output variables for display, it appears that DB2 tra ...

Thanks a lot Dick,

I went through the documents that you sent me. I learned lot of things about the version incompatibilities etc...but it does not specifically talk about the table scan that I w ...

Satyender,

You could use IEBGENER, SORT, FILEAID or any such utilities to copy any dataset from any storage device to another (where you have access).

//STEP01 EXEC PGM=SORT
//SORTIN ...

I have been asked to do both and I have an answer for the second (DB2 Query Search). My only concern now is to find out the list of DB2 tables whose Data has one of the obsolete symbols.

All I cou ...

Hi,

I have least experience working with DB2 and require your support on the following (I did try to search for existing threads on this topics but could not find something that answers my question ...

Hey Kolusu !!! This is great news 8) Wish you all the very best for your new endeavour.

Regards,
Phantom

Vak255,

The following link details the JOIN feature in Syncsort

http://www.mvsforums.com/helpboards/viewtopic.php?p=22582#22582

Hope this helps,

Thanks,
Phantom

Vak255,

The version of Syncsort (PGM=SORT) and Synctool will be different. The correct version of sort can be found only in PGM=SORT. Please check the sysout and get back to us on the version.
...

Vak255,

Try this sample JCL - (you need to customize to your requirements - field positions and LRECL). This will work with older versions of syncsort that supports SPLICE (v 1.1 and above).

In ...