DSXchange

Link collector can be connected directly to a transformer only if you have interprocess buffering on. Otherwise you need a passive stage in between.

Wow great. I bet a lot of dsxians will be relieved by checking out this post. A lot of us were more than just curious in finding out the release dates. Thanks Ray.

Ok great. I bet you already have a script in place to do that. Just add small piece of code to check the line count and then drop the file.

What do you mean by "datastage drops the file". Do you mean creates it? If thats the case, then the file will be created regardless of the record count. If you mean something else then please clarify. You can check for number of lines in a file by wc -l command. If it returns 0 that means the file i...

Great, you can mark this post as "Resolved" then. Thanks.

And Dark side can get scary , right Craig ?

These are internal repository tables and not documented. Ray and others have worked very hard to get to the depths and provide us the gems, which you can get at a cost that is less than 14 cents a day. I say its pretty affordable.

I couldnt help laughing out loud
I especially like

ray.wurlod wrote:2) Kill the users

I didnt either. I answered his first query. Then when i came to this one i sensed it. Then when i saw a third one i didnt bother commenting.

As i said, the coding depends upon the type of zip it is
if its .tar then

if its .Z then

it its .gz then

These command(s) will go in the after job subroutine "ExecSh"

True. But they can certainly be called by DSX.
Refer thispost

Ok now i am confused. Is the routine not being called after the DS job finishes or it is being called and just not functioning as you want it to. If the former then check in the log file. What does it say about the after-job subroutine. If latter, then, i have a question. Did you try correcting the ...

Depending upon the what kind of zip it is (the extension, .tar, .Z or .gz) you will have to supply the proper command in the before job subroutine as KirtiKumar mentioned.

You have the commands messed up. This is the proper syntax (use of quotes)

You have initialized variable 'Error' and using another variable 'ErrorCode' in your If condition. ErrorCode has not been initialized, hence never zero, hence your problem.