DSXchange

Exactly same thing happened to me - administrator as well for that matter

source field [1,19]
But then you need to be sure your source data corresponds with the mask you provided.
Works fine for us, also when tranporting timestamps from say SQL Server to Oracle

Hi Sud Well, it may be that I use too little data, but that does not eliminate the potential of data being transferred, in cases where I want everything or nothing. Not something The time span I see is up to 4 seconds between the warning and the completion. My concern is that the second the warning ...

Hi guys We are looking into parallel jobs but have met the following scenario: Warning Limit = 1 When a warning pops up in one of the threads in the job, this message is seen: Issuing abort after 1 warnings logged. but the remaining threads just keeps loading data. At the end the job finishes with f...

ArndW wrote:I think that this is a known V8 bug. ...

Another one to the collection

Well work around (for those who may find it usefull) is so far to use Microsoft ODBC for Oracle og IBM ODBC for Oracle whenimporting metadata, and use the plugin in the job.

Thanks for the reply

Hi When trying to import Table definition using Import -> Table Definitions -> Plug-in meta Data definitons -> OraOCI AND connecting to Oracle10gr2 database, the column length are not imported. On other Oracle versions, column length is imported. OS: Win2K3 DS: 8.0.1 Ora: Local client has been both ...

what you need to ensure

A: User ID is granted access to the table.
B: If no synonym exists you need to prefix the table-name with schema owner in the select statement.

"select column from owner.tablename;"

characters have already been mapped at the boundaries between external data and DataStage. Hi Ray and thanks for the reply. Well apparently all characters have not been mapped. job worked somewhat OK on the "NON-NLS-Enabled" server, mapping all "funny" characters to ?. What need...

[quote]Just a slight correction, it's not the 880th record, the message: Write failed for record id ' 880'". means that the primary key value (the record id) is invalid for some reason.[quote] Correction. Something somewhere in record with ID = '880' is invalid. It need not be in the key column...

Quote: If you subsequently change the routine then the jobs will be affected. This is not true I'm afraid. After completing the NLS issue I tried this one. Simple Routine Ans = 1 One job uses this ruotine. Fine Release Job, and change routine to Ans = 2. (Yes- I compiled the routine) When running th...

Hey ArndW The greatest reply so far. I suspected esactly something like that. This should imply that you would store the result of the "IMPORT NLS Map" job as a hashed fil, - target directory = Datastage\Engine\nls\maps\MAP.TABLE Load and register it in the DS Administrator, and you are ru...

Thanks for the replies. The use of the VOC files is still somewhat of a mystery, but we are getting there :) Not to be ungrateful, but the original topic was to edit a code map in an external editor, and then import the code map into the DS Server. And on that topic I would really appreciate if ther...

Hi Arn Sorry to disagree. Quote: "all that they contain are links to the routine" Un-quote. Yes. Provided the routine is present in the given DS Project. To illustrate: PROJECT_D (devl) is located at server AA100 We release the DS Job which embeds the code in the routines used within the j...

Thanks for all the replies. Perhaps I wasn't clear enough. As to recompiling jobs. In environments other than developement we only have released jobs. These jobs take in the routine code as they were on the time of release. Consequently a changed routine will not be used in our validation and produc...

Hi ArndW Thank you for a good reply - not the one I hoped to see, but still :o) Well it is more like we are loading into a "non-unicode" environment We don't want to get mapping errors, and a lot of the characters must be converted to pre-defined characters. The nice thing would be to take...