 |
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 164 matches |
| Author | Message |
|---|---|
 Topic: Convert from binary to character field |
|
| Sqlcode Replies: 4 Views: 4664 |
 Forum: Utilities Posted: Mon May 21, 2012 9:20 am Subject: Convert from binary to character field |
| rajeev5174,
we have got a file of length 80, the 1'st 10 bytes is character and from 11 byte there is a comp field which is s9(09) comp and rest of the field is charcter I need to change the comp ... |
|
| Topic: compare two files in sort |
|
| Sqlcode Replies: 1 Views: 5502 |
Forum: Utilities Posted: Thu May 17, 2012 9:23 am Subject: compare two files in sort |
| koolspark,
Try below untested... In the overlay, you can actually overlay entire 14 bytes (from file 2) but i am showing them differenly for the ease of understanding... //STEP0001 EXEC PGM ... |
|
| Topic: Retiring after 43+ years with IBM |
|
| Sqlcode Replies: 11 Views: 12623 |
Forum: Utilities Posted: Wed May 16, 2012 9:34 am Subject: Retiring after 43+ years with IBM |
| Frank,
Wishing you all the best for the future. Thanks, |
|
| Topic: Getting Second Sunday of March and First Sunday of November |
|
| Sqlcode Replies: 3 Views: 4427 |
Forum: Application Programming Posted: Thu May 10, 2012 9:30 am Subject: Getting Second Sunday of March and First Sunday of November |
| deep81this,
Do you have calendar table built already? Thanks, |
|
| Topic: DFSORT MATCH with existing Dups on Files! |
|
| Sqlcode Replies: 16 Views: 17751 |
Forum: Utilities Posted: Mon May 07, 2012 8:42 am Subject: DFSORT MATCH with existing Dups on Files! |
| Santlou,
However, my client only has DFSORT V1R5. Huh? Could below be the issue? What is the DD name(s) for your input files? ICE005A 0 STATEMENT DEFINER ERROR ICE056A 0 SORTIN NOT DEFINED ICE ... |
|
| Topic: Conversion of alphabetic to COMP-3 |
|
| Sqlcode Replies: 7 Views: 5642 |
Forum: Utilities Posted: Wed May 02, 2012 10:15 am Subject: Conversion of alphabetic to COMP-3 |
| Anuj Dhawan,
First 1,14,c'--', is to keep original values and next one is to do the conversion. This is to show original/input values and converted values on the same line for ease of understanding. ... |
|
| Topic: Conversion of alphabetic to COMP-3 |
|
| Sqlcode Replies: 7 Views: 5642 |
Forum: Utilities Posted: Mon Apr 30, 2012 11:01 am Subject: Conversion of alphabetic to COMP-3 |
| jim haire,
Use TO=PD,LENGTH=n to do conversion. Feel free to change BUILD to OVERLAY or anything other function that you need. //STEP0001 EXEC PGM=SORT //SORTIN DD * ... |
|
| Topic: Checking date format |
|
| Sqlcode Replies: 3 Views: 3134 |
Forum: Utilities Posted: Tue Apr 24, 2012 9:43 am Subject: Checking date format |
| ranga_subham,
If you really meant to check any other values than '-' in the 5th and 8th position, shouldn't you omit such records? OR did you mean to check for valid date values as well? Something ... |
|
| Topic: Can we check DB2 table in sort |
|
| Sqlcode Replies: 4 Views: 3629 |
Forum: Utilities Posted: Thu Apr 12, 2012 9:31 am Subject: Can we check DB2 table in sort |
| shyamsaravan,
It may be possible if you are willing to code DFSort user exit. I personally haven't coded one to check for dB2 existence but it may be possible. Refer to link below for more informa ... |
|
| Topic: column of generated sequence numbers ? |
|
| Sqlcode Replies: 5 Views: 4032 |
Forum: Database Posted: Tue Nov 01, 2011 1:34 pm Subject: column of generated sequence numbers ? |
| tcurrier,
See if below helps... DB2 V9 If you need leading zeros, you need to cast sequence number for char and use digits. SELECT FIELDA,FIELDB,ROW_NUMBER () OVER () AS SEQ_NUM ... |
|
| Topic: To update a file using SORT |
|
| Sqlcode Replies: 11 Views: 7143 |
Forum: Utilities Posted: Wed Aug 31, 2011 8:50 pm Subject: To update a file using SORT |
| Frank,
Yeah, it wouldn't work. As always thanks for correcting my mistake. Thanks, |
|
| Topic: To update a file using SORT |
|
| Sqlcode Replies: 11 Views: 7143 |
Forum: Utilities Posted: Wed Aug 31, 2011 3:25 pm Subject: To update a file using SORT |
| Alternatively you could try below...I have used XX in file1 to indicate any number.
//STEP0001 EXEC PGM=SORT //SYSOUT DD SYSOUT=* ... |
|
| Topic: To update a file using SORT |
|
| Sqlcode Replies: 11 Views: 7143 |
Forum: Utilities Posted: Wed Aug 31, 2011 2:43 pm Subject: To update a file using SORT |
| lenovo,
Use code tags and please show few samples of Input records from both the file and expected output. What do you mean by "there is only one PART in the whole file"? Did you mean o ... |
|
| Topic: Many to many matching of record |
|
| Sqlcode Replies: 2 Views: 2007 |
Forum: Utilities Posted: Thu Aug 25, 2011 7:32 am Subject: Many to many matching of record |
| nithyakothai,
See if below helps...Your layout for file2 is not clear!!! //STEP0001 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTJNF1 DD * RAMA ... |
|
| Topic: DFSORT - Combining steps |
|
| Sqlcode Replies: 3 Views: 3015 |
Forum: Utilities Posted: Tue Aug 23, 2011 10:08 am Subject: DFSORT - Combining steps |
| relaxing,
Assuming LRECL of 80 for FB input file. See if below works(untested)... SORT FIELDS=(1,10,CH,A,11,2,CH,D),EQUALS OUTREC IFTHEN=(WHEN=GROUP,KEYBEGIN=(1,12),PUSH=( ... |
|
All times are GMT - 5 Hours |