DSXchange

Haven't seen that one... can you post your command and error unedited, copy/paste to here?

So... because of that error, you think you need to convert your data to hex? I doubt it - check with your DBA / BA to verify what actually needs to go into that field.

How exactly did you 'migrate' everything? And when you access Oracle / view data from a job, what stage are you using?

I don't think the stage defaults to any particular shell, I assume it would be the default shell of the user the job runs under.

Would you be willing to post the script, perhaps that will allow us to see the issue.

Since you hijacked this thread instead of starting your own, we have no idea what O/S you have. For UNIX, it's just the "mv" command with the date added as already shown.

I would check with your official support provider and ask if that 2005 version is supported and/or how to access it. Worst case, I suppose one could always purchase updated drivers from Data Direct themselves.

Out of curiousity, your target is what kind of field in your Oracle database?

Right... so what's in the log file?

Does this FAQ help?

viewtopic.php?t=107844

Why ask just me rather than everyone?

Talk to your AS/400 and UNIX administrators, see what approved ways you have to transfer files between those boxes.

Welcome. :D How enamored are you / your users of these 'breaking lines'? I've found it far simpler to strip them from the field before writing to the file than to deal with them on the reading side. And typically there isn't an issue with zapping them during the process, at least in my experience. I...

You typically "remove them" by correcting the issues they point out so they are no longer being generated. That being said, I searched the forums here for both "no longer exists in dataset schema" and "There are no sort keys in the dataset schema" and got 8 and 5 matche...

I copied my reply from your 'hijack' post and then deleted my reply from there. With my reply gone, can you please go back and delete yours as well? Thanks. Edited to add: Please stop cherry-picking other people's posts to hijack. Stick with this one. Now you've got another extraneous post to delete...

That command will only gunzip and untar as in land the file, it won't "read" it. You'll need to add the "-O" option to "extract files to standard out" and then the stage should be able to read that stream as if it was reading the file from disk. Normally, you would put ...

Our dev and QA systems are physically half way cross the country at a Disaster Recovery site while our production system is not directly on site but fairly local (within 100 miles). I've also heard that others have had similar performance troubles and have been using a workaround. They place a clie...