1- MERGE(ub_view) hint added to query as a top level hint when UB_PARALLEL used.
2- The following messages are not printed when an error occured before:
   - "No data found to unload."
   - "ubSQL-4 [34] Wrong UB_PARALLEL object count found."

1- SELECT ON DBA_OBJECTS privilege is required for "No data found to unload" message even if there are rows to unload.

1- OCI_SUCCESS_WITH_INFO allowed in unload fetch for Oracle error:
  "ORA-24347: Warning of a NULL column in an aggregate function"
2- New error code: "ubSQL-3 [26] Unable to parse UB_PARALLEL. All data not entered correctly."
3- New error code: "ubSQL-10 [13] Wrong UB_PARALLEL parse."
4- New error code: "ubSQL-3 [27] Unable to parse UB_PARALLEL. Maximum object count exceeded."
5- Removed error code: "ubSQL-4 [18] THREAD_SETS parameter greater than rowid ranges."
6- New error code: "ubSQL-10 [14] UB_PARALLEL degree greater than rowid ranges."
7- Message changed.
   old: "ubSQL-4 [17] THREAD_SETS parameter greater than rowid ranges."
   new: "ubSQL-4 [17] UB_PARALLEL degree greater than rowid ranges."
8- New error code: "ubSQL-10 [15] Wrong UB_PARALLEL parse."
9- ubSQL-3 [34] Unable to parse UB_PARALLEL. Negative degree entered.
10- ubSQL-4 [34] Wrong UB_PARALLEL object count found.
11- New error code: "ubSQL-3 [29] Unable to parse UB_PARALLEL. Right parenthesis not entered."
12- New error code: "ubSQL-3 [30] Unable to parse UB_PARALLEL. Maximum degree exceeded."
13- New error code: "ubSQL-3 [28] Unable to parse UB_PARALLEL. Maximum multiple degree exceeded."
14- New error code: "ubSQL-3 [31] Unable to parse UB_PARALLEL. Object already used."
15- New error code: "ubSQL-3 [32] Unable to parse UB_PARALLEL. All data not entered correctly."
16- New error code: "ubSQL-3 [33] Unable to parse UB_PARALLEL. Object split level not entered correctly."
17- Removed parameters: THREAD_SETS,TABLE_SPLIT_LEVEL.
18- Removed error code: "ubSQL-4 [31] WRONG PARAMETER VALUE"
19- Message changed.
    old: "ubSQL-10 [26] UNABLE TO IDENTIFY TABLE SPLIT LEVEL"
    new: "ubSQL-10 [26] UNABLE TO IDENTIFY OBJECT SPLIT LEVEL"
20- New error code: "ubSQL-10 [16] Wrong UB_PARALLEL parse."
21- SHOW PARAMETERS doesn't show LICENSE_KEY parameter.
22- New error code: "ubSQL-11 [0] Unable to create OCI environment."
23- New error code: "ubSQL-11 [1] Unable to create OCI environment."
24- New error code: "ubSQL-11 [2] Unable to allocate OCI error handle."
25- Requirement fo SELECT ON DBA_OBJECTS privileges removed.

1- Elapsed time calculation changed from second to microsecond.
2- Message changed.
   old: "ubSQL-4 [18] FETCH_THREADS parameter greater than rowid ranges."
   new: "ubSQL-4 [18] THREAD_SETS parameter greater than rowid ranges."
3- Message changed.
   old: "ubSQL-4 [17] FETCH_THREADS parameter greater than rowid ranges."
   new: "ubSQL-4 [17] THREAD_SETS parameter greater than rowid ranges."
4- BUG: OCI_NODATA returned from getOwnerObject() while unloading from partition/subpartion table of different schema when THREAD_SETS>1.
   CAUSE: ALL_OBJECTS doesn't include partition data of different schema.
   FIX: DBA_OBJECTS used.
5- O_RDWR replaced with O_WRONLY in OSDWriterThread(),OSDOpenWrite().
6- O_DSYNC removed from OSDWriterThread(),OSDOpenWrite().
7- posix_fadvise(,,,POSIX_FADV_DONTNEED) added to OSDWriterThread().
8- New error code: "ubSQL-1 [11] UNABLE TO SET FILE ADVICE"
9- Unused remoteSessions,semBufferSetDB fields removed from struct sUserInterface.
10- setMultipleParameter() renamed to checkMultipleParameters().
11-Message changed.
   old: "ubSQL-4 [16] OUTPUT_FILE_NAMES MAX COUNT EXCEEDED"
   new: "ubSQL-4 [16] MULTIPLE PARAMETER VALUE MAX COUNT EXCEEDED"
