MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Answers requested for few questions asked in an interview.

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Interview Q & A
View previous topic :: View next topic  
Author Message
mf_user
Intermediate


Joined: 01 Jun 2003
Posts: 372
Topics: 105

PostPosted: Wed Feb 15, 2006 7:04 am    Post subject: Answers requested for few questions asked in an interview. Reply with quote

Hi,

1) Is it possible to retrieve first 5 characters of a column from a DB2 table?

2) Is it possible use the column function "MAX" on a column that is defined as character in DB2?

3) Why does the S9(8 ) COMP occupies only 4 bytes?

4) Is it possible to have or define multiple MAPS within a MAPSET in CICS?

5) A main DB2-COBOL program reads a file and a DB2-COBOL sub-program updates the table? In this case which call is preferrable? Static or Dynamic?

6) Can we access a QSAM file in a CICS-COBOL program?

Thanks in advance.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==
Back to top
View user's profile Send private message Send e-mail
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12358
Topics: 75
Location: San Jose

PostPosted: Wed Feb 15, 2006 8:28 am    Post subject: Reply with quote

Mf_user,

Please follow the forum rules. There is an seperate forum exclusively for the interview Q & A. All the interview related questions MUST be posted in that forum. If you do NOT follow the rules then you will soon join the elite list of banned users as this is not the first time I am reminding you about following the rules of the forum.


Quote:

1) Is it possible to retrieve first 5 characters of a column from a DB2 table?


Yes. Use substr function. check this link for a detailed explanation of the function SUBSTR

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQH11/3.2.80?DT=20010718164132

Quote:

2) Is it possible use the column function "MAX" on a column that is defined as character in DB2?


Yes

Quote:

3) Why does the S9(08 ) COMP occupies only 4 bytes?


Because it is stored in a fullword. check this
[code:1:a982af7050]
-------------------------------------+-----------------------
1 through 4
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
mf_user
Intermediate


Joined: 01 Jun 2003
Posts: 372
Topics: 105

PostPosted: Wed Feb 15, 2006 10:38 pm    Post subject: Very sorry. Reply with quote

Kolusu,

First of all, my apologies. I started to post only db2 related questions but somehow carried on with other questions as well.

I find the answers very useful.

Thanks a lot.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==
Back to top
View user's profile Send private message Send e-mail
mf_user
Intermediate


Joined: 01 Jun 2003
Posts: 372
Topics: 105

PostPosted: Wed Feb 15, 2006 10:49 pm    Post subject: Reply with quote

Kolusu,

Would you please move this topic to interview Q&A section.

Also, please tell me how do you quickly find the link with the search in the site?

For example, to find the link http://www.mvsforums.com/helpboards/viewtopic.php?p=7132#7132 how you would have searched the site before posting.

Please help me in understanding this.

I promise this won't be repeated.

Thanks.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==
Back to top
View user's profile Send private message Send e-mail
mf_user
Intermediate


Joined: 01 Jun 2003
Posts: 372
Topics: 105

PostPosted: Wed Feb 15, 2006 11:07 pm    Post subject: Reply with quote

Kolusu,

Basically a MAX column function is used on a column with numeric characters per my understanding. But, why anybody wants to use it on a column that is defined as character. Is it to get the largest string out of it?

Please clarify.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==
Back to top
View user's profile Send private message Send e-mail
CZerfas
Intermediate


Joined: 31 Jan 2003
Posts: 211
Topics: 8

PostPosted: Thu Feb 16, 2006 4:36 am    Post subject: Reply with quote

MAX is just an internal sort, using the bit representation of the literal. Therefore MAX will follow the collation sequence of your data.

regards
Christian
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12358
Topics: 75
Location: San Jose

PostPosted: Thu Feb 16, 2006 10:00 am    Post subject: Reply with quote

Quote:

Also, please tell me how do you quickly find the link with the search in the site?


Mf_user,

Simply narrow down your search to the subject. ex: you are dealing with a CICS question then simply search in the "CICS and Middleware" forum. In this case you are dealing with sequential file access in CICS. so search for "Sequential" and you will find the topic titled "Non-vsam files" and you will find the information you are looking for. Now if you want to link a specific topic in that post, then it is explained here.

http://www.mvsforums.com/helpboards/viewtopic.php?t=5091

Hope this helps...

Cheers

Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
mf_user
Intermediate


Joined: 01 Jun 2003
Posts: 372
Topics: 105

PostPosted: Fri Feb 17, 2006 12:59 am    Post subject: Reply with quote

Thanks Kolusu. So nice of you.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Interview Q & A All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group