Problem with codes in MQ SQL Database - different codes become the same ... ?!

[ivan_will]

Hi all,

I have problems with codes in MQ SQL database.

The problem is that in the DB there is Document Codes like: 01 ; 001  ; 0000000001

When I reload all the lines all of the above codes become like 0000000001 and there is dublication in my data!

When I use where func by customer number it shows 01 but when make with two client names the codes become 001 (fist dos is 01 and the second 001)

Ideas?????

[#2 · Accepted solution]

Hello Ivan.

I had the same problem.

Try to force the format in string... like this:

[TABLE_ALIAS]:

Load Text(Document_Code) as Document_Code_Formated, *; //This load command will load data from the SQL command bellow, forcing the Document_Code to be in a string format

SQL Select * From SQL_Table;

That will do (perharps hahaha)

Regards,

Bruno