Search found 15 matches

by 156138
Tue Dec 19, 2006 7:30 pm
Forum: CICS
Topic: TDQ
Replies: 1
Views: 4481

TDQ

Hi,

How to browse a TDQ.
by 156138
Thu Dec 07, 2006 4:19 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Reg : DB2 certifications
Replies: 1
Views: 4243

Reg : DB2 certifications

Is it possible to take DB2 application programmer certification without
taking family fundamentals test.
by 156138
Mon Dec 04, 2006 6:55 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: NULL value
Replies: 2
Views: 7618

NULL value

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.
by 156138
Tue Nov 28, 2006 10:00 pm
Forum: JCL
Topic: SORT
Replies: 2
Views: 6929

SORT

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????
by 156138
Fri Nov 24, 2006 8:25 pm
Forum: CICS
Topic: 2 Phase commit
Replies: 3
Views: 8340

2 Phase commit

What is 2 phase commit??
by 156138
Wed Nov 15, 2006 12:43 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Reg:Performance of a DB2 query
Replies: 3
Views: 7233

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...
by 156138
Thu Nov 09, 2006 3:36 pm
Forum: CICS
Topic: Reg : MQ series
Replies: 2
Views: 3800

Reg : MQseries

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.
by 156138
Tue Nov 07, 2006 2:45 pm
Forum: CICS
Topic: Reg : MQ series
Replies: 2
Views: 3800

Reg : MQ series

Hi,

Why a connection to a Queue manager is not needed for CICS program where as it is mandatory for a batch program.
by 156138
Fri Sep 15, 2006 4:07 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Reg:Performance of a DB2 query
Replies: 3
Views: 7233

Reg:Performance of a DB2 query

Can anyone explain how to analyse the performance of a DB2 query
using EXPLAIN (ENDEVOR tool).
by 156138
Fri Sep 15, 2006 12:19 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 query !!
Replies: 6
Views: 21650

Db2 query

Select (colums whichever you want)
INTO(.......)
FROM table name A
WHERE A.name LIKE '_C%'
by 156138
Fri Sep 08, 2006 12:41 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Reg: CASE usage in DB2
Replies: 2
Views: 7269

Reg: CASE usage in DB2

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 ...
by 156138
Fri Sep 01, 2006 1:42 pm
Forum: COBOL
Topic: Reg variable declaration
Replies: 6
Views: 10267

Reg: variable declaration

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...
by 156138
Wed Aug 30, 2006 12:40 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Reg : DB2 700 certification
Replies: 1
Views: 5782

Reg : DB2 700 certification

Hi,

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

Regards,
Vinod Reddy.
by 156138
Wed Aug 30, 2006 10:44 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Reg: CASE usage in DB2
Replies: 2
Views: 7269

Reg: CASE usage in DB2

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 ...
by 156138
Tue Aug 29, 2006 7:32 pm
Forum: JCL
Topic: Reg: Different operating systems in mainframes
Replies: 2
Views: 11461

Reg: Different operating systems in mainframes

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.