DSXchange

Use a UV stage rather than an ODBC stage. A UV stage uses ODBC protocols, but is native to UniVerse and "understands" some of the unique features of the database's capabilities. The DSN localuv has its user ID and password disabled because it is already connected. Having established that, can you pl...

Can SQL Server handle the timestamp 0001-01-01 00:00:00 successfully? There is a problem with the year 1AD because the previous year is not 0AD - there is no such year - the previous year is 1BC. Therefore the transition through midnight is not properly defined. Can you try 0001-01-01 00:00:01 as th...

Remove the duplicates or use a target table that will accept duplicates or generate an artificial and unique key.

User and password are greyed out if you choose localuv as the DSN, because you are already connected to localuv; it is the schema of the project itself.

You can do jobs on server, unless the politics of your client forbids it. There is no technical reason not to, and there are some technical reasons why you should, particularly for small jobs. The main one of these is the far smaller startup time of server jobs.

You could use an External Filter stage and process your string through, say, awk. This can handle regular expressions.

In BASIC you could use MatchField() functions.

Once you can read the entire post above you will have the whole story. Please note that neither I nor the other four premium posters is paid anything for posting on DSXchange, but I do want it to keep going, which is why I'm always advocating that people buy premium memberships - one of the ways tha...

There is no single difference between server job compilation and parallel job compilation, as your question seems to imply. Nor is it very clear just why you "need more information on the server job compilation" - is there any specific thing you have found in the manuals that is not clear? The way t...

What have you already learned from the manuals and from searching? And when's the interview. There are, in DataStage, two kinds of hashed file. These are called dynamic and static, based on whether or not their internal "table space" management is governed automatically by the volume of data requiri...

Your first problem is the one- or two-digit day numbers in conjunction with a substring that takes the first eleven characters of the string. Get this right first, by substringing into separate components (in stage variables) then manipulating the day number before re-assembly. You need to add the l...

Welcome aboard. Can you be more specific about what you mean by "programming"? DataStage has an internal programming language called DataStage BASIC, but most "programming" of DataStage is done with graphical tools, rather than with coding. There are a couple of Red Books from IBM, but they are not ...

PX is an obsolete term. When Ascential Software acquired Torrent systems (the Orchestrate parallel execution architecture), the marketing folks at Ascential described the technology as the "parallel extender" for DataStage, hence PX. Once it was apparent that it was not an extender but, indeed, sepa...

You can pre-count the number of lines in the source file using an operating system command such as wc -l from an Execute Command activity in a job sequence and, based on what is returned from that and from the records this job keeps, determine the starting position (line number) from which to proces...