DSXchange

Ok, it turns out that I was getting the DEVICE number using LIST.READU on one machine, then trying to figure out the the Major,Minor devices from another machine! Once I went back and started checking my work I found the error and then the formula became obvious. For those interested: Device = "...

svarChanged = IF svarLastFieldB = In.FieldB THEN 0 ELSE 1
svarLastFieldB = In.FieldB
svarCounter = IF svarChanged THEN svarCounter = 1 ELSE svarCounter = svarCounter + 1



Derivation of Out.Value = svarCounter

Tirumal,

you need to supply more information and do some more diagnosis; it is impossible to guess what the cause might have been. Does this job use a database - if so, it could have been a lock & wait on the database.

Look at some of the jobs. The "stages" are few and straightforward. A sequencer job is the DataStage equivalent of a simple shell script or batch program.

That isn't too large a number, why not use that query, then do a hashed file lookup in a transform stage instead of copying the hashed file to a db table?

Yes, you could load the hashed file into a temporary table. That would entail moving less rows from the database to DataStage. How many rows get returned with just "select count(*) from nv where fund_dt < getdate();"

Try modifying the job which calls up the container (just moving a stage around should do the trick) then doing a save and compile.

Are the two projects identical? If so, take your successful export and import it into QA and then try the export again. The memory issue, if still present, is a bug and could be reported to your support provider along with the .dsx file so that they can reproduce and fix the problem. If the error is...

Yes, you can issue the UNIX "cp" commands while the system is running, it won't break anything.

The ICONV() and OCONV() functions are not available in PX jobs unless you have a BASIC transform stage. Is that the case? The base date for internal date format is 1967-12-31, that is 0 internally, so the previous day is -1 and the 29th is -2 and so on. What is your problem with these numbers? This ...

Can you name some specific functions that you feel need to written in c++? Perhaps if you do that others might be able to suggest alternatives.

Correct, the bulk of the post from me won't be visible as it is a premium post. The membership finances the site (the posters are all volunteers). But I would think that if you searched here you might find other suggestions that are not marked as premium.

If you don't need the log contents, just clear the complete log from the Director, that should do the trick. But you should find out why the log got corrupted. Either growing past the ~2Gb limit as miwinter suggested or perhaps if the file system filled up while that log was being written to.

Craig - I recall that the function LOCATE() doesn't work in server transforms, just the "LOCATE x IN y SETTING z" syntax.

I don't have access right now to DataStage to test out what you ask, perhaps someone else might know the answer.