DSXchange

Have you tried to FTP to your own host to see if that works correctly? Is your target also a Windows machine or a UNIX machine or something else? Are you doing a binary or an ASCII/EBCDIC transfer? The reason for these questions is that the FTP stage as such works as expected so we are most likely l...

That was quite easy, I wrote a simple job with one transform, but the macro in a stage variable, constraint and in a derivation. I then compiled the job and looked at the generated BASIC code for the transformer to see what the code generator had done.

The DataStagers team now has 4 members and is already ranked in cumulative team position #5,543 out of 8,555 teams after less than a week.

I'm sure I've seen tables with that many columns, so I don't think you've hit a hard limit; at least not a generally known one. Since your error is in the Transform is it likely that the reason lies in the processing you do instead of the number of columns. If your "view data" works then the transfo...

The deadlock daemon is a process called "dslockd". You most certainly did a kill -9 which killed the pid but left the lock in DataStage. I'll just comment that many threads warn about doing this. If your deadlock daemon is running then wait a couple of minutes and the lock will get released, the def...

Craig - I didn't see your post until after I responded... we did think along the same lines, though. PCL is short for "Procedure Call" which is a complete call - pushing the current environment onto the stack, doing the call-by-ref/call-by-value substitutions, loading the called procedure into theth...

Peter, you've found an interesting point. I wrote a test and analyzed it and found out that the DSJobStartDate macro gets converted to an internal variable lookup when used in a constraint or a derivation. But when it is assigned to a stage variable it will call a locally catalogued routine which is...

The DSUBINARY portion is a uuencoded representation of the routine's compiled object code (actually, it's pseudo-code meant to be interpreted by the DS engine at runtime).

The only table level locking is done with a bulk load (I think that takes an exclusive table lock) and that is a function of the load method, not datastage so you can't do anything about it at the DS level. Normal inserts/upserts can be run concurrently and will not exclusively lock each other out -...

Vijay, you cannot do this type of functionality directly from the sequence which starts the job. Since it is waiting for the job it called to finish it isn't able to simultaneously check for it running too long. I would have your sequence start two actions in parallel, your job and a Routine Activit...

What is your separator and are you using quoted strings? This really is a common type of error that is easy to fix but sometimes hard to locate. Look at your data from outside of DataStage and make sure of what your data really contains on line 1 (hmmm.. do you have column names?) Are the quotes bal...

You can get a job's last start time and status from places such as the dsjob command line or within a BASIC program. If the 10 minute time limit is exceeded then you can issue a STOP command to that job. The approach you take is dependant upon where you wish to implement this logic - outside of the ...

Jobs will get and hold certain locks; but I don't think that a metadata table definition gets locked by a job when it uses it. A normal kill signal is an interruptable one so that allows a process that gets this notification to cleanup up after itself. A kill -9 signal say "abort right now" and does...

Sumeet,

as loveojha2 has already suggested you need to reset your job and then look at the entry headed "from previous run" in the log file (this entry is created as part of the reset).

Hello Ranga, welcome to the forum! Unfortunately there is no public download from IBM or Ascential of any of the DataStage components. I think that you could try to contact your local Ascential/IBM representative and see about arranging a limited time-expired trial license but I don't know what the ...