DSXchange

You avoided my question about the setgid bit. Can you import in the other (another) project? Perhaps a newly-created project, just to test this problem and which you can delete subsequently?

Please tell us how you changed your record delimiter.

Also, can you please post a hex dump of the first line or three of the file in question, and the record schema you are using when reading it?

Then add a reject link (if using upsert) to find out WHY they are being rejected. If you are using load method, then look in the sqlldr log file.

Does not the FTP stage allow an "after" telnet command? You could use this to delete the file.

Search DSXchange for @FM

Although Windows XP is not a supported operating system for it, DataStage 7.5x2 can be installed on Windows XP (professional only) and does work if the compatible compiler and DataStage software have been installed correctly.

Two useful links to portals on the IBM web site.

Information Center for version 8.0

Information Center for version 8.1 including updates

You also need a tmp folder in the root level of the drive on which DataStage engine is installed, for example D:\tmp

MKS Toolkit treats this as /tmp

This stage type is not available in server jobs, yet you marked the job type as server. Are you looking for a server job solution?

Try %ss.6 in the seconds position.

No activity is probably OK. Least - or, indeed, any - activity is unlikely to be OK as the backup is likely to be incomplete and/or corrupted. For example a dynamic hashed file in the Repository may have re-shaped itself while it was being backed up.

Then use a text file. It will be clearer.

Right, technically then, DataStage doesn't "pick" it at all. DataStage (merely another client application as far as Oracle is concerned) supplies the name and the Oracle client software "picks" the name and corresponding definition out of the tnsnames.ora file, whose location is ...