DSXchange

Research format strings, in particular how to accommodate elements that have a variable number of characters (for example your month and day components may have one or two digits).

Oh, the data MODEL is available. Just go to Model View in Metadata Workbench.

Are you referring to NULL (unknown value) here, or trailing NUL bytes (0x00)? If the latter, you can use the Convert() function to convert any occurrence of Char(0) to "". Or you can use the three-argument version of the Trim() function to trim just the trailing occurrence(s).

More detail? Not really. All sorting in DataStage parallel jobs uses the tsort operator. The Sort stage gives more options than input link sorting and than inserted tsort operators. The data have to come together (on the same server) to be processed by the stage. Correct partitioning will guarantee ...

XMETA is only the conventional name - it can be called whatever you like. My current site, for example, uses schema name suffixes to discriminate DEV, TEST and PROD. That's why I prefer to call it the metadata repository. As for your "isn't this an issue?" question, I can't see why, apart ...

I also don't believe there's any way to use an encypted password with IAAdmin command. Like you, I've noticed that the documentation is silent on the issue, but it's never worked for me. Robert's suggestion of securing the directory is a good one. You might also consider protecting the script via th...

1. Input link sorting is identical to Sort stage except that Sort stage gives more flexibility (for example allocation of memory to sort, generation of key change column). 2. Probably, since its input is sorted. There's nothing within the stage to change the sorted order of rows processed. However, ...

I'd probably use a server routine with DSJ.ME as the job handle argument. These can be invoked from user variables. The "value" of the Parameter Set (DSGetParamInfo() function) is the name of the values file, if one was used.

I'd be looking at the scheduling service exposed by the application server, to check whether its timezone environment variable (or explicit setting) is correct.

Then it appears that you will need to extract your design information from the common metadata repository.

The checkpoint mechanism keeps track of the iteration within a loop (skipping unneeded iterations on restart), so I would imagine it properly keeps track of the iteration within each loop when there are more than one. View the code (on the Job Control tab) to see how this is implemented, or look at ...

What happens if you?

All that said, I think you're going to end up needing a routine.

Can't see why not. What have you tried?

Almost definitely not. 64-bit hashed files use 64-bit internal pointers, so take up more space on disk. Otherwise the access mechanism is identical to that for 32-bit hashed files (possibly with more seek activity within the file, which would actually make performance worse).