This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
When trying to create a new virtual field against a table, I've noticed that the Virtual Field type dropdown in the IDE is not always consistent.
We are trying to create a virtual date field that has a Date conversion Type but don't seem to get the option on some Tables.
I can't see any obvious difference between a table that shows all Virtual Field Types and one that only shows Code Fragment and Undefined.
How do we get from this
Virtual Field Type 2.png (6.82 KiB) Viewed 125720 times
To this
Virtual Field Type 1.png (8.61 KiB) Viewed 125720 times
I'm probably missing something obvious but I can't think what it is.
btw both these tables are RDMLX enabled.
My 1st question would be why would you not use the Date Field Format ? - Especially if you are using RDMLX tables.
But to answer your question...
What are the Field types of the Virtual Fields you are using? Our company used the same format you are trying to set up and we would use (S8,0) for both the real field and the virtual field. Are the field formats you are trying to use for the virtual field the same?
We have created the normal date field which is S8,0 and written as YYYYMMDD on the table (DCD2DC), but we would normally also create a virtual field to display the date as DDMMYYYY (DCD2CV). as below:
Date conv.png (9.19 KiB) Viewed 125699 times
Our issue is we can't seem to do this on certain tables and I'm not sure why?
I know there are other ways of doing this but it would be good to know why this isn't possible for certain tables.
I have tested in V15 EPC 150014, with rdmlx files, rdml files, other files in ibm as other files in window... cant reproduce that. In all cases I can create all kind of virtual fields.
what version/epc are you using?
I dont have any old S/36 flat files that use to be loaded as other files, but wondering is that could be the case...
Adding on to suggest checking that the field types are the same for both the real and virtual fields for doing a date conversion. We do almost the same thing at my company where the real field is a Packed(8,0) or Signed(8,0) field holding the date in YYYYMMDD format and the virtual is a Packed(6,0) or Signed(6,0) field, respectively, holding the date in MMDDYY format.
Theron Rossiter
Kawasaki Motors Manufacturing Corp., USA
