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
Warning as invalid date
Moderators: chulett, rschirm, roy
Welcome to DSXchange,
could you post the exact error message and perhaps also a sample of the xml data with the date?
could you post the exact error message and perhaps also a sample of the xml data with the date?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 4
- Joined: Tue Apr 22, 2014 8:02 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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 4
- Joined: Tue Apr 22, 2014 8:02 am
Re: Warning as invalid date
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
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
-
- Participant
- Posts: 4
- Joined: Tue Apr 22, 2014 8:02 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
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