 |
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 265 matches |
| Author | Message |
|---|---|
 Topic: VERTICAL to HORIZONAL COLUMNS |
|
| NASCAR9 Replies: 4 Views: 24080 |
 Forum: Database Posted: Tue Dec 18, 2018 7:08 pm Subject: VERTICAL to HORIZONAL COLUMNS |
| kolusu,
No apology necessary. Your help is second to none. I posted the query because I have never seen/used the Function DECODE before. It solves a problem I'm faced with periodical. I'm hoping it ... |
|
| Topic: VERTICAL to HORIZONAL COLUMNS |
|
| NASCAR9 Replies: 4 Views: 24080 |
Forum: Database Posted: Tue Dec 18, 2018 5:06 pm Subject: VERTICAL to HORIZONAL COLUMNS |
| kolusu,
I have xml to do the concatenating of data and flatting. xml returns the data in a single column(as far as I know). I'm familiar with the link, I participated in it 
The point of ... |
|
| Topic: VERTICAL to HORIZONAL COLUMNS |
|
| NASCAR9 Replies: 4 Views: 24080 |
Forum: Database Posted: Tue Dec 18, 2018 2:33 pm Subject: VERTICAL to HORIZONAL COLUMNS |
| The data is in a vertical format with a key of FAMILY_ID that allows grouping a Family. The data looks something like this:
FAMILY_ID RELATION_ID FIRST_NAME LAST_NAME 123456 0 HOBO ... |
|
| Topic: How to concatenate text from multiple rows |
|
| NASCAR9 Replies: 6 Views: 78716 |
Forum: Database Posted: Thu Jun 07, 2018 12:59 pm Subject: How to concatenate text from multiple rows |
| Kolusu,
I see where I omitted TEXTNUMBER from my results. 
I used your model and added an Order BY(just to show another option) and removed REPLACE(REPLACE I tested with know data in our s ... |
|
| Topic: How to concatenate text from multiple rows |
|
| NASCAR9 Replies: 6 Views: 78716 |
Forum: Database Posted: Wed Jun 06, 2018 6:01 pm Subject: How to concatenate text from multiple rows |
|
SELECT STRIP(TRIM(CAST(SUBSTR(XMLSERIALIZE(XMLAGG(XMLTEXT(CONTENT|| ', ') ORDER BY TEXTNUMBER, LINE) AS CLOB (1K)) , 1, 100) AS VARCHAR &# ... |
|
| Topic: SET Symbol substitution for instream data in JCL |
|
| NASCAR9 Replies: 2 Views: 7342 |
Forum: Job Control Language(JCL) Posted: Wed May 09, 2018 5:54 pm Subject: SET Symbol substitution for instream data in JCL |
| Kolusu,
You get the 'BIG BRAIN' Award today! It worked perfectly! Thank You Very Much! |
|
| Topic: SET Symbol substitution for instream data in JCL |
|
| NASCAR9 Replies: 2 Views: 7342 |
Forum: Job Control Language(JCL) Posted: Wed May 09, 2018 11:31 am Subject: SET Symbol substitution for instream data in JCL |
| I'm trying to set a variable in a job that is repeated 8 times. The change happens daily.
// SET EPRM='.SPL-08MAY2018' **** This is loaded into a dataset Via PGM=EZACFSM1 XXXX\XXXXFTP ... |
|
| Topic: Determining run time of DB2 SQL query |
|
| NASCAR9 Replies: 4 Views: 12355 |
Forum: Database Posted: Fri Dec 15, 2017 12:02 pm Subject: Determining run time of DB2 SQL query |
| In the past Auditing was very expensive for CPU in our shop.
This is a little rough, but it will get the job done. If the time does not have to be 100% perfect you could do something like this: ... |
|
| Topic: How to get PST TSO TIME using CURDAT sort |
|
| NASCAR9 Replies: 8 Views: 6885 |
Forum: Utilities Posted: Wed Oct 18, 2017 4:06 pm Subject: How to get PST TSO TIME using CURDAT sort |
| Google is your best friend.
https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.2.0/com.ibm.zos.v2r2.ieae200/dynpsm.htm |
|
| Topic: Last execution of a Stored Procedure |
|
| NASCAR9 Replies: 3 Views: 5435 |
Forum: Database Posted: Mon Oct 09, 2017 11:58 am Subject: Last execution of a Stored Procedure |
| Thanks kolusu,
The above query did not give me the complete list. It did give me the column I need to look at( LASTUSED). Below are two queries I built. The first one gives all the detail about Ob ... |
|
| Topic: Last execution of a Stored Procedure |
|
| NASCAR9 Replies: 3 Views: 5435 |
Forum: Database Posted: Fri Oct 06, 2017 4:35 pm Subject: Last execution of a Stored Procedure |
| I searched and nothing came up, it could be my search skills
Is there a query that can tell me the last time a stored procedure executed? |
|
| Topic: New Formatting Functions in DB2 |
|
| NASCAR9 Replies: 1 Views: 4529 |
Forum: Database Posted: Wed Jul 26, 2017 6:42 pm Subject: New Formatting Functions in DB2 |
| The forum has been slow so I figured I post something.
Just came across this function: VARCHAR_FORMAT Read up on it, it's powerful. Many more formats available. I use to do this: ... |
|
| Topic: FB to VB using OUTREC |
|
| NASCAR9 Replies: 7 Views: 9397 |
Forum: Utilities Posted: Fri Oct 21, 2016 11:08 am Subject: FB to VB using OUTREC |
| This will solve your 32 blank problem
32Z, 32 ZEROES 32X, 32 SPACES |
|
| Topic: Strange WS data behavior after WRITE in Cobol. |
|
| NASCAR9 Replies: 7 Views: 7845 |
Forum: Application Programming Posted: Tue Oct 04, 2016 2:33 pm Subject: Strange WS data behavior after WRITE in Cobol. |
| Regardless, you need to initialize the record. | |
| Topic: Strange WS data behavior after WRITE in Cobol. |
|
| NASCAR9 Replies: 7 Views: 7845 |
Forum: Application Programming Posted: Tue Oct 04, 2016 1:08 pm Subject: Strange WS data behavior after WRITE in Cobol. |
| INITIALIZE DETAIL-RECORD
REPLACING ALPHANUMERIC BY SPACES NUMERIC BY ZEROS. Fill in the WS variables WRITE FD 01 NAME (Insert your 01 ... |
|
All times are GMT - 5 Hours |