DSXchange

The database cannot update a record that does not exist.

Nagarjuna - what are you using that port for?

Ray, this is a PX installation and those ports are closed between client and server. Or do you mean runtime port usage on a single machine?

Since it is a timeout issue, the question as to how heavily the machine was loaded at the time the error occurred as opposed to the normal load arises.

It is possible to do, but you will need to use a transform stage and write explicit checks on each column since server jobs are not strictly typed as they are in PX jobs.

The TimestampFromSecondsSince function could be used to deliver you a time component based on a number of seconds (30 minutes has 1800 seconds).

I'm not sure if you intentionally entered "workaround" to this question. Your compiler is either incorrectly installed or incorrectly specified in the ADMIN settings for your project. Also, is that the correct compiler version for your DataStage?

This is a trial-and-error list. The site put in a firewall which blocked each and every port in the system unless explicitly enabled. These were the ones that I had to open for DataStage at V8.0.1. I don't have the list of exactly which portions use which ports, but I will see if I can find that as ...

If you stop the job and check the directory, is the fifo file still there? If so, delete it. Also, are you using BASIC stages in the PX job?

is masked initial capitals. I assume that is wha the Infa function does as well.

The 139 doesn't help much. Somewhere in the error message there will be a SQL code or other more specific message.

Collation probably doesn't apply, as it affect the sort order of characters, and not the representation. With NLS problems you will need to take problem analysis step by step. First just read some data from SQL server and output it to a flat file. Look at the flat file with a tool you know supports ...

My suspicion is that the answer is going to be "you can't". Specifically what kind of queries - SQL type subselects? DataStage will allow you to do certain joins and queries but SQL is limited to databases.

Is there any more to the error message, the Segmentation fault and abort message don't narrow down the issue at all. Also, does the new SELECT function correctly from your preferred tool?

What method was used to convert the date to a decimal value? Is the date stored as a YYYYMMDD or a YYYYDDD or a Julian date? Without knowing that, a conversion or comparison is not possible.