Sql Db Issue

Hi all,
I am working in iFix to SQL. I have extended my table and SQL cmd but now I get this error: Error. SQL cmd %s is not terminated or too long. My SQL command is: Insert into LogDryer (Date_Time, DR_State, A_Res, B_Res, C_Res, A1_Temp, A2_Temp, A3_Temp, A4_Temp, A5_Temp,B1_Temp, B2_Temp, B3_Temp,C1_Temp, C2_Temp, C3_Temp, Cool_Temp, LE_Left, LE_Center, LE_Right, TE_Left, TE_Center, TE_Right, A1_Humid, A2_Humid, A3_Humid, A4_Humid, A5_Humid, B1_Humid, B2_Humid, B3_Humid, C1_Humid, C2_Humid, C3_Humid) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);

I have seen much larger tables and commands so this has me baffled.
Anyone a guru in SQL?
Thank you.

Where are you seeing this error? Is this in management studio?

It is probably the maximum length of the command 'string' is greater than allowable string data type of IFix (256 characters?)
Try splitting the SQL command into several seperate SQL Insert commands so that the command length is shorter

I dont use IFIX but try somthing like this

strString1 = "INSERT IGNORE INTO" and include a primary key
sql write instruction
strString2 = "UPDATE ???? WHERE " primary key=the primary key from the insert command
sql write instruction

The default number of characters for an SQL statement is 255. To increase it add the /CLx switch to WSQLODC in the task config section of the SCU (where x is the max number of characters allowed in the SQL statement e.g. /CL1000 )

Thank you all. The SCU had /CL5000. I increased it to 10000. Same error. Have yet to break up the cmd. I will give that a try next week. Even at 10000 I am getting the error. I have split the command and am logging to two different tables. I also created another table to work on getting all into one. At least for now data is logging. Marshy, I again thank you for pointing out the Alarm Window on the iFix Forum. That is one of the most useful tools I have seen yet.

And yes, I am seeing the error in both, Management Studio Error Library Table and iFix Alarm Window. The Error Library was created by us and may be a message by iFix.