Moving Signed value to Alpbha-numeric field.

Gnanas N · Posted: Mon Nov 19, 2007 4:18 pm

Hi all,

I have a field like below.

WS-ITR PIC S9(04).

But in DB2 table, the corresponding column data type is VARCHAR(04).

So I have to move it to Alpha-numeric field say X(04). And X(04) is enough or not?

Or X(05) is needed to retain sign?

Consider the value for WS-ITR is -2009. So, in this case, is it possible to have sign stored in database?

Note : I think S9(04) will take only 4 bytes in memory. Correct me if I am wrong.

Thanks,
Gnanas

Craq Giegerich · Posted: Mon Nov 19, 2007 6:25 pm

Gnanas N · Posted: Mon Nov 19, 2007 7:04 pm

Craq Giegerich says

dbzTHEdinosauer · Posted: Mon Nov 19, 2007 7:30 pm

pic s9(4) will indeed only use 4 bytes since the sign is an overprint. that is what craig meant by garbage. (e.g. -234 WB 023M) now, how could you find that?

but as craig said, if you have numeric data, store it as numeric data; to do otherwise is just rookie behavior.

dick scherrer · Posted: Mon Nov 19, 2007 10:54 pm

Hello,

Hopefully, this signed, zoned-decimal number will not be used as a key. . .

balbudheprashant · New User Joined: 24 Aug 2007 Posts: 5 Location: Pune

[quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code][list][list=][img][/img][url][b][i][u][quote][code]

Quote:

[code]

[list=][img][/img][url][/url][/code]

Gnanas N · Posted: Tue Nov 20, 2007 3:07 pm

Prashant ,

What is this? I don't understand.

dbzTHEdinosauer · Posted: Tue Nov 20, 2007 3:52 pm

Why in the world are you using a varchar for 4 bytes? considering that you will always have a length for two bytes you are creating a 6 byte column, of which 4 bytes are available for data and you are trying to stuff 5 descret characters into it.

although s9(4) only takes up 4 bytes, you need five bytes to make any sense out of it (to show the sign).

suggest the varchar(04) column be dropped and a either a char(5) or smallint column be added.

if you just have to go with the char col, suggest you move the host variable s9(4) to an edit mask, then update the column with the edit mask.