DSXchange

Please give an exact example of what you mean by system error. If a row is unable to be read from a sequential text file because of invalid column definitions, then there's no way to trap that to a file. If you haven't accurately described in the sequential stage what a row looks like, how can you w...

Search this forum for unlocking jobs. Also look for "DS.TOOLS". Your function is just an object in the lock table, it will show up on the lock listing and you can release it.

The .pdf files distributed with the software, available under your Start button as Online Documentation, cover in the BASIC manual all of the APIs available for accessing the log information. You can search the forum, as we've posted many times logic that can be used to extract info from logs. You c...

chulett wrote:Consider it ignored.

But by answering that you're ignoring it, are you really ignoring it?

If production and backup instances are identical in every way except connection credentials, simply parameterize your connection credentials (dsn, userid, password). Run the sequence giving it the production credentials, which in turn propagates the connection credentials in the sequencer to its job...

Once a Server job reads a row it parses it into the column definitions format. There is a variable that contains the entire row read from the input source, but I don't think you want to use it because it's undocumented and tricky to get at. Your solution is quite easy. Basically, load the full colum...

Actually, you can use OCONV with the MDxy token. The y will shift decimals and the x will set the decimal place. So, MD33 will shift the decimal 3 positions, then round to 3 places. Likewise, MD24 will shift 4 places and then round to 2.

Did you move the project or change its underlying path in anyway? Internally, a project is registered with an explicit path. If you physically move the project or change its path in any way, then the internal table is not in sync with reality. If you use DS.TOOLS, you can see the licensing informati...

Can you please describe what the link is doing? Is it reading a file and loading a table? If it is sitting and spinning it could be a metadata issue - it's trying to interpret the file and can't read a row because the definition of a row is fouled. It could be that the database is busy getting ready...

Unless you perform some derivation other than a straight mapping DS will not attempt to scale data. Try adding zero ( link.column + 0) to your value to see if DS will be nice and adjust your data. However, your situation is one of an implied decimal. You will have to divide by 1000 to get your answe...

You cannot, another poster just stated the same errant suggestion.

DataStage's internal repository is undocumented by Ascential. Those of us who are Universe/Unidata/PICK bit-twisters from wayback have peeked and poked around under the covers enough to understand the internal structure. You can simply inspect an empty projects directory and get an idea of the name ...

Your post indicates you are on a Windoze platform, but your text talks about Unix. Parallel jobs do not work on Windoze because it has not been ported to Windoze in a distributable form.

The client software runs your PC and connects to the DataStage server via TCP/IP. Therefore, if you can ping your DataStage server from your client using the IP and the DNS, then you can use either in the client to connect to the server. DataStage has two flavours: Server and Parallel. Parallel is c...

Why not use the Aggregator stage? If your data is sorted then the Aggregator is optimized for that activity.