MVSFORUMS.com

whizkid79 · Beginner Joined: 29 Sep 2004 Posts: 53 Topics: 14

Hi,
I inserted # and ^ in a varchar field but they disappear while viewing it.
Can you please tell me why?

kolusu · Posted: Mon Nov 22, 2004 1:54 pm Post subject:

whizkid79,

what do you mean they disappear?

[code:1:c88962bdea]
INSERT INTO Table(column) VALUES('#
_________________
Kolusu
www.linkedin.com/in/kolusu

whizkid79 · Beginner Joined: 29 Sep 2004 Posts: 53 Topics: 14

Kolusu,

I'm inserting data in DB2 expert (file-aid). In edit mode once i enter # or ^ nad press enter, it disappears.

kolusu · Posted: Mon Nov 22, 2004 3:24 pm Post subject:

whizkid79,

May be inserted record is sorted on the key and may be in the next page? Why don't you select the row in spufi or qmf?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

whizkid79 · Beginner Joined: 29 Sep 2004 Posts: 53 Topics: 14

Kolusu,
If i insert a record with # or ^ and then select it, its coming. Its disappearing only when i'm using DB2 file-aid. Maybe its a limitation/property of this product.