Hi community,
I tried to convert Cisco 7942 SCCP phone to SIP using SQL query. I already know about Migrate SCCP to SIP in bulk menu and I don't want to use it because we have a lot of device without all same configuration and we don't want to create Phone Template for each use cases (about 10000 phones).
SQL update request looks like following:
UPDATE device SET tkdeviceprotocol = (select enum from typedeviceprotocol where name = 'SIP'), fksipprofile = (select pkid from sipprofile where name = 'Standard SIP Profile'), fksecurityprofile = (select pkid from securityprofile where name ='Cisco 7942 - Standard SIP Non-Secure Profile') WHERE pkid = (select pkid from device where name = 'SEPAAAAAAAAAAAA')
when I type this request, I have the following SQL code errors: 418.
I search on Informix documentation (https://www.ibm.com/docs/en/informix-servers/12.10?topic=informix-error-messages) and I read following:
-418 NULL SQLDA descriptor or host variable list encountered.
Review the way the program constructs the sqlda and related data
structures; somehow it is setting up a null pointer. If the program is
in IBM Informix 4GL or another language in which the sqlda is not
constructed directly by the program, or if this statement only refers
to host variables by name, this error should not occur. If the error
recurs, note all circumstances and contact IBM Informix Techical Support.
Do you have any idea ? Many thanks.
Mikael
