DATA Step, Macro, Functions and more

Problem with proc metalib

Reply
Contributor
Posts: 38

Problem with proc metalib

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
Super Contributor
Posts: 394

Re: Problem with proc metalib

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

Good luck!
Ask a Question
Discussion stats
  • 1 reply
  • 161 views
  • 0 likes
  • 2 in conversation