Problem with proc metalib

thomash123 — Mon, 18 Apr 2011 13:02:57 GMT

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

Re: Problem with proc metalib

Tim_SAS — Mon, 18 Apr 2011 13:22:25 GMT

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

Good luck!

topic Problem with proc metalib in SAS Programming

Problem with proc metalib

Re: Problem with proc metalib