DSXchange

SIGNIT doesn't exist, but SIGINT does. This is an unhandled UNIX interrupt and you would need to provide the actual error message in the logfile for anyone to be able to assist you.

You will need root access unless you installed with impersonation, in which case your datastage Administrator ID will be sufficient.

I you equate working days with weekdays then there are a number of functions in PX that will give you a number; but with both fixed holidays and complex moving ones (like Easter) you will need to use a solution that specifically flags dates as being workdays or not as Ken has already pointed out.

Can you try to use your favorite SQL tool (or MSQUERY in a pinch) and execute the insert statement as it was generated by hand to see if the error persists? You could also post this SQL here.

You have most likely done your own SQL and the number of parameters does not match the number of columns.

Often if the mainframe packed data doesn't seem to be correct the real reason is that the file is being converted from EBCDIC to ASCII and thereby corrupts the packed data. If that is the case you can convert those fields back using the DB EBCDIC function and then apply your SDK function.

Madhu, all timings are relative, so nobody here can tell you what to do or even if these values are good or bad.
What is your effective speed if you do only inserts? Is your database partitioned? Do you have multiple constraints?

I decided to follow Ken's suggestion and typed in "dsjob" at the command line. Lo and behold, I got the following output: Command Syntax: dsjob [-file <file> <server> | [-server <server>][-user <user>][-password <password>]] <primary command> [<arguments>] Valid primary command options are: -run -st...

Yes, the dsenv is used (required) in the server edition as well.

loveojha2 wrote:Open the RT_BP271 folder...

. That is correct, but the program that is causing the error in this case, "DSD.WriteLog", is a DS program and not found there.

ICE, let us take things just one step at a time. You stated ...Whenever I select that job from DS director or DS mgr,I got that error msg and the application was shutting down... Does that mean you click on the job and your Windows client session fails? If yes, does it happen when you try it from an...

Even though you haven't told us what you are using as a "Batch SID", I'll assume that loveojha2 gave the correct interpretation of what it might be. In that case, what is wrong with using his suggestion of implementing KeyMgtGetNextValue()?

What is a Batch SID? If you could explain that then perhaps someone might answer. Could it be a "Session ID"?

I'm a puTTY convert now as well.

prabu,

a hardcoded value will add that value for each row. If it doesn't then the error is elsewhere. Could you explain your job? Does your transform have constraints and what type of object are you writing to?