DSXchange

What do I have to do to pass XMLs by reference across stages?

Ray:

Yes that is the error message. Can you please help me understanding the missing variable here?

Friends: Any help on this?

Craig- If I have to set the block size explicitly to a safe "high" number then I need to increase the length of the xml columns in my job to a high number as well. The xml columns support 2 GB of XML data and the sum of all those XML columns will be a very big number. As a last resort I mi...

Yes, I am aware that can be a change.

However, I was looking if we can handle this using unbounded longvarchars.

Actually there are multiple xml columns in the table. Hence if I set each to more than 99999 I will have to increase the Block size to a very large number than the present 128 kb which I want to avoid. Hence I tried to keep it unbounded but then the DB2 Stage is throwing this error. Friends: Have an...

Friends:

Any idea what I should do to resolve this?

Thanks

Friends, I have a Parallel Job which is reading data from few tables, creating XML Hierarchy and updating the XML column of a DB2 table on the basis of a key column. I have set the data type of the XML column as LongVarChar(99999) in the XML Output Stage and in DB2 UDB API Stage. With this setting, ...

Hello Friends, I am trying to debug an operator, in this case - DB2 Stage in my Job because it has aborted with log: Failure executing operator logic. From the dump, I see the operator number as 52. Hence I have set: APT_DEBUG_OPERATOR to 52. However during job run my job aborts with this message fo...

SELECT * FROM
EDW_STAGING.STG_GS_RT
WHERE
DW_CREATED_DT >= TO_DATE('#pSFDCStartDate# #pSFDCStartTime#', 'YYYY-MM-DD HH24:MI:SS')

While running a DS 87 job that reads data from database using the query with parameter values pSFDCStartDate=1900-01-01 and pSFDCStartTime=12:00:00, But the values are getting replaced in the run time are pSFDCStartDate=0900-00-00 and pSFDCStartTime=02:00:00. which are incorrect and causing job fail...

My sequencer got aborted with the following error: From previous run DataStage Job 144 Phantom 12678 Unable to open the operating system file "/tmp/select45256aa". Aborting! [ENOENT] No such file or directory Attempting to Cleanup after ABORT raised in job PB_MS1_Master_Seq. DataStage Phan...

Someone pls provide an alternative way to get it resolved.

Please provide all the detailed steps to get rid of this error.

I have one job which is not visible in the director but it is available in the designer.

When I try to compile the job in the designer then it gives me an error : " Cannot find Job ".

Please help me here.I need to get this one fixed quickly.

We have DataStage jobs which connect to DB2 v8.0 which is on a zOS system using DB2 native stages. Now there are plans of migrating from DB2 v8.0 to v10.0 and we need to suggest whether this transition would require any job level changes.

Does anyone has any ideas on this.

Thanks!!