DSXchange

Not a strange problem but actually a known one related to Service Pack 2 on Windows XP. There's been a patch available to correct that on Ascential's eServices website for quite some time now.

Ah... Ray's own Kobayashi Maru.

Read the online help that installs with the product, specifically Chapter 2 which covers the Version Control "Methodology".

Actually, Dennis lets me take cuts.

Two different days, Sai.

The OCI stages are the native stages provided for accessing Oracle via DataStage. In my mind, ODBC is the 'stage of last resort' only to be used when you've got no other choice. All that's required to use OCI is an Oracle client installed on the DataStage server and some config tweaks in the dsenv f...

By default (and through the GUI) they are 32bit. You either have to create them by hand as 64bit or RESIZE them afterwards.

Search the forum for 64BIT and RESIZE to get the syntax.

If you are using the DB2 stage, you'll find that it can want Date/Timestamp fields in internal format, depending on how you've defined it in the stage.

What about it "isn't working"? How are you using your expression field and what kind of output are you seeing?

Curious what happens when you try something simple like:


in a derivation for various values?

No, the SIGKILL ( kill -9 ) is something that is either explicitly issued by a person or perhaps by a monitoring tool when it thinks Something Is Wrong. DataStage itself won't do this. Perhaps this "third party tool" you've mentioned? Or perhaps by an Admin who is not all that DataStage aware? I've ...

Which is why the script does a 'reset' instead.

Chuck, in your shoes I'd build a small test job and pass in a couple of fields with the values you are questioning and then interrogate them. See if they test as Null or Empty depending on how they look in the source file and how you set your options in the Sequential File stage. Then you will have ...

Not really sure what you are asking, Julie. If you are asking if there is some way, when returning a 'multi-row result set' from a reference lookup, to know how many rows each lookup returned, there isn't an automatic one that I'm aware of. I'm guessing you could do some custom sql in an additional ...

In other words, to do this from the operating system you need to examine all of the RT_LOGnnn directories in the Project directory where this happened, looking for the 'Big Ones'. A query against DS_JOBS will translate the job number into a job name.

Sounds like your job is locking itself out - is that what you meant by "waiting for resources"? And are you saying you have three output links all writing to the same Oracle table using three different ODBC stages - or do all three links go into a single ODBC stage? If you were using OCI stages (and...