Error while passing SQL as a parameter
Posted: Mon Apr 23, 2012 12:32 pm
Hello,
I am facing an error with a Datastage 8.5 Parallel Job. I have a job that reads from a mainframe DB2 Table (Using DB2 Connector) and writing into a Teradata Table( Using TD Connector).
The job is running fine when I keep the SQL Statement (that reads from the source table) in the DB2 Connector Stage.
But when i make the same SQL as a parameter and assign the parameter name in the DB2 Connector, the job is aborting. It looks like the DB2 connector is not able to import the metadata of the source table.
In my job RCP is enabled and no column names are mentioned.
Please share your thoughts on the situation. Is there any limit in the number of charactors allowed in a parameter value ? my SQL has 400 Charactors in it.
thanks for your help
Sree
I am facing an error with a Datastage 8.5 Parallel Job. I have a job that reads from a mainframe DB2 Table (Using DB2 Connector) and writing into a Teradata Table( Using TD Connector).
The job is running fine when I keep the SQL Statement (that reads from the source table) in the DB2 Connector Stage.
But when i make the same SQL as a parameter and assign the parameter name in the DB2 Connector, the job is aborting. It looks like the DB2 connector is not able to import the metadata of the source table.
In my job RCP is enabled and no column names are mentioned.
Please share your thoughts on the situation. Is there any limit in the number of charactors allowed in a parameter value ? my SQL has 400 Charactors in it.
thanks for your help
Sree