 |
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 8 matches |
| Author | Message |
|---|---|
 Topic: Question on cursor - avoiding 'order by' |
|
| vinothenator_1782 Replies: 4 Views: 1983 |
 Forum: Database Posted: Mon Aug 03, 2009 2:16 am Subject: Question on cursor - avoiding 'order by' |
| Hi Kolusu, went through some posts and i believe my assumption on DB2 part is wrong. Data can be stored differently from its index order in DB2. Using 'Order by' will degrade the performance since im ... | |
| Topic: Question on cursor - avoiding 'order by' |
|
| vinothenator_1782 Replies: 4 Views: 1983 |
Forum: Database Posted: Mon Aug 03, 2009 1:49 am Subject: Question on cursor - avoiding 'order by' |
| Yes Kolusu, its a CICS transaction and it is MQ triggered. So whenever a message is dropped in the queue my transaction will get triggered. Is my assumption on DB2 handling correct ? Please advise. | |
| Topic: Question on cursor - avoiding 'order by' |
|
| vinothenator_1782 Replies: 4 Views: 1983 |
Forum: Database Posted: Sat Aug 01, 2009 6:53 am Subject: Question on cursor - avoiding 'order by' |
| Hi all,
I have a cursor for a select statement which retrieves records based on a condition. But my program needs to handle only 50 rows at a time to avoid transaction timeout. In this case, ... |
|
| Topic: Matching two input files as generic and loading output files |
|
| vinothenator_1782 Replies: 10 Views: 4034 |
Forum: Utilities Posted: Tue Mar 24, 2009 10:51 am Subject: Matching two input files as generic and loading output files |
| Can we pass multiple keys for INFILE1 & INFIEL2 and we can do sortout. Please advise with coding | |
| Topic: Matching two input files as generic and loading output files |
|
| vinothenator_1782 Replies: 10 Views: 4034 |
Forum: Utilities Posted: Fri Mar 20, 2009 11:59 pm Subject: Matching two input files as generic and loading output files |
| hi,
I know i can do it SYNC SORT. Please below data and let me know. INFILE1 KEY ( 2,9) , LRECL=600, RECFM=FB INFILE2 KEY (1,9) , LRECL=120, RECFM= FB OUTFILE = (F1:1,2,9,15,F2:2,9......) - ... |
|
| Topic: Reference Modification in Easytrieve |
|
| vinothenator_1782 Replies: 1 Views: 2194 |
Forum: Application Programming Posted: Fri Mar 20, 2009 3:03 am Subject: can we refernce modification in easytrieve program? |
| like as example.
Move A(12:5) TO B. if not please advise is there any other option for eastrieve program. |
|
| Topic: Matching two input files as generic and loading output files |
|
| vinothenator_1782 Replies: 10 Views: 4034 |
Forum: Utilities Posted: Thu Mar 19, 2009 11:03 pm Subject: Matching two input files as generic and loading output files |
| Hi, I didn't get any response. Please advise whether my question is understandble or or not? | |
| Topic: Matching two input files as generic and loading output files |
|
| vinothenator_1782 Replies: 10 Views: 4034 |
Forum: Utilities Posted: Thu Mar 19, 2009 12:42 pm Subject: Matching two input files as generic and loading output files |
| Hi,
I have two input files INFILE1 INKEY1 2 9 A INFILE2 INKEY2 1 9 A Job infile1(inkey1) infile2(inkey2) OUTFILE FORMAT IS INFILE1(1,12) INFILE2(2,10) INFILE1(22 13) INFILE2( ... |
|
All times are GMT - 5 Hours |