DSXchange

The API DSGetJobInfo documented in your manual will tell you the state of a job when used appropriately. As your your creation of jobstreams and restartability, you'll need to learn more about restartability in Sequencers. As for partially loaded data, you're going to need to look at your loading st...

Stop messing with this stage. This stage is for reading/writing a file in a remote directory. To move files use command line FTP. The mget option will retrieve multiple files based on a wildcard, turning off prompting will ease the transfer. A simple shell script can make this process reusable.

pump307 appears to be a robot spamming content on random postings. Better boot that user off.

If you know how to execute an operating system command from inside a java script, then you have the ability to execute the dsjob command in the DS engine/bin directory. What other information are you seeking?

Can some one guide me in this regard please. Its very urgent. We're sorry your problems are urgent. Please don't ask for urgent answers again in the future, as that usually means they won't be answered immediately. Your problem is that you lack the understanding of how unix command line works. This...

Some things to consider when opting for the "all-in-one" jobs for both PX and Server: 1. Large design size means importing/exporting the job takes longer - produces a larger dsx file for a single job. 2. Large designs means that more logic is within a single job - only one developer has write access...

By java means you don't want to use the dsjob command line executable to start, monitor, and extra log and link metadata? You prefer to write your own version in java? If you understand the APIs available, what would that gain you over doing shell command executions of dsjob?

The execution hander thread is an independent stream of tasks to do when something goes wrong. By your shown design, there's nothing to "do", the job starts with the exception handler stage. Your job should start with a stage that does something. Detach your exception handler and set it somewhere on...

It the message indicates that the job had an "Access violation. ", probably with the sequential text file. Any chance you had it open in Notepad or something? Even just have Windoze Explorer focused on a file induces a operating system lock on the file, which will cause an access violation with Data...

Forget about using DataStage for a moment. In the world of writing computer programs, is it "best" to have a single 5000 line top-down program, or a collection of small modular routines, methods, and procedures that may reach 8000 lines of code? Best - define it. Best design to maintain? Best design...

Only when a job runs does the log get purged. If you only run a job once a month, but its purge is daily, it will only purge when the job runs. There's no "purge" daemon to clean up logs daily - it's the responsibility of the job to maintain its own log. Setting the project purge setting means that ...

Instead of your job design, use a Batch style job to call DS routines directly, it's much more elegant. To call any subroutine, just use: Call DSU.yoursubroutinename(InputArg, DSJ.ERRFATAL) You can put calls to DSLogInfo before and after calling your routine to error trap it. You also can do...

You can do this with a COMMON variable accessed using a custom FUNCTION, but you MUST disable row buffering, remove IPC stages, and disable read/writecaching for your premise to work no matter what. Another method would be to write the value to a single row hash file on the last transformer and refe...

You are using # around the job parameter, like #InstancePassword#? If you use View Data on the stage, it should prompt you to enter parameters utilized.

My 2 cents contribution, in 7+ years with DS this has happened to me only because of design error, never because of DS. Are you overwriting the existing file or appending to the existing file? Any stage variable/row rollup occurring?