DSXchange

Use the GUI. You normally wouldn't need to worry about 'orphans' like that, they are definitely Abby something or other... Abby Normal.

Is 'not being able to see all jobs' the same as you 'not being able to see any jobs'? If yes, then you did not have the project all to yourself and need to try again.

jatayl wrote:I think we can probably just use the 9.2.0.5 libraries instead of 10g on the client side.

That's exactly what we do.

What happens if you shut it down and restart it as 'root' - does it work then?

Exactly - you are making an assumption about where 'you' are when the script is run. Never assume.

Not sure what kind of suggestion you are looking for, other than a confirmation that yes indeed you need to take a 'least common denominator' approach with client versus database software versions. We have several instances where a 9i client talks successfully with a 10g database, but I would never ...

What is needed is fully documented. The Oracle stage docs mention this, as does the Installation and Configuration Guide from what I recall. There's even a Plug-In Configuration Guide or some such out there. And on the off chance you don't know those pdf documents are all there, check the Docs direc...

Didn't realize I needed to be more clear, especially with your subject of 'select distinct'. Normal sql supports the 'distinct' clause, any reason you can't change your sql so that it comes from your database into your job already 'distinct' - with unique values? The only reason you'd need to do it ...

Can you not simply do a distinct select in your source query?

Is this just a problem you are having, or is this happening to everyone?

You would need to post the details in the sqlldr log as noted. That or take that to your DBA: "please see the loader logfile: /apps/opt/IBM/InformationServer/Server/Scratch/ora.2430.764692.6.log for details" Edited to add - I see there's more to this than that. Following related messages make that c...

You CAN use job parameters in the connection options in a DRS stage. The only thing is that you don't get a neat right click option to insert it. Ah... not only can you use parameters practically everywhere just by typing them in by hand, you CAN get the 'neat right-click option to insert it' in an...

It would help if you stated what you were thinking about creating, what functionality you needed that wasn't already available.

Also consider a parameterized 'Wildcard' value that only brings in the files you want to process, but that only if your files use an ISO format date. [ex. test_20081231.csv] Otherwise fall back on what Ray posted re: filtering inside the job or an easy to build Looping sequence job to avoid having t...

Right - Google for something like 'free image hosting'. They will even generate the appropriate 'image' tags you'll need.