DSXchange

The two most common causes are inactivity timeout and network failure between client and server machine. Inactivity timeout is easily addressed in Administrator client (set a long inactivity timeout, or "do not timeout"); alternatively don't be idle for longer than specified. You might also check th...

DBAs always say that. Grab the SQL from the ORAOCI8 (or ODBC) stage, and check whether it executes OK in PL/SQL (sqlplus). Is your query explicitly mentioning the column ROWID? If not, the problem is definitely somewhere in Oracle - if not in the table itself then perhaps in the query parser. What r...

It's an Oracle error, not a DataStage error.

Use the oerr command on the Oracle server host, or consult the Oracle error codes and messages manual, to decode -1410 (invalid ROWID) and get suggestions for remedying it.

Do u know the number is just a fictional number or is it true. Because it is 5 billion rows. Are u really sure you have that many number of rows in it? I haven't seen a table so big until now ? or am I reading it wrong. These numbers are perfectly possible in countries like India (where Nag is) or ...

A script for creating the SQL Server tables is provided. C:\Program Files\Ascential\DataStage\Documentation Tool\mssql.sql Create an ODBC data source from your client machine to point to the SQL Server database in which you create the tables. In the Documentation Assistant, before exporting, choose ...

It's probably a timeout on the CPI-C function CMSEND. Perhaps your SAP instance was very busy doing other things at the time. Check the SAP error logs to see whether any additional information is available.

Another possibility is that the hashed file has reached its 2GB limit, and you have not created it able to be larger (that is, with 64 bit internal pointers). When loading the hashed file, select only the columns that you will actually need in the job. This will mean a much smaller hashed file than ...

This is not, strictly speaking, a BCI problem, though it was discovered when your job has attempted to use a BCI function (behind an ODBC stage, for example). The problem is that the DataDirect driver indicated by your data source name could not be loaded by the ODBC driver manager. This may be beca...

My guess would be an incomplete server installation, but one which is lacking a piece that your job designs aren't using.
Contact your support provider for help in tracking this one down. It's quite a technical piece of diagnosis.

An existing hashed file, provided there is a VOC entry pointing to it, can be converted to 64-bit internal addressing with the following command.

STRONG ADVICE Don't enable the 64BIT_FILES configuration parameter. This sets ALL your hashed files to >2GB capability. You don't need it. The syntax for creating hashed files with >2GB capacity (that is, with 64-bit internal pointers) is to use the appropriate option: 64BIT with the CREATE.FILE or ...

Alas, no, you'll be delivering the five characters "@NULL" using this syntax. To construct a string that contains the null designator you must refer to is via the @NULL.STR system variable (this is the null designator, rather than NULL). And you must concatenate anything that's constant and anything...

Enable server side tracing. Start an Administrator client. Add a project. Exit that Administrator client. Stop server side tracing. Examine the trace file. Weep. It's non trivial. You have to: create an account that is an SQL schema copy all required tables from the template project grant appropriat...

Hi Ray, I didn't try your solution because, when you said use an UV table I thought I cannot because i am working on Oracle. When you say a UV table you mean UniVerse Table, right!. so, can I create a UV table in Oracle or in DataStage memory? I am sorry i have never worked on UV tables. Thanks Sm....

For all practical considerations, the overhead is negligible compared to the amount of work that PX will be doing actually processing your data. Don't feel constrained by the tiny overhead involved. Contrast the amount of learning and work that you'd have to do to implement the same rules using the ...