MVSFORUMS.com

Thank you very much all of you for the detailed useful reply.

As the update query getting really complecated, we added some selection criteria to reduce the 4th table's results to less than 50 reco ...

Hi,

I am getting 1000 records from 4 tables and I need to update perticular column in the 4th table.

For example, I am getting results from Table A, B, C & D using Joins and based on conditi ...

You can use following option in Changeman - Primary Option Menu:

C M+R - Merge+Reconcile (formerly CDF)

This will solve your requirements.

Thanks to all for your suggestions.

I have discussed with my DBA and he mentioned that we need have the 'Not Null with Default' for the new column even though it is a primary key.

Thanks.

Hi dbzTHEdinosauer,

Thanks for your response.

I cannot create the table on my own in my shop. That's why I posted that question. I can only request for the creation of table to DB2 Team. Befor ...

Hi,

In following way my existing table was created:

CREATE TABLE Product
(Product_id CHAR(4) FOR SBCS DATA NOT NULL,
Product_Name CHAR(3) FOR SBCS ...

Thanks Kolusu.

As you said, I have tried it and it works.

Hello All,

I need to write a program which needs to read a record from the GSAM File. I will be receiving the flat file and that needs to be converted to GSAM file.

While reading the links & ...

Hello Danm,

PL1 works with exception conditions. In case of any problem with file attributes and data set characteristics, the UNDEFINEDFILE condition will be raised. So, I believe in your case, y ...

The error message says that " NO ACTIVE MODULE FOUND " .

It may be because of Mainprogram looking for subprogram, may be your Sub Program is not available.. check all your link step.. als ...

Yes. You need to have FETCh and then followed by CALL for the Fetched module.

Usaully we cod as follows:

DCL module_name EXTERNAL ENTRY(PTR) OPTIONS(FETCHABLE);

CALL module_na ...

Hi Frank,

Thanks for your response.

I will wait for the response, if any expertise faced this kind of situation and experience on solving this. Rolling Eyes

Thanks.

Hi Frank,

You are exactly right. it works if I introduce 'EQUALS' in the PLISTRA parameter.

Other than this, is there any direct matching(Like, if SRTGET,SRTFILL used in CA SORT, we need to use ...

Hi,

Before writing this query, I checked all the post regarding PLISRTA in this forum. But I coudn't get exact answer.

My questions is, is there any difference between CA SORT and PLISRTA?

In ...

Hi Madan1582,

AFAIK, IBM PL/I for MVS & VM 1.1 will not support TRIM Function. You need to write a Trim functionality as subroutine.

Only Enterprise PL/1 supports TRIM function.