 |
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 14 matches |
| Author | Message |
|---|---|
 Topic: Matching two files on keys and writing to output |
|
| Piscesian Replies: 1 Views: 2238 |
 Forum: Utilities Posted: Sat Dec 10, 2011 6:42 am Subject: Matching two files on keys and writing to output |
| I have two files
File A - LRECL=250,RECFM=FB ----+----1----+----2 ******************** ABCD000000047700012 NPTQ000000047700012 ASRA000000047700012 BECC400124431800001 ... |
|
| Topic: Deleting Files from server |
|
| Piscesian Replies: 3 Views: 4492 |
Forum: Job Control Language(JCL) Posted: Sat Jun 11, 2011 5:43 am Subject: Deleting Files from server |
| Hi,
I have an FTP step in the last step of a JCL which deletes .PDF files from a server(close to 900 PDF files). The problem is that if any of the files is being used or open, job abends with RC=16 ... |
|
| Topic: Select row with Maximum sequence value |
|
| Piscesian Replies: 3 Views: 2161 |
Forum: Database Posted: Sun Dec 02, 2007 12:51 am Subject: Select row with Maximum sequence value |
| Hi,
I have a DB2 table in which rows are stored in the following manner SDNum SeqNum Textdata 84510 4 dddd 84510 3 cccc 84510 2 bbbb 84510 1 aaaa 84511 3 cccc 84511 2 bbbb 84511 1 aaaa 845 ... |
|
| Topic: Update date in dataset |
|
| Piscesian Replies: 3 Views: 2071 |
Forum: Utilities Posted: Wed Aug 22, 2007 12:51 pm Subject: Update date in dataset |
| Thanks Kolusu,
This is really useful.... |
|
| Topic: Update date in dataset |
|
| Piscesian Replies: 3 Views: 2071 |
Forum: Utilities Posted: Mon Aug 13, 2007 1:42 pm Subject: Update date in dataset |
| I need to update a datefile in one of the steps of a JCL
Suppose the date file is 2007-06-30 When the jcl is executed, the date file should look like 2007-07-31 i.e update the file to next month en ... |
|
| Topic: Update query |
|
| Piscesian Replies: 4 Views: 2410 |
Forum: Database Posted: Sat Jun 02, 2007 5:15 pm Subject: Update query |
| Thanks William,Kolusu for your inputs.... | |
| Topic: Update query |
|
| Piscesian Replies: 4 Views: 2410 |
Forum: Database Posted: Fri Jun 01, 2007 6:31 pm Subject: Update query |
| Hi,
I need to update a particular DB2 table based on fixed set of values that I have in an excel spreadsheet. Table A Table B SANUM = 1545 ... |
|
| Topic: Help in SQL Query |
|
| Piscesian Replies: 5 Views: 3455 |
Forum: Database Posted: Sat May 19, 2007 2:01 pm Subject: Help in SQL Query |
| Hi,
Can somebody throw light on this as to why this CASE statement is failing.. Thanks, |
|
| Topic: Help in SQL Query |
|
| Piscesian Replies: 5 Views: 3455 |
Forum: Database Posted: Fri May 18, 2007 5:25 pm Subject: Help in SQL Query |
| Hi Kolusu,
Am getting the following error DSNT408I SQLCODE = -122, ERROR: A SELECT STATEMENT WITH NO GROUP BY CLAUSE CONTAINS A COLUMN NAME AND A COLUMN FUNCTION IN THE SELECT CLAUSE OR A COLUMN ... |
|
| Topic: Help in SQL Query |
|
| Piscesian Replies: 5 Views: 3455 |
Forum: Database Posted: Fri May 18, 2007 4:35 pm Subject: Help in SQL Query |
| I'm extracting records from couple of DB2 tables and displaying them on a front end screen.
I'm facing an issue with some records present in a particular DB2 table(SA_SCHEDULE) AGT_ID START_DT ... |
|
| Topic: Rearranging data |
|
| Piscesian Replies: 3 Views: 2759 |
Forum: Utilities Posted: Tue Apr 25, 2006 4:01 pm Subject: Rearranging data |
| Sorry,Frank,for posting in the wrong forum.
There are approximately 20,000 records in the input dataset. For e.g 257}20050414}20050501}180}50 257}20050414}200505 ... |
|
| Topic: Rearranging data |
|
| Piscesian Replies: 3 Views: 2759 |
Forum: Utilities Posted: Tue Apr 25, 2006 3:37 pm Subject: Rearranging data |
| Hi,
I have an input mainframe dataset that contains data like this: 257}20050414}20050501}180}50 257}20050414}20050501}180}25 257}20050414}20050501}180}0 I want to re-arrange(re-format) the ... |
|
| Topic: Sorting records to get the most recent record |
|
| Piscesian Replies: 2 Views: 2119 |
Forum: Utilities Posted: Tue Jul 05, 2005 8:37 pm Subject: Sorting records to get the most recent record |
| Frank,
Thanks a lot for your solution. |
|
| Topic: Sorting records to get the most recent record |
|
| Piscesian Replies: 2 Views: 2119 |
Forum: Utilities Posted: Sat Jul 02, 2005 1:35 am Subject: Sorting records to get the most recent record |
| Hi,
My requirement is to get the last updated event from the input file. I/p file structure: A1-1 A2-8 A3-37 A4-48 333507 2005-06-29-21.05.54 HALFWRKD ... |
|
All times are GMT - 5 Hours |