DSXchange

You could in earlier versions, I would imagine it still works in 8... one example.

That should work fine I would think, give it a shot and let us know.

If I did I would have posted it. Maybe later when I have some spare time to ponder it...

The table doesn't exist in the project you are connected to. And you can't move anywhere in there where it will find anything other than DataStage objects.

D'oh, missed that.

Fixed your job design for you - you need to use code tags not quote tags to preserve whitespace.

... but only for hashed files with a VOC record pointer. You'll need to manually create it for your pathed hashed files using SET.FILE, if I recall correctly.

Even with all that, in your shoes I would just stick with the devil you know - Oracle load balancing, especially if that's already working for you.

Right... look for a "dbase" driver, not anything that specifically says FoxPro.

Get it working outside of DataStage first. Surely there are DB2 savvy people there who can help you? Once you have it working, you can easily get it back into your job.

What do you think 'bad param' might mean? The job does not have a parameter with that exact name, spelling and case.

Rather than mine, it would seem. Why not run some simple tests yourself? One example - put bad values in the odbc configuration file (things like hostname that exist in tnsnames) and see if the connection still works. If it does then you'll know it got what it needed from the tnsnames.ora entry. Fro...

saugat_1982 wrote:@ Craig - Requirement is to read from dbf files , no access to Foxpro DB .
So I am not sure, will just an "ODBC" be a solution ?

I've said it twice, I guess a third time won't hurt - Yes. AFAIK, you just need the right ODBC driver.

Assuming effdt is an actual date and BIzDate is a string, don't you need to do something more like:

My understanding is that it needs it because it needs it, that's just the way it works. And while you may have documented things like the hostname (etc) in the odbc file I don't believe they are actually used. Some of this may depend on if you are using the 'thick' or 'thin' drivers as well, I'm hon...