Author |
Message |
Topic: Joinkeys 2 files, retain date in discarded file |
vivek
Replies: 6
Views: 4617
|
Forum: Utilities Posted: Tue Nov 16, 2010 9:58 am Subject: Joinkeys 2 files, retain date in discarded file |
I contacted syncsort. Two errors in the card.
1. I wasn't using when(none) condition so syncsort must have kept the whole file length for that condition. I added that condition and got an error th ... |
Topic: Joinkeys 2 files, retain date in discarded file |
vivek
Replies: 6
Views: 4617
|
Forum: Utilities Posted: Mon Nov 15, 2010 1:50 pm Subject: Joinkeys 2 files, retain date in discarded file |
//USERID12 JOB (ABCD),'PGMER',NOTIFY=&SYSUID,CLASS=W,
// MSGCLASS=X
//JOINKEYS EXEC PGM=SORT
//SORTJNF1 DD *
DATE=111510
NONMATCH NMNMN
MATCH1 22222
NONMATCH MMMMM
MATCH ... |
Topic: Joinkeys 2 files, retain date in discarded file |
vivek
Replies: 6
Views: 4617
|
Forum: Utilities Posted: Mon Nov 15, 2010 11:26 am Subject: Joinkeys 2 files, retain date in discarded file |
Kolusu,
thanks for the response. I am using syncsort. |
Topic: Joinkeys 2 files, retain date in discarded file |
vivek
Replies: 6
Views: 4617
|
Forum: Utilities Posted: Mon Nov 15, 2010 10:54 am Subject: Joinkeys 2 files, retain date in discarded file |
I am comparing File A and File B.
1.File A has date info as first rec.
2.Match recs in File B will be written to output.
3. I want to retain Date info as first record in the output file but it is ... |
Topic: How to improve Communication skills |
vivek
Replies: 14
Views: 13819
|
Forum: Related Non-Technical Topics Posted: Fri Jul 14, 2006 1:28 pm Subject: How to improve Communication skills |
vivek said: Most weird grammar in american usage is double negativity but meaning them as a single negative . e.g. In regular english one would say "I haven't seen anything yet" is spoken as ... |
Topic: difference between merge , hybrid joins |
vivek
Replies: 2
Views: 1767
|
Forum: Database Posted: Fri Jul 14, 2006 11:53 am Subject: difference between merge , hybrid joins |
I will try it and let you know if I have questions.
Thanks Kolusu. You are the best. |
Topic: difference between merge , hybrid joins |
vivek
Replies: 2
Views: 1767
|
Forum: Database Posted: Fri Jul 14, 2006 11:16 am Subject: difference between merge , hybrid joins |
does anyone have a crisp answer for this question
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences. |
Topic: IDMS SQL table download and upload |
vivek
Replies: 3
Views: 2202
|
Forum: Database Posted: Mon Oct 03, 2005 8:31 am Subject: IDMS SQL table download and upload |
you need to use the migrator option in your configuration managemetn tool. otherwise punch into tso and then punch out to destination database. |
Topic: JOB IDMS,DB2,CICS,ADSO,LRF,COBOL,MVS,ZO/S IN TRENTON,NJ |
vivek
Replies: 5
Views: 6261
|
Forum: Related Non-Technical Topics Posted: Mon Oct 03, 2005 8:06 am Subject: JOB IDMS,DB2,CICS,ADSO,LRF,COBOL,MVS,ZO/S IN TRENTON,NJ |
Currently Not much for IDMS, Db2, cics, testing options are open.
cannot do h1b from india. f1s welcome. |
Topic: SOC 7 ... |
vivek
Replies: 4
Views: 4479
|
Forum: Problem Determination Posted: Mon Aug 15, 2005 1:35 pm Subject: SOC 7 ... |
Vikas, you use sign trailing separate clause. |
Topic: U0602 Abend |
vivek
Replies: 8
Views: 8590
|
Forum: Problem Determination Posted: Mon Aug 15, 2005 1:27 pm Subject: U0602 Abend |
quick response though bithead. thanks. |
Topic: U0602 Abend |
vivek
Replies: 8
Views: 8590
|
Forum: Problem Determination Posted: Mon Aug 15, 2005 1:16 pm Subject: U0602 Abend |
Bithead, do you know how to solve this U0602 on focus ? I am getting it now. |
Topic: U0602 Abend |
vivek
Replies: 8
Views: 8590
|
Forum: Problem Determination Posted: Wed Jul 13, 2005 11:02 am Subject: U0602 Abend |
did you mean QW U602 ? because you provided text for U602 above. U2222 is another I one I am trying to find out.
Btw dont IBM have details on user abends ? |
Topic: JOB IDMS,DB2,CICS,ADSO,LRF,COBOL,MVS,ZO/S IN TRENTON,NJ |
vivek
Replies: 5
Views: 6261
|
Forum: Related Non-Technical Topics Posted: Wed Jul 13, 2005 10:43 am Subject: JOB IDMS,DB2,CICS,ADSO,LRF,COBOL,MVS,ZO/S IN TRENTON,NJ |
Jobs, anyone ? |
Topic: U0602 Abend |
vivek
Replies: 8
Views: 8590
|
Forum: Problem Determination Posted: Tue Jul 12, 2005 9:52 am Subject: U0602 Abend |
Kolusu, thanks for your input. It occurred in focus extracts. I guess it is space related.
Do you know any comprehensive list of user abend codes. I got an U2222 and couldn't find info on that.
... |
|