 |
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 17 matches |
| Author | Message |
|---|---|
 Topic: Update query |
|
| sendhil Replies: 4 Views: 2184 |
 Forum: Database Posted: Sat Jun 02, 2007 8:45 pm Subject: Update query |
| A formula in excel might do the trick? You can generate the sql in excel itself. | |
| Topic: Maximum limit of a Stem. |
|
| sendhil Replies: 2 Views: 1310 |
Forum: TSO and ISPF Posted: Fri Jan 26, 2007 5:28 am Subject: Maximum limit of a Stem. |
| Hi,
I am parsing a file which is big enough. And i am building a stem variable.The limit of the stem variable is to go till 4,00,000.I am not sure abt the maximum limits of stem. I need to k ... |
|
| Topic: To Generate SQL based on where clause. |
|
| sendhil Replies: 4 Views: 2286 |
Forum: Database Posted: Thu Jan 25, 2007 9:06 am Subject: To Generate SQL based on where clause. |
| Kolusu,
I have tried the above mentioned query . The problem was i got extra spaces when i did that. The output looked as below. UPDATE TABLEA SET COL1 = 'X' WHERE COL2= ' COL2value1 ... |
|
| Topic: To Generate SQL based on where clause. |
|
| sendhil Replies: 4 Views: 2286 |
Forum: Database Posted: Thu Jan 25, 2007 6:55 am Subject: To Generate SQL based on where clause. |
| Sorry ,
We need a apostrophe before and after the COL2value* so that we can rerun those update statements.(These are the variables that filled up the places as a result of the select statement) ... |
|
| Topic: To Generate SQL based on where clause. |
|
| sendhil Replies: 4 Views: 2286 |
Forum: Database Posted: Thu Jan 25, 2007 6:52 am Subject: To Generate SQL based on where clause. |
| Hi,
We are trying to generate update SQLs based on a sql condition. SELECT 'UPDATE TABLEA', 'SET COL1 = ''X''', 'WHERE COL2=', COL2, ';' 'COMMIT;' FROM TABLEA WHERE COL3= 'xxxxxx ... |
|
| Topic: Reg Sum() Aggregate in CuRsor. |
|
| sendhil Replies: 2 Views: 1376 |
Forum: Database Posted: Wed Oct 11, 2006 8:29 am Subject: Reg Sum() Aggregate in CuRsor. |
| THNX | |
| Topic: Reg Sum() Aggregate in CuRsor. |
|
| sendhil Replies: 2 Views: 1376 |
Forum: Database Posted: Wed Oct 11, 2006 8:07 am Subject: Reg Sum() Aggregate in CuRsor. |
| Hi,
I am using a Sum() aggregate in a cursor.But i am facing some precompilation errors. SELECT COVERAGE_CD, COVERAGE_SEQ_NBR, UNIT_NBR, ... |
|
| Topic: How to Raise Informational Messages using Edit Macros? |
|
| sendhil Replies: 2 Views: 1593 |
Forum: TSO and ISPF Posted: Fri Sep 22, 2006 3:35 am Subject: How to Raise Informational Messages using Edit Macros? |
| semigeezer,
Let me try and get back. |
|
| Topic: How to Raise Informational Messages using Edit Macros? |
|
| sendhil Replies: 2 Views: 1593 |
Forum: TSO and ISPF Posted: Fri Sep 22, 2006 1:31 am Subject: How to Raise Informational Messages using Edit Macros? |
| Hi,
I have written an edit macro that changes few lines in the program. I need to Hilite those lines that have been changed like it happens when a change macro executes. 000033 ==CHG> 0 ... |
|
| Topic: Find Macro returns 4! |
|
| sendhil Replies: 11 Views: 4025 |
Forum: TSO and ISPF Posted: Wed Sep 20, 2006 11:42 pm Subject: Find Macro returns 4! |
| semigeezer,
Thanks a Lot .It worked. Regards Sendhil. |
|
| Topic: Find Macro returns 4! |
|
| sendhil Replies: 11 Views: 4025 |
Forum: TSO and ISPF Posted: Wed Sep 20, 2006 8:38 am Subject: Find Macro returns 4! |
|
....RECOVERY OFF WARN....NUMBER OFF.............. CAPS OFF....HEX OFF....NULLS OFF....TABS OFF........................ AUTOSAVE ON....AUTONUM OFF....AUTOLIST OFF....STATS ON.............. PROFILE ... |
|
| Topic: Find Macro returns 4! |
|
| sendhil Replies: 11 Views: 4025 |
Forum: TSO and ISPF Posted: Wed Sep 20, 2006 7:58 am Subject: Find Macro returns 4! |
| semigeezer,
No. It is not actually having line numbers also.It is a COBOL program And the purpose of hte logic is to insert few lines after a given line.But While inserting I need to replace ... |
|
| Topic: Find Macro returns 4! |
|
| sendhil Replies: 11 Views: 4025 |
Forum: TSO and ISPF Posted: Mon Sep 18, 2006 7:53 am Subject: Find Macro returns 4! |
| kolusu,
Nope its not a VB file.Any other workaround? Regards Sendhil. |
|
| Topic: Find Macro returns 4! |
|
| sendhil Replies: 11 Views: 4025 |
Forum: TSO and ISPF Posted: Mon Sep 18, 2006 7:34 am Subject: Find Macro returns 4! |
| kolusu,
I didnt get you.Where to add the 4 bytes?Could u please elaborate? Thanks Sendhil. |
|
| Topic: Find Macro returns 4! |
|
| sendhil Replies: 11 Views: 4025 |
Forum: TSO and ISPF Posted: Mon Sep 18, 2006 7:11 am Subject: Find Macro returns 4! |
| Hi,
I am trying to use the Find command in my edit macro. "F '*' .ZCSR .ZCSR 7" The line .ZCSR is pointing to has a '*' in the 7th column.But still the above command returns 4. ... |
|
All times are GMT - 5 Hours |