DSXchange

I just wrote a sample job; rowgen -> external filter -> peek. I generate 10 rows with one column with two values, "100" or "101". I declared a grep with a parameter of "100" (no quotes) and the peek stage shows 5 rows. No problem.

with respect to (1) I meant that it doesn't include the repository itself, which isn't that small anymore but at least doesn't grow in size much. (2) No, PX jobs store their dataset data in the location(s) specified in the APT_CONFIG file(s), so determining how much space is used requires looking th...

How do you define the 1st line in your file? Is it terminated by EBCDIC <cr> or is it fixed length? Unless you know that information you won't be able to do anything with the file.

What happens when you rename your source file column from "DATA" to "count"?

The public disk caching is a DataStage engine level setting and can be enabled per hashed file and is independant of which methods are used to read/write to the files. So it will work from BASIC code just as it does in jobs. I just took a quick check and it seems that the "dsdskche.pdf" document is ...

I think you should wait for the truss/strace to get installed. If you don't have a busy system, you could also get and post the results of the commands "PORT.STATUS" and "LIST.READU EVERY" from the TCL prompt.

Use another Data type. It seems that at V8 you can write CLOBs and BLOBs to Oracle using the enterprise edition, but you still cannot read them.

This means you have an error elsewhere. I've just written a small test job using CFF at V8 with just one PIC S9(3) column and set the default to both "0" and "123"; then created a test file with 3 lines, "aa", "bb" and "cc" terminated with UNIX newline. When I run the job I get no errors and either ...

Thanks for kind words! (although I'm not quite sure what "silence in answering" means and if that is a good thing or not)

This probably happens because the record with the error is outside of the scope or range of records shown with "view data" - did you look at all partitions and up to record 801?

It is hard to come up with a general rule (i.e. if the rightmost nibble is 0x00 you have a null field), but in this example I would make this column (whatever stealth name it might have) be NULLable and have a default value of null. I don't know why you are getting the error in your first post, thou...

Cobol COMP-3 columns are BCD (binary coded decimal) and the value of 0x00 0x00 is not valid since the last 4 bits are used for the sign, which is 0xC, 0xD or 0xF (for positive, negative or unsigned)

Most of the disk space used in Server jobs is in the project directory. You can put hashed files anywhere you wish on disk, though; so unless you don't use nonlocal hashed files or have specific places where these reside it is going to be difficult to know exactly how much space is used in server jo...

That's the document. I can't recall the exact numbers, but the maximum amount of memory useable for the cache is initially small but can be expanded. There are a couple of "gotchas" with caching and I've managed to get the DS instance so confused that not a single r/w operation worked until we reboo...

ag_ram: You don't seem to get the point I am making You backup the DS_JOBOBJECTS as you've described, then decide to restore your job a half day later, after your 10 colleagues have spent time modifying their jobs. You use the complex methods you have explained earlier in this thread to identify the...