 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 17 matches |
| Author | Message |
|---|---|
 Topic: Deleting more than one member in a PDS |
|
| viji Replies: 2 Views: 2129 |
 Forum: TSO and ISPF Posted: Fri Mar 11, 2005 1:27 am Subject: Deleting more than one member in a PDS |
| nevilh, Thank You, it is working! | |
| Topic: Deleting more than one member in a PDS |
|
| viji Replies: 2 Views: 2129 |
Forum: TSO and ISPF Posted: Thu Mar 10, 2005 7:07 am Subject: Deleting more than one member in a PDS |
| Hi,
I have a PDS containing 850 records. I need to delete the members having its name starting will 'P' . Nearly 250 members are there will its name starting with 'P'. Since 250 is a huge number i ... |
|
| Topic: change Expire date for tape |
|
| viji Replies: 9 Views: 7066 |
Forum: Job Control Language(JCL) Posted: Tue Feb 01, 2005 4:40 am Subject: change Expire date for tape |
| I doesnot know whether the expiry date can be modified. But the following will work to change the expirty date.
Probably you can copy this file to another tape file with required expiry date. and ... |
|
| Topic: Select Duplicate Records |
|
| viji Replies: 3 Views: 1599 |
Forum: Database Posted: Thu Jan 27, 2005 4:58 am Subject: Select Duplicate Records |
| WallaceC, Try the following SQL....
Select A.FIRST_NAME, A.LAST_NAME, A.CITY, A.STATE, B.CITY, B.STATE from (SELECT * FROM TBL_A D WHERE EXISTS (SELECT FIRST_NAME,LAST_NAME,MAX( ... |
|
| Topic: Details on Deleted DB2 tablespace |
|
| viji Replies: 1 Views: 1698 |
Forum: Database Posted: Tue May 11, 2004 10:14 am Subject: Details on Deleted DB2 tablespace |
| One of my DB2 tablespace was deleted in test region. How to get the information on which job/which user deleted this tablespace?
Will the DB2 stores this sort of information and where? Any help ... |
|
| Topic: DCBE |
|
| viji Replies: 1 Views: 3407 |
Forum: Job Control Language(JCL) Posted: Mon May 03, 2004 10:16 am Subject: DCBE |
| I have problem with the tape dataset....I would appreciate if anyone could help me.
The input TAPE dataset was created with few records(say 100 records) DISP=NEW. And then few more records(say 50 r ... |
|
| Topic: Info on ConnectDirect (Formerly Network Data Mover(NDM)) |
|
| viji Replies: 1 Views: 3093 |
Forum: Utilities Posted: Thu Oct 30, 2003 1:55 am Subject: Info on ConnectDirect (Formerly Network Data Mover(NDM)) |
| Could anyone give me link for the NDM manual....
Thanks, |
|
| Topic: DB2 Equivalent for S9(18) COMP? |
|
| viji Replies: 2 Views: 2427 |
Forum: Database Posted: Thu Oct 30, 2003 1:39 am Subject: DB2 Equivalent for S9(18) COMP? |
| Thanks Kolusu, your solution works good. | |
| Topic: DB2 Equivalent for S9(18) COMP? |
|
| viji Replies: 2 Views: 2427 |
Forum: Database Posted: Wed Oct 15, 2003 4:49 am Subject: DB2 Equivalent for S9(18) COMP? |
| What is the DB2 Equivalent data type for S9(18 ) COMP?
Thanks |
|
| Topic: How can I use CASE in... |
|
| viji Replies: 1 Views: 1583 |
Forum: Database Posted: Wed Jul 23, 2003 12:59 am Subject: How can I use CASE in... |
| Hello,
Consider I have a EMPLOYEE table with employeeID,InsuranceID,Employee Name,ClaimNo.... I have nearly 3 Insurance company....Each Insurance company different tables to store all its detail ... |
|
| Topic: Truncation occurs in the calucated column |
|
| viji Replies: 3 Views: 2635 |
Forum: Database Posted: Wed Jul 23, 2003 12:11 am Subject: Truncation occurs in the calucated column |
| Thanks Kolusu, Your solution solved my problem!!!!!!
Thanks once again....  |
|
| Topic: Truncation occurs in the calucated column |
|
| viji Replies: 3 Views: 2635 |
Forum: Database Posted: Tue Jul 22, 2003 7:14 am Subject: Truncation occurs in the calucated column |
| Hi,
I have two columns A & B defined as Integer in a DB2 table. Now i need to calculate (A/B)*100......When I do this the decimal part gets truncated!!! this could be because the original column( ... |
|
| Topic: Data Transfer from TANDEM to Mainframe by NDM process |
|
| viji Replies: 4 Views: 11850 |
Forum: Other Technical Topics Posted: Fri Mar 21, 2003 5:36 am Subject: Data Transfer from TANDEM to Mainframe by NDM process |
| Hi,
I need to transfer the data from tandem machine to Mainframe by NDM(network data mover) process. Could anyone provide me the link for the manual of NDM? thanks |
|
| Topic: converting lowercase to uppercase using synctool |
|
| viji Replies: 1 Views: 4330 |
Forum: Utilities Posted: Mon Jan 27, 2003 2:26 pm Subject: converting lowercase to uppercase using synctool |
| Hi,
How to convert my data in lowercase to uppercase using synctool. In Dfsort we have the option TRAN=LTOU. what about in synctool???? |
|
| Topic: IKJEFT1A & IKJEFT01 |
|
| viji Replies: 3 Views: 17844 |
Forum: Database Posted: Fri Jan 10, 2003 2:14 pm Subject: IKJEFT1A & IKJEFT01 |
| Thanks kolusu for the info
could you provide me the link where i could more info on this. |
|
All times are GMT - 5 Hours |