Mainframe, MVS and zOS Discussion

I double Enrico said there are plenty of options along with Trace...

You might also need to follow your company standard procedure for all the validations that needs to be done.. Talk to your team or check the existing programs and that should answer your question

Is it one job or is it based on Partition?

You could check on this link for REVOKE but most shops only DBA has authority over this command

http://publibz.boulder.ibm.com/cgi-bin/ ... 0325102208

http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.ugref/src/tpc/db2z_incrementalimagecopies.html A very good link to start... If you need to know incremental image copy http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.ugref/src/tpc/db2z_utl_...

what do you mean by hanged?
Are you executing any foreground programs that is in loop?

Also if you just wanted to reconnect

Try

Try

Thanks for sharing the link , It would help people future

Suntles,

You could do a count(*) and find the number of records and then process the cursor.

As Nicc mentioned you could use insert statement

But if there are more records it is better to have frequent commits or as an alternative you could unload and load data

Corrected the typo it is equi join

narinderc wrote:There is not much support here. Most of the seniors guys have left the organization.

In that case there should be someone from the client team or Technical support or system admin who would have definitely done this.. check with them

Innerjoin ,selfjoin and equi join are all same

Also you could try UNLOAD and LOAD

You could copy your rexx scripts to SYSEXEC or SYSPROC library

For past few years I have stopped using debugging tools, As Robert said adding Display after each Paragraph or section helps in narrowing down to the problem.... Also it helps in understanding the program flow much easier by executing it with the test input rather than starring at the piece of code ...

If you could elaborate you could get better reply

I would normally do a Count(*)

Hi Priya

Just to check did it solve your problem

Anuj If I remember correctly TRAIL is shortform for TRAILINGBLANKS in Mainframe and TS had done that I guess

TRAILingblanks Specifies that the FTP server preserves the trailing blanks in a fixed format data set when the data is sent to a foreign host.