DSXchange

Agreed. Use DataStage 390 when you have no COBOL programming resources available, that's where the advantage lies. Amazing... COBOL was a 'dead' language way back when I was doing it in the 80's. The main processing systems here are all 'COBOL over Oracle' behemoths. Make that more like UNdead! [grr...

Part No. 00D-030DS751
December 2004

They must have rectified the oversight. And yes, the value doesn't matter. If it is 'set' the option is in effect.

Yes, the Folder Stage - that is the missing 'required input stream' the compiler is complaining about. Have you read the XML PACK Designer Guide pdf that you have? There is a section there called 'Adding an XML Input Stage to Your Server Job' that might help. You should also find any post by kduke a...

A difference in what SQL Server selected versus what you are getting from Oracle. Sounds like you got an empty string before and now you are getting nulls. As noted, there is no magic bullet or easy answer here. You have to change all the jobs. You'll either need to change what gets selected using a...

Job design? When you put your XML source into a database table, is that flattened or still as XML?

Typical job design would look like:

Folder -> XML Input -> Transformer -> DB

For the former (flattened data).

It's not a "weird error", it's an Access Violation. What did you find when you searched the forums here for that message?

Ken is challenging your "it's very bad performance" statement. I would have gotten there.

You might want to check the parameter assignments in the Sequence job again. If you make the password parameters in the Sequence jobs - as a test - a String instead of Encrypted, does it work? I believe there were some bugs with encrypted passwords back in the 6.x days, you might want to contact you...

When you run them outside of the Sequence job, do they run ok? That answer could help point out a general parameter issue or a Sequence setup issue.

Search the forum for 'null password given', see if any of the other posts on the subject help.

Have you built an routines yet? Used DSExecute to run a command? Pretty straight forward. Pass in the filename to be cat'd as an argument and the result back out the other end. Check this post for one example. There are others out there a search will turn up.

ps. He's no Brian.

"Didn't work" how? If you do a straight command line sqlldr direct path load from this file, how long does it take?

It's not the SP2 patch that is the problem here. There is a specific 'Designer crashes while editing Sequence jobs' patch as well that you need to get. A search here should turn it up or ask your Support provider.

They are listed exactly as Arnd notes in my 7.5.1A version of the document. There's a discrete section for 'Oracle Support' in the Environment Variables chapter. Does your manual not have a Chapter 6 with a section of Oracle variables in it? You seem to be quoting from it. I don't know why you'd hav...

Post some detail error messages so we can see what's behind the ellipses, the (...) part.

'Everything'? Then what does DataStage have to do with your question? Just run your C program from the command line.

Or just use one of the 'normal' mechanisms available for execution of any other command line object - DSExecute, ExecSH, Execute Command stage, etc etc.