DSXchange

Yes, you can read a dataset in append mode. What happens when you do a UNIX "orchadmin describe {the path in your error message}"; does that work?

The PX sequential file stage lets you use a wildcard pattern for reading multiple files; this should be your simplest solution.

How about access to the .ds dataset file - are you running with the same userid?

Just pretend that you have your flat file and you have a DOS command window open. What command would you use to import the file? This is the exact same command you would use from DataStage once the file has been created.

Per the manual: TMPDIR. This defaults to /tmp. It is used for miscellaneous internal temporary data, including FIFO queues and Transformer temporary storage. As a minor optimization, it can be better to ensure that it is set to a file system separate to the DataStage install directory. Most of the t...

If one column is not fixed width then the file cannot be fixed width. Your requirements to consider the sequential file as fixed width don't change that fact. If you saved the file from Excel then it is a variable length delimited file, and you should declare it as such in PX. You need to know your ...

Tania,

lookups to hashed files need to specify the full key, there are no range lookups supported. If you search the forum for "range lookups" and hashed files you will find that this problem has surfaced many times and there are various solutions available depending upon your requirements.

UniVerse is a post-relational database that is also known as a "Pick Database". It also happens to be the database system that the current engine is written in.

Ronin-sama, Even though a server reinstallation won't cause you to lose your projects, you might not need to have to do that. If you use a DOS session and attach to your E:/Ascential/Datastage/Engine directory and try a "bin/uvregen" it should regenerate your .uvconfig file and perhaps let you resta...

Manually clearing the STATUS file of any job is not a good idea, it can cause a lot of problems. If you start your jobs from sequences you can specify the Job Activity to reset the job if required prior to a run. The same result can also be achieved if you start your jobs via the UNIX dsjob command,...

Are you running the job with the same configuration file that you are using to view the data?

Vijay, the manual that you already read explains that the command stage lets you execute OS commands; so there is no exhaustive list of commands. DataStage itself is a great tool to generate files, so you might not even have to use an external command. What command do you want to call? What is the f...

Nick,

DataStage does not inlude a programmatic call to clear the log file for a job; it can be done explicitly (and the methods have been posted here) if necessary, but it is preferable to use the purge settings to automatically clear aged log entries either by age or number of previous runs.

There is not difference at the hashed file level between UNIX and Windows; in neither implementation can these files be accessed from the OS. You need to use one of the methods listed above on either platform.

nasimul,

could you tell us what the error message was?