DSXchange

DataStage BASIC does not have WHILE..WEND. The correct syntax for DataStage BASIC is given in the DataStage BASIC manual, and can be learned from the Programming with DataStage BASIC training DVD available from DSXchange Learning Center . While or Until tests can be used in uncounted or counted loop...

DataStage with NLS enabled reads the file in bytes only as far as the NLS map, which converts the byte stream into Unicode code point equivalents. There should be no problem reading fixed-width format files in any MBCS (multi-byte character set) encoding. I have processed files containing Japanese c...

The UniVerse manuals, now hosted on Rocket Software site, will be of most help, particular the System Description. Search DSXchange to find the URL.

It can't. You have to design this. Typically detecting zero rows involves two jobs - one to do the testing and a different one to take the action. Control is exerted, of course, via a sequence.

This is a matter of personal philosophy and office politics rather than a technology argument. My personal philosophy is to use the right tool for the job, which is often a mix of server and parallel jobs. The fact that the target is a data warehouse is moot. Server jobs are especially good at low v...

Is 13538 a typo? (the DataStage client/server port is 31538.)

Each job has its own log, which is a table in the Repository. The job has a unique number assigned when the job is created, and the name of the table that contains the job log is RT_LOGnnn where nnn is that job number. Job names are mapped to job numbers in the DS_JOBS table. Note that job logs are ...

Yes, provided that the xyz.ds file (the descriptor file for the Data Set) has already been deleted, which the early part of this post seems to suggest is the case.

In general, provided that the first two numbers in the version are the same (here, 7.5), you will be OK.

Check "generate warning for activities that finish with status other than OK" in all sequence and recompile the sequences. Detect the warning in the top level sequence and handle them there.

There are other options for retrieving the event ID of the most recent log event of particular type, and for retrieving the detail of any particular event.

Use the DIGITS Transform. This is precisely what it does.

You are not correct. Any server routine can return any data.

The problem you have reported does not come from the code you have posted. You have not called DSSetParam() correctly - or you may have provided a parameter value of incorrect type in a job activity in a sequence.

Look at the files in the directories specifed as resource disk in your configuration file. These files are the data files associated with Data Sets and File Sets. Somewhere in the very long, generated name of each is the name of the control file for the Data Set or File Set to which it belong(ed).

That's what the Remove Duplicates stage, mentioned by Sainath early in this thread, is for.