 |
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 10 matches |
| Author | Message |
|---|---|
 Topic: Outer joins |
|
| veluvpv Replies: 7 Views: 3203 |
 Forum: Database Posted: Wed Feb 02, 2011 4:23 am Subject: Outer joins |
| Kolusu,
Apologize for the mistake. Will search before posting hence forth. Thanks for the reply. Regards, VPV |
|
| Topic: Outer joins |
|
| veluvpv Replies: 7 Views: 3203 |
Forum: Database Posted: Tue Feb 01, 2011 7:57 am Subject: Outer joins |
| Kolusu,
As said in the previous post, the query worked fine.. Now the question is about performance   . I have huge data in the db  . So is it possible to fine tune the SQL? 
A ... |
|
| Topic: Outer joins |
|
| veluvpv Replies: 7 Views: 3203 |
Forum: Database Posted: Thu Jan 27, 2011 6:48 am Subject: Outer joins |
| Kolusu..!!!
you are REALLY GREAT..!!! 8)  
it worked out and i got the expected result. thanks a bunch..!! Regards, VPV |
|
| Topic: Outer joins |
|
| veluvpv Replies: 7 Views: 3203 |
Forum: Database Posted: Tue Jan 25, 2011 1:42 pm Subject: Outer joins |
| Kolusu,
Apologize for the missed info. please find the details below, tableb has keyfield1 (which is common to tablea),number (FK - Tablec. this is the field common to table b and tablec), age,s ... |
|
| Topic: Outer joins |
|
| veluvpv Replies: 7 Views: 3203 |
Forum: Database Posted: Tue Jan 25, 2011 6:14 am Subject: Outer joins |
| Hi All,
I surfed a lot on my below requirement, but couldn't get the exact solutions anywhere. Please guide me thru this, My Req: I have 3 tables, say tablea,tableb and tablec. Table a and ta ... |
|
| Topic: FTP PKZIP to Desktop |
|
| veluvpv Replies: 4 Views: 4309 |
Forum: Job Control Language(JCL) Posted: Fri Sep 18, 2009 3:32 am Subject: FTP PKZIP to Desktop |
| Kolusu,
The recfm and the record length of the header file is also the same (FB & 360) Do you have SMTP up and running? Yes,SMTP is up (since we use the same JCL syntax in which we ... |
|
| Topic: How to get only 'n' no. of records in o/p file using sort? |
|
| veluvpv Replies: 12 Views: 8248 |
Forum: Utilities Posted: Mon Jan 19, 2009 12:57 pm Subject: How to get only 'n' no. of records in o/p file using sort? |
| Frank,
The question is using SORT, but already given solution is not using SORT utility, if their shop doesnot configured to use the ICETOOL or ICEMAN how does that help them?? |
|
| Topic: How to get only 'n' no. of records in o/p file using sort? |
|
| veluvpv Replies: 12 Views: 8248 |
Forum: Utilities Posted: Mon Jan 19, 2009 8:05 am Subject: How to get only 'n' no. of records in o/p file using sort? |
| Hi,
Please remove the null card // in first step. |
|
| Topic: How to get only 'n' no. of records in o/p file using sort? |
|
| veluvpv Replies: 12 Views: 8248 |
Forum: Utilities Posted: Mon Jan 19, 2009 7:57 am Subject: How to get only 'n' no. of records in o/p file using sort? |
| Hi,
Using SORT we can achieve the result, first step sort it and in second step copy it using STOPAFT... //JS010 EXEC PGM=SORT . . //SYSOUT DD SYSOUT=* //SYSIN DD * ... |
|
| Topic: Count records while in view/browse mode in 3.4 |
|
| veluvpv Replies: 10 Views: 4859 |
Forum: TSO and ISPF Posted: Thu Jul 17, 2008 4:16 am Subject: Count records while in view/browse mode in 3.4 |
| Using File-Aid Tool in Option 3 -Utiltilities in that option 8-Interactive mention the input dataset and then enter and give the command Tally. It will display number records read in the input file.
... |
|
All times are GMT - 5 Hours |