DSXchange

Thought about that, but was trying to not expose the seedier side of your life, Arnd, trawling ports for womens and all.

{or boats, Arnd thinks about boats too}

Could very well be a client version mismatch (or one of the buggy ones), which is why we talked about it in your older thread and I asked about it here.

What brought you to this old thread, Ray?

Wow... been way too long since I've used the dspackinst command. I also don't remember having to choose a plugin location during a maintenance mode, it was all automagic. Perhaps you need to point up one directory level higher? I vaguely recall something like that tripping me up using dspackinst, kn...

Or force the columns to be 'Text', then I would think Excel would quote the string and the comma won't be a problem.

Strange, never seen such behaviour from the array size. Can you explain what 'selected' means in your first post - when you view data, or run the job, or?? I'd also be curious what this job design looks like and how 'fat' each record is - average record length or max length, whatever you have. Also...

There's nothing wrong with your 'log report', and the way it works has been explained several times in the thread. The log reports the number of records sent down the link, period. What happens inside the database is up to the database. There are no guarantees that the keys you've sent will actually...

Nature of the beast. Your 'lesser time' example can return records right away because it selects all records. The first example needs to filter the records you want from the same full scan of the table.

Your use of a function against Col2 in the filter means any index over Col2 cannot be used.

Ok..."i have a job like dataset--->transformer--->flatfile." (sorry, had to get that out of the way) i cannot understand this. Why not? No data in equals no data out. Because the output field is hardccoded(independent of input data) and when i run the job it should produce H irrespective on input da...

D'oh! Lost track of where I was.

Carlos - post your questions once in the appropriate forum, not everywhere. Please.

Sorry, not really sure what you are asking.

The 'name' you pass will need to include a dot and then the Invocation ID: Name=xxxxx.yyyy rather than Name=xxxxx as you are doing now.