An error might occur when you use the PUT or SAS_PUT functions with SAS/ACCESS® Interface to Netezza


The following error might occur when you attempt to use the SAS_PUT function to process formats in the Netezza database:

ERROR: CLI execute error: ERROR: Function 'SAS_PUT(VARCHAR, UNKNOWN)' does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts
 

The problem occurs because the formats have not been published to the Netezza database. An error is not generated by the %indnz_publish_formats macro if the user does not have unfenced permissions to publish the formats to the database. Once the appropriate permissions have been granted, the %indnz_publish_formats macro need to be run again.