DSXchange

Make a copy of the routine, and add more complete error handling to the Open and ReadU statements. Common /Sequences/ Initialized, NextVal, SeqFile EQUATE RoutineName TO 'KeyMgtGetNextValueConcurrent' If NOT(Initialized) Then * Not initialised. Attempt to open the file. Initialized = 1 Open ...

Can you please post the "job started" event from the job log (or status) view so that the actual value passed to the parameter may be recognized?

And, when you do, please verify that the SQL is both complete and as you intended.

What was the most recent prior good value? You may have experienced "arithmetic overflow". To determine the current "next available key" value for a given sequence execute the following query. SELECT NAME, F1 FMT '10R' COL.HDG "Next Value" FROM SDKSequences USING DICT VOC WHERE NAME = '<<S...

No, because I specified "the next available key", rather than the current max key value. implying that there would be a +1 in the SELECT statement.

And one can always re-parse the raw string using Column Import stage.

Prior to running the job, probably in another job, obtain the next available surrogate key value and write it to that other job's user status area or to a file. Pick up the value and pass it to the job containing the generator as a job parameter value. This will be the initial value to use in the ge...

The job type in this thread is marked as "server". In which Transformer stage can and does perform a left outer join.

Have O/S group memberships been changed?
Have the mapping of DataStage roles to O/S groups been changed (perhaps by ill-advised edits to/removal of the .developer.adm file in the project)?

I'd say leaving them in is a 'worst practice' because RCP will try to propagate them through to the target.

1. The job(s)/activities that need to run first are to be scheduled first.

2. Any that need the results of these must be scheduled afterwards, and perhaps conditionally upon the earlier job(s)/activities completing successfully.

3. Repeat step 2 until no more dependencies.

If you upgrade to version 8 you get a SCD stage that looks after all that for you.

1. No. 2. No. Any SQL to be run from the DOS command line would have to be run from a BAT file - DataStage BASIC does not create an "executable" in the operating system sense - all DataStage BASIC code executes within dssh. You can regard dssh as a virtual machine if you like. However, routines can ...

You have an incompletely-deleted job. Run DS.CHECKER when you have exclusive access to the project to clean up "orphaned" files from partially deleted jobs. After that your import should be OK.

What does this number represent for the Timestamp data type? Is it the number of characters, or the number of fractional second digits?

Right now the site is without a webmaster. Walter departed to pursue additional interests. The process has begun to hire a new webmaster.