DSXchange

Five containers, each with a different record format output.

Hey, these two posts look similar:

http://www.dsxchange.com/viewtopic.php?p=151889#151889

IBM told us to insert this line into our ds.rc file: ulimit -f unlimited It's a shame, because by default you are supposed to make sure you're ulimit is set to unlimited across the board. Your initial installation 'way back should have included making these adjustments at the same time you verified...

Why don't you just containerize the Server CFF stage and use in your PX job?

Or

Is there a problem using a Server job to just normalize the data into separate files and then have PX jobs pick it up from there?

Is this data your job generated? Or is this a file you are trying to configure to read?

Sure, you need to use an after-job or after-transformer routine to attach to the job and call the API to get the link statistics for your particular link. Now, if it's 0 or 42 or whatever number you like take whatever action you like. A 0 row count means NO ROWS go down the link, so there's NO ROW t...

Yep, buried in each project folder.

Omit uses the current user logged in for a trusted connection. Unix folks never have this problem because we always use the userid and password. It is such a pain on Windoze, don't you think?

There's 2 ways to start a job: use Director client or use dsjob command line. My guess is that they simply are using the dsjob command line interface to execute the commands to start a job. This isn't rocket science, some watchdog script waits for whatever mechanisms to tell it that it is time to st...

You could always stream the data to an output link using a function in the constraint that isn't really a constraint but a does a delete on the hash file from within the function. It's quite easy actually, just open the hash file on the first row passed and put into a COMMON file handle variable, th...

Unix command line, you can run anything. If the stored procedures are "do-something" procedures, this is the easiest method to use for invocation and error/return code handling. If the SP's are data streamers, then you can use the DB2 plugin to execute and receive the streaming results. If they're s...

The hash files are probably a perfect method for what you need to do. Slam your file into a hash file, then parse it at need, referencing rows when necessary, adding rows, updating exist, etc, dump it back to a sequential file.

What's the big deal?

Yes it's wandering, but I've got to be in the ballpark on that guess.

They're there, you just have to work a little to find them. We learn by doing....

DS.TOOLS from any project TCL prompt will get you this information. Do you want programmatic access? If so, READ it out of UV.ACCOUNT and parse, or use the DSExecute API to execute the TCL command to SELECT the file. You can always use the unix command line read to access the file from a shell script.