DSXchange

Same thing. You need to have configured whichever plug-in you are using to import the metadata. It's not a separate object.

What shows in the Name column when you pick the plug-in? I don't have anything DB2 related installed here, so can't speak to exactly what is what in that regard.

What 7.x version - a 7.5.x version? If so, then you should have the Loop and User Variables stages available for Sequence jobs. Those were added for exactly the kind of thing you are trying to do. The User Variables stage gets a list of the files in the dropbox. That is leveraged by the Start Loop s...

You want to 'get' as in use the variable in your routine? What happens when you just reference it? Pretty sure the reference would need hash / pounds signs around it, so:


For example. Or did you try that and it didn't work for you?

asitagrawal wrote:May be... but I dont find any documentation on how to configure it.. Can u plz guide me

Start with the Plug-In Bookshelf document - PlugDoc.pdf in your Docs directory.

Noted.

Or you just have a large number of tables for it to select and you need to be patient. How long did you wait before you decided there was a problem?

Please don't do things like this. Start a new thread as this has nothing to do with the current topic being discussed. That way we get your credentials and particulars and you can mark the topic resolved whenever you deem it resolved.

But is the field nullable in your metadata?

And make sure you haven't checked the 'Disable BBCode in this post' option, that makes all your quoting / etc go a little wonky.

What is the actual error that you get? And is your target Oracle field nullable or not?

That's because inserts are 'one for one' - you send a record to the stage and it gets inserted. Deletes are no such animal, at least not necessarily. One 'record' sent as a delete could actually delete many records in the database. In the 'old days' you could access the sqlca record and get the 'num...

Ok. I'd suggest contacting your Support provider as that is not how it should be working AFAIK. We're using 7.5.1A and 7.5.2 here and I don't recall that as an issue. So the 'solution' might be to upgrade or IBM may be able to supply a patch for your version. This is with 'Automatic' mode, I assume,...

Just to be sure, what exact 7 version do you have? For example - 7.0.1, 7.5.1A, 7.5.2?

swades wrote:Ans me thanks.

No reason to ask for an answer.

Pretty sure "we" all have had this conversation before. What ever happened to the resource checks Ken asked you to perform?

(ack, too slow. Waves as the Ken-mobile blows right on by)

Welcome! :D Which Oracle Bulkload 'option' are you using? Any particular stage or are you using some other mechanism to spawn the bulk loader? And these are literally green INFO messages, eh? That seems strange. What exact version of DataStage? Is your Oracle instance co-resident on your DataStage s...

The problem you've been having has never made a whole lotta sense. At this point, I'd suggest you contact Support and get some 'official' help with the issue. And then let us know what it turns out to be, of course.