 |
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 10 matches |
| Author | Message |
|---|---|
 Topic: JOINKEYS REFORMAT question |
|
| Lean Replies: 1 Views: 1842 |
 Forum: Utilities Posted: Wed Nov 25, 2015 8:32 pm Subject: JOINKEYS REFORMAT question |
| Purpose : File3 has paired records from file1 and is the same length as file1.
If file1 length is changed from 69 to 70, I have to update REFORMAT FIELDS=(F1:1,70) manually. I’m wondering if ther ... |
|
| Topic: Fetch cursor with OPTIMIZE FOR 1 ROW |
|
| Lean Replies: 2 Views: 5799 |
Forum: Database Posted: Wed Jan 07, 2015 9:27 pm Subject: Fetch cursor with OPTIMIZE FOR 1 ROW |
| ok, thanks kolusu | |
| Topic: Fetch cursor with OPTIMIZE FOR 1 ROW |
|
| Lean Replies: 2 Views: 5799 |
Forum: Database Posted: Wed Jan 07, 2015 7:15 am Subject: Fetch cursor with OPTIMIZE FOR 1 ROW |
| hi All
I have declare one cursor like below, but it select the second records when excute the fetch func. can pls help share some advice, how it works. and one more question, it will only return o ... |
|
| Topic: To remove additional spaces before continuation character |
|
| Lean Replies: 6 Views: 5191 |
Forum: Utilities Posted: Thu Sep 18, 2014 12:42 am Subject: To remove additional spaces before continuation character |
| Thanks Kolusu, i will try. | |
| Topic: To remove additional spaces before continuation character |
|
| Lean Replies: 6 Views: 5191 |
Forum: Utilities Posted: Tue Sep 16, 2014 8:21 pm Subject: To remove additional spaces before continuation character |
| Hi Kolusu,
because the continuation character can appear in any position of ending spaces. like below: EX '&PRMLIB.(IEFBATRX)' - '&DBSYSID. T ... |
|
| Topic: To remove additional spaces before continuation character |
|
| Lean Replies: 6 Views: 5191 |
Forum: Utilities Posted: Tue Sep 16, 2014 7:51 am Subject: To remove additional spaces before continuation character |
| Hi Kolusu,
I have coded it as per your suggestion, one more question, i would like to change some members from one PDS lib, if they have such issues. Can we use DFSORT to do it? //SYSIN DD ... |
|
| Topic: To remove additional spaces before continuation character |
|
| Lean Replies: 6 Views: 5191 |
Forum: Utilities Posted: Mon Sep 15, 2014 4:04 am Subject: To remove additional spaces before continuation character |
| Hi all,
we meet one issue that continuation character is out of 72 column for one prm member after doing macro replacement, can we have a way to leave just one space or remove all spaces before the ... |
|
| Topic: Can I drop multiple columns in DB2 |
|
| Lean Replies: 4 Views: 10030 |
Forum: Database Posted: Sun Aug 24, 2014 8:34 pm Subject: Can I drop multiple columns in DB2 |
| got it, thanks kolusu. | |
| Topic: Can I drop multiple columns in DB2 |
|
| Lean Replies: 4 Views: 10030 |
Forum: Database Posted: Sat Aug 23, 2014 8:50 pm Subject: Can I drop multiple columns in DB2 |
| Hi Kolusu,
I saw one other forum that they said make it, is there any other way without recreating the table, because there are some data in the table. the data should be reloaded after recreatin ... |
|
| Topic: Can I drop multiple columns in DB2 |
|
| Lean Replies: 4 Views: 10030 |
Forum: Database Posted: Fri Aug 22, 2014 9:56 pm Subject: Can I drop multiple columns in DB2 |
| i just want to drop the last three fields from a table, as following comments from IBM knowledge center.
To add a column, issue the following statement: ALTER TABLE SALES ADD COLUMN SOLD_ ... |
|
All times are GMT - 5 Hours |