 |
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 32 matches |
| Author | Message |
|---|---|
 Topic: Sort card to eliminate dupes and keep specific record |
|
| nishantrk Replies: 2 Views: 1513 |
 Forum: Utilities Posted: Fri Nov 12, 2010 8:52 pm Subject: Sort card to eliminate dupes and keep specific record |
| Sorry missed a thing the output should have a additional indicator telling that the record had dupes
111111S20101008 I 222222S20101008 333333S20101010 I 444444U20101010 I 555555U20101010 66 ... |
|
| Topic: Sort card to eliminate dupes and keep specific record |
|
| nishantrk Replies: 2 Views: 1513 |
Forum: Utilities Posted: Fri Nov 12, 2010 8:43 pm Subject: Sort card to eliminate dupes and keep specific record |
| This should be a general problem , but i couldn't figure it out nor find the right solution , though have searched various forums
Record length 80 , VB 111111A20101008 111111S20101008 222222S ... |
|
| Topic: Extraction of records with variable data |
|
| nishantrk Replies: 2 Views: 1491 |
Forum: Utilities Posted: Tue Oct 12, 2010 8:47 pm Subject: Extraction of records with variable data |
| Thakn you sir!!!!!!!!!!! | |
| Topic: Extraction of records with variable data |
|
| nishantrk Replies: 2 Views: 1491 |
Forum: Utilities Posted: Tue Oct 12, 2010 1:26 pm Subject: Extraction of records with variable data |
| Have a FB file which contains differnet record types length 80.The struture of the file is Header record which indetifies the begining of group and then follwoed the detial record.
BEGIN 222222 ... |
|
| Topic: DB2 version 8 Multi row insert |
|
| nishantrk Replies: 7 Views: 4910 |
Forum: Database Posted: Mon May 17, 2010 7:55 pm Subject: DB2 version 8 Multi row insert |
| Sorry the earlier got posted half way through...
This code is working fine for me..the only problem am getting is ...the number of conditions returned in the ERRCNT is coming as 2 ,whereas i have on ... |
|
| Topic: DB2 version 8 Multi row insert |
|
| nishantrk Replies: 7 Views: 4910 |
Forum: Database Posted: Mon May 17, 2010 7:37 pm Subject: DB2 version 8 Multi row insert |
| Thanks Dibankar...
yeah i had changed my code ..but still its doesn't seem to work perfectly... I changed it to.. IF SQLCODE = +0 add to inserted-counter else IF SQLCODE = -2 ... |
|
| Topic: DB2 version 8 Multi row insert |
|
| nishantrk Replies: 7 Views: 4910 |
Forum: Database Posted: Fri May 14, 2010 6:49 am Subject: DB2 version 8 Multi row insert |
| i don't want the program to error for duplicate records... I probably misunderstand, but yes you do want the program to error if the duplicate is detected. . .
yeah..I don't want the program to abe ... |
|
| Topic: DB2 version 8 Multi row insert |
|
| nishantrk Replies: 7 Views: 4910 |
Forum: Database Posted: Thu May 13, 2010 9:06 pm Subject: DB2 version 8 Multi row insert |
| Have read that multi row insert is around 15% more effiect than normal inserts ,am trying to implement it ,in one of our programs but am not sure how to use the get diagonostic for error handling...
... |
|
| Topic: performance of DB2 query vs Cobol table search |
|
| nishantrk Replies: 8 Views: 6118 |
Forum: Database Posted: Thu Apr 22, 2010 6:42 pm Subject: performance of DB2 query vs Cobol table search |
| Thanks all for your views and suggestion...
Actually i had only mentioned part of code...the actual code does a lot more processing and has been optimized to do that..my requirement is just a small e ... |
|
| Topic: performance of DB2 query vs Cobol table search |
|
| nishantrk Replies: 8 Views: 6118 |
Forum: Database Posted: Wed Apr 21, 2010 7:28 pm Subject: performance of DB2 query vs Cobol table search |
| I have to read a files which has around 10 million records.Then query a DB2 tableemployee category table to get his dept ,based on the indicator is get from the DB2 table do a write for the records. ... | |
| Topic: Performance of sysncort |
|
| nishantrk Replies: 10 Views: 3576 |
Forum: Utilities Posted: Sun Mar 28, 2010 7:58 pm Subject: Performance of sysncort |
| Thanks..Due to my sufficient knowledge on sort processing was not asking the right question...was able to resolve the issue...you inputs were very helpful.. | |
| Topic: syncsort partial records copy vs full record |
|
| nishantrk Replies: 3 Views: 1841 |
Forum: Utilities Posted: Sun Mar 28, 2010 4:22 pm Subject: syncsort partial records copy vs full record |
| Suggest they explain why they believe this. . .The process will use more space for the output and most likely run longer if the full-size records are written when only 100 bytes would be needed.
... |
|
| Topic: Performance of sysncort |
|
| nishantrk Replies: 10 Views: 3576 |
Forum: Utilities Posted: Sun Mar 28, 2010 4:15 pm Subject: Performance of sysncort |
|
The INREC control statement reformats the input records. Use the INREC control statement to add, delete, or reformat fields before the records are sorted or merged. Use theOUTREC control statement o ... |
|
| Topic: Performance of sysncort |
|
| nishantrk Replies: 10 Views: 3576 |
Forum: Utilities Posted: Sun Mar 28, 2010 10:22 am Subject: Performance of sysncort |
| Only one pass of the input should be needed.
If only one pass is required then i think its better to have the 2nd file also created using the same sort card ..(We have the same sort running again 2 ... |
|
| Topic: Performance of sysncort |
|
| nishantrk Replies: 10 Views: 3576 |
Forum: Utilities Posted: Sat Mar 27, 2010 9:52 pm Subject: Performance of sysncort |
| How many records are in the original input file? What is the recfm/lrecl?
How many records will be written to each of the output files? Will the output have the recfm/lrecl as the input? Somethi ... |
|
All times are GMT - 5 Hours |