mainframegurukul.com

Hi,

How to browse a TDQ.

Is it possible to take DB2 application programmer certification without
taking family fundamentals test.

What is hex equivalent for a NULL value.
I think there won't be any hex equivalent for NULL,correct me if iam wrong.

Suppose if a want directly edit a DB2 table in which
value of a NULLABLE field should be made as NULL.Is there is anyway to
do it.

When using sort to remove the duplicate records, i.e. PGM=SORT with a SYSIN containing a SORT statement and SUM FIELDS=NONE, which record will be kept?

Suppose if i have 20 records with the same key which record do you think that will be written into output. Is it first or something????

What is 2 phase commit??

Reddy, Thanx for information , i know that the results will be put in a PLAN_TABLE. When you select * from PLAN_TABLE depending on which column will u able to decide the query is ok. One thing is depending on index usage. Second there are two cost columns PROCMS and PROCSU. Do you know the maximum p...

Exactly.

There is explicit connection to a queue manager in batch application program and there is nothing as such in CICS application program .

I want to know how CICS will handle this automatic connection to a default queue manager.

Hi,

Why a connection to a Queue manager is not needed for CICS program where as it is mandatory for a batch program.

Can anyone explain how to analyse the performance of a DB2 query
using EXPLAIN (ENDEVOR tool).

Select (colums whichever you want)
INTO(.......)
FROM table name A
WHERE A.name LIKE '_C%'

Thanks Kali for u r reply. Let me provide some more details ,if nothing is selected it is returning NULL values. Thats fine. Suppose my length is say 40(as per JCL). If it returns NULL value the file length is automatically changed to 41 which i don't want . Because whatever SQL iam using is Unload ...

I don't think the double quote inside the last literal will be a cause for u r compile error. I have tried with double quote and it is working fine. What might be the cause iam thinking is that if you want continue a literal in next line there should be '-' in the indent column(7th column) and you m...

Hi,

Can you please tell me where i can find the sample test papers for
DB2 700 certification.

Regards,
Vinod Reddy.

Hi, Suppose if i have a CASE statement in my select, is it mandatory to use Else statement for the CASE. Suppose i have a select statement as follows. Select CASE WHEN B.SPG = '01' THEN C.PROM_SELL_PRICE_11 WHEN B.SPG = '02' THEN C.PROM_SELL_PRICE_12 WHEN B.SPG = '03' THEN C.PROM_SELL_PRICE_13 WHEN ...

Hello,

Could you just tell me is there is any other operating system that
supports mainframes other than OS/2,OS/390 and the latest Z series.

Could you please distinguish between the above mentioned operating
systems.

What is the concept of MVS.