Hi, I am trying to load UTF8 data using SAS Bulk Loader and have following questions: 1. SAS Oracle Bulk Loader uses SQLLDR to bulk load data into Oracle. Is there a way to load UTF8 data with the bulk loader? 2. For loading UTF8 data using SQLLDR, there is an SQLLDR option 'CHARACTERSET UTF8', but does somebody knows how to pass this parameter using SAS Bulk Loader Option? passing it in BL_OPTIONS does not works and generates error ... View more

Hi Is there a way get the current connected user in a SAS EG Custom Addin? For example - If user 'xyz' launches an SAS EG session and starts a custom addin task, so is there a way to determine the name of the user who launced the SAS EG session. I know, I could run a piece of SAS code to get the username by reading results of underlying OS system command, but was wondering whether SAS EG Addin libraries provided some way. Thanks Vinay ... View more

Hi How do I retrieve options specified on a library while allocating it programatically in SAS 9.1.3? Suppose, I have following statement: libname mylib '/path/to/mylib' compress=yes; So, How do I know that the libref 'mylib' defined above is a compressed library? I could not find any relevant dictionary table which holds this information.... Also, if I run following statement, it prints the info in SAS log, making me think that SAS does hold the information somewhere: libname mylib list; Following are few initial lines of log(which prints compress value): NOTE: Libref=   MYLIB       Scope=    IOM ROOT COMP ENV       Engine=   V9       Compress= YES Thanks Vinay ... View more

Hi After installing SAS Integration Technlogies 9.23 and launching ITConfig2.exe and entering the SAS Metadata Server details. I am getting following error: "The object invoked has disconnected from its clients." I suspect some problem with DCOM setting. Also, SAS is not installed locally and I am trying to connect to a remote SAS server. Details on error is as follows: ****************************************************************************** System.Runtime.InteropServices.COMException (0x80042002): The object invoked has disconnected from its clients. 0x80010108 ****************************************************************************** Does anyobdy has any clues, why is this happening.? Any help would be appreciated. Note: I am able to connect to Workspace server but problem comes while connecting to SAS Metadata server. Thanks Vinay ... View more