The job extracts Datawarehouse information and converts it into XML format that is accepted by the database.The output is non formatted XML output.
While compiling the Datastage job I get an Error"Invalid derivation to output column'
I didnt have any problem when i didnt concatenate the User defined variable
Could you provide me with pointers as to where it coulc have gone wrong???
Invalid Derivatiton to Output column
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 301
- Joined: Thu Jul 14, 2005 10:27 am
- Location: Melbourne, Australia
- Contact:
Crikey - Can you provide us with some more hints to go on? Can we assume the error is being generated by a Transformer stage?
You say that you didn't have a problem before you "concatenate(d) the User defined variable", so in answer to your question about where you went wrong I'll chance my arm and say that the problem is with the concatenation of the User defined variable.
Does "User defined variable" mean a job paramter, stage variable, or something else? What's the derivation that's failing? Can you show us the concatenation expression in question?
J.
You say that you didn't have a problem before you "concatenate(d) the User defined variable", so in answer to your question about where you went wrong I'll chance my arm and say that the problem is with the concatenation of the User defined variable.
Does "User defined variable" mean a job paramter, stage variable, or something else? What's the derivation that's failing? Can you show us the concatenation expression in question?
J.
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>