mf979171
Beginner
Joined: 31 Aug 2007
Posts: 4
Topics: 2
|
 Posted: Sat Dec 22, 2007 1:33 pm Post subject: BIT Data type IBMSNAP_COMMITSEQ |
 |
|
Hi,
Requirement :
I have to create a report in which I want to use the below mentioned IBMSNAP_COMMITSEQ column value and based on the difference between last updated value and current updated value, retrieve the rows and produce a report.
Given :
I have a table which is having a column - IBMSNAP_COMMITSEQ. This is defined in the table as
IBMSNAP_COMMITSEQ CHAR(10) FOR BIT DATA NOT NULL
Question :
I tried to store the last updated value of IBMSNAP_COMMITSEQ of table in a file and next when trying to compare the value stored in the file and the current column value (in the table) the result is not produced (No rows selected). will PIC X(10) suffice the datatype need during the comparison? or need to do some conversion for BIT DATA ?
How can I compare a value in the file with the value in the table defined as 'FOR BIT DATA' ?
In short I think the file value stored as PIC x(10) doesnt get compared to FOR BIT DATA value of column in the table.
Thanks.
_________________
Thanks. |
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
