DSXchange

This is most likely due to the block size that is being used. In order to speed up execution, surrogate keys are generated in blocks instead of going to the file/database for each and every key. It is possible that holes can occur when the program is stopped where the rest of the keys in the block a...

Is the interview soon?

I think that the two job descriptions are pretty much the same and are interchangeable. "DataStage programmers" or "DataStage engineers" could also be added to that list. Generally "DataStage Architect" could be considered a different role. The architect works more on the big picture and design whil...

Use Google to search for "ASCII EBCDIC conversion" and you will get many hits, or look in the BASIC Job developer which also has a conversion table. Where are you doing your EBCDIC conversion? In some places you can explicitly modify this convsersion mapping (i.e. within DataStage). If you cannot co...

It is questions like this that make me wonder and that bother me. Is DSXchange considered to be a replacement for the help files, the documentation and other sources? 1. the DataStage manuals which are installed with each client installation contain many of references to environment variables. A qui...

The mainframe will use EBCDIC and the character0xBB is not defined. 0x1A in ASCII is defined as "SUB" Decimal 26 is 0x1A, the same as above. The EBCDIC hex value for "]" is 0x5A. Some 3270 emulators will display the character as "]", though. Unless you specify a conversion explicitly for this non-EB...

kollurianu wrote:How to know/identify what are PX equivalents...

the PX manuals exhaustively list the available functions, or you can use the PX drop-down lists within the transform stage.

As Craig has already pointed out, use the filter option in the sequential file stage. If your source file is "a.Z" then the filter option would read and the compressed file is read and uncompressed in memory to the DataStage job.

Sorry, I just realized I didn't pay attention to your first post. Are you 100% certain that you aren't using TSNO anywhere else in the stage? Perhaps custom update code, or before/after code? This is the only think I can think of at the moment.

Wolfgang - thanks! (I'm sitting about 2 metres from Udo at this very second!)

If you look at the job control code generated by a job sequence you can see where you could add one line per job activity stage call to fill a parameter with the job name being called. You cannot do this directly in a job sequence, but this code could be copied to a normal server job and inserted in...

Very roughly: - Code your subroutine in c++, compile and load it into a library - Create a new parallel subroutine from the manager and add the details on the parameters, name and location of the coded routine Note from the HELP Example parallel routines are supplied on the Client Installation CD in...

Thanks Wolfgang! I looked for that page earlier and didn't find it. I hadn't heard about 7.5.3 coming out

It looks like your job has no INSER_SQL parameter.

In which case you are using custom SQL that still contains TSNO