DSXchange

Welcome to Earth, marsboy! :D Are you familiar with using hashed files in a DataStage Server job? Doing things directly like this in Oracle is the slowest way you could have chosen, as you are coming to realize. A typical job design to do what you want would leverage hashed files for speed and go so...

Saama wrote:I know that OCI and MSSQLSERVERLOAD disables the constrainsts and indexes , doesn't check for integrity of data and load the data.

Not true, at least not as a blanket statement. Or at least not for Oracle. What you say it does is an option in the process.

I have already a script for extracting the files to Ds server and looping it. Still i need to write another routine for that. What does that mean? What 'that' do you need a routine for? You are 'looping' in your script? Rather than in a Sequence job? The script should just return a delimited list o...

Alas, no. I've never seen mention of nls_read_fixedwidth() in terms of selecting from Oracle before, so this message might have come when DataStage is checking the metadata of your write to a fixed-width file. The problem definition is a little confusing. First mention of the 'nls_put_fixwidth' pro...

A 'put' would generally mean a write, not a read. Sounds like you are writing to a fixed-width file and you are sending more data to a column than will fit in it. This is not allowed in a fixed-width file.

In the name space it will just import the Xpath. No, you can type whatever you want in there as well as import information. I have imported the schema and try to validate the XML Inputfile if any attributes are missing then the job should abort. If that attribute is required and it is missing, sure...

Ok, good... just wanted to make sure you weren't expecting anything more from me. Yet.

What kind of validation are you expecting? Note that there is more to it than simply checking the option, did you read the online help for the stage? To reference a schema in your XML document, use the schemaLocation attribute within the root element tag. In other words, you've got to tell it where ...

Because of you, I would guess.

Instead? No. However, that one is well worth reading.

By 'Oracle stage' do you mean the OCI stages? They don't use ODBC, but leverage your existing Oracle client software. The process to configure DataStage for the Oracle OCI plug-ins is documented in both the pdf for the stage itself or the 'Plug-In Installation and Configuration Guide' pdf.

Pwned!

Oh good, you got a solution.

ps. If you're not sure if you should start a new topic or not - start a new topic.

I know, that's why I said 'Never mind'.

Did you read the rest of the post?

Glad you found that old post. :D

Those are account based hashed files that you can do sql against, as far as I know. So it should be possible to update the field and replace all 'X' with 'Y', yes? Perhaps someone like Ray or Kim could confirm...