DSXchange

Do the non-failed activities have "do not checkpoint run" selected? This will cause them to be executed on every run of the sequence, irrespective of whether checkpointing is used in the sequence.

It's really annoying that the Ascential applications now seem to insist upon the Ascential-supplied ODBC drivers being used, and resist the use of other ODBC drivers even those that are ODBC 3.0 compliant. C'mon, guys, isn't ODBC a STANDARD?!! If you try to use the Ascential-supplied drivers from an...

DS_JOBS is a standard DataStage table, but does not contain job status. The DS_JOBS table records the job's type and category, and an internal number that DataStage uses to refer to the job in all other aspects. However, you get a job handle via a call to DSAttachJob(), you do not need to be aware t...

If you are using only generated SQL you should be fine. If you are using user-defined SQL, or relying on before-SQL or after-SQL scripts in the OCI stage, then that part of your design will probably require reworking. If you are using Oracle bulk loader (sqlldr) then obviously that part also will re...

All of the square bracketed fields at the beginning of the message demonstrate that the ODBC driver was, in fact, able to connect to SQL Server. At that point, "Login fails." indicates that your credentials were not correct. Check that they are correct in DataStage, check that that user exists in SQ...

A DataStage job log is a database table, not a file. You view it through the Director client. Otherwise you need to select rows from it using the DataStage API, or using SQL. The name of the table is RT_LOGnnn where nnn is the internal DataStage number for that job, which mapping can be found from D...

OK, here it is with eight (ignoring node pools and disk pools). With 24 scratch disks you have 3 times as many file systems involved. You can see here what I mean by "round robin allocation" of scratch disk resources. Only eight actual directories are used. { node node0 { fastname "my...

You need to differentiate three maps (encodings). ISO8859-6 is the UNIX server map for Arabic. MS1256 (or CP1256 on DOS) is the Windows server map for Arabic. MS1256-CS is the map for communicating with the Windows client (the "-CS" stands for "client/server"). As noted earlier, the problem may not ...

The technology will allow you to take a feed from a site such as XE.com to guarantee that your exchange rates are as up to date as possible.

Historical Geographical Note
UR is (was) an ancient Babylonian city. There is no such English word.

This is what the TMPDIR environment variable is set to - it goes there if your scratch space becomes full but it needs more scratch space. It may also go there for other reasons - I don't know what else your job or other UNIX processes may be doing.

What happens if the day number is greater than 9?

Yes, physical. Separate spindles.

Try searching (both here and Google) for "indexed sequential" and "ISAM" (indexed sequential access method). It's more of a mainframe than a server technology.

Does anyone have information on how to use the Oracle HHJLDATE function/procedure? With an example or two would be wonderful. This converts Gregorian to Hijrah ("Islamic") dates.