Warning as invalid date

brindasabapathi · Post by **brindasabapathi** » Fri Jun 27, 2014 12:07 am

Hi ALL,
I recently started working on datastage
In datastage, I designed a sample job where I am fetching values from a XML file. Everything is fine, but for two fields which is of type date, it is showing warning like invalid date in XML_Input stage. I imported the correct table definition.
So that none of the values are getting parsed to next stage
What should I do to resolve this problem?
Thanks in Advance

ArndW · Post by **ArndW** » Fri Jun 27, 2014 5:21 am

Welcome to DSXchange,

could you post the exact error message and perhaps also a sample of the xml data with the date?

brindasabapathi · Post by **brindasabapathi** » Fri Jun 27, 2014 5:32 am

Ya sure!!

From XML file I am fetching date in this format

<calendar4>2014-06-10</calendar4>

and the type of the variable is date.
When I am inserting the data into database it is showing warning like

XML_INPUT_1: XSLT Processor: Column Name="calendar4"; Value="" is an invalid date

Because of this warning the entire values are not inserted into database.

ray.wurlod · Post by **ray.wurlod** » Fri Jun 27, 2014 3:49 pm

Try changing the Data Element in the Columns grid to "Date". It may be that DataStage is expecting an internal format when data type is Date. The Data Element can cause a translation to be effected.

brindasabapathi · Post by **brindasabapathi** » Sat Jun 28, 2014 6:46 am

Thanks for your response
I have mentioned the data type as Date in all stages wherever the data is getting parsing
Even then I could not find why it is giving that warning

chulett · Post by **chulett** » Sat Jun 28, 2014 6:50 am

Not the "data type" but rather the data element, a specific column property.

brindasabapathi · Post by **brindasabapathi** » Tue Jul 01, 2014 12:39 am

Still I am getting warning message while inserting values into table.
Here is the sample warning message what I am getting while inserting values into table

Sample..Transformer_2: Statement INSERT INTO Student(Name,roll_no) VALUES(?,?) failed to run.
Sample..Transformer_2: [IIS-CONN-DB2-695] Exception thrown from CC_DB2DBStatement::executeInsert, file CC_DB2DBStatement.cpp, line 923: SQLExecute reported: SQLSTATE = 57016: Native Error Code = -668: Msg = [IBM][CLI Driver][DB2/AIX64] SQL0668N Operation not allowed for reason code "7" on table "Student". SQLSTATE=57016

chulett · Post by **chulett** » Tue Jul 01, 2014 6:24 am

Talk to your DBA.

http://www.dbtalks.com/Forums/Thread/37 ... table.aspx

Warning as invalid date

Warning as invalid date

Re: Warning as invalid date