IBM Mainframe Forum

Posted: **Wed May 08, 2013 12:16 am**

Hi,
Please help me solve my problem.
This is my code and as shown, I want to fetch the balance corresponding to a particular id and update it.

Select all

select balance in :h1-bal
from tblname
where id = :h1-id

compute h1-bal = h1-bal + 10.50

The problem is that my h1-bal is declared in dclgen as follows

Select all

h1-bal pics9(2)v9(2) usage is comp-3.

Now, when I try to access the value fetched from the table, it is shown as .........

What should i do?

Posted: **Wed May 08, 2013 12:22 am**

read the db2 manuals about the correspondence between the DB2/SQL data types and the corresponding COBOL types

Posted: **Wed May 08, 2013 12:49 am**

Actually i tired doing that by declaring the host variable as s9(2)v9(2) usage comp-3. But still it displays '......'

Posted: **Wed May 08, 2013 12:54 am**

pearl wrote:Now, when I try to access the value fetched from the table, it is shown as .........

What should i do?

Give us the definition of the column.
Display the data in hexadecimal; post this enclosed in Code tags.

Posted: **Wed May 08, 2013 1:02 am**

Akatsukami wrote:
pearl wrote:Now, when I try to access the value fetched from the table, it is shown as .........

What should i do?

Give us the definition of the column.
Display the data in hexadecimal; post this enclosed in Code tags.

In table, column drefined as

Select all

balance decimal(4,2) not null

In dclgen

Select all

h1-balance pic s9(2)v9(2) usage is comp-3

I want to get the actual value from the table and do calculations on it. But, since its comp-3 the value taken is '.........'
How do I get the value from the table into a host variable using a select query.?

Posted: **Wed May 08, 2013 1:19 am**

pearl wrote:
Akatsukami wrote:
pearl wrote:Now, when I try to access the value fetched from the table, it is shown as .........

What should i do?

Give us the definition of the column.
Display the data in hexadecimal; post this enclosed in Code tags.

In table, column drefined as
Select all
balance decimal(4,2) not null

In dclgen
Select all
h1-balance pic s9(2)v9(2) usage is comp-3

I want to get the actual value from the table and do calculations on it. But, since its comp-3 the value taken is '.........'
How do I get the value from the table into a host variable using a select query.?

Pearl-chan, you're worse than my cat when it comes to following instructions. I asked you to display the data in hexadecimal and post that here in Code tags. I will now tell you that solving your problem requires it.

Posted: **Wed May 08, 2013 5:47 pm**

Nothing to do with CICS but all to do with DB2 and whatever language you are using. Moved to DB2 rather than being deleted.

Posted: **Thu May 09, 2013 12:02 am**

Hello,

If you want to be able to "see" the value, you need to show it in HEX or DISPLAY it individually in the code

IBM Mainframe Forum

fetch problem with host variable

fetch problem with host variable

Re: fetch problem with host variable

Re: fetch problem with host variable

Re: fetch problem with host variable

Re: fetch problem with host variable

Re: fetch problem with host variable

Re: fetch problem with host variable

Re: fetch problem with host variable