Problem with proc metalib

[thomash123]

Dear all,

I am facing issues with updating metadata via DI Studio 4.21 M3.

When selecting the corresponding option for a DB2 table the log says:

[...]

proc metalib;

omr (libid="A900000F" repid="A5XBOHFR");
report(type = summary);
update_rule = (noadd);

select (A5XBOHFR.AB0000QY);

run;

SYMBOLGEN: Macro variable DMDATASRC resolves to acpme
SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing.
ERROR: CLI error trying to establish connection: [IBM][CLI Driver] SQL30082N Security processing failed with reason "24"
("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001

[...]

The DB2 connection works fine in all jobs with the same user. SELECT rights are granted.

It seems the statement does not use the correct credentials. The DB2 lib is preassigned.

Any idea on this one?

Thanks,
Thomas

[Tim_SAS]

This isn't the best forum for your question. Try posting your question in the SAS Enterprise Data Management & Integration forum.

Good luck!