Use "/" for "Data delimiter" of Dr.Sum EA.
If you set data delimiter as "-", reading data from a table containing date type columns is not possible.
Notes
If the table you created (including a view and a distributor) is not shown in the table name list, try one of the below steps.
Close the project and open it again
Open a property dialog of either Execute Select Query or Execute Update Query, and execute [Refresh connection]
Open a property dialog of one of the following operation - Read Table/View, Write(BulkInsert), Write(DataLoader), Write(Update/Insert) - and execute [Update schema definition]. Then close the property dialog and open it again
It is not possible to execute to a table with its name containing surrogate pair characters.
It is not possible to execute to a table with a column containing surrogate pair characters.
Notes
Error may occur due to timeout at the time of committing may occur when the processing time is long.In this case, global resources [Process timeout] or simply a longer processing time in seconds, "0" (ignoring the time-out), this error may be avoided by setting.
For multi-aggregate can be specified [Download file type] is [EXCEL], [PDF].
Link definition is not supported.
[Definition file name] definition file name exists with the same name, Datalizer reads the definition file is defined in the top.
Set custom fields definition file does not support the criteria.
Only the definition file created with Dr.Sum EA Datalizer for Web can be specified [Definition file name].
A definition file created with Datalizer for Excel cannot be used.
If items with the same names exist more than one in [Column], [Row], or [Summary] of [Items for adjusting aggregation condition], the aggregation result may not appear as you've configured.
If selecting [Continue] when [Action upon error], you cannot aquire information regarding to the record that error occurred.
Read to import.log of Dr.Sum EA server.
If you have enabled scripting transaction attributes, or transaction icons (BEGIN - COMMIT) in, Dr.Sum EA process to the "append table" if the process is running continuously, "append table "Locking error occurs in processing.
In PSP, errors may occur if other processing that executes loading or writing to the same tables as the specified tables in [Table name] already exist.
Distributor-type insertion sequence, the transition is made import position. But circulation is set to ON transition of the first table from the table import position last become even does not take an error.
It is not possible to execute to a table with its name containing surrogate pair characters.
It is not possible to execute to a table with a column containing surrogate pair characters.
Notes
Error may occur due to timeout at the time of committing may occur when the processing time is long.In this case, global resources [Process timeout] or simply a longer processing time in seconds, "0" (ignoring the time-out), this error may be avoided by setting.
An error will occur if a column without the NOT NULL UNIQUE restriction is specified as a key.
Multiple columns cannot be used as keys.
NULL values are written to an empty distinction.
Can not participate in the transaction.
In PSP, errors may occur if other processing that executes loading or writing to the same tables as the specified tables in [Table name] already exist.
If an error occurs in Write(DataLoader) operation, UPDATE and INSERT will not be executed.
You are not allowed to write in a distributor.
If the below conditions are all applicable, an error will occur saying "jp.co.dw_sapporo.drsum_ea.DWException: Can not open a CS file."
There are several columns received with the UNIQUE restriction in a target table.
Match all the columns set as keys. Get together and update.
Empty character exists in data to update.
It is not possible to execute to a table with its name containing surrogate pair characters.
It is not possible to execute to a table with a column containing surrogate pair characters.
Notes
Error may occur due to timeout at the time of committing may occur when the processing time is long.In this case, global resources [Process timeout] or simply a longer processing time in seconds, "0" (ignoring the time-out), this error may be avoided by setting.
When you insert data into the order-type distributor, the number exceeds the upper limit of the server group table is an error there. Import position transition in that process does not insert.
Table creation function
When [Create table] is checked, the specification limits are as follows.
The column in which [Key] of [Schema definition] is checked is defined as a unique key, [Allow null] setting is ignored.
Writing fails when the creating or deleting table fails.
Creating or deleting table operates out of the transaction.
The setting of precision is ignored for types other than VARCHAR and NUMERIC.
Precision of VARCHAR can only be specified as 1 to 225.If a number outside that range is specified, or nothing is specified, type will be defined without specifying precision.
Precision of NUMERIC can only be specified as 1 to 33. If you specify a value outside the range 33 to define the empty set to 0.
The decimal place of NUMERIC can only be specified as 0 to 33. Outside the range that is specified or empty, and then defined with a 0.
NUMERIC 0 or empty if both digits and fractional digits, and do not define the number of digits and fractional digits.
The setting of decimal place is ignored for types other than NUMERIC.
It is not possible to execute to a table with its name containing surrogate pair characters.
It is not possible to execute to a table with a column containing surrogate pair characters.
Notes
Error may occur due to timeout at the time of committing may occur when the processing time is long.In this case, global resources [Process timeout] or simply a longer processing time in seconds, "0" (ignoring the time-out), this error may be avoided by setting.
Dr.Sum EA Due to the limitations of the condition and either the tables are KEY PRIMARY KEY must be.
About outer join (OUTER JOIN)
Joins in FROM Clause
Due to the limitations of Dr.Sum EA, ON clause can only be specified in the table join conditions, you can not find mention of the condition.
Dr.Sum EA Due to the limitations of the outer join table is either a key join condition must be PRIMARY KEY.
Combining WHERE clause
Dr.Sum EA Due to the limitations of the outer join table if the condition is "=", "*=", "=*" join either one or the other must be the PRIMARY KEY key.
Combining a composite key
SQL Wizard , the binding does not support composite keys. [SQL statement] Please specify directly.
It is not possible to execute to a table with its name containing surrogate pair characters.
It is not possible to execute to a table with a column containing surrogate pair characters.
Notes
Error may occur due to timeout at the time of committing may occur when the processing time is long.In this case, global resources [Process timeout] or simply a longer processing time in seconds, "0" (ignoring the time-out), this error may be avoided by setting.
INSERT when inserting data into sentences using an ordinal type distributor, the number exceeds the upper limit of the server group table is an error there. Import position transition in that process does not insert.
It is not possible to execute to a table with its name containing surrogate pair characters.
It is not possible to execute to a table with a column containing surrogate pair characters.
Notes
Error may occur due to timeout at the time of committing may occur when the processing time is long.In this case, global resources [Process timeout] or simply a longer processing time in seconds, "0" (ignoring the time-out), this error may be avoided by setting.
It is not possible to execute to a table with its name containing surrogate pair characters.
It is not possible to execute to a table with a column containing surrogate pair characters.
Notes
Error may occur due to timeout at the time of committing may occur when the processing time is long.In this case, global resources [Process timeout] or simply a longer processing time in seconds, "0" (ignoring the time-out), this error may be avoided by setting.