 |
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 41 matches |
| Author | Message |
|---|---|
 Topic: Can I Sort with 2 different LRECL input files |
|
| newcobol Replies: 5 Views: 3942 |
 Forum: Utilities Posted: Wed Apr 22, 2015 12:49 pm Subject: Can I Sort with 2 different LRECL input files |
| plan b was to make both files 307, yes. the last 26 bytes of one of the files(the one without the extra 2 fields) will just be spaces | |
| Topic: Can I Sort with 2 different LRECL input files |
|
| newcobol Replies: 5 Views: 3942 |
Forum: Utilities Posted: Wed Apr 22, 2015 12:12 pm Subject: Can I Sort with 2 different LRECL input files |
| fyi, the 2 extra fields at the end of the changed file are not part of the fields used in the sortsum | |
| Topic: Can I Sort with 2 different LRECL input files |
|
| newcobol Replies: 5 Views: 3942 |
Forum: Utilities Posted: Wed Apr 22, 2015 12:09 pm Subject: Can I Sort with 2 different LRECL input files |
| they are both fb. if i can't concatenate them with different sizes, that answers my question. plan b would be to just make the other file longer in the in dcb statement so it would match the first cha ... | |
| Topic: Can I Sort with 2 different LRECL input files |
|
| newcobol Replies: 5 Views: 3942 |
Forum: Utilities Posted: Wed Apr 22, 2015 11:48 am Subject: Can I Sort with 2 different LRECL input files |
| i have a sort currently with the same size input files . it sortsums into one file. one of the input files i am changing so that it has 2 new fields on it and is 26 bytes longer. i will obviously make ... | |
| Topic: PROC STEP WITH EMAIL FOR FAILURE |
|
| newcobol Replies: 3 Views: 4228 |
Forum: Job Control Language(JCL) Posted: Fri Jan 23, 2015 3:57 pm Subject: PROC STEP WITH EMAIL FOR FAILURE |
| I want a step to execute only if a step prior to it has an error(code > 4)
i think this should work except there are multiple steps, and if one of them finishes ok, this step wont execute even if ... |
|
| Topic: Unloading table columns properly |
|
| newcobol Replies: 1 Views: 2302 |
Forum: Utilities Posted: Mon Aug 04, 2014 2:41 pm Subject: Unloading table columns properly |
| table definition, has no nulls
,DBNA_LOC_NO ,INTEGER , 4 ,DBNA_CTRY_CD ,CHAR , 3 ,DBNA_AIG_CTRY_CD ,CHAR , 3 ,DBNA_STAT ... |
|
| Topic: Unload putting low value at end of data set |
|
| newcobol Replies: 4 Views: 4371 |
Forum: Database Posted: Wed Jul 30, 2014 4:31 pm Subject: Unload putting low value at end of data set |
| DECIMAL , 11 , 2 ,N
decimal 11(meaning total) with 2 after the decimal point no nulls |
|
| Topic: Unload putting low value at end of data set |
|
| newcobol Replies: 4 Views: 4371 |
Forum: Database Posted: Wed Jul 30, 2014 3:46 pm Subject: Unload putting low value at end of data set |
| p.s.
this is comp-3 field I am selecting |
|
| Topic: Unload putting low value at end of data set |
|
| newcobol Replies: 4 Views: 4371 |
Forum: Database Posted: Wed Jul 30, 2014 3:42 pm Subject: Unload putting low value at end of data set |
| running an unload with this sql:
SELECT CHAR(SUM(POR1_GROSS_PRM_AMT)) the row looks like this with hex turned on, there is a dot at the end 0033534144268.65. 4FFFFFFFFFFFFF4FF0 00033534144268B ... |
|
| Topic: Outrec fields |
|
| newcobol Replies: 3 Views: 3003 |
Forum: Utilities Posted: Fri Jul 25, 2014 11:54 am Subject: Outrec fields |
| ok, prior to reading ur response, i ran it, and it got code 0. i reran it with 14,487, not 14,387(my mistake there). it seems to have worked. it wrote out all the fields except for policy number and c ... | |
| Topic: Outrec fields |
|
| newcobol Replies: 3 Views: 3003 |
Forum: Utilities Posted: Fri Jul 25, 2014 11:08 am Subject: Outrec fields |
| i have input file with several fields. i am doing a sortsum, then i want to skip one of the fields when getting my output.
when using the outrec fields, do i have to write out every field that i wan ... |
|
| Topic: Invalid referback-not makng sense. |
|
| newcobol Replies: 2 Views: 7942 |
Forum: Problem Determination Posted: Fri Jun 13, 2014 8:19 am Subject: Invalid referback-not makng sense. |
| I put a condition code on a step190 in a proc. i have a test job, that calls a proc, and step190 in proc is executing db2proc dsnuproc. the condition code is dependent on step010, which is valid and s ... | |
| Topic: Adding to a sort to make it comma delimited |
|
| newcobol Replies: 2 Views: 3520 |
Forum: Utilities Posted: Mon Apr 14, 2014 11:52 am Subject: Adding to a sort to make it comma delimited |
| just got back here. i added the c'"' at the beginning and the end, and c',' in between the fields in the outrec only and it worked! thanks for the response. | |
| Topic: Adding to a sort to make it comma delimited |
|
| newcobol Replies: 2 Views: 3520 |
Forum: Utilities Posted: Mon Apr 14, 2014 10:30 am Subject: Adding to a sort to make it comma delimited |
| I have 2 sort cards working together to sort sum and turn input file into display data. I am tasked to make this also comma delimited. typically this is done in the cobol program putting " at beg ... | |
| Topic: Putting sign into the display output record |
|
| newcobol Replies: 1 Views: 4310 |
Forum: Utilities Posted: Tue Mar 11, 2014 4:33 pm Subject: Putting sign into the display output record |
| we want the plus or minus to show in the output record.
does anyone know how to change the signed fields. i am turning comp-3 into display data, its working but i want to put a + in first column if i ... |
|
All times are GMT - 5 Hours |