DSXchange

My assumption was that it is already tab delimited, thus you could send it as a long string and it would preserve those delimiters. Is that not the case? If not, command line ftp won't help at all.

I did. The documentation does. I'm not really sure what more elaboration you are looking for.

Do you have any specific questions?

Try reading (and transferring) it as one long varchar field. Either that or there's always command line ftp.

There are examples (or at least an example) in the online help for the stage.

Right, LOGTO the project in question. And then execute the command directly or go thru the DS.TOOLS menu.

Sure, do this directly from the command line of your O/S.

FTP it as one long string field and tell it not to add anything (like quotes) as it transfers the file.

Yup, that's what it does.

Maybe... big maybe. If your target table partitioned?

Have you tried escaping it? Put a back-slash before the dollar sign.

Not really, don't have 8.x or PX or Windows or use ODBC, but...

Is your installation NLS enabled?

In other words, do you have a UNIX ODBC driver for Excel that your company has purchased? DataStage does not ship with one.

That 'update action' first deletes any record and then inserts a new one in its place. If you are willing to burn two DML statements for every record when one would do, I suppose it could be used in that manner.

so we have to declare ODBC_0 stage twice once in local container and other in job design, which is redundant. No, as noted that is specific to the job design of the example, not the fact that a container is involved. Use or non-use of a container does not change how anything works or the stages inv...

I'm sure some sort of query could be cobbled together for that but I don't have any such thing. Did you check Chuck's stuff? I use that to 'search whole project at one go'... as long as the project has been exported.