message mapping error in update

[Former Member]

I have a database scenario. I am picking data from sender database. We have a Flag field in table with value blank

I made the select statement like this

Seect x,y,z from TableName where Flag = ""

I get the error in sender adapter com channel monitoring.

Can we have blank value in the databse table for Flag?

Can PI handle files above 25 mb size

[Former Member · Accepted solution]

Hi Midhun,

If the Flag field is STRING type, then try with the Select statement as:

SELECT X, Y,Z FROM TABLENAME WHERE FLAG IS NULL

Yes PI can handle files above 25 MB, but this is dependent on the hardware sizing of your PI system.

I encourage you to post different discussions for different questions.

Regards,

Alka.

[Former Member · Accepted solution]

I gave Flag = "Null" and Flag = Null.

Each time I got an error incorrect syntax

Update statement is <TEST>

[Former Member · Accepted solution]

I gave Flag is Nul and it is working

what should I give in UPDATE

[former_member191435 · Accepted solution]

if you want to update the table then provide the update query...

Otherwise just use <TEST>

Thanks,

Sreenivas

[Former Member · Accepted solution]

Hi Midhun,

Use update statement in your sender communication channel

UPDATE table SET flag = 1 WHERE flag = 0;

by the above statement you put your desired flag values.

Regards,

Suhale Shaik.

[Former Member · Accepted solution]

Hello,

As I have explained in another of your discussion threads,

Considering that the interface you have designed will be implemented in a live scenario and will keep on executing at the pre-defined polling intervals,

the SELECT statement is to select the records from the table which are required to be picked after the last polling interval and the UPDATE statement is for marking these records as processed.

Hence, your UPDATE statement should be

UPDATE Tablename SET FLAG = "SOME VALUE" WHERE FLAG IS NULL

Regards,

Alka.

[iaki_vila]

Hi Midhun,

Please share the exact exception that you are getting. You can use a blank flag and I've seen a PI handles 50/60 Mb messages without problem, all depends about your PI size and configuration.

Have you set the UPDATE sentence?

Regards.