DSXchange

To run a job in the loop without waiting, you can't use a Job Activity stage to run them as they have the wait built in. You'll need to use dsjob from the command line without either of the wait options to accomplish that. That is, dsjob command without either -wait or -jobstatus options, invoked f...

1. No. With a Loop, it goes around and around, one iteration at a time. 2. There is a final line terminator in your file. This means that you are generating an empty line when reading it. You need to eliminate that. Show how you convert your file to a delimited list, and we'll respond with that solu...

If you can't define it in the Pivot stage define it in the stage on the other end of the link.

Nor are the sequence numbers in your example unique. How about you specify precisely what is required? It seems to me that all you need to do is to sort your incoming data and generate a key each time a change in the sorted value is detected - which detection is most easily done in the Sort stage. T...

Your input sample does not have 60 characters. They seem to be constructed entirely of your alleged "40 character key" values.

How are the extra columns to be generated?

If you don't mind getting really technical, and can demonstrate that there are no more than 2^5 distinct values in your source data, then you could store them using five bits per character and thus achieve the requirement to store 60 characters in a 40 byte field. Of course, you will need to write a...

Technically you are in danger of losing precision or even value. Basically you can't. In the same way that you can't fit a 60cm waist into a 40cm waistband. Or 60 litres of fluid into a 40 litre container. So, what you have to do is to get guidance from the business on is which 40 of the 60 characte...

Might someone have restored from backup? Particularly if it was an ISX backup, that would not be recorded in DS_AUDIT.

Mod() is, of course, an INTEGER division function, as noted by Arnd and others.

Another solution would be to increase the arguments by powers of ten until they were integer-equivalents, then reduce back afterwards.

But why re-open this thread four years on?

Beat me to it! :D

Use a server Sequential File stage in a server Shared Container in a parallel job.

There are many rule sets, including for Argentina, Brazil, Chile, Mexico and Peru, in the Information Server file directory but not visible in the Designer palette. A full list of those is here. Rule sets for Japanese and Russian are available in version 8.7 and I believe there are new rule sets for...

It might just mean that your client machine is running out of memory. Try closing a few other windows and/or restarting the Designer client.

Does one of the header files which you ARE including (probably ints.h) contain a declaration to include the srstream header ?

Another technique is to use a Folder stage, either in a server job or in a server shared container in a parallel job. This functionality is innate to the Folder stage.