How to insert Dec fixed(9,0) value in the select query.

rajesh_manas · New User Joined: 30 Mar 2006 Posts: 11

Dear All,

The query is as below,

SELECT CUSTOMER_NR,
(0),
NAME

From CUST table;

I want to write the above query result to a following structure

DCL 1 CUST,
5 Customer_nr char(10),
5 Reserve1 Dec fixed(9,0), (Always it should be filled with zero)
5 Name Char(25);

I need alwasy Zero in the place of Reserve1 out of query.

Please let me know how we can Hard code value '0' in the query.

Regards,
Rajesh

DavidatK · Posted: Thu Jan 18, 2007 7:48 pm

Rajesh,

What you have is 99% correct. Just remove the ?(?,?)?

SELECT
CUSTOMER_NR,
0,
NAME
From CUST table

rajesh_manas · New User Joined: 30 Mar 2006 Posts: 11

But the problem is this zero value has to be stored in Decimal(9,0),

I mean it has to be stored in 5 Bytes variable while moving the data from file to program Interal structure....

Please let me know , How to hard code zero value which has to take 5 bytes.

Regards,
rajesh

William Thompson · Posted: Thu Jan 18, 2007 8:31 pm

Don't you select into host variables? That would be where you set the size....

rajesh_manas · New User Joined: 30 Mar 2006 Posts: 11

Sorry, I dont have an idea on declaring the Host variables in the select query.....Can you please let me know the syntax.

Regards,
Rajesh

William Thompson · Posted: Thu Jan 18, 2007 8:40 pm

What is this?

rajesh_manas · New User Joined: 30 Mar 2006 Posts: 11

That is the internal structure in my program, Where the Query output file will be moved.

William Thompson · Posted: Thu Jan 18, 2007 8:51 pm

Those are your host variables....Don't you "select column-name into data-name"?

UmeySan · Posted: Thu Jan 18, 2007 9:53 pm

Hi !

DCL ... are you programming in PL/I ???

Regards, UmeySan