DSXchange

Lots of UNIX commands (for example cp, mv and so on) are silent if successful. "Silence is good."
If you want to guarantee output, add another command that isn't silent. For example

hi, I have a job, which has a transformer , sort and an aggregator. When i run the job for 200, 000 records , i only get 199233. It says the job is finished. Why i am not getting the rest of records. thanks shivan You expect to get fewer rows out of an Aggregator than went in. That's the whole poin...

What Arnd said. One interesting thing is that the DSX export file is transportable. Often the support center in Sydney (Australia) received DSX files from Japan, Korea, and so on. By simply changing the Character Set property in the DSX file's header, they could import onto an English DataStage syst...

SEEK statement is limited to addresses less than 2GB from beginning of file. That's because the two numeric arguments are implemented as int32. There's nothing you can do apart from put in an enhancement request to have SEEK changed to use int64. Or write your own C functions (which is what they've ...

So you've now set HOME in the dsenv file, yes?

Here's one of several ways. Run a job that captured SELECT MAX(SKcolumn) FROM table into a hashed file whose key is the table name and where the captured key value (presumably an Integer) is the only non-key field. Upcase the table name if you like. In the Transformer stage you want to initialize a ...

The failure to write to the hashed file is usually indicative of a permissions problem (in which case you can't write ANY record to the hashed file) or a corrupted group (page) within the hashed file. Usually you delete and re-create the hashed file on each run, so that the newly-created hashed file...

You can perform ANY legal SQL from a suitable passive stage type. The only extra thing you have to do is to make sure that your Columns grid contains the correct number of key and non-key columns so as to match what's specified (or implied) in the SQL. For example, parameter markers in WHERE clauses...

You may need to fiddle with your date picture. The default is %yyyy-%mm-%dd (with the delimiters). Try explicitly specifying %yyyy%mm%dd (without delimiters).

I would have to check that out. This week I'm on the road (as usual) at a server-only site. If it's possible I imagine you would find it in the Orchestrate manuals. Problem is, it may not have the same name.

If you use Administrator to delete the VERSION project, you must create its replacement with Administrator. The import process dscmdimport does not recreate VOC, VOCLIB, &SAVEDLISTS& or their dictionaries nor any of the DS_* hashed files that store design-time information. If you have any ve...

I don't see this. What version are you using?

Try a CAST in the Derivation of the column. For example

For the line terminations, get to the Columns grid in your Sequential File stage, and scroll to the right till you find "contains line terminators". Set this to "Yes".

You can capture the current maximum using a job, say into a hashed file keyed by table name. This needs you to be 100% confident that no other process will be updating the audit table. Otherwise use a database mechanism for generating the sequence_no, such as an Oracle sequence, or a serial (auto-in...

Or "Hawk".