IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

What is null indicator variable


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
karthi_ind

Active User


Joined: 24 Feb 2004
Posts: 131
Location: Chennai

PostPosted: Thu Jul 08, 2004 3:41 pm
Reply with quote

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.
Back to top
View user's profile Send private message
unna

New User


Joined: 15 Oct 2004
Posts: 17

PostPosted: Fri Oct 15, 2004 3:29 pm
Reply with quote

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,
Back to top
View user's profile Send private message
janardhana Reddy

New User


Joined: 20 Oct 2004
Posts: 17
Location: Bangalore

PostPosted: Wed Oct 20, 2004 4:35 pm
Reply with quote

For the fifth question the answer:

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

Thanks
Janardhan
Back to top
View user's profile Send private message
unna

New User


Joined: 15 Oct 2004
Posts: 17

PostPosted: Wed Oct 20, 2004 5:57 pm
Reply with quote

Hi,

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

Regards,
Back to top
View user's profile Send private message
janardhana Reddy

New User


Joined: 20 Oct 2004
Posts: 17
Location: Bangalore

PostPosted: Thu Oct 21, 2004 11:44 am
Reply with quote

Like operator will be performed on character data only.


select * from pr2.se_number where se_number_cd like '999%' ;
Back to top
View user's profile Send private message
janardhana Reddy

New User


Joined: 20 Oct 2004
Posts: 17
Location: Bangalore

PostPosted: Thu Oct 21, 2004 11:49 am
Reply with quote

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
Back to top
View user's profile Send private message
unna

New User


Joined: 15 Oct 2004
Posts: 17

PostPosted: Thu Oct 21, 2004 6:15 pm
Reply with quote

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,
Back to top
View user's profile Send private message
unna

New User


Joined: 15 Oct 2004
Posts: 17

PostPosted: Thu Oct 21, 2004 6:22 pm
Reply with quote

hi,

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

Regards,
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts Null values are considered in Total c... DFSORT/ICETOOL 6
No new posts Variable Output file name DFSORT/ICETOOL 8
No new posts Adding 'ODD' and 'EVEN' indicator at ... DFSORT/ICETOOL 6
No new posts Moving Or setting POINTER to another ... COBOL Programming 2
Search our Forums:

Back to Top