Search found 143 matches

by arrbee
Sun Jun 11, 2006 11:46 am
Forum: INTERVIEW QUESTIONS
Topic: jcl questions
Replies: 2
Views: 6508

How we can help you without seeing your question!!!???

If you wanted to greet us then thanks.

Hi, How are you doing?
by arrbee
Sun Jun 11, 2006 11:45 am
Forum: EASYTRIEVE
Topic: EASYTRIEVE
Replies: 3
Views: 16042

See if this is useful to you..............

http://www.easytrieveplus.com/prog_contents.html

HTH.
by arrbee
Sun Jun 11, 2006 11:42 am
Forum: ENDEVOR, COOLGEN , PANVALET and CA-7
Topic: analaysis tool
Replies: 2
Views: 8852

I think, there use to be a tool called MF-Revolve. I am not sure.
by arrbee
Sun Jun 11, 2006 11:40 am
Forum: JCL
Topic: How to execute first n number of steps in a jcl
Replies: 6
Views: 17885

A JCL with 30 steps.

Guys, A JCL is having 30 steps. I want to execute only the 3rd step. One way of doing it is to put a RESTART=STEP03 in the job card and put a null statement after the 3rd step.

Does anybody know multiple ways of doing the same? Pls share the details.

TIA.
by arrbee
Sun Jun 11, 2006 11:37 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Using Index
Replies: 2
Views: 11216

Using Index

1). How do we know whether a SELECT query is using INDEX or not? 2). How can we say that a SELECT query is optimized or not? My guess is that before using that query in an embedded SQL we can run EXPLAIN on that. Can anybody explain the details? 3). How to use a TEST region program to run in DB2 PRO...
by arrbee
Sun Jun 11, 2006 11:31 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Testing a field in db2.
Replies: 1
Views: 7457

Testing a field in db2.

Hi,

A field is modified from Decimal(9,2) to Decimal(11,2). After successful compilation, ran the JCL successfully with zero return code. How to find whether the particular field is (9,2) or (11,2).

TIA.
by arrbee
Wed Jun 07, 2006 7:22 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Reg: DCLGEN copybook compilation
Replies: 4
Views: 16529

Is this what you wanted to ask? A table is added with two new columns (Defined as NOT NULL WITH DEFAULT) with the existing columns, and the corresponding host variables for those two columns in DCLGEN( As a copybook) are also defined. Is it required to recompile the programs that use the newly added...
by arrbee
Wed Jun 07, 2006 7:20 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Reg: DCLGEN copybook compilation
Replies: 4
Views: 16529

Pls rephrase your Q. It is confusing.
by arrbee
Wed Jun 07, 2006 7:15 am
Forum: JCL
Topic: How to execute first n number of steps in a jcl
Replies: 6
Views: 17885

Put a null statement (//) after the 10th step........:-)

HTH.
by arrbee
Wed May 31, 2006 4:33 pm
Forum: COBOL
Topic: Where can i find IMS/DC manuals
Replies: 4
Views: 7165

It is tough to work. Are you put into that project without being trained!?

I am sorry.
by arrbee
Wed May 31, 2006 12:19 pm
Forum: COBOL
Topic: What are all the COBOL compilers available?
Replies: 6
Views: 25775

Compile - IGYCRCTL
Link Edit - IEWL

!?!?
by arrbee
Wed May 31, 2006 12:11 pm
Forum: COBOL
Topic: Searching GDG versions
Replies: 6
Views: 16147

I think krvarada is asking how to search a string in a GDG with many generations!!! Well....you can supply GDG base to DDNAME in the JCL to process all the generations by your COBOL program. You would use a SEARCH /PERFORM verb in the procedure division to do a look out on the data what you are look...
by arrbee
Tue May 30, 2006 9:57 am
Forum: VSAM - File system
Topic: how to convert vsam to db2
Replies: 2
Views: 6125

Sir,

Try www.google.com.

I got many hits..........
by arrbee
Tue May 30, 2006 9:53 am
Forum: IMS DB
Topic: IMS DB DC
Replies: 4
Views: 12161

Did you try GOOGLE
by arrbee
Tue May 30, 2006 9:51 am
Forum: IMS/DC
Topic: PCB Status code of AD
Replies: 3
Views: 13737

because you said JUNK is coming in........is it something you need to do with initializing the fields!! I am just giving a hint here.

Thanks.