WORK Target Table

[milts]

Hi,

I'm using DI 3.4 and I would like to generate the code for a job whose target table's libref is work. However I'm getting an error Invalid Metadata: No library specified. Would it not be possible to generate a code for a DI job whose target table is a work table? Thanks!

[LinusH]

Rare situation to have a Work target table...

Without investigating that, have you defined the Work-library in metadata?

No problem for me (DIS 4.5).

[milts]

You are correct it's kinda odd to see something like that. I haven't explored their whole process yet why they designed such.

There are no work-library declarations in the metadata. The target table's library is only set to the default which is <none> since the table should reside into the work path generated when the SAS session begins.

[LinusH]

Then you need to declare it in metadata. Just define it as pre-assigned, and then it will probably work.