Search found 15 matches

by fredrick andrews
Mon Feb 27, 2012 10:39 am
Forum: JCL
Topic: Email sending Problem
Replies: 10
Views: 9771

McaVishalGupta,

I'm pretty sure that this is due to lowvalues / junk in your files.
Remove them and try it.
It will work.


Thanks! :D
by fredrick andrews
Sat Feb 25, 2012 8:36 am
Forum: Admin Announcements
Topic: DB2 QUICK START - FREE for Members
Replies: 81
Views: 109403

Hi Krishna,

Please send me the password number 987.
Thanks in advance.

Regards,
Fred!
by fredrick andrews
Sat Feb 25, 2012 8:29 am
Forum: DB2 INTERVIEW QUESTIONS
Topic: If (Input File = Table) -> Write-to (Output file)
Replies: 1
Views: 2538

If (Input File = Table) -> Write-to (Output file)

Input File:

abc123
def455
ghi347

Db2 Table data:

amnjgh
def798
anh762
ksj934
ghi121

Output file:

def798
ghi121


How will you do this with cursor?
Can we do this without cursor? If yes, how?


P.S: Not using the CODE tags for highlighting purposes...Thanks!
by fredrick andrews
Sat Feb 25, 2012 8:22 am
Forum: COBOL INTERVIEW QUESTIONS
Topic: Editing a Copybook - How to?
Replies: 2
Views: 3614

Editing a Copybook - How to?

You have some changes to be made in a copybook.
Like adding a new field and renaming another field.

What all precautions should you take when doing this???

How will you proceed?
by fredrick andrews
Thu Feb 23, 2012 7:09 pm
Forum: DB2 INTERVIEW QUESTIONS
Topic: VARCHAR in DB2
Replies: 4
Views: 4696

Roger!


:D Thanks!
by fredrick andrews
Thu Feb 23, 2012 4:24 pm
Forum: DB2 INTERVIEW QUESTIONS
Topic: Regarding Cursor
Replies: 4
Views: 7107

dbzTHEdinosauer wrote:Fredrick Andrews,

i realize that you are trying to increase your post count,
but try to pick on questions that are not 2 years old
Guilty as charged... :?
Hey, but I'm only replying in threads where I have some idea about... Not in every new thread created...

Thanks!
by fredrick andrews
Thu Feb 23, 2012 8:42 am
Forum: JCL INTERVIEW QUESTIONS
Topic: concatenate datasets using multiple sortin
Replies: 10
Views: 15687

Can someone please post the JCL for this...

Sort has made IEBGENER shy away at least from me..
by fredrick andrews
Thu Feb 23, 2012 8:34 am
Forum: DB2 INTERVIEW QUESTIONS
Topic: VARCHAR in DB2
Replies: 4
Views: 4696

10 XYZ.
49 XYZ-LEN PIC S9(4) USAGE COMP.
49 XYZ-TEXT PIC X(100).

XYZ-LEN is the length of the dataitem and XYZ-TEXT is the actual data-item.

HTH
by fredrick andrews
Thu Feb 23, 2012 8:30 am
Forum: DB2 INTERVIEW QUESTIONS
Topic: Where would you specify the DECLARE CURSOR statement?
Replies: 4
Views: 6073

Hi dbzTHEdinosauer,

Thanks for the answer.
Sure, we can do it .

But, is there any difference when doing these?

I mean, any performance advantage or anything at all..?

Thanks in advance.
by fredrick andrews
Thu Feb 23, 2012 8:27 am
Forum: DB2 INTERVIEW QUESTIONS
Topic: Regarding Cursor
Replies: 4
Views: 7107

A Cobol-DB2 program can be written without using cursors.
However, using cursors you can do some advances things which might not be possible/ easily possible without using cursors.

Thanks
by fredrick andrews
Thu Feb 23, 2012 8:26 am
Forum: DB2 INTERVIEW QUESTIONS
Topic: FILLER is executable or not?
Replies: 4
Views: 6831

Hi,

Yes... This question is not relevant.

But, many people ask this question.
If they ask, what Natarajan said is the answer to give.

Source:

Personal Experience.
by fredrick andrews
Thu Feb 23, 2012 7:27 am
Forum: COBOL INTERVIEW QUESTIONS
Topic: how to refer the data field?
Replies: 3
Views: 5681

Is it a date field??
by fredrick andrews
Thu Feb 23, 2012 7:26 am
Forum: COBOL INTERVIEW QUESTIONS
Topic: I want to find the 50th city code.how?
Replies: 4
Views: 8221

I think this is a DB2 interview question.

Table (City,city code)

He wants the city code for the city that is the 50th retrieved row.
by fredrick andrews
Thu Feb 23, 2012 7:13 am
Forum: JOB DISCUSSION
Topic: IBM Mainframe Training to corporate & individuals
Replies: 2
Views: 2730

What is the course fee for IBM mainframe training?
by fredrick andrews
Thu Feb 23, 2012 7:07 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Necessity of Group by CLAUSE
Replies: 1
Views: 2189

If there is an orders table with customers and price of the goods they have bought. Then, If you want to get the total amount they have spent on the goods, the below query will help. Example: SELECT Customer,SUM(Price) FROM Qual.Orders GROUP BY Customer; Customer SUM(Price) ________ __________ Amar ...