 |
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: Help:DB2-table updated ibn last three days |
|
| pulsar Replies: 6 Views: 2474 |
 Forum: Database Posted: Tue Nov 27, 2007 8:33 am Subject: Help:DB2-table updated ibn last three days |
| thanks CraigG.
I got it using SELECT CURRENT DATE FROM SYSIBM.SYSDUMMY1 |
|
| Topic: Help:DB2-table updated ibn last three days |
|
| pulsar Replies: 6 Views: 2474 |
Forum: Database Posted: Tue Nov 27, 2007 8:22 am Subject: Help:DB2-table updated ibn last three days |
| Thanks CraigG & vkphani.
But now the problem is getting the Current date. how can i get it for any table? |
|
| Topic: Help:DB2-table updated ibn last three days |
|
| pulsar Replies: 6 Views: 2474 |
Forum: Database Posted: Tue Nov 27, 2007 7:26 am Subject: Help:DB2-table updated ibn last three days |
| Is it possible to write a query where i can fetch rows updated in last three days.
Eg: Select Val1 from Table1 where last updated date > current date - 3 Note: Last updated date is a colum ... |
|
| Topic: Utility to move from one PDS to other |
|
| pulsar Replies: 4 Views: 2085 |
Forum: Utilities Posted: Wed Nov 07, 2007 11:47 pm Subject: Utility to move from one PDS to other |
| Thanks dbzTHEdinosauer & expat | |
| Topic: Utility to move from one PDS to other |
|
| pulsar Replies: 4 Views: 2085 |
Forum: Utilities Posted: Wed Nov 07, 2007 3:15 am Subject: Utility to move from one PDS to other |
| Is there any utility to move all elements from one PDS to other.
eg: From USRID.INPUT to USRID.INPUT.BKUP Note:The manual s * m is fine, but it will be good if this is automated. |
|
| Topic: Help:Need to replace chars in a PS |
|
| pulsar Replies: 8 Views: 4174 |
Forum: Utilities Posted: Fri Nov 02, 2007 10:02 am Subject: Help:Need to replace chars in a PS |
Thanks a lot krisprems. It worked  |
|
| Topic: Help:Need to replace chars in a PS |
|
| pulsar Replies: 8 Views: 4174 |
Forum: Utilities Posted: Fri Nov 02, 2007 9:46 am Subject: Help:Need to replace chars in a PS |
| my DEFMSG
T1 : RECFM=FB ; LRECL= 1000; BLKSIZE= 30000 OUT : RECFM=FB ; LRECL= 1000; BLKSIZE= 27000 OUT HAS INCOMPATIBLE LRECL SYNCSMF C ... |
|
| Topic: Help:Need to replace chars in a PS |
|
| pulsar Replies: 8 Views: 4174 |
Forum: Utilities Posted: Fri Nov 02, 2007 9:32 am Subject: Help:Need to replace chars in a PS |
| Thanks Vivek - It worked fine when i gave
//OUT DD SYSOUT=* But when i gave //OUT DD ..a flat file it throws SPLICE FROM(T1) TO(OUT) ON(101,8,PD) ... |
|
| Topic: Help:Need to replace chars in a PS |
|
| pulsar Replies: 8 Views: 4174 |
Forum: Utilities Posted: Fri Nov 02, 2007 8:43 am Subject: Help:Need to replace chars in a PS |
| Thanks Vivek G for your quick response.
Unfortunately ICETOOL is not available in my system  |
|
| Topic: Help:Need to replace chars in a PS |
|
| pulsar Replies: 8 Views: 4174 |
Forum: Utilities Posted: Fri Nov 02, 2007 8:05 am Subject: Help:Need to replace chars in a PS |
| I have 2 Input files
File1: 1234567890 9874561230 6549873210 File2 ABC DEF GHI My output file should look like 12ABC67890 98DEF61230 65GHI73210 ie.i want to REPLACE the ... |
|
All times are GMT - 5 Hours |