DSXchange

Come along to the next Information on Demand conference. In the Certification Lounge (for certified people) they have massages available. Or at least they have had for the past three conferences, and it was both busy and populate, so I guess they'll keep it going. Ice creams are also available in th...

With the intermediate Sequential File stage that shouldn't have worked in 5.1 either, unless (for whatever reason) DataStage allocated the same process to execute T2 as it had used to execute T1. No way to check, alas, no longer have a 5.1 installation available.

That's correct. Get your dba to create a table/database with logging, rather than without logging. It shouldn't matter, but DataStage interprets the informational message returned by Informix as an alert, and does not permit processing to proceed. (There may be an environment variable you can set to...

I understood that everything was in T2, which would discount that argument. If my assumption is wrong, then I'm with Ken - COMMON is unique to one process - with an intermediate passive stage or with inter-process row buffering you force the active stages to run in separate processes, so the COMMON ...

Toss a coin. Either is OK (at least once you change "massage" to "message"!). Your design will need some stage to read the records (perhaps an MQ Series stage, perhaps a Sequential File stage) followed by XML Input stage. The XML Input stage, despite its name, does not read anything. It receives XML...

Job status while running will always be "Running". You don't need to look at anything.

Sure you could do it (for example by calling a routine from the Transformer stage). But it would suffice to create a stage variable initialized to the DS Constant DSJS.RUNNING.

Also have your admin check the credentials assigned to each user in Information Server.

Craig asks that question because, if you've been able to use the OCI stage (for example), it means that ORACLE_HOME and, possibly, other Oracle-related environment variables are apparently set up OK in the dsenv script (which also means that sqlldr should be able to be found, since it is usually in ...

Don't forget/neglect phase 2 - allocation of blame and re-education.

This environment variable could not have gotten into the User-defined folder by itself.

The largest permissible BigInt (int64) value is 9,223,372,036,854,775,807 (2^63-1) in a twos-complement machine. This has 19 digits. Therefore nineteen "9" characters is not a legal BigInt. You need to re-think your logic. Does this "rounding" happen only in View Data, or are you writing the result ...

If Status is empty then the row count will not be incremented, according to your logic. Add a debugging statement in the after-stage subroutine to report the values of the three COMMON variables immediately on entry.

In that case - except for when the Pope fiddled with the calendar - you could use a simple mapping from month number (and year number in the case of February) to number of days in the month. Iconv(TheDate, "DM") -----> svMonth Iconv(TheDate, "DY") -----> svYear &q...

Do you have a user called xmeta (probably as owner of the database instance) as well as a database instance called XMETA? I can't see why that user would have the Job folder locked, unless it were in the middle of doing some other task, but such a lock should only be held transiently. Have you invol...

Can you open any of the other DataStage clients? At which point in the logging-in sequence does this error occur? Do you have NLS enabled and, if so, what is the client-server mapping (as set in the Administrator client)?

DataStage does support real time. Sequential files with buffered writes don't. You could submit an enhancement request to allow for non-buffered writes or flush interval to be configurable - that technology exists even in DataStage BASIC.