DSXchange

If you have an e-mail-to-SMS gateway server running, you can do this (with mutt on Unix, for example): Message = "Job " : JobName : " is not in a runnable state!" Code = "echo " : Message : " | mutt <cellphone no>@<ip address>" Call DSExecute("UNIX",...

Did you use Manager (using menu Tools -> Register Plug-In...) to register the plug-in? It should be OK though if the plug-in was installed at initial DataStage installation.

In the lookup condition, try:
where DateField is your 10 character date field. This way it will look up in proper timestamp format, e.g. "2003-09-15 00:00:00.000" and not just "2003-09-15"

Howzit Denzil

When you say only one developer can access the data, is it one developer out of the bunch or the first one that accesses it?

Is the required dsdb2.dll file in your client's /engine/bin directory?

I'm just looking at the release documentation now. I'm very relieved to see there's no Spell Check stage in 7.5.

I think a spell check stage will be quite a cool idea... improve your data quality and all that.

?

Howzit Denzil I see in the readme for 7.5 that Enterprise Edition supports your fancy OCCURS DEPENDING ON CFF's... Enterprise Edition ~~~~~~~~~~~~~~~~~~ Complex Flat File Stage ----------------------- A new Parallel Complex Flat File stage has been added to read or write files that contain complex s...

I love being married to a beautiful woman. 8) Now I never have to stare at a PC on a Saturday night anymore. Oh hang on, I never did, except in the hard-core gamer days... Anyway, I downloaded all the UniVerse manuals from http://www-306.ibm.com/software/data/u2/pubs/library/96univ/ . That seems eno...

I ended up doing the above using a job. So I have a hash file now (Time_D_Keys) with only one column, which is a key (according to the imported DS UniVerse def.) BUT... I populate this hash file with a routine: FileNameOnDisk = "Time_D_Keys" open FileNameOnDisk to TimeDimHash else print 'E...

I create a hash file in UV: create.file Time_D_Keys 30 That works fine. Then I add a field in the dictionary: INSERT INTO DICT Time_D_Keys(@ID, F1, LOC, FORMAT) VALUES ('TimeKey', 'D', 1, '8L'); Also works fine. When I import the UV file definition into DS, I get two fields, AT.ID (@ID) and TimeKey....

In that case, perhaps you may want to use more than one transformer. It will make your life easier and the life of whoever has to maintain the job in future. Pass the first transformer's two outputs, from constraints: level3.NOTFOUND and level4.NOTFOUND or Not(level3.NOTFOUND) and Not(level4.NOTFOUN...

An auto-purge comes in really handy to prevent such super-long logs. Craig's already mentioned it, but anyway...

In Director's Status View, with the job in question selected:

Job --> Clear Log... --> Auto-purge --> Enabled for this job

Set it up and voila! :D

If you're still battling, how about trying to use a char(32) instead of " " to do the lookup? Or seq(" ") and lookup on an ASCII code 32?

A project cleanup will delete unreferenced files, etc. but will not clear log files. Faeez, if it happens again, why not check your running processes and CPU/memory resources before restarting either the DataStage server process or the machine itself? I had a case once - it wasn't a DataStage projec...

Virtual machine software like VMWare is pretty powerful, yet quite easy to work with. These fancy things aren't the minefields they used to be. Another nice thing is that one can share resources (such as files and databases of course! :) ) between virtual machines, making it easy to test the same th...

You may not be able to, because of the NT services that make up the DataStage server.

How about trying to install DS 5.2 and 7.1 on two seperate virtual machines? You can download VMWare Workstation and see if that works for you.