Special Character Issue Form SAS to Oracle Using Bulkload

Son_Of_Krypton — Thu, 28 Apr 2022 10:32:52 GMT

Hi All,

I am trying to insert data into oracle table but when i use bulkload option in append the data with special character is being replaced by [] or ?.

The first result in above screenshot is appending without bulkload option and second one using bulkload option

proc append base = CTARGET.CLIENT    (BULKLOAD           = YES
                                         BL_USE_SQLLDR      = YES
                                         BL_DIRECT_PATH     = YES
                                         BL_LOAD_METHOD     = TRUNCATE
                                         BL_CONTROL         = "&cntpth.&fle..cnt"
                                         BL_LOG             = "&pth1."
                                         BL_DATAFILE        = "&pth2."
                                         BL_DELETE_DATAFILE = YES)
               data = CLIENT1 force;
   run;

And if i use only proc append without bulkload option as below then data is loading correctly.

proc append base=CTARGET.CLIENT new=CLIENT1 force;
run;

Can anyone help me here if i need to add any other option in bulkload so the special character can be displayed correctly

Re: Special Character Issue Form SAS to Oracle Using Bulkload

AMSAS — Thu, 28 Apr 2022 16:44:24 GMT

I took a look at the SAS Technical Support tracking database, there are several tracks with similar issues which appears to be related to character sets.

I recommend you open a TS track for this question.

Please include the following:
- SAS Version you are running (the following code will report SAS version information)
%put &sysvlong ;
%put &sysscpl ;
%put &syssite ;
- Registry Report (*.txt files) for each server, please clearly name the report files to reflect the server it was executed on.
- Oracle version

topic Re: Special Character Issue Form SAS to Oracle Using Bulkload in SAS Programming

Special Character Issue Form SAS to Oracle Using Bulkload

Re: Special Character Issue Form SAS to Oracle Using Bulkload