What is the COBOL picture clause of the following DB2 data types: DATE, T

Login | Sign Up


	Ask Questions on ANYTHING, that arise in your Daily Life at FORUM9.COM

Categories >> Software >> MainFrame >> IBM MainFrame >> DB2

Question

What is the COBOL picture clause of the following DB2 data 
types: DATE, TIME, TIMESTAMP?

Question Submitted By :: Guest

Rank

Answer Posted By

Re: What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?

Answer
# 1

date          pic x(10)
time          pic x(08)
timestamp     pic x(26)

Is This Answer Correct ?

6 Yes

1 No

Islam

Re: What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?

Answer
# 2

DATE      PIC X(10)
TIME      PIC X(8)
TIMESTAMP PIC X(26)

Is This Answer Correct ?

0 Yes

0 No

Kalyani

Question	Asked @	Answers
Other DB2 Interview Questions


What is a clustering index?		2
What is dynamic SQL?		1
Explain an outer join?		1
How many clustering indexes can be defined for a table?		1
What is a composite index and how does it differ from a multiple index?		1
What is an alias?		2
What is CHECK PENDING ?		2
What is a LIKE table and how is it created?		1
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?		1
What is the picture clause of the null indicator variable?		4
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?	Perot-Systems	5
How do you Load a table ?? and what is Load replace ?	Xansa	2
when does the SQL statement gets executed when you use cursor in the application programming ?		3
What is COPY PENDING status?		4
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?		1
Why might full image copies be faster to implement than an incremental image copy?		1
Can we install 2 different versions of Db2 on same mainframe?		2
Where are plans stored?		2
What is the error code -803 ?		2
Give the COBOL definition of a VARCHAR field.		1

For more DB2 Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com