DSXchange

You can get the time in 2 forms:

TIME() returns the number of seconds since midnight from now.

@TIME returns the number of seconds since midnight from when the routine (or job in this case) was started.[/b]

I'm thinking not of spaces but of an extra @FM (which is what crlf's get converted to when calling shell commands)

The second method isn't the same. A reject link is one that is used when no other links have criteria that are true, and by putting a constraint into it you are ensuring that records do pass down it; I think your results now have identical rows going to accept and reject.

Could you post your code where you are getting the results of the ECHO command? Perhaps there are extraneous characters in that returned string that you aren't filtering out.

or mark it as nullable in the source and put a null handler in the column definition using "edit row" in the source stage.

No, you can call external functions from both types DataStage but doing so from PX is much simpler and better documented. If I understood the last post correctly then this does belong in the PX forum.

Peter, that does sound like an odd type of problem. The "ole" message is usually related to the link between the client and server and most often is due to a client problem. You can do a DS.REINDEX ALL without worries of corrupting your data, just ensure that nobody else in using DataStage otherwise...

I think DSGuru2B did understand your question. In your initial post you want your job to replace "AA" with "value1" and so on. If you create a lookup with the "AA" as the key and "value1" as the value and do that for all of your 2000 potential answers you need only do that one time and then use that...

How is this column defined in the DataStage job, though?

Moderator/Ray - but using the GCI is a Server question so I think the original question refers to Server and not parallel, but only PeterPol can tell us for sure

Plus I'm curious as to which customer is using TX in Sheffield since I happen to be located in Yorkshire at present

DSGuru2B - there is no "grace" period for exceeding the license terms, but DataStage performance is not affected by doing so.

Craig - how long has this new licensing been in effect? I haven't installed a new license in about 6 months and hadn't seen this variation before.

(best to stick in English in this forum) In Server jobs the conversion from a string to a decimal can be done differently. There are really no explicit data types and if you have a string that you wish to treat as a number you can just use it in a numeric function and let DataStage do an implicit co...

La fonction "StringToDecimal" n'existe pas dans DataStage Serveur, juste en PX.

The filename format indicates that you are trying to view a dataset by referencing one of the data files and not the descriptor file. You need to reference your .ds descriptor file to view the dataset.