DSXchange

sashah wrote:or -param name1=value1 -param name2=value2

That way.

If you really need to do it that way, seems to me it would have to be an OCI lookup.

Not knowing everything that's going on, first suggestion would be to comment out the WEOFSEQ function in your routine and see if that 'fixes' it.

Not when you are talking about a 32bit application.

Because you are 'viewing data' via an insert statement, not a select. When the stage generates the sql, it knows how to do this 'insert to select' conversion behind the scenes. For user-defined it just runs your DML. Boom. Yet another reason to avoid user-defined sql unless you have absolutely no ot...

Neither are we without seeing the actual XML. How did you generate the XPath expression(s) you are using? By hand? Best would be to use the XML Metadata Importer goodie and point it to an xsd for the file in question.

I am still not clear on how to use the Filter option to process files in a directory. By using wildcards there to 'cat' multiple files to standard out, which the Sequential File stage would then read as input. Saves the disk space needed for the combined file if it works for you, it wouldn't for me...

That would be a question for your Support provider. I've never seen the problem and don't recall any patches for something similar, but it might be platform dependant. Check with support.

The 'two field' way the Folder stage brings the entire XML file into memory and then passes it as one record / field to the XML Input stage. In the other, the XML stage does its own dirty work. It's better at it. In all cases, the 'issues' are the same - your job falls over dead. Nothing more than t...

I don't think so, but we'll have to see what one of the Uber Gurus has to say on the subject.

Something like that would seem to be a bug. I'd suggest you contact your Support provider and ask them.

We know it's in the sequential file. I asked where exactly is it? How about an example of your problem?

You can't directly compare the two. Yes, there is a size limit because of the nature of the 'suck everything into memory to parse' way that XML works, but then you already knew that. Not sure what 'dynamic' XML files would be, perhaps an explanation of what you mean would be in order. Lastly, 'anyth...

So, just out of curiousity, did you actually end up creating a mixed case table name? It's not so much about creating an upper case name but rather not forcing them to be mixed. Without the quotes, any combination of upper and lower cased letters will be automagically converted to all upper when the...

You do realize your 'junk character' of 0D is a carriage return - a char(13), yes? Where exactly is this showing up?