Custome code in VDB

[arpan_ghosh]

Hi,

After unlocking the code and saving it, the columns in the output table are removed from metadata.

After saving the data query containing the custom code, the columns of the output table present in the query is removed.

But in need to run this data query on periodic basis

Let me know if I am missing something? Any suggestions

Cheers

Arpan

[Madelyn_SAS]

When you unlock the code, the Design and Results tabs are removed from the interface, and you must continue to maintain the query via code.  Is this the behavior that you are referring to?

[arpan_ghosh]

Hi,

After unlocking the code the design and Results tab are removed but when I save the query after editing the manual code the columns in the output table are removed from metadata.

But in need to run this data query on periodic basis and need to have the results in an output table.

How do I achieve that as my output table does not have any columns once I save the custom data query.

can we not save the output of custom code results (done in the code tab) in the output table?

Regards

Arpan

[Lorrie_SAS]

Hi Arpan,

From your problem description, it sounds like you might have saved the query after unlocking editing on the Code tab. Try saving the data query before you unlock manual editing.

There are several steps to take before unlocking manual editing. You can find more information about them in the User's Guide here:

http://support.sas.com/documentation/cdl/en/vaug/67500/HTML/default/viewer.htm#n0xlm7xwg2dyern1ph1mh...

Please let me know if this helps.

Best regards,

Lorrie