DSXchange

Chulett - It has space aftre warn. It doesn't have one in what you posted, hence the suggestion. :? Can you post an accurate version of what you actually tried to run after the change Kim suggested so we can see what it was you ran? Give us real values rather than made up examples if you'd like peo...

What happens if you put in the space you are missing in front of "-warn"?

Can you copy/paste your new error message here? Is the truncation part working for you in addition to the inserts?

Rather than post onto the end of two somewhat related topics, you really should have started your own post and told us exactly what your issue is.

Not sure what you mean by "no resolution found"... the Local Fix section of the linked note contains the grants needed to resolve the problem, did they not correct it for you? Or does being on an AS400 somehow invalidate that solution?

When you set those properties, there's really no reason for you to be inserting any kind of sql statement - the stage should handle all that for you automagically. Why not just give it a try and see if that works or not? And then let us know, too.

Don't have any docs or DataStage in front of me at the moment... usually there is an Update Action akin to "Clear table then Insert" and in most cases that "clear" means truncate. Do you see any such thing in the stage?

Told you it wouldn't fix it. :wink: You have more of the same problem. Because everything is inside a single set of quotes, you are passing in a literal string of the variable's names rather than the actual substituted value. Like before, you need to change your string builds to concatenate the valu...

You'll need to explain what "not able to handle it" means as that is what you would use... if you are referring to $ReturnValue, that is.

I don't see how you get that error from the code you posted as your actual INSERT statement isn't getting into the command you are executing. This should get you closer although I doubt it will fix things: SQLCmd = 'sqlcmd -S NIBC1521 -U DBUser -P dbuser123 -q "' : InsertStmt : '"' I'm ass...

1. Whatever parameters / values need to be passed to your Java code.
2. Anywhere your user has access to.

Shruthi wrote:Yes. Step 3 is successful. Just found that this is not happening at all times.

Sorry? It is successful... sometimes?

But while loading to the target we are getting error as NULL cant be inserted in database. Date Columns are nullable clomn in target. You do realize these two statements are contradictory? If your target column was in fact nullable then the error noted would not be occurring. I would suggest you fi...

Why not just read the Java Pack Guide manual?

So, it's not that you want to "delete a hashed file" but rather you want to delete records from a hashed file, yes? As you've found, you can only do that for hashed files that have a VOC record pointer established for them and you get one of those in two ways: 1. An "account based&quo...