Inserting a row in a table with low-values using QMF/SPUFI

kalyanp_80 · New User Joined: 03 Feb 2006 Posts: 41 Location: Hyderabad

Hi,

I have a requirement which I am detailing out below:

I have an embeded SQL in COBOL program which is trying to delete a record from DB2 table. SQL looks like this:

EXEC SQL
DELETE
FROM UES_LOCK_TBL
WHERE
PERSON_ID = :WS-PERSON-ID
END-EXEC.

In Host-Variable WS-PERSON-ID, I am moving low-values.

To do Unit Testing, I want to insert a record with low-values using QMF. But I am not able to find how to insert a row in a table with low values/high values. Please guide.

Thanks
Amith Patalay

Suryanarayana.tadala · New User Joined: 03 Nov 2005 Posts: 43 Location: St.Louis

Could you tell the declaration of the variable WS-PERSON-ID ??

hikaps14 · Active User Joined: 02 Sep 2005 Posts: 189 Location: Noida

Hi,

some time back I also had the same requirement.
so what I exactly did was moving literal low-values to the field.

I made a constant variable and gave low-values in it 'value' verb.
and then moved this variable to the host variable.

I hope it works, If there is a better way plz tell me also.

Thanks,
-Kapil.

rajeshps19 · New User Joined: 14 Feb 2007 Posts: 4 Location: Noida

Hi Kalyan,

Try this:

While inserting use the HEXAdecimal format of the low-values.

For example if Column3 in table1 is of 3 characters and you want to insert low-values in this table then

INSERT INTO table1
(Column1,
Column2,
Column3)
VALUES
(value1,
value2,
X'000000')

This will insert low-values in Column3 in three places.

Hope this helps.

Thanks,