DSXchange

Working gr8 Thanks dude After your sql put the words: "WITH NONE". So if your sql look like: Insert into table1 (col1,col2) values(?,?) Change it to: Insert into table1 (col1,col2) values(?,?) with none I believe that your target table is a non-journaled table, and you need to either set ...

Hi All, I am loading data into AS400 table from oracle stage. we have journaling is on onthis table. Job is aborting with the following error. "VPMDATA,0: Fatal Error: Fatal: [IBM][CLI Driver][AS] SQL7008N REXX variable "VPMDATA " contains inconsistent data. SQLSTATE=55019 DSTAGE-DB2C...

you can create your own create statment and you can specify which field you want primary index

genarate create statement at runtime=no

and you can enter your own sql.

Thanks for your reply,
It is working fine. But I found one more issue which the above code is not supporting

example :

input : 0000000.123
output should be 0.123

but if I apply the above code I am getting '.123'. I need '0' before decimal point.

Thanks for your support

its not working , Can you please modify the above statement what I given

If I use the below statement leading and tailring zeros are elimination but I need 3 numbers after decimal. my input is numaric and I changed my target as varchar. If (IsNull(col_name)=1) Then '0':Trim(Convert(' ','',(lnk_lkp_IPS_UOM2.EXTND_SALES_AMT) ),"0","B") Else if col_name ...

what about DecimalToString() with rtype as suppress_zero? In a column I have both negative and possitive vlues. I have to eliminate the leading zeros. as of now I am using the below statement If (IsNull(Col_name)=1) Then '0':Trim(Convert(' ','',(col_name) ),"0","L") Else Trim(Co...

what if we have negative values. how to truncate those. this logic is not working for the negative values.

example : -00000123.21
it should be : -123.21

anbu wrote:Use trim function to remove leading zeros and define field as varchar in target

Hi it is working fine with the following syntax

Trim(Convert(' ','',(col_name) ),"0","L")

Hi I am loading data into a flat file. Data is comming in the folloing formate

its showing as 000000000008194.000 (numaric(17,3)

it should be 8194.000.

Please suggest me how to convert?

both source and lookup both are not null columns but no records are inserting into database. if I run the job using lookup records are inserting.

when I replacing lookup with join do i need to modify anything?

both source and lookup both are not null columns but no records are inserting into database. if I run the job using lookup records are inserting

Hi I am joining two tables , If I use lookup stage, due to volume of data it getting aborted, because of data limit is exceeding 4 gb. that is why I am replacing Joiner over there. If I use joiner I am getting warning and job getting fail. error Join_67: When checking operator: On input data set 1: ...

Hi I am running one job. oracle is the source and I am using ODBC_Connector as lookup. I used around 8 odbc connects as lookup in different placess in that job. This job will take around 4 hours. After two hours I am getting the following error. I didn't see any fatal errors. but job aborted with fo...

The volume of data in the lookup is 3 mil.

we don't have any other support team. If any one know the right answer or suggestions please respond.