Hi ,
I am trying to load the data from file to database.
file have one date column begin_date its data type is timestamp(19), target database column type is timestamp (38). while loading the data I am getting the error, date for mante not supporting.
What's the target database and can you paste the DML.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
use IConv and OConv datastage functions convert the input value appropriate to Oracle Date format. Look for Online document for IConv and OConv with different options.
nivas wrote:use IConv and OConv datastage functions convert the input value appropriate to Oracle Date format. Look for Online document for IConv and OConv with different options.
nivas wrote:use IConv and OConv datastage functions convert the input value appropriate to Oracle Date format. Look for Online document for IConv and OConv with different options.
Once again, you make sure that the incoming data is not null. If not, then use the iconv function with the format that your data is coming and oconv function in the format that you want.
rsomiset wrote:Once again, you make sure that the incoming data is not null. If not, then use the iconv function with the format that your data is coming and oconv function in the format that you want.
Hi All,
date column have value. But while converting null is comming out.