Search found 12 matches

by vishu1484
Fri Aug 28, 2009 9:50 pm
Forum: CICS
Topic: CICS Maps related question - symbolic map vs physical map
Replies: 1
Views: 7808

CICS Maps related question - symbolic map vs physical map

What is the difference between a Symbolic map and Physical map ?

Explain in brief plz...
by vishu1484
Thu Jul 30, 2009 9:42 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: SQl Queries on Duplicates values
Replies: 7
Views: 12384

Hi Natarajan
it's came perfect answer thanks a lot for your support.
i tried this with joins as below.

SELECT t1.Dept
FROM table as t1inner join

(
SELECT Dept
FROM table GROUP BY Dept
HAVING COUNT(*) > 1
) as t2 on t1.Dept=t2.Dept


Regards,
Vishal
by vishu1484
Tue Jul 28, 2009 5:38 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: SQl Queries on Duplicates values
Replies: 7
Views: 12384

Not quite clear can you please explain...
by vishu1484
Tue Jul 28, 2009 5:18 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: SQl Queries on Duplicates values
Replies: 7
Views: 12384

SQl Queries on Duplicates values

Hi, There is one table name as master with record as below. A/c No Dept 1 A 2 B 3 C 4 D 5 A 6 D 7 A 8 B A/C no and Dept are different column. Now i want the record which is duplicates in it.(only duplicates record should display) Like in above table A, D and B are duplicates so that only record shou...
by vishu1484
Wed May 14, 2008 3:20 pm
Forum: COBOL
Topic: Corresponding statement
Replies: 4
Views: 10979

Corresponding statement

Which one of the following is not a valid statement?


MOVE CORRESPONDING OLD-REC TO NEW-REC.

MULTIPLY CORRESPONDING OLD-REC BY NEW-REC.

ADD CORRESPONDING OLD-REC TO NEW-REC.

SUBTRACT CORRESPONDING OLD-REC FROM NEW-REC.
by vishu1484
Mon May 12, 2008 11:36 am
Forum: JCL
Topic: GDG Related
Replies: 2
Views: 9405

GDG Related

Maximum how many number of generation that are allowed in GDG ?
by vishu1484
Fri May 09, 2008 4:29 pm
Forum: JCL
Topic: GDG Related
Replies: 8
Views: 19088

Thanks a lot krishna
by vishu1484
Fri May 09, 2008 2:03 pm
Forum: JCL
Topic: GDG Related
Replies: 8
Views: 19088

So u mean to say that i can use that 12 version of GDG in one JCL step. One more thing, If i will convert that GDG in flat file and use than also its correct ?

Let me know. Thanks for your responce.
by vishu1484
Fri May 09, 2008 9:07 am
Forum: JCL
Topic: GDG Related
Replies: 8
Views: 19088

Yes record contain dates of various month.
by vishu1484
Thu May 08, 2008 5:48 pm
Forum: JCL
Topic: GDG Related
Replies: 8
Views: 19088

Yes i need to differentiate that also...
by vishu1484
Thu May 08, 2008 5:21 pm
Forum: JCL
Topic: GDG Related
Replies: 8
Views: 19088

GDG Related

Hi, Premium data for the month is saved in a GDG file, so at the end of the year we have 12 version of premium file(one for each month). In year end i would like to generate a report for entire year's premium date. So can we use that 12 version of GDG together in one JCL and create whole year report...
by vishu1484
Thu May 08, 2008 3:10 pm
Forum: JCL
Topic: Related to Jcl
Replies: 2
Views: 7845

Related to Jcl

Following need to be specified to access a non-catlog datasets

1) Unit 2) Vol=ser 3)Unit & Vol=ser 4) None of above

which is correct one. Let me know

Thanks Vishal