DSXchange

Is there white space between city and state in this field? Is state abbreviated or in full, or a mixture? Have you run any investigation over the data to determine which tokens are being identified as which under the USAREA rule? If so, what are the results of that investigation. You may need to des...

In server jobs you can set the transaction size in the Informix CLI stage (or the ODBC stage, if that's what you're using). A value of 0 will commit all rows sent as a single transaction; a value of 1 will commit one row at a time. Somewhere in between is probably a good value. Have you considered u...

That suggests that DSStopJob can not be used to stop the job from which it is called; you will need to replace it with a call to DSLogFatal.

There's a fourth way and a fifth way; you can create a simple batch in Director (under Tools menu). You can do this even though you're not in the Developer role. This is the kind of batch whose name begins with "Batch::" and which is automatically compiled. This is sometimes handy if you temporarily...

Welcome aboard! :D Yours is a particularly messy requirement, especially for a beginner. DataStage is not designed to have job flow made interruptable, so you have to create your own, as you suggested. You need a routine that must run for every row (slowing down your throughput rate). Start date and...

To address your specific points: 1. This will be true no matter which mechanism you choose. If you want to send current information to caller, you must obtain current information from database. However, you can use a shared hashed file (publicly cached) and keep it up to date at the same time you ar...

In most branches of the Repository there is a CATEGORY column. With the exception of table definitions you can update this using SQL, provided you have already created the new category. A backslash in the category name indicates a new level. For example: UPDATE DS_JOBS SET CATEGORY = 'level1\level2'...

Another thing that can cause this error is where the log file for the job has received so many entries that it has reached 2GB. This is why you should purge log files. Once a log file reaches 2GB, unless there is administrative prevention by changing it to 64-bit internal addressing, the log file be...

There are several "Ardent run time library" (ARDTRTL) libraries that need to be installed on the mainframe, and usually are. You also need to edit the JCL templates, which allows you to supply the names with which you installed the libraries, to replace the YOUR... tokens. You can edit JCL templates...

RT_SC35 are located under your $DSHOME/../Projects/[specific project] folder. This is only true if you install your project in the default location (as a sub-directory of $DSHOME/../Projects). There is no requirement to do so; you can install your project directory on any local file system except t...

These are easy to create. To test speed of reading from a sequential file use this design. SeqFile -----> Transformer -----> SeqFile Output link contraint is @FALSE so that no rows are written. This is the fastest data flow you will ever get in DataStage. Every additional piece of functionality will...

Hi Morney. RT_BP145 is a subdirectory in your project directory on the server. Telnet in, cd to the project directory, then cd to RT_BP145. You'll find a file in there called JOB.1433470019.DT.1330157629.TRANS1, which you can inspect with, for example, vi (if you :set nu , you even get line numbers!...

Most other databases are fairly compatible in SQL grammar. Oracle is definitely the odd one out!

A before/after subroutine is called before or after a job or an active stage is run. To call one from a Transformer stage, right mouse click in the opened Transformer stage's background or click on the leftmost tool on the opened Transformer stage's toolbar. This will open the Transformer's stage pr...

On the output of the SeqFile stage, use tail -1 as a filter.