DSXchange

That really doesn't make much sense, I suspect there is a key piece of information missing. Have you looked at the job's log after it completes, are they any warnings posted to it? What is your Update Action in the OCI stage?

So... do you have an FTP issue or a job issue?

Have you compared the files to ensure they are identical after the transfer? How exactly are you performing the FTP - script, manually, FTP stage?

Have you used the OCI stage before this and are just having an issue with one table / connection - or is this the first time you are attempting to do this in DataStage? If the first time, the implication (at a bare minimum) is you haven't configured DataStage for Oracle. Worst case, it can mean you...

Are you absolutely certain you need to do this?

So... export the Read Only objects as well if you need them.

It is supplied as part of the standard install. However, it sounds like someone has futzed around and created a 'User Defined' version of it as well, seemingly with the same name - not exactly what I would call a Best Practice.

Perhaps you can take some comfort from the fact that, from what I recall, the 8.1 release will have a stage (stages?) that will support both pivot 'directions'.

As noted, it is very hard to understand what exactly you are trying to do and what your problem is. However... in above structure i want to pass whole xml and type attribute to trnasfomer so how can i do that .... wht will be the xpath/derivation for the same in XML pluign before transformer ?or an...

On top of that, have a chat with your DBA on the subject as well.

You'd have to tell us what is different about your last record.

a) Welcome!

b) Why not use OCI?

c) Post your entries from both files.

The 'semaphore' file would need to be touched into existance on the DataStage server for it to be of any easy use. Otherwise, you'd need to use another mechanism to poll for its arrival.

LoadCur.CTransformerStage25.Lnk_SQL_Upmedia: DSD.BCIPut call to SQLExecute returned informational message. SQLSTATE=01004, DBMS.CODE=0 [Ardent][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver] Fractional truncation There's no problem updating more than one row at a time and it will happen autom...

You're probably better off changing the Link Tracing Level on the Inputs Properties tab of the FTP stage and seeing what gets logged when the job runs rather than trying to debug something like that. Put your cursor in the field and then click Property Help to see the additive values you can use the...

'ksh' is fine by itself, no need for the '-x' option.