DSXchange

RCP does not cause problems, just inappropriate use of it may cause them. If you shorten the length to 250 in your job, does the control file contain the explicit lengths?

I just realized that I clipped off the last line of my post:

Terminology notwithstanding, that demo is impressive!

You are correct in that the Job Activity will issue a wait and not continue until the called job has finished. If you don't care how many instances are run concurrently, replace the Job Activity stage with a Command stage and build the command line for dsjob manually in the sequence, but don't add t...

Yes, it is possible in DS. How you implement it depends upon several factors. If the text file is simple, I would just use some UNIX command(s) to output the date in a single line and call that from a Command stage in a job sequence, then pass the returned values straight through to a job using a Jo...

Sounds like an abstract from a bad Sci-Fi movie I saw recently where the bad guys were worshiping the "UnderVerse". Or perhaps MetaVerse is a modern form of the iambic pentameter which uses a base 16 syllables :D

or use the MKS toolkit command "head -1123 {file} | tail -1"

You cannot use the method that I suggested using DataStage FTP since that attempts to parse the contents of each line, and since the format is now wrong it won't interpret the column contents correctly.

You have declared some character to be your column separator in your sequential file definition. Row 1123 has at least one less separator than the rows before it, i.e. one less column. You can change your column definitions to ignore that error - but it sounds like in your case you need to correct y...

You can lookup the use of the DSJobController code in Basic Programmer's Guide in the chapter on DSGetJobInfo(). It will tell you the DataStage job name that started the current one, and an exception handler is part of the current job (the sequence) so unless the sequence was started by another sequ...

Can you try to 'save as' another name and/or another category or does that generate the same error?

What happens if you don't use a filter and just get a list of all tables?

ds_is_fun - Now you have intrigued me, how does restarting DataStage reset which 'config files'? It just happens that the failure occurs on some node, then causes all the other processes to stop. If a fork() call cannot complete it is usually caused by some form of system overload - be it memory or ...

Also check to make sure that you have declared your hashed file as a DYNAMIC one, and/or ensured that the starting minimum modulo is sufficiently high in the case of a dynamic file or large enough to hold the expected data volume without overflowing too badly in the case of a static hashed file.

The lookup stage will return multiple rows, and there is an option to limit that to a single row.

"Wanna" is not an English word; but I'll guess you meant "want to know concurrent users". On a 32bit system with 1Gb - I'd guess 1.
This is like asking "how many people fit in a vehicle"? This starts at 1 on my bike and usually ends with 57 in a bus and ranges in between.