Integer datatype with length > 10

[Former Member]

Hello,

The issue I presently face is that in one of the database tables contains an integer field of type INT4 (length 10). The data coming into this field has integer values > 10. Due to this the data stored in the table is corrupt with incorrect delimiters.

When a SELECT is performed, the dump DBIF_RSQL_SQL_ERROR

is faced.

With analysis, it is found that :

"To be more exact, ORA-01455 means that in the context of a SELECT

statement, you try to transfer the content of a column to an integer

variable whereupon the content of the column disrupts the integer number

area."

Apart from changing the datatype to a one that contains length > 10, is there any other way to address this issue.

Regards

Anupama

[Former Member]

Hello,

The issue I presently face is that in one of the database tables contains an integer field of type INT4 (length 10). The data coming into this field has integer values > 10. Due to this the data stored in the table is corrupt with incorrect delimiters.

When a SELECT is performed, the dump DBIF_RSQL_SQL_ERROR

is faced.

With analysis, it is found that :

"To be more exact, ORA-01455 means that in the context of a SELECT

statement, you try to transfer the content of a column to an integer

variable whereupon the content of the column disrupts the integer number

area."

Apart from changing the datatype to a one that contains length > 10, is there any other way to address this issue.

Regards

Anupama

[Former Member]

u can use diffrent data type for that like type n.

this is what SAP Help says about the Integer Data types..

INT1: 1-byte integer between 0 and 255. The length is set to 3 places for this data type.

INT2: 2-byte integer between -32767 and 32767. Fields of this type should only be used for length fields. These long fields are positioned immediately in front of a long field (type LCHR, LRAW). With INSERT or UPDATE on the long field, the database interface enters the length which was actually used in the length field. The length is set to 5 places for this data type.

INT4: 4-byte integer between -2147483647 bis 2147483647. The length is set to 10 places for this data type.

[anversha_s]

hi,

a sugestion.

can u declare the type as

CHAR or N

and try.

Rgds

Anver

[Former Member]

Hi Anupama,

you may try using packed data type, or type n with length = 16 or more than that..

[Former Member]

hi lal,

U better create ur own domain instea of default int4 so that u can set the length u want..do try it.. in this case u don need to change data type..

regards ,

Rajkumar.G.

[Former Member]

Hi Anu,

Instaed of changing type create a domain of type char of 20 and then u can assign this to dataelement corresponing to the field.

with regards

prince elvis.

[Former Member]

Hello Elvis,

Thanks for the reply.

I have a situation wherein I am SELECTING data from a DB table to a integer.

Niether the datatype of the database column niether the integer support a integer value with length > 10.

If I declare the Local variable in the program as type 'P' it is catering to my requirement, but what would be the corresponding data type for the database domain in the 46C2 release.

Regards

Anupama

[Former Member]

Hi Anupama,

Probably the data coming from char to integer. So better to convert char to integer you problem might solve.

Another solution is make database domain and defined variable should have same domain.

Regards

Bhupal Reddy

[Former Member]

aa