12- freeFile() added in cleanUp.c
13- New error code: "ubSQL-10 [10] WRONG OUTPUT FILE NAME COUNT
14- createOutputFDArray() renamed to openOutputFiles().
15- Memory leaks in openOutputFiles(),connectOperation() removed.
16- New error code: "ubSQL-2 [1] UNABLE TO GET FILE STATUS"
17- Warning removed from OSDClose(): "perror("OSD WARNING(ignorable for PIPES)""
18- New error code: "ubSQL-2 [9] UNABLE TO FLUSH TO FILE"
19- exit(EXIT_FAILURE) added to OSDClose() for any OSD failures.
20- Message changed. 
    old: "ubSQL-7 [8] WRONG PRE-LICENSE KEY."
    new: "ubSQL-10 [11] Invalid Base64 string length."
21- New error code: "ubSQL-7 [8] Wrong encoded string."
22- New error code: "ubSQL-3 [23] Wrong encoded password."
23- New error code: "ubSQL-10 [12] Invalid Base64 string length."
24- New error code: "ubSQL-7 [15] Wrong encoded string."
25- New error code: "ubSQL-3 [25] Wrong TNS alias."
26- ENCODE statement added.
27- Encoded password in CONNECT statement added.
28- Whitespace characters allowed and trimmed in username and password.

1- INPUT_BUFFER_COUNT parameter added; but not used.
2- USER_INTERFACE_PARAMETER_COUNT constant set to the available parameter count.
3- New parameter: OUTPUT_FILE_FORMAT; Values: TEXT, BINARY.
4- New error code: ubSQL-4 [32] "WRONG PARAMETER VALUE".
5- sColumnsInfo.isPiecedColumn commented out in ubSQL.h,OCIUtils.c,unload.c.
6- if columnDelimiterSize==1, column delimiter assigned directly, instead of memcpy().
7- sColumnsInfo.columnMaxSize renamed to sColumnsInfo.defineSize.
8- setDefineVariablesText() and setDefineVariablesBinary() added.
9- New error code: "ubSQL-8 [1] Unsupported column type"
10- New error code: "ubSQL-8 [2] Unsupported column type"
11- Message changed:
   old: printf("Data type of column %i....: UN-KNOWN\n",i);
        printf("External data type code...: %i\n",pUserInterface->columnsInfo->columnType[i-1]);
   new: printf("Column name.....: %s\n",&pUserInterface->columnsInfo->columnName[i*(COLUMN_NAME_SIZE+1)]);
        printf("Column type code: %i\n",pUserInterface->columnsInfo->columnType[i]);
12- Printing "Wait time" after unload removed.
13- Thread statistics added.
14- MIN_OUTPUT_FILE_SIZE of 512 defined.
15- New error code: "ubSQL-10 [0] WRONG FETCHED DATA SIZE"
16- New error code: "ubSQL-10 [1] FETCHED DATA SIZE OF NULL VALUE NOT ZERO"
17- New error code: "ubSQL-10 [2] WRONG FETCHED DATA SIZE"
18- New error code: "ubSQL-10 [3] WRONG FETCHED DATA SIZE"
19- New error code: "ubSQL-10 [4] UNKNOWN FETCHED DATA TYPE"
20- TextWriter renamed to writerThread.
21- Memory leaks in isSqlloaderControlFileOperation(),setMultipleParameter() resolved.
22- oracleLoader.c added.
23- New error code: ubSQL-2 [16] ddlFileName
24- Separate Environment Handle created for each ThreadSet.
25- indexOfString(),indexOfNoCaseString(),convertIntToCharArray(),findCharSize() added to utils.c.
26- New error code: "ubSQL-2 [17] WRONG LOCATION NAME"
27- New error code: "ubSQL-2 [18] WRONG LOCATION NAME"
28- New error code: "ubSQL-3 [0] DATA keyword in ACCESS PARAMETERS reserved"
29- New error code: "ubSQL-3 [1] CHARACTERSET keyword in ACCESS PARAMETERS reserved"
30- New error code: "ubSQL-3 [2] FIELDS keyword in ACCESS PARAMETERS reserved"
31- New error code: "ubSQL-3 [3] RECORDS keyword in ACCESS PARAMETERS reserved"
32- New error code: "ubSQL-3 [4] LANGUAGE keyword in ACCESS PARAMETERS reserved"
33- New error code: "ubSQL-9 [2] UNKNOWN ENDIANNESS"
34- New error code: "ubSQL-3 [7] TERRITORY keyword in ACCESS PARAMETERS reserved"
35- New error code: "ubSQL-3 [10] BYTEORDERMARK keyword in ACCESS PARAMETERS reserved"
36- New error code: "ubSQL-3 [16] STRING keyword in ACCESS PARAMETERS reserved"
37- BUG: If there are multiple OUTPUT_FILE_NAMES and last fetched rows are not equal to ARRAY_FETCH_ROW_COUNT, output buffer is overwritten.
38- New error code: "ubSQL-10 [5] FETCHED DATA SIZE OF NULL VALUE NOT ZERO"
39- New error code: "ubSQL-9 [2] Unsupported character set form"
40- New error code: "ubSQL-3 [17] CHARACTERSET keyword in PARAMETERS reserved"
41- New error code: "ubSQL-3 [20] BYTEORDERMARK keyword in PARAMETERS reserved"
42- New error code: "ubSQL-3 [19] BYTEORDER keyword in PARAMETERS reserved
43- New error code: "ubSQL-3 [18] LENGTH keyword in PARAMETERS reserved"
44- New error code: "ubSQL-3 [17] CHARACTERSET keyword in PARAMETERS reserved"
45- New error code: "ubSQL-3 [21] FIELDS keyword in PARAMETERS reserved"
46- New error code: "ubSQL-3 [22] No LOAD or CONTINUE_LOAD keyword found in PARAMETERS"
47- New error code: "ubSQL-2 [19] PARAMETERS truncated"
48- New error code: "ubSQL-10 [6] DATA keyword not found"
49- cleanUp.c added.
50- Message changed.
   old: "ubSQL-4 [18] THREADS_PER_OBJECT GREATER THAN ROWID RANGES."
   new: "ubSQL-4 [18] FETCH_THREADS parameter greater than rowid ranges."
