 |
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 74 matches |
| Author | Message |
|---|---|
 Topic: Cursor using JOIN and FOR UPDATEM OF |
|
| prog_mario Replies: 4 Views: 4799 |
 Forum: Database Posted: Wed Jul 04, 2012 8:19 pm Subject: Cursor using JOIN and FOR UPDATEM OF |
| Thanks a lot guys. I used the first sugestion from GuyC and it worked fine. | |
| Topic: SORT 2 FILES - OUTPUTING THE DIFFERENCES FROM BOTH INPUTS. |
|
| prog_mario Replies: 7 Views: 6234 |
Forum: Utilities Posted: Sat Jun 30, 2012 7:08 am Subject: SORT 2 FILES - OUTPUTING THE DIFFERENCES FROM BOTH INPUTS. |
| Hi everybody I'm really glad receiving all that attention from all of you.
Talking with my business partner, he said that only 2 fields could be modified. One thing I forgot to say (Kolusu) is that ... |
|
| Topic: SORT 2 FILES - OUTPUTING THE DIFFERENCES FROM BOTH INPUTS. |
|
| prog_mario Replies: 7 Views: 6234 |
Forum: Utilities Posted: Tue Jun 26, 2012 2:45 pm Subject: SORT 2 FILES - OUTPUTING THE DIFFERENCES FROM BOTH INPUTS. |
| EXAMPLE:
FILE1: PEDRO2012-06-26MANAGER FILE2: PEDRO2012-06-26PRESIDENT THE OUTPUT I NEED WOULD BE: PEDRO 2012-06-26 MANAGERPREDISENT PEDRO CONTINUES THE SAME, SO, WE HAVE 5 S ... |
|
| Topic: SORT 2 FILES - OUTPUTING THE DIFFERENCES FROM BOTH INPUTS. |
|
| prog_mario Replies: 7 Views: 6234 |
Forum: Utilities Posted: Tue Jun 26, 2012 1:32 pm Subject: SORT 2 FILES - OUTPUTING THE DIFFERENCES FROM BOTH INPUTS. |
| Hi everybody. I'm trying this since this morning...
I have 2 files, length 106 bytes. 1st is an old table unload. 2nd is the current table unload. I need to compare both files and if anything is d ... |
|
| Topic: Cursor using JOIN and FOR UPDATEM OF |
|
| prog_mario Replies: 4 Views: 4799 |
Forum: Database Posted: Tue Jun 26, 2012 9:27 am Subject: Cursor using JOIN and FOR UPDATEM OF |
| Thanks a lot GuyC. | |
| Topic: Cursor using JOIN and FOR UPDATEM OF |
|
| prog_mario Replies: 4 Views: 4799 |
Forum: Database Posted: Tue Jun 26, 2012 8:20 am Subject: Cursor using JOIN and FOR UPDATEM OF |
| Hi everybody.
I need to build a cursor join 2 tables and update some columns of one of those tables but it's not working. DECLARE CURMARCA CURSOR WITH HOLD FOR SELECT B. ... |
|
| Topic: Using long header names (how to continue in the next line?) |
|
| prog_mario Replies: 2 Views: 3724 |
Forum: Utilities Posted: Fri Jun 22, 2012 2:12 pm Subject: Using long header names (how to continue in the next line?) |
| thanks a lot. | |
| Topic: Using long header names (how to continue in the next line?) |
|
| prog_mario Replies: 2 Views: 3724 |
Forum: Utilities Posted: Fri Jun 22, 2012 1:18 pm Subject: Using long header names (how to continue in the next line?) |
|
SORT FIELDS=(001,005,CH,A, 007,011,CH,A, 019,010,CH,A, ... |
|
| Topic: Using concat & substr |
|
| prog_mario Replies: 2 Views: 3204 |
Forum: Database Posted: Mon Dec 05, 2011 7:44 am Subject: Using concat & substr |
| I need to run a query like this:
Select tab_number ,tab_name from tab where date(tab_timestamp) >= tab_rec_date; In this situation tab_rec_date is length of 8 bytes (YYYYM ... |
|
| Topic: How to empty a file without deleting it? |
|
| prog_mario Replies: 1 Views: 3230 |
Forum: Utilities Posted: Tue Sep 13, 2011 6:43 am Subject: How to empty a file without deleting it? |
| Hi everybody, I have a job step in which I need to delete the content of da dataset to let it empty.
Is it possible to do that using IDCAMS or IEFBR14? |
|
| Topic: Join of 2 files with some specific conditions. |
|
| prog_mario Replies: 7 Views: 8676 |
Forum: Utilities Posted: Mon Aug 08, 2011 11:46 am Subject: Join of 2 files with some specific conditions. |
| It's working this way:
JOINKEYS FILE=F1,FIELDS=(008,005,A,001,007,A) JOINKEYS FILE=F2,FIELDS=(008,005,A,001,007,A) JOIN UNPAIRED REFORMAT ... |
|
| Topic: Join of 2 files with some specific conditions. |
|
| prog_mario Replies: 7 Views: 8676 |
Forum: Utilities Posted: Mon Aug 08, 2011 11:06 am Subject: Join of 2 files with some specific conditions. |
| This is my sort card:
OPTION COPY JOINKEYS F1=INA,FIELDS=(13,05,A,06,07,A) JOINKEYS F2=INB,FIELDS=(13,05,A,06,07,A) JOIN UNPAIRED ... |
|
| Topic: Join of 2 files with some specific conditions. |
|
| prog_mario Replies: 7 Views: 8676 |
Forum: Utilities Posted: Mon Aug 08, 2011 11:04 am Subject: Join of 2 files with some specific conditions. |
| It's not working because when I run the job it seems that Syncsort is executed.
SYNCSORT LICENSED FOR CPU SERIAL NUMBER 98B8A, SYSIN : OPTION COPY ... |
|
| Topic: Join of 2 files with some specific conditions. |
|
| prog_mario Replies: 7 Views: 8676 |
Forum: Utilities Posted: Mon Aug 08, 2011 9:57 am Subject: Join of 2 files with some specific conditions. |
| I have 2 input files (same lenght and same fields) and and need to use SORT to join the files using these conditions:
a- when the record exists in file 1 but not in file 2, I want to output the rec ... |
|
| Topic: Package authority from SySIBM tables |
|
| prog_mario Replies: 9 Views: 5454 |
Forum: Database Posted: Thu May 05, 2011 2:23 pm Subject: Package authority from SySIBM tables |
| The error occurs only when I'm connected remotely. When I use a VPN it works, but, STMT doesn't have the information I need. | |
All times are GMT - 5 Hours |