DSXchange

Had exactly same issue with a csv file where last column of the file was numeric and all conversion functions where throwing warnings. So converted line delimeter to UNIX type that fixed the problem.

Had exactly same issue with a csv file where last column of the file was numeric and all conversion functions where throwing warnings. So converted line delimeter to UNIX type that fixed the problem.

Anybody could response to it.

To get rid of this Warning: APT_CombinedOperatorController,2: Conversion error calling conversion routine decimal_from_dfloat data may have been lost and Following this rule: Precision is number of digits and scale is number of digits to the right of the decimal. scale/decimal value (right part of d...

Thanks qt_ky and SURA to to explain the storage of numeric.

My actual data value was 14656.495444480958, that becomes Numeric(17, 12) and it works fine. I have increased the total precision to 20 to fit max value that i found in the table.

My source is double data type and using dFloatToDecimal function to send to target column decimal(16,12), i get warning message for the source data value of 13456.123456789012 and its displayed as zeroes but when i change target column to decimal(16,11) no warning but value is rounded. Even if i inc...

Hi Guys thanks for your post. I did same as i added IP and HOST NAME in c:/windows/system32/network/etc/hosts file and my client started working. By the way where i can find the total # of licenses available
?

Job is taking very long time while doing a select from db2 tables/views. Its a simple job selects from db2 api stage and loads to flat file. There are two tables and two views used in this job. This job was taking only few minutes before and now its taking hours to complete. Only change on db is tha...

Im trying to execute copy command in EXECUTE COMMAND stage where folder name has a space in it. Actual path is like this: //dsserver/etl/Ftp Files/dummy.txt Error message is as follows: cp: "//dsserver/etl/Ftp " is a directory (not copied) cp: Files/dummy.txt: The system cannot find the pa...

It was typo, I missed it in the message. Just wanted to know if its the right approach that first create a view and then LOAD it with datastage job from different extracts ?

How can a VIEW be created in datastage ? I created a view in db and then tried to INSERT data into it using db2 api stage but datastage id was not allowed for insert in a view. Is it right way to do it.

VIEW SQL:
----------------
Create VIEW as MYVIEW
COL1, COL2
From TBL

Any thoughts on this issue ?

As Chullet said Sequence must be in status of 'Aborted/Restartable' to start from failure point. Moreover, these jobs should be connected with each other.

SQL join is requirement of this job otherwise db extract is too big if i want to use ds join.

I tried running SEQUENTIAL and with 1 NODE both runs produced wrong number of rows.