51- Message changed.
   old: "ubSQL-4 [17] THREADS_PER_OBJECT GREATER THAN ROWID RANGES."
   new: "ubSQL-4 [17] FETCH_THREADS parameter greater than rowid ranges."
52- New error code: "ubSQL-4 [33] "Wrong REJECT LIMIT value."
53- M_PRINT_LOADER_COMMENTS added.
54- sqlldr.c renamed to sqlLoader.c
55- Removed error code: ubSQL-4 [10] "PARAMETER VALUE TOO BIG"
56- Parameter FETCH_THREADS renamed to THREAD_SETS.
57- sem_trywait() removed from M_OSD_SEM_TIMED_WAIT.
58- New error code: "ubSQL-10 [7] Wrong DATE size"
59- SQLT_TIMESTAMP_LTZ column type support removed.
60- New error code: "ubSQL-10 [8] WRONG OUTPUT BUFFER OFFSET"
61- New error code: "ubSQL-10 [9] WRONG OUTPUT BUFFER OFFSET"
62- New error code: "ubSQL-1 [8] UNABLE TO GET PAGESIZE"
63- New error code: "ubSQL-1 [9] REQUESTED MEMORY SIZE TOO LARGE"
64- New error code: "ubSQL-1 [10] UNABLE TO ALLOCATE ALLIGNED MEMORY"
65- New error code: "ubSQL-2 [0] UNABLE TO CHANGE FILE STATUS FLAGS"
66- New parameter: BYPASS_FILE_SYSTEM_CACHE; Type: Boolean
67- New error code: "ubSQL-2 [7] ubSQL not compiled with DIRECT-IO"
68- New error code: "ubSQL-2 [20] <fileName>"
69- New error code: "ubSQL-2 [24] UNEXPECTED WRITE ENCOUNTERED"

1- Memory allocation for columnName variable in getColumnsInfo() removed.
2- "startup ubSHM" removed.

1- "startup ubSHM" added.
2- New error code: ubSQL-3 [16] "WRONG <parameter> TEXT".
3- New error code: ubSQL-3 [17] "WRONG <ubSHM> TEXT".
4- ubSHM.h created.
5- New error code: ubSQL-1 [8] "UNABLE TO OPEN ubDBC LIBRARY".
6- OCI_SUCCESS_WITH_INFO in checkError() returns TRUE.
7- MAX_MESSAGE_SIZE=512 defined for checkError().
8- setSessionParameters() in connectToDatabase does not return value.
9- ubSQL-6 [1] and ubSQL-6 [2] modified.
   old: "FETCHED DATA TRUNCATED OR NULL".
   new: "FETCHED DATA TRUNCATED".
10- MAX_SQL_TEXT_SIZE changed from UB1MAXVAL*30 to UB2MAXVAL.