how to retrieve spaces from table?

sandeep4u · New User Joined: 12 Aug 2005 Posts: 32

I have a table in which col1 is defined as comp-3. Now i want to retrieve the data from that column whose value is spaces. How I should proceed

Particularly in File-aid...... plz guide me.

Thx in advance.

sandy

DavidatK · Posted: Wed Feb 22, 2006 11:49 pm

sandeep4u,

This is a DB2 table?

You say it?s defined as a COMP-3, This means that for DB2 it?s defined as decimal.

If so, I don?t believe DB2 will allow you to put spaces in a decimal column.

Dave,

bonniem · New User Joined: 09 Aug 2005 Posts: 67

Sandeep,

do you mean NULL? then you can have an sql like

select * from <table-name>
where <col1> is null.

sonu_winks · New User Joined: 23 Nov 2005 Posts: 23

if the cobol deln of the corresponding column is comp-3 it should be decimal in DB2 and the value u want to retieve must be NULL , not spaces.

sandeep4u · New User Joined: 12 Aug 2005 Posts: 32

Hi,

Sorry for I have specified wrong info.. Thx for giving me reply.

.........actually the column is defined as alphanumeric i.e. varchar2 in DB2 but in cobol the ws-parameter is COMP-3.
Now i am retrieving the data from table and storing it in the variable.
In File-aid i am trying to retrive the table value not equal to spaces..but i am not able to retrive it. I am specifying the condition against the col in file-aid but it is giving me "NO Records Selected", but there are records in the table.........

Please help me out........ sorry for inconvenience.....

Thx in advance........

sandy