What causes error 'DQ836E - YOUR PICTURE OR HEADING CLAUSE IS MISPLACED' ?

book

Article ID: 36546

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server

Issue/Introduction

Problem: 

I am using the following valid syntax but  getting error DQ836E, why is this error occurring?

ORDER-ENT-DT 'ORDER DATE' PICTURE '99/99/99'

DQ836E - YOUR PICTURE OR HEADING CLAUSE IS MISPLACED 

 

Cause: 

The error can occur when a PICTURE clause is specified on a character field, it can only be used on numeric fields. 

In this case the date field is defined as character not numeric.

 

Resolution:

Either remove the PICTURE clause for the field defined as character or redefine the field as numeric.

 

Environment

Release: DATABB00200-14-Datacom/AD
Component: