kalpanapai
IS-IT--Management
Hi
I have to pick up 14 fields data ,concatenate and load them into another table.
The main table had 4 fields which are of type VARCHAR(255) and rest 10 fields are of type lvarchar.
Another table has 2 columns one is of type integer and another one is CHAR(10000).
I have written a stored procedure which takes 1 parameter (ex id) picks the data and calls another procedure no of times by passing each field and returns the data without spaces. Finally it concatenates all the data and inserts into to another table.
This workd fine on test box which is also solaris with informix U9.2 version. But on production machine some of the records fails to insert the data into CHAR filed , bcoz as soon as it encounters null value it stops .
Any help would appreciated as i am with this pblm unable to understand the same code works on one m/c not on another for few records.
Thanks heaps !!!!!!!
I have to pick up 14 fields data ,concatenate and load them into another table.
The main table had 4 fields which are of type VARCHAR(255) and rest 10 fields are of type lvarchar.
Another table has 2 columns one is of type integer and another one is CHAR(10000).
I have written a stored procedure which takes 1 parameter (ex id) picks the data and calls another procedure no of times by passing each field and returns the data without spaces. Finally it concatenates all the data and inserts into to another table.
This workd fine on test box which is also solaris with informix U9.2 version. But on production machine some of the records fails to insert the data into CHAR filed , bcoz as soon as it encounters null value it stops .
Any help would appreciated as i am with this pblm unable to understand the same code works on one m/c not on another for few records.
Thanks heaps !!!!!!!