DSXchange

Is it possible to run the Netezza stage in sequential mode?

Your format string needs to match the data coming in. Do you have dashes in your data string?

Why not simply read the documentation? I don't have it handy right now and I don't really see the point of doing a copy/paste of things here that are in the standard documentation library.

Remove them. Not that different from my suggestion to double-check the file for stray returns. Use ":set list" in vi to help them show up if needed.

1. Yes.

2. Documented in the Oracle Connectivity Guide pdf.

Note that there would be no need for the "extract date - write/read file" steps if you're just talking the current year / month. A routine could easily return them.

I need to read a Remote .xls Excel File and FTP that into my System as .xls Excel file using FTP Plug-in Stage You can't. The stage is metadata driven and really only meant for flat files, which is why it works when you save the xls as a csv. Since you are on Windows, you can use ODBC to read the x...

Well... perhaps that was true five years ago.

<moved from FAQ Discussions>

Next time please be more careful where you start your post.

Thought you weren't allowed to use Server jobs? If this case 'fetch' just means 'read from' because the parameter was stored in a database table.

It doesn't like what you specified as the second filename. Make sure it is spelled (and cased) properly and permissions are correct.

Do an exact search for "DSSetUserStatus".

srinivas.nettalam wrote:We brought the dsenv file to the earlier state but still we are getting the same errors

If all you changed was the dsenv file then I would assert that you are not in fact at that 'earlier state'.

I don't see where you set the DB2 library path. Regardless, I'd make sure your LD_LIBRARY_PATH is all one line with no accidental returns in it. It may also be too long now and need to be broken up into two statements.

Sounds to me like your repositories are out of sync, in your shoes I would contact my official support provider for help.