DSXchange

You put in your 'static' filename and then specify the Trigger Column attribute there as well. Every time the value in that column changes, you get a new file with an increasing number appended to it.

Thank gawd! You're having the problem in the FTP stage, I assume? I hate the stoopid thing and tend to avoid it like walking the plank, so can't say I've tried changing the delimiter there. One thing I have done is, if you already have the file built and simply want to transfer it as is with a minim...

Nothing wrong with either size, though they do seem small. Had to hit the road, but yes the next suggestion is to pursue the 'split the jobs' suggestion and see if that changes the behaviour. Land the file in the first job to a flat file and then load from there.

</sarcasm off>

Hard to help if you have a DBA that's just going to play that card. [sigh]

The ASCII value for a tab would be 009, not 9.

The procedure didn't compile. What else are you expecting to be told?

The following code is of a routine : ***************Routine Start*************** Ans = "" VAL = "" IF PREMIUM_CATEGORY = "4" THEN VAL = "SY" END IF PREMIUM_CATEGORY = "3" THEN VAL = "MA" END IF PREMIUM_CATEGORY = "2" THEN VAL = &...

That sounds... odd. Are you sure?

Have your DBA upgrade the client. That's a pretty major mismatch, and the .1 client is a known buggy as heck version.

What 'bat file' would that be, exactly?

No, not that I am aware of.

Have you had your DBA monitor it during the job?

First off, I'd be curious why you feel you would need to compile anything from the 'command line' and if that command line would be on the client or the server machine. Anywho, do a search for dscc and all shall be revealed.

Post in one forum, please. Repeating it won't get you any better answers.

ps. Answered in this post.

Welcome aboard. I did an 'all terms' search for 'dsjob java api' and got a handful of hits, including this one:

http://www.dsxchange.com/viewtopic.php?t=91114

See if it or any of the others it brings up helps.