Search results for query: *

Hi, How do I get the list of all child tables and it's corresponding count of number of rows that got deleted when I use ON DELETE CASCADE option to delete the rows. An audit of the counts against every table whose rows got deleted. Table Master 100 Table child1 50 Table child2 5 Table child3 30

Rexxhead, I tried most of ALLOC FI(SYSEXEC) DA('DATASET') SHR REUSE but still it does not get allocated. i also tried ALTLIB, TSOLIB, EXEC etc. but no use. this is the best option i wud say, as i can make it work simple.

rexxhead, I have solved all issues and see it is working good. I allocate the rexx dataset using below command : TSO ALLOC FI(SYSEXEC) DA('PDSNAME') SHR REUSE And then I am able to invoke my TSO SRC PGMNAME etc., Every time I logon to TSO session, I had to run the ALLOC FI(SYSEXEC) command...

Thanks Rexxhead! I made changes accordingly. I am left out with one more requirement. If the member is not found, I must say "Member not found" and exit. I did add this patch below after LMOPEN ADDRESS ISPEXEC "LMMFIND DATAID("DATID") MEMBER("MEMBR")...

rexxhead, Many thanks for your assistance. I achieved it by this code below. I am able to open the member in VIEW mode. But after the command is executed and if I press PF3, I see RC =4. I am not sure if I miss something obvious in syntax or need to check some thing. I see some examples having...

I found a thread in this forum thread277-1443229 having code to display the members of PDS with other details. I tried to customise that with LMMFIND & LMMDISP. It displays the member name,but not the content of the member. ISPEXEC LMMDISP DATAID(data-id) OPTION(DISPLAY) MEMBER(member) Kinldy...

All, Thanks for your concerns. I shall ensure I would not break one. I shall apply to my development PDS before I go for next level. rexxhead : Yes, all are separate PDS. Pls can you suggest me a probable solution? I am new to REXX but not to mainframes! So I am sure I can cope-up Kindly...

Hi, I am new to REXX. I have the below requirement: In ISPF, we enter 3.4, ENTER and give the PDS name and enter, TYPE M or S to display the list of members and then select E or B or V to do action on the member(s) This must be automated. On the command line (ISPF first screen after...