DSXchange

You are setting the transaction size to 1000 with the update action of "insert new or update existing"?
Arent you getting any warning message that says, that the size is set to 1 ?

Get more space, especially if you are not using the same file system for your staging files. Keep purging your log files. You must be creating "in account" humongous hashed files. That might be the main culprit. Just get more space.

thatiprashant wrote:hi,

everytime the transaction of any of these products go thru it will create a respective code

prashant

Who creates those codes. Do you create them?
Well regardless, let them be there, pass them through a transformer and put the constraint not equal to those two codes.

IMHO, when you absolutely have to stop a job which is accessing a database, dont use the director, give your dba a call and ask him to kill that thread accessing the database. This will send a "connection lost" signal to datastage which will then abort right away. As Craig mentioned, at times, the c...

Does your id have the right priviledges to set the environment variables?

The bulk loader works on its own. It has a message file that it writes to. And it writes every step, even its commits. That file is very usefull if any problem occurs. The DS log doesnt help much has the only work it is doing is creating the command files to invoke DB2's load utility. As per the OP'...

A basic transformer in px, its like putting a corvette in a school zone. If you absolutely have to, only then use it. I think you are better off trying to go through vincent's blogs or doing a little bit more searching on this site.

Welcome Aboard Access the hashed file via universe stage as a universe file, provided it was created "in account", and run sql queries on it. If it was created outside the account, then use SETFILE to create a VOC entry and use that name to access the hashed file via the universe stage. That is much...

I suspect a "range conversion" would be fairly slick also. Oconv(InLink.TheColumn, "RA,M") Particularly if multiple ranges need to be tested. Oconv(InLink.TheColumn, "RA,M;V,W") I believe that the OCONV representation of the R code that i was talking about. Right...

'cat' will only display the contents of the file. If the file has the values concatenated together then yes it will, but thats in the unix world. Your on windows. I suggest coding all this in a basic routine. You code everything to get it in a way you want and then call the DSSendMail() function. Re...

O yes. Completely forgot that while using > and < operators on characters it implicitly changes them to its ascii. So there you go, my suggestion is already moot. Craig, look at the R code (Range function). You can specify the range, the lower bounds and upper bounds and the number of ranges. That m...

Go into the director and check the status of that job. A code -99 means that its not in a runnable state. Recompile it and try it again.

What other methods have you tried. If its a range, try changing it into ascii and checking that range.
For example, Alphabets are between 065 - 090 for Uppercase and 097 - 122 for lowercase. That would be much faster.

I just checked it today, to run from keyboard, open the job and press Ctrl+F5. See if that works.
A really strange problem

No, actually, i would have used the command stage myself. But since you were experiencing some problems with it, i suggested an alternative method.