DSXchange

I guess the matter is solved so marking the topic as resolved.

Glad that I started this :P @BI-RMA I was specifically talking about date conversion. For String To Decimal, Decimal To Integer etc implicit conversions may be OK. When I said that explicit conversion is better then I meant what Priyadarshi is trying to say. Just optimum performance or letting datas...

What if any junk value or spaces or Null value comes from the file ? There's a possibility since the source is a Sequential File. Last week I have raised a topic regarding the same. Kindly check Craig's comment. http://www.dsxchange.com/viewtopic.php?t=149264&highlight= . Thats why I think its b...

A column cannot have two different datatypes. Either its a DATE or TIMESTAMP.

@Bob,
We have two clients 8.1 and 8.7, and I have checked it in both.

I am now handling spaces in my job and explicitly converting into dates.
Datastage is really a mysterious tool

That's what Ray, I am doing nothing extra.
Just directly mapping a String Field(which contains date) to a Date Column.
Ideally I should use a StringToDate function but since my dates(from source) are in default YYYY-MM-DD format so I didn't use any conversion.

The extended column metadata doesn't have anything enabled..

Hi, My source is a File and contains a varchar field which actually stores date in the basic format YYYY-MM-DD. In the transformer I didn't use any conversion methods for date conversion since the date is in default datastage format. Well this worked perfectly until I validated the data. For spaces,...

I am too doing the same, but I thought better to ask than regret later.

Hi,

Is there any way/logic to update records in a Sequential File ?

@akarsh
Did you try any of my options ?

@akarsh We have also experienced the same issue while updating data on our DB2 tables. Try one of these solution :- 1) Use Oracle Connector Partitioning instead of Hash Partitioning in the target. OR 2) Reduce the "Array Size" to 1, keeping Record Count to higher value e.g 2000. OR 3) Run ...

@Jayanto,
Use simple TRIM function and store the output as Integer.

Jack,
If you use multiple queries then it will throw an error for invalid character ";".
What sort of sqls you are using, why dont you use Before/After SQL or try union as suggested by Craig.
I had the same problem so I used Before SQL.