 |
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 12 matches |
| Author | Message |
|---|---|
 Topic: SQL Select when more rows and single Rows |
|
| DGM Replies: 3 Views: 2036 |
 Forum: Database Posted: Sat Nov 26, 2005 12:12 pm Subject: SQL Select when more rows and single Rows |
| Hi
Thanks for the post. Can you please explain me the following SQL. select Y.PO as B_PO, Y.MAX_SEQ as B_SEQ, case when num1 = 1 then X.status else 'P' end as b_status fro ... |
|
| Topic: SQL Select when more rows and single Rows |
|
| DGM Replies: 3 Views: 2036 |
Forum: Database Posted: Thu Nov 24, 2005 8:47 pm Subject: SQL Select when more rows and single Rows |
| Hi
I need to have a SQL based on inner select. I want to get the Latest PO information when multiple occurance is present in table. TableA Col1 Col2 Col3 PO Loc OR ... |
|
| Topic: Vertical To Horizontal , Can it be possible by SyncSort |
|
| DGM Replies: 8 Views: 9084 |
Forum: Utilities Posted: Wed Nov 16, 2005 8:14 am Subject: Vertical To Horizontal , Can it be possible by SyncSort |
| Hi
I can use splice operator by SYNCTOOL. That works in my JCL. I have SYNCSORT 1.1 . But How can I get my desired output. Thanks DGM |
|
| Topic: Vertical To Horizontal , Can it be possible by SyncSort |
|
| DGM Replies: 8 Views: 9084 |
Forum: Utilities Posted: Wed Nov 16, 2005 2:29 am Subject: Vertical To Horizontal , Can it be possible by SyncSort |
| Hi
I want to create a Horizontal from Vertical Row. Key is PO and 9 Byte. INPUT PO(9 byte char) Change_Description(15 byte desc) 123456789 add item 123456789 ... |
|
| Topic: Easytrieve Abend at END OF File |
|
| DGM Replies: 8 Views: 10444 |
Forum: Application Programming Posted: Mon Nov 14, 2005 10:49 pm Subject: Easytrieve Abend at END OF File |
| Yes Kolusu, It worked as I have expected. It is a great site to get the resolution.
Thank you Kolusu |
|
| Topic: Easytrieve Abend at END OF File |
|
| DGM Replies: 8 Views: 10444 |
Forum: Application Programming Posted: Mon Nov 14, 2005 12:23 am Subject: Easytrieve Abend at END OF File |
| I thing, I have mistaken in my code. I have kept ODX = 1 instead of ODX=0.
I will check it again before Post again. Thank you kolusu. |
|
| Topic: Easytrieve Abend at END OF File |
|
| DGM Replies: 8 Views: 10444 |
Forum: Application Programming Posted: Mon Nov 14, 2005 12:15 am Subject: Easytrieve Abend at END OF File |
| Sorry for mistaken in last sentense. If input has 483 records, It won't be writing any record by putting the = sign in If loop. | |
| Topic: Easytrieve Abend at END OF File |
|
| DGM Replies: 8 Views: 10444 |
Forum: Application Programming Posted: Mon Nov 14, 2005 12:12 am Subject: Easytrieve Abend at END OF File |
| Hi kolusu
I did the coding the way you have suggested. I saw my input has 966 records and i am expecting two output records but it only wrote one record. I thing i have to do something with end o ... |
|
| Topic: Convert left justified Digits to Actual Numeric |
|
| DGM Replies: 4 Views: 4265 |
Forum: Utilities Posted: Sat Nov 12, 2005 4:40 pm Subject: Convert left justified Digits to Actual Numeric |
| Thanks Kolusu for considering my question.
I was looking for SORT Solution . I can't apply Frank's Method due TO limitation of Syncsort. I apreciate Franks help. I did this in easytrieve in the fo ... |
|
| Topic: Easytrieve Abend at END OF File |
|
| DGM Replies: 8 Views: 10444 |
Forum: Application Programming Posted: Sat Nov 12, 2005 4:09 pm Subject: Easytrieve Abend at END OF File |
| Hi Kolusu
This worked and thak you very much for your solution. Again It didn't solve my purpose what I am trying to do. This logic will always write the record even if it has not ... |
|
| Topic: Convert left justified Digits to Actual Numeric |
|
| DGM Replies: 4 Views: 4265 |
Forum: Utilities Posted: Sat Nov 12, 2005 11:27 am Subject: Convert left justified Digits to Actual Numeric |
| Hi
I have a requirment to get the numeric number which is left justfied with digits. This left justified digits are always digits. I have Syncsort in my Shop. I posted this question to Sy ... |
|
| Topic: Easytrieve Abend at END OF File |
|
| DGM Replies: 8 Views: 10444 |
Forum: Application Programming Posted: Sat Nov 12, 2005 1:08 am Subject: Easytrieve Abend at END OF File |
| The input file is 1 byte length and and total of 14080 records.
I want to accumulate 483 bytes from input to write to output file. My Program is abending at end of file. Trying to find why is it so ... |
|
All times are GMT - 5 Hours |