What is null indicator variable

karthi_ind · Posted: Thu Jul 08, 2004 3:41 pm

hi

1) whatz null indicator variable?

2) whatz use of db2 utilities? (real time)

such as load, quisce, copy, check data

3) if not null with default is specified during an 'alter' command what will be the default values of date, time, timestamp ?

4) whatz timestamp mismatch error (-818) ?

5) can we use db2's 'like' operator for numeric values? or the operator is meant only for alphabetiv values?

can i give select * from acc-table where acc-no like '989%'

anbudan
karthi G.

unna · New User Joined: 15 Oct 2004 Posts: 17

Hi Karthi,
I have some answers for your few questions.

1. Null Indicator:
used by DB2 to specify whether a column contains null or not null values. if the value of Null indicator is 0 then NOT NULL.
If -1 then Null and -2 Truncated.

If u need some more informations i can provide.

4. -818 - The Precompiler generated timestamp X in the load module is different from bind Time stamp Y in DBRM. Recompile it again to solve the problem.

5. Like operators can only be used for Alphabets I suppose.
eg:

1. select * from emp
where empname LIKE 'A%'

It will take the names of the employees starting with alphabet A .

2. Select * from emp
where empname LIKE '-AM%'

It will take the only employee names having 2nd and 3rd letter as AM .

Thanks,

janardhana Reddy · New User Joined: 20 Oct 2004 Posts: 17 Location: Bangalore

For the fifth question the answer:

Yes, we can use numaric value in the like operator.

Thanks
Janardhan

unna · New User Joined: 15 Oct 2004 Posts: 17

Hi,

Can u quote some examples where in Numeric values are used in Like operator?

Regards,

janardhana Reddy · New User Joined: 20 Oct 2004 Posts: 17 Location: Bangalore

Like operator will be performed on character data only.

select * from pr2.se_number where se_number_cd like '999%' ;

janardhana Reddy · New User Joined: 20 Oct 2004 Posts: 17 Location: Bangalore

Unna,

karthi's question is is it possible to use numaric values in the LIKE operator. He had give example select * from acc-table where acc-no like '989%' .. He is asking that above query is correct or not.

Have provided clear information

unna · New User Joined: 15 Oct 2004 Posts: 17

Hi,

[quote]

can we use db2's 'like' operator for numeric values? or the operator is meant only for alphabetiv values?

The answer is only Alphabetic values.
for that i have given some examples.
which implies the example given by karthik goes not hold good.

Regards,

unna · New User Joined: 15 Oct 2004 Posts: 17

hi,

I think iam on the right track from my first post to this Query onwards.
Anyhow, Thank you for ur reply.

Regards,