MQSeries.net :: View topic

sachinramesh · Posted: Thu May 22, 2008 3:52 am Post subject:

Hi

I had problem when running my flow..

i have a tds message which is like this
My input is like this 1. no;name;area;country;
2.no;name;area;country;

But the value of "area" in the first record is 1,2,3,4,5;

in the next record it is 2,3,4,5;

in the code i am seperating the "area" value based on the Comma and storing it in the environment variable and inserting the data into the database.

But after debugging the flow i found that the first recordis inserted correctly
but when it comes to the next record i found that my variable gets replaced like this 2 with 1(in the first record)
3 with 2(in the first record)
4 with 3(in the first record)
5 with 4(in the first record)

But the 5 value is still remaining and is getting inserted into the database

This is my code for seperating the "area" value with the comma.

SET IN_I = 1;
WHILE ( CH_VIJETHA_AREA <> '' ) DO
-- find out the position of the separator in the 'AREA' field
SET IN_TEMP_POSTION_I = ( POSITION ( ',' IN CH_VIJETHA_AREA ) );
-- check if start of 'AREA' field
IF (IN_TEMP_POSTION_I <> '0') THEN
SET Environment.Variables.AREA_LIST[IN_I] = TRIM (SUBSTRING ( CH_VIJETHA_AREA FROM 1 FOR ( IN_TEMP_POSTION_I - 1 ) ) ) ;
SET CH_VIJETHA_AREA = SUBSTRING ( CH_VIJETHA_AREA FROM ( IN_TEMP_POSTION_I + 1 ) );
SET IN_I = IN_I + 1;
ELSE
SET Environment.Variables.AREA_LIST[IN_I] = TRIM ( CH_VIJETHA_AREA ) ;
SET CH_VIJETHA_AREA = '';
END IF;
END WHILE;
SET AREA_CARDINALITY = CARDINALITY(Environment.Variables.AREA_LIST[]);