Search found 23 matches

by pankaj_zenith2008
Tue Dec 01, 2009 8:35 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 Query
Replies: 5
Views: 8166

N one thing I can think of for this problem is,
I can use UNION to combine rows, thats what i comprehend, but finally no output.
by pankaj_zenith2008
Mon Nov 30, 2009 8:48 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 Query
Replies: 5
Views: 8166

sorry if you misunderstood the question, But I am unable to write this query. N I gave the hint because-- this is what i hv to told to people to whom i hv asked this que, bt they were not able to answer. So i took the help of this FORUM so that i can have my que solved. Can someone please show me th...
by pankaj_zenith2008
Thu Nov 26, 2009 8:47 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 Query
Replies: 5
Views: 8166

DB2 Query

I have ONLY one table Tab1 having ONLY three columns as EmpId, EmpName, ManagerId.

I have to display EmpId and the Manager Name.


hint is :- the manager is also an employe of the compney.
by pankaj_zenith2008
Wed Nov 25, 2009 8:02 am
Forum: COBOL
Topic: what is the length of PARM parameter in jcl
Replies: 11
Views: 26187

yes anuj, now i came to know that he was lookin for sysin an the answer, and i guess for each row in sysin - we have to write accapt statement in cobol pgm,

correct me if i supposed wrong
by pankaj_zenith2008
Tue Aug 18, 2009 6:50 pm
Forum: COBOL
Topic: cobol
Replies: 6
Views: 12654

can you please please give any example ( CODE EXAMPLE ) for the explanation of how to pass values using sysin, i deadly nead tha answer,

help help
by pankaj_zenith2008
Tue Aug 18, 2009 6:01 pm
Forum: VSAM - File system
Topic: CODE field
Replies: 1
Views: 4246

CODE field

I have some doubts,

what is VSAM Code field and what is upgrade set.

seeking help from all
by pankaj_zenith2008
Tue Aug 18, 2009 6:00 pm
Forum: VSAM - File system
Topic: share option
Replies: 1
Views: 6230

share option

What is the explanation of share-option, n where we used to define it ( is it defined in the definition of the DATASET. ), please answer
by pankaj_zenith2008
Tue Aug 18, 2009 5:57 pm
Forum: JCL
Topic: Use of include statment.
Replies: 2
Views: 4761

thanks Mr Spock , it explains everything about include, thank you very much for your support
by pankaj_zenith2008
Tue Aug 18, 2009 5:31 pm
Forum: COBOL
Topic: Creation of DS
Replies: 1
Views: 3836

Creation of DS

While creating the DS, we give DirectoryBlock value as not null for PDS, n 0 for PS( Physical Sequential),

My Question is while giving DirectoryBlock = 1, it will allocate how many members, 5 or 6 ?

The question i was asked was how to create a PDS with a limit of 30 PS.

HELP
by pankaj_zenith2008
Tue Aug 18, 2009 4:52 pm
Forum: JCL
Topic: Diff b/n JES2 n JES3
Replies: 0
Views: 2803

Diff b/n JES2 n JES3

Can someone provide me the answer or the link which explains the diff b/n JES2 n JES3 statements. Or is there are some restrictions in JES2 which we can deal in JES3 ( i am clueless )
by pankaj_zenith2008
Tue Aug 18, 2009 4:50 pm
Forum: JCL
Topic: Definition SYS*
Replies: 1
Views: 3701

Definition SYS*

hi alll, could you please help me in understanding[ not the definitions ] the following terms,

1. SYSUDUMPS
2. SYSABEND.
3. SYSMDUMP.
4. SYSABOUT.
by pankaj_zenith2008
Tue Aug 18, 2009 4:45 pm
Forum: VSAM - File system
Topic: QSAM
Replies: 2
Views: 8823

QSAM

1. VSAM i know, but what is difference between VSAM/ QSAM/ ISAM and FLAT file.

2. What is/are QSAM Errors.

If anyone have links specifically for QSAM, il be highly thankful to him/her
by pankaj_zenith2008
Tue Aug 18, 2009 4:39 pm
Forum: JCL
Topic: skeleton JCL
Replies: 1
Views: 5347

skeleton JCL

what is skeleton jcl and why it is used.
by pankaj_zenith2008
Tue Aug 18, 2009 4:39 pm
Forum: JCL
Topic: What is the meaning of Until Further notice. [ TYPRUN ]
Replies: 2
Views: 7435

What is the meaning of Until Further notice. [ TYPRUN ]

TYPRUN has two options, 1 is SCAN, and other is HOLD.

SCAN is used for checking syntax,
But the definition of TYPRUN=HOLD says this will hold it until further notice,
What does this until further notice means, n how to give that so called notice.[/u][/i]
by pankaj_zenith2008
Tue Aug 18, 2009 4:31 pm
Forum: JCL
Topic: Use of include statment.
Replies: 2
Views: 4761

Use of include statment.

What is the use of include statement in the JCl. ( Does it have anything related to to the DATASET alternative to the Steplib statement. )