IBM Mainframe Forum

Hi,
I need help please.

I have a DB2 table that has a index. That index has 3 columns. One of thoses columns is numeric and I need to transform it to character.

Current index:


New index:


The documentation I have says to avoid to changing numeric ---> character because that causes many problems, but it doesn't say which ones....
Instead, it says to add 1 new colum at the end of the table but, that is not possible because the ColumnB is part of the key of the table.

Could anyone tell me what should I do ?
Thanks in advance!

I can't say what you should do, but what you should have done is to think about your design before you started.

And changing data that is intrinsically numerical to character? PMAB!

I did not design that table.

It is strange to change numeric to character, but I need it. The values are numerics in the columnB.
The problem is my ERP that uses DB2 tables. When ColumnB est populated with spaces, it transforms automatically the spaces to zeros because ColumnB is defined as numerique. That causes a problem because I need to verify the ColumnB must be not empty.

It is for that I need to alter the ColumnB.

Thanks

vegafacundodaniel wrote:The problem is my ERP that uses DB2 tables. When ColumnB est populated with spaces, it transforms automatically the spaces to zeros because ColumnB is defined as numerique. That causes a problem because I need to verify the ColumnB must be not empty

Ever heard of "NULL"?

These users thanked the author prino for the post:

sikkandhar (Wed Feb 17, 2016 2:51 am)

WHen I want to check if columnB is empty (spaces) ou null (nothing), that column contains zeros, populated by the ERP. The ERP is a closed source that I can't not modify.
Thanks

that column contains zeros, populated by the ERP. The ERP is a closed source that I can't not modify.

how do You know that after changing the column the ERP application will still work ???

After changing the columnB, I need to adapte the customer procedures impacted (=programs).

The ERP is a closed source

just take a decision ...

the ERP/application/whateverYouwantto callthething

is it closed source or not ???

The ERP is a semi closed source. It makes somes things that I can't not control, for example, it makes zeros instead of spaces when a column is numeric.
Thanks

Question please. If I:

- UNLOAD the old table (definition and data) with IKJEFT01 program. It makes 2 files (*)
- DROP old table (Tablespace, table, index..) with columnB as numeric
- CREATE new table with columnB as CHAR
- LOAD data with (*) using DSNUPROC program.
Question: the data from the old ColumnB (DECIMAL 2) populates the new columnB (CHAR 2) properly?

Thanks