PM50734: USING SQL SERVER "GETDATE()" FUNCTION ERROR - UDA-SQL-0219 LOCAL PROCESSING BEING USED

APAR status

• Closed as suggestion for future release.

Error description

• Happens inside of Framework manager??If you try and use the SQL
  server specific function getDate() inside of a new query
  item/calculation, you get an error saying local processing is
  required. Occurs even if the datasource it is accessing is set
  to "database only" processing.??Trying to do the above results
  in the following error message:?RQP-DEF-0177 An error occurred
  while performing operation 'sqlPrepareWithOptions'
  status='-126'.?UDA-SQL-0219 The function "getdate" is being used
  for local processing but is not available as a built-in
  function, or at least one of its parameters is not supported.??
  

Local fix

• Use common functions inside of FM, such as current_date instead
  of SQL server specific functions
  

Problem summary

Problem conclusion

Temporary fix

Comments

• No additional comments.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels