DSXchange

If you have scp or rcp installed then they are easier to use; I look at them as modern extensions to ftp... they also allow you to copy directories, which the standard ftp protocol does not.

Convert your dataset to VarChar(40) and trim your strings.

I now see why you wanted to use the drag-and-drop interface. When you use ftp you need to do: a) "connect <remotemachine>" b) "cd <remotedirectoryname>" c) "lcd <localdirectoryname>" d) "put <filename>" to copy local file to remote or "get <filename>" to copy remote file to local machine.

You should use the documentation you have at your site.

Oracle - use sqlplus
Informix - use dbaccess
SQL Server - don't know.

...Moreover, the job works perfectly fine when I remove incremental processing (upsert all records from source)... Well, what does or doesn't get processes when you do that? Remember, we don't have your job to look at so your statement doesn't help us try to localize the problem. Does the problem g...

Suggestion: Don't use a 3rd party FTP tool, open up a session in UNIX and use the builtin FTP command, it might not be drag-and-drop but it will work.

Odd, I do.

Do "Read Method" = "File Pattern",
then put your wildcarded string into "File Pattern"

That is really strange, especially since a HEX conversion seems to be done. I'm at a loss - what is the derivation for the column PRODUCT_DESCRIPTION? Also, does the error go away if you just output to a sequential file instead of to a ODBC stage?

the FTP process shouldn't fail, or when it does it will give a better error. Yo are probably using Hummingbird to connect to your UNIX machine, or are you using a special FTP tool/program? You do have other options in UNIX such as an NFS mount or things like scp and rcp ; but most likely you will se...

Can you also post what your OCONV() statement is?

All of these products have their own command-line driven interface. You will need to issue commands to login, set schema, execute query/command and logout; each of the 3 has a different method for connecting and it's own syntax. From DataStage you can shell out to UNIX using DSExecute() and similar ...

All of these products have their own command-line driven interface. You will need to issue commands to login, set schema, execute query/command and logout; each of the 3 has a different method for connecting and it's own syntax. From DataStage you can shell out to UNIX using DSExecute() and similar ...

Trimming a CHAR(10) field with the value of "hello " will result in a value of "hello " (i.e. unchanged!) if it is being put back into a CHAR(10) field. You need to ensure that your comparison works on identical data types. If you do a transform stage and execute a derivation "IF TRIM(In.CharField)=...

ODBC Solaris drivers for PostGres can be found here

Do you have a hidden null in the key